Query editor
WITH fees_collection AS (SELECTchain,evt_tx_hash,evt_index,evt_block_dateFROMlifi_multichain.feecollector_evt_feescollectedWHERE_integrator = X'b50b730D81611c1C8139e9B70D262152b895d918'AND evt_block_date >= CURRENT_DATE - INTERVAL '300' DAY),assets_swapped AS (SELECTchain,evt_tx_hash,evt_index,evt_block_date,fromAmount,CAST(fromAssetId AS varchar) AS fromAssetId,CAST(toAssetId AS varchar) AS toAssetId,evt_tx_from AS userFROMlifi_multichain.lifidiamond_evt_assetswappedWHEREevt_block_date >= CURRENT_DATE - INTERVAL '300' DAYAND fromAssetId != toAssetId -- Filter out swaps where from and to are the same)SELECTa.evt_block_date AS date,a.evt_tx_hash AS tx_hash,a.chain AS chain,a.user AS user_address,a.fromAssetId AS token_from_address,CASEWHEN a.fromAssetId = '0x0000000000000000000000000000000000000000' THENCASE a.chainWHEN 'ethereum' THEN 'ETH'WHEN 'polygon' THEN 'MATIC'WHEN 'bsc' THEN 'BNB'WHEN 'arbitrum' THEN 'ETH'WHEN 'optimism' THEN 'ETH'WHEN 'avalanche_c' THEN 'AVAX'WHEN 'fantom' THEN 'FTM'WHEN 'berachain' THEN 'BERA'ELSE 'NATIVE'ENDELSE tf.symbolEND AS token_from_symbol,a.toAssetId AS token_to_address,CASEWHEN a.toAssetId = '0x0000000000000000000000000000000000000000' THENCASE a.chainWHEN 'ethereum' THEN 'ETH'WHEN 'polygon' THEN 'MATIC'WHEN 'bsc' THEN 'BNB'WHEN 'arbitrum' THEN 'ETH'WHEN 'optimism' THEN 'ETH'WHEN 'avalanche_c' THEN 'AVAX'WHEN 'fantom' THEN 'FTM'