PREVIEW / etf_5min / 2022-01-25
file: by_date/etf_5min/2022/2022-01-25.parquet size: 2.1 MB rows: 103,279
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-25 04:00:00 | SPY | ETF | 434.95 | 435.49 | 433.22 | 433.59 | 42462.0 |
| 2022-01-25 04:05:00 | SPY | ETF | 433.54 | 433.86 | 433.48 | 433.86 | 7809.0 |
| 2022-01-25 04:10:00 | SPY | ETF | 434.14 | 434.14 | 433.58 | 433.79 | 11045.0 |
| 2022-01-25 04:15:00 | SPY | ETF | 434.15 | 434.44 | 434.12 | 434.16 | 3302.0 |
| 2022-01-25 04:20:00 | SPY | ETF | 434.1 | 435.25 | 434.08 | 435.24 | 10006.0 |
| 2022-01-25 04:25:00 | SPY | ETF | 435.37 | 436.1 | 435.22 | 436.1 | 12497.0 |
| 2022-01-25 04:30:00 | SPY | ETF | 435.94 | 436.24 | 435.9 | 436.24 | 1118.0 |
| 2022-01-25 04:35:00 | SPY | ETF | 435.72 | 436.04 | 435.64 | 436.0 | 4273.0 |
| 2022-01-25 04:40:00 | SPY | ETF | 435.96 | 436.25 | 435.6 | 436.25 | 14975.0 |
| 2022-01-25 04:45:00 | SPY | ETF | 436.32 | 436.91 | 436.32 | 436.69 | 16638.0 |
| 2022-01-25 04:50:00 | SPY | ETF | 436.69 | 437.2 | 436.69 | 437.2 | 19440.0 |
| 2022-01-25 04:55:00 | SPY | ETF | 437.16 | 437.4 | 436.63 | 436.89 | 8851.0 |
| 2022-01-25 05:00:00 | SPY | ETF | 436.91 | 436.97 | 436.37 | 436.37 | 1677.0 |
| 2022-01-25 05:05:00 | SPY | ETF | 436.3 | 437.19 | 436.29 | 437.0 | 7780.0 |
| 2022-01-25 05:10:00 | SPY | ETF | 437.05 | 437.1 | 436.9 | 437.1 | 3951.0 |
| 2022-01-25 05:15:00 | SPY | ETF | 437.33 | 437.7 | 437.15 | 437.7 | 3409.0 |
| 2022-01-25 05:20:00 | SPY | ETF | 437.57 | 437.57 | 437.21 | 437.52 | 4151.0 |
| 2022-01-25 05:25:00 | SPY | ETF | 437.2 | 437.2 | 437.02 | 437.14 | 7414.0 |
| 2022-01-25 05:30:00 | SPY | ETF | 437.1 | 437.12 | 436.7 | 436.7 | 13900.0 |
| 2022-01-25 05:35:00 | SPY | ETF | 436.78 | 436.78 | 435.71 | 435.95 | 25557.0 |
| 2022-01-25 05:40:00 | SPY | ETF | 436.05 | 436.07 | 435.71 | 435.71 | 1915.0 |
| 2022-01-25 05:45:00 | SPY | ETF | 435.5 | 435.76 | 434.99 | 435.05 | 18092.0 |
| 2022-01-25 05:50:00 | SPY | ETF | 434.89 | 435.24 | 434.89 | 435.07 | 10161.0 |
| 2022-01-25 05:55:00 | SPY | ETF | 435.13 | 435.44 | 434.71 | 435.19 | 14828.0 |
| 2022-01-25 06:00:00 | SPY | ETF | 435.1 | 435.9 | 435.07 | 435.87 | 4498.0 |
| 2022-01-25 06:05:00 | SPY | ETF | 435.8 | 436.07 | 435.5 | 435.88 | 5266.0 |
| 2022-01-25 06:10:00 | SPY | ETF | 435.92 | 435.93 | 435.85 | 435.93 | 1540.0 |
| 2022-01-25 06:15:00 | SPY | ETF | 436.17 | 436.35 | 435.52 | 435.52 | 33641.0 |
| 2022-01-25 06:20:00 | SPY | ETF | 435.49 | 435.74 | 435.41 | 435.7 | 31529.0 |
| 2022-01-25 06:25:00 | SPY | ETF | 435.72 | 435.72 | 435.38 | 435.48 | 25372.0 |
| 2022-01-25 06:30:00 | SPY | ETF | 435.35 | 435.59 | 434.75 | 434.9 | 40787.0 |
| 2022-01-25 06:35:00 | SPY | ETF | 435.0 | 435.26 | 434.7 | 434.74 | 21450.0 |
| 2022-01-25 06:40:00 | SPY | ETF | 434.72 | 434.85 | 433.77 | 434.02 | 88906.0 |
| 2022-01-25 06:45:00 | SPY | ETF | 433.89 | 434.22 | 433.85 | 434.08 | 25738.0 |
| 2022-01-25 06:50:00 | SPY | ETF | 434.03 | 434.17 | 433.91 | 433.97 | 14932.0 |
| 2022-01-25 06:55:00 | SPY | ETF | 433.98 | 434.58 | 433.76 | 434.2 | 55842.0 |
| 2022-01-25 07:00:00 | SPY | ETF | 434.17 | 434.289 | 433.49 | 433.49 | 58182.0 |
| 2022-01-25 07:05:00 | SPY | ETF | 433.53 | 433.97 | 433.436 | 433.96 | 18821.0 |
| 2022-01-25 07:10:00 | SPY | ETF | 433.98 | 434.67 | 433.97 | 434.3 | 28242.0 |
| 2022-01-25 07:15:00 | SPY | ETF | 434.3 | 434.49 | 434.01 | 434.41 | 42532.0 |
| 2022-01-25 07:20:00 | SPY | ETF | 434.31 | 434.68 | 433.63 | 433.63 | 15872.0 |
| 2022-01-25 07:25:00 | SPY | ETF | 433.71 | 434.21 | 433.68 | 434.2 | 17076.0 |
| 2022-01-25 07:30:00 | SPY | ETF | 434.07 | 434.08 | 433.3 | 433.6 | 48412.0 |
| 2022-01-25 07:35:00 | SPY | ETF | 433.59 | 433.9 | 433.37 | 433.52 | 80012.0 |
| 2022-01-25 07:40:00 | SPY | ETF | 433.51 | 433.58 | 432.91 | 433.57 | 36816.0 |
| 2022-01-25 07:45:00 | SPY | ETF | 433.71 | 433.82 | 433.33 | 433.73 | 50165.0 |
| 2022-01-25 07:50:00 | SPY | ETF | 433.75 | 433.93 | 433.62 | 433.78 | 29601.0 |
| 2022-01-25 07:55:00 | SPY | ETF | 433.82 | 433.86 | 433.24 | 433.39 | 41494.0 |
| 2022-01-25 08:00:00 | SPY | ETF | 434.14 | 440.169 | 432.8004 | 432.8004 | 146290.0 |
| 2022-01-25 08:05:00 | SPY | ETF | 432.86 | 433.04 | 431.43 | 431.43 | 254353.0 |
> showing 50 of 103,279 rows — these rows as CSV