select date_trunc ({{Time_Interval}},block_timestamp) as date,
symbol,
count (distinct tx_hash) as Bridges,
count (distinct tx_sender) as Bridgor,
sum (bridges) over (partition by symbol order by date asc) as Cumulative_Bridges
from aptos.defi.fact_bridge_activity t1 join aptos.core.dim_tokens t2 on t1.token_address = t2.token_address
where destination_chain_name ilike 'avalanche'
and block_timestamp >= '{{Start_Date}}' and block_timestamp <= '{{End_Date}}'
group by 1,2
order by 1 desc