uniswap_swaps AS (

SELECT

block_timestamp,

block_timestamp::date AS date,

tx_hash,

token_in,

symbol_in,

token_out,

symbol_out,

COALESCE(amount_in_usd,amount_out_usd) AS amount_usd

FROM

ethereum.defi.ez_dex_swaps

WHERE

platform IN ('uniswap-v2', 'uniswap-v3')

AND amount_usd BETWEEN 0 AND 10000000

),

traded_tokens AS (

SELECT

TRUNC(date,'MONTH') AS monthly,

token_in AS token_contract,

symbol_in AS symbol,

tx_hash,

amount_usd

FROM

uniswap_swaps

UNION ALL

SELECT

TRUNC(date,'MONTH') AS monthly,

token_out AS token_contract,

symbol_out AS symbol,

tx_hash,

amount_usd

FROM

uniswap_swaps