Query editor
WITH swaps AS (SELECTchain AS blockchain,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 = 'ambire-extension-prod'AND evt_block_time >= date_trunc('day', now()) - interval '90' dayAND evt_block_time < date_trunc('day', now())),native_wrapped AS (SELECT *FROM (VALUES('ethereum', 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2),('arbitrum', 0x82aF49447D8a07e3bd95BD0d56f35241523fBab1),('base', 0x4200000000000000000000000000000000000006),('optimism', 0x4200000000000000000000000000000000000006),('polygon', 0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270),('bnb', 0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c),('avalanche_c', 0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7)) AS t(blockchain, wrapped_native)),normalized AS (SELECTs.*,CASEWHEN s.fromAssetId = 0x0000000000000000000000000000000000000000THEN n.wrapped_nativeELSE s.fromAssetIdEND AS pricing_token,s.fromAmount AS pricing_amount_rawFROM swaps sLEFT JOIN native_wrapped nON n.blockchain = s.blockchain),priced_swaps AS (SELECTs.blockchain,s.evt_block_time,s.evt_block_number,