'Arbitrum' as label_chain,

tx_hash,

case

when SYMBOL_IN = 'RDNT' then 'Sell'

when SYMBOL_OUT = 'RDNT' then 'Buy'

end as label,

ORIGIN_FROM_ADDRESS as trader,

SYMBOL_IN,

SYMBOL_OUT,

POOL_NAME,

PLATFORM,

SYMBOL_IN as selling_assets,

SYMBOL_OUT as buying_assets,

AMOUNT_IN_USD

from arbitrum.defi.ez_dex_swaps

where datetime >= current_date - interval '30 days'

and

(

SYMBOL_IN = 'RDNT'

or

SYMBOL_OUT = 'RDNT'

)

and

AMOUNT_IN_USD is not null

order by AMOUNT_IN_USD desc

limit 50

select BLOCK_TIMESTAMP::date as datetime,

'BSC' as label_chain,

tx_hash,

case

when SYMBOL_IN = 'RDNT' then 'Sell'

when SYMBOL_OUT = 'RDNT' then 'Buy'

end as label,