PREVIEW / stock_5min / 2003-07-07
file: by_date/stock_5min/2003/2003-07-07.parquet size: 2.2 MB rows: 161,826 symbols: 1,587
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-07 09:00:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 44800.0 |
| 2003-07-07 09:05:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3436 | 0.3436 | 53200.0 |
| 2003-07-07 09:10:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.3427 | 0.3427 | 36400.0 |
| 2003-07-07 09:15:00 | AAPL | Stock | 0.3427 | 0.3427 | 0.3427 | 0.3427 | 16800.0 |
| 2003-07-07 09:20:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 39200.0 |
| 2003-07-07 09:25:00 | AAPL | Stock | 0.3441 | 0.3441 | 0.3438 | 0.3438 | 28000.0 |
| 2003-07-07 09:30:00 | AAPL | Stock | 0.3441 | 0.3455 | 0.3416 | 0.3445 | 3462200.0 |
| 2003-07-07 09:35:00 | AAPL | Stock | 0.3445 | 0.3482 | 0.3445 | 0.3475 | 3750096.0 |
| 2003-07-07 09:40:00 | AAPL | Stock | 0.3473 | 0.3482 | 0.3457 | 0.347 | 2400272.0 |
| 2003-07-07 09:45:00 | AAPL | Stock | 0.3468 | 0.348 | 0.3468 | 0.3475 | 1232000.0 |
| 2003-07-07 09:50:00 | AAPL | Stock | 0.3475 | 0.3482 | 0.3473 | 0.3482 | 1578080.0 |
| 2003-07-07 09:55:00 | AAPL | Stock | 0.3482 | 0.3509 | 0.348 | 0.3505 | 10624656.0 |
| 2003-07-07 10:00:00 | AAPL | Stock | 0.3505 | 0.3505 | 0.3491 | 0.3493 | 4174800.0 |
| 2003-07-07 10:05:00 | AAPL | Stock | 0.3493 | 0.3504 | 0.3493 | 0.35 | 1265600.0 |
| 2003-07-07 10:10:00 | AAPL | Stock | 0.35 | 0.3502 | 0.3489 | 0.3495 | 1113056.0 |
| 2003-07-07 10:15:00 | AAPL | Stock | 0.3493 | 0.3523 | 0.3493 | 0.3514 | 5249944.0 |
| 2003-07-07 10:20:00 | AAPL | Stock | 0.3518 | 0.3551 | 0.3518 | 0.355 | 15242360.0 |
| 2003-07-07 10:25:00 | AAPL | Stock | 0.3548 | 0.3564 | 0.3545 | 0.3563 | 12100872.0 |
| 2003-07-07 10:30:00 | AAPL | Stock | 0.3564 | 0.357 | 0.3552 | 0.3554 | 8793288.0 |
| 2003-07-07 10:35:00 | AAPL | Stock | 0.3555 | 0.3563 | 0.3552 | 0.3563 | 4231976.0 |
| 2003-07-07 10:40:00 | AAPL | Stock | 0.3561 | 0.3563 | 0.3554 | 0.3554 | 1530312.0 |
| 2003-07-07 10:45:00 | AAPL | Stock | 0.3554 | 0.3558 | 0.3554 | 0.3554 | 2261168.0 |
| 2003-07-07 10:50:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3553 | 0.3559 | 2815120.0 |
| 2003-07-07 10:55:00 | AAPL | Stock | 0.3563 | 0.3571 | 0.3559 | 0.357 | 3587808.0 |
| 2003-07-07 11:00:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3564 | 0.3566 | 1596000.0 |
| 2003-07-07 11:05:00 | AAPL | Stock | 0.3566 | 0.3566 | 0.3554 | 0.3557 | 2161600.0 |
| 2003-07-07 11:10:00 | AAPL | Stock | 0.3557 | 0.3579 | 0.3555 | 0.3575 | 14507416.0 |
| 2003-07-07 11:15:00 | AAPL | Stock | 0.3575 | 0.358 | 0.357 | 0.3575 | 3469368.0 |
| 2003-07-07 11:20:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3575 | 0.3575 | 2580200.0 |
| 2003-07-07 11:25:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3564 | 0.3573 | 4631648.0 |
| 2003-07-07 11:30:00 | AAPL | Stock | 0.3571 | 0.358 | 0.3568 | 0.3577 | 3498488.0 |
| 2003-07-07 11:35:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3571 | 0.3573 | 1776656.0 |
| 2003-07-07 11:40:00 | AAPL | Stock | 0.3571 | 0.3575 | 0.3561 | 0.3566 | 3472784.0 |
| 2003-07-07 11:45:00 | AAPL | Stock | 0.3566 | 0.3573 | 0.3564 | 0.3573 | 2156000.0 |
| 2003-07-07 11:50:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3563 | 0.357 | 1036000.0 |
| 2003-07-07 11:55:00 | AAPL | Stock | 0.3571 | 0.3577 | 0.357 | 0.3577 | 1758400.0 |
| 2003-07-07 12:00:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3577 | 0.358 | 2373952.0 |
| 2003-07-07 12:05:00 | AAPL | Stock | 0.358 | 0.3589 | 0.358 | 0.3589 | 2802072.0 |
| 2003-07-07 12:10:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3571 | 0.3586 | 7241584.0 |
| 2003-07-07 12:15:00 | AAPL | Stock | 0.3586 | 0.36 | 0.3584 | 0.3598 | 2875656.0 |
| 2003-07-07 12:20:00 | AAPL | Stock | 0.3596 | 0.3602 | 0.3596 | 0.36 | 2066960.0 |
| 2003-07-07 12:25:00 | AAPL | Stock | 0.3596 | 0.3598 | 0.3589 | 0.3595 | 1326640.0 |
| 2003-07-07 12:30:00 | AAPL | Stock | 0.3596 | 0.3604 | 0.3595 | 0.3598 | 1640464.0 |
| 2003-07-07 12:35:00 | AAPL | Stock | 0.3596 | 0.3598 | 0.3595 | 0.3598 | 1224384.0 |
| 2003-07-07 12:40:00 | AAPL | Stock | 0.3596 | 0.3598 | 0.3595 | 0.3595 | 1136408.0 |
| 2003-07-07 12:45:00 | AAPL | Stock | 0.3596 | 0.3596 | 0.3579 | 0.3579 | 3606064.0 |
| 2003-07-07 12:50:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3566 | 0.3573 | 2651600.0 |
| 2003-07-07 12:55:00 | AAPL | Stock | 0.3573 | 0.3575 | 0.3568 | 0.3568 | 3835888.0 |
| 2003-07-07 13:00:00 | AAPL | Stock | 0.3568 | 0.3569 | 0.3557 | 0.3559 | 5250000.0 |
| 2003-07-07 13:05:00 | AAPL | Stock | 0.3559 | 0.3564 | 0.3555 | 0.3557 | 2397136.0 |
> showing 50 of 161,826 rows — these rows as CSV