Query editor
SELECTnarrative, mtd_perf, APPROX_PERCENTILE(mtd_perf,0.5) OVER() * 100 AS avg_mtd_perf_across_all_narrativesFROM(SELECT * FROM dune.cryptokoryo_research.result_narratives_mtd_perf_comparative_subset_1 -- query_3590848UNION ALLSELECT * FROM query_3590849UNION ALL(SELECT'BTC' AS narrative, (latest_price - first_price) / first_price AS ytd_performanceFROM (SELECTFIRST_VALUE(price) OVER (ORDER BY minute DESC) AS latest_price,FIRST_VALUE(price) OVER (ORDER BY minute) AS first_priceFROM prices.usdWHEREsymbol='BTC' AND blockchain IS NULLAND (minute >= DATE_TRUNC('month', NOW()) OR minute >= DATE_TRUNC('minute', NOW())))LIMIT 1))ORDER BY 2 DESC