SELECT

ethereum.core.ez_dex_swaps.EVENT_NAME as "Event Name",

ethereum.core.ez_dex_swaps.PLATFORM as "Platform",

ethereum.core.ez_dex_swaps.BLOCK_TIMESTAMP::date AS "Date",

ethereum.core.ez_dex_swaps.SYMBOL_OUT as "Symbol Out",

AVG(ethereum.core.ez_dex_swaps.AMOUNT_IN / ethereum.core.ez_dex_swaps.AMOUNT_OUT) AS "Token Price"

FROM ethereum.core.ez_dex_swaps

WHERE ethereum.core.ez_dex_swaps.SYMBOL_IN = 'USDC'

AND ethereum.core.ez_dex_swaps.SYMBOL_OUT != ''

AND ethereum.core.ez_dex_swaps.AMOUNT_OUT_USD > 0

AND ethereum.core.ez_dex_swaps.EVENT_NAME = 'Swap'

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

AND ethereum.core.ez_dex_swaps.PLATFORM IN ('uniswap-v2')

GROUP BY "Event Name", "Platform", "Symbol Out", "Date"

ORDER BY "Symbol Out", "Platform", "Date"),

sushiswap AS (

SELECT

ethereum.core.ez_dex_swaps.EVENT_NAME as "Event Name",

ethereum.core.ez_dex_swaps.PLATFORM as "Platform",

ethereum.core.ez_dex_swaps.BLOCK_TIMESTAMP::date AS "Date",

ethereum.core.ez_dex_swaps.SYMBOL_OUT as "Symbol Out",

AVG(ethereum.core.ez_dex_swaps.AMOUNT_IN / ethereum.core.ez_dex_swaps.AMOUNT_OUT) AS "Token Price"

FROM ethereum.core.ez_dex_swaps

WHERE ethereum.core.ez_dex_swaps.SYMBOL_IN = 'USDC'

AND ethereum.core.ez_dex_swaps.SYMBOL_OUT != ''

AND ethereum.core.ez_dex_swaps.AMOUNT_OUT_USD > 0

AND ethereum.core.ez_dex_swaps.EVENT_NAME = 'Swap'

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

AND ethereum.core.ez_dex_swaps.PLATFORM IN ('sushiswap')

GROUP BY "Event Name", "Platform", "Symbol Out", "Date"

ORDER BY "Symbol Out", "Platform", "Date"

),

dexComparison AS (