when date_part('day', block_timestamp)<=7 then '1st week'

when date_part('day', block_timestamp)>7 and date_part('day', block_timestamp)<=14 then '2st week'

when date_part('day', block_timestamp)>14 and date_part('day', block_timestamp)<=21 then '3st week'

when date_part('day', block_timestamp)>21 then '4st week'

end as "Week", sum(amount_in_usd) as "Swap Volume (USD)", COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Trader Count",

count(distinct tx_hash) as "Swap Count", avg(amount_in_usd) as "Avg Swap Volume"

from gnosis.defi.ez_dex_swaps

where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and platform='honeyswap'

group by 1

order by 1