MLDZMNTreasury
Updated 2024-06-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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