PREVIEW / stock_5min / 2000-07-17
file: by_date/stock_5min/2000/2000-07-17.parquet size: 1.2 MB rows: 91,240 symbols: 1,201
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-17 08:35:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0446 | 1.0446 | 196000.0 |
| 2000-07-17 08:40:00 | AAPL | Stock | 1.0446 | 1.0525 | 1.0446 | 1.0491 | 168000.0 |
| 2000-07-17 08:45:00 | AAPL | Stock | 1.0513 | 1.0513 | 1.0491 | 1.0491 | 72800.0 |
| 2000-07-17 08:50:00 | AAPL | Stock | 1.0558 | 1.0558 | 1.0446 | 1.0446 | 246400.0 |
| 2000-07-17 08:55:00 | AAPL | Stock | 1.0446 | 1.0536 | 1.0446 | 1.0446 | 106400.0 |
| 2000-07-17 09:00:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0402 | 1.0424 | 140000.0 |
| 2000-07-17 09:10:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0402 | 1.0446 | 11200.0 |
| 2000-07-17 09:15:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0402 | 1.0402 | 112000.0 |
| 2000-07-17 09:20:00 | AAPL | Stock | 1.0413 | 1.0413 | 1.0402 | 1.0402 | 11200.0 |
| 2000-07-17 09:25:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0357 | 1.0413 | 201600.0 |
| 2000-07-17 09:30:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0391 | 1.0407 | 1954400.0 |
| 2000-07-17 09:35:00 | AAPL | Stock | 1.0391 | 1.0446 | 1.0324 | 1.0357 | 4698400.0 |
| 2000-07-17 09:40:00 | AAPL | Stock | 1.0346 | 1.0391 | 1.0313 | 1.0346 | 5101600.0 |
| 2000-07-17 09:45:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0279 | 1.0335 | 4244800.0 |
| 2000-07-17 09:50:00 | AAPL | Stock | 1.0324 | 1.0346 | 1.029 | 1.0346 | 4760000.0 |
| 2000-07-17 09:55:00 | AAPL | Stock | 1.0346 | 1.0368 | 1.0324 | 1.0352 | 2296000.0 |
| 2000-07-17 10:00:00 | AAPL | Stock | 1.0352 | 1.0391 | 1.0335 | 1.0368 | 2828000.0 |
| 2000-07-17 10:05:00 | AAPL | Stock | 1.0368 | 1.0424 | 1.0357 | 1.0357 | 3970400.0 |
| 2000-07-17 10:10:00 | AAPL | Stock | 1.0374 | 1.0402 | 1.029 | 1.0357 | 7436800.0 |
| 2000-07-17 10:15:00 | AAPL | Stock | 1.0335 | 1.0368 | 1.0335 | 1.0357 | 3108000.0 |
| 2000-07-17 10:20:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0257 | 1.0301 | 4648000.0 |
| 2000-07-17 10:25:00 | AAPL | Stock | 1.0313 | 1.0346 | 1.029 | 1.0301 | 3651200.0 |
| 2000-07-17 10:30:00 | AAPL | Stock | 1.0301 | 1.0357 | 1.029 | 1.0301 | 3320800.0 |
| 2000-07-17 10:35:00 | AAPL | Stock | 1.0324 | 1.0407 | 1.0301 | 1.0391 | 8808800.0 |
| 2000-07-17 10:40:00 | AAPL | Stock | 1.0402 | 1.0502 | 1.0357 | 1.0391 | 5023200.0 |
| 2000-07-17 10:45:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0357 | 1.0379 | 10813600.0 |
| 2000-07-17 10:50:00 | AAPL | Stock | 1.0379 | 1.0424 | 1.0368 | 1.0379 | 2704800.0 |
| 2000-07-17 10:55:00 | AAPL | Stock | 1.0379 | 1.0391 | 1.0368 | 1.0368 | 1853600.0 |
| 2000-07-17 11:00:00 | AAPL | Stock | 1.0379 | 1.0391 | 1.0368 | 1.0379 | 806400.0 |
| 2000-07-17 11:05:00 | AAPL | Stock | 1.0379 | 1.0491 | 1.0379 | 1.048 | 2447200.0 |
| 2000-07-17 11:10:00 | AAPL | Stock | 1.048 | 1.0491 | 1.0424 | 1.0424 | 1954400.0 |
| 2000-07-17 11:15:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0391 | 1.0396 | 2660000.0 |
| 2000-07-17 11:20:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0391 | 1.043 | 4480000.0 |
| 2000-07-17 11:25:00 | AAPL | Stock | 1.043 | 1.0435 | 1.0402 | 1.0402 | 2604000.0 |
| 2000-07-17 11:30:00 | AAPL | Stock | 1.0413 | 1.0413 | 1.0379 | 1.0391 | 2503200.0 |
| 2000-07-17 11:35:00 | AAPL | Stock | 1.0402 | 1.0458 | 1.0402 | 1.0458 | 1019200.0 |
| 2000-07-17 11:40:00 | AAPL | Stock | 1.0458 | 1.0458 | 1.0402 | 1.0402 | 520800.0 |
| 2000-07-17 11:45:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0346 | 1.0346 | 3931200.0 |
| 2000-07-17 11:50:00 | AAPL | Stock | 1.0346 | 1.0391 | 1.0346 | 1.0379 | 6518400.0 |
| 2000-07-17 11:55:00 | AAPL | Stock | 1.0368 | 1.0402 | 1.0368 | 1.0379 | 9553600.0 |
| 2000-07-17 12:00:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0379 | 2626400.0 |
| 2000-07-17 12:05:00 | AAPL | Stock | 1.0379 | 1.0379 | 1.0313 | 1.0335 | 6003200.0 |
| 2000-07-17 12:10:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0313 | 1.0313 | 1820000.0 |
| 2000-07-17 12:15:00 | AAPL | Stock | 1.0313 | 1.0318 | 1.0268 | 1.0301 | 3539200.0 |
| 2000-07-17 12:20:00 | AAPL | Stock | 1.029 | 1.0324 | 1.0279 | 1.0313 | 739200.0 |
| 2000-07-17 12:25:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.029 | 1.0313 | 2122400.0 |
| 2000-07-17 12:30:00 | AAPL | Stock | 1.0313 | 1.0324 | 1.0268 | 1.0268 | 1075200.0 |
| 2000-07-17 12:35:00 | AAPL | Stock | 1.029 | 1.0324 | 1.0257 | 1.0257 | 4648000.0 |
| 2000-07-17 12:40:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0201 | 1.0218 | 2872800.0 |
| 2000-07-17 12:45:00 | AAPL | Stock | 1.0223 | 1.029 | 1.0212 | 1.0279 | 4720800.0 |
> showing 50 of 91,240 rows — these rows as CSV