mlhUntitled Query
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,
count(distinct swapper) as swappers,
count(distinct tx_id) as txs,
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
)
and SUCCEEDED='true'
group by 1
Run a query to Download Data