PREVIEW / etf_1hour / 2025-03-28
file: by_date/etf_1hour/2025/2025-03-28.parquet size: 623 KB rows: 23,754
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-03-28 04:00:00 | SPY | ETF | 566.48 | 566.88 | 564.49 | 565.7 | 37613.0 |
| 2025-03-28 05:00:00 | SPY | ETF | 565.78 | 566.1 | 565.45 | 565.58 | 16648.0 |
| 2025-03-28 06:00:00 | SPY | ETF | 565.75 | 567.06 | 565.75 | 566.67 | 22774.0 |
| 2025-03-28 07:00:00 | SPY | ETF | 566.74 | 566.75 | 565.84 | 566.35 | 157321.0 |
| 2025-03-28 08:00:00 | SPY | ETF | 566.47 | 567.85 | 564.46 | 564.46 | 445126.0 |
| 2025-03-28 09:00:00 | SPY | ETF | 564.46 | 566.64 | 563.76 | 563.9399 | 4051061.0 |
| 2025-03-28 10:00:00 | SPY | ETF | 563.84 | 564.36 | 558.26 | 558.79 | 9838436.0 |
| 2025-03-28 11:00:00 | SPY | ETF | 558.8 | 559.8 | 557.77 | 557.93 | 5700402.0 |
| 2025-03-28 12:00:00 | SPY | ETF | 557.92 | 558.8 | 556.44 | 556.5432 | 4097187.0 |
| 2025-03-28 13:00:00 | SPY | ETF | 556.5 | 556.7 | 555.22 | 556.41 | 4529189.0 |
| 2025-03-28 14:00:00 | SPY | ETF | 556.39 | 556.97 | 555.31 | 556.18 | 3860668.0 |
| 2025-03-28 15:00:00 | SPY | ETF | 556.21 | 556.72 | 555.07 | 555.83 | 12811222.0 |
| 2025-03-28 16:00:00 | SPY | ETF | 555.84 | 555.8879 | 553.75 | 553.7599 | 5124428.0 |
| 2025-03-28 17:00:00 | SPY | ETF | 553.7 | 554.16 | 553.7 | 554.05 | 95732.0 |
| 2025-03-28 18:00:00 | SPY | ETF | 554.11 | 554.5191 | 553.88 | 554.203 | 78253.0 |
| 2025-03-28 19:00:00 | SPY | ETF | 554.3 | 554.37 | 553.92 | 554.15 | 26155.0 |
| 2025-03-28 04:00:00 | QQQ | ETF | 478.64 | 479.81 | 478.43 | 479.59 | 67724.0 |
| 2025-03-28 05:00:00 | QQQ | ETF | 479.8 | 480.47 | 479.59 | 479.69 | 23266.0 |
| 2025-03-28 06:00:00 | QQQ | ETF | 479.79 | 481.17 | 479.79 | 480.75 | 92073.0 |
| 2025-03-28 07:00:00 | QQQ | ETF | 480.76 | 480.91 | 479.81 | 480.68 | 86349.0 |
| 2025-03-28 08:00:00 | QQQ | ETF | 480.27 | 482.02 | 478.42 | 478.66 | 367376.0 |
| 2025-03-28 09:00:00 | QQQ | ETF | 478.63 | 481.031 | 478.07 | 478.4522 | 3528642.0 |
| 2025-03-28 10:00:00 | QQQ | ETF | 478.44 | 479.05 | 471.8 | 472.43 | 8940009.0 |
| 2025-03-28 11:00:00 | QQQ | ETF | 472.43 | 473.0751 | 470.92 | 470.92 | 3635132.0 |
| 2025-03-28 12:00:00 | QQQ | ETF | 470.92 | 471.89 | 469.57 | 469.74 | 2933621.0 |
| 2025-03-28 13:00:00 | QQQ | ETF | 469.74 | 469.95 | 468.4891 | 469.56 | 3497116.0 |
| 2025-03-28 14:00:00 | QQQ | ETF | 469.5 | 470.4 | 468.62 | 469.52 | 2718774.0 |
| 2025-03-28 15:00:00 | QQQ | ETF | 469.51 | 470.04 | 468.05 | 469.0187 | 5430444.0 |
| 2025-03-28 16:00:00 | QQQ | ETF | 469.02 | 469.03 | 466.69 | 466.7 | 2488037.0 |
| 2025-03-28 17:00:00 | QQQ | ETF | 466.87 | 467.21 | 466.74 | 467.21 | 91541.0 |
| 2025-03-28 18:00:00 | QQQ | ETF | 467.25 | 467.5 | 467.05 | 467.17 | 34665.0 |
| 2025-03-28 19:00:00 | QQQ | ETF | 467.18 | 467.2 | 466.75 | 466.9 | 26296.0 |
| 2025-03-28 04:00:00 | IWM | ETF | 204.53 | 204.95 | 204.36 | 204.86 | 14192.0 |
| 2025-03-28 05:00:00 | IWM | ETF | 204.92 | 204.96 | 204.38 | 204.39 | 5216.0 |
| 2025-03-28 06:00:00 | IWM | ETF | 204.5 | 204.89 | 204.48 | 204.64 | 8905.0 |
| 2025-03-28 07:00:00 | IWM | ETF | 204.66 | 204.89 | 204.56 | 204.89 | 23680.0 |
| 2025-03-28 08:00:00 | IWM | ETF | 204.59 | 205.33 | 204.05 | 204.05 | 170952.0 |
| 2025-03-28 09:00:00 | IWM | ETF | 204.03 | 204.78 | 202.69 | 202.74 | 2374623.0 |
| 2025-03-28 10:00:00 | IWM | ETF | 202.74 | 202.99 | 200.55 | 200.655 | 3511195.0 |
| 2025-03-28 11:00:00 | IWM | ETF | 200.62 | 201.12 | 200.35 | 200.395 | 2205997.0 |
| 2025-03-28 12:00:00 | IWM | ETF | 200.38 | 200.9297 | 200.08 | 200.25 | 1097875.0 |
| 2025-03-28 13:00:00 | IWM | ETF | 200.21 | 200.23 | 199.38 | 200.01 | 1748541.0 |
| 2025-03-28 14:00:00 | IWM | ETF | 199.99 | 200.35 | 199.705 | 200.215 | 1687307.0 |
| 2025-03-28 15:00:00 | IWM | ETF | 200.22 | 200.69 | 199.74 | 200.49 | 4378155.0 |
| 2025-03-28 16:00:00 | IWM | ETF | 200.45 | 200.5 | 199.57 | 199.61 | 2060901.0 |
| 2025-03-28 17:00:00 | IWM | ETF | 199.57 | 199.74 | 199.55 | 199.59 | 37524.0 |
| 2025-03-28 18:00:00 | IWM | ETF | 199.56 | 199.79 | 199.55 | 199.73 | 20765.0 |
| 2025-03-28 19:00:00 | IWM | ETF | 199.6 | 199.79 | 199.6 | 199.78 | 19059.0 |
| 2025-03-28 04:00:00 | DIA | ETF | 421.9 | 421.9 | 421.59 | 421.59 | 596.0 |
| 2025-03-28 05:00:00 | DIA | ETF | 422.36 | 422.36 | 422.36 | 422.36 | 238.0 |
> showing 50 of 23,754 rows — these rows as CSV