Query editor
WITH swaps AS (SELECTchain,evt_block_time,evt_block_number,evt_tx_hash,evt_index,contract_address,transactionId,integrator,referrer,receiver,fromAssetId,toAssetId,fromAmount,toAmountFROM lifi_multichain.lifidiamond_v2_evt_lifigenericswapcompletedWHERE integrator = 'heyAura-test'AND evt_block_time >= now() - interval '30' day),native_wrapped AS (SELECT *FROM (VALUES('ethereum', 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2),('arbitrum', 0x82aF49447D8a07e3bd95BD0d56f35241523fBab1),('base', 0x4200000000000000000000000000000000000006),('optimism', 0x4200000000000000000000000000000000000006),('polygon', 0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270),('bnb', 0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c),('avalanche_c', 0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7)) AS t(chain, wrapped_native)),normalized AS (SELECTs.*,CASEWHEN s.fromAssetId = 0x0000000000000000000000000000000000000000THEN n.wrapped_nativeELSE s.fromAssetIdEND AS from_pricing_token,CASEWHEN s.toAssetId = 0x0000000000000000000000000000000000000000THEN n.wrapped_nativeELSE s.toAssetIdEND AS to_pricing_tokenFROM swaps sLEFT JOIN native_wrapped nON n.chain = s.chain),selected_token AS (SELECT