PREVIEW / stock_5min / 2000-07-27
file: by_date/stock_5min/2000/2000-07-27.parquet size: 1.2 MB rows: 87,913 symbols: 1,184
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-27 08:30:00 | AAPL | Stock | 0.894 | 0.894 | 0.8929 | 0.8929 | 140000.0 |
| 2000-07-27 08:40:00 | AAPL | Stock | 0.8884 | 0.8884 | 0.8884 | 0.8884 | 56000.0 |
| 2000-07-27 08:45:00 | AAPL | Stock | 0.8839 | 0.8839 | 0.8839 | 0.8839 | 56000.0 |
| 2000-07-27 09:10:00 | AAPL | Stock | 0.8862 | 0.8862 | 0.8862 | 0.8862 | 5600.0 |
| 2000-07-27 09:15:00 | AAPL | Stock | 0.8884 | 0.894 | 0.8884 | 0.894 | 61600.0 |
| 2000-07-27 09:20:00 | AAPL | Stock | 0.8884 | 0.8884 | 0.8884 | 0.8884 | 28000.0 |
| 2000-07-27 09:25:00 | AAPL | Stock | 0.8906 | 0.8929 | 0.8884 | 0.8917 | 128800.0 |
| 2000-07-27 09:30:00 | AAPL | Stock | 0.8929 | 0.894 | 0.8906 | 0.8934 | 2688000.0 |
| 2000-07-27 09:35:00 | AAPL | Stock | 0.8934 | 0.9029 | 0.8906 | 0.8984 | 3001600.0 |
| 2000-07-27 09:40:00 | AAPL | Stock | 0.8984 | 0.9085 | 0.8973 | 0.9074 | 4065600.0 |
| 2000-07-27 09:45:00 | AAPL | Stock | 0.9085 | 0.9174 | 0.9051 | 0.9129 | 2956800.0 |
| 2000-07-27 09:50:00 | AAPL | Stock | 0.9141 | 0.9196 | 0.9107 | 0.9118 | 4116000.0 |
| 2000-07-27 09:55:00 | AAPL | Stock | 0.9118 | 0.9174 | 0.9107 | 0.9129 | 1764000.0 |
| 2000-07-27 10:00:00 | AAPL | Stock | 0.9152 | 0.9152 | 0.9107 | 0.9107 | 6770400.0 |
| 2000-07-27 10:05:00 | AAPL | Stock | 0.9085 | 0.9118 | 0.9063 | 0.9063 | 4989600.0 |
| 2000-07-27 10:10:00 | AAPL | Stock | 0.9063 | 0.9074 | 0.904 | 0.9074 | 6216000.0 |
| 2000-07-27 10:15:00 | AAPL | Stock | 0.9063 | 0.9107 | 0.9063 | 0.9107 | 4166400.0 |
| 2000-07-27 10:20:00 | AAPL | Stock | 0.9107 | 0.9129 | 0.9096 | 0.9118 | 4799200.0 |
| 2000-07-27 10:25:00 | AAPL | Stock | 0.9129 | 0.9219 | 0.9107 | 0.9202 | 7750400.0 |
| 2000-07-27 10:30:00 | AAPL | Stock | 0.9208 | 0.9219 | 0.9163 | 0.9196 | 4104800.0 |
| 2000-07-27 10:35:00 | AAPL | Stock | 0.9185 | 0.9196 | 0.9152 | 0.9185 | 3376800.0 |
| 2000-07-27 10:40:00 | AAPL | Stock | 0.9152 | 0.9219 | 0.9129 | 0.9152 | 3152800.0 |
| 2000-07-27 10:45:00 | AAPL | Stock | 0.9152 | 0.9196 | 0.9129 | 0.9152 | 1696800.0 |
| 2000-07-27 10:50:00 | AAPL | Stock | 0.9152 | 0.9174 | 0.9141 | 0.9163 | 1288000.0 |
| 2000-07-27 10:55:00 | AAPL | Stock | 0.9174 | 0.9196 | 0.9141 | 0.9163 | 1590400.0 |
| 2000-07-27 11:00:00 | AAPL | Stock | 0.9174 | 0.9196 | 0.9141 | 0.9141 | 2228800.0 |
| 2000-07-27 11:05:00 | AAPL | Stock | 0.9129 | 0.9152 | 0.9129 | 0.9129 | 1562400.0 |
| 2000-07-27 11:10:00 | AAPL | Stock | 0.9129 | 0.9152 | 0.9107 | 0.9141 | 1982400.0 |
| 2000-07-27 11:15:00 | AAPL | Stock | 0.9141 | 0.9152 | 0.9118 | 0.9141 | 453600.0 |
| 2000-07-27 11:20:00 | AAPL | Stock | 0.9141 | 0.9174 | 0.9129 | 0.9163 | 2984800.0 |
| 2000-07-27 11:25:00 | AAPL | Stock | 0.9141 | 0.9152 | 0.9129 | 0.9152 | 1226400.0 |
| 2000-07-27 11:30:00 | AAPL | Stock | 0.9163 | 0.9163 | 0.9118 | 0.9118 | 4435200.0 |
| 2000-07-27 11:35:00 | AAPL | Stock | 0.9129 | 0.9152 | 0.9118 | 0.9129 | 8842400.0 |
| 2000-07-27 11:40:00 | AAPL | Stock | 0.9118 | 0.9141 | 0.9118 | 0.9141 | 1058400.0 |
| 2000-07-27 11:45:00 | AAPL | Stock | 0.9141 | 0.9141 | 0.9129 | 0.9141 | 476000.0 |
| 2000-07-27 11:50:00 | AAPL | Stock | 0.9141 | 0.9152 | 0.9129 | 0.9141 | 778400.0 |
| 2000-07-27 11:55:00 | AAPL | Stock | 0.9141 | 0.9163 | 0.9141 | 0.9152 | 3001600.0 |
| 2000-07-27 12:00:00 | AAPL | Stock | 0.9141 | 0.9152 | 0.9118 | 0.9129 | 1792000.0 |
| 2000-07-27 12:05:00 | AAPL | Stock | 0.9129 | 0.9152 | 0.9129 | 0.9141 | 1411200.0 |
| 2000-07-27 12:10:00 | AAPL | Stock | 0.9141 | 0.9163 | 0.9129 | 0.9141 | 845600.0 |
| 2000-07-27 12:15:00 | AAPL | Stock | 0.9152 | 0.9152 | 0.9141 | 0.9141 | 716800.0 |
| 2000-07-27 12:20:00 | AAPL | Stock | 0.9152 | 0.9152 | 0.9118 | 0.9129 | 7268800.0 |
| 2000-07-27 12:25:00 | AAPL | Stock | 0.9141 | 0.9174 | 0.9129 | 0.9157 | 6764800.0 |
| 2000-07-27 12:30:00 | AAPL | Stock | 0.9174 | 0.9174 | 0.9152 | 0.9152 | 487200.0 |
| 2000-07-27 12:35:00 | AAPL | Stock | 0.9157 | 0.9196 | 0.9152 | 0.9196 | 1439200.0 |
| 2000-07-27 12:40:00 | AAPL | Stock | 0.9196 | 0.9219 | 0.9174 | 0.9208 | 12460000.0 |
| 2000-07-27 12:45:00 | AAPL | Stock | 0.9208 | 0.9219 | 0.9185 | 0.9185 | 907200.0 |
| 2000-07-27 12:50:00 | AAPL | Stock | 0.9185 | 0.9191 | 0.9174 | 0.9174 | 274400.0 |
| 2000-07-27 12:55:00 | AAPL | Stock | 0.9174 | 0.918 | 0.9118 | 0.9174 | 3119200.0 |
| 2000-07-27 13:00:00 | AAPL | Stock | 0.9141 | 0.9174 | 0.9129 | 0.9129 | 1618400.0 |
> showing 50 of 87,913 rows — these rows as CSV