winnie-fsSolana I dex %
Updated 2024-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with
A as(
select trim(replace(replace(protocol,'v1'),'v4')) as protocol, sum(volume) as volume
from external.defillama.fact_dex_volume
where chain = 'solana'
and date_trunc('day',date) >= CURRENT_DATE - interval '30 day'
group by 1)
select *
from A
where volume > 0
order by volume desc
QueryRunArchived: QueryRun has been archived