PREVIEW / etf_30min / 2024-01-12
file: by_date/etf_30min/2024/2024-01-12.parquet size: 784 KB rows: 30,864
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-01-12 04:00:00 | SPY | ETF | 476.12 | 477.09 | 475.82 | 476.65 | 16792.0 |
| 2024-01-12 04:30:00 | SPY | ETF | 476.9 | 476.9 | 476.3 | 476.36 | 8876.0 |
| 2024-01-12 05:00:00 | SPY | ETF | 476.24 | 476.6 | 476.2 | 476.6 | 2509.0 |
| 2024-01-12 05:30:00 | SPY | ETF | 476.43 | 476.49 | 475.99 | 476.19 | 2065.0 |
| 2024-01-12 06:00:00 | SPY | ETF | 476.4 | 476.4 | 475.75 | 475.98 | 9381.0 |
| 2024-01-12 06:30:00 | SPY | ETF | 475.88 | 475.92 | 474.17 | 474.92 | 195872.0 |
| 2024-01-12 07:00:00 | SPY | ETF | 474.95 | 475.35 | 474.75 | 475.17 | 205167.0 |
| 2024-01-12 07:30:00 | SPY | ETF | 475.19 | 475.57 | 475.1 | 475.15 | 70938.0 |
| 2024-01-12 08:00:00 | SPY | ETF | 475.17 | 476.85 | 474.3196 | 475.22 | 283457.0 |
| 2024-01-12 08:30:00 | SPY | ETF | 475.59 | 476.67 | 475.46 | 476.43 | 570673.0 |
| 2024-01-12 09:00:00 | SPY | ETF | 476.43 | 477.97 | 476.29 | 477.85 | 395912.0 |
| 2024-01-12 09:30:00 | SPY | ETF | 477.84 | 478.6 | 477.0797 | 477.12 | 5901624.0 |
| 2024-01-12 10:00:00 | SPY | ETF | 477.14 | 477.5 | 475.9 | 476.53 | 5666474.0 |
| 2024-01-12 10:30:00 | SPY | ETF | 476.52 | 476.9101 | 475.23 | 475.8 | 4075600.0 |
| 2024-01-12 11:00:00 | SPY | ETF | 475.81 | 476.79 | 475.61 | 476.5795 | 3144130.0 |
| 2024-01-12 11:30:00 | SPY | ETF | 476.58 | 476.82 | 475.405 | 475.67 | 2570426.0 |
| 2024-01-12 12:00:00 | SPY | ETF | 475.68 | 476.32 | 475.365 | 475.92 | 2198548.0 |
| 2024-01-12 12:30:00 | SPY | ETF | 475.94 | 476.49 | 475.61 | 476.13 | 1776282.0 |
| 2024-01-12 13:00:00 | SPY | ETF | 476.13 | 476.76 | 476.13 | 476.6299 | 1979778.0 |
| 2024-01-12 13:30:00 | SPY | ETF | 476.64 | 477.02 | 476.4901 | 476.931 | 1739017.0 |
| 2024-01-12 14:00:00 | SPY | ETF | 476.93 | 477.34 | 476.58 | 476.91 | 2203383.0 |
| 2024-01-12 14:30:00 | SPY | ETF | 476.9099 | 476.93 | 476.15 | 476.2501 | 2402584.0 |
| 2024-01-12 15:00:00 | SPY | ETF | 476.26 | 476.48 | 475.76 | 476.1895 | 2569012.0 |
| 2024-01-12 15:30:00 | SPY | ETF | 476.19 | 476.9 | 476.08 | 476.665 | 7110680.0 |
| 2024-01-12 16:00:00 | SPY | ETF | 476.66 | 477.1452 | 476.1183 | 476.2 | 1810456.0 |
| 2024-01-12 16:30:00 | SPY | ETF | 476.16 | 476.2 | 475.97 | 476.15 | 108540.0 |
| 2024-01-12 17:00:00 | SPY | ETF | 476.12 | 476.33 | 476.1075 | 476.2 | 38599.0 |
| 2024-01-12 17:30:00 | SPY | ETF | 476.1 | 476.13 | 475.95 | 476.0 | 16768.0 |
| 2024-01-12 18:00:00 | SPY | ETF | 476.0 | 476.0 | 475.6 | 475.7596 | 59647.0 |
| 2024-01-12 18:30:00 | SPY | ETF | 475.72 | 475.8709 | 475.68 | 475.75 | 25636.0 |
| 2024-01-12 19:00:00 | SPY | ETF | 475.78 | 475.86 | 475.77 | 475.81 | 7715.0 |
| 2024-01-12 19:30:00 | SPY | ETF | 475.84 | 475.84 | 475.65 | 475.65 | 14794.0 |
| 2024-01-12 04:00:00 | QQQ | ETF | 409.31 | 409.64 | 409.0 | 409.01 | 27260.0 |
| 2024-01-12 04:30:00 | QQQ | ETF | 409.13 | 409.36 | 408.46 | 408.49 | 23572.0 |
| 2024-01-12 05:00:00 | QQQ | ETF | 408.61 | 408.88 | 408.39 | 408.84 | 49129.0 |
| 2024-01-12 05:30:00 | QQQ | ETF | 408.72 | 408.82 | 408.11 | 408.46 | 33755.0 |
| 2024-01-12 06:00:00 | QQQ | ETF | 408.51 | 408.63 | 408.02 | 408.31 | 21728.0 |
| 2024-01-12 06:30:00 | QQQ | ETF | 408.29 | 408.29 | 407.02 | 407.72 | 69821.0 |
| 2024-01-12 07:00:00 | QQQ | ETF | 407.73 | 408.08 | 407.5 | 408.0 | 35036.0 |
| 2024-01-12 07:30:00 | QQQ | ETF | 408.03 | 408.34 | 408.0 | 408.05 | 65966.0 |
| 2024-01-12 08:00:00 | QQQ | ETF | 407.8611 | 409.52 | 407.65 | 407.94 | 147736.0 |
| 2024-01-12 08:30:00 | QQQ | ETF | 408.2 | 409.7092 | 408.2 | 409.36 | 376948.0 |
| 2024-01-12 09:00:00 | QQQ | ETF | 409.41 | 410.41 | 409.21 | 410.34 | 304467.0 |
| 2024-01-12 09:30:00 | QQQ | ETF | 410.41 | 411.25 | 409.62 | 409.905 | 4050984.0 |
| 2024-01-12 10:00:00 | QQQ | ETF | 409.94 | 410.35 | 408.71 | 409.42 | 3506382.0 |
| 2024-01-12 10:30:00 | QQQ | ETF | 409.4671 | 409.9899 | 408.15 | 408.905 | 2425706.0 |
| 2024-01-12 11:00:00 | QQQ | ETF | 408.91 | 410.13 | 408.67 | 409.8 | 1806775.0 |
| 2024-01-12 11:30:00 | QQQ | ETF | 409.81 | 409.955 | 408.36 | 408.515 | 1782659.0 |
| 2024-01-12 12:00:00 | QQQ | ETF | 408.54 | 409.2792 | 408.26 | 408.88 | 1391126.0 |
| 2024-01-12 12:30:00 | QQQ | ETF | 408.9 | 409.39 | 408.58 | 409.12 | 1093392.0 |
> showing 50 of 30,864 rows — these rows as CSV