PREVIEW / stock_5min / 2023-03-23
file: by_date/stock_5min/2023/2023-03-23.parquet size: 6.8 MB rows: 417,335 symbols: 1,728
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-03-23 04:00:00 | AAPL | Stock | 159.02 | 159.48 | 158.52 | 159.48 | 7523.0 |
| 2023-03-23 04:05:00 | AAPL | Stock | 159.48 | 159.5 | 159.45 | 159.49 | 3249.0 |
| 2023-03-23 04:10:00 | AAPL | Stock | 159.49 | 159.49 | 159.39 | 159.39 | 4471.0 |
| 2023-03-23 04:15:00 | AAPL | Stock | 159.42 | 159.65 | 159.42 | 159.64 | 4346.0 |
| 2023-03-23 04:20:00 | AAPL | Stock | 159.6 | 159.62 | 159.59 | 159.59 | 1679.0 |
| 2023-03-23 04:25:00 | AAPL | Stock | 159.59 | 159.61 | 159.54 | 159.54 | 305.0 |
| 2023-03-23 04:30:00 | AAPL | Stock | 159.5 | 159.6 | 159.5 | 159.51 | 1220.0 |
| 2023-03-23 04:35:00 | AAPL | Stock | 159.5 | 159.5 | 159.42 | 159.42 | 495.0 |
| 2023-03-23 04:40:00 | AAPL | Stock | 159.44 | 159.59 | 159.44 | 159.58 | 1526.0 |
| 2023-03-23 04:45:00 | AAPL | Stock | 159.64 | 159.7 | 159.64 | 159.7 | 4263.0 |
| 2023-03-23 04:50:00 | AAPL | Stock | 159.77 | 159.78 | 159.75 | 159.77 | 1084.0 |
| 2023-03-23 04:55:00 | AAPL | Stock | 159.73 | 159.75 | 159.71 | 159.71 | 1250.0 |
| 2023-03-23 05:00:00 | AAPL | Stock | 159.72 | 159.72 | 159.56 | 159.56 | 3583.0 |
| 2023-03-23 05:05:00 | AAPL | Stock | 159.6 | 159.61 | 159.6 | 159.6 | 18771.0 |
| 2023-03-23 05:10:00 | AAPL | Stock | 159.59 | 159.79 | 159.59 | 159.79 | 2209.0 |
| 2023-03-23 05:15:00 | AAPL | Stock | 159.61 | 159.61 | 159.5 | 159.55 | 3847.0 |
| 2023-03-23 05:20:00 | AAPL | Stock | 159.65 | 159.66 | 159.65 | 159.66 | 1550.0 |
| 2023-03-23 05:25:00 | AAPL | Stock | 159.53 | 159.53 | 159.52 | 159.52 | 337.0 |
| 2023-03-23 05:30:00 | AAPL | Stock | 159.56 | 159.56 | 159.44 | 159.55 | 1953.0 |
| 2023-03-23 05:35:00 | AAPL | Stock | 159.6 | 159.72 | 159.58 | 159.58 | 1960.0 |
| 2023-03-23 05:40:00 | AAPL | Stock | 159.7 | 159.7 | 159.61 | 159.61 | 1773.0 |
| 2023-03-23 05:45:00 | AAPL | Stock | 159.65 | 159.74 | 159.65 | 159.74 | 409.0 |
| 2023-03-23 05:50:00 | AAPL | Stock | 159.61 | 159.82 | 159.61 | 159.8 | 1177.0 |
| 2023-03-23 05:55:00 | AAPL | Stock | 159.7 | 159.75 | 159.7 | 159.7 | 2835.0 |
| 2023-03-23 06:00:00 | AAPL | Stock | 159.75 | 159.75 | 159.75 | 159.75 | 118.0 |
| 2023-03-23 06:05:00 | AAPL | Stock | 159.82 | 159.82 | 159.82 | 159.82 | 270.0 |
| 2023-03-23 06:10:00 | AAPL | Stock | 159.69 | 159.73 | 159.51 | 159.51 | 1398.0 |
| 2023-03-23 06:15:00 | AAPL | Stock | 159.6 | 159.6 | 159.52 | 159.59 | 1429.0 |
| 2023-03-23 06:20:00 | AAPL | Stock | 159.55 | 159.55 | 159.38 | 159.38 | 5248.0 |
| 2023-03-23 06:25:00 | AAPL | Stock | 159.45 | 159.69 | 159.45 | 159.56 | 1498.0 |
| 2023-03-23 06:30:00 | AAPL | Stock | 159.51 | 159.51 | 159.33 | 159.35 | 2157.0 |
| 2023-03-23 06:35:00 | AAPL | Stock | 159.5 | 159.5 | 159.39 | 159.4 | 1664.0 |
| 2023-03-23 06:40:00 | AAPL | Stock | 159.44 | 159.44 | 159.4 | 159.4 | 776.0 |
| 2023-03-23 06:45:00 | AAPL | Stock | 159.53 | 159.58 | 159.53 | 159.58 | 550.0 |
| 2023-03-23 06:50:00 | AAPL | Stock | 159.6 | 159.6 | 159.6 | 159.6 | 505.0 |
| 2023-03-23 07:00:00 | AAPL | Stock | 159.61 | 159.74 | 159.43 | 159.74 | 16373.0 |
| 2023-03-23 07:05:00 | AAPL | Stock | 159.7 | 159.7 | 159.64 | 159.64 | 3101.0 |
| 2023-03-23 07:10:00 | AAPL | Stock | 159.66 | 159.77 | 159.62 | 159.77 | 3843.0 |
| 2023-03-23 07:15:00 | AAPL | Stock | 159.8 | 159.8 | 159.77 | 159.77 | 710.0 |
| 2023-03-23 07:20:00 | AAPL | Stock | 159.8 | 159.8 | 159.66 | 159.66 | 9475.0 |
| 2023-03-23 07:25:00 | AAPL | Stock | 159.62 | 159.62 | 159.6 | 159.61 | 1140.0 |
| 2023-03-23 07:30:00 | AAPL | Stock | 159.58 | 159.58 | 159.47 | 159.5 | 4339.0 |
| 2023-03-23 07:35:00 | AAPL | Stock | 159.6 | 159.65 | 159.55 | 159.55 | 7094.0 |
| 2023-03-23 07:40:00 | AAPL | Stock | 159.54 | 159.57 | 159.52 | 159.55 | 962.0 |
| 2023-03-23 07:45:00 | AAPL | Stock | 159.59 | 159.7 | 159.59 | 159.59 | 1674.0 |
| 2023-03-23 07:50:00 | AAPL | Stock | 159.59 | 159.61 | 159.45 | 159.6 | 5960.0 |
| 2023-03-23 07:55:00 | AAPL | Stock | 159.63 | 159.68 | 159.43 | 159.45 | 3946.0 |
| 2023-03-23 08:00:00 | AAPL | Stock | 159.7 | 159.85 | 158.44 | 159.32 | 69933.0 |
| 2023-03-23 08:05:00 | AAPL | Stock | 159.18 | 159.35 | 159.18 | 159.24 | 7945.0 |
| 2023-03-23 08:10:00 | AAPL | Stock | 159.28 | 159.34 | 159.16 | 159.2379 | 6163.0 |
> showing 50 of 417,335 rows — these rows as CSV