farokhtiabSwap Volume of USDH in $SOL
Updated 2022-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week', block_timestamp) as date,
count (distinct tx_id) as tx_count,
sum(case when swap_from_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then SWAP_FROM_AMOUNT else SWAP_TO_AMOUNT end) as swap_volume,
COUNT(DISTINCT SWAPPER) as swappers,
case when swap_from_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'Sell' else 'Buy' end as type
from solana.core.fact_swaps
where succeeded = TRUE
AND (swap_from_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' OR swap_to_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' )
group by date, type
Run a query to Download Data