PREVIEW / stock_5min / 2022-12-05
file: by_date/stock_5min/2022/2022-12-05.parquet size: 6.9 MB rows: 427,652 symbols: 2,056
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-12-05 04:00:00 | AAPL | Stock | 148.0 | 148.0 | 147.66 | 147.9 | 2992.0 |
| 2022-12-05 04:05:00 | AAPL | Stock | 147.86 | 147.86 | 147.5 | 147.51 | 28435.0 |
| 2022-12-05 04:10:00 | AAPL | Stock | 147.53 | 147.53 | 147.37 | 147.4 | 5623.0 |
| 2022-12-05 04:15:00 | AAPL | Stock | 147.57 | 147.61 | 147.54 | 147.57 | 1693.0 |
| 2022-12-05 04:20:00 | AAPL | Stock | 147.6 | 147.61 | 147.6 | 147.61 | 250.0 |
| 2022-12-05 04:25:00 | AAPL | Stock | 147.6 | 147.7 | 147.6 | 147.7 | 600.0 |
| 2022-12-05 04:30:00 | AAPL | Stock | 147.71 | 147.73 | 147.62 | 147.65 | 1047.0 |
| 2022-12-05 04:35:00 | AAPL | Stock | 147.57 | 147.7 | 147.57 | 147.7 | 450.0 |
| 2022-12-05 04:45:00 | AAPL | Stock | 147.74 | 147.75 | 147.74 | 147.75 | 1723.0 |
| 2022-12-05 04:50:00 | AAPL | Stock | 147.7 | 147.7 | 147.65 | 147.65 | 510.0 |
| 2022-12-05 04:55:00 | AAPL | Stock | 147.64 | 147.64 | 147.61 | 147.61 | 800.0 |
| 2022-12-05 05:05:00 | AAPL | Stock | 147.61 | 147.61 | 147.61 | 147.61 | 246.0 |
| 2022-12-05 05:10:00 | AAPL | Stock | 147.73 | 147.73 | 147.72 | 147.72 | 978.0 |
| 2022-12-05 05:15:00 | AAPL | Stock | 147.66 | 147.72 | 147.62 | 147.72 | 1155.0 |
| 2022-12-05 05:20:00 | AAPL | Stock | 147.65 | 147.65 | 147.59 | 147.59 | 979.0 |
| 2022-12-05 05:25:00 | AAPL | Stock | 147.63 | 147.73 | 147.6 | 147.65 | 1372.0 |
| 2022-12-05 05:30:00 | AAPL | Stock | 147.65 | 147.8 | 147.61 | 147.8 | 2088.0 |
| 2022-12-05 05:35:00 | AAPL | Stock | 147.64 | 147.64 | 147.64 | 147.64 | 500.0 |
| 2022-12-05 05:40:00 | AAPL | Stock | 147.77 | 147.9 | 147.77 | 147.9 | 4130.0 |
| 2022-12-05 05:45:00 | AAPL | Stock | 147.84 | 147.88 | 147.8 | 147.88 | 1280.0 |
| 2022-12-05 05:50:00 | AAPL | Stock | 147.81 | 147.81 | 147.8 | 147.8 | 1801.0 |
| 2022-12-05 05:55:00 | AAPL | Stock | 147.85 | 147.85 | 147.83 | 147.85 | 353.0 |
| 2022-12-05 06:00:00 | AAPL | Stock | 147.85 | 147.85 | 147.85 | 147.85 | 100.0 |
| 2022-12-05 06:05:00 | AAPL | Stock | 147.86 | 147.9 | 147.86 | 147.9 | 976.0 |
| 2022-12-05 06:10:00 | AAPL | Stock | 147.96 | 148.1 | 147.96 | 148.06 | 7177.0 |
| 2022-12-05 06:15:00 | AAPL | Stock | 148.0 | 148.01 | 147.91 | 147.97 | 990.0 |
| 2022-12-05 06:20:00 | AAPL | Stock | 148.06 | 148.06 | 148.06 | 148.06 | 505.0 |
| 2022-12-05 06:30:00 | AAPL | Stock | 147.89 | 147.98 | 147.89 | 147.94 | 1370.0 |
| 2022-12-05 06:35:00 | AAPL | Stock | 148.0 | 148.0 | 148.0 | 148.0 | 450.0 |
| 2022-12-05 06:40:00 | AAPL | Stock | 147.96 | 147.99 | 147.96 | 147.98 | 543.0 |
| 2022-12-05 06:45:00 | AAPL | Stock | 147.98 | 148.18 | 147.98 | 148.18 | 4564.0 |
| 2022-12-05 06:50:00 | AAPL | Stock | 148.09 | 148.19 | 148.08 | 148.19 | 1165.0 |
| 2022-12-05 06:55:00 | AAPL | Stock | 148.1 | 148.42 | 148.09 | 148.29 | 6006.0 |
| 2022-12-05 07:00:00 | AAPL | Stock | 148.15 | 148.28 | 148.03 | 148.2 | 6202.0 |
| 2022-12-05 07:05:00 | AAPL | Stock | 148.21 | 148.21 | 148.15 | 148.15 | 6687.0 |
| 2022-12-05 07:10:00 | AAPL | Stock | 148.2 | 148.2 | 148.14 | 148.19 | 10633.0 |
| 2022-12-05 07:15:00 | AAPL | Stock | 148.17 | 148.17 | 147.9 | 147.92 | 7732.0 |
| 2022-12-05 07:20:00 | AAPL | Stock | 147.97 | 147.97 | 147.81 | 147.81 | 5516.0 |
| 2022-12-05 07:25:00 | AAPL | Stock | 147.75 | 147.8 | 147.59 | 147.61 | 14334.0 |
| 2022-12-05 07:30:00 | AAPL | Stock | 147.7 | 147.7 | 147.58 | 147.62 | 2897.0 |
| 2022-12-05 07:35:00 | AAPL | Stock | 147.59 | 147.66 | 147.54 | 147.59 | 7848.0 |
| 2022-12-05 07:40:00 | AAPL | Stock | 147.64 | 147.73 | 147.64 | 147.67 | 2074.0 |
| 2022-12-05 07:45:00 | AAPL | Stock | 147.66 | 147.72 | 147.63 | 147.67 | 3460.0 |
| 2022-12-05 07:50:00 | AAPL | Stock | 147.69 | 147.7 | 147.69 | 147.7 | 200.0 |
| 2022-12-05 07:55:00 | AAPL | Stock | 147.74 | 147.8 | 147.74 | 147.78 | 3363.0 |
| 2022-12-05 08:00:00 | AAPL | Stock | 148.07 | 148.21 | 147.55 | 147.75 | 58189.0 |
| 2022-12-05 08:05:00 | AAPL | Stock | 147.75 | 147.83 | 147.441 | 147.68 | 19035.0 |
| 2022-12-05 08:10:00 | AAPL | Stock | 147.68 | 147.69 | 147.6 | 147.65 | 8323.0 |
| 2022-12-05 08:15:00 | AAPL | Stock | 147.6 | 147.69 | 147.57 | 147.68 | 9470.0 |
| 2022-12-05 08:20:00 | AAPL | Stock | 147.65 | 147.9 | 147.65 | 147.9 | 13709.0 |
> showing 50 of 427,652 rows — these rows as CSV