aPriorifaucet
    Updated 9 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: 9 days ago
    FROM_ADDRESS
    TX_COUNT
    ADDRESS_COUNT
    TRANSFER_VALUE
    1
    0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d83428342313142761717.89
    2
    0x77a6ab7dc9096e7a311eb9bb4791494460f53c82131114116249782231.16262789
    3
    0x8c826f795466e39acbff1bb4eeeb759609377ba1205884167474677985.999015655
    4
    0x051785102854b9b9c93c504d9675ffda7a12e07f12195271052051589663.29
    5
    0xd7a24d1f1435cd314e86736e139f8431d4498d4e13211556683219335.81
    6
    0xc0f2bacafbc928be652cb6fbd3caf75d651329b810899530778150231.503129542
    7
    0x307d06edcc51d5cf7ca84ab78749209d804699ff2367985484296941.87
    8
    0x366694cdef0a8c55b60e2cb28aaf6c2c1958313a161121567595839.3
    9
    0x3ddddddce6b28582f7f52780e404b13a03d42805504884931972640.296592591
    10
    0xeec3d8429ea769774b19d29facfcbcbf6fdc5127674456297866554.031845
    11
    0xf7f484a99cf8535b30b5033a245c28a2e2bd875e919734679352690.4
    12
    0x050eba46265667efe3a64ac709e74b94d7e074e72068695607849511.645499936
    13
    0x3ddd1ebbf06bd2044b4924da22b0ece6d7ae6f71347073285535189.92
    14
    0x380850effbaef0be65e10e964c23f320e4917334502201441431738
    15
    0xe985eaede8f8a1ac25963f683b32d4d0b24378df282712753526303.111476983
    16
    0x6e2470133d47c20a8966ab9dab6622b12105062a275572680725361.141221483
    17
    0xb7278fc09a91000b4d88363e0d7baad595f103e1202181489024202.16
    18
    0x236bf2ec79ed617a85fd3abc2c1cc04fccaac9e0249372421022516.075961483
    19
    0x3a25f8c644ae5c864f9bbca1ae0f9560d1bdf24040637316530817455.08
    20
    0xe69160a76e76bdc454d33dfcd497e936224a16a4109651087014779.56
    41
    3KB
    9s