PREVIEW / etf_5min / 2022-09-15
file: by_date/etf_5min/2022/2022-09-15.parquet size: 1.9 MB rows: 90,346
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-15 04:00:00 | SPY | ETF | 395.62 | 395.89 | 395.55 | 395.55 | 42388.0 |
| 2022-09-15 04:05:00 | SPY | ETF | 395.59 | 395.61 | 395.38 | 395.41 | 11348.0 |
| 2022-09-15 04:10:00 | SPY | ETF | 395.41 | 395.41 | 395.1 | 395.1 | 10071.0 |
| 2022-09-15 04:15:00 | SPY | ETF | 395.06 | 395.08 | 394.9 | 394.9 | 26401.0 |
| 2022-09-15 04:20:00 | SPY | ETF | 394.86 | 395.01 | 394.86 | 394.95 | 3697.0 |
| 2022-09-15 04:25:00 | SPY | ETF | 394.93 | 395.0 | 394.93 | 394.94 | 1207.0 |
| 2022-09-15 04:30:00 | SPY | ETF | 394.96 | 394.96 | 394.87 | 394.87 | 200.0 |
| 2022-09-15 04:35:00 | SPY | ETF | 395.01 | 395.02 | 394.9 | 394.9 | 3320.0 |
| 2022-09-15 04:40:00 | SPY | ETF | 395.02 | 395.03 | 394.79 | 394.83 | 9158.0 |
| 2022-09-15 04:45:00 | SPY | ETF | 394.71 | 394.71 | 394.6 | 394.7 | 6167.0 |
| 2022-09-15 04:50:00 | SPY | ETF | 394.67 | 394.87 | 394.64 | 394.87 | 4400.0 |
| 2022-09-15 04:55:00 | SPY | ETF | 394.99 | 395.01 | 394.78 | 395.01 | 12864.0 |
| 2022-09-15 05:00:00 | SPY | ETF | 395.06 | 395.12 | 394.85 | 394.87 | 24190.0 |
| 2022-09-15 05:05:00 | SPY | ETF | 395.06 | 395.2 | 395.0 | 395.19 | 11733.0 |
| 2022-09-15 05:10:00 | SPY | ETF | 395.23 | 395.23 | 395.09 | 395.09 | 15500.0 |
| 2022-09-15 05:15:00 | SPY | ETF | 395.0 | 395.0 | 395.0 | 395.0 | 100.0 |
| 2022-09-15 05:20:00 | SPY | ETF | 395.15 | 395.15 | 395.12 | 395.12 | 341.0 |
| 2022-09-15 05:25:00 | SPY | ETF | 395.03 | 395.07 | 395.03 | 395.07 | 500.0 |
| 2022-09-15 05:30:00 | SPY | ETF | 395.15 | 395.44 | 395.15 | 395.42 | 1901.0 |
| 2022-09-15 05:40:00 | SPY | ETF | 395.63 | 395.7 | 395.51 | 395.54 | 9570.0 |
| 2022-09-15 05:45:00 | SPY | ETF | 395.58 | 395.63 | 395.58 | 395.58 | 1110.0 |
| 2022-09-15 05:50:00 | SPY | ETF | 395.55 | 395.55 | 395.36 | 395.36 | 3790.0 |
| 2022-09-15 05:55:00 | SPY | ETF | 395.3 | 395.39 | 395.3 | 395.35 | 4420.0 |
| 2022-09-15 06:00:00 | SPY | ETF | 395.43 | 395.5 | 395.43 | 395.5 | 3090.0 |
| 2022-09-15 06:05:00 | SPY | ETF | 395.27 | 395.36 | 395.27 | 395.36 | 1100.0 |
| 2022-09-15 06:10:00 | SPY | ETF | 395.34 | 395.5 | 395.34 | 395.5 | 1777.0 |
| 2022-09-15 06:20:00 | SPY | ETF | 395.43 | 395.43 | 395.2 | 395.3 | 5580.0 |
| 2022-09-15 06:25:00 | SPY | ETF | 395.17 | 395.22 | 395.02 | 395.02 | 3881.0 |
| 2022-09-15 06:30:00 | SPY | ETF | 395.04 | 395.04 | 394.48 | 394.53 | 58475.0 |
| 2022-09-15 06:35:00 | SPY | ETF | 394.5 | 394.5 | 393.89 | 394.08 | 51222.0 |
| 2022-09-15 06:40:00 | SPY | ETF | 394.11 | 394.11 | 393.41 | 393.68 | 23981.0 |
| 2022-09-15 06:45:00 | SPY | ETF | 393.83 | 393.9 | 393.79 | 393.88 | 8008.0 |
| 2022-09-15 06:50:00 | SPY | ETF | 393.84 | 394.08 | 393.84 | 394.0 | 2194.0 |
| 2022-09-15 06:55:00 | SPY | ETF | 393.92 | 394.01 | 393.82 | 394.0 | 3997.0 |
| 2022-09-15 07:00:00 | SPY | ETF | 394.06 | 394.16 | 393.9 | 393.9 | 28346.0 |
| 2022-09-15 07:05:00 | SPY | ETF | 393.97 | 394.14 | 393.97 | 394.02 | 10587.0 |
| 2022-09-15 07:10:00 | SPY | ETF | 394.01 | 394.35 | 393.96 | 394.33 | 19359.0 |
| 2022-09-15 07:15:00 | SPY | ETF | 394.33 | 394.5 | 394.33 | 394.5 | 30730.0 |
| 2022-09-15 07:20:00 | SPY | ETF | 394.5 | 394.75 | 394.43 | 394.71 | 24080.0 |
| 2022-09-15 07:25:00 | SPY | ETF | 394.73 | 394.92 | 394.66 | 394.89 | 19780.0 |
| 2022-09-15 07:30:00 | SPY | ETF | 394.86 | 394.87 | 394.6 | 394.68 | 11965.0 |
| 2022-09-15 07:35:00 | SPY | ETF | 394.66 | 394.72 | 394.6 | 394.6 | 7499.0 |
| 2022-09-15 07:40:00 | SPY | ETF | 394.5 | 394.5 | 394.24 | 394.42 | 22673.0 |
| 2022-09-15 07:45:00 | SPY | ETF | 394.46 | 394.46 | 394.29 | 394.36 | 15899.0 |
| 2022-09-15 07:50:00 | SPY | ETF | 394.38 | 394.38 | 393.97 | 393.97 | 31134.0 |
| 2022-09-15 07:55:00 | SPY | ETF | 393.94 | 394.16 | 393.83 | 394.1 | 40475.0 |
| 2022-09-15 08:00:00 | SPY | ETF | 394.2 | 395.65 | 393.5096 | 393.75 | 116656.0 |
| 2022-09-15 08:05:00 | SPY | ETF | 393.7 | 393.84 | 393.47 | 393.57 | 60315.0 |
| 2022-09-15 08:10:00 | SPY | ETF | 393.56 | 394.0 | 393.55 | 393.96 | 23277.0 |
| 2022-09-15 08:15:00 | SPY | ETF | 393.95 | 394.03 | 393.76 | 393.76 | 41674.0 |
> showing 50 of 90,346 rows — these rows as CSV