PREVIEW / etf_5min / 2022-10-31
file: by_date/etf_5min/2022/2022-10-31.parquet size: 1.9 MB rows: 95,073
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-10-31 04:00:00 | SPY | ETF | 388.8 | 389.45 | 387.61 | 387.61 | 53223.0 |
| 2022-10-31 04:05:00 | SPY | ETF | 387.61 | 387.61 | 387.24 | 387.24 | 46873.0 |
| 2022-10-31 04:10:00 | SPY | ETF | 387.29 | 387.34 | 387.2 | 387.32 | 7535.0 |
| 2022-10-31 04:15:00 | SPY | ETF | 387.28 | 387.28 | 387.12 | 387.25 | 27509.0 |
| 2022-10-31 04:20:00 | SPY | ETF | 387.34 | 387.4 | 387.25 | 387.36 | 18859.0 |
| 2022-10-31 04:25:00 | SPY | ETF | 387.36 | 387.4 | 387.06 | 387.06 | 18049.0 |
| 2022-10-31 04:30:00 | SPY | ETF | 387.0 | 387.0 | 386.68 | 386.68 | 15750.0 |
| 2022-10-31 04:35:00 | SPY | ETF | 386.76 | 386.84 | 386.7 | 386.84 | 4450.0 |
| 2022-10-31 04:40:00 | SPY | ETF | 386.84 | 386.84 | 386.81 | 386.81 | 600.0 |
| 2022-10-31 04:45:00 | SPY | ETF | 386.7 | 386.72 | 386.48 | 386.53 | 5756.0 |
| 2022-10-31 04:50:00 | SPY | ETF | 386.55 | 386.55 | 386.42 | 386.42 | 1800.0 |
| 2022-10-31 04:55:00 | SPY | ETF | 386.52 | 386.9 | 386.52 | 386.9 | 1600.0 |
| 2022-10-31 05:00:00 | SPY | ETF | 386.83 | 386.87 | 386.59 | 386.62 | 3500.0 |
| 2022-10-31 05:05:00 | SPY | ETF | 386.72 | 386.77 | 386.58 | 386.63 | 2300.0 |
| 2022-10-31 05:10:00 | SPY | ETF | 386.58 | 386.59 | 386.53 | 386.55 | 1445.0 |
| 2022-10-31 05:15:00 | SPY | ETF | 386.65 | 386.71 | 386.54 | 386.62 | 1460.0 |
| 2022-10-31 05:20:00 | SPY | ETF | 386.8 | 386.95 | 386.8 | 386.95 | 3730.0 |
| 2022-10-31 05:25:00 | SPY | ETF | 386.94 | 386.95 | 386.76 | 386.92 | 5550.0 |
| 2022-10-31 05:30:00 | SPY | ETF | 387.0 | 387.29 | 387.0 | 387.2 | 5130.0 |
| 2022-10-31 05:35:00 | SPY | ETF | 387.19 | 387.28 | 387.19 | 387.27 | 400.0 |
| 2022-10-31 05:40:00 | SPY | ETF | 387.29 | 387.35 | 387.29 | 387.29 | 2305.0 |
| 2022-10-31 05:45:00 | SPY | ETF | 387.4 | 387.5 | 387.38 | 387.38 | 1925.0 |
| 2022-10-31 05:50:00 | SPY | ETF | 387.4 | 387.4 | 387.31 | 387.33 | 2515.0 |
| 2022-10-31 05:55:00 | SPY | ETF | 387.27 | 387.27 | 387.02 | 387.1 | 2220.0 |
| 2022-10-31 06:00:00 | SPY | ETF | 387.01 | 387.15 | 386.97 | 387.0 | 11259.0 |
| 2022-10-31 06:05:00 | SPY | ETF | 387.07 | 387.43 | 387.03 | 387.4 | 5875.0 |
| 2022-10-31 06:10:00 | SPY | ETF | 387.32 | 387.32 | 387.05 | 387.15 | 3700.0 |
| 2022-10-31 06:15:00 | SPY | ETF | 387.2 | 387.2 | 386.94 | 386.95 | 10172.0 |
| 2022-10-31 06:20:00 | SPY | ETF | 386.92 | 387.15 | 386.8 | 387.15 | 1075.0 |
| 2022-10-31 06:25:00 | SPY | ETF | 387.15 | 387.15 | 387.07 | 387.1 | 14975.0 |
| 2022-10-31 06:30:00 | SPY | ETF | 387.1 | 387.1 | 386.91 | 387.0 | 7389.0 |
| 2022-10-31 06:35:00 | SPY | ETF | 387.14 | 387.17 | 387.13 | 387.13 | 1805.0 |
| 2022-10-31 06:40:00 | SPY | ETF | 387.08 | 387.08 | 386.87 | 386.94 | 5623.0 |
| 2022-10-31 06:45:00 | SPY | ETF | 386.96 | 387.03 | 386.94 | 386.94 | 4221.0 |
| 2022-10-31 06:50:00 | SPY | ETF | 386.96 | 387.0 | 386.84 | 386.84 | 2751.0 |
| 2022-10-31 06:55:00 | SPY | ETF | 386.92 | 387.37 | 386.92 | 387.33 | 2415.0 |
| 2022-10-31 07:00:00 | SPY | ETF | 387.35 | 387.9 | 387.34 | 387.61 | 67193.0 |
| 2022-10-31 07:05:00 | SPY | ETF | 387.599 | 387.76 | 387.55 | 387.72 | 29725.0 |
| 2022-10-31 07:10:00 | SPY | ETF | 387.73 | 387.99 | 387.73 | 387.84 | 35963.0 |
| 2022-10-31 07:15:00 | SPY | ETF | 387.9 | 388.08 | 387.89 | 387.91 | 11649.0 |
| 2022-10-31 07:20:00 | SPY | ETF | 387.86 | 387.93 | 387.8 | 387.9 | 7655.0 |
| 2022-10-31 07:25:00 | SPY | ETF | 387.9 | 388.23 | 387.9 | 388.23 | 20632.0 |
| 2022-10-31 07:30:00 | SPY | ETF | 388.15 | 388.15 | 387.81 | 387.85 | 8888.0 |
| 2022-10-31 07:35:00 | SPY | ETF | 387.86 | 387.89 | 387.65 | 387.73 | 8233.0 |
| 2022-10-31 07:40:00 | SPY | ETF | 387.78 | 387.99 | 387.78 | 387.89 | 19669.0 |
| 2022-10-31 07:45:00 | SPY | ETF | 387.99 | 388.08 | 387.84 | 387.91 | 23550.0 |
| 2022-10-31 07:50:00 | SPY | ETF | 387.88 | 387.9 | 387.38 | 387.51 | 34128.0 |
| 2022-10-31 07:55:00 | SPY | ETF | 387.44 | 387.59 | 387.44 | 387.57 | 31862.0 |
| 2022-10-31 08:00:00 | SPY | ETF | 387.84 | 388.78 | 386.53 | 387.0 | 134392.0 |
| 2022-10-31 08:05:00 | SPY | ETF | 387.3 | 387.3 | 386.99 | 387.05 | 100713.0 |
> showing 50 of 95,073 rows — these rows as CSV