select *

('ECY31gWwxy4s2VnMkYhmqDkrV75KrwR2yTtsnrnSpump', 'BARRON'),

('FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P', 'MELANIA'),

('FZ5Jt1qefwdBLESjJAjRewJCPSfN6ocqMSc3RoqMpump', 'IVANKA'),

('YHJGAU32z4r83KGvjrsq1cGrTkQGgsj16GU2zY6pump', 'ERIC TRUMP'),

('Gn8bRZvr1m25rQtYF9mYrfKWaiRmgmzTfQWdebG4pump', 'TRUMP JR')

) l(address,token)

),

pre_last_tab as

(select date(block_timestamp) as datetime,

'sell' as label,

symbol_in as token,

- amount_out_usd as amt

from arbitrum.defi.ez_dex_swaps

where token_in in (select lower(address) from full_data)

union all

select date(block_timestamp) as datetime,

'buy',

symbol_out,

amount_in_usd

from arbitrum.defi.ez_dex_swaps

where token_out in (select lower(address) from full_data)

union all

select date(block_timestamp) as datetime,

'sell',

symbol_in as token,

- amount_out_usd as amt

from base.defi.ez_dex_swaps

where token_in in (select lower(address) from full_data)

union all

select date(block_timestamp) as datetime,

'buy',