PREVIEW / stock_1min / 2006-10-05
file: by_date/stock_1min/2006/2006-10-05.parquet size: 8.8 MB rows: 711,382 symbols: 1,940
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-05 06:33:00 | AAPL | Stock | 2.6864 | 2.6864 | 2.6864 | 2.6864 | 2800.0 |
| 2006-10-05 06:39:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6964 | 2.6964 | 56000.0 |
| 2006-10-05 06:56:00 | AAPL | Stock | 2.6939 | 2.6939 | 2.6936 | 2.6936 | 28000.0 |
| 2006-10-05 06:57:00 | AAPL | Stock | 2.6804 | 2.6804 | 2.6804 | 2.6804 | 16800.0 |
| 2006-10-05 07:00:00 | AAPL | Stock | 2.6611 | 2.6611 | 2.6611 | 2.6611 | 8400.0 |
| 2006-10-05 07:09:00 | AAPL | Stock | 2.6725 | 2.6725 | 2.6718 | 2.6718 | 8400.0 |
| 2006-10-05 07:12:00 | AAPL | Stock | 2.6718 | 2.6721 | 2.6718 | 2.6721 | 11200.0 |
| 2006-10-05 07:19:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 19600.0 |
| 2006-10-05 07:23:00 | AAPL | Stock | 2.6696 | 2.6696 | 2.6696 | 2.6696 | 21280.0 |
| 2006-10-05 07:33:00 | AAPL | Stock | 2.675 | 2.675 | 2.675 | 2.675 | 14000.0 |
| 2006-10-05 07:35:00 | AAPL | Stock | 2.6711 | 2.6711 | 2.6711 | 2.6711 | 2800.0 |
| 2006-10-05 07:41:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6554 | 2.6554 | 291200.0 |
| 2006-10-05 07:43:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.6554 | 2.6554 | 44800.0 |
| 2006-10-05 07:51:00 | AAPL | Stock | 2.6704 | 2.6725 | 2.6704 | 2.6725 | 8400.0 |
| 2006-10-05 07:59:00 | AAPL | Stock | 2.6671 | 2.6671 | 2.6671 | 2.6671 | 28000.0 |
| 2006-10-05 08:00:00 | AAPL | Stock | 2.6611 | 2.6696 | 2.6596 | 2.6596 | 188804.0 |
| 2006-10-05 08:01:00 | AAPL | Stock | 2.6614 | 2.6679 | 2.6554 | 2.6571 | 874440.0 |
| 2006-10-05 08:02:00 | AAPL | Stock | 2.6571 | 2.6632 | 2.6561 | 2.6611 | 130732.0 |
| 2006-10-05 08:03:00 | AAPL | Stock | 2.6618 | 2.6643 | 2.6618 | 2.6643 | 28000.0 |
| 2006-10-05 08:04:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6621 | 2.6625 | 175840.0 |
| 2006-10-05 08:05:00 | AAPL | Stock | 2.6621 | 2.6643 | 2.6611 | 2.6629 | 141008.0 |
| 2006-10-05 08:06:00 | AAPL | Stock | 2.6625 | 2.6629 | 2.6625 | 2.6629 | 119000.0 |
| 2006-10-05 08:07:00 | AAPL | Stock | 2.6629 | 2.6629 | 2.6625 | 2.6629 | 35000.0 |
| 2006-10-05 08:08:00 | AAPL | Stock | 2.6625 | 2.6625 | 2.6607 | 2.6607 | 213164.0 |
| 2006-10-05 08:09:00 | AAPL | Stock | 2.6629 | 2.6646 | 2.6629 | 2.6639 | 39200.0 |
| 2006-10-05 08:10:00 | AAPL | Stock | 2.6625 | 2.6625 | 2.6625 | 2.6625 | 27608.0 |
| 2006-10-05 08:11:00 | AAPL | Stock | 2.6614 | 2.6614 | 2.6593 | 2.66 | 90972.0 |
| 2006-10-05 08:12:00 | AAPL | Stock | 2.66 | 2.6625 | 2.66 | 2.6625 | 74340.0 |
| 2006-10-05 08:13:00 | AAPL | Stock | 2.66 | 2.66 | 2.6589 | 2.6589 | 5656.0 |
| 2006-10-05 08:14:00 | AAPL | Stock | 2.6593 | 2.6625 | 2.6589 | 2.6625 | 69468.0 |
| 2006-10-05 08:15:00 | AAPL | Stock | 2.6639 | 2.6639 | 2.6607 | 2.6607 | 98644.0 |
| 2006-10-05 08:16:00 | AAPL | Stock | 2.6589 | 2.6607 | 2.6589 | 2.6607 | 60116.0 |
| 2006-10-05 08:17:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6575 | 2.6589 | 29680.0 |
| 2006-10-05 08:18:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6589 | 2.6589 | 6160.0 |
| 2006-10-05 08:19:00 | AAPL | Stock | 2.6589 | 2.6607 | 2.6589 | 2.6607 | 21112.0 |
| 2006-10-05 08:20:00 | AAPL | Stock | 2.6589 | 2.6607 | 2.6589 | 2.6607 | 39536.0 |
| 2006-10-05 08:24:00 | AAPL | Stock | 2.6586 | 2.6586 | 2.6586 | 2.6586 | 2800.0 |
| 2006-10-05 08:25:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 28000.0 |
| 2006-10-05 08:26:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 35280.0 |
| 2006-10-05 08:27:00 | AAPL | Stock | 2.6621 | 2.6625 | 2.6621 | 2.6625 | 70000.0 |
| 2006-10-05 08:29:00 | AAPL | Stock | 2.6625 | 2.6625 | 2.6607 | 2.6607 | 19600.0 |
| 2006-10-05 08:30:00 | AAPL | Stock | 2.6625 | 2.6625 | 2.6625 | 2.6625 | 8400.0 |
| 2006-10-05 08:32:00 | AAPL | Stock | 2.6607 | 2.6625 | 2.6607 | 2.6614 | 25284.0 |
| 2006-10-05 08:33:00 | AAPL | Stock | 2.6614 | 2.6614 | 2.6614 | 2.6614 | 2800.0 |
| 2006-10-05 08:35:00 | AAPL | Stock | 2.6625 | 2.6625 | 2.6625 | 2.6625 | 25284.0 |
| 2006-10-05 08:36:00 | AAPL | Stock | 2.6639 | 2.6696 | 2.6639 | 2.6696 | 128800.0 |
| 2006-10-05 08:37:00 | AAPL | Stock | 2.6679 | 2.6679 | 2.6643 | 2.6643 | 113400.0 |
| 2006-10-05 08:38:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6593 | 2.6632 | 70000.0 |
| 2006-10-05 08:39:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6589 | 2.6589 | 103600.0 |
| 2006-10-05 08:40:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6589 | 2.6589 | 5600.0 |
> showing 50 of 711,382 rows — these rows as CSV