Query editor
WITH TokenPrices AS (SELECTcontract_address AS token,MAX(price) AS price_usd,decimals,blockchainFROM prices.dayWHEREtimestamp >= CURRENT_TIMESTAMP - INTERVAL '30' DAYGROUP BYcontract_address,decimals,blockchain), NativeTokenPrices AS (SELECTblockchain,MAX(price) AS native_price_usdFROM prices.dayWHEREcontract_address = 0x0000000000000000000000000000000000000000AND timestamp >= CURRENT_TIMESTAMP - INTERVAL '30' DAYGROUP BYblockchain), IntegratorFees AS (SELECTevt_tx_from AS user,_token AS token,SUM(_integratorFee) AS total_integrator_fee_raw,TP.decimals,MAX(COALESCE(CASEWHEN _token = 0x0000000000000000000000000000000000000000THEN NTP.native_price_usdELSE TP.price_usdEND,0)) AS price_usdFROM lifi_multichain.feecollector_evt_feescollectedLEFT JOIN TokenPrices AS TPON feecollector_evt_feescollected._token = TP.tokenAND feecollector_evt_feescollected.chain = TP.blockchainLEFT JOIN NativeTokenPrices AS NTPON feecollector_evt_feescollected.chain = NTP.blockchainWHERE_integrator = 0xb50b730D81611c1C8139e9B70D262152b895d918AND evt_block_date >= CURRENT_DATE - INTERVAL '300' DAYGROUP BYevt_tx_from,_token,TP.decimals)SELECTuser,token,SUM(total_integrator_fee_raw / POWER(10, decimals)) AS total_integrator_fee,SUM(total_integrator_fee_raw / POWER(10, decimals) * price_usd) AS total_integrator_fee_usdFROM IntegratorFeesGROUP BY