MLDZMNTreasury
    Updated 2024-06-20
    select
    count(distinct tx_hash) as spins,
    count(distinct ORIGIN_FROM_ADDRESS) as players,
    sum(AMOUNT) as vol_ETH,
    avg(AMOUNT) as avg_vol_ETH,
    sum(AMOUNT_USD) as vol_usd,
    avg(AMOUNT_USD) as avg_vol_usd,
    vol_ETH/players as eth_per_player,
    vol_usd/players as usd_per_player,
    spins/players as "spins per player"


    from blast.core.ez_native_transfers
    where ORIGIN_TO_ADDRESS = '0x965d03b148e82e8c99049bfcdc85ee360e0315b1'
    and IDENTIFIER = 'CALL_0_1'
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived