PREVIEW / stock_5min / 2000-02-23
file: by_date/stock_5min/2000/2000-02-23.parquet size: 1.1 MB rows: 88,558 symbols: 1,137
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-02-23 09:30:00 | AAPL | Stock | 1.0109 | 1.0173 | 1.0109 | 1.0167 | 7168000.0 |
| 2000-02-23 09:35:00 | AAPL | Stock | 1.0173 | 1.0234 | 1.0151 | 1.0156 | 6899200.0 |
| 2000-02-23 09:40:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0056 | 1.0056 | 5667200.0 |
| 2000-02-23 09:45:00 | AAPL | Stock | 1.0056 | 1.0061 | 0.9911 | 0.9927 | 6137600.0 |
| 2000-02-23 09:50:00 | AAPL | Stock | 0.9927 | 1.0011 | 0.9922 | 0.995 | 5353600.0 |
| 2000-02-23 09:55:00 | AAPL | Stock | 0.995 | 1.0078 | 0.9944 | 1.0078 | 3528000.0 |
| 2000-02-23 10:00:00 | AAPL | Stock | 1.0078 | 1.0212 | 1.0078 | 1.0117 | 5409600.0 |
| 2000-02-23 10:05:00 | AAPL | Stock | 1.0117 | 1.0179 | 1.0084 | 1.0173 | 2520000.0 |
| 2000-02-23 10:10:00 | AAPL | Stock | 1.0179 | 1.0206 | 1.01 | 1.01 | 2228800.0 |
| 2000-02-23 10:15:00 | AAPL | Stock | 1.01 | 1.014 | 1.0022 | 1.0061 | 4681600.0 |
| 2000-02-23 10:20:00 | AAPL | Stock | 1.0056 | 1.0173 | 1.0033 | 1.0156 | 3516800.0 |
| 2000-02-23 10:25:00 | AAPL | Stock | 1.0167 | 1.0173 | 1.0117 | 1.0134 | 2363200.0 |
| 2000-02-23 10:30:00 | AAPL | Stock | 1.0134 | 1.0212 | 1.0112 | 1.0206 | 3584000.0 |
| 2000-02-23 10:35:00 | AAPL | Stock | 1.0206 | 1.0268 | 1.019 | 1.0268 | 4323200.0 |
| 2000-02-23 10:40:00 | AAPL | Stock | 1.0268 | 1.0307 | 1.0257 | 1.0262 | 8265600.0 |
| 2000-02-23 10:45:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.024 | 1.024 | 4065600.0 |
| 2000-02-23 10:50:00 | AAPL | Stock | 1.0246 | 1.0268 | 1.0246 | 1.0246 | 2721600.0 |
| 2000-02-23 10:55:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0195 | 1.0212 | 2934400.0 |
| 2000-02-23 11:00:00 | AAPL | Stock | 1.0212 | 1.0285 | 1.0201 | 1.0246 | 4894400.0 |
| 2000-02-23 11:05:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0234 | 1.0234 | 2755200.0 |
| 2000-02-23 11:10:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0167 | 1.0167 | 4670400.0 |
| 2000-02-23 11:15:00 | AAPL | Stock | 1.0167 | 1.0176 | 1.0156 | 1.0162 | 2576000.0 |
| 2000-02-23 11:20:00 | AAPL | Stock | 1.0167 | 1.0206 | 1.0162 | 1.0173 | 1131200.0 |
| 2000-02-23 11:25:00 | AAPL | Stock | 1.0193 | 1.0204 | 1.0184 | 1.0201 | 1500800.0 |
| 2000-02-23 11:30:00 | AAPL | Stock | 1.0195 | 1.0246 | 1.0179 | 1.0223 | 4009600.0 |
| 2000-02-23 11:35:00 | AAPL | Stock | 1.024 | 1.029 | 1.0234 | 1.029 | 3808000.0 |
| 2000-02-23 11:40:00 | AAPL | Stock | 1.0282 | 1.0296 | 1.0268 | 1.029 | 2273600.0 |
| 2000-02-23 11:45:00 | AAPL | Stock | 1.029 | 1.029 | 1.0268 | 1.029 | 4569600.0 |
| 2000-02-23 11:50:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0273 | 1.0273 | 3158400.0 |
| 2000-02-23 11:55:00 | AAPL | Stock | 1.0262 | 1.0279 | 1.0257 | 1.0268 | 4009600.0 |
| 2000-02-23 12:00:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0268 | 1.029 | 5947200.0 |
| 2000-02-23 12:05:00 | AAPL | Stock | 1.029 | 1.029 | 1.0268 | 1.029 | 8545600.0 |
| 2000-02-23 12:10:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0279 | 1.029 | 2139200.0 |
| 2000-02-23 12:15:00 | AAPL | Stock | 1.029 | 1.029 | 1.024 | 1.0257 | 2352000.0 |
| 2000-02-23 12:20:00 | AAPL | Stock | 1.0257 | 1.0279 | 1.0257 | 1.0257 | 1937600.0 |
| 2000-02-23 12:25:00 | AAPL | Stock | 1.0257 | 1.0262 | 1.0212 | 1.0218 | 1948800.0 |
| 2000-02-23 12:30:00 | AAPL | Stock | 1.0218 | 1.029 | 1.0218 | 1.0285 | 2576000.0 |
| 2000-02-23 12:35:00 | AAPL | Stock | 1.0279 | 1.0285 | 1.0246 | 1.0279 | 1086400.0 |
| 2000-02-23 12:40:00 | AAPL | Stock | 1.0285 | 1.029 | 1.0279 | 1.0282 | 828800.0 |
| 2000-02-23 12:45:00 | AAPL | Stock | 1.0279 | 1.0279 | 1.0265 | 1.0265 | 1915200.0 |
| 2000-02-23 12:50:00 | AAPL | Stock | 1.0246 | 1.0279 | 1.0246 | 1.0273 | 2520000.0 |
| 2000-02-23 12:55:00 | AAPL | Stock | 1.0273 | 1.0285 | 1.0268 | 1.0273 | 3091200.0 |
| 2000-02-23 13:00:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0268 | 1.0279 | 5432000.0 |
| 2000-02-23 13:05:00 | AAPL | Stock | 1.0279 | 1.0368 | 1.0279 | 1.0366 | 22209600.0 |
| 2000-02-23 13:10:00 | AAPL | Stock | 1.0368 | 1.0368 | 1.0324 | 1.034 | 7190400.0 |
| 2000-02-23 13:15:00 | AAPL | Stock | 1.034 | 1.0424 | 1.0329 | 1.0391 | 4233600.0 |
| 2000-02-23 13:20:00 | AAPL | Stock | 1.0391 | 1.0446 | 1.0379 | 1.0441 | 5880000.0 |
| 2000-02-23 13:25:00 | AAPL | Stock | 1.0435 | 1.0485 | 1.0391 | 1.0469 | 8814400.0 |
| 2000-02-23 13:30:00 | AAPL | Stock | 1.0463 | 1.0525 | 1.0463 | 1.0522 | 7750400.0 |
| 2000-02-23 13:35:00 | AAPL | Stock | 1.0525 | 1.0525 | 1.048 | 1.0485 | 11401600.0 |
> showing 50 of 88,558 rows — these rows as CSV