FROM_ADDRESS | TX_COUNT | ADDRESS_COUNT | TRANSFER_VALUE | |
---|---|---|---|---|
1 | 0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d83 | 428342 | 31314 | 2761717.89 |
2 | 0x77a6ab7dc9096e7a311eb9bb4791494460f53c82 | 131114 | 116249 | 782231.16262789 |
3 | 0x8c826f795466e39acbff1bb4eeeb759609377ba1 | 205884 | 167474 | 677985.999015655 |
4 | 0x051785102854b9b9c93c504d9675ffda7a12e07f | 1219527 | 1052051 | 589663.29 |
5 | 0xd7a24d1f1435cd314e86736e139f8431d4498d4e | 132115 | 56683 | 219335.81 |
6 | 0xc0f2bacafbc928be652cb6fbd3caf75d651329b8 | 108995 | 30778 | 150231.503129542 |
7 | 0x307d06edcc51d5cf7ca84ab78749209d804699ff | 236798 | 54842 | 96941.87 |
8 | 0x366694cdef0a8c55b60e2cb28aaf6c2c1958313a | 16112 | 15675 | 95839.3 |
9 | 0x3ddddddce6b28582f7f52780e404b13a03d42805 | 50488 | 49319 | 72640.296592591 |
10 | 0xeec3d8429ea769774b19d29facfcbcbf6fdc5127 | 67445 | 62978 | 66554.031845 |
11 | 0xf7f484a99cf8535b30b5033a245c28a2e2bd875e | 91973 | 46793 | 52690.4 |
12 | 0x050eba46265667efe3a64ac709e74b94d7e074e7 | 206869 | 56078 | 49511.645499936 |
13 | 0x3ddd1ebbf06bd2044b4924da22b0ece6d7ae6f71 | 34707 | 32855 | 35189.92 |
14 | 0x380850effbaef0be65e10e964c23f320e4917334 | 50220 | 14414 | 31738 |
15 | 0xe985eaede8f8a1ac25963f683b32d4d0b24378df | 28271 | 27535 | 26303.111476983 |
16 | 0x6e2470133d47c20a8966ab9dab6622b12105062a | 27557 | 26807 | 25361.141221483 |
17 | 0xb7278fc09a91000b4d88363e0d7baad595f103e1 | 20218 | 14890 | 24202.16 |
18 | 0x236bf2ec79ed617a85fd3abc2c1cc04fccaac9e0 | 24937 | 24210 | 22516.075961483 |
19 | 0x3a25f8c644ae5c864f9bbca1ae0f9560d1bdf240 | 406373 | 165308 | 17455.08 |
20 | 0xe69160a76e76bdc454d33dfcd497e936224a16a4 | 10965 | 10870 | 14779.56 |
aPriorifaucet
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
FROM_ADDRESS
-- ,transfer_value
,count(*) as tx_count
,count(distinct TO_ADDRESS) as address_count
,sum(transfer_value) as transfer_value
from
(
select
FROM_ADDRESS
,TO_ADDRESS
,BLOCK_TIMESTAMP
,TX_HASH
,VALUE as transfer_value
from monad.testnet.fact_transactions
where VALUE>=0.01
) a
group by 1
having count(*)>10000 and count(distinct TO_ADDRESS)>10000
order by transfer_value desc
Last run: 9 days ago
41
3KB
9s