SpiltadavidOrca Total Volume
Updated 2022-07-12
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day',block_timestamp) as day, sum(swap_from_amount) as total_volume
from solana.core.fact_swaps
where SWAP_PROGRAM='orca'
and SWAP_FROM_MINT='So11111111111111111111111111111111111111112'
and swap_to_amount<>0
and day>= '2022-01-01'
and SWAP_TO_MINT<>'So11111111111111111111111111111111111111112'
group by 1
order by 1 desc;
Run a query to Download Data