BLOCK_TIMESTAMP::date as day

,BRIDGE

,count (DISTINCT tx_id) as tx_count

,sum(AMOUNT) as amount

,sum (tx_count) over (partition by BRIDGE order by day) as growth_tx

from flow.core.fact_bridge_transactions

group by 1,2

order by 1