crabtriumph-3379Top Rich Customers (Shop) copy
    Updated 2024-05-25
    -- forked from sssstatistic / Top Rich Customers (Shop) @ https://flipsidecrypto.xyz/sssstatistic/q/rOHXNfWgS24s/top-rich-customers-shop

    select origin_from_address as "Customer Address",
    sum(decoded_log['cost']) / pow(10, 18) as SSS
    from blast.core.ez_decoded_event_logs
    where contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
    and event_name = 'BuyItemFromShop'
    group by origin_from_address
    order by SSS desc


    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived