PREVIEW / etf_5min / 2024-12-23
file: by_date/etf_5min/2024/2024-12-23.parquet size: 2.7 MB rows: 134,406
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-12-23 04:00:00 | SPY | ETF | 593.58 | 593.58 | 592.64 | 592.69 | 12109.0 |
| 2024-12-23 04:05:00 | SPY | ETF | 592.67 | 593.11 | 592.67 | 593.09 | 3274.0 |
| 2024-12-23 04:10:00 | SPY | ETF | 593.03 | 593.03 | 592.71 | 592.78 | 2296.0 |
| 2024-12-23 04:15:00 | SPY | ETF | 592.78 | 592.86 | 592.6 | 592.6 | 1881.0 |
| 2024-12-23 04:20:00 | SPY | ETF | 592.6 | 592.88 | 592.46 | 592.46 | 689.0 |
| 2024-12-23 04:25:00 | SPY | ETF | 592.59 | 592.6 | 592.59 | 592.6 | 249.0 |
| 2024-12-23 04:30:00 | SPY | ETF | 592.84 | 592.84 | 592.75 | 592.8 | 650.0 |
| 2024-12-23 04:35:00 | SPY | ETF | 592.78 | 592.91 | 592.78 | 592.91 | 1064.0 |
| 2024-12-23 04:40:00 | SPY | ETF | 592.99 | 593.08 | 592.87 | 592.87 | 1560.0 |
| 2024-12-23 04:45:00 | SPY | ETF | 593.01 | 593.08 | 592.88 | 593.0 | 18616.0 |
| 2024-12-23 04:50:00 | SPY | ETF | 593.03 | 593.03 | 592.7 | 592.7 | 4081.0 |
| 2024-12-23 04:55:00 | SPY | ETF | 592.72 | 592.76 | 592.72 | 592.74 | 1267.0 |
| 2024-12-23 05:05:00 | SPY | ETF | 592.7 | 592.7 | 592.7 | 592.7 | 100.0 |
| 2024-12-23 05:10:00 | SPY | ETF | 592.9 | 592.9 | 592.67 | 592.67 | 687.0 |
| 2024-12-23 05:15:00 | SPY | ETF | 592.58 | 592.67 | 592.5 | 592.67 | 1546.0 |
| 2024-12-23 05:20:00 | SPY | ETF | 592.55 | 592.55 | 592.06 | 592.06 | 2782.0 |
| 2024-12-23 05:25:00 | SPY | ETF | 592.11 | 592.22 | 592.03 | 592.22 | 5331.0 |
| 2024-12-23 05:30:00 | SPY | ETF | 592.02 | 592.12 | 591.77 | 592.0 | 4577.0 |
| 2024-12-23 05:35:00 | SPY | ETF | 591.84 | 591.84 | 591.84 | 591.84 | 100.0 |
| 2024-12-23 05:40:00 | SPY | ETF | 592.05 | 592.05 | 591.8 | 591.8 | 1004.0 |
| 2024-12-23 05:45:00 | SPY | ETF | 591.79 | 591.84 | 591.47 | 591.5 | 3088.0 |
| 2024-12-23 05:50:00 | SPY | ETF | 591.61 | 591.61 | 591.54 | 591.54 | 875.0 |
| 2024-12-23 05:55:00 | SPY | ETF | 591.73 | 591.73 | 591.73 | 591.73 | 100.0 |
| 2024-12-23 06:00:00 | SPY | ETF | 591.35 | 591.35 | 591.2 | 591.2 | 2561.0 |
| 2024-12-23 06:05:00 | SPY | ETF | 591.21 | 591.21 | 590.9 | 591.0 | 6687.0 |
| 2024-12-23 06:10:00 | SPY | ETF | 591.0 | 591.23 | 590.99 | 591.23 | 1467.0 |
| 2024-12-23 06:15:00 | SPY | ETF | 591.1 | 591.1 | 590.91 | 590.91 | 670.0 |
| 2024-12-23 06:20:00 | SPY | ETF | 591.01 | 591.01 | 590.59 | 590.6 | 1376.0 |
| 2024-12-23 06:25:00 | SPY | ETF | 590.51 | 590.57 | 590.4 | 590.4 | 3370.0 |
| 2024-12-23 06:30:00 | SPY | ETF | 590.39 | 590.76 | 590.39 | 590.5 | 3721.0 |
| 2024-12-23 06:35:00 | SPY | ETF | 590.45 | 590.64 | 590.43 | 590.64 | 4050.0 |
| 2024-12-23 06:40:00 | SPY | ETF | 590.59 | 590.69 | 590.55 | 590.56 | 1577.0 |
| 2024-12-23 06:45:00 | SPY | ETF | 590.5 | 590.5 | 590.16 | 590.16 | 8634.0 |
| 2024-12-23 06:50:00 | SPY | ETF | 590.5 | 590.71 | 590.33 | 590.34 | 12335.0 |
| 2024-12-23 06:55:00 | SPY | ETF | 590.33 | 590.47 | 590.33 | 590.41 | 2099.0 |
| 2024-12-23 07:00:00 | SPY | ETF | 590.46 | 590.77 | 590.46 | 590.73 | 11756.0 |
| 2024-12-23 07:05:00 | SPY | ETF | 590.9 | 590.99 | 590.78 | 590.95 | 12537.0 |
| 2024-12-23 07:10:00 | SPY | ETF | 591.1 | 591.28 | 590.99 | 591.23 | 18142.0 |
| 2024-12-23 07:15:00 | SPY | ETF | 591.22 | 591.27 | 591.01 | 591.201 | 8621.0 |
| 2024-12-23 07:20:00 | SPY | ETF | 591.18 | 591.69 | 591.18 | 591.62 | 10763.0 |
| 2024-12-23 07:25:00 | SPY | ETF | 591.6 | 591.61 | 591.381 | 591.47 | 5960.0 |
| 2024-12-23 07:30:00 | SPY | ETF | 591.56 | 591.65 | 591.41 | 591.5 | 7592.0 |
| 2024-12-23 07:35:00 | SPY | ETF | 591.51 | 591.52 | 591.3 | 591.36 | 14101.0 |
| 2024-12-23 07:40:00 | SPY | ETF | 591.41 | 591.63 | 591.39 | 591.44 | 11926.0 |
| 2024-12-23 07:45:00 | SPY | ETF | 591.6 | 591.74 | 591.57 | 591.7 | 43958.0 |
| 2024-12-23 07:50:00 | SPY | ETF | 591.67 | 591.92 | 591.62 | 591.78 | 23824.0 |
| 2024-12-23 07:55:00 | SPY | ETF | 591.75 | 591.82 | 591.69 | 591.78 | 6964.0 |
| 2024-12-23 08:00:00 | SPY | ETF | 590.68 | 594.0 | 590.56 | 591.39 | 63733.0 |
| 2024-12-23 08:05:00 | SPY | ETF | 591.34 | 591.64 | 591.34 | 591.4 | 12727.0 |
| 2024-12-23 08:10:00 | SPY | ETF | 591.54 | 591.62 | 591.3396 | 591.3396 | 18254.0 |
> showing 50 of 134,406 rows — these rows as CSV