aPrioriuser_profile
    Updated 4 days ago
    select
    FROM_ADDRESS as wallet
    ,count(distinct TX_HASH) as tx_count
    ,count(distinct TO_ADDRESS) as address_count
    ,count(distinct date(BLOCK_TIMESTAMP)) as tx_date_count
    from
    (
    select
    FROM_ADDRESS
    ,TO_ADDRESS
    ,TX_HASH
    ,BLOCK_TIMESTAMP
    from monad.testnet.fact_transactions
    ) a
    group by 1
    order by address_count desc

    Last run: 4 days ago
    WALLET
    TX_COUNT
    ADDRESS_COUNT
    TX_DATE_COUNT
    1
    0x051785102854b9b9c93c504d9675ffda7a12e07f2879405117835622
    2
    0xc0f2bacafbc928be652cb6fbd3caf75d651329b813344592548546
    3
    0x8c826f795466e39acbff1bb4eeeb759609377ba123380418665924
    4
    0x3a25f8c644ae5c864f9bbca1ae0f9560d1bdf24048220817528227
    5
    0xc6392ad8a14794ea57d237d12017e7295bea236353993817373523
    6
    0x5790bc75e4d09bb7327f21a90d48ce82aad04d5e31725213904630
    7
    0x77a6ab7dc9096e7a311eb9bb4791494460f53c8215484513499120
    8
    0xeecc2fa50180e7c929c814a8bd65e45f81994327643856432519
    9
    0xeec3d8429ea769774b19d29facfcbcbf6fdc512767452629836
    10
    0x307d06edcc51d5cf7ca84ab78749209d804699ff3059735823242
    11
    0xd7a24d1f1435cd314e86736e139f8431d4498d4e1421125738327
    12
    0x050eba46265667efe3a64ac709e74b94d7e074e72081685623012
    13
    0x503c48bf3089248dce441840ccb9d7cb5efb5ed9761315522621
    14
    0x47771d92ba37dfef43406a02b04a11cfac03d972755745515621
    15
    0xac19f5d4728b2c9a486266929f1465d0ffb53621765965493521
    16
    0x3ddddddce6b28582f7f52780e404b13a03d42805527264945812
    17
    0xf7f484a99cf8535b30b5033a245c28a2e2bd875e920854687221
    18
    0x224b251a411f85e83828a9d8353c76ef7093561d577374593018
    19
    0xa8b194b8461569d1dfe24d2b73c8c621e0deb825449074376824
    20
    0xa9b4e2c9fb992d5956f0b2138651029cdde25404549953784917
    ...
    100000
    5MB
    52s