PREVIEW / stock_5min / 2001-06-12
file: by_date/stock_5min/2001/2001-06-12.parquet size: 1.6 MB rows: 109,474 symbols: 1,303
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-06-12 08:00:00 | AAPL | Stock | 0.373 | 0.373 | 0.3684 | 0.3688 | 33600.0 |
| 2001-06-12 08:20:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 5600.0 |
| 2001-06-12 08:55:00 | AAPL | Stock | 0.3561 | 0.3561 | 0.3561 | 0.3561 | 5600.0 |
| 2001-06-12 09:00:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 28000.0 |
| 2001-06-12 09:05:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 28000.0 |
| 2001-06-12 09:10:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3552 | 0.3552 | 11200.0 |
| 2001-06-12 09:15:00 | AAPL | Stock | 0.355 | 0.3552 | 0.3545 | 0.3552 | 61600.0 |
| 2001-06-12 09:20:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3545 | 0.3545 | 196000.0 |
| 2001-06-12 09:25:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.3529 | 0.3532 | 621600.0 |
| 2001-06-12 09:30:00 | AAPL | Stock | 0.353 | 0.3571 | 0.3529 | 0.3532 | 6882400.0 |
| 2001-06-12 09:35:00 | AAPL | Stock | 0.3532 | 0.3571 | 0.353 | 0.3545 | 9324000.0 |
| 2001-06-12 09:40:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3534 | 0.3541 | 4642400.0 |
| 2001-06-12 09:45:00 | AAPL | Stock | 0.3541 | 0.3554 | 0.3532 | 0.3541 | 10136000.0 |
| 2001-06-12 09:50:00 | AAPL | Stock | 0.3541 | 0.3563 | 0.3541 | 0.3552 | 9570400.0 |
| 2001-06-12 09:55:00 | AAPL | Stock | 0.355 | 0.3586 | 0.355 | 0.3579 | 13512800.0 |
| 2001-06-12 10:00:00 | AAPL | Stock | 0.3586 | 0.3596 | 0.3571 | 0.3575 | 9032800.0 |
| 2001-06-12 10:05:00 | AAPL | Stock | 0.3571 | 0.358 | 0.3563 | 0.3573 | 1708000.0 |
| 2001-06-12 10:10:00 | AAPL | Stock | 0.357 | 0.358 | 0.357 | 0.3571 | 8181600.0 |
| 2001-06-12 10:15:00 | AAPL | Stock | 0.3573 | 0.358 | 0.3554 | 0.3555 | 6792800.0 |
| 2001-06-12 10:20:00 | AAPL | Stock | 0.3555 | 0.3564 | 0.3548 | 0.3548 | 4211200.0 |
| 2001-06-12 10:25:00 | AAPL | Stock | 0.3548 | 0.3548 | 0.3529 | 0.3545 | 7683200.0 |
| 2001-06-12 10:30:00 | AAPL | Stock | 0.3546 | 0.3546 | 0.3536 | 0.3538 | 2329600.0 |
| 2001-06-12 10:35:00 | AAPL | Stock | 0.3538 | 0.3566 | 0.3538 | 0.3561 | 3399200.0 |
| 2001-06-12 10:40:00 | AAPL | Stock | 0.3559 | 0.3564 | 0.355 | 0.355 | 2284800.0 |
| 2001-06-12 10:45:00 | AAPL | Stock | 0.355 | 0.357 | 0.355 | 0.3568 | 3147200.0 |
| 2001-06-12 10:50:00 | AAPL | Stock | 0.3568 | 0.3568 | 0.3561 | 0.3566 | 3511200.0 |
| 2001-06-12 10:55:00 | AAPL | Stock | 0.3564 | 0.3589 | 0.3563 | 0.3575 | 2380000.0 |
| 2001-06-12 11:00:00 | AAPL | Stock | 0.3575 | 0.3586 | 0.3571 | 0.3577 | 4961600.0 |
| 2001-06-12 11:05:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3566 | 0.3573 | 2296000.0 |
| 2001-06-12 11:10:00 | AAPL | Stock | 0.3573 | 0.358 | 0.3571 | 0.358 | 2436000.0 |
| 2001-06-12 11:15:00 | AAPL | Stock | 0.358 | 0.3582 | 0.357 | 0.3571 | 1405600.0 |
| 2001-06-12 11:20:00 | AAPL | Stock | 0.357 | 0.3577 | 0.357 | 0.3573 | 2083200.0 |
| 2001-06-12 11:25:00 | AAPL | Stock | 0.3573 | 0.3579 | 0.3563 | 0.3571 | 2083200.0 |
| 2001-06-12 11:30:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3571 | 0.3571 | 1444800.0 |
| 2001-06-12 11:35:00 | AAPL | Stock | 0.3571 | 0.358 | 0.357 | 0.358 | 1450400.0 |
| 2001-06-12 11:40:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3577 | 0.3577 | 5409600.0 |
| 2001-06-12 11:45:00 | AAPL | Stock | 0.3577 | 0.3577 | 0.357 | 0.357 | 1657600.0 |
| 2001-06-12 11:50:00 | AAPL | Stock | 0.357 | 0.3571 | 0.3563 | 0.357 | 3466400.0 |
| 2001-06-12 11:55:00 | AAPL | Stock | 0.357 | 0.358 | 0.3568 | 0.3573 | 1327200.0 |
| 2001-06-12 12:00:00 | AAPL | Stock | 0.3573 | 0.3575 | 0.357 | 0.3575 | 1668800.0 |
| 2001-06-12 12:05:00 | AAPL | Stock | 0.3573 | 0.3579 | 0.3571 | 0.3575 | 1836800.0 |
| 2001-06-12 12:10:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3566 | 0.3575 | 526400.0 |
| 2001-06-12 12:15:00 | AAPL | Stock | 0.3577 | 0.3577 | 0.3568 | 0.3573 | 3169600.0 |
| 2001-06-12 12:20:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3559 | 0.3561 | 1534400.0 |
| 2001-06-12 12:25:00 | AAPL | Stock | 0.3561 | 0.3564 | 0.3554 | 0.3563 | 1612800.0 |
| 2001-06-12 12:30:00 | AAPL | Stock | 0.3563 | 0.3571 | 0.3563 | 0.3564 | 1820000.0 |
| 2001-06-12 12:35:00 | AAPL | Stock | 0.3564 | 0.3571 | 0.3564 | 0.3571 | 772800.0 |
| 2001-06-12 12:40:00 | AAPL | Stock | 0.3568 | 0.3571 | 0.3564 | 0.3564 | 862400.0 |
| 2001-06-12 12:45:00 | AAPL | Stock | 0.3564 | 0.3571 | 0.3557 | 0.3563 | 2553600.0 |
| 2001-06-12 12:50:00 | AAPL | Stock | 0.3559 | 0.3566 | 0.3559 | 0.3564 | 644000.0 |
> showing 50 of 109,474 rows — these rows as CSV