PREVIEW / stock_5min / 2001-11-19
file: by_date/stock_5min/2001/2001-11-19.parquet size: 1.6 MB rows: 113,837 symbols: 1,357
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-19 08:15:00 | AAPL | Stock | 0.3425 | 0.3425 | 0.3425 | 0.3425 | 11200.0 |
| 2001-11-19 08:30:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3411 | 0.3411 | 56000.0 |
| 2001-11-19 08:45:00 | AAPL | Stock | 0.3425 | 0.3425 | 0.3425 | 0.3425 | 5600.0 |
| 2001-11-19 09:05:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3393 | 0.3393 | 11200.0 |
| 2001-11-19 09:10:00 | AAPL | Stock | 0.3395 | 0.3395 | 0.3393 | 0.3393 | 190400.0 |
| 2001-11-19 09:15:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3393 | 0.3393 | 56000.0 |
| 2001-11-19 09:20:00 | AAPL | Stock | 0.3395 | 0.3395 | 0.3393 | 0.3393 | 61600.0 |
| 2001-11-19 09:25:00 | AAPL | Stock | 0.3393 | 0.3395 | 0.3388 | 0.3388 | 123200.0 |
| 2001-11-19 09:30:00 | AAPL | Stock | 0.3393 | 0.3409 | 0.3386 | 0.34 | 5616800.0 |
| 2001-11-19 09:35:00 | AAPL | Stock | 0.3396 | 0.3413 | 0.3391 | 0.3411 | 5191200.0 |
| 2001-11-19 09:40:00 | AAPL | Stock | 0.3413 | 0.3446 | 0.3411 | 0.3446 | 7207200.0 |
| 2001-11-19 09:45:00 | AAPL | Stock | 0.3446 | 0.347 | 0.3446 | 0.347 | 6104000.0 |
| 2001-11-19 09:50:00 | AAPL | Stock | 0.3468 | 0.3489 | 0.3464 | 0.3484 | 8237600.0 |
| 2001-11-19 09:55:00 | AAPL | Stock | 0.3489 | 0.3516 | 0.3488 | 0.3516 | 8948800.0 |
| 2001-11-19 10:00:00 | AAPL | Stock | 0.3516 | 0.3545 | 0.3516 | 0.3541 | 18989600.0 |
| 2001-11-19 10:05:00 | AAPL | Stock | 0.3539 | 0.3546 | 0.3529 | 0.353 | 9189600.0 |
| 2001-11-19 10:10:00 | AAPL | Stock | 0.3532 | 0.3536 | 0.3529 | 0.353 | 2492000.0 |
| 2001-11-19 10:15:00 | AAPL | Stock | 0.353 | 0.3534 | 0.3518 | 0.3523 | 4060000.0 |
| 2001-11-19 10:20:00 | AAPL | Stock | 0.3521 | 0.3538 | 0.3513 | 0.3527 | 2895200.0 |
| 2001-11-19 10:25:00 | AAPL | Stock | 0.3521 | 0.3529 | 0.3509 | 0.3527 | 2844800.0 |
| 2001-11-19 10:30:00 | AAPL | Stock | 0.3529 | 0.3536 | 0.352 | 0.3527 | 5600000.0 |
| 2001-11-19 10:35:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3513 | 0.3513 | 5628000.0 |
| 2001-11-19 10:40:00 | AAPL | Stock | 0.3513 | 0.3516 | 0.3511 | 0.3511 | 812000.0 |
| 2001-11-19 10:45:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3507 | 0.3518 | 3057600.0 |
| 2001-11-19 10:50:00 | AAPL | Stock | 0.3518 | 0.3525 | 0.3516 | 0.3516 | 1377600.0 |
| 2001-11-19 10:55:00 | AAPL | Stock | 0.352 | 0.3529 | 0.3516 | 0.3527 | 1736000.0 |
| 2001-11-19 11:00:00 | AAPL | Stock | 0.3527 | 0.3545 | 0.3527 | 0.3536 | 3382400.0 |
| 2001-11-19 11:05:00 | AAPL | Stock | 0.3534 | 0.3541 | 0.353 | 0.3538 | 3388000.0 |
| 2001-11-19 11:10:00 | AAPL | Stock | 0.353 | 0.3532 | 0.3525 | 0.3529 | 2329600.0 |
| 2001-11-19 11:15:00 | AAPL | Stock | 0.3527 | 0.3529 | 0.3518 | 0.352 | 4911200.0 |
| 2001-11-19 11:20:00 | AAPL | Stock | 0.3521 | 0.3536 | 0.3521 | 0.3536 | 1814400.0 |
| 2001-11-19 11:25:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.3523 | 0.3529 | 2598400.0 |
| 2001-11-19 11:30:00 | AAPL | Stock | 0.3529 | 0.3539 | 0.3521 | 0.3523 | 3169600.0 |
| 2001-11-19 11:35:00 | AAPL | Stock | 0.3525 | 0.353 | 0.3514 | 0.3516 | 3539200.0 |
| 2001-11-19 11:40:00 | AAPL | Stock | 0.3518 | 0.3527 | 0.3518 | 0.3525 | 1792000.0 |
| 2001-11-19 11:45:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3521 | 0.3525 | 1864800.0 |
| 2001-11-19 11:50:00 | AAPL | Stock | 0.3525 | 0.3536 | 0.3521 | 0.3523 | 1293600.0 |
| 2001-11-19 11:55:00 | AAPL | Stock | 0.3523 | 0.353 | 0.3513 | 0.3513 | 5107200.0 |
| 2001-11-19 12:00:00 | AAPL | Stock | 0.3513 | 0.3516 | 0.3486 | 0.3489 | 3298400.0 |
| 2001-11-19 12:05:00 | AAPL | Stock | 0.35 | 0.3504 | 0.3488 | 0.3491 | 1484000.0 |
| 2001-11-19 12:10:00 | AAPL | Stock | 0.3488 | 0.3502 | 0.3486 | 0.3498 | 1881600.0 |
| 2001-11-19 12:15:00 | AAPL | Stock | 0.3498 | 0.3507 | 0.3496 | 0.3505 | 1041600.0 |
| 2001-11-19 12:20:00 | AAPL | Stock | 0.3504 | 0.3507 | 0.35 | 0.3504 | 2357600.0 |
| 2001-11-19 12:25:00 | AAPL | Stock | 0.3504 | 0.3506 | 0.3498 | 0.3506 | 3113600.0 |
| 2001-11-19 12:30:00 | AAPL | Stock | 0.3507 | 0.3516 | 0.3505 | 0.3516 | 2044000.0 |
| 2001-11-19 12:35:00 | AAPL | Stock | 0.3516 | 0.3518 | 0.3507 | 0.3509 | 1540000.0 |
| 2001-11-19 12:40:00 | AAPL | Stock | 0.3509 | 0.3518 | 0.3509 | 0.3518 | 728000.0 |
| 2001-11-19 12:45:00 | AAPL | Stock | 0.3513 | 0.3527 | 0.3511 | 0.3523 | 778400.0 |
| 2001-11-19 12:50:00 | AAPL | Stock | 0.3523 | 0.3536 | 0.3523 | 0.3525 | 5684000.0 |
| 2001-11-19 12:55:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3523 | 0.3527 | 5538400.0 |
> showing 50 of 113,837 rows — these rows as CSV