PREVIEW / etf_5min / 2022-08-31
file: by_date/etf_5min/2022/2022-08-31.parquet size: 1.9 MB rows: 91,895
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-08-31 04:00:00 | SPY | ETF | 398.98 | 399.52 | 398.83 | 399.25 | 9132.0 |
| 2022-08-31 04:05:00 | SPY | ETF | 399.16 | 399.28 | 398.91 | 398.91 | 4379.0 |
| 2022-08-31 04:10:00 | SPY | ETF | 399.05 | 399.16 | 398.79 | 398.79 | 4244.0 |
| 2022-08-31 04:15:00 | SPY | ETF | 398.85 | 399.16 | 398.81 | 399.15 | 3557.0 |
| 2022-08-31 04:20:00 | SPY | ETF | 398.99 | 398.99 | 398.41 | 398.48 | 2114.0 |
| 2022-08-31 04:25:00 | SPY | ETF | 398.51 | 398.55 | 398.34 | 398.51 | 2527.0 |
| 2022-08-31 04:30:00 | SPY | ETF | 398.48 | 398.48 | 398.35 | 398.38 | 900.0 |
| 2022-08-31 04:35:00 | SPY | ETF | 398.18 | 398.45 | 398.18 | 398.45 | 1361.0 |
| 2022-08-31 04:40:00 | SPY | ETF | 398.62 | 398.82 | 398.5 | 398.81 | 2250.0 |
| 2022-08-31 04:45:00 | SPY | ETF | 398.98 | 399.11 | 398.98 | 399.08 | 2187.0 |
| 2022-08-31 04:50:00 | SPY | ETF | 399.05 | 399.05 | 398.96 | 398.96 | 7250.0 |
| 2022-08-31 04:55:00 | SPY | ETF | 398.91 | 398.91 | 398.63 | 398.66 | 5500.0 |
| 2022-08-31 05:00:00 | SPY | ETF | 398.62 | 398.62 | 398.2 | 398.27 | 11050.0 |
| 2022-08-31 05:05:00 | SPY | ETF | 398.26 | 398.26 | 398.0 | 398.09 | 2980.0 |
| 2022-08-31 05:10:00 | SPY | ETF | 398.01 | 398.05 | 397.7 | 397.7 | 8823.0 |
| 2022-08-31 05:15:00 | SPY | ETF | 397.77 | 398.12 | 397.72 | 398.12 | 3875.0 |
| 2022-08-31 05:25:00 | SPY | ETF | 397.85 | 397.89 | 397.8 | 397.86 | 4018.0 |
| 2022-08-31 05:30:00 | SPY | ETF | 397.77 | 397.88 | 397.62 | 397.81 | 5350.0 |
| 2022-08-31 05:35:00 | SPY | ETF | 397.86 | 398.0 | 397.58 | 397.62 | 4400.0 |
| 2022-08-31 05:40:00 | SPY | ETF | 397.74 | 397.99 | 397.74 | 397.99 | 3700.0 |
| 2022-08-31 05:45:00 | SPY | ETF | 398.11 | 398.11 | 397.58 | 397.7 | 3210.0 |
| 2022-08-31 05:50:00 | SPY | ETF | 397.82 | 398.17 | 397.82 | 398.17 | 2717.0 |
| 2022-08-31 05:55:00 | SPY | ETF | 397.77 | 398.0 | 397.77 | 398.0 | 1510.0 |
| 2022-08-31 06:00:00 | SPY | ETF | 398.06 | 398.06 | 397.59 | 397.88 | 2850.0 |
| 2022-08-31 06:05:00 | SPY | ETF | 397.95 | 398.03 | 397.86 | 398.0 | 1933.0 |
| 2022-08-31 06:10:00 | SPY | ETF | 398.06 | 398.59 | 398.06 | 398.54 | 4277.0 |
| 2022-08-31 06:15:00 | SPY | ETF | 398.64 | 398.67 | 398.42 | 398.42 | 518.0 |
| 2022-08-31 06:20:00 | SPY | ETF | 398.66 | 398.89 | 398.6 | 398.86 | 2100.0 |
| 2022-08-31 06:25:00 | SPY | ETF | 398.97 | 399.08 | 398.85 | 398.96 | 11850.0 |
| 2022-08-31 06:30:00 | SPY | ETF | 398.77 | 398.83 | 398.39 | 398.4 | 6775.0 |
| 2022-08-31 06:35:00 | SPY | ETF | 398.52 | 399.12 | 398.5 | 399.1 | 7555.0 |
| 2022-08-31 06:40:00 | SPY | ETF | 399.1 | 399.27 | 398.97 | 398.97 | 7369.0 |
| 2022-08-31 06:45:00 | SPY | ETF | 399.11 | 399.41 | 399.01 | 399.41 | 4570.0 |
| 2022-08-31 06:50:00 | SPY | ETF | 399.4 | 399.92 | 399.4 | 399.81 | 29175.0 |
| 2022-08-31 06:55:00 | SPY | ETF | 399.6 | 399.6 | 399.35 | 399.35 | 4109.0 |
| 2022-08-31 07:00:00 | SPY | ETF | 399.26 | 399.64 | 399.2 | 399.6 | 38048.0 |
| 2022-08-31 07:05:00 | SPY | ETF | 399.59 | 399.59 | 399.25 | 399.29 | 7398.0 |
| 2022-08-31 07:10:00 | SPY | ETF | 399.27 | 399.36 | 399.01 | 399.16 | 11963.0 |
| 2022-08-31 07:15:00 | SPY | ETF | 399.05 | 399.69 | 399.05 | 399.69 | 5675.0 |
| 2022-08-31 07:20:00 | SPY | ETF | 399.69 | 399.84 | 399.5 | 399.65 | 22408.0 |
| 2022-08-31 07:25:00 | SPY | ETF | 399.64 | 399.64 | 399.25 | 399.25 | 11650.0 |
| 2022-08-31 07:30:00 | SPY | ETF | 399.37 | 399.46 | 399.1 | 399.1 | 4938.0 |
| 2022-08-31 07:35:00 | SPY | ETF | 399.11 | 399.29 | 398.88 | 398.88 | 4422.0 |
| 2022-08-31 07:40:00 | SPY | ETF | 398.91 | 399.11 | 398.88 | 399.08 | 3559.0 |
| 2022-08-31 07:45:00 | SPY | ETF | 399.01 | 399.01 | 398.77 | 398.77 | 16830.0 |
| 2022-08-31 07:50:00 | SPY | ETF | 398.78 | 399.09 | 398.76 | 399.05 | 5141.0 |
| 2022-08-31 07:55:00 | SPY | ETF | 399.0 | 399.32 | 399.0 | 399.32 | 25331.0 |
| 2022-08-31 08:00:00 | SPY | ETF | 399.25 | 401.11 | 397.7696 | 399.74 | 112385.0 |
| 2022-08-31 08:05:00 | SPY | ETF | 399.74 | 399.9 | 399.54 | 399.66 | 41115.0 |
| 2022-08-31 08:10:00 | SPY | ETF | 399.7 | 399.83 | 399.56 | 399.645 | 57590.0 |
> showing 50 of 91,895 rows — these rows as CSV