-- forked from Blocto bridge transaction copy @ https://flipsidecrypto.xyz/studio/queries/13a523e6-d3d6-4a63-8001-34df1c77b1e2
SELECT direction,
count (DISTINCT Tx_id) as Transactions,
FROM flow.defi.ez_bridge_transactions,
WHERE block_timestamp >= '2024-01-01'
and bridge = 'cbridge'
GROUP BY 1
ORDER by 2 DESC