0-MIDtop 10 purchasers by t-am
    Updated 2025-02-13

    select FROM_ADDRESS
    ,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
    order by 3 desc
    limit 10



    QueryRunArchived: QueryRun has been archived