Abbas_ra21Total swap Volume
Updated 2022-10-10
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc('{{Timeframe}}',BLOCK_TIMESTAMP) AS date,
case when SWAP_TO_MINT='HBB111SCo9jkCejsZfz8Ec8nH7T6THF8KEKSnvwT6XK6' then 'HBB'
else 'USDH' end AS token,
sum(SWAP_TO_AMOUNT) AS "swap to Volume"
from solana.core.fact_swaps
where SWAP_TO_MINT in ('HBB111SCo9jkCejsZfz8Ec8nH7T6THF8KEKSnvwT6XK6','USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')
group by 1,2
Run a query to Download Data