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

    Last run: 29 days ago
    DAY
    PURCHASERS
    PURCHASES
    PURCHASE_VOLUME
    TICKET_AMOUNT
    1
    2025-02-16 00:00:00.0008821057131190026238
    2
    2025-02-14 00:00:00.0004875402215504431
    3
    2025-02-17 00:00:00.0002900445512720650254413
    4
    2025-02-13 00:00:00.000102912084938509877
    5
    2025-02-15 00:00:00.0004355123905507811
    5
    252B
    3s