PREVIEW / stock_5min / 2001-11-07
file: by_date/stock_5min/2001/2001-11-07.parquet size: 1.6 MB rows: 110,514 symbols: 1,358
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-07 08:00:00 | AAPL | Stock | 0.347 | 0.3489 | 0.347 | 0.347 | 302400.0 |
| 2001-11-07 08:05:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 28000.0 |
| 2001-11-07 08:10:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 44800.0 |
| 2001-11-07 08:15:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 5600.0 |
| 2001-11-07 08:25:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 123200.0 |
| 2001-11-07 08:30:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 33600.0 |
| 2001-11-07 08:40:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 168000.0 |
| 2001-11-07 08:45:00 | AAPL | Stock | 0.3473 | 0.3477 | 0.3473 | 0.3473 | 89600.0 |
| 2001-11-07 08:50:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3477 | 0.3477 | 263200.0 |
| 2001-11-07 08:55:00 | AAPL | Stock | 0.348 | 0.348 | 0.348 | 0.348 | 22400.0 |
| 2001-11-07 09:00:00 | AAPL | Stock | 0.348 | 0.3482 | 0.348 | 0.3482 | 112000.0 |
| 2001-11-07 09:05:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.348 | 0.348 | 16800.0 |
| 2001-11-07 09:15:00 | AAPL | Stock | 0.3464 | 0.3466 | 0.3464 | 0.3466 | 173600.0 |
| 2001-11-07 09:20:00 | AAPL | Stock | 0.3466 | 0.347 | 0.3466 | 0.347 | 112000.0 |
| 2001-11-07 09:25:00 | AAPL | Stock | 0.347 | 0.3471 | 0.3464 | 0.3471 | 1052800.0 |
| 2001-11-07 09:30:00 | AAPL | Stock | 0.3475 | 0.3505 | 0.3475 | 0.35 | 11586400.0 |
| 2001-11-07 09:35:00 | AAPL | Stock | 0.3498 | 0.3521 | 0.3493 | 0.3511 | 4625600.0 |
| 2001-11-07 09:40:00 | AAPL | Stock | 0.3516 | 0.3518 | 0.3502 | 0.3505 | 6669600.0 |
| 2001-11-07 09:45:00 | AAPL | Stock | 0.35 | 0.3525 | 0.3488 | 0.3525 | 4244800.0 |
| 2001-11-07 09:50:00 | AAPL | Stock | 0.3525 | 0.3527 | 0.3505 | 0.3513 | 2917600.0 |
| 2001-11-07 09:55:00 | AAPL | Stock | 0.3511 | 0.3525 | 0.35 | 0.3502 | 8355200.0 |
| 2001-11-07 10:00:00 | AAPL | Stock | 0.3502 | 0.3523 | 0.35 | 0.35 | 4989600.0 |
| 2001-11-07 10:05:00 | AAPL | Stock | 0.35 | 0.3509 | 0.3489 | 0.3507 | 4166400.0 |
| 2001-11-07 10:10:00 | AAPL | Stock | 0.3507 | 0.3521 | 0.3495 | 0.3504 | 4088000.0 |
| 2001-11-07 10:15:00 | AAPL | Stock | 0.3502 | 0.3502 | 0.3486 | 0.3488 | 3309600.0 |
| 2001-11-07 10:20:00 | AAPL | Stock | 0.3488 | 0.35 | 0.3482 | 0.3493 | 5376000.0 |
| 2001-11-07 10:25:00 | AAPL | Stock | 0.3493 | 0.3505 | 0.3486 | 0.3491 | 5219200.0 |
| 2001-11-07 10:30:00 | AAPL | Stock | 0.3493 | 0.3513 | 0.3491 | 0.3498 | 6042400.0 |
| 2001-11-07 10:35:00 | AAPL | Stock | 0.3502 | 0.3518 | 0.3491 | 0.3518 | 5941600.0 |
| 2001-11-07 10:40:00 | AAPL | Stock | 0.3518 | 0.3529 | 0.3514 | 0.3521 | 6238400.0 |
| 2001-11-07 10:45:00 | AAPL | Stock | 0.3525 | 0.3527 | 0.3521 | 0.3521 | 1327200.0 |
| 2001-11-07 10:50:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.3491 | 0.3491 | 4306400.0 |
| 2001-11-07 10:55:00 | AAPL | Stock | 0.3495 | 0.3504 | 0.3493 | 0.3498 | 1383200.0 |
| 2001-11-07 11:00:00 | AAPL | Stock | 0.3498 | 0.3507 | 0.3495 | 0.3505 | 1237600.0 |
| 2001-11-07 11:05:00 | AAPL | Stock | 0.3506 | 0.3518 | 0.3504 | 0.3511 | 2116800.0 |
| 2001-11-07 11:10:00 | AAPL | Stock | 0.3509 | 0.3514 | 0.3509 | 0.3513 | 688800.0 |
| 2001-11-07 11:15:00 | AAPL | Stock | 0.3513 | 0.3514 | 0.3509 | 0.3513 | 1484000.0 |
| 2001-11-07 11:20:00 | AAPL | Stock | 0.3513 | 0.3516 | 0.3509 | 0.3511 | 1013600.0 |
| 2001-11-07 11:25:00 | AAPL | Stock | 0.3513 | 0.3518 | 0.3502 | 0.3504 | 2368800.0 |
| 2001-11-07 11:30:00 | AAPL | Stock | 0.3507 | 0.3507 | 0.35 | 0.35 | 1965600.0 |
| 2001-11-07 11:35:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3502 | 0.3511 | 3511200.0 |
| 2001-11-07 11:40:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3496 | 0.3496 | 1248800.0 |
| 2001-11-07 11:45:00 | AAPL | Stock | 0.3496 | 0.3507 | 0.3491 | 0.3491 | 3124800.0 |
| 2001-11-07 11:50:00 | AAPL | Stock | 0.3491 | 0.3493 | 0.3486 | 0.3489 | 1646400.0 |
| 2001-11-07 11:55:00 | AAPL | Stock | 0.3489 | 0.3502 | 0.3482 | 0.3488 | 907200.0 |
| 2001-11-07 12:00:00 | AAPL | Stock | 0.3486 | 0.35 | 0.3486 | 0.3496 | 3942400.0 |
| 2001-11-07 12:05:00 | AAPL | Stock | 0.3496 | 0.3505 | 0.3493 | 0.3505 | 3544800.0 |
| 2001-11-07 12:10:00 | AAPL | Stock | 0.35 | 0.3505 | 0.35 | 0.3502 | 952000.0 |
| 2001-11-07 12:15:00 | AAPL | Stock | 0.3502 | 0.3511 | 0.35 | 0.3507 | 862400.0 |
| 2001-11-07 12:20:00 | AAPL | Stock | 0.3507 | 0.3514 | 0.3507 | 0.3509 | 744800.0 |
> showing 50 of 110,514 rows — these rows as CSV