PREVIEW / etf_5min / 2023-08-14
file: by_date/etf_5min/2023/2023-08-14.parquet size: 1.9 MB rows: 94,928
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-08-14 04:00:00 | SPY | ETF | 447.06 | 447.31 | 446.0 | 447.09 | 4484.0 |
| 2023-08-14 04:05:00 | SPY | ETF | 446.95 | 447.13 | 446.88 | 447.13 | 3874.0 |
| 2023-08-14 04:10:00 | SPY | ETF | 447.36 | 447.36 | 446.63 | 446.63 | 3733.0 |
| 2023-08-14 04:15:00 | SPY | ETF | 446.71 | 446.71 | 446.43 | 446.45 | 2135.0 |
| 2023-08-14 04:20:00 | SPY | ETF | 446.58 | 446.73 | 446.58 | 446.7 | 1010.0 |
| 2023-08-14 04:25:00 | SPY | ETF | 446.61 | 446.66 | 446.52 | 446.6 | 5700.0 |
| 2023-08-14 04:30:00 | SPY | ETF | 446.5 | 446.5 | 446.34 | 446.34 | 2104.0 |
| 2023-08-14 04:35:00 | SPY | ETF | 446.39 | 446.65 | 446.39 | 446.65 | 1895.0 |
| 2023-08-14 04:40:00 | SPY | ETF | 446.6 | 446.6 | 446.5 | 446.5 | 2900.0 |
| 2023-08-14 04:45:00 | SPY | ETF | 446.61 | 446.61 | 446.6 | 446.6 | 911.0 |
| 2023-08-14 04:50:00 | SPY | ETF | 446.63 | 446.67 | 446.63 | 446.63 | 920.0 |
| 2023-08-14 04:55:00 | SPY | ETF | 446.53 | 446.53 | 446.46 | 446.47 | 1800.0 |
| 2023-08-14 05:00:00 | SPY | ETF | 446.37 | 446.37 | 446.26 | 446.37 | 3798.0 |
| 2023-08-14 05:05:00 | SPY | ETF | 446.39 | 446.43 | 446.36 | 446.43 | 600.0 |
| 2023-08-14 05:10:00 | SPY | ETF | 446.14 | 446.4 | 446.14 | 446.4 | 1114.0 |
| 2023-08-14 05:15:00 | SPY | ETF | 446.43 | 446.6 | 446.43 | 446.6 | 514.0 |
| 2023-08-14 05:20:00 | SPY | ETF | 446.65 | 446.7 | 446.65 | 446.7 | 960.0 |
| 2023-08-14 05:25:00 | SPY | ETF | 446.53 | 446.53 | 446.43 | 446.43 | 1625.0 |
| 2023-08-14 05:30:00 | SPY | ETF | 446.55 | 446.55 | 446.43 | 446.44 | 1853.0 |
| 2023-08-14 05:35:00 | SPY | ETF | 446.68 | 446.68 | 446.65 | 446.65 | 500.0 |
| 2023-08-14 05:40:00 | SPY | ETF | 446.31 | 446.4 | 446.31 | 446.4 | 2300.0 |
| 2023-08-14 05:45:00 | SPY | ETF | 446.45 | 446.45 | 446.45 | 446.45 | 200.0 |
| 2023-08-14 05:50:00 | SPY | ETF | 446.35 | 446.37 | 446.3 | 446.3 | 1707.0 |
| 2023-08-14 06:00:00 | SPY | ETF | 446.44 | 446.46 | 446.26 | 446.35 | 1754.0 |
| 2023-08-14 06:05:00 | SPY | ETF | 446.5 | 446.71 | 446.5 | 446.71 | 1493.0 |
| 2023-08-14 06:10:00 | SPY | ETF | 446.65 | 446.67 | 446.64 | 446.64 | 935.0 |
| 2023-08-14 06:15:00 | SPY | ETF | 446.64 | 446.64 | 446.64 | 446.64 | 200.0 |
| 2023-08-14 06:20:00 | SPY | ETF | 446.72 | 446.76 | 446.51 | 446.51 | 6442.0 |
| 2023-08-14 06:25:00 | SPY | ETF | 446.42 | 446.42 | 446.36 | 446.36 | 2325.0 |
| 2023-08-14 06:30:00 | SPY | ETF | 446.35 | 446.47 | 446.35 | 446.4 | 2950.0 |
| 2023-08-14 06:35:00 | SPY | ETF | 446.58 | 446.6 | 446.58 | 446.6 | 1122.0 |
| 2023-08-14 06:40:00 | SPY | ETF | 446.61 | 446.68 | 446.61 | 446.68 | 1518.0 |
| 2023-08-14 06:45:00 | SPY | ETF | 446.84 | 446.85 | 446.76 | 446.84 | 1161.0 |
| 2023-08-14 06:50:00 | SPY | ETF | 446.92 | 446.92 | 446.87 | 446.87 | 12450.0 |
| 2023-08-14 07:00:00 | SPY | ETF | 446.63 | 446.69 | 446.63 | 446.65 | 4596.0 |
| 2023-08-14 07:05:00 | SPY | ETF | 446.6 | 446.8 | 446.6 | 446.63 | 7500.0 |
| 2023-08-14 07:10:00 | SPY | ETF | 446.6 | 446.6 | 446.38 | 446.38 | 12163.0 |
| 2023-08-14 07:15:00 | SPY | ETF | 446.37 | 446.4 | 446.31 | 446.39 | 9541.0 |
| 2023-08-14 07:20:00 | SPY | ETF | 446.39 | 446.5 | 446.37 | 446.46 | 8516.0 |
| 2023-08-14 07:25:00 | SPY | ETF | 446.39 | 446.49 | 446.39 | 446.48 | 6006.0 |
| 2023-08-14 07:30:00 | SPY | ETF | 446.49 | 446.5 | 446.41 | 446.42 | 2600.0 |
| 2023-08-14 07:35:00 | SPY | ETF | 446.39 | 446.42 | 446.15 | 446.17 | 14741.0 |
| 2023-08-14 07:40:00 | SPY | ETF | 446.17 | 446.25 | 445.99 | 446.03 | 22371.0 |
| 2023-08-14 07:45:00 | SPY | ETF | 446.03 | 446.1 | 445.97 | 446.1 | 9759.0 |
| 2023-08-14 07:50:00 | SPY | ETF | 446.08 | 446.21 | 446.0 | 446.2 | 5130.0 |
| 2023-08-14 07:55:00 | SPY | ETF | 446.22 | 446.27 | 446.22 | 446.27 | 3550.0 |
| 2023-08-14 08:00:00 | SPY | ETF | 446.6514 | 447.0196 | 446.0 | 446.13 | 29784.0 |
| 2023-08-14 08:05:00 | SPY | ETF | 446.05 | 446.05 | 445.96 | 446.03 | 20298.0 |
| 2023-08-14 08:10:00 | SPY | ETF | 446.02 | 446.07 | 445.94 | 446.0 | 10065.0 |
| 2023-08-14 08:15:00 | SPY | ETF | 446.01 | 446.01 | 445.56 | 445.56 | 19039.0 |
> showing 50 of 94,928 rows — these rows as CSV