Query editor
withtokens_data AS (SELECTpool_contract, pool_symbol, stable,token0_contract, token1_contract,token0_symbol, token1_symbol,token0_decimals, token1_decimalsFROM query_3283233),price_feed AS (SELECT p.price, p.symbol, p.contract_addressFROM prices.usd_latest pWHERE blockchain = 'base'AND contract_address IN (SELECT DISTINCT token0_contract FROM tokens_dataUNION ALLSELECT DISTINCT token1_contract FROM tokens_data)),transfers AS (SELECTday, x.pool_contract, y.pool_symbol,CASEWHEN x.token = y.token0_contract THEN amount/POW(10,y.token0_decimals) * priceWHEN x.token = y.token1_contract THEN amount/POW(10,y.token1_decimals) * priceELSE NULLEND AS usd_amount,CASEWHEN x.token = y.token0_contract THEN token0_symbolWHEN x.token = y.token1_contract THEN token1_symbolELSE NULLEND AS token_symbolFROM (SELECTDATE_TRUNC('day', evt_block_time) AS day,evt_tx_hash AS tx_hash,to AS pool_contract,contract_address AS token,SUM(value) AS amountFROM erc20_base.evt_TransferWHERE to IN (SELECT pool_contractFROM tokens_data)GROUP BY 1,2,3,4UNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS day,evt_tx_hash AS tx_hash,"from" AS pool_contract,contract_address AS token,- SUM(value) AS amountFROM erc20_base.evt_Transfer evtWHERE "from" IN (SELECT pool_contractFROM tokens_data)GROUP BY 1,2,3,4) xINNER JOIN tokens_data y ON x.pool_contract = y.pool_contract