50 rows yesterday at 3:46 PM
| # | to | total_gas |
|---|---|---|
| 0 | 0x4bba9b6b49f3dfa6615f079e9d66b0aa68b04a4d | 1337.073343706 |
| 1 | 0x06450dee7fd2fb8e39061434babcfc05599a6fb8 | 680.584034378 |
| 2 | 0x0de8bf93da2f7eecb3d9169422413a9bef4ef628 | 256.051002099 |
| 3 | 0x0a252663dbcc0b073063d6420a40319e438cfa59 | 229.587865227 |
| 4 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 208.863767448 |
| 5 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 94.592241406 |
| 6 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 79.047049732 |
| 7 | 0x43506849d7c04f9138d1a2050bbf3a0c054402dd | 77.128465981 |
| 8 | 0x3ccb891089d53e2faaf0decde04b41c3fce1a107 | 42.601828862 |
| 9 | 0x394e30d83d020469a1f8b16e89d7fd5fdb1935b0 | 41.641898504 |
| 10 | 0x06a9ab27c7e2255df1815e6cc0168d7755feb19a | 34.641754469 |
| 11 | 0xe7c4b445d3c7c8e4d68afb85a068f9faa18e9a5b | 34.092591037 |
| 12 | 0x25665943874b6c4499562835b398eeee63bbc45f | 20.596501982 |
| 13 | 0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad | 17.307775971 |
| 14 | 0x7a250d5630b4cf539739df2c5dacb4c659f2488d | 14.281606884 |
| 15 | 0xf2519e127e983cf996ee085fd1bf8a2fc9001287 | 12.03197482 |
| 16 | 0x54c97c29021a12cacb31f8388b32dd5486083f7b | 11.843327285 |
| 17 | 0xb8ffc3cd6e7cf5a098a1c92f48009765b24088dc | 10.982568757 |
| 18 | 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 | 10.86309573 |
| 19 | 0x2b33cf282f867a7ff693a66e11b0fcc5552e4425 | 10.732236027 |
| 20 | 0x4d0528598f916fd1d8dc80e5f54a8feedcfd4b18 | 10.545388646 |
| 21 | 0x17144556fd3424edc8fc8a4c940b2d04936d17eb | 10.53804725 |
| 22 | 0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb | 9.773867529 |
| 23 | 0x000000000000aaeb6d7670e522a718067333cd4e | 8.272076062 |
| 24 | 0x6b175474e89094c44da98b954eedeac495271d0f | 7.992650567 |
| 25 | 0x1bc8f124e7e320c71a6394de0458e8d7ea27623e | 7.594711266 |
| 26 | 0xe56333c2aedfeb4fbd5b7a4dbedc1b0f99e15abd | 7.168352359 |
| 27 | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 6.866531152 |
| 28 | 0x4c9edd5852cd905f086c759e8383e09bff1e68b3 | 6.404784365 |
| 29 | 0xdee6cdd28da9f51e3a8421395973894a884f3b2d | 6.306954892 |
| 30 | 0x000000000022d473030f116ddee9f6b43ac78ba3 | 6.212118485 |
| 31 | 0x3451b6b219478037a1ac572706627fc2bda1e812 | 5.819228345 |
| 32 | 0x5f4ec3df9cbd43714fe2740f5e3616155c5b8419 | 5.462411137 |
| 33 | 0x7d4e742018fb52e48b08be73d041c18b21de6fb5 | 5.455544972 |
| 34 | 0xf18056bbd320e96a48e3fbf8bc061322531aac99 | 5.416763291 |
| 35 | 0xe5d50a0500b9e791b60e30b62ee90bce56f47579 | 5.185315353 |
| 36 | 0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2 | 5.03066408 |
| 37 | 0xe583bcde0160b637330b27a3ea1f3c02ba2ec460 | 4.960072394 |
| 38 | 0xef434e4573b90b6ecd4a00f4888381e4d0cc5ccd | 4.935438166 |
| 39 | 0x10692b1c144ef98904335e40ce857369d19b8333 | 4.910909687 |
| 40 | 0x7effd7b47bfd17e52fb7559d3f924201b9dbff3d | 4.904034582 |
| 41 | 0x947cb49334e6571ccbfef1f1f1178d8469d65ec7 | 4.800711972 |
| 42 | 0xc4441c2be5d8fa8126822b9929ca0b81ea0de38e | 4.749142223 |
| 43 | 0x3abe33f1995109d7cf5c89dac472ab003bfc44a8 | 4.724349006 |
| 44 | 0x73a15fed60bf67631dc6cd7bc5b6e8da8190acf5 | 4.715622472 |
| 45 | 0x2b65f9d2e4b84a2df6ff0525741b75d1276a9c2f | 4.624897683 |
| 46 | 0xae12f6f805842e6dafe71a6d2b41b28ba5fc821e | 4.624012303 |
| 47 | 0x9d39a5de30e57443bff2a8307a4256c8797a3497 | 4.507750703 |
| 48 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 4.474711784 |
| 49 | 0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640 | 4.330663014 |
1
2
3
4
5
6
7
8
select
to,
sum(gas) / 1e9 as total_gas
from evm_calls_ethereum_mainnet_v1
where timestamp >= now() - interval 1 day
group by to
order by total_gas desc
limit 50