Query editor
WITH -- Reference prices from main pool query instead of calling GeckoTerminal againtoken_prices AS (SELECT DISTINCT token0_mint AS token_mint_address, token0_price AS priceFROM query_6727292UNIONSELECT DISTINCT token1_mint, token1_priceFROM query_6727292),-- Reference pool addresses from main pool querypool_addresses AS (SELECT DISTINCT pool_addressFROM query_6727292),-- Reference pool metadata from main pool querypool_metadata AS (SELECT DISTINCTpool_address,token0_mint,token1_mint,token0_price,token1_priceFROM query_6727292),-- Daily balances from solana_utils.daily_balancesdaily_pool_balances AS (SELECTdb.day,db.token_balance_owner AS pool_address,db.token_mint_address,SUM(CAST(db.token_balance AS DOUBLE)) AS total_balanceFROM solana_utils.daily_balances dbWHERE db.token_balance_owner IN (SELECT pool_address FROM pool_addresses)AND db.token_balance > 0AND db.day >= DATE '2026-02-16'GROUP BY db.day, db.token_balance_owner, db.token_mint_address),-- Daily TVL per day across all poolsdaily_tvl AS (SELECTdpb.day,SUM(dpb.total_balance * COALESCE(tp.price, 0)) AS daily_tvl_usdFROM daily_pool_balances dpbLEFT JOIN token_prices tp ON dpb.token_mint_address = tp.token_mint_addressGROUP BY dpb.day),-- Daily volume: today's 24h volume from main querydaily_volume AS (SELECTCURRENT_DATE AS day,SUM(volume_usd_24h) AS daily_volume_usdFROM query_6727292),-- Daily fees: current all-time fees from main querydaily_fees AS (