select

block_timestamp,

swap_from_mint,

CASE

WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' THEN 'SOL'

WHEN swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'

WHEN swap_from_mint = '2RuDRx9RAcXrSoLupeMLGuBay6w5Q1nUrdPySjA3pump' THEN 'FARTNOY'

WHEN swap_from_mint = 'BA61E4KevZ89a54sDAcMTn3Q1WTg8RkAkC2F2pPZpump' THEN 'JEWSTOOL'

WHEN swap_from_mint = 'Da4NWKF7UKc6RveYFxht9UyHrEiPKUJfTde1SLxypump' THEN 'PETE'

WHEN swap_from_mint = 'C25kNdsAkBgTty6bauzf1EFPGF7xMw7emuFESrryV9r4' THEN 'JAILCOIN'0

WHEN swap_from_mint = '4hr97GiyvAc2Ak57gETQVb1kfaoMeYwngMZZ9qe1pump' THEN 'FARTSTOOL'

WHEN swap_from_mint = 'BktHEAc2WS8TQi2vmavn1rA4L1WJuwF3Vkk3DnwwARti' THEN 'ENRON'

WHEN swap_from_mint = 'FUneMdVVwkbeqhFLSi4nW8k8vdMTPMiSd8VMwfi83div' THEN 'JAILCOIN'

WHEN swap_from_mint = 'EyHjeT4A2CQ2LzmFUCvMTg7bhcHgK6eVQgVwyLzCpump' THEN 'DOGSTOOL'

WHEN swap_from_mint = 'mVuzEMo5n4p6iHNFGWsFkACB2F1vNmW8BdwoyKApump' THEN 'BARFBOY'

WHEN swap_from_mint = 'JCyBh3crFKPSFpDfuY1VwWaaBsD73QfG9YoGKXSfpump' THEN 'BARSTOOL'

WHEN swap_from_mint = 'EARyeM7a9NbZybjXrwdhHdsTtCNuB7dw9wCDJs5Bpump' THEN 'CEASER'

WHEN swap_from_mint = '5poDRfGiHJonS6SR6QiQvAPPLj4JghyS1mZ2zhGypump' THEN 'RETARDO'

WHEN swap_from_mint = '5dHPsouikv7WAz6mfcofkpQibs8MjAV5aBCgpLknpump' THEN 'BARSTOOL'

WHEN swap_from_mint = 'EcUgGEve9YX7Na4AtdqLH27V51iRZnoisDShQEGfpump' THEN 'PEACH'

WHEN swap_from_mint = 'J71Kdxi1qKKv8rRXm2kA9veKbZ3rjqo3955PKYyjpump' THEN 'MVP'

WHEN swap_from_mint = 'GpUNZJWmgd3deYHWVLsnfNW75npshwE18engEKoPpump' THEN 'PORTNOY'

WHEN swap_from_mint = '8KMfU13W1ayhBEyWrZTe8hPTNbZo2cLJrH3pTqNqpump' THEN 'MONTOYA'

WHEN swap_from_mint = 'AxriehR6Xw3adzHopnvMn7GcpRFcD41ddpiTWMg6pump' THEN 'JAILSTOOL'

WHEN swap_from_mint = '7qhwYUXBaPTfWkhUpgWTjHAvdG48wRj5TLmTQ5Topump' THEN 'PEACH'

WHEN swap_from_mint = '2tiEtPrcDaUopnSzg1tY2xTD8PdCCqjY2HwnpNHspump' THEN 'RUGSTOOL'

WHEN swap_from_mint = 'CwuSer8pA8QwDgfLkQN95gNA4QpK2bE8FpnjfbNVpump' THEN 'PEACHES'

WHEN swap_from_mint = 'FGeL6znivc1HHcVk9qthyVwuYxLv2EEQJwMoh5Cmpump' THEN 'PIZZA'

ELSE swap_from_mint

END AS swap_from,

swap_from_amount,

swap_to_mint,

CASE

WHEN swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'SOL'

WHEN swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'