PREVIEW / stock_5min / 2023-06-09
file: by_date/stock_5min/2023/2023-06-09.parquet size: 6.6 MB rows: 402,975 symbols: 1,617
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-06-09 04:00:00 | AAPL | Stock | 180.19 | 180.19 | 180.1 | 180.1 | 1060.0 |
| 2023-06-09 04:05:00 | AAPL | Stock | 180.12 | 180.12 | 180.01 | 180.01 | 2718.0 |
| 2023-06-09 04:10:00 | AAPL | Stock | 180.01 | 180.06 | 180.0 | 180.06 | 9390.0 |
| 2023-06-09 04:15:00 | AAPL | Stock | 180.06 | 180.13 | 180.04 | 180.12 | 2546.0 |
| 2023-06-09 04:20:00 | AAPL | Stock | 180.02 | 180.06 | 180.01 | 180.06 | 2841.0 |
| 2023-06-09 04:25:00 | AAPL | Stock | 180.03 | 180.25 | 180.02 | 180.22 | 2831.0 |
| 2023-06-09 04:30:00 | AAPL | Stock | 180.22 | 180.23 | 180.18 | 180.2 | 3393.0 |
| 2023-06-09 04:35:00 | AAPL | Stock | 180.2 | 180.2 | 180.2 | 180.2 | 354.0 |
| 2023-06-09 04:40:00 | AAPL | Stock | 180.28 | 180.3 | 180.28 | 180.3 | 1970.0 |
| 2023-06-09 04:45:00 | AAPL | Stock | 180.3 | 180.35 | 180.3 | 180.35 | 2530.0 |
| 2023-06-09 04:50:00 | AAPL | Stock | 180.36 | 180.42 | 180.35 | 180.35 | 2117.0 |
| 2023-06-09 04:55:00 | AAPL | Stock | 180.39 | 180.4 | 180.35 | 180.4 | 649.0 |
| 2023-06-09 05:00:00 | AAPL | Stock | 180.39 | 180.39 | 180.32 | 180.32 | 1443.0 |
| 2023-06-09 05:05:00 | AAPL | Stock | 180.5 | 180.5 | 180.38 | 180.38 | 1828.0 |
| 2023-06-09 05:10:00 | AAPL | Stock | 180.46 | 180.5 | 180.45 | 180.5 | 15805.0 |
| 2023-06-09 05:15:00 | AAPL | Stock | 180.4 | 180.4 | 180.38 | 180.38 | 1364.0 |
| 2023-06-09 05:20:00 | AAPL | Stock | 180.38 | 180.38 | 180.3 | 180.3 | 673.0 |
| 2023-06-09 05:25:00 | AAPL | Stock | 180.4 | 180.4 | 180.4 | 180.4 | 200.0 |
| 2023-06-09 05:30:00 | AAPL | Stock | 180.47 | 180.47 | 180.47 | 180.47 | 300.0 |
| 2023-06-09 05:35:00 | AAPL | Stock | 180.4 | 180.4 | 180.31 | 180.36 | 2832.0 |
| 2023-06-09 05:40:00 | AAPL | Stock | 180.32 | 180.35 | 180.29 | 180.29 | 3119.0 |
| 2023-06-09 05:45:00 | AAPL | Stock | 180.25 | 180.25 | 180.25 | 180.25 | 147.0 |
| 2023-06-09 05:50:00 | AAPL | Stock | 180.24 | 180.24 | 180.24 | 180.24 | 1170.0 |
| 2023-06-09 06:00:00 | AAPL | Stock | 180.25 | 180.35 | 180.25 | 180.35 | 343.0 |
| 2023-06-09 06:05:00 | AAPL | Stock | 180.35 | 180.35 | 180.35 | 180.35 | 148.0 |
| 2023-06-09 06:10:00 | AAPL | Stock | 180.35 | 180.36 | 180.21 | 180.21 | 3516.0 |
| 2023-06-09 06:15:00 | AAPL | Stock | 180.22 | 180.27 | 180.2 | 180.27 | 3030.0 |
| 2023-06-09 06:20:00 | AAPL | Stock | 180.27 | 180.3 | 180.2 | 180.29 | 4131.0 |
| 2023-06-09 06:25:00 | AAPL | Stock | 180.3 | 180.37 | 180.3 | 180.37 | 662.0 |
| 2023-06-09 06:30:00 | AAPL | Stock | 180.25 | 180.25 | 180.2 | 180.2 | 1809.0 |
| 2023-06-09 06:35:00 | AAPL | Stock | 180.25 | 180.26 | 180.2 | 180.2 | 2881.0 |
| 2023-06-09 06:40:00 | AAPL | Stock | 180.25 | 180.25 | 180.13 | 180.13 | 2039.0 |
| 2023-06-09 06:45:00 | AAPL | Stock | 180.15 | 180.27 | 180.15 | 180.23 | 1138.0 |
| 2023-06-09 06:50:00 | AAPL | Stock | 180.25 | 180.25 | 180.25 | 180.25 | 100.0 |
| 2023-06-09 06:55:00 | AAPL | Stock | 180.38 | 180.38 | 180.38 | 180.38 | 219.0 |
| 2023-06-09 07:00:00 | AAPL | Stock | 180.39 | 180.39 | 180.07 | 180.07 | 6818.0 |
| 2023-06-09 07:05:00 | AAPL | Stock | 180.18 | 180.25 | 180.1 | 180.25 | 959.0 |
| 2023-06-09 07:10:00 | AAPL | Stock | 180.23 | 180.3 | 180.22 | 180.3 | 729.0 |
| 2023-06-09 07:15:00 | AAPL | Stock | 180.34 | 180.5 | 180.25 | 180.5 | 4201.0 |
| 2023-06-09 07:20:00 | AAPL | Stock | 180.4 | 180.4 | 180.24 | 180.34 | 919.0 |
| 2023-06-09 07:25:00 | AAPL | Stock | 180.35 | 180.4 | 180.35 | 180.35 | 1348.0 |
| 2023-06-09 07:30:00 | AAPL | Stock | 180.42 | 180.42 | 180.42 | 180.42 | 200.0 |
| 2023-06-09 07:35:00 | AAPL | Stock | 180.53 | 180.55 | 180.5 | 180.53 | 1219.0 |
| 2023-06-09 07:40:00 | AAPL | Stock | 180.5 | 180.65 | 180.49 | 180.6 | 5963.0 |
| 2023-06-09 07:45:00 | AAPL | Stock | 180.56 | 180.69 | 180.56 | 180.65 | 2611.0 |
| 2023-06-09 07:50:00 | AAPL | Stock | 180.69 | 180.7 | 180.58 | 180.58 | 5890.0 |
| 2023-06-09 07:55:00 | AAPL | Stock | 180.58 | 180.59 | 180.51 | 180.55 | 1600.0 |
| 2023-06-09 08:00:00 | AAPL | Stock | 180.45 | 180.7 | 180.05 | 180.7 | 36208.0 |
| 2023-06-09 08:05:00 | AAPL | Stock | 180.6136 | 180.8 | 180.6001 | 180.8 | 6664.0 |
| 2023-06-09 08:10:00 | AAPL | Stock | 180.7612 | 180.85 | 180.75 | 180.82 | 8419.0 |
> showing 50 of 402,975 rows — these rows as CSV