solananaSolana - Marinade - Dex Metrics
Updated 2025-04-03
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
›
⌄
select
date_trunc('day', block_timestamp) as dt
, 'mSOL' as symbol
, platform
, sum(coalesce(case when swap_from_symbol = 'MSOL' then swap_from_amount else swap_to_amount end,0)) as daily_volume
, sum(coalesce(case when swap_from_symbol = 'MSOL' then 0 else swap_to_amount end,0)) as daily_buys
, sum(coalesce(case when swap_from_symbol = 'MSOL' then swap_from_amount else 0 end,0)) as daily_sells
, sum(coalesce(case when swap_from_symbol = 'MSOL' then swap_from_amount_usd else swap_to_amount_usd end,0)) as daily_volume_usd
, sum(coalesce(case when swap_from_symbol = 'MSOL' then 0 else swap_to_amount_usd end,0)) as daily_buys_usd
, sum(coalesce(case when swap_from_symbol = 'MSOL' then swap_from_amount_usd else 0 end,0)) as daily_sells_usd
, count(distinct swapper) as total_wallets
, median(case when swap_from_symbol = 'MSOL' then swap_from_amount_usd else swap_to_amount_usd end) AS median_daily_volume_usd
from solana.marinade.ez_swaps
where succeeded = true and (swap_from_symbol = 'MSOL' or swap_to_symbol = 'MSOL')
group by 1,2,3
union all
select
date_trunc('day', block_timestamp) as dt
, 'MNDE' as symbol
, platform
, sum(coalesce(case when swap_from_symbol = 'MNDE' then swap_from_amount else swap_to_amount end,0)) as daily_volume
, sum(coalesce(case when swap_from_symbol = 'MNDE' then 0 else swap_to_amount end,0)) as daily_buys
, sum(coalesce(case when swap_from_symbol = 'MNDE' then swap_from_amount else 0 end,0)) as daily_sells
, sum(coalesce(case when swap_from_symbol = 'MNDE' then swap_from_amount_usd else swap_to_amount_usd end,0)) as daily_volume_usd
, sum(coalesce(case when swap_from_symbol = 'MNDE' then 0 else swap_to_amount_usd end,0)) as daily_buys_usd
, sum(coalesce(case when swap_from_symbol = 'MNDE' then swap_from_amount_usd else 0 end,0)) as daily_sells_usd
, count(distinct swapper) as total_wallets
, median(case when swap_from_symbol = 'MNDE' then swap_from_amount_usd else swap_to_amount_usd end) AS median_daily_volume_usd
from solana.marinade.ez_swaps
where succeeded = true and (swap_from_symbol = 'MNDE' or swap_to_symbol = 'MNDE')
group by 1,2,3
order by dt desc, symbol asc
QueryRunArchived: QueryRun has been archived