date_trunc('day', block_timestamp) as date,

CASE WHEN date > '2022-11-14' THEN 'After wBNB Bootstrapping' ELSE 'Before wBNB Bootstrapping' END as timeframe,

sum(amount/pow(10, decimal)) as total_volume,

avg(amount/pow(10, decimal)) as average_volume,

sum(total_volume) over (order by date) as cum_vol,

COUNT(DISTINCT tx_id) as bridges

FROM osmosis.core.fact_transfers

LEFT outer JOIN osmosis.core.dim_labels

ON address = currency

WHERE project_name LIKE '%BNB%'

AND sender LIKE 'axelar%'

AND receiver LIKE 'osmo%'

and date>= '{{Date_wBNB}}'

GROUP BY 1