trunc(block_timestamp,'{{granularity}}') as date,

case when date>='2022-11-03' then 'Post Hack'

else 'Pre Hack' end as period,

count(distinct tx_hash) as token_swaps,

count(distinct trader) as traders,

sum(amount_out) as volume

from near.core.ez_dex_swaps

where (TOKEN_IN_CONTRACT='token.skyward.near' or TOKEN_OUT_CONTRACT='token.skyward.near') and date>=CURRENT_DATE-INTERVAL '{{period}}'

group by 1 order by 1 asc