PREVIEW / stock_5min / 2023-12-26
file: by_date/stock_5min/2023/2023-12-26.parquet size: 6.8 MB rows: 407,416 symbols: 1,219
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-12-26 04:00:00 | AAPL | Stock | 193.8 | 194.12 | 193.8 | 194.12 | 1330.0 |
| 2023-12-26 04:10:00 | AAPL | Stock | 194.02 | 194.02 | 194.0 | 194.0 | 301.0 |
| 2023-12-26 04:20:00 | AAPL | Stock | 193.82 | 193.82 | 193.76 | 193.76 | 1150.0 |
| 2023-12-26 04:25:00 | AAPL | Stock | 193.89 | 193.89 | 193.89 | 193.89 | 100.0 |
| 2023-12-26 04:35:00 | AAPL | Stock | 194.0 | 194.0 | 194.0 | 194.0 | 1982.0 |
| 2023-12-26 04:40:00 | AAPL | Stock | 194.0 | 194.0 | 194.0 | 194.0 | 700.0 |
| 2023-12-26 04:45:00 | AAPL | Stock | 193.96 | 193.96 | 193.96 | 193.96 | 163.0 |
| 2023-12-26 04:50:00 | AAPL | Stock | 193.93 | 193.93 | 193.93 | 193.93 | 117.0 |
| 2023-12-26 04:55:00 | AAPL | Stock | 193.81 | 193.83 | 193.81 | 193.81 | 1274.0 |
| 2023-12-26 05:00:00 | AAPL | Stock | 193.83 | 193.83 | 193.83 | 193.83 | 100.0 |
| 2023-12-26 05:05:00 | AAPL | Stock | 193.92 | 193.92 | 193.9 | 193.9 | 482.0 |
| 2023-12-26 05:15:00 | AAPL | Stock | 193.83 | 193.83 | 193.83 | 193.83 | 100.0 |
| 2023-12-26 05:35:00 | AAPL | Stock | 193.85 | 193.85 | 193.85 | 193.85 | 100.0 |
| 2023-12-26 05:40:00 | AAPL | Stock | 193.85 | 193.85 | 193.84 | 193.84 | 202.0 |
| 2023-12-26 06:05:00 | AAPL | Stock | 193.89 | 193.89 | 193.89 | 193.89 | 100.0 |
| 2023-12-26 06:10:00 | AAPL | Stock | 193.87 | 193.87 | 193.87 | 193.87 | 111.0 |
| 2023-12-26 06:15:00 | AAPL | Stock | 193.83 | 193.83 | 193.83 | 193.83 | 100.0 |
| 2023-12-26 06:40:00 | AAPL | Stock | 193.89 | 193.89 | 193.89 | 193.89 | 192.0 |
| 2023-12-26 06:45:00 | AAPL | Stock | 193.85 | 193.85 | 193.85 | 193.85 | 200.0 |
| 2023-12-26 06:50:00 | AAPL | Stock | 193.87 | 193.87 | 193.87 | 193.87 | 100.0 |
| 2023-12-26 06:55:00 | AAPL | Stock | 193.87 | 193.87 | 193.87 | 193.87 | 141.0 |
| 2023-12-26 07:00:00 | AAPL | Stock | 193.85 | 193.85 | 193.84 | 193.84 | 734.0 |
| 2023-12-26 07:05:00 | AAPL | Stock | 193.88 | 193.88 | 193.7 | 193.7 | 4385.0 |
| 2023-12-26 07:10:00 | AAPL | Stock | 193.72 | 193.8 | 193.72 | 193.8 | 383.0 |
| 2023-12-26 07:15:00 | AAPL | Stock | 193.71 | 193.75 | 193.71 | 193.75 | 490.0 |
| 2023-12-26 07:20:00 | AAPL | Stock | 193.76 | 193.76 | 193.72 | 193.72 | 1108.0 |
| 2023-12-26 07:30:00 | AAPL | Stock | 193.74 | 193.74 | 193.74 | 193.74 | 100.0 |
| 2023-12-26 07:35:00 | AAPL | Stock | 193.76 | 193.8 | 193.76 | 193.8 | 966.0 |
| 2023-12-26 07:40:00 | AAPL | Stock | 193.8 | 193.8 | 193.8 | 193.8 | 263.0 |
| 2023-12-26 07:45:00 | AAPL | Stock | 193.82 | 193.88 | 193.82 | 193.85 | 1690.0 |
| 2023-12-26 07:50:00 | AAPL | Stock | 193.85 | 193.85 | 193.85 | 193.85 | 732.0 |
| 2023-12-26 07:55:00 | AAPL | Stock | 193.87 | 193.87 | 193.87 | 193.87 | 127.0 |
| 2023-12-26 08:00:00 | AAPL | Stock | 193.85 | 194.02 | 193.59 | 193.59 | 31638.0 |
| 2023-12-26 08:05:00 | AAPL | Stock | 193.83 | 193.87 | 193.116 | 193.82 | 5171.0 |
| 2023-12-26 08:10:00 | AAPL | Stock | 193.82 | 193.83 | 193.8 | 193.8 | 1037.0 |
| 2023-12-26 08:15:00 | AAPL | Stock | 193.8 | 193.8 | 193.75 | 193.75 | 3652.0 |
| 2023-12-26 08:20:00 | AAPL | Stock | 193.75 | 193.76 | 193.7006 | 193.7405 | 6642.0 |
| 2023-12-26 08:25:00 | AAPL | Stock | 193.75 | 193.76 | 193.7199 | 193.7294 | 1852.0 |
| 2023-12-26 08:30:00 | AAPL | Stock | 193.7291 | 193.73 | 193.58 | 193.58 | 6610.0 |
| 2023-12-26 08:35:00 | AAPL | Stock | 193.56 | 193.56 | 193.44 | 193.45 | 8640.0 |
| 2023-12-26 08:40:00 | AAPL | Stock | 193.45 | 193.53 | 193.36 | 193.36 | 2223.0 |
| 2023-12-26 08:45:00 | AAPL | Stock | 193.36 | 193.39 | 193.26 | 193.38 | 4699.0 |
| 2023-12-26 08:50:00 | AAPL | Stock | 193.3701 | 193.45 | 193.3701 | 193.4 | 4362.0 |
| 2023-12-26 08:55:00 | AAPL | Stock | 193.45 | 193.53 | 193.45 | 193.5294 | 9790.0 |
| 2023-12-26 09:00:00 | AAPL | Stock | 193.53 | 193.549 | 193.51 | 193.53 | 2717.0 |
| 2023-12-26 09:05:00 | AAPL | Stock | 193.53 | 193.6 | 193.53 | 193.6 | 2760.0 |
| 2023-12-26 09:10:00 | AAPL | Stock | 193.59 | 193.67 | 193.59 | 193.6498 | 3982.0 |
| 2023-12-26 09:15:00 | AAPL | Stock | 193.6691 | 193.67 | 193.59 | 193.59 | 2152.0 |
| 2023-12-26 09:20:00 | AAPL | Stock | 193.57 | 193.7 | 193.57 | 193.7 | 13880.0 |
| 2023-12-26 09:25:00 | AAPL | Stock | 193.68 | 193.68 | 193.53 | 193.62 | 29842.0 |
> showing 50 of 407,416 rows — these rows as CSV