1WITH
2  prices AS (
3    SELECT
4      date,
5      symbol,
6      close
7    FROM
8      "@yahoo.finance.daily_prices"
9    WHERE
10      symbol IN ('SPY', 'QQQ', 'QLD', 'TQQQ')
11      AND instrument_type = 'ETF'
12      AND date >= CAST('2024-12-20' AS DATE)
13      AND date < CAST('2025-12-21' AS DATE)
14  ),
15  base_prices AS (
16    SELECT
17      symbol,
18      close AS base_price
19    FROM
20      prices
21    WHERE
22      date = (
23        SELECT
24          MIN(date)
25        FROM
26          prices
27      )
28  )
29SELECT
30  p.date::date as "date",
31  100 as baseline,
32  ROUND(
33    (
34      SELECT
35        close
36      FROM
37        prices
38      WHERE
39        symbol = 'SPY'
40        AND date = p.date
41    ) / (
42      SELECT
43        base_price
44      FROM
45        base_prices
46      WHERE
47        symbol = 'SPY'
48    ) * 100,
49    2
50  ) AS spy_index,
51  ROUND(
52    (
53      SELECT
54        close
55      FROM
56        prices
57      WHERE
58        symbol = 'QQQ'
59        AND date = p.date
60    ) / (
61      SELECT
62        base_price
63      FROM
64        base_prices
65      WHERE
66        symbol = 'QQQ'
67    ) * 100,
68    2
69  ) AS qqq_index,
70  ROUND(
71    (
72      SELECT
73        close
74      FROM
75        prices
76      WHERE
77        symbol = 'QLD'
78        AND date = p.date
79    ) / (
80      SELECT
81        base_price
82      FROM
83        base_prices
84      WHERE
85        symbol = 'QLD'
86    ) * 100,
87    2
88  ) AS qld_index,
89  ROUND(
90    (
91      SELECT
92        close
93      FROM
94        prices
95      WHERE
96        symbol = 'TQQQ'
97        AND date = p.date
98    ) / (
99      SELECT
100        base_price
101      FROM
102        base_prices
103      WHERE
104        symbol = 'TQQQ'
105    ) * 100,
106    2
107  ) AS tqqq_index
108FROM
109  (
110    SELECT DISTINCT
111      date
112    FROM
113      prices
114    ORDER BY
115      date
116  ) p
117ORDER BY
118  p.date