date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_hash) as swaps,

sum(swaps) over (order by date) as total_swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users,

sum(users) over (order by date) as total_users,

sum(amount_in_usd) as swap_volume_usd,

sum(swap_volume_usd) over (order by date) as total_volume

FROM ethereum.core.ez_dex_swaps

WHERE platform LIKE 'sushiswap'

and date>= CURRENT_DATE - 180

GROUP BY 1