aPrioriuser_profile
    Updated 2025-03-14
    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

    QueryRunArchived: QueryRun has been archived