SELECT

block_timestamp::date AS "Date",

-- CASE

-- WHEN platform = 'sushiswap' THEN 'Sushiswap'

-- WHEN platform = 'uniswap-v2' THEN 'Uniswap'

-- END AS "Platform",

COUNT(DISTINCT(origin_from_address)) AS "Unique Users"

FROM ethereum.core.ez_dex_swaps

WHERE

block_timestamp::date between '2022-01-01' AND '2022-12-31'

AND event_name = 'Swap'

AND platform IN ('uniswap-v2')

GROUP BY "Date"

ORDER BY "Date"),

sushiswapUsers AS (

SELECT

block_timestamp::date AS "Date",

-- CASE

-- WHEN platform = 'sushiswap' THEN 'Sushiswap'

-- WHEN platform = 'uniswap-v2' THEN 'Uniswap'

-- END AS "Platform",

COUNT(DISTINCT(origin_from_address)) AS "Unique Users"

FROM ethereum.core.ez_dex_swaps

WHERE

block_timestamp::date between '2022-01-01' AND '2022-12-31'

AND event_name = 'Swap'

AND platform IN ('sushiswap')

GROUP BY "Date"

ORDER BY "Date"

SELECT

uniswapUsers."Date",

uniswapUsers."Unique Users" AS "Uniswap",