PREVIEW / stock_1min / 2007-05-17
file: by_date/stock_1min/2007/2007-05-17.parquet size: 10.9 MB rows: 903,118 symbols: 2,457
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-17 09:30:00 | AAPL | Stock | 3.8268 | 3.8361 | 3.8268 | 3.835 | 3858372.0 |
| 2007-05-17 09:31:00 | AAPL | Stock | 3.8343 | 3.8386 | 3.8329 | 3.8361 | 1756888.0 |
| 2007-05-17 09:32:00 | AAPL | Stock | 3.8354 | 3.84 | 3.8329 | 3.8382 | 3071320.0 |
| 2007-05-17 09:33:00 | AAPL | Stock | 3.8389 | 3.8475 | 3.837 | 3.845 | 3159128.0 |
| 2007-05-17 09:34:00 | AAPL | Stock | 3.8436 | 3.8462 | 3.8404 | 3.8433 | 2624496.0 |
| 2007-05-17 09:35:00 | AAPL | Stock | 3.8432 | 3.8546 | 3.8432 | 3.8546 | 3254636.0 |
| 2007-05-17 09:36:00 | AAPL | Stock | 3.8546 | 3.8554 | 3.8496 | 3.8525 | 2286704.0 |
| 2007-05-17 09:37:00 | AAPL | Stock | 3.8529 | 3.8529 | 3.8504 | 3.8521 | 2202480.0 |
| 2007-05-17 09:38:00 | AAPL | Stock | 3.8521 | 3.8525 | 3.8471 | 3.8475 | 1645672.0 |
| 2007-05-17 09:39:00 | AAPL | Stock | 3.8482 | 3.8561 | 3.8443 | 3.8557 | 3285324.0 |
| 2007-05-17 09:40:00 | AAPL | Stock | 3.8561 | 3.8686 | 3.8561 | 3.8686 | 5274024.0 |
| 2007-05-17 09:41:00 | AAPL | Stock | 3.8686 | 3.875 | 3.8679 | 3.8714 | 6534836.0 |
| 2007-05-17 09:42:00 | AAPL | Stock | 3.8718 | 3.8718 | 3.8661 | 3.8664 | 3364872.0 |
| 2007-05-17 09:43:00 | AAPL | Stock | 3.8661 | 3.8671 | 3.8575 | 3.86 | 3659292.0 |
| 2007-05-17 09:44:00 | AAPL | Stock | 3.86 | 3.8629 | 3.8582 | 3.8604 | 2781492.0 |
| 2007-05-17 09:45:00 | AAPL | Stock | 3.8607 | 3.8679 | 3.8601 | 3.8671 | 4285876.0 |
| 2007-05-17 09:46:00 | AAPL | Stock | 3.8668 | 3.8711 | 3.8664 | 3.8686 | 4436880.0 |
| 2007-05-17 09:47:00 | AAPL | Stock | 3.8686 | 3.8693 | 3.8629 | 3.8646 | 2692592.0 |
| 2007-05-17 09:48:00 | AAPL | Stock | 3.8643 | 3.8646 | 3.8561 | 3.8629 | 3328640.0 |
| 2007-05-17 09:49:00 | AAPL | Stock | 3.8629 | 3.8636 | 3.8593 | 3.8611 | 1095360.0 |
| 2007-05-17 09:50:00 | AAPL | Stock | 3.8607 | 3.8654 | 3.8604 | 3.865 | 1222256.0 |
| 2007-05-17 09:51:00 | AAPL | Stock | 3.865 | 3.8664 | 3.8625 | 3.8639 | 1732248.0 |
| 2007-05-17 09:52:00 | AAPL | Stock | 3.8646 | 3.8668 | 3.8607 | 3.8607 | 1909012.0 |
| 2007-05-17 09:53:00 | AAPL | Stock | 3.8607 | 3.8614 | 3.8564 | 3.8568 | 2575916.0 |
| 2007-05-17 09:54:00 | AAPL | Stock | 3.8568 | 3.8593 | 3.8479 | 3.8543 | 3805368.0 |
| 2007-05-17 09:55:00 | AAPL | Stock | 3.8536 | 3.8607 | 3.8525 | 3.8607 | 2449188.0 |
| 2007-05-17 09:56:00 | AAPL | Stock | 3.8604 | 3.8625 | 3.86 | 3.8611 | 1601852.0 |
| 2007-05-17 09:57:00 | AAPL | Stock | 3.8604 | 3.8636 | 3.8593 | 3.8636 | 1534344.0 |
| 2007-05-17 09:58:00 | AAPL | Stock | 3.8636 | 3.8654 | 3.8621 | 3.8644 | 2122960.0 |
| 2007-05-17 09:59:00 | AAPL | Stock | 3.8643 | 3.8654 | 3.8625 | 3.8626 | 751604.0 |
| 2007-05-17 10:00:00 | AAPL | Stock | 3.8625 | 3.8632 | 3.8561 | 3.8625 | 2539460.0 |
| 2007-05-17 10:01:00 | AAPL | Stock | 3.8625 | 3.8639 | 3.86 | 3.8614 | 1131536.0 |
| 2007-05-17 10:02:00 | AAPL | Stock | 3.8611 | 3.865 | 3.8604 | 3.865 | 1619408.0 |
| 2007-05-17 10:03:00 | AAPL | Stock | 3.865 | 3.8671 | 3.8643 | 3.8671 | 2399264.0 |
| 2007-05-17 10:04:00 | AAPL | Stock | 3.8671 | 3.8704 | 3.8668 | 3.8685 | 2737924.0 |
| 2007-05-17 10:05:00 | AAPL | Stock | 3.8682 | 3.8714 | 3.8671 | 3.8707 | 3753540.0 |
| 2007-05-17 10:06:00 | AAPL | Stock | 3.8707 | 3.8711 | 3.8679 | 3.8707 | 1675856.0 |
| 2007-05-17 10:07:00 | AAPL | Stock | 3.8707 | 3.8721 | 3.8693 | 3.8704 | 2635080.0 |
| 2007-05-17 10:08:00 | AAPL | Stock | 3.8704 | 3.875 | 3.87 | 3.8739 | 4424168.0 |
| 2007-05-17 10:09:00 | AAPL | Stock | 3.8736 | 3.8742 | 3.8707 | 3.8721 | 2426676.0 |
| 2007-05-17 10:10:00 | AAPL | Stock | 3.8718 | 3.8729 | 3.8707 | 3.8707 | 1232840.0 |
| 2007-05-17 10:11:00 | AAPL | Stock | 3.8707 | 3.8711 | 3.8668 | 3.8696 | 2758504.0 |
| 2007-05-17 10:12:00 | AAPL | Stock | 3.87 | 3.8732 | 3.87 | 3.8718 | 1730316.0 |
| 2007-05-17 10:13:00 | AAPL | Stock | 3.8721 | 3.8724 | 3.8696 | 3.87 | 1243956.0 |
| 2007-05-17 10:14:00 | AAPL | Stock | 3.87 | 3.8729 | 3.8689 | 3.8725 | 1233064.0 |
| 2007-05-17 10:15:00 | AAPL | Stock | 3.8725 | 3.8746 | 3.8718 | 3.8745 | 1921304.0 |
| 2007-05-17 10:16:00 | AAPL | Stock | 3.8746 | 3.8779 | 3.8743 | 3.8746 | 6021372.0 |
| 2007-05-17 10:17:00 | AAPL | Stock | 3.8746 | 3.875 | 3.8711 | 3.8746 | 2399460.0 |
| 2007-05-17 10:18:00 | AAPL | Stock | 3.8743 | 3.8768 | 3.8725 | 3.8732 | 1815212.0 |
| 2007-05-17 10:19:00 | AAPL | Stock | 3.8732 | 3.8736 | 3.8639 | 3.8664 | 2316608.0 |
> showing 50 of 903,118 rows — these rows as CSV