PREVIEW / etf_5min / 2024-10-29
file: by_date/etf_5min/2024/2024-10-29.parquet size: 2.4 MB rows: 118,643
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-10-29 04:00:00 | SPY | ETF | 581.19 | 581.19 | 580.95 | 580.95 | 5629.0 |
| 2024-10-29 04:05:00 | SPY | ETF | 580.91 | 580.95 | 580.75 | 580.75 | 10458.0 |
| 2024-10-29 04:10:00 | SPY | ETF | 580.84 | 581.01 | 580.84 | 580.97 | 726.0 |
| 2024-10-29 04:15:00 | SPY | ETF | 580.92 | 580.92 | 580.41 | 580.41 | 4903.0 |
| 2024-10-29 04:20:00 | SPY | ETF | 580.44 | 580.45 | 580.21 | 580.44 | 2240.0 |
| 2024-10-29 04:25:00 | SPY | ETF | 580.49 | 581.06 | 580.49 | 581.04 | 2694.0 |
| 2024-10-29 04:30:00 | SPY | ETF | 581.13 | 581.15 | 581.13 | 581.13 | 574.0 |
| 2024-10-29 04:35:00 | SPY | ETF | 581.14 | 581.2 | 581.14 | 581.2 | 236.0 |
| 2024-10-29 04:40:00 | SPY | ETF | 581.43 | 581.45 | 581.43 | 581.43 | 1281.0 |
| 2024-10-29 04:45:00 | SPY | ETF | 581.5 | 581.5 | 581.47 | 581.47 | 511.0 |
| 2024-10-29 04:50:00 | SPY | ETF | 581.48 | 581.56 | 581.48 | 581.56 | 900.0 |
| 2024-10-29 04:55:00 | SPY | ETF | 581.06 | 581.2 | 580.97 | 581.2 | 1835.0 |
| 2024-10-29 05:00:00 | SPY | ETF | 581.11 | 581.11 | 580.84 | 580.93 | 3070.0 |
| 2024-10-29 05:05:00 | SPY | ETF | 580.99 | 580.99 | 580.97 | 580.97 | 400.0 |
| 2024-10-29 05:10:00 | SPY | ETF | 580.8 | 580.8 | 580.69 | 580.7 | 300.0 |
| 2024-10-29 05:15:00 | SPY | ETF | 580.81 | 580.81 | 580.61 | 580.76 | 1348.0 |
| 2024-10-29 05:20:00 | SPY | ETF | 580.75 | 580.99 | 580.75 | 580.98 | 2374.0 |
| 2024-10-29 05:25:00 | SPY | ETF | 580.95 | 581.1 | 580.95 | 581.02 | 474.0 |
| 2024-10-29 05:30:00 | SPY | ETF | 580.93 | 580.95 | 580.93 | 580.95 | 3000.0 |
| 2024-10-29 05:45:00 | SPY | ETF | 580.89 | 580.9 | 580.88 | 580.89 | 6348.0 |
| 2024-10-29 05:50:00 | SPY | ETF | 580.86 | 580.95 | 580.81 | 580.82 | 1099.0 |
| 2024-10-29 05:55:00 | SPY | ETF | 580.88 | 580.93 | 580.86 | 580.93 | 1466.0 |
| 2024-10-29 06:00:00 | SPY | ETF | 580.99 | 580.99 | 580.95 | 580.95 | 270.0 |
| 2024-10-29 06:05:00 | SPY | ETF | 580.59 | 580.6 | 580.46 | 580.59 | 1600.0 |
| 2024-10-29 06:10:00 | SPY | ETF | 580.59 | 580.76 | 580.59 | 580.76 | 917.0 |
| 2024-10-29 06:15:00 | SPY | ETF | 580.7 | 580.7 | 580.54 | 580.62 | 1987.0 |
| 2024-10-29 06:25:00 | SPY | ETF | 580.48 | 580.5 | 580.48 | 580.5 | 4173.0 |
| 2024-10-29 06:30:00 | SPY | ETF | 580.64 | 580.67 | 580.64 | 580.67 | 668.0 |
| 2024-10-29 06:35:00 | SPY | ETF | 580.55 | 580.55 | 580.55 | 580.55 | 187.0 |
| 2024-10-29 06:45:00 | SPY | ETF | 580.71 | 580.82 | 580.69 | 580.82 | 883.0 |
| 2024-10-29 06:50:00 | SPY | ETF | 580.72 | 580.79 | 580.72 | 580.76 | 3400.0 |
| 2024-10-29 06:55:00 | SPY | ETF | 580.75 | 580.76 | 580.75 | 580.76 | 500.0 |
| 2024-10-29 07:00:00 | SPY | ETF | 580.65 | 580.7 | 580.29 | 580.5 | 9688.0 |
| 2024-10-29 07:05:00 | SPY | ETF | 580.5 | 580.51 | 580.18 | 580.18 | 2647.0 |
| 2024-10-29 07:10:00 | SPY | ETF | 580.24 | 580.3 | 580.16 | 580.25 | 15138.0 |
| 2024-10-29 07:15:00 | SPY | ETF | 580.21 | 580.43 | 580.15 | 580.15 | 5921.0 |
| 2024-10-29 07:20:00 | SPY | ETF | 580.2 | 580.25 | 580.18 | 580.22 | 7917.0 |
| 2024-10-29 07:25:00 | SPY | ETF | 580.28 | 580.29 | 580.1 | 580.14 | 9512.0 |
| 2024-10-29 07:30:00 | SPY | ETF | 580.14 | 580.24 | 580.14 | 580.2 | 4262.0 |
| 2024-10-29 07:35:00 | SPY | ETF | 580.09 | 580.14 | 580.09 | 580.14 | 2507.0 |
| 2024-10-29 07:40:00 | SPY | ETF | 580.32 | 580.63 | 580.32 | 580.63 | 3386.0 |
| 2024-10-29 07:45:00 | SPY | ETF | 580.54 | 580.66 | 580.35 | 580.35 | 1390.0 |
| 2024-10-29 07:50:00 | SPY | ETF | 580.42 | 580.42 | 580.24 | 580.25 | 3591.0 |
| 2024-10-29 07:55:00 | SPY | ETF | 580.3 | 580.3 | 580.01 | 580.08 | 3153.0 |
| 2024-10-29 08:00:00 | SPY | ETF | 580.24 | 581.52 | 579.82 | 580.06 | 48242.0 |
| 2024-10-29 08:05:00 | SPY | ETF | 579.98 | 580.05 | 579.91 | 579.91 | 9692.0 |
| 2024-10-29 08:10:00 | SPY | ETF | 579.89 | 579.93 | 579.49 | 579.79 | 109739.0 |
| 2024-10-29 08:15:00 | SPY | ETF | 579.92 | 580.12 | 579.84 | 579.96 | 33092.0 |
| 2024-10-29 08:20:00 | SPY | ETF | 579.96 | 579.96 | 579.6 | 579.76 | 23330.0 |
| 2024-10-29 08:25:00 | SPY | ETF | 579.75 | 580.01 | 579.66 | 579.9794 | 11958.0 |
> showing 50 of 118,643 rows — these rows as CSV