mlhmonthly volume of swaps
Updated 2022-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('month', block_timestamp) as months,
sum(SWAP_FROM_AMOUNT) as total_swap_from,
sum(SWAP_TO_AMOUNT) as total_swap_to
from solana.core.fact_swaps
where BLOCK_ID in
(select
BLOCK_ID
from solana.core.fact_events
where PROGRAM_ID ='SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'--swim protocol
)
and SUCCEEDED='true'
group by 1
Run a query to Download Data