PREVIEW / stock_5min / 2023-09-08
file: by_date/stock_5min/2023/2023-09-08.parquet size: 6.3 MB rows: 385,692 symbols: 1,445
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-09-08 04:00:00 | AAPL | Stock | 179.0 | 179.0 | 178.61 | 178.61 | 2272.0 |
| 2023-09-08 04:05:00 | AAPL | Stock | 178.6 | 178.65 | 178.6 | 178.63 | 1303.0 |
| 2023-09-08 04:10:00 | AAPL | Stock | 178.61 | 178.66 | 178.34 | 178.4 | 6696.0 |
| 2023-09-08 04:15:00 | AAPL | Stock | 178.38 | 178.38 | 178.06 | 178.17 | 4010.0 |
| 2023-09-08 04:20:00 | AAPL | Stock | 178.2 | 178.2 | 178.12 | 178.15 | 3739.0 |
| 2023-09-08 04:25:00 | AAPL | Stock | 178.15 | 178.15 | 177.51 | 177.76 | 26831.0 |
| 2023-09-08 04:30:00 | AAPL | Stock | 177.75 | 177.82 | 177.75 | 177.8 | 429.0 |
| 2023-09-08 04:35:00 | AAPL | Stock | 177.82 | 178.0 | 177.82 | 177.98 | 718.0 |
| 2023-09-08 04:40:00 | AAPL | Stock | 178.0 | 178.13 | 178.0 | 178.08 | 669.0 |
| 2023-09-08 04:45:00 | AAPL | Stock | 178.06 | 178.11 | 178.04 | 178.04 | 649.0 |
| 2023-09-08 04:50:00 | AAPL | Stock | 178.0 | 178.0 | 178.0 | 178.0 | 218.0 |
| 2023-09-08 04:55:00 | AAPL | Stock | 178.04 | 178.04 | 177.75 | 177.75 | 1027.0 |
| 2023-09-08 05:00:00 | AAPL | Stock | 177.73 | 177.73 | 177.18 | 177.42 | 12837.0 |
| 2023-09-08 05:05:00 | AAPL | Stock | 177.46 | 177.68 | 177.46 | 177.46 | 7558.0 |
| 2023-09-08 05:10:00 | AAPL | Stock | 177.47 | 177.59 | 177.47 | 177.57 | 2862.0 |
| 2023-09-08 05:15:00 | AAPL | Stock | 177.53 | 177.59 | 177.47 | 177.47 | 20034.0 |
| 2023-09-08 05:20:00 | AAPL | Stock | 177.47 | 177.49 | 177.41 | 177.43 | 2600.0 |
| 2023-09-08 05:25:00 | AAPL | Stock | 177.45 | 177.5 | 177.38 | 177.5 | 1377.0 |
| 2023-09-08 05:30:00 | AAPL | Stock | 177.54 | 177.59 | 177.54 | 177.57 | 1174.0 |
| 2023-09-08 05:35:00 | AAPL | Stock | 177.57 | 177.59 | 177.54 | 177.55 | 4107.0 |
| 2023-09-08 05:40:00 | AAPL | Stock | 177.57 | 177.59 | 177.57 | 177.59 | 2578.0 |
| 2023-09-08 05:45:00 | AAPL | Stock | 177.59 | 177.77 | 177.59 | 177.76 | 8439.0 |
| 2023-09-08 05:50:00 | AAPL | Stock | 177.76 | 177.76 | 177.57 | 177.57 | 3677.0 |
| 2023-09-08 05:55:00 | AAPL | Stock | 177.52 | 177.53 | 177.5 | 177.53 | 702.0 |
| 2023-09-08 06:00:00 | AAPL | Stock | 177.52 | 177.52 | 177.5 | 177.5 | 600.0 |
| 2023-09-08 06:05:00 | AAPL | Stock | 177.51 | 177.51 | 177.16 | 177.2 | 4872.0 |
| 2023-09-08 06:10:00 | AAPL | Stock | 177.25 | 177.44 | 177.25 | 177.44 | 1290.0 |
| 2023-09-08 06:15:00 | AAPL | Stock | 177.46 | 177.46 | 177.45 | 177.46 | 1066.0 |
| 2023-09-08 06:20:00 | AAPL | Stock | 177.49 | 177.75 | 177.49 | 177.74 | 3328.0 |
| 2023-09-08 06:25:00 | AAPL | Stock | 177.73 | 177.75 | 177.72 | 177.73 | 1300.0 |
| 2023-09-08 06:30:00 | AAPL | Stock | 177.75 | 177.78 | 177.74 | 177.74 | 1356.0 |
| 2023-09-08 06:35:00 | AAPL | Stock | 177.78 | 177.78 | 177.16 | 177.54 | 6080.0 |
| 2023-09-08 06:40:00 | AAPL | Stock | 177.7 | 177.76 | 177.65 | 177.66 | 6845.0 |
| 2023-09-08 06:45:00 | AAPL | Stock | 177.65 | 177.65 | 177.65 | 177.65 | 100.0 |
| 2023-09-08 06:50:00 | AAPL | Stock | 177.69 | 177.72 | 177.69 | 177.71 | 1100.0 |
| 2023-09-08 06:55:00 | AAPL | Stock | 177.71 | 177.82 | 177.71 | 177.8 | 11729.0 |
| 2023-09-08 07:00:00 | AAPL | Stock | 177.78 | 177.82 | 177.45 | 177.77 | 68558.0 |
| 2023-09-08 07:05:00 | AAPL | Stock | 177.83 | 177.85 | 177.78 | 177.85 | 2720.0 |
| 2023-09-08 07:10:00 | AAPL | Stock | 177.82 | 177.89 | 177.8 | 177.8 | 1950.0 |
| 2023-09-08 07:15:00 | AAPL | Stock | 177.78 | 177.78 | 177.52 | 177.54 | 6906.0 |
| 2023-09-08 07:20:00 | AAPL | Stock | 177.6 | 177.63 | 177.52 | 177.52 | 6406.0 |
| 2023-09-08 07:25:00 | AAPL | Stock | 177.57 | 177.57 | 177.28 | 177.38 | 8655.0 |
| 2023-09-08 07:30:00 | AAPL | Stock | 177.35 | 177.47 | 177.26 | 177.46 | 4720.0 |
| 2023-09-08 07:35:00 | AAPL | Stock | 177.5 | 177.56 | 177.28 | 177.34 | 6655.0 |
| 2023-09-08 07:40:00 | AAPL | Stock | 177.4 | 177.4 | 177.31 | 177.31 | 10797.0 |
| 2023-09-08 07:45:00 | AAPL | Stock | 177.41 | 177.41 | 177.31 | 177.33 | 3061.0 |
| 2023-09-08 07:50:00 | AAPL | Stock | 177.33 | 177.4 | 177.24 | 177.4 | 7913.0 |
| 2023-09-08 07:55:00 | AAPL | Stock | 177.46 | 177.49 | 177.36 | 177.48 | 4102.0 |
| 2023-09-08 08:00:00 | AAPL | Stock | 177.7913 | 179.75 | 177.06 | 177.3287 | 133380.0 |
| 2023-09-08 08:05:00 | AAPL | Stock | 177.33 | 177.33 | 177.25 | 177.31 | 25335.0 |
> showing 50 of 385,692 rows — these rows as CSV