select

BLOCK_TIMESTAMP::date as day,

count(distinct tx_hash) as spins,

count(distinct ORIGIN_FROM_ADDRESS) as players,

sum(AMOUNT) as "Daily volume (ETH)",

sum(AMOUNT_USD) as "Daily volume (USD)",

sum("Daily volume (ETH)") over (order by day) as "Total volume (ETH)",

sum("Daily volume (USD)") over (order by day) as "Total volume (USD)",

sum(spins) over (order by day) as "Total spins",

"Daily volume (ETH)"/players as ETH_per_player,

"Daily volume (USD)"/players as "Spin volume per player",

spins/players as "spins per player"

from blast.core.ez_native_transfers

where ORIGIN_TO_ADDRESS = '0x965d03b148e82e8c99049bfcdc85ee360e0315b1'

and IDENTIFIER = 'CALL_ORIGIN'

group by 1

order by 1 desc