sum(amount) as amount_bridged,

count(distinct tx_id) as transactions,

CASE

when direction = 'inbound' then 'inbound'

when direction = 'outbound' then 'outbound'

END as direction,

CASE

when bridge = 'blocto' then 'blocto teleport bridge'

when bridge = 'cbridge' then 'celer bridge'

END as bridge,

count(distinct flow_wallet_address) as users

FROM flow.core.ez_bridge_transactions

WHERE block_timestamp::date >= '2023-01-01'

GROUP BY date, direction, bridge

ORDER BY date;