POOL_NAME | TRANSACTIONS | USERS | DEPOSIT_VOLUME_USD | WITHDRAW_VOLUME_USD | DEPOSIT_AVERAGE_AMOUNT_USD | WITHDRAW_AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|
1 | USDH-MSOL | 890888 | 221 | 14159147.21490796 | 14063598.01299337 | 15.809112687921 | 15.702429137183 |
2 | MSOL-USDC | 449441 | 13389 | 836808911.1518998 | 827897871.0399767 | 1854.029749132373 | 1834.286492048177 |
3 | SOL-MSOL | 364321 | 29290 | 11796407286.974873 | 11946284411.637081 | 31363.747585784367 | 31762.23402258102 |
4 | MSOL-USDT | 187144 | 3750 | 496430821.73460025 | 458730686.51953536 | 2634.67547173154 | 2434.591961233483 |
5 | MNDE-MSOL | 128361 | 12782 | 63763393.34299698 | 49807441.26830222 | 494.190266636158 | 386.02639210936 |
6 | MSOL-ETH | 113167 | 3084 | 143690255.7831738 | 140812706.590047 | 1259.380309416402 | 1234.159888077119 |
7 | BSOL-MSOL | 68071 | 503 | 39067245.94303406 | 41999454.93523481 | 553.101892076424 | 594.615193114193 |
8 | ORCA-MSOL | 38295 | 10074 | 49038114.39885377 | 48597712.1411241 | 1280.535693924893 | 1269.035439120619 |
9 | MSOL-JITOSOL | 38241 | 346 | 40478553.45734684 | 43193238.47363785 | 1041.382903456312 | 1111.22301192791 |
10 | MSOL-SOL | 26102 | 5845 | 60823146.07028768 | 85868788.10503289 | 2330.21017815829 | 3289.739794078342 |
Afonso_DiazTop Pools
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
29
30
31
32
33
34
35
›
⌄
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
pool_name,
count(distinct tx_id) as transactions,
count(distinct user) as users,
sum(iff(event_name = 'deposit', amount_usd, 0)) as deposit_volume_usd,
sum(iff(event_name = 'withdraw', amount_usd, 0)) as withdraw_volume_usd,
avg(iff(event_name = 'deposit', amount_usd, 0)) as deposit_average_amount_usd,
avg(iff(event_name = 'withdraw', amount_usd, 0)) as withdraw_average_amount_usd
from
main
where
amount_usd > 0
group by 1
order by transactions desc
limit 10
Last run: 2 days ago
10
969B
5s