PREVIEW / stock_5min / 2000-07-18
file: by_date/stock_5min/2000/2000-07-18.parquet size: 1.2 MB rows: 87,856 symbols: 1,199
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-18 08:00:00 | AAPL | Stock | 1.0458 | 1.0458 | 1.0424 | 1.0424 | 22400.0 |
| 2000-07-18 08:30:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0491 | 1.0491 | 11200.0 |
| 2000-07-18 08:35:00 | AAPL | Stock | 1.0446 | 1.0536 | 1.0357 | 1.0491 | 78400.0 |
| 2000-07-18 08:40:00 | AAPL | Stock | 1.0491 | 1.0536 | 1.0446 | 1.0536 | 44800.0 |
| 2000-07-18 08:50:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0446 | 1.0446 | 5600.0 |
| 2000-07-18 08:55:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0424 | 1.0424 | 44800.0 |
| 2000-07-18 09:00:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0446 | 1.0446 | 56000.0 |
| 2000-07-18 09:05:00 | AAPL | Stock | 1.0513 | 1.0513 | 1.0424 | 1.0424 | 33600.0 |
| 2000-07-18 09:10:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0424 | 1.0424 | 50400.0 |
| 2000-07-18 09:15:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0402 | 1.0424 | 375200.0 |
| 2000-07-18 09:20:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0435 | 1.0446 | 263200.0 |
| 2000-07-18 09:25:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0424 | 1.0446 | 1170400.0 |
| 2000-07-18 09:30:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0435 | 1.0435 | 3679200.0 |
| 2000-07-18 09:35:00 | AAPL | Stock | 1.0446 | 1.0513 | 1.0357 | 1.0491 | 10068800.0 |
| 2000-07-18 09:40:00 | AAPL | Stock | 1.048 | 1.0513 | 1.0391 | 1.0458 | 8898400.0 |
| 2000-07-18 09:45:00 | AAPL | Stock | 1.0458 | 1.0491 | 1.0435 | 1.0446 | 7061600.0 |
| 2000-07-18 09:50:00 | AAPL | Stock | 1.0458 | 1.048 | 1.0424 | 1.0469 | 6356000.0 |
| 2000-07-18 09:55:00 | AAPL | Stock | 1.0469 | 1.0469 | 1.0446 | 1.0458 | 6333600.0 |
| 2000-07-18 10:00:00 | AAPL | Stock | 1.0458 | 1.0469 | 1.0446 | 1.0446 | 8797600.0 |
| 2000-07-18 10:05:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0446 | 1.0446 | 5684000.0 |
| 2000-07-18 10:10:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0435 | 1.0446 | 7319200.0 |
| 2000-07-18 10:15:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.0402 | 1.0413 | 3864000.0 |
| 2000-07-18 10:20:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0391 | 1.0413 | 3505600.0 |
| 2000-07-18 10:25:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0391 | 1.0402 | 1887200.0 |
| 2000-07-18 10:30:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0313 | 1.0313 | 7184800.0 |
| 2000-07-18 10:35:00 | AAPL | Stock | 1.0313 | 1.0357 | 1.029 | 1.029 | 4788000.0 |
| 2000-07-18 10:40:00 | AAPL | Stock | 1.029 | 1.0313 | 1.0179 | 1.029 | 4418400.0 |
| 2000-07-18 10:45:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0223 | 1.0223 | 6260800.0 |
| 2000-07-18 10:50:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.0156 | 1.0201 | 4608800.0 |
| 2000-07-18 10:55:00 | AAPL | Stock | 1.019 | 1.0234 | 1.0156 | 1.0223 | 3841600.0 |
| 2000-07-18 11:00:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.0179 | 1.0223 | 1209600.0 |
| 2000-07-18 11:05:00 | AAPL | Stock | 1.0223 | 1.0223 | 1.019 | 1.0212 | 1736000.0 |
| 2000-07-18 11:10:00 | AAPL | Stock | 1.0212 | 1.0234 | 1.0179 | 1.0234 | 2318400.0 |
| 2000-07-18 11:15:00 | AAPL | Stock | 1.0246 | 1.0296 | 1.0246 | 1.0296 | 817600.0 |
| 2000-07-18 11:20:00 | AAPL | Stock | 1.0301 | 1.0324 | 1.0223 | 1.0246 | 901600.0 |
| 2000-07-18 11:25:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0246 | 1.0268 | 1579200.0 |
| 2000-07-18 11:30:00 | AAPL | Stock | 1.0246 | 1.0268 | 1.0201 | 1.0246 | 1786400.0 |
| 2000-07-18 11:35:00 | AAPL | Stock | 1.0246 | 1.0346 | 1.0246 | 1.0324 | 2380000.0 |
| 2000-07-18 11:40:00 | AAPL | Stock | 1.0335 | 1.0368 | 1.0324 | 1.0335 | 2805600.0 |
| 2000-07-18 11:45:00 | AAPL | Stock | 1.0324 | 1.0368 | 1.0324 | 1.0335 | 2027200.0 |
| 2000-07-18 11:50:00 | AAPL | Stock | 1.0346 | 1.0413 | 1.0324 | 1.0352 | 2749600.0 |
| 2000-07-18 11:55:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0279 | 1.0313 | 1870400.0 |
| 2000-07-18 12:00:00 | AAPL | Stock | 1.0335 | 1.0357 | 1.0335 | 1.0346 | 1562400.0 |
| 2000-07-18 12:05:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0335 | 1.0357 | 2990400.0 |
| 2000-07-18 12:10:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0346 | 1.0368 | 1831200.0 |
| 2000-07-18 12:15:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0379 | 3287200.0 |
| 2000-07-18 12:20:00 | AAPL | Stock | 1.0374 | 1.0402 | 1.0368 | 1.0379 | 2380000.0 |
| 2000-07-18 12:25:00 | AAPL | Stock | 1.0379 | 1.0379 | 1.0335 | 1.0357 | 4121600.0 |
| 2000-07-18 12:30:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0335 | 1.0346 | 2049600.0 |
| 2000-07-18 12:35:00 | AAPL | Stock | 1.0346 | 1.0346 | 1.0324 | 1.0335 | 621600.0 |
> showing 50 of 87,856 rows — these rows as CSV