flipside

    hourly stats
    0-MIDhourly stats
    Updated 2025-02-18
    select date_trunc('day',BLOCK_TIMESTAMP) as day
    ,count(distinct FROM_ADDRESS) as purchasers
    ,count(distinct TX_HASH) as purchases
    ,sum(VALUE) as purchase_volume
    ,(sum(VALUE)/50) as ticket_amount
    from ronin.core.fact_transactions
    where TO_ADDRESS='0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'
    and ORIGIN_FUNCTION_SIGNATURE='0xf1151e76'
    group by 1

    QueryRunArchived: QueryRun has been archived