SELECT

block_timestamp::date as date,

'BNB' as token,

COUNT(DISTINCT tx_hash) as tx_cnt,

COUNT(DISTINCT BNB_FROM_ADDRESS) as user_cnt,

sum(amount) as volume_token,

avg(amount) as avg_volume_token,

sum(tx_cnt) over (ORDER by date) as cum_tx_cnt,

sum(volume_token) over (ORDER by date) as cum_volume_token

FROM bsc.core.ez_bnb_transfers

WHERE DATE >= CURRENT_DATE - INTERVAL '{{Past_Months}} MONTH'

AND DATE <= CURRENT_DATE - 1

GROUP by 1

UNION

SELECT

block_timestamp::date as date,

'MATIC' as token,

COUNT(DISTINCT tx_hash) as tx_cnt,

COUNT(DISTINCT MATIC_FROM_ADDRESS) as user_cnt,

sum(amount) as volume_token,

avg(amount) as avg_volume_token,

sum(tx_cnt) over (ORDER by date) as cum_tx_cnt,

sum(volume_token) over (ORDER by date) as cum_volume_token

FROM polygon.core.ez_matic_transfers

WHERE DATE >= CURRENT_DATE - INTERVAL '{{Past_Months}} MONTH'

AND DATE <= CURRENT_DATE - 1

GROUP by 1

UNION

SELECT

block_timestamp::date as date,

'OP' as token,