0-MID2024-04-25 07:34 PM
    Updated 2024-04-25
    select date_trunc('minute',BLOCK_TIMESTAMP) as minute
    ,count(distinct FROM_ADDRESS) as minters
    ,count(distinct TX_HASH) as mints
    ,sum(mints)over(order by minute) as total_mints
    from base.core.fact_transactions
    where STATUS='SUCCESS'
    and TO_ADDRESS='0x87a701770996b323560e332396b33839482e2641'
    group by 1
    QueryRunArchived: QueryRun has been archived