PREVIEW / etf_5min / 2023-01-04
file: by_date/etf_5min/2023/2023-01-04.parquet size: 2.0 MB rows: 100,869
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-04 04:00:00 | SPY | ETF | 382.5 | 382.51 | 382.31 | 382.44 | 8096.0 |
| 2023-01-04 04:05:00 | SPY | ETF | 382.45 | 382.5 | 382.16 | 382.21 | 3409.0 |
| 2023-01-04 04:10:00 | SPY | ETF | 382.09 | 382.38 | 382.09 | 382.38 | 1762.0 |
| 2023-01-04 04:15:00 | SPY | ETF | 382.19 | 382.4 | 382.15 | 382.4 | 1933.0 |
| 2023-01-04 04:20:00 | SPY | ETF | 382.38 | 382.5 | 382.34 | 382.37 | 1937.0 |
| 2023-01-04 04:25:00 | SPY | ETF | 382.32 | 382.32 | 382.18 | 382.18 | 3264.0 |
| 2023-01-04 04:30:00 | SPY | ETF | 382.04 | 382.2 | 382.0 | 382.2 | 705.0 |
| 2023-01-04 04:35:00 | SPY | ETF | 382.29 | 382.34 | 382.29 | 382.32 | 1175.0 |
| 2023-01-04 04:40:00 | SPY | ETF | 382.29 | 382.42 | 382.27 | 382.29 | 1874.0 |
| 2023-01-04 04:45:00 | SPY | ETF | 382.32 | 382.62 | 382.29 | 382.6 | 1797.0 |
| 2023-01-04 04:50:00 | SPY | ETF | 382.51 | 382.53 | 382.47 | 382.47 | 925.0 |
| 2023-01-04 04:55:00 | SPY | ETF | 382.5 | 382.5 | 382.38 | 382.38 | 950.0 |
| 2023-01-04 05:00:00 | SPY | ETF | 382.38 | 382.65 | 382.38 | 382.65 | 500.0 |
| 2023-01-04 05:05:00 | SPY | ETF | 382.65 | 382.81 | 382.65 | 382.76 | 1617.0 |
| 2023-01-04 05:10:00 | SPY | ETF | 382.87 | 382.87 | 382.73 | 382.86 | 1105.0 |
| 2023-01-04 05:15:00 | SPY | ETF | 382.76 | 382.76 | 382.43 | 382.45 | 1400.0 |
| 2023-01-04 05:20:00 | SPY | ETF | 382.46 | 382.73 | 382.46 | 382.73 | 553.0 |
| 2023-01-04 05:30:00 | SPY | ETF | 382.69 | 382.69 | 382.6 | 382.6 | 1007.0 |
| 2023-01-04 05:35:00 | SPY | ETF | 382.43 | 382.44 | 382.02 | 382.02 | 1010.0 |
| 2023-01-04 05:40:00 | SPY | ETF | 381.97 | 382.04 | 381.87 | 381.87 | 500.0 |
| 2023-01-04 05:45:00 | SPY | ETF | 381.97 | 382.2 | 381.97 | 382.15 | 2509.0 |
| 2023-01-04 05:50:00 | SPY | ETF | 382.1 | 382.16 | 382.07 | 382.15 | 700.0 |
| 2023-01-04 05:55:00 | SPY | ETF | 382.12 | 382.12 | 382.08 | 382.08 | 309.0 |
| 2023-01-04 06:00:00 | SPY | ETF | 382.3 | 382.3 | 382.26 | 382.26 | 650.0 |
| 2023-01-04 06:05:00 | SPY | ETF | 382.31 | 382.31 | 382.31 | 382.31 | 200.0 |
| 2023-01-04 06:10:00 | SPY | ETF | 382.38 | 382.69 | 382.38 | 382.69 | 1092.0 |
| 2023-01-04 06:15:00 | SPY | ETF | 382.56 | 382.56 | 382.52 | 382.52 | 750.0 |
| 2023-01-04 06:20:00 | SPY | ETF | 382.54 | 382.57 | 382.54 | 382.57 | 200.0 |
| 2023-01-04 06:25:00 | SPY | ETF | 382.55 | 382.55 | 382.55 | 382.55 | 100.0 |
| 2023-01-04 06:30:00 | SPY | ETF | 382.57 | 382.65 | 382.4 | 382.42 | 2673.0 |
| 2023-01-04 06:35:00 | SPY | ETF | 382.52 | 382.81 | 382.52 | 382.79 | 3315.0 |
| 2023-01-04 06:40:00 | SPY | ETF | 382.67 | 382.67 | 382.6 | 382.6 | 600.0 |
| 2023-01-04 06:45:00 | SPY | ETF | 382.64 | 382.64 | 382.64 | 382.64 | 125.0 |
| 2023-01-04 06:50:00 | SPY | ETF | 382.74 | 382.75 | 382.66 | 382.73 | 4845.0 |
| 2023-01-04 06:55:00 | SPY | ETF | 382.77 | 382.79 | 382.38 | 382.38 | 6275.0 |
| 2023-01-04 07:00:00 | SPY | ETF | 382.28 | 382.39 | 382.17 | 382.17 | 12927.0 |
| 2023-01-04 07:05:00 | SPY | ETF | 382.19 | 382.19 | 381.92 | 381.96 | 26723.0 |
| 2023-01-04 07:10:00 | SPY | ETF | 381.96 | 382.27 | 381.96 | 382.27 | 11027.0 |
| 2023-01-04 07:15:00 | SPY | ETF | 382.22 | 382.22 | 382.04 | 382.04 | 7543.0 |
| 2023-01-04 07:20:00 | SPY | ETF | 382.09 | 382.095 | 381.78 | 381.87 | 6417.0 |
| 2023-01-04 07:25:00 | SPY | ETF | 381.8 | 382.03 | 381.8 | 381.88 | 57983.0 |
| 2023-01-04 07:30:00 | SPY | ETF | 381.89 | 382.19 | 381.89 | 382.05 | 22730.0 |
| 2023-01-04 07:35:00 | SPY | ETF | 382.07 | 382.1 | 381.916 | 382.0 | 83329.0 |
| 2023-01-04 07:40:00 | SPY | ETF | 381.9 | 382.0 | 381.78 | 382.0 | 31533.0 |
| 2023-01-04 07:45:00 | SPY | ETF | 382.01 | 382.01 | 381.49 | 381.53 | 51613.0 |
| 2023-01-04 07:50:00 | SPY | ETF | 381.46 | 381.76 | 381.4 | 381.75 | 59098.0 |
| 2023-01-04 07:55:00 | SPY | ETF | 381.73 | 381.91 | 381.66 | 381.84 | 22555.0 |
| 2023-01-04 08:00:00 | SPY | ETF | 382.17 | 383.08 | 381.3 | 382.22 | 50886.0 |
| 2023-01-04 08:05:00 | SPY | ETF | 382.2 | 382.35 | 382.1 | 382.35 | 18540.0 |
| 2023-01-04 08:10:00 | SPY | ETF | 382.37 | 382.48 | 382.28 | 382.35 | 22795.0 |
> showing 50 of 100,869 rows — these rows as CSV