tx_hash

from ethereum.maker.ez_flash_loans

where block_timestamp >= CURRENT_DATE - {{days_back}}

,typical_users as (select

ORIGIN_FROM_ADDRESS

from ethereum.core.ez_token_transfers

where tx_hash in (select tx_hash from base)

and block_timestamp >= CURRENT_DATE - {{days_back}})

,swaps as (

select

BLOCK_TIMESTAMP,

'SUSHISWAP' as platform,

AMOUNT_IN_USD,

ORIGIN_FROM_ADDRESS as swapper,

SYMBOL_IN,SYMBOL_OUT

from

ethereum.sushi.ez_swaps

where origin_from_address in (select origin_from_address from typical_users)

and block_timestamp >= CURRENT_DATE - {{days_back}}

union all

select

BLOCK_TIMESTAMP,

'UNISWAP' as platform,

AMOUNT1_USD as AMOUNT_IN_USD,

RECIPIENT as swapper,

TOKEN0_SYMBOL as SYMBOL_IN,TOKEN1_SYMBOL as SYMBOL_OUT

from

ethereum.uniswapv3.ez_swaps