PLATFORM | EVENT_NAME | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | DAILY_AVERAGE_TXNS | DAILY_AVERAGE_USERS | |
|---|---|---|---|---|---|---|---|---|
1 | meteora | deposit | 49824 | 33380 | 86913395.030614 | 2590.949322719154 | 53.230769 | 35.662393 |
2 | meteora | withdraw | 41896 | 28784 | 84148841.4317398 | 2841.042622361991 | 44.617678 | 30.653887 |
3 | orca | deposit | 1860380 | 48328 | 2084727460.796701 | 1157.945830376085 | 1386.274218 | 36.011923 |
4 | orca | withdraw | 138503 | 26472 | 2082249657.2170546 | 16174.446019536377 | 103.283371 | 19.740492 |
5 | raydium | deposit | 423749 | 9032 | 11565387120.013184 | 29447.42320122925 | 312.499263 | 6.660767 |
6 | raydium | withdraw | 80698 | 10979 | 11687999950.583334 | 177742.63132369192 | 59.599705 | 8.108567 |
Afonso_DiazTotal
Updated 2 days ago
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
›
⌄
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
platform,
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,
count(distinct tx_id) / count(distinct block_timestamp::date) as daily_average_txns,
count(distinct user) / count(distinct block_timestamp::date) as daily_average_users
from
main
group by 1, 2
order by platform, event_name
Last run: 2 days ago
6
545B
3s