BLOCK_TIMESTAMP::DATE as date,

case

when BLOCK_TIMESTAMP>='2022-12-25' then 'Holidays and new year'

else 'Before holidays' end as days,

count(distinct FROM_ADDRESS) as users,

count(distinct tx_hash) as txn

from optimism.core.fact_transactions x join optimism.core.dim_labels y on x.TO_ADDRESS= y.address

where label_subtype != 'token_contract'

and LABEL_TYPE ='dex'

and STATUS = 'SUCCESS'

and BLOCK_TIMESTAMP>='2022-12-01'

group by 1,2