PREVIEW / stock_5min / 2000-07-11
file: by_date/stock_5min/2000/2000-07-11.parquet size: 1.2 MB rows: 92,379 symbols: 1,197
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-11 08:35:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 5600.0 |
| 2000-07-11 09:00:00 | AAPL | Stock | 1.0167 | 1.0167 | 1.0167 | 1.0167 | 22400.0 |
| 2000-07-11 09:05:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 106400.0 |
| 2000-07-11 09:15:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0167 | 1.0179 | 184800.0 |
| 2000-07-11 09:20:00 | AAPL | Stock | 1.019 | 1.019 | 1.019 | 1.019 | 33600.0 |
| 2000-07-11 09:25:00 | AAPL | Stock | 1.019 | 1.0223 | 1.019 | 1.0212 | 487200.0 |
| 2000-07-11 09:30:00 | AAPL | Stock | 1.0179 | 1.0179 | 0.99 | 1.0084 | 5728800.0 |
| 2000-07-11 09:35:00 | AAPL | Stock | 1.0084 | 1.0089 | 1.0022 | 1.0078 | 6288800.0 |
| 2000-07-11 09:40:00 | AAPL | Stock | 1.0078 | 1.0201 | 1.0067 | 1.0201 | 8142400.0 |
| 2000-07-11 09:45:00 | AAPL | Stock | 1.0201 | 1.0424 | 1.0134 | 1.0402 | 18088000.0 |
| 2000-07-11 09:50:00 | AAPL | Stock | 1.0391 | 1.0536 | 1.0346 | 1.048 | 16828000.0 |
| 2000-07-11 09:55:00 | AAPL | Stock | 1.0486 | 1.0502 | 1.0368 | 1.0424 | 6389600.0 |
| 2000-07-11 10:00:00 | AAPL | Stock | 1.0368 | 1.0435 | 1.0335 | 1.0379 | 5616800.0 |
| 2000-07-11 10:05:00 | AAPL | Stock | 1.0357 | 1.0446 | 1.0346 | 1.0424 | 5801600.0 |
| 2000-07-11 10:10:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.0335 | 1.0402 | 3203200.0 |
| 2000-07-11 10:15:00 | AAPL | Stock | 1.0379 | 1.0402 | 1.0346 | 1.0368 | 4194400.0 |
| 2000-07-11 10:20:00 | AAPL | Stock | 1.0368 | 1.0424 | 1.0357 | 1.0424 | 4334400.0 |
| 2000-07-11 10:25:00 | AAPL | Stock | 1.0419 | 1.0424 | 1.0391 | 1.0402 | 3147200.0 |
| 2000-07-11 10:30:00 | AAPL | Stock | 1.0391 | 1.0424 | 1.0379 | 1.0413 | 2576000.0 |
| 2000-07-11 10:35:00 | AAPL | Stock | 1.0413 | 1.0424 | 1.0402 | 1.0424 | 2475200.0 |
| 2000-07-11 10:40:00 | AAPL | Stock | 1.0424 | 1.0446 | 1.0357 | 1.0357 | 3208800.0 |
| 2000-07-11 10:45:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0335 | 1.0335 | 3914400.0 |
| 2000-07-11 10:50:00 | AAPL | Stock | 1.0346 | 1.0402 | 1.0335 | 1.0379 | 3707200.0 |
| 2000-07-11 10:55:00 | AAPL | Stock | 1.0368 | 1.0391 | 1.0346 | 1.0368 | 2374400.0 |
| 2000-07-11 11:00:00 | AAPL | Stock | 1.0379 | 1.0402 | 1.0379 | 1.0391 | 2352000.0 |
| 2000-07-11 11:05:00 | AAPL | Stock | 1.0379 | 1.0402 | 1.0379 | 1.0391 | 3533600.0 |
| 2000-07-11 11:10:00 | AAPL | Stock | 1.0391 | 1.0402 | 1.0379 | 1.0391 | 1708000.0 |
| 2000-07-11 11:15:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0379 | 1.0402 | 1937600.0 |
| 2000-07-11 11:20:00 | AAPL | Stock | 1.0391 | 1.0402 | 1.0379 | 1.0391 | 3046400.0 |
| 2000-07-11 11:25:00 | AAPL | Stock | 1.0402 | 1.0424 | 1.0379 | 1.0413 | 4121600.0 |
| 2000-07-11 11:30:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0402 | 1.0402 | 6820800.0 |
| 2000-07-11 11:35:00 | AAPL | Stock | 1.0402 | 1.0458 | 1.0402 | 1.0424 | 4345600.0 |
| 2000-07-11 11:40:00 | AAPL | Stock | 1.0424 | 1.0446 | 1.0424 | 1.0424 | 2928800.0 |
| 2000-07-11 11:45:00 | AAPL | Stock | 1.0424 | 1.0435 | 1.0402 | 1.0435 | 2324000.0 |
| 2000-07-11 11:50:00 | AAPL | Stock | 1.0435 | 1.0469 | 1.0424 | 1.0469 | 5471200.0 |
| 2000-07-11 11:55:00 | AAPL | Stock | 1.0458 | 1.0513 | 1.0402 | 1.0508 | 6591200.0 |
| 2000-07-11 12:00:00 | AAPL | Stock | 1.0502 | 1.0513 | 1.0469 | 1.0469 | 3572800.0 |
| 2000-07-11 12:05:00 | AAPL | Stock | 1.0469 | 1.048 | 1.0458 | 1.0458 | 1377600.0 |
| 2000-07-11 12:10:00 | AAPL | Stock | 1.0469 | 1.0469 | 1.0446 | 1.0446 | 2973600.0 |
| 2000-07-11 12:15:00 | AAPL | Stock | 1.0446 | 1.0569 | 1.0435 | 1.0547 | 24214400.0 |
| 2000-07-11 12:20:00 | AAPL | Stock | 1.0558 | 1.0558 | 1.0502 | 1.0536 | 3892000.0 |
| 2000-07-11 12:25:00 | AAPL | Stock | 1.0536 | 1.058 | 1.0513 | 1.0558 | 4205600.0 |
| 2000-07-11 12:30:00 | AAPL | Stock | 1.0547 | 1.0558 | 1.0513 | 1.0513 | 2760800.0 |
| 2000-07-11 12:35:00 | AAPL | Stock | 1.0513 | 1.0525 | 1.0491 | 1.0491 | 1607200.0 |
| 2000-07-11 12:40:00 | AAPL | Stock | 1.0502 | 1.0502 | 1.0458 | 1.0469 | 2139200.0 |
| 2000-07-11 12:45:00 | AAPL | Stock | 1.0469 | 1.0491 | 1.0458 | 1.0458 | 3892000.0 |
| 2000-07-11 12:50:00 | AAPL | Stock | 1.048 | 1.0525 | 1.0458 | 1.0491 | 1187200.0 |
| 2000-07-11 12:55:00 | AAPL | Stock | 1.0491 | 1.0502 | 1.048 | 1.0491 | 2184000.0 |
| 2000-07-11 13:00:00 | AAPL | Stock | 1.0491 | 1.0513 | 1.0469 | 1.0469 | 2660000.0 |
| 2000-07-11 13:05:00 | AAPL | Stock | 1.048 | 1.0502 | 1.0402 | 1.0402 | 5723200.0 |
> showing 50 of 92,379 rows — these rows as CSV