PREVIEW / stock_1min / 2008-06-05
file: by_date/stock_1min/2008/2008-06-05.parquet size: 12.6 MB rows: 1,016,339 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-05 06:10:00 | AAPL | Stock | 6.6293 | 6.6293 | 6.6293 | 6.6293 | 2800.0 |
| 2008-06-05 06:49:00 | AAPL | Stock | 6.6189 | 6.6189 | 6.6189 | 6.6189 | 2800.0 |
| 2008-06-05 07:02:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.6161 | 6.6161 | 2800.0 |
| 2008-06-05 07:25:00 | AAPL | Stock | 6.6311 | 6.6311 | 6.6304 | 6.6304 | 5600.0 |
| 2008-06-05 07:55:00 | AAPL | Stock | 6.6379 | 6.6379 | 6.6379 | 6.6379 | 11200.0 |
| 2008-06-05 07:56:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6411 | 6.6411 | 8400.0 |
| 2008-06-05 07:58:00 | AAPL | Stock | 6.6425 | 6.7229 | 6.6425 | 6.7229 | 147980.0 |
| 2008-06-05 07:59:00 | AAPL | Stock | 6.7129 | 6.7129 | 6.6879 | 6.6879 | 16800.0 |
| 2008-06-05 08:00:00 | AAPL | Stock | 6.6661 | 6.6664 | 6.6546 | 6.6607 | 130452.0 |
| 2008-06-05 08:01:00 | AAPL | Stock | 6.6586 | 6.6629 | 6.6568 | 6.6571 | 120428.0 |
| 2008-06-05 08:02:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 47600.0 |
| 2008-06-05 08:03:00 | AAPL | Stock | 6.66 | 6.66 | 6.6543 | 6.6546 | 19040.0 |
| 2008-06-05 08:04:00 | AAPL | Stock | 6.6571 | 6.6586 | 6.6571 | 6.6586 | 5600.0 |
| 2008-06-05 08:05:00 | AAPL | Stock | 6.6607 | 6.6621 | 6.6607 | 6.6607 | 33600.0 |
| 2008-06-05 08:06:00 | AAPL | Stock | 6.6607 | 6.6632 | 6.6589 | 6.6589 | 28000.0 |
| 2008-06-05 08:07:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2008-06-05 08:08:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6586 | 6.6586 | 29960.0 |
| 2008-06-05 08:09:00 | AAPL | Stock | 6.6604 | 6.6604 | 6.6596 | 6.6604 | 8400.0 |
| 2008-06-05 08:10:00 | AAPL | Stock | 6.6586 | 6.6589 | 6.6586 | 6.6589 | 14000.0 |
| 2008-06-05 08:11:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6589 | 6.6607 | 74060.0 |
| 2008-06-05 08:12:00 | AAPL | Stock | 6.6625 | 6.6639 | 6.6589 | 6.6611 | 64260.0 |
| 2008-06-05 08:14:00 | AAPL | Stock | 6.6639 | 6.6643 | 6.6611 | 6.6643 | 62132.0 |
| 2008-06-05 08:15:00 | AAPL | Stock | 6.6661 | 6.6721 | 6.6654 | 6.6661 | 52584.0 |
| 2008-06-05 08:16:00 | AAPL | Stock | 6.6686 | 6.6686 | 6.6671 | 6.6671 | 5600.0 |
| 2008-06-05 08:17:00 | AAPL | Stock | 6.6661 | 6.6679 | 6.6661 | 6.6668 | 33600.0 |
| 2008-06-05 08:19:00 | AAPL | Stock | 6.6661 | 6.6661 | 6.6661 | 6.6661 | 37240.0 |
| 2008-06-05 08:20:00 | AAPL | Stock | 6.6679 | 6.6689 | 6.6679 | 6.6689 | 22400.0 |
| 2008-06-05 08:21:00 | AAPL | Stock | 6.6682 | 6.6682 | 6.6661 | 6.6661 | 35392.0 |
| 2008-06-05 08:22:00 | AAPL | Stock | 6.6661 | 6.6661 | 6.6661 | 6.6661 | 2800.0 |
| 2008-06-05 08:23:00 | AAPL | Stock | 6.6657 | 6.6657 | 6.6643 | 6.6643 | 61600.0 |
| 2008-06-05 08:24:00 | AAPL | Stock | 6.6629 | 6.6629 | 6.6629 | 6.6629 | 2800.0 |
| 2008-06-05 08:25:00 | AAPL | Stock | 6.6629 | 6.6629 | 6.6607 | 6.6607 | 25200.0 |
| 2008-06-05 08:26:00 | AAPL | Stock | 6.6589 | 6.6589 | 6.6589 | 6.6589 | 14000.0 |
| 2008-06-05 08:27:00 | AAPL | Stock | 6.6571 | 6.6575 | 6.6554 | 6.6554 | 56000.0 |
| 2008-06-05 08:28:00 | AAPL | Stock | 6.6554 | 6.6564 | 6.6554 | 6.6554 | 44632.0 |
| 2008-06-05 08:29:00 | AAPL | Stock | 6.6564 | 6.6582 | 6.6564 | 6.6582 | 22400.0 |
| 2008-06-05 08:30:00 | AAPL | Stock | 6.66 | 6.6707 | 6.66 | 6.6679 | 228816.0 |
| 2008-06-05 08:31:00 | AAPL | Stock | 6.6657 | 6.6657 | 6.6607 | 6.6629 | 129164.0 |
| 2008-06-05 08:32:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 12600.0 |
| 2008-06-05 08:33:00 | AAPL | Stock | 6.6604 | 6.6675 | 6.6604 | 6.6675 | 178444.0 |
| 2008-06-05 08:34:00 | AAPL | Stock | 6.6675 | 6.6689 | 6.6675 | 6.6679 | 67200.0 |
| 2008-06-05 08:35:00 | AAPL | Stock | 6.6696 | 6.6764 | 6.6696 | 6.675 | 147840.0 |
| 2008-06-05 08:36:00 | AAPL | Stock | 6.6736 | 6.675 | 6.6714 | 6.675 | 21700.0 |
| 2008-06-05 08:37:00 | AAPL | Stock | 6.6707 | 6.6714 | 6.6679 | 6.6696 | 91560.0 |
| 2008-06-05 08:38:00 | AAPL | Stock | 6.6696 | 6.6714 | 6.6696 | 6.6714 | 8960.0 |
| 2008-06-05 08:39:00 | AAPL | Stock | 6.6746 | 6.675 | 6.6739 | 6.6746 | 86800.0 |
| 2008-06-05 08:40:00 | AAPL | Stock | 6.6718 | 6.6732 | 6.6718 | 6.6732 | 5600.0 |
| 2008-06-05 08:41:00 | AAPL | Stock | 6.6689 | 6.6729 | 6.6686 | 6.6729 | 43820.0 |
| 2008-06-05 08:42:00 | AAPL | Stock | 6.6729 | 6.675 | 6.6725 | 6.675 | 20300.0 |
| 2008-06-05 08:43:00 | AAPL | Stock | 6.6743 | 6.6768 | 6.6743 | 6.675 | 103600.0 |
> showing 50 of 1,016,339 rows — these rows as CSV