EVENT_NAME | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | DIALY_AVERAGE_TXNS | DIALY_AVERAGE_USERS | |
|---|---|---|---|---|---|---|---|
1 | withdraw | 261097 | 64439 | 13854398449.232128 | 61818.53185982192 | 192.833826 | 47.591581 |
2 | deposit | 2333953 | 88928 | 13737027975.8405 | 6169.3451830031 | 1721.204277 | 65.581121 |
Afonso_DiazTotal
Updated 2025-04-22
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
›
⌄
with
main as (
select
tx_id,
block_timestamp,
pool_address,
provider_address as user,
pool_name,
platform,
token_a_amount_usd + token_b_amount_usd as amount_usd,
action_type as event_name
from
solana.marinade.ez_liquidity_pool_actions
)
select
event_name,
count(distinct tx_id) as transactions,
count(distinct user) as users,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd,
transactions / count(distinct block_timestamp::date) as dialy_average_txns,
users / count(distinct block_timestamp::date) as dialy_average_users
from
main
group by 1
Last run: about 1 month ago
2
166B
3s