puriftiming analysis cubquest count per minute
    Updated 2024-08-25
    --this is per event, so can be multiple transfers per tx_hash, amount here refers to

    select minute, minters_count from (
    select date_trunc('minute',block_timestamp) as minute, count(distinct decoded_log['to']) as minters_count from berachain.testnet.fact_decoded_event_logs
    where CONTRACT_ADDRESS=lower('0x886D2176D899796cD1AfFA07Eff07B9b2B80f1be')
    and decoded_log['from']=lower('0x0000000000000000000000000000000000000000')
    group by 1
    )
    where minters_count>=10
    order by minute desc

    QueryRunArchived: QueryRun has been archived