PREVIEW / etf_5min / 2022-08-22
file: by_date/etf_5min/2022/2022-08-22.parquet size: 1.9 MB rows: 93,620
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-08-22 04:00:00 | SPY | ETF | 419.97 | 419.97 | 417.5 | 417.5 | 17391.0 |
| 2022-08-22 04:05:00 | SPY | ETF | 417.64 | 417.88 | 417.64 | 417.72 | 11105.0 |
| 2022-08-22 04:10:00 | SPY | ETF | 417.58 | 417.63 | 417.36 | 417.36 | 2300.0 |
| 2022-08-22 04:15:00 | SPY | ETF | 417.31 | 417.61 | 417.31 | 417.5 | 4610.0 |
| 2022-08-22 04:20:00 | SPY | ETF | 417.56 | 417.7 | 417.47 | 417.53 | 2398.0 |
| 2022-08-22 04:25:00 | SPY | ETF | 417.47 | 417.7 | 417.38 | 417.7 | 2700.0 |
| 2022-08-22 04:30:00 | SPY | ETF | 417.68 | 417.68 | 417.39 | 417.39 | 1797.0 |
| 2022-08-22 04:35:00 | SPY | ETF | 417.22 | 417.48 | 417.2 | 417.28 | 2673.0 |
| 2022-08-22 04:40:00 | SPY | ETF | 417.37 | 417.37 | 417.1 | 417.27 | 1338.0 |
| 2022-08-22 04:45:00 | SPY | ETF | 417.22 | 417.5 | 417.22 | 417.41 | 1750.0 |
| 2022-08-22 04:50:00 | SPY | ETF | 417.49 | 417.54 | 417.48 | 417.53 | 2150.0 |
| 2022-08-22 04:55:00 | SPY | ETF | 417.43 | 417.75 | 417.43 | 417.58 | 2298.0 |
| 2022-08-22 05:00:00 | SPY | ETF | 417.42 | 417.46 | 417.32 | 417.32 | 1446.0 |
| 2022-08-22 05:05:00 | SPY | ETF | 417.31 | 417.48 | 417.26 | 417.48 | 6244.0 |
| 2022-08-22 05:10:00 | SPY | ETF | 417.49 | 417.61 | 417.4 | 417.47 | 2800.0 |
| 2022-08-22 05:15:00 | SPY | ETF | 417.37 | 417.7 | 417.35 | 417.65 | 1809.0 |
| 2022-08-22 05:20:00 | SPY | ETF | 417.62 | 417.62 | 417.43 | 417.43 | 2020.0 |
| 2022-08-22 05:25:00 | SPY | ETF | 417.39 | 417.41 | 417.3 | 417.31 | 1680.0 |
| 2022-08-22 05:30:00 | SPY | ETF | 417.33 | 417.33 | 416.78 | 416.78 | 9050.0 |
| 2022-08-22 05:35:00 | SPY | ETF | 416.85 | 416.91 | 416.85 | 416.86 | 2200.0 |
| 2022-08-22 05:40:00 | SPY | ETF | 416.78 | 416.86 | 416.77 | 416.86 | 1912.0 |
| 2022-08-22 05:45:00 | SPY | ETF | 416.83 | 417.05 | 416.83 | 417.05 | 5247.0 |
| 2022-08-22 05:50:00 | SPY | ETF | 417.17 | 417.37 | 417.17 | 417.36 | 4903.0 |
| 2022-08-22 05:55:00 | SPY | ETF | 417.46 | 417.46 | 417.35 | 417.35 | 2351.0 |
| 2022-08-22 06:00:00 | SPY | ETF | 417.31 | 417.41 | 417.31 | 417.35 | 1064.0 |
| 2022-08-22 06:05:00 | SPY | ETF | 417.29 | 417.62 | 417.29 | 417.57 | 1960.0 |
| 2022-08-22 06:10:00 | SPY | ETF | 417.55 | 417.85 | 417.55 | 417.71 | 10055.0 |
| 2022-08-22 06:15:00 | SPY | ETF | 417.69 | 417.85 | 417.69 | 417.78 | 9415.0 |
| 2022-08-22 06:20:00 | SPY | ETF | 417.74 | 417.78 | 417.68 | 417.75 | 2983.0 |
| 2022-08-22 06:25:00 | SPY | ETF | 417.75 | 417.75 | 417.62 | 417.62 | 8670.0 |
| 2022-08-22 06:30:00 | SPY | ETF | 417.58 | 417.58 | 417.45 | 417.46 | 550.0 |
| 2022-08-22 06:35:00 | SPY | ETF | 417.5 | 417.7 | 417.49 | 417.64 | 11991.0 |
| 2022-08-22 06:40:00 | SPY | ETF | 417.62 | 417.62 | 417.4 | 417.4 | 2650.0 |
| 2022-08-22 06:45:00 | SPY | ETF | 417.45 | 417.7 | 417.41 | 417.69 | 1403.0 |
| 2022-08-22 06:50:00 | SPY | ETF | 417.73 | 417.84 | 417.73 | 417.76 | 5433.0 |
| 2022-08-22 06:55:00 | SPY | ETF | 417.86 | 417.86 | 417.65 | 417.66 | 3808.0 |
| 2022-08-22 07:00:00 | SPY | ETF | 417.68 | 417.93 | 417.68 | 417.81 | 15586.0 |
| 2022-08-22 07:05:00 | SPY | ETF | 417.78 | 417.81 | 417.66 | 417.67 | 21988.0 |
| 2022-08-22 07:10:00 | SPY | ETF | 417.7 | 417.88 | 417.7 | 417.83 | 17862.0 |
| 2022-08-22 07:15:00 | SPY | ETF | 417.87 | 417.9 | 417.66 | 417.75 | 15718.0 |
| 2022-08-22 07:20:00 | SPY | ETF | 417.7 | 418.04 | 417.7 | 417.84 | 19916.0 |
| 2022-08-22 07:25:00 | SPY | ETF | 417.76 | 417.78 | 417.48 | 417.55 | 12698.0 |
| 2022-08-22 07:30:00 | SPY | ETF | 417.52 | 417.54 | 417.32 | 417.4 | 19445.0 |
| 2022-08-22 07:35:00 | SPY | ETF | 417.32 | 417.49 | 417.31 | 417.49 | 23411.0 |
| 2022-08-22 07:40:00 | SPY | ETF | 417.49 | 417.49 | 417.35 | 417.47 | 15911.0 |
| 2022-08-22 07:45:00 | SPY | ETF | 417.49 | 417.55 | 417.41 | 417.41 | 23118.0 |
| 2022-08-22 07:50:00 | SPY | ETF | 417.4 | 417.56 | 417.35 | 417.55 | 94351.0 |
| 2022-08-22 07:55:00 | SPY | ETF | 417.55 | 417.72 | 417.49 | 417.65 | 28767.0 |
| 2022-08-22 08:00:00 | SPY | ETF | 417.8 | 420.81 | 416.8396 | 417.33 | 67680.0 |
| 2022-08-22 08:05:00 | SPY | ETF | 417.34 | 421.13 | 417.22 | 417.25 | 98325.0 |
> showing 50 of 93,620 rows — these rows as CSV