SELECT

tx_id as tx,

CASE

WHEN ARRAY_CONTAINS('N4xy6PT672fPyA969nQy7jTQ17AsMZ1jrbgm8ZvRKYK'::variant, instruction:accounts::array) THEN 'Bonk/USDC'

WHEN ARRAY_CONTAINS('8eoPffvvhYosGwbpa11UnQxBisCe6dD2HeLiJWUJb5x4'::variant, instruction:accounts::array) THEN 'BLZE-USDC'

WHEN ARRAY_CONTAINS('G9gb8MqiSaCJVASckYeK6hw8v4qfwX8ma2Mpywn2qas1'::variant, instruction:accounts::array) THEN 'BLZE-bSOL'

WHEN ARRAY_CONTAINS('4sxoqoWAkBc1443t65746K9yoKLkLocbinNeQCLak6tX'::variant, instruction:accounts::array) THEN 'TBTC-SOL'

WHEN ARRAY_CONTAINS('FuR4CNqbcJ4feUysem5AE8sbtjRrctJ2qB5BiR4UuDvc'::variant, instruction:accounts::array) THEN 'TBTC-USDC'

WHEN ARRAY_CONTAINS('4xqyRGWMRkfVo7GH74aryKjSLcpQiVHGAZY4u1n6wAbZ'::variant, instruction:accounts::array) THEN 'UXD-USDC'

WHEN ARRAY_CONTAINS('DvWpLaNUPqoCGn4foM6hekAPKqMtADJJbJWhwuMiT6vK'::variant, instruction:accounts::array) THEN 'bSOL-SOL'

WHEN ARRAY_CONTAINS('abUTXJ1KTSaKocx3gr6UQDn5kaN666c9x7UXZSXepbh'::variant, instruction:accounts::array) THEN 'aaUSDT-4Pool'

WHEN ARRAY_CONTAINS('USD4WhBLkQsNm8bXMfxoKuMRtE281CYrPGcfJXZxQL9'::variant, instruction:accounts::array) THEN 'aUSDC-4Pool'

WHEN ARRAY_CONTAINS('abUDCvrNgN9snpRKo2x73pSxaWP1m7gysnBeVmi2XPW'::variant, instruction:accounts::array) THEN 'abBUSD-4Pool'

WHEN ARRAY_CONTAINS('6ZLKLjMd2KzH7PPHCXUPgbMAtdTT37VgTtdeXWLoJppr'::variant, instruction:accounts::array) THEN 'acUSD-USDC'

WHEN ARRAY_CONTAINS('SWABtvDnJwWwAb9CbSA3nv7nTnrtYjrACAVtuP3gyBB'::variant, instruction:accounts::array) THEN 'PAI-3Pool'

WHEN ARRAY_CONTAINS('32D4zRxNc1EssbJieVHfPhZM3rH6CzfUPrWUuWxD9prG'::variant, instruction:accounts::array) THEN 'USDT-USDC'

WHEN ARRAY_CONTAINS('HcjZvfeSNJbNkfLD4eEcRBr96AD3w1GpmMppaeRZf7ur'::variant, instruction:accounts::array) THEN 'mSOL-SOL'

WHEN ARRAY_CONTAINS('ERgpKaq59Nnfm9YRVAAhnq16cZhHxGcDoDWCzXbhiaNw'::variant, instruction:accounts::array) THEN 'jitoSOL-SOL'

WHEN ARRAY_CONTAINS('4osWxj2n4FpEnwMjDjgRqBW43jCxd9mp34q4Eo2xzurV'::variant, instruction:accounts::array) THEN 'USDT-USDTet'

WHEN ARRAY_CONTAINS('7EJSgV2pthhDfb4UiER9vzTqe2eojei9GEQAQnkqJ96e'::variant, instruction:accounts::array) THEN 'stSOL-SOL'

WHEN ARRAY_CONTAINS('LiDoU8ymvYptqxenJ4YpcURBchn4ef63tcbdznBCKJh'::variant, instruction:accounts::array) THEN 'stSOL-2Pool'

WHEN ARRAY_CONTAINS('MAR1zHjHaQcniE2gXsDptkyKUnNfMEsLBVcfP7vLyv7'::variant, instruction:accounts::array) THEN 'mSOL-2Pool'

WHEN ARRAY_CONTAINS('9K1R4DVYZjSH3JiegPfpWndp7RNjFzbtReQPHERoZar8'::variant, instruction:accounts::array) THEN 'SOL-jitoSOL'

WHEN ARRAY_CONTAINS('USD42Jvem43aBSLqT83GZmvRbzAjpKBonQYBQhni7Cv'::variant, instruction:accounts::array) THEN 'wUSD-4Pool'

WHEN ARRAY_CONTAINS('5kYoik2SHAQxtK82jeHfkwTb1UrStJJUqBteXcU5csP8'::variant, instruction:accounts::array) THEN 'MDS-USDC'

WHEN ARRAY_CONTAINS('Aw1MJ31SHEEYmzg9vE4bXa5ZURS5HDvMZjhXmt7Tu8yJ'::variant, instruction:accounts::array) THEN 'SOL-MDS'

WHEN ARRAY_CONTAINS('pvgGDMNpxapbVM8YNao5f6i6mioMzZBHjzDeEcYf9iZ'::variant, instruction:accounts::array) THEN 'HADES-MDS'

WHEN ARRAY_CONTAINS('SoLw5ovBPNfodtAbxqEKHLGppyrdB4aZthdGwpfpQgi'::variant, instruction:accounts::array) THEN 'pSOL-SOL'

WHEN ARRAY_CONTAINS('5NQTw1WqVEt6wP1LmohsrYDyJp2NDipdv6eULVNByXMb'::variant, instruction:accounts::array) THEN 'WBTC-USDC'

WHEN ARRAY_CONTAINS('En74MBGaWL4QcHrKhXPevbK7GSLWDcwVwcQ9U5jzTo5H'::variant, instruction:accounts::array) THEN 'MDS-USDT'

ELSE 'Other'

END AS pair

FROM solana.core.fact_events

WHERE program_id = 'Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB'

AND block_timestamp::date >= current_date -30)