PREVIEW / stock_5min / 2023-05-22
file: by_date/stock_5min/2023/2023-05-22.parquet size: 6.8 MB rows: 416,520 symbols: 1,647
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-05-22 04:00:00 | AAPL | Stock | 175.25 | 175.44 | 175.22 | 175.3 | 2742.0 |
| 2023-05-22 04:05:00 | AAPL | Stock | 175.3 | 175.34 | 175.29 | 175.33 | 3780.0 |
| 2023-05-22 04:10:00 | AAPL | Stock | 175.3 | 175.33 | 175.29 | 175.33 | 1950.0 |
| 2023-05-22 04:15:00 | AAPL | Stock | 175.34 | 175.38 | 175.25 | 175.3 | 2279.0 |
| 2023-05-22 04:20:00 | AAPL | Stock | 175.25 | 175.25 | 175.25 | 175.25 | 100.0 |
| 2023-05-22 04:25:00 | AAPL | Stock | 175.36 | 175.41 | 175.36 | 175.41 | 718.0 |
| 2023-05-22 04:30:00 | AAPL | Stock | 175.36 | 175.46 | 175.36 | 175.43 | 531.0 |
| 2023-05-22 04:35:00 | AAPL | Stock | 175.46 | 175.46 | 175.3 | 175.33 | 1470.0 |
| 2023-05-22 04:40:00 | AAPL | Stock | 175.34 | 175.34 | 175.27 | 175.27 | 534.0 |
| 2023-05-22 04:45:00 | AAPL | Stock | 175.28 | 175.3 | 175.28 | 175.3 | 273.0 |
| 2023-05-22 05:10:00 | AAPL | Stock | 175.27 | 175.27 | 175.27 | 175.27 | 100.0 |
| 2023-05-22 05:15:00 | AAPL | Stock | 175.3 | 175.3 | 175.14 | 175.14 | 9428.0 |
| 2023-05-22 05:20:00 | AAPL | Stock | 175.2 | 175.27 | 175.15 | 175.15 | 1244.0 |
| 2023-05-22 05:25:00 | AAPL | Stock | 175.15 | 175.15 | 175.15 | 175.15 | 656.0 |
| 2023-05-22 05:30:00 | AAPL | Stock | 175.18 | 175.18 | 175.18 | 175.18 | 200.0 |
| 2023-05-22 05:35:00 | AAPL | Stock | 175.11 | 175.23 | 175.05 | 175.23 | 1406.0 |
| 2023-05-22 05:40:00 | AAPL | Stock | 175.23 | 175.23 | 175.23 | 175.23 | 220.0 |
| 2023-05-22 05:45:00 | AAPL | Stock | 175.24 | 175.27 | 175.24 | 175.27 | 347.0 |
| 2023-05-22 05:50:00 | AAPL | Stock | 175.26 | 175.27 | 173.77 | 173.78 | 40267.0 |
| 2023-05-22 05:55:00 | AAPL | Stock | 173.68 | 173.98 | 172.87 | 173.31 | 50658.0 |
| 2023-05-22 06:00:00 | AAPL | Stock | 173.31 | 173.31 | 172.6 | 172.89 | 42660.0 |
| 2023-05-22 06:05:00 | AAPL | Stock | 173.06 | 173.6 | 173.0 | 173.33 | 16283.0 |
| 2023-05-22 06:10:00 | AAPL | Stock | 173.45 | 173.45 | 173.2 | 173.2 | 6146.0 |
| 2023-05-22 06:15:00 | AAPL | Stock | 173.16 | 173.2 | 173.16 | 173.18 | 2978.0 |
| 2023-05-22 06:20:00 | AAPL | Stock | 173.14 | 173.17 | 173.14 | 173.17 | 1906.0 |
| 2023-05-22 06:25:00 | AAPL | Stock | 173.25 | 173.35 | 173.25 | 173.26 | 3915.0 |
| 2023-05-22 06:30:00 | AAPL | Stock | 173.33 | 173.33 | 173.25 | 173.31 | 1066.0 |
| 2023-05-22 06:35:00 | AAPL | Stock | 173.43 | 173.7 | 173.43 | 173.52 | 4628.0 |
| 2023-05-22 06:40:00 | AAPL | Stock | 173.52 | 173.59 | 173.41 | 173.59 | 13114.0 |
| 2023-05-22 06:45:00 | AAPL | Stock | 173.6 | 173.68 | 173.52 | 173.52 | 4152.0 |
| 2023-05-22 06:50:00 | AAPL | Stock | 173.52 | 173.52 | 173.39 | 173.44 | 15084.0 |
| 2023-05-22 06:55:00 | AAPL | Stock | 173.49 | 173.68 | 173.49 | 173.5 | 7797.0 |
| 2023-05-22 07:00:00 | AAPL | Stock | 173.5 | 173.68 | 173.5 | 173.65 | 26216.0 |
| 2023-05-22 07:05:00 | AAPL | Stock | 173.63 | 173.75 | 173.6 | 173.64 | 14875.0 |
| 2023-05-22 07:10:00 | AAPL | Stock | 173.6 | 173.6 | 173.45 | 173.56 | 19502.0 |
| 2023-05-22 07:15:00 | AAPL | Stock | 173.56 | 173.57 | 173.44 | 173.44 | 20819.0 |
| 2023-05-22 07:20:00 | AAPL | Stock | 173.42 | 173.42 | 173.3 | 173.31 | 19902.0 |
| 2023-05-22 07:25:00 | AAPL | Stock | 173.31 | 173.35 | 173.25 | 173.25 | 8665.0 |
| 2023-05-22 07:30:00 | AAPL | Stock | 173.25 | 173.5 | 173.24 | 173.5 | 6344.0 |
| 2023-05-22 07:35:00 | AAPL | Stock | 173.5 | 173.5 | 173.27 | 173.4 | 4890.0 |
| 2023-05-22 07:40:00 | AAPL | Stock | 173.33 | 173.33 | 173.33 | 173.33 | 408.0 |
| 2023-05-22 07:45:00 | AAPL | Stock | 173.44 | 173.46 | 173.42 | 173.42 | 1197.0 |
| 2023-05-22 07:50:00 | AAPL | Stock | 173.46 | 173.46 | 173.34 | 173.34 | 2981.0 |
| 2023-05-22 07:55:00 | AAPL | Stock | 173.33 | 173.42 | 173.32 | 173.42 | 7351.0 |
| 2023-05-22 08:00:00 | AAPL | Stock | 173.4998 | 175.16 | 173.22 | 173.61 | 60890.0 |
| 2023-05-22 08:05:00 | AAPL | Stock | 173.57 | 173.6 | 173.43 | 173.43 | 11507.0 |
| 2023-05-22 08:10:00 | AAPL | Stock | 173.39 | 173.48 | 173.37 | 173.46 | 8824.0 |
| 2023-05-22 08:15:00 | AAPL | Stock | 173.46 | 173.57 | 173.4 | 173.42 | 12941.0 |
| 2023-05-22 08:20:00 | AAPL | Stock | 173.4199 | 173.55 | 173.4 | 173.55 | 17466.0 |
| 2023-05-22 08:25:00 | AAPL | Stock | 173.54 | 173.6 | 173.51 | 173.57 | 12431.0 |
> showing 50 of 416,520 rows — these rows as CSV