jennifertranTop 3 DEXs on Solana
Updated 2023-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with
lastMonthSwaps as (
select
*
from
solana.core.fact_swaps swaps
left join solana.core.dim_labels labels on labels.address = swaps.program_id
where
block_timestamp BETWEEN DATEADD('day', -30, CURRENT_DATE()) AND CURRENT_DATE()
)
select
count(*) as number_of_swaps,
label
from
lastMonthSwaps
group by
label
order by
number_of_swaps desc
limit 3;
Run a query to Download Data