block_number,

tx_hash,

ARRAY_AGG(block_timestamp) as block_timestamp,

ARRAY_AGG(event_index) as event_index,

ARRAY_AGG(AMOUNT_IN) as amount_out,

ARRAY_AGG(AMOUNT_OUT) as amount_in,

ARRAY_AGG(ORIGIN_FROM_ADDRESS) as origin_from,

ARRAY_AGG(ORIGIN_TO_ADDRESS) as origin_to,

ARRAY_AGG(sender) as sender,

ARRAY_AGG(tx_to) as tx_to,

ARRAY_AGG(

CASE

WHEN SYMBOL_IN = 'WETH' THEN 'buy' ELSE 'sell'

END) AS swap_type

FROM

ethereum.defi.ez_dex_swaps

block_number >= 20075299

AND

block_number <= 20198955

and

((TOKEN_IN = lower('0xA045Fe936E26e1e1e1Fb27C1f2Ae3643acde0171') and TOKEN_OUT = lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'))

or

(TOKEN_IN = lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2') and TOKEN_OUT = lower('0xA045Fe936E26e1e1e1Fb27C1f2Ae3643acde0171')))

and

contract_address = lower('0xB10d5aCEE2233a30f03ADf6f425249113395D7a8')

group by

1, 2

order by

1, 3

50000