TOTAL_DEPOSITS | TOTAL_PLAYERS | VOLUME | VOL_PER_USER | |
|---|---|---|---|---|
1 | 485710 | 17952 | 714931472.189947 | 39824.614092577 |
MLDZMNyolo2
Updated 2025-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tb1 as (select
*
from blast.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = lower('0x0000000000E14E87e5c80A8A90817308fFF715d3')
and ORIGIN_FUNCTION_SIGNATURE in ('0xca232b09','0x553be400') --0x553be400 multiple and 0xca232b09 single deposit
),
tb2 as (select
SYMBOL,
count(distinct tx_hash) as no_deposits,
count(distinct FROM_ADDRESS) as no_players,
sum(AMOUNT_USD) as total_volume,
avg(AMOUNT_USD) as avg_volume,
total_volume/no_players as volume_per_user
from blast.core.ez_token_transfers
where tx_hash in (select tx_hash from tb1)
group by 1
union
select
'ETH' as SYMBOL,
count(distinct tx_hash) as no_deposits,
count(distinct FROM_ADDRESS) as no_players,
sum(AMOUNT_USD) as total_volume,
avg(AMOUNT_USD) as avg_volume,
total_volume/no_players as volume_per_user
from blast.core.ez_native_transfers
where tx_hash in (select tx_hash from tb1)
group by 1)
select
sum(no_deposits) as total_deposits,
sum(no_players) as total_players,
Last run: 3 months ago
1
49B
54s