Skip to content

Instantly share code, notes, and snippets.

@metachris
Created September 15, 2023 07:42
Show Gist options
  • Save metachris/d3c064e0680e3b8a86c88159c684aa37 to your computer and use it in GitHub Desktop.
Save metachris/d3c064e0680e3b8a86c88159c684aa37 to your computer and use it in GitHub Desktop.
Mempool Dumpster - Daily CSV Example
timestamp_ms hash chain_id from to value nonce gas gas_price gas_tip_cap gas_fee_cap data_size data_4bytes sources
1694649600006 0x2ad8820a830823591349a7382a9fb48e5cfbb3e5abcbcc1cd43fa4c775908338 1 0x9e4a3c9b2c8f2cb15bea04a5af1e5c3f09e6516e 0xff836a5821e69066c87e268bc51b849fab94240c 0 16 200000 12537846537 12537846537 12537846537 68 0x095ea7b3 bloxroute local chainbound eden infura apool
1694649600082 0xaf2fe34380c3ccf288cb34bcecfa07fb964c1d1e4277bdb7ca132f484e36cfe8 1 0x5f3f6fc9f0979067f457fe00912960977f5d0f3b 0x1715a3e4a142d8b698131108995174f37aeba10d 0 40 232220 15521385218 100000000 15521385218 100 0xad58bdd1 chainbound bloxroute eden local infura apool
1694649600149 0xfac66aab169ef3a9569860661c5c64ca1a1628b42b1758675e5039bad099f56b 1 0x55ced56727840a74f9342bfbcbc6840ab201ac58 0xe90d8981fe90f5fd40713731a9abfe0b9e85fbc9 14162047157759459 1 21000 275000000 110000000 275000000 0 local apool infura bloxroute
1694649600160 0x67b532186f7a6313b5a68c0909e76ae65bac670126fbcc17f78eea85a08f38d4 1 0x3caa589cb2341d0f600711cc845257d277eb220a 0x777777776ae22446a6d46b2fec86088ad553c0e1 777 1 21000 138955833 138955833 138955833 0 local infura apool
1694649600164 0xa7042cce011ad869b4d947ef90bd04c21ae052301c2a2d278f7883e9829b5d72 1 0xe099d2629f45775f453b32fc13f81e90ff1c9c9a 0x00000000eddb52aaa642c5ce030a0405f4db2a87 0 10 21000 230216799 230216799 230216799 0 local infura apool
1694649600244 0xd009c4840eb95de3430368ee709b45786e6bac41112bb26ad5fc56c65ca70b47 1 0x0d7f4c7d5c1c89e07b910d74ed9b524f4d49bf29 0xa0c68c638235ee32657e8f720a23cec1bfc77c77 1200000000000000 0 141736 1000000000 1000000000 1000000000 36 0x4faa8a26 local infura apool bloxroute
1694649600300 0x779e00923967fe54fda2e9bf3d264d652a2dc109d81c6f6e5629afb4d2c87f79 1 0x0d7f4c7d5c1c89e07b910d74ed9b524f4d49bf29 0xa0c68c638235ee32657e8f720a23cec1bfc77c77 1200000000000000 1 141736 1500000000 1500000000 1500000000 36 0x4faa8a26 local infura apool bloxroute
1694649600329 0x943e97f7f4198f251238fadac012e9cab47fecfe9b4b3827aec9d45f0c4843ab 1 0xd8aa8f3be2fb0c790d3579dcf68a04701c1e33db 0x63c856b816dcfa22fa403d8f62e0517db6f3a891 0 354042 2800000 18126312215 1000000000 18126312215 4 0x98e5b12a bloxroute chainbound eden local infura apool
1694649600368 0x1241dce03a70bbd23cd2d92f4422aedd25a3e459ae6eaa2656dc6900c57cbb7c 1 0xd8aa8f3be2fb0c790d3579dcf68a04701c1e33db 0x2659dbe2d2e6f88063027af4eec9d1d1b2fc9789 0 354043 2800000 18126312215 1000000000 18126312215 4 0x98e5b12a bloxroute chainbound local eden apool infura
1694649600387 0x2a5a553464dbe7dacc496ca8c57807de18d66c5e104d5a2152b1fe96278ee3d2 1 0x2abc22eb9a09ebbe7b41737ccde147f586efeb6a 0x2ecbe0b77b7fe0442c6eb7a129106c4a129337bd 978800000000000000 101126 90000 20506026800 2200000000 20506026800 0 bloxroute chainbound eden local infura apool
1694649600415 0xd581a0e48e62b4fe68943e1965210edd390f13800aeae1eb117eb42c495c6854 1 0xcac0f1a06d3f02397cfb6d7077321d73b504916e 0x7776607e2e0bd61052e60d59f1fdd11dfbec27e8 45298747728466281285 470 108177 19037808605 3000000000 19037808605 452 0xb9e9a5ef chainbound bloxroute eden local infura apool
1694649600433 0x348a901010c944fcab9e7592b21d07119405da8d84d93230f26e8ada62713713 1 0xd8aa8f3be2fb0c790d3579dcf68a04701c1e33db 0x0ed1bcc400acd34593451e76f854992198995f52 0 354044 2800000 18126312215 1000000000 18126312215 4 0x98e5b12a bloxroute chainbound eden local apool infura
1694649600450 0x5420a41f3ac7da719e8def947da99c566d3fb887a6f9057a3e2c12f190afa650 1 0xe675ae2540ea12ae8872527d0c4b7427954fefbf 0xe675ae2540ea12ae8872527d0c4b7427954fefbf 0 3 311154 3000000000 2200000000 3000000000 0 local apool infura
1694649600459 0xcb225f0851fe5cf16846c6897a98fb51a6fd50cc54632cef9167dcdcc2f26631 1 0xd80f0cac04f670524004124564aa6d3a76f49434 0xffffeed14c6c4c3cfb897526fa4a23b2f862833b 0 200 72657 12475532051 100000000 12475532051 484 0x84ca1dd1 chainbound bloxroute eden local infura apool
1694649600482 0xc74d536847e0bff0fc9436a6a33be830e5caabe8d719392c146567f2887d6e21 1 0x7dcb39fe010a205f16ee3249f04b24d74c4f44f1 0xf1eb010ad9b6ec7d9623033325025b38f85e14dc 500000000000000000 3653 21000 15269334831 100000000 15269334831 0 bloxroute chainbound infura apool eden local
1694649600574 0x9acc3744da05677cf6ae50fb424a4dc93c8e94de2ba066d966fe1d0565faaffb 1 0xa92c09c197ca8cb759e3f8daa8367f9543753e23 0xa5409ec958c83c3f309868babaca7c86dcb077c1 0 1 50000 1000000000 1000000000 1000000000 4 0xddd81f82 infura bloxroute local
1694649600590 0x5db38c8c63456e84a0957f76e8ef89bc3e62e38fe90e5f3d2b446384717edd6c 1 0xcc4441465c9e6b9aa67641a5a6f79b79e3f215c0 0x7a250d5630b4cf539739df2c5dacb4c659f2488d 50000000000000000 0 212832 15269334831 100000000 15269334831 228 0x7ff36ab5 chainbound bloxroute eden local infura apool
1694649600600 0x09ec56414462c3980772999e0d27fa0a79dcb667a156e1a1532ed0f5eaa672f3 1 0x5e0d187d3bbc924f3aca8334117f9f8324f99a43 0xf03ea2b020fd8760f398242852f6198b29ace827 13346625207727574 1 21000 15269334831 100000000 15269334831 0 chainbound bloxroute eden local apool infura
1694649600653 0xbf6b6a8f6a9b0ee97c059e54f56e45dd7c5b58c325f408d7f4f957e77f87611d 1 0x8d73b6d6c66c1cbf51bf8b8748d07f8be2618253 0x61d5822dd7b3ed495108733e6550d4529480c8f6 0 8 56368 3000000000 3000000000 3000000000 68 0x095ea7b3 infura local apool
1694649600708 0x55ac82ba2abf540b83c9caea6de68b794415ec4709fd0df8ab4d33ee977ecb7a 1 0xfa8d78fb977101aa337786271a8c011e58f60774 0x8d796746f2d30c0e1487ac8cf5568f8b49d56417 226335000000000 2 21000 32000000000 32000000000 32000000000 0 apool
1694649600751 0x2075cf0a833fec455b99ad9f237baa9ecd3706bf6118c7cbe50634041c8e5341 1 0x8129b737912e17212c8693b781928f5d0303390a 0x0d62bac5c346c78dc1b27107cabc5f4de057a830 0 340976 5000000 150000000000 1500000000 150000000000 12868 0x3fe317a6 bloxroute chainbound local eden apool infura
1694649600775 0x6ced27d8c1f5fd4559745565e40040d2bbacaa4ce462894af443d5e5ac95b65c 1 0x47ec53d37e81bf237949084acd5c0f3d27a1d4d7 0x663a5c229c09b049e36dcc11a9b0d4a8eb9db214 100000000000000000 5 403942 14853298771 100000000 14853298771 196 0x8af416f6 chainbound bloxroute eden local apool infura
1694649600803 0x96ff0516043e7d134d6fd949bea2a63e2385b024e799231005095d2de6f9cae0 1 0x8129b737912e17212c8693b781928f5d0303390a 0x0d62bac5c346c78dc1b27107cabc5f4de057a830 0 340977 5000000 150000000000 1500000000 150000000000 12868 0x3fe317a6 chainbound eden bloxroute local apool infura
1694649601026 0xec73bba3f50a8342848c1c1e30627ad5dfd56f4aed413ef00b54d853b72e8ab0 1 0x31bf1c429dd43688b874198944c46e40686baafa 0x4e5b2e1dc63f6b91cb6cd759936495434c7e972f 2050436000000000 1 21000 14000000000 14000000000 14000000000 0 bloxroute chainbound eden local infura apool
1694649601098 0x809d7b83cdeae9699497dbbc0a419a44b7978c69a8503de56444476f59d9afc0 1 0x0c7cb2ff04f43a38d54de62712e5e11757fba54f 0x695afdb42edff97af470a15920a66df81a234c0e 0 570 35097 22383744806 1000000000 22383744806 68 0xa9059cbb chainbound bloxroute eden local apool infura
1694649601115 0x63753294b7c857479fd999bddb80acd2844c5484d58c2d752df8b74a4948b5bc 1 0xbbda162f1e3ec2d4d9d99cafd0c14b03ec4e78d3 0x5fdcca53617f4d2b9134b29090c87d01058e27e9 0 453 5000000 20000000000 20000000000 20000000000 68 0x441a3e70 bloxroute chainbound local eden infura apool
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment