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}})

select

BLOCK_TIMESTAMP,

'UNISWAP' as platform,

AMOUNT1_USD as AMOUNT_IN_USD,

SENDER as swapper,

TOKEN0_SYMBOL as SYMBOL_IN,TOKEN1_SYMBOL as SYMBOL_OUT

from

ethereum.uniswapv3.ez_swaps

where RECIPIENT in (select origin_from_address from typical_users)

and block_timestamp >= CURRENT_DATE - {{days_back}}

limit 20