PREVIEW / etf_5min / 2022-11-09
file: by_date/etf_5min/2022/2022-11-09.parquet size: 2.0 MB rows: 98,176
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-11-09 04:00:00 | SPY | ETF | 382.12 | 382.23 | 381.78 | 381.98 | 31805.0 |
| 2022-11-09 04:05:00 | SPY | ETF | 381.95 | 382.0 | 381.71 | 381.71 | 8160.0 |
| 2022-11-09 04:10:00 | SPY | ETF | 381.65 | 381.69 | 381.42 | 381.43 | 2963.0 |
| 2022-11-09 04:15:00 | SPY | ETF | 381.29 | 381.34 | 381.05 | 381.05 | 42443.0 |
| 2022-11-09 04:20:00 | SPY | ETF | 381.12 | 381.38 | 381.1 | 381.37 | 5075.0 |
| 2022-11-09 04:25:00 | SPY | ETF | 381.38 | 381.5 | 381.35 | 381.5 | 3784.0 |
| 2022-11-09 04:30:00 | SPY | ETF | 381.29 | 381.29 | 381.1 | 381.1 | 7175.0 |
| 2022-11-09 04:35:00 | SPY | ETF | 381.36 | 381.36 | 381.16 | 381.16 | 700.0 |
| 2022-11-09 04:40:00 | SPY | ETF | 381.12 | 381.12 | 381.04 | 381.11 | 1150.0 |
| 2022-11-09 04:45:00 | SPY | ETF | 381.11 | 381.17 | 380.49 | 380.49 | 9580.0 |
| 2022-11-09 04:50:00 | SPY | ETF | 380.63 | 380.69 | 380.52 | 380.69 | 5428.0 |
| 2022-11-09 04:55:00 | SPY | ETF | 380.59 | 380.59 | 380.07 | 380.2 | 13199.0 |
| 2022-11-09 05:00:00 | SPY | ETF | 380.37 | 380.48 | 380.2 | 380.29 | 8590.0 |
| 2022-11-09 05:05:00 | SPY | ETF | 380.1 | 380.13 | 380.07 | 380.12 | 2722.0 |
| 2022-11-09 05:10:00 | SPY | ETF | 380.03 | 380.07 | 379.83 | 379.83 | 2300.0 |
| 2022-11-09 05:15:00 | SPY | ETF | 379.87 | 380.17 | 379.75 | 380.04 | 8572.0 |
| 2022-11-09 05:20:00 | SPY | ETF | 380.1 | 380.36 | 379.97 | 380.28 | 8119.0 |
| 2022-11-09 05:25:00 | SPY | ETF | 380.15 | 380.2 | 380.15 | 380.15 | 2500.0 |
| 2022-11-09 05:30:00 | SPY | ETF | 380.31 | 380.38 | 380.31 | 380.38 | 770.0 |
| 2022-11-09 05:35:00 | SPY | ETF | 380.6 | 380.74 | 380.6 | 380.74 | 1959.0 |
| 2022-11-09 05:40:00 | SPY | ETF | 380.88 | 381.07 | 380.88 | 381.07 | 915.0 |
| 2022-11-09 05:45:00 | SPY | ETF | 380.94 | 381.27 | 380.94 | 381.03 | 9475.0 |
| 2022-11-09 05:50:00 | SPY | ETF | 380.85 | 381.23 | 380.8 | 381.2 | 1909.0 |
| 2022-11-09 05:55:00 | SPY | ETF | 381.15 | 381.34 | 381.14 | 381.15 | 4122.0 |
| 2022-11-09 06:00:00 | SPY | ETF | 381.28 | 381.38 | 381.22 | 381.22 | 8654.0 |
| 2022-11-09 06:05:00 | SPY | ETF | 381.14 | 381.5 | 381.11 | 381.5 | 2415.0 |
| 2022-11-09 06:10:00 | SPY | ETF | 381.52 | 381.71 | 381.48 | 381.71 | 2572.0 |
| 2022-11-09 06:15:00 | SPY | ETF | 381.85 | 381.95 | 381.73 | 381.9 | 2763.0 |
| 2022-11-09 06:20:00 | SPY | ETF | 381.99 | 382.02 | 381.71 | 381.71 | 4500.0 |
| 2022-11-09 06:25:00 | SPY | ETF | 381.63 | 381.86 | 381.52 | 381.86 | 10604.0 |
| 2022-11-09 06:30:00 | SPY | ETF | 381.8 | 381.8 | 381.61 | 381.61 | 6300.0 |
| 2022-11-09 06:35:00 | SPY | ETF | 381.46 | 382.02 | 381.3 | 381.92 | 12900.0 |
| 2022-11-09 06:40:00 | SPY | ETF | 381.77 | 381.94 | 381.68 | 381.68 | 1585.0 |
| 2022-11-09 06:45:00 | SPY | ETF | 381.57 | 381.68 | 381.52 | 381.64 | 7080.0 |
| 2022-11-09 06:50:00 | SPY | ETF | 381.69 | 381.74 | 381.44 | 381.53 | 2639.0 |
| 2022-11-09 06:55:00 | SPY | ETF | 381.5 | 381.51 | 381.27 | 381.46 | 14050.0 |
| 2022-11-09 07:00:00 | SPY | ETF | 381.53 | 381.57 | 381.4 | 381.46 | 18663.0 |
| 2022-11-09 07:05:00 | SPY | ETF | 381.4 | 381.4 | 381.13 | 381.13 | 48738.0 |
| 2022-11-09 07:10:00 | SPY | ETF | 381.1 | 381.1 | 380.85 | 380.88 | 18173.0 |
| 2022-11-09 07:15:00 | SPY | ETF | 380.97 | 381.04 | 380.75 | 380.9 | 22650.0 |
| 2022-11-09 07:20:00 | SPY | ETF | 380.9 | 381.02 | 380.51 | 380.59 | 17398.0 |
| 2022-11-09 07:25:00 | SPY | ETF | 380.6 | 380.83 | 380.57 | 380.6 | 25938.0 |
| 2022-11-09 07:30:00 | SPY | ETF | 380.73 | 381.13 | 380.7 | 380.78 | 36046.0 |
| 2022-11-09 07:35:00 | SPY | ETF | 380.78 | 381.05 | 380.78 | 381.02 | 8014.0 |
| 2022-11-09 07:40:00 | SPY | ETF | 380.99 | 381.37 | 380.95 | 381.35 | 14894.0 |
| 2022-11-09 07:45:00 | SPY | ETF | 381.34 | 381.63 | 381.31 | 381.56 | 45283.0 |
| 2022-11-09 07:50:00 | SPY | ETF | 381.52 | 381.82 | 381.5 | 381.64 | 11061.0 |
| 2022-11-09 07:55:00 | SPY | ETF | 381.64 | 381.86 | 381.64 | 381.76 | 14223.0 |
| 2022-11-09 08:00:00 | SPY | ETF | 381.18 | 382.44 | 380.13 | 381.92 | 90524.0 |
| 2022-11-09 08:05:00 | SPY | ETF | 381.89 | 381.89 | 381.28 | 381.33 | 27601.0 |
> showing 50 of 98,176 rows — these rows as CSV