Skip to content

Instantly share code, notes, and snippets.

View Haaroon's full-sized avatar

Haaroon Y Haaroon

42 followers · 79 following
View GitHub Profile
@Haaroon
Haaroon / ethereum_transactions.csv
Created December 27, 2021 12:12
raw example ethereum transactions in csv format extracted using ethereum etl
We can't make this file beautiful and searchable because it's too large.
hash,nonce,block_hash,block_number,transaction_index,from_address,to_address,value,gas,gas_price,input,block_timestamp,max_fee_per_gas,max_priority_fee_per_gas,transaction_type
0xb9de00ac9236c20d136743c3d0bac5fd2801de0c25f230df1ccaf581579f3d1f,30677,0x70c1bfd672b30b981001ce390bf475ae26c64a875a39ec8b0516695c96f41aa0,13200000,0,0xc4a675c5041e9687768ce154554d6cddd2540712,0xa57bd00134b2850b2a1c55860c9e9ea100fdd6cf,0,1000000,85143555099,0x1cff79cd000000000000000000000000acba996e2459509996833ea42b4c8b98f831c16f00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000184befb07a70000000000000000000000008df51a9714ae6357a5b829cc8d677b43d7e8bd53000000000000000000000000514910771af9ca656af840dff83e8264ecf986ca0000000000000000000000001f573d6fb3f13d689ff844b4ce37794d79a7ff1c00000000000000000000000056178a0d5f301baf6cf3e1cd53d9863437345bf900000000000000000000000004d0231162b4784b706908c787ce32bd075db9b70000000000000000000000000000000000000000000000056bc75e2d63
@Haaroon
Haaroon / ethereum_transaction.csv
Created December 27, 2021 12:02
example of ethereum transactions in csv format taken using ethereul etl
We can't make this file beautiful and searchable because it's too large.
,hash,nonce,block_hash,block_number,transaction_index,from_address,to_address,value,gas,gas_price,block_timestamp,max_fee_per_gas,max_priority_fee_per_gas,transaction_type
0,0x5c504ed432cb51138bcf09aa5e8a410dd4a1e204ef84bfed1be16dfba1b22060,0,0x4e3a3754410177e6937ef1f84bba68ea139e8d1a2258c5f85db9f1cd715a1bdd,46147,0,0xa1e4380a3b1f749673e270229993ee55f35663b4,0x5df9b87991262f6ba471f09758cde1c0fc1de734,31337.0,21000,50000000000000,1438918233,,,0
1,0x19f1df2c7ee6b464720ad28e903aeda1a5ad8780afc22f0b960827bd4fcf656d,0,0x5793f91c9fa8f824d8ed77fc1687dddcf334da81c68be65a782a36463b6f7998,46169,0,0xbd08e0cddec097db7901ea819a3d1fd9de8951a2,0x5c12a8e43faf884521c2454f39560e6c265a68c8,1.99e+19,21000,909808707606,1438918613,,,0
2,0x9e6e19637bb625a8ff3d052b7c2fe57dc78c55a15d258d77c43d5a9c160b0384,0,0xf4a537e8e2233149929a9b6964c9aced6ee95f42131aa6b648d2c7946dfc6fe2,46170,0,0x63ac545c991243fa18aec41d4f6f598e555015dc,0xc93f2250589a6563f5359051c1ea25746549f0d8,5.999895e+20,21000,500000000000,1438918630,,,0
3,0xcb9378977089c773c0
@Haaroon
Haaroon / command.txt
Created November 2, 2021 10:17
sbt assembly without tests
// sbt assembly without tests
sbt “set test in assembly := {}” assembly
@Haaroon
Haaroon / gist:7e637d63c0d5737c2f8b986fda511d7a
Created November 1, 2021 19:40
Wireguard Android TV how to allow remote control apps
First ADB into android tv
then
> adb shell
> am start -n com.wireguard.android/com.wireguard.android.activity.MainActivity
Then you can use your remote to allow remote control apps
@Haaroon
Haaroon / Readme.txt
Last active October 11, 2021 10:41
How to export Outlook calendars OLM into Office 365 / Google / etc.
this process works on a macbook, but it will also work on another machine if you can find similar tools
This exports all outlook calendar events into individual .ics files, then using another tool we merge the many files into a single one to allow us to easily import it to any destination such as Office 365, Google etc.
If you have an OLM file, go to Step 1, then otherwise go to step 3
1. First export your outlook calendar into an OLM file
2. Next Reimport this into your PC, this will import the calendar as a calendar "on my computer"
3. Use this script to export all calendars to ICS https://gist.github.com/talkingmoose/f3a21b2c1ba26ade658d
4. Use this program to merge them into one, make sure there is no sapce in the file path https://github.com/hellopablo/ics-merger
5. Then drag the single .ics file into the calendar of your choice in your outlook app, this will sync the entries into the server. Note that it may loose the "invite sent by" part of the calendar entry. (Using the outlook web impor
@Haaroon
Haaroon / coffee.scala
Created August 13, 2021 11:42
Scala Future coffee code from Neophyte
def prepareCappuccino(): Future[Cappuccino] = {
val groundCoffee = grind("arabica beans")
val heatedWater = heatWater(Water(20))
val frothedMilk = frothMilk("milk")
for {
ground <- groundCoffee
water <- heatedWater
foam <- frothedMilk
espresso <- brew(ground, water)
} yield combine(espresso, foam)
@Haaroon
Haaroon / Latex command to shorten cryptocurrency address
Created January 30, 2021 19:58
\usepackage{xstring}
\usepackage{hyperref}
\newcommand{\ethaddr}[1]{\textcolor{blue}{\href{https://etherscan.io/address/#1}{\StrLeft{#1}{5}...\StrRight{#1}{5}}}}
@Haaroon
Haaroon / scala for the impatient excercise 6
Created December 30, 2020 16:23
// 1. Write an object Conversions with methods inchesToCentimeters, gallonsToLiters, and milesToKilometers.
object Conversions {
def inchesToCentimeters(value: Double)={
// 1 inch = 2.54
value * 2.54
}
def gallonsToLiters(value: Double)={
// 1 gallon = 3.78541 liters
value * 3.78541
@Haaroon
Haaroon / scala for the impatient excercise 5
Created December 30, 2020 15:11
// ex1
class Counter {
private var value = 0
def increment() {
if (value != Int.MaxValue)
value += 1
}
}
// ex2
@Haaroon
Haaroon / scala for the impatient excercise 4
Created December 29, 2020 20:53
// ex 2
val in = new java.util.Scanner(new java.io.File("example.txt"))
val words = scala.collection.mutable.Map[String, Int]()
while (in.hasNext()) {
val word = in.next().replaceAll("\\W", "")
val c = words.getOrElse(word, 0) + 1
words(word) = c
}
for((k,v) <- words) println(k +" : "+ v)