Query editor
WITH lmts_price AS (SELECTdate_trunc('day', block_time) AS trade_day,SUM(CAST(amount_usd AS DOUBLE)) AS usd_amount,SUM(CASEWHEN token_bought_symbol = 'LMTS' THEN CAST(token_bought_amount AS DOUBLE)WHEN token_sold_symbol = 'LMTS' THEN CAST(token_sold_amount AS DOUBLE)ELSE 0END) AS lmts_amount,SUM(CAST(amount_usd AS DOUBLE))/ NULLIF(SUM(CASEWHEN token_bought_symbol = 'LMTS' THEN CAST(token_bought_amount AS DOUBLE)WHEN token_sold_symbol = 'LMTS' THEN CAST(token_sold_amount AS DOUBLE)ELSE 0END),0) AS lmts_price_usdFROM dex.tradesWHERE blockchain = 'base'AND token_pair = 'LMTS-USDC'AND (token_bought_symbol = 'LMTS' OR token_sold_symbol = 'LMTS')GROUP BY 1),lmts_buys AS (SELECTdate_trunc('day', block_time) AS trade_day,SUM(CAST(token_bought_amount AS DOUBLE)) AS lmts_bought,SUM(CAST(amount_usd AS DOUBLE)) AS usd_amount,SUM(CAST(amount_usd AS DOUBLE)) / NULLIF(SUM(CAST(token_bought_amount AS DOUBLE)), 0) AS buy_priceFROM dex.tradesWHERE tx_from = 0xBF3132977d9801506deF8E927c4Ff06E5b0801d1AND blockchain = 'base'AND token_pair = 'LMTS-USDC'AND token_bought_symbol = 'LMTS'GROUP BY 1),lmts_sells AS (SELECTdate_trunc('day', block_time) AS trade_day,SUM(CAST(token_sold_amount AS DOUBLE))*-1 AS lmts_sold,SUM(CAST(amount_usd AS DOUBLE))*-1 AS usd_amount,SUM(CAST(amount_usd AS DOUBLE)) / NULLIF(SUM(CAST(token_sold_amount AS DOUBLE)), 0) AS sell_priceFROM dex.tradesWHERE tx_from = 0xBF3132977d9801506deF8E927c4Ff06E5b0801d1AND blockchain = 'base'AND token_pair = 'LMTS-USDC'AND token_sold_symbol = 'LMTS'GROUP BY 1)-- example usage:SELECTp.trade_day,p.lmts_price_usd,b.lmts_bought,