Query editor
WITH ranked_prices AS (SELECTminute,price,symbol,blockchain,DATE_TRUNC('month', minute) AS month,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', minute) ORDER BY minute ASC) as rn_asc,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', minute) ORDER BY minute DESC) as rn_descFROM prices.usdWHERE symbol = 'SOL'AND blockchain = 'solana'AND minute >= NOW() - INTERVAL '1' YEAR), prices as (SELECTmonth,MAX(CASE WHEN rn_asc = 1 THEN price ELSE NULL END) as month_start_price,MAX(CASE WHEN rn_desc = 1 THEN price ELSE NULL END) as month_end_priceFROM ranked_pricesGROUP BY month)SELECTmonth, month_start_price, month_end_price, (month_end_price - month_start_price) / month_start_price AS "Monthly Price Change", CASEWHEN ((month_end_price - month_start_price) / month_start_price) < 0 THEN 'Negative'ELSE 'Positive'END AS catFROM prices