select *

('AGiXT', 'F9TgEJLLRUKDRF16HgjUCdJfJ5BK6ucyiW8uJxVPpump', 'Solana'),

('GEOD', '7JA5eZdCzztSfQbJvS8aVVxMFfd81Rs9VvwnocV1mKHu', 'Solana'),

('AUKI', '0xF9569cFb8FD265e91aa478d86ae8c78b8AF55Df4', 'Base'),

('HIBER', 'FHKiJEg2zmhv9DEeaXMSZa7R4P8BPFX5VTRrzrtJpump', 'Solana'),

('BREW', '2hXQn7nJbh2XFTxvtyKb5mKfnScuoiC1Sm8rnWydpump', 'Solana'),

('mxyz', 'UCYaUNhgB2344N8Qpg4t712V9RHahcpTCejwXKspump', 'Solana'),

('RobOS', '5Tfwxm9pA3oiAUUyQ7HkAyomCo6i6Jr4h4c8U91Xpump', 'Solana'),

('daige', 'HsNx7RirehVMy54xnFtcgCBPDMrwNnJKykageqdWpump', 'Solana'),

('XRT', '0x7dE91B204C1C737bcEe6F000AAA6569Cf7061cb7', 'Ethereum'),

('SAM', '0xd0174292C4d6dfa7c4Ee20F371f3b6D401782cd5', 'Base'),

('MROBOTICS', 'DMzVMP3eBvmXS45HWsn3VSKLm8CxP5ge8erpJZ8Cpump', 'Solana')

) l(token,address,chain)

),

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',