block_timestamp::date as day

,CONTRACT_NAME as token

,count (DISTINCT tx_id) as tx_count

,sum(AMOUNT) as amount

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

from flow.core.fact_bridge_transactions join flow.core.dim_contract_labels

on EVENT_CONTRACT = TOKEN_CONTRACT

group by 1,2

order by 1