Abbas_ra21Total swap Volume
    Updated 2022-10-10
    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