PREVIEW / stock_5min / 2001-05-31
file: by_date/stock_5min/2001/2001-05-31.parquet size: 1.6 MB rows: 115,008 symbols: 1,300
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-05-31 08:00:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3532 | 0.3532 | 588000.0 |
| 2001-05-31 08:05:00 | AAPL | Stock | 0.3541 | 0.3541 | 0.3541 | 0.3541 | 5600.0 |
| 2001-05-31 08:15:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3554 | 0.3554 | 50400.0 |
| 2001-05-31 08:20:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3541 | 0.3541 | 39200.0 |
| 2001-05-31 08:25:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3534 | 0.3534 | 84000.0 |
| 2001-05-31 08:30:00 | AAPL | Stock | 0.3541 | 0.3541 | 0.3536 | 0.3536 | 224000.0 |
| 2001-05-31 08:40:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.3532 | 0.3532 | 5600.0 |
| 2001-05-31 08:45:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3527 | 0.3527 | 28000.0 |
| 2001-05-31 09:05:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.3532 | 0.3532 | 39200.0 |
| 2001-05-31 09:10:00 | AAPL | Stock | 0.3532 | 0.3536 | 0.3532 | 0.3534 | 112000.0 |
| 2001-05-31 09:15:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.3532 | 0.3532 | 308000.0 |
| 2001-05-31 09:20:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3536 | 0.3536 | 11200.0 |
| 2001-05-31 09:25:00 | AAPL | Stock | 0.3534 | 0.3539 | 0.353 | 0.3539 | 1064000.0 |
| 2001-05-31 09:30:00 | AAPL | Stock | 0.3536 | 0.3541 | 0.348 | 0.3491 | 16363200.0 |
| 2001-05-31 09:35:00 | AAPL | Stock | 0.3496 | 0.3529 | 0.3495 | 0.3518 | 15293600.0 |
| 2001-05-31 09:40:00 | AAPL | Stock | 0.3523 | 0.3584 | 0.3518 | 0.3584 | 7207200.0 |
| 2001-05-31 09:45:00 | AAPL | Stock | 0.3582 | 0.3584 | 0.3546 | 0.3571 | 11625600.0 |
| 2001-05-31 09:50:00 | AAPL | Stock | 0.3571 | 0.3573 | 0.3541 | 0.3554 | 5650400.0 |
| 2001-05-31 09:55:00 | AAPL | Stock | 0.3559 | 0.358 | 0.3552 | 0.3564 | 12376000.0 |
| 2001-05-31 10:00:00 | AAPL | Stock | 0.3563 | 0.3571 | 0.3527 | 0.3532 | 5376000.0 |
| 2001-05-31 10:05:00 | AAPL | Stock | 0.3532 | 0.3573 | 0.3527 | 0.357 | 7599200.0 |
| 2001-05-31 10:10:00 | AAPL | Stock | 0.357 | 0.3591 | 0.3557 | 0.3579 | 19712000.0 |
| 2001-05-31 10:15:00 | AAPL | Stock | 0.3579 | 0.3584 | 0.3571 | 0.3573 | 4463200.0 |
| 2001-05-31 10:20:00 | AAPL | Stock | 0.3571 | 0.358 | 0.3563 | 0.3577 | 2973600.0 |
| 2001-05-31 10:25:00 | AAPL | Stock | 0.358 | 0.358 | 0.3563 | 0.3566 | 5476800.0 |
| 2001-05-31 10:30:00 | AAPL | Stock | 0.357 | 0.3584 | 0.3563 | 0.3579 | 3136000.0 |
| 2001-05-31 10:35:00 | AAPL | Stock | 0.3573 | 0.3575 | 0.3566 | 0.3568 | 2290400.0 |
| 2001-05-31 10:40:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3557 | 0.3566 | 3052000.0 |
| 2001-05-31 10:45:00 | AAPL | Stock | 0.3557 | 0.3571 | 0.3557 | 0.357 | 2856000.0 |
| 2001-05-31 10:50:00 | AAPL | Stock | 0.357 | 0.3577 | 0.3552 | 0.3552 | 3914400.0 |
| 2001-05-31 10:55:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3538 | 0.3548 | 6400800.0 |
| 2001-05-31 11:00:00 | AAPL | Stock | 0.3541 | 0.358 | 0.3541 | 0.3579 | 3068800.0 |
| 2001-05-31 11:05:00 | AAPL | Stock | 0.3579 | 0.3586 | 0.3571 | 0.3571 | 10992800.0 |
| 2001-05-31 11:10:00 | AAPL | Stock | 0.3571 | 0.3577 | 0.3564 | 0.3573 | 1372000.0 |
| 2001-05-31 11:15:00 | AAPL | Stock | 0.3577 | 0.3582 | 0.3571 | 0.3579 | 5252800.0 |
| 2001-05-31 11:20:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3577 | 0.3577 | 901600.0 |
| 2001-05-31 11:25:00 | AAPL | Stock | 0.3579 | 0.3582 | 0.3571 | 0.3579 | 5028800.0 |
| 2001-05-31 11:30:00 | AAPL | Stock | 0.3579 | 0.3582 | 0.3571 | 0.3575 | 1176000.0 |
| 2001-05-31 11:35:00 | AAPL | Stock | 0.3571 | 0.3582 | 0.3571 | 0.3575 | 1024800.0 |
| 2001-05-31 11:40:00 | AAPL | Stock | 0.3579 | 0.3586 | 0.3575 | 0.3579 | 1052800.0 |
| 2001-05-31 11:45:00 | AAPL | Stock | 0.358 | 0.3591 | 0.3571 | 0.3582 | 15013600.0 |
| 2001-05-31 11:50:00 | AAPL | Stock | 0.3582 | 0.3582 | 0.3577 | 0.358 | 1321600.0 |
| 2001-05-31 11:55:00 | AAPL | Stock | 0.3582 | 0.3582 | 0.3571 | 0.3571 | 2660000.0 |
| 2001-05-31 12:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3552 | 0.3552 | 3068800.0 |
| 2001-05-31 12:05:00 | AAPL | Stock | 0.3554 | 0.3561 | 0.355 | 0.3555 | 1114400.0 |
| 2001-05-31 12:10:00 | AAPL | Stock | 0.3555 | 0.3557 | 0.3536 | 0.3545 | 2996000.0 |
| 2001-05-31 12:15:00 | AAPL | Stock | 0.355 | 0.3555 | 0.3546 | 0.3554 | 1825600.0 |
| 2001-05-31 12:20:00 | AAPL | Stock | 0.3554 | 0.3557 | 0.3545 | 0.3545 | 1444800.0 |
| 2001-05-31 12:25:00 | AAPL | Stock | 0.3545 | 0.3554 | 0.3545 | 0.3554 | 1859200.0 |
| 2001-05-31 12:30:00 | AAPL | Stock | 0.3554 | 0.3575 | 0.3554 | 0.3568 | 1344000.0 |
> showing 50 of 115,008 rows — these rows as CSV