SELECT 'Ethereum' AS Chain,

Date_trunc('day',BLOCK_TIMESTAMP) AS Date,

TX_HASH,

ORIGIN_FROM_ADDRESS AS Swapper,

POOL_NAME,

AMOUNT_IN,

AMOUNT_OUT,

SYMBOL_IN,

SYMBOL_OUT,

IFF(AMOUNT_IN_USD>0,AMOUNT_IN_USD,AMOUNT_OUT_USD) AS USD_Value

FROM ethereum.sushi.ez_swaps WHERE date >= '2022-05-12' AND date != CURRENT_DATE

UNION ALL

SELECT 'Optimism',

Date_trunc('day',BLOCK_TIMESTAMP) AS date,

TX_HASH,

ORIGIN_FROM_ADDRESS,

POOL_NAME,

AMOUNT_IN,

AMOUNT_OUT,

SYMBOL_IN,

SYMBOL_OUT,

IFF(AMOUNT_IN_USD>0,AMOUNT_IN_USD,AMOUNT_OUT_USD)

FROM optimism.sushi.ez_swaps WHERE date >= '2022-05-12' AND date != CURRENT_DATE

)

SELECT

Chain,

CASE

WHEN USD_Value > 0 AND USD_Value < 500 Then 'less than $500'

WHEN USD_Value >= 500 AND USD_Value < 1000 Then '500-1,000$'