PREVIEW / etf_30min / 2024-09-17
file: by_date/etf_30min/2024/2024-09-17.parquet size: 828 KB rows: 33,168
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-17 04:00:00 | SPY | ETF | 563.3 | 564.27 | 563.3 | 564.0 | 14889.0 |
| 2024-09-17 04:30:00 | SPY | ETF | 564.05 | 564.34 | 564.05 | 564.27 | 12072.0 |
| 2024-09-17 05:00:00 | SPY | ETF | 564.16 | 564.63 | 564.16 | 564.44 | 18881.0 |
| 2024-09-17 05:30:00 | SPY | ETF | 564.53 | 564.99 | 564.53 | 564.78 | 14474.0 |
| 2024-09-17 06:00:00 | SPY | ETF | 564.73 | 565.0 | 564.73 | 564.92 | 9774.0 |
| 2024-09-17 06:30:00 | SPY | ETF | 564.92 | 564.92 | 564.38 | 564.45 | 7701.0 |
| 2024-09-17 07:00:00 | SPY | ETF | 564.42 | 564.52 | 564.06 | 564.21 | 87012.0 |
| 2024-09-17 07:30:00 | SPY | ETF | 564.19 | 565.41 | 564.07 | 565.22 | 99236.0 |
| 2024-09-17 08:00:00 | SPY | ETF | 564.39 | 565.35 | 562.31 | 564.93 | 129844.0 |
| 2024-09-17 08:30:00 | SPY | ETF | 565.24 | 565.58 | 564.75 | 565.32 | 237772.0 |
| 2024-09-17 09:00:00 | SPY | ETF | 565.33 | 565.53 | 564.9 | 565.08 | 153218.0 |
| 2024-09-17 09:30:00 | SPY | ETF | 565.12 | 565.57 | 564.07 | 564.49 | 3253235.0 |
| 2024-09-17 10:00:00 | SPY | ETF | 564.51 | 566.25 | 564.27 | 565.95 | 2433575.0 |
| 2024-09-17 10:30:00 | SPY | ETF | 565.95 | 566.58 | 564.65 | 565.135 | 2358609.0 |
| 2024-09-17 11:00:00 | SPY | ETF | 565.16 | 565.965 | 564.99 | 565.14 | 1510071.0 |
| 2024-09-17 11:30:00 | SPY | ETF | 565.15 | 565.34 | 564.77 | 564.99 | 1279480.0 |
| 2024-09-17 12:00:00 | SPY | ETF | 564.97 | 565.19 | 562.9 | 563.74 | 2144296.0 |
| 2024-09-17 12:30:00 | SPY | ETF | 563.74 | 563.74 | 560.98 | 561.825 | 2549118.0 |
| 2024-09-17 13:00:00 | SPY | ETF | 561.83 | 563.0796 | 561.48 | 562.72 | 1271351.0 |
| 2024-09-17 13:30:00 | SPY | ETF | 562.74 | 563.07 | 560.795 | 562.62 | 1672473.0 |
| 2024-09-17 14:00:00 | SPY | ETF | 562.63 | 563.18 | 562.25 | 562.63 | 1301738.0 |
| 2024-09-17 14:30:00 | SPY | ETF | 562.6201 | 562.8899 | 561.33 | 562.025 | 1826756.0 |
| 2024-09-17 15:00:00 | SPY | ETF | 562.02 | 562.45 | 561.33 | 562.182 | 1957078.0 |
| 2024-09-17 15:30:00 | SPY | ETF | 562.17 | 563.17 | 561.715 | 563.1 | 5077813.0 |
| 2024-09-17 16:00:00 | SPY | ETF | 563.12 | 563.5 | 562.909 | 563.43 | 3261204.0 |
| 2024-09-17 16:30:00 | SPY | ETF | 563.45 | 563.53 | 563.08 | 563.14 | 95780.0 |
| 2024-09-17 17:00:00 | SPY | ETF | 563.1 | 563.15 | 562.98 | 563.05 | 87664.0 |
| 2024-09-17 17:30:00 | SPY | ETF | 563.0808 | 563.1056 | 563.02 | 563.02 | 23154.0 |
| 2024-09-17 18:00:00 | SPY | ETF | 563.07 | 563.3 | 562.96 | 563.28 | 78413.0 |
| 2024-09-17 18:30:00 | SPY | ETF | 563.28 | 563.33 | 563.1 | 563.22 | 6581.0 |
| 2024-09-17 19:00:00 | SPY | ETF | 563.15 | 563.19 | 563.05 | 563.1875 | 4827.0 |
| 2024-09-17 19:30:00 | SPY | ETF | 563.18 | 563.53 | 563.18 | 563.46 | 38948.0 |
| 2024-09-17 04:00:00 | QQQ | ETF | 474.12 | 475.23 | 474.12 | 474.75 | 36824.0 |
| 2024-09-17 04:30:00 | QQQ | ETF | 474.82 | 475.14 | 474.81 | 475.0 | 17329.0 |
| 2024-09-17 05:00:00 | QQQ | ETF | 475.07 | 475.55 | 475.01 | 475.55 | 44689.0 |
| 2024-09-17 05:30:00 | QQQ | ETF | 475.48 | 476.05 | 475.48 | 475.73 | 21553.0 |
| 2024-09-17 06:00:00 | QQQ | ETF | 475.76 | 476.05 | 475.75 | 476.0 | 5286.0 |
| 2024-09-17 06:30:00 | QQQ | ETF | 475.97 | 476.0 | 475.17 | 475.27 | 20263.0 |
| 2024-09-17 07:00:00 | QQQ | ETF | 475.22 | 475.44 | 475.0 | 475.11 | 20704.0 |
| 2024-09-17 07:30:00 | QQQ | ETF | 475.07 | 476.39 | 475.0 | 476.19 | 67158.0 |
| 2024-09-17 08:00:00 | QQQ | ETF | 475.2209 | 476.27 | 472.9 | 475.82 | 165659.0 |
| 2024-09-17 08:30:00 | QQQ | ETF | 476.06 | 476.77 | 475.7 | 476.35 | 229282.0 |
| 2024-09-17 09:00:00 | QQQ | ETF | 476.32 | 476.71 | 475.8401 | 476.24 | 149023.0 |
| 2024-09-17 09:30:00 | QQQ | ETF | 476.3 | 477.05 | 474.23 | 475.42 | 2764821.0 |
| 2024-09-17 10:00:00 | QQQ | ETF | 475.46 | 476.83 | 474.97 | 476.37 | 1586743.0 |
| 2024-09-17 10:30:00 | QQQ | ETF | 476.36 | 477.6 | 475.1 | 475.66 | 1910344.0 |
| 2024-09-17 11:00:00 | QQQ | ETF | 475.69 | 476.74 | 475.25 | 475.55 | 1149760.0 |
| 2024-09-17 11:30:00 | QQQ | ETF | 475.5397 | 475.88 | 474.96 | 475.758 | 850209.0 |
| 2024-09-17 12:00:00 | QQQ | ETF | 475.77 | 476.0199 | 472.62 | 473.78 | 1747989.0 |
| 2024-09-17 12:30:00 | QQQ | ETF | 473.75 | 473.99 | 471.53 | 472.41 | 1860322.0 |
> showing 50 of 33,168 rows — these rows as CSV