date_trunc ('{{scale}}',block_timestamp)::date as date,

case

when CONTRACT_ADDRESS=lower('0xE5417Af564e4bFDA1c483642db72007871397896') then 'GNS token'

else 'Others ' end as type ,

count(tx_hash) as txns,

count(distinct ORIGIN_FROM_ADDRESS) as users,

sum(txns) over (partition by type order by date rows between unbounded preceding and current row) as cum_transfer,

sum(users) over (partition by type order by date rows between unbounded preceding and current row) as cum_users

from Polygon.core.fact_token_transfers

where BLOCK_TIMESTAMP>=CURRENT_DATE - {{Days_back}}

group by 1,2