PREVIEW / etf_30min / 2024-01-19
file: by_date/etf_30min/2024/2024-01-19.parquet size: 807 KB rows: 31,672
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-19 04:00:00 | SPY | ETF | 477.84 | 478.58 | 477.2 | 478.55 | 49010.0 |
| 2024-01-19 04:30:00 | SPY | ETF | 478.48 | 478.48 | 477.85 | 478.42 | 20380.0 |
| 2024-01-19 05:00:00 | SPY | ETF | 478.36 | 478.44 | 478.16 | 478.25 | 8894.0 |
| 2024-01-19 05:30:00 | SPY | ETF | 478.26 | 478.65 | 478.16 | 478.62 | 13860.0 |
| 2024-01-19 06:00:00 | SPY | ETF | 478.5 | 478.72 | 478.46 | 478.65 | 6221.0 |
| 2024-01-19 06:30:00 | SPY | ETF | 478.67 | 478.99 | 478.67 | 478.83 | 27908.0 |
| 2024-01-19 07:00:00 | SPY | ETF | 478.88 | 478.9 | 477.92 | 478.55 | 215555.0 |
| 2024-01-19 07:30:00 | SPY | ETF | 478.5 | 478.97 | 478.36 | 478.91 | 180025.0 |
| 2024-01-19 08:00:00 | SPY | ETF | 478.8805 | 479.47 | 476.49 | 476.49 | 331243.0 |
| 2024-01-19 08:30:00 | SPY | ETF | 479.0 | 479.21 | 478.43 | 478.51 | 148585.0 |
| 2024-01-19 09:00:00 | SPY | ETF | 478.51 | 478.63 | 477.56 | 477.65 | 596305.0 |
| 2024-01-19 09:30:00 | SPY | ETF | 477.65 | 477.97 | 476.94 | 477.92 | 6282311.0 |
| 2024-01-19 10:00:00 | SPY | ETF | 477.91 | 478.384 | 476.9901 | 477.95 | 5394295.0 |
| 2024-01-19 10:30:00 | SPY | ETF | 477.94 | 478.56 | 477.34 | 478.2803 | 3897456.0 |
| 2024-01-19 11:00:00 | SPY | ETF | 478.3 | 479.28 | 478.01 | 478.85 | 4008620.0 |
| 2024-01-19 11:30:00 | SPY | ETF | 478.845 | 478.93 | 478.2 | 478.87 | 3485906.0 |
| 2024-01-19 12:00:00 | SPY | ETF | 478.88 | 479.51 | 478.28 | 479.35 | 2819545.0 |
| 2024-01-19 12:30:00 | SPY | ETF | 479.38 | 480.2 | 479.28 | 480.195 | 4518498.0 |
| 2024-01-19 13:00:00 | SPY | ETF | 480.2 | 481.0 | 479.73 | 480.96 | 4308766.0 |
| 2024-01-19 13:30:00 | SPY | ETF | 480.9501 | 481.71 | 480.94 | 481.6694 | 3838671.0 |
| 2024-01-19 14:00:00 | SPY | ETF | 481.67 | 482.72 | 481.524 | 481.97 | 6032482.0 |
| 2024-01-19 14:30:00 | SPY | ETF | 481.97 | 482.25 | 481.33 | 482.21 | 4660119.0 |
| 2024-01-19 15:00:00 | SPY | ETF | 482.21 | 482.55 | 481.79 | 482.14 | 4545264.0 |
| 2024-01-19 15:30:00 | SPY | ETF | 482.14 | 482.48 | 481.835 | 482.42 | 9854533.0 |
| 2024-01-19 16:00:00 | SPY | ETF | 482.43 | 482.74 | 482.11 | 482.62 | 5797023.0 |
| 2024-01-19 16:30:00 | SPY | ETF | 482.61 | 482.75 | 478.4765 | 482.38 | 433298.0 |
| 2024-01-19 17:00:00 | SPY | ETF | 482.43 | 482.5 | 482.31 | 482.45 | 55866.0 |
| 2024-01-19 17:30:00 | SPY | ETF | 482.45 | 482.45 | 482.31 | 482.37 | 38476.0 |
| 2024-01-19 18:00:00 | SPY | ETF | 482.37 | 482.52 | 482.36 | 482.43 | 249272.0 |
| 2024-01-19 18:30:00 | SPY | ETF | 482.48 | 482.48 | 482.44 | 482.48 | 11049.0 |
| 2024-01-19 19:00:00 | SPY | ETF | 482.48 | 482.52 | 482.46 | 482.52 | 27846.0 |
| 2024-01-19 19:30:00 | SPY | ETF | 482.55 | 482.65 | 482.54 | 482.64 | 15334.0 |
| 2024-01-19 04:00:00 | QQQ | ETF | 414.75 | 416.3 | 414.75 | 416.25 | 60992.0 |
| 2024-01-19 04:30:00 | QQQ | ETF | 416.2 | 416.2 | 415.49 | 416.1 | 48359.0 |
| 2024-01-19 05:00:00 | QQQ | ETF | 416.05 | 416.1 | 415.78 | 415.9 | 31611.0 |
| 2024-01-19 05:30:00 | QQQ | ETF | 415.92 | 416.5 | 415.91 | 416.34 | 31099.0 |
| 2024-01-19 06:00:00 | QQQ | ETF | 416.26 | 416.44 | 416.17 | 416.31 | 37598.0 |
| 2024-01-19 06:30:00 | QQQ | ETF | 416.31 | 416.69 | 416.31 | 416.61 | 35876.0 |
| 2024-01-19 07:00:00 | QQQ | ETF | 416.55 | 416.61 | 415.82 | 415.95 | 166529.0 |
| 2024-01-19 07:30:00 | QQQ | ETF | 415.97 | 416.39 | 415.67 | 416.35 | 201400.0 |
| 2024-01-19 08:00:00 | QQQ | ETF | 416.51 | 416.71 | 414.31 | 416.23 | 338640.0 |
| 2024-01-19 08:30:00 | QQQ | ETF | 416.22 | 416.46 | 415.85 | 415.93 | 116327.0 |
| 2024-01-19 09:00:00 | QQQ | ETF | 415.91 | 416.07 | 415.19 | 415.19 | 259006.0 |
| 2024-01-19 09:30:00 | QQQ | ETF | 415.22 | 415.75 | 414.625 | 415.71 | 6317019.0 |
| 2024-01-19 10:00:00 | QQQ | ETF | 415.73 | 416.21 | 414.6906 | 415.82 | 3381537.0 |
| 2024-01-19 10:30:00 | QQQ | ETF | 415.81 | 416.44 | 415.265 | 416.0612 | 2238138.0 |
| 2024-01-19 11:00:00 | QQQ | ETF | 416.08 | 417.12 | 415.74 | 416.78 | 2541716.0 |
| 2024-01-19 11:30:00 | QQQ | ETF | 416.8 | 417.07 | 416.05 | 416.9808 | 2489040.0 |
| 2024-01-19 12:00:00 | QQQ | ETF | 416.98 | 417.65 | 416.2799 | 417.512 | 2494799.0 |
| 2024-01-19 12:30:00 | QQQ | ETF | 417.52 | 418.41 | 417.45 | 418.405 | 2963259.0 |
> showing 50 of 31,672 rows — these rows as CSV