SELECT

BLOCK_TIMESTAMP,

ORIGIN_FROM_ADDRESS as user_wallet_address,

'swapping' as EVENT_NAME,

AMOUNT_IN_USD,

AMOUNT_OUT_USD,

PLATFORM,

SYMBOL_IN,

SYMBOL_out,

RANK() OVER (partition by ORIGIN_FROM_ADDRESS order by BLOCK_TIMESTAMP asc)as rank

FROM ethereum.core.ez_dex_swaps

where platform in ('uniswap-v2','uniswap-v3'))

count(user_wallet_address) as "Total number of swapper users",

sum(AMOUNT_IN_USD) as "Sum of the input amount in the first transactions"

FROM swap_users

WHERE rank=1 and BLOCK_TIMESTAMP>=current_date-365