select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct tx_hash) as "Swap Count",
count(distinct swapper) as "Swapper Count"
from aptos.defi.ez_dex_swaps
where
(token_in='0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin'
or
token_out='0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin')
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1
order by 1