faucet | apriori | Flipside

Updated 8 days ago

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: 8 days ago

	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

3KB

flipside