PREVIEW / stock_1min / 2012-03-27
file: by_date/stock_1min/2012/2012-03-27.parquet size: 13.2 MB rows: 985,433 symbols: 2,848
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-27 04:18:00 | AAPL | Stock | 21.6879 | 21.6961 | 21.6879 | 21.6961 | 5600.0 |
| 2012-03-27 04:39:00 | AAPL | Stock | 21.6829 | 21.6829 | 21.6829 | 21.6829 | 8400.0 |
| 2012-03-27 04:42:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 14168.0 |
| 2012-03-27 04:44:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 22400.0 |
| 2012-03-27 04:53:00 | AAPL | Stock | 21.6696 | 21.6696 | 21.6696 | 21.6696 | 14000.0 |
| 2012-03-27 04:58:00 | AAPL | Stock | 21.6682 | 21.6682 | 21.6679 | 21.6679 | 5600.0 |
| 2012-03-27 05:01:00 | AAPL | Stock | 21.6779 | 21.6779 | 21.6779 | 21.6779 | 2800.0 |
| 2012-03-27 05:11:00 | AAPL | Stock | 21.6929 | 21.6929 | 21.6929 | 21.6929 | 5600.0 |
| 2012-03-27 05:12:00 | AAPL | Stock | 21.6929 | 21.6964 | 21.6929 | 21.6964 | 5600.0 |
| 2012-03-27 05:13:00 | AAPL | Stock | 21.6875 | 21.6875 | 21.6875 | 21.6875 | 5600.0 |
| 2012-03-27 05:14:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 36400.0 |
| 2012-03-27 05:21:00 | AAPL | Stock | 21.6864 | 21.6864 | 21.6864 | 21.6864 | 8400.0 |
| 2012-03-27 05:23:00 | AAPL | Stock | 21.6789 | 21.6789 | 21.6786 | 21.6786 | 25200.0 |
| 2012-03-27 05:37:00 | AAPL | Stock | 21.6679 | 21.6679 | 21.6679 | 21.6679 | 35000.0 |
| 2012-03-27 05:44:00 | AAPL | Stock | 21.6682 | 21.6682 | 21.6679 | 21.6679 | 14000.0 |
| 2012-03-27 06:03:00 | AAPL | Stock | 21.6679 | 21.6679 | 21.6679 | 21.6679 | 7000.0 |
| 2012-03-27 06:04:00 | AAPL | Stock | 21.6786 | 21.6964 | 21.6786 | 21.6964 | 53060.0 |
| 2012-03-27 06:36:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 7756.0 |
| 2012-03-27 06:46:00 | AAPL | Stock | 21.6782 | 21.6789 | 21.6782 | 21.6789 | 24920.0 |
| 2012-03-27 06:50:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6714 | 21.6714 | 5600.0 |
| 2012-03-27 07:01:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6661 | 21.6661 | 5600.0 |
| 2012-03-27 07:02:00 | AAPL | Stock | 21.6625 | 21.6686 | 21.6625 | 21.6686 | 8400.0 |
| 2012-03-27 07:03:00 | AAPL | Stock | 21.6729 | 21.6739 | 21.6589 | 21.6589 | 23408.0 |
| 2012-03-27 07:06:00 | AAPL | Stock | 21.6596 | 21.6596 | 21.6596 | 21.6596 | 2800.0 |
| 2012-03-27 07:08:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 14000.0 |
| 2012-03-27 07:09:00 | AAPL | Stock | 21.6607 | 21.665 | 21.6607 | 21.665 | 11200.0 |
| 2012-03-27 07:10:00 | AAPL | Stock | 21.6657 | 21.6657 | 21.6657 | 21.6657 | 2800.0 |
| 2012-03-27 07:13:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 5600.0 |
| 2012-03-27 07:14:00 | AAPL | Stock | 21.6639 | 21.6639 | 21.6639 | 21.6639 | 2800.0 |
| 2012-03-27 07:16:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 24892.0 |
| 2012-03-27 07:17:00 | AAPL | Stock | 21.6589 | 21.6704 | 21.6554 | 21.6704 | 50988.0 |
| 2012-03-27 07:18:00 | AAPL | Stock | 21.6707 | 21.6707 | 21.6707 | 21.6707 | 2800.0 |
| 2012-03-27 07:23:00 | AAPL | Stock | 21.6707 | 21.6707 | 21.6707 | 21.6707 | 2800.0 |
| 2012-03-27 07:32:00 | AAPL | Stock | 21.6707 | 21.6707 | 21.6707 | 21.6707 | 5180.0 |
| 2012-03-27 07:41:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6471 | 21.6471 | 37240.0 |
| 2012-03-27 07:44:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.64 | 21.64 | 5600.0 |
| 2012-03-27 07:49:00 | AAPL | Stock | 21.6429 | 21.6561 | 21.6429 | 21.6561 | 14000.0 |
| 2012-03-27 07:52:00 | AAPL | Stock | 21.6432 | 21.6432 | 21.6429 | 21.6429 | 27944.0 |
| 2012-03-27 07:53:00 | AAPL | Stock | 21.6425 | 21.6425 | 21.6425 | 21.6425 | 2800.0 |
| 2012-03-27 07:54:00 | AAPL | Stock | 21.6254 | 21.6339 | 21.6232 | 21.6286 | 60088.0 |
| 2012-03-27 07:55:00 | AAPL | Stock | 21.6286 | 21.6389 | 21.6286 | 21.6389 | 31164.0 |
| 2012-03-27 07:56:00 | AAPL | Stock | 21.6339 | 21.6339 | 21.6339 | 21.6339 | 2800.0 |
| 2012-03-27 07:57:00 | AAPL | Stock | 21.6321 | 21.6321 | 21.6071 | 21.6071 | 135912.0 |
| 2012-03-27 07:58:00 | AAPL | Stock | 21.5989 | 21.6189 | 21.595 | 21.6107 | 144200.0 |
| 2012-03-27 07:59:00 | AAPL | Stock | 21.6111 | 21.6179 | 21.6082 | 21.6179 | 27888.0 |
| 2012-03-27 08:00:00 | AAPL | Stock | 21.6071 | 21.6743 | 21.6071 | 21.6139 | 134596.0 |
| 2012-03-27 08:01:00 | AAPL | Stock | 21.6086 | 21.6143 | 21.6036 | 21.6082 | 139048.0 |
| 2012-03-27 08:02:00 | AAPL | Stock | 21.6089 | 21.6143 | 21.6082 | 21.6143 | 39480.0 |
| 2012-03-27 08:03:00 | AAPL | Stock | 21.6214 | 21.6221 | 21.62 | 21.6221 | 16800.0 |
| 2012-03-27 08:04:00 | AAPL | Stock | 21.6214 | 21.6286 | 21.6214 | 21.6286 | 74676.0 |
> showing 50 of 985,433 rows — these rows as CSV