with naas_tokens as (

SELECT lower(token_address) token_address, token, lower(tj_pool) tj_pool

FROM (

VALUES

('0x8F47416CaE600bccF9530E9F3aeaA06bdD1Caa79','THORv2','0x95189f25b4609120F72783E883640216E92732DA'),

('0x83a283641C6B4DF383BCDDf807193284C84c5342','VPND','0x4cd20F3e2894Ed1A0F4668d953a98E689c647bfE'),

('0x6C1c0319d8dDcb0ffE1a68C5b3829Fd361587DB4','POLAR','0xD81Cb1F7BCe1d539f3de6E7431a637cB5c66669d'),

('0xD21CdCA47Fa45A0A51eec030E27AF390ab3aa489','MEAD','0x295f322E3Cf883925aE8CC9346e4D2B19d7dCb0c'),

('0xd3253bEB9d8AE234e9f2B72a66dF07cC75AC9E79','MEAT(MILKv2)','0x281c0036bDBB54C76Bf3c3436f68988dbC8e1d84'),

('0xfcc6CE74f4cd7eDEF0C5429bB99d38A3608043a5','FIRE','0xc71fA9D143ad905eE73B6EDB4cd44df427df1Fe7'),

('0x490bf3ABcAb1fB5c88533d850F2a8d6D38298465','PLAYMATES','0xFd17C7a2E1EEe2EE2a308E43BDFbAC4dF135c5Cd'),

('0x340990358AE38008181b6dB6156D9021A2D425dA','ORBIT','0x5b159312EFe6953a52a8fF3BB351C6AFc26e667D'),

('0x97E7044ab98B7891546485f5f66EDcc2F58be106','EM','0x1673B86B6F26a121F47a2ae60ab534af78c26C18'),

('0xA7b47575A9b4c2EbF3e6f9ad1d84932bD7AF380F','DEGEN','0x50411e8bA9679988a4Fd59c283b45EB309062f16'),

('0xB11877E59C3b59870E8A6f771A0c83D1ee3F60f8','DOUB','0x19995AD68Fea76C448c2a5e2134313cf72d16DcC'),

('0xD641E62525e830e98Cb9D7D033a538A1f092ff34','LVTv2','0xb16471a1C2E24C325151EaCeb5543747787cd811'),

('0x9e20Af05AB5FED467dFDd5bb5752F7d5410C832e','PXTv2','0x326238cfaf10fc6f536791b548441d03b80daca8')

) AS a (token_address, token, tj_pool)

),

naas as (

select

date(e.block_timestamp) dt

,e.tx_hash

,e.origin_from_address usr

,case when cast(event_inputs:amount0In as float) > 0 then 'Sell' else 'Buy' end typ

,nt.token

from avalanche.core.fact_event_logs e

left join naas_tokens nt

on e.contract_address = nt.tj_pool

where e.event_name = 'Swap'

--and e.origin_to_address = '0x60ae616a2155ee3d9a68541ba4544862310933d4' -- Trader Joe

),