Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('day', block_timestamp) as date, sum(swap_from_amount) as volume
from solana.core.fact_swaps a
where SUCCEEDED='true'
and swap_from_mint='So11111111111111111111111111111111111111112'
and swap_to_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and SWAP_PROGRAM ilike 'orca%'
and BLOCK_TIMESTAMP >= CURRENT_DATE -30
group by date
order by date desc
Run a query to Download Data