Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select count (tx_id) as users, sum(swap_to_amount) as volume, address_name as swaped_token
from solana.core.fact_swaps a
left join solana.core.dim_labels b
on b.address=a.swap_to_mint
where BLOCK_TIMESTAMP >= current_date -30
and SUCCEEDED='true'
and SWAP_from_MINT='So11111111111111111111111111111111111111112'
and SWAP_PROGRAM like 'orca%'
group by swaped_token
order by volume DESC
limit 3
Run a query to Download Data