--TOTAL TRANSACTION BETWEEN MAY TO OCTOBER 2022 (JUMBO)
select date_trunc('month', block_timestamp) "DATE", count(swap_id) "NUMBER OF TRANSACTIONS"
from near.core.ez_dex_swaps
where platform = 'token.jumbo_exchange.near' AND Block_timestamp::DATE BETWEEN '2022-05-01' AND '2022-10-31'
group by 1
order by 1 desc