select

block_timestamp,

tx_hash

from polygon.core.fact_transactions

-- where block_timestamp > date_from_parts(2021,07,01)

-- order by block_timestamp

),

vol as(

select

date(block_timestamp) as date,

count(distinct tx_hash) as n,

case when date(block_timestamp) > date_from_parts(2022,06,30) then 'red' else 'blue' end as pre_post

from txs

group by date(block_timestamp)

select * from vol

where date > date_from_parts(2022,01,1)