PREVIEW / etf_5min / 2022-09-22
file: by_date/etf_5min/2022/2022-09-22.parquet size: 2.0 MB rows: 98,388
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-09-22 04:00:00 | SPY | ETF | 378.23 | 378.9 | 377.02 | 378.7 | 7864.0 |
| 2022-09-22 04:05:00 | SPY | ETF | 378.82 | 379.03 | 378.43 | 378.57 | 10644.0 |
| 2022-09-22 04:10:00 | SPY | ETF | 378.62 | 378.79 | 378.47 | 378.5 | 5075.0 |
| 2022-09-22 04:15:00 | SPY | ETF | 378.55 | 378.99 | 378.55 | 378.99 | 12982.0 |
| 2022-09-22 04:20:00 | SPY | ETF | 378.95 | 379.23 | 378.95 | 379.13 | 5410.0 |
| 2022-09-22 04:25:00 | SPY | ETF | 379.07 | 379.16 | 378.87 | 378.99 | 2890.0 |
| 2022-09-22 04:30:00 | SPY | ETF | 379.18 | 379.32 | 379.02 | 379.32 | 4205.0 |
| 2022-09-22 04:35:00 | SPY | ETF | 379.28 | 379.65 | 379.28 | 379.53 | 11267.0 |
| 2022-09-22 04:40:00 | SPY | ETF | 379.53 | 380.0 | 379.53 | 380.0 | 13984.0 |
| 2022-09-22 04:45:00 | SPY | ETF | 380.07 | 380.32 | 379.38 | 379.38 | 17885.0 |
| 2022-09-22 04:50:00 | SPY | ETF | 379.38 | 379.61 | 379.1 | 379.2 | 14101.0 |
| 2022-09-22 04:55:00 | SPY | ETF | 379.13 | 379.32 | 379.04 | 379.29 | 6203.0 |
| 2022-09-22 05:00:00 | SPY | ETF | 379.23 | 379.23 | 378.65 | 378.79 | 10659.0 |
| 2022-09-22 05:05:00 | SPY | ETF | 378.69 | 378.71 | 378.09 | 378.16 | 18506.0 |
| 2022-09-22 05:10:00 | SPY | ETF | 378.2 | 378.57 | 378.2 | 378.57 | 8290.0 |
| 2022-09-22 05:15:00 | SPY | ETF | 378.57 | 378.63 | 378.22 | 378.22 | 2450.0 |
| 2022-09-22 05:20:00 | SPY | ETF | 378.4 | 378.45 | 378.06 | 378.13 | 7150.0 |
| 2022-09-22 05:25:00 | SPY | ETF | 378.11 | 378.28 | 378.06 | 378.2 | 2428.0 |
| 2022-09-22 05:30:00 | SPY | ETF | 378.43 | 378.64 | 378.43 | 378.48 | 4075.0 |
| 2022-09-22 05:35:00 | SPY | ETF | 378.2 | 378.25 | 377.63 | 377.63 | 9569.0 |
| 2022-09-22 05:40:00 | SPY | ETF | 377.58 | 377.63 | 377.3 | 377.51 | 16837.0 |
| 2022-09-22 05:45:00 | SPY | ETF | 377.55 | 377.73 | 377.42 | 377.46 | 5400.0 |
| 2022-09-22 05:50:00 | SPY | ETF | 377.51 | 377.7 | 377.35 | 377.7 | 1519.0 |
| 2022-09-22 05:55:00 | SPY | ETF | 377.69 | 377.96 | 377.69 | 377.88 | 7576.0 |
| 2022-09-22 06:00:00 | SPY | ETF | 377.75 | 377.75 | 377.21 | 377.3 | 4891.0 |
| 2022-09-22 06:05:00 | SPY | ETF | 377.3 | 377.5 | 377.3 | 377.5 | 2554.0 |
| 2022-09-22 06:10:00 | SPY | ETF | 377.34 | 377.34 | 377.29 | 377.33 | 687.0 |
| 2022-09-22 06:15:00 | SPY | ETF | 377.3 | 377.48 | 377.3 | 377.48 | 1895.0 |
| 2022-09-22 06:20:00 | SPY | ETF | 377.48 | 377.8 | 377.44 | 377.78 | 6706.0 |
| 2022-09-22 06:25:00 | SPY | ETF | 377.69 | 378.08 | 377.67 | 378.05 | 8591.0 |
| 2022-09-22 06:30:00 | SPY | ETF | 378.06 | 378.52 | 378.06 | 378.47 | 22029.0 |
| 2022-09-22 06:35:00 | SPY | ETF | 378.48 | 378.6 | 378.37 | 378.51 | 7762.0 |
| 2022-09-22 06:40:00 | SPY | ETF | 378.31 | 378.38 | 378.01 | 378.06 | 3400.0 |
| 2022-09-22 06:45:00 | SPY | ETF | 378.15 | 378.15 | 377.87 | 377.87 | 600.0 |
| 2022-09-22 06:50:00 | SPY | ETF | 377.91 | 378.47 | 377.91 | 378.41 | 12121.0 |
| 2022-09-22 06:55:00 | SPY | ETF | 378.38 | 378.4 | 378.25 | 378.4 | 1200.0 |
| 2022-09-22 07:00:00 | SPY | ETF | 378.31 | 378.57 | 377.34 | 378.11 | 37652.0 |
| 2022-09-22 07:05:00 | SPY | ETF | 377.99 | 378.05 | 377.15 | 377.15 | 22821.0 |
| 2022-09-22 07:10:00 | SPY | ETF | 377.19 | 377.19 | 376.78 | 376.82 | 61137.0 |
| 2022-09-22 07:15:00 | SPY | ETF | 376.79 | 377.28 | 376.79 | 377.2 | 78136.0 |
| 2022-09-22 07:20:00 | SPY | ETF | 377.24 | 377.24 | 376.65 | 376.91 | 42677.0 |
| 2022-09-22 07:25:00 | SPY | ETF | 376.96 | 376.98 | 376.17 | 376.21 | 45332.0 |
| 2022-09-22 07:30:00 | SPY | ETF | 376.21 | 376.61 | 376.21 | 376.46 | 9895.0 |
| 2022-09-22 07:35:00 | SPY | ETF | 376.48 | 377.05 | 376.48 | 377.03 | 33533.0 |
| 2022-09-22 07:40:00 | SPY | ETF | 377.02 | 377.2 | 376.76 | 377.2 | 27840.0 |
| 2022-09-22 07:45:00 | SPY | ETF | 377.11 | 377.11 | 376.65 | 376.93 | 44627.0 |
| 2022-09-22 07:50:00 | SPY | ETF | 377.0 | 377.57 | 377.0 | 377.57 | 33897.0 |
| 2022-09-22 07:55:00 | SPY | ETF | 377.58 | 377.93 | 377.58 | 377.79 | 36143.0 |
| 2022-09-22 08:00:00 | SPY | ETF | 378.48 | 379.15 | 375.19 | 377.81 | 127151.0 |
| 2022-09-22 08:05:00 | SPY | ETF | 377.83 | 377.87 | 377.39 | 377.8 | 32395.0 |
> showing 50 of 98,388 rows — these rows as CSV