with tokens as (

select *

from (values

('So11111111111111111111111111111111111111112', 'ETH'),('Bfk2J75eraAFUDn4u7jjcZeSPjrZL21aNsmXUXyJPwP6', 'TGOAT'),('GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn', 'tETH'),

('3Q5RQRTKCH4RWGFVFht1RtM1fx3SSxNGAk1sTuVank6w', 'Brick'),('BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL', 'SOL'),('8nF4QmTxsFh5L7bBw9qfdfW67CEAdLWuK9EQjsTgk8d' ,'MOO'),

('9HzD1rqAB2LzCUdmr8h8RGSJv6RNMgWJ2o5dk2pkC1Cc', 'doowithash'),('G1hD3TTmxPGAxHrukFSqNxReRMa1cZ5q4WhtpYK6vh8m', 'MDENG'),('137EXM1L3m8hDeq29ducnGhYCwEDCAnxcJ7kqD4TcFFC', 'GSVM'),

('trbts2EsWyMdnCjsHUFBKLtgudmBD7Rfbz8zCg1s4EK' ,'Turbo'),('AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE', 'USDC'),('G9uhFuhGvmvPFxmUD3NWtx3bxHmWBjMmviqEXmh3T6Wa', 'IKD'),

('9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8', 'TIA'),('BbNyKTtWyGdqCtjffwPcW2fbYmfR5Y1A6mmgyCD1ythz', 'TOKYO'),('AjG93K7MXFoMk8GiwvRf4ScXNYQiTSUiNvqF2okihpCh', 'Lily'),

('Bfk2J75eraAFUDn4u7jjcZeSPjrZL21aNsmXUXyJPwP6', 'TGOAT'),('HieeNVs733a9WY51hvRCaQSS4fJiMmh7nHD9xwXGMQin', 'TURBO'),('Bfk2J75eraAFUDn4u7jjcZeSPjrZL21aNsmXUXyJPwP6', 'TGOAT'),

('3imBwxNwVbPnz6yr87HjvdxjNvyCx7cqiuaDyahSB897', 'Dogo'),('EBRHLtbgxEjr2RfUhZXZGdfzvqx8DT62fpxstGCyePmK', 'EDOG'),('F668vpw38wrwDBV5dgxc1rLnDCvDQFLRzusNQuJNoq9X', 'ASUNA') ,

('Czj8Zg7yMMRsYqjWo8J7cApo4uaCqo8Swy8o6PStmUsZ', 'EOWL'),('BZ1xiCBMd1oHFMkFxpJ8NfPzHekX4J9A4MYKfuXo5BR3', 'KIRITO'),('DBTbatKbp36HAKNCDytNQE6deeU2mZzhr2gVENJajz8C', 'KYOTO'),

('9uosBCreVYJ5WjNhh4eXVy8Zs5hM5H9mkQfPTHxw1W8k', 'SAM'),('AUzARKJCWuFitVWAwGR8pkiP3c8DKzRT9GYEG7kcybiV', 'OSAKA'),('Eth1111111111111111111111111111111111111111', 'Native ETH'),

('LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' ,'LAIKA'),('82kkga2kBcQNyV4VKJhGvE7Z58fFavVyuh5NapMVo7Qs', 'SPL Token (MVo7Qs)'),('V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM' ,'stTIA'),

('841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH', 'WIF'),('2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn', 'ORCA'),('D9KiTU9KZcxhMp3GPrWokK17PsgidC5zsJcVAJhsK6Kx', 'epm4'),

('Aj6HETPRCwjLJBBpfSEnRy8jCp1ZipEs7FTMKi745tsJ', 'PODAVINI'),('HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL', 'MOON'),('5DxsTFvJHTEQPSBXLx8M9feFj1xKvXQ1xjmeiV2bbHuU', 'SPL Token (2bbHuU)'),

('4j4n3W6E7FnL9ZcLBZ7FndBFRUH8biHybJFso2fBuJrA', 'SPL Token (fBuJrA)'),('2L1HrmGSkQnV2Embd9V58kkXxMUzTC7DK8mg93UpcYMV', 'SPL Token (UpcYMV)'),('95RwGTfqTMbzbw18pUNQCKKUoudB3VYuEYKmGAx7kZ5m', 'SPL Token (x7kZ5m)'),

('FZLbeANPzvtKPX7cZyRJ53Ce1wihgr57h5r348NziSRD', 'PANTY') t(TOKEN, symbol))),

pools as (

select

BLOCK_TIMESTAMP as creation_date,

INSTRUCTION:accounts[1] as tokenMintA,

b.symbol as tokenMintA_symbol,

INSTRUCTION:accounts[2] as tokenMintB,

c.symbol as tokenMintB_symbol,

tokenMintB_symbol || ' - ' || tokenMintA_symbol as pool_name,

INSTRUCTION:accounts[5] as pool_funder,

INSTRUCTION:accounts[6] as pool_address,

INSTRUCTION:accounts[7] as tokenVaultA,

INSTRUCTION:accounts[8] as tokenVaultB,

case

when INSTRUCTION:accounts[9] = '9ZhzuqjANw7T8Q8KWErXELrx9ZMArUdXAUmoJ9qBGuUS' then '0.01' when INSTRUCTION:accounts[9] = 'BWhUdrPPor8gxya47efretmwTtkCpFQxDiK8eRDV4ibE' then '0.02'