PREVIEW / stock_1min / 2012-10-05
file: by_date/stock_1min/2012/2012-10-05.parquet size: 12.3 MB rows: 911,043 symbols: 2,794
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-10-05 04:49:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 11200.0 |
| 2012-10-05 06:56:00 | AAPL | Stock | 23.8132 | 23.8132 | 23.8132 | 23.8132 | 9800.0 |
| 2012-10-05 06:58:00 | AAPL | Stock | 23.8036 | 23.8036 | 23.8036 | 23.8036 | 16800.0 |
| 2012-10-05 07:00:00 | AAPL | Stock | 23.7961 | 23.7961 | 23.7961 | 23.7961 | 8400.0 |
| 2012-10-05 07:02:00 | AAPL | Stock | 23.7918 | 23.7964 | 23.7918 | 23.7918 | 27972.0 |
| 2012-10-05 07:03:00 | AAPL | Stock | 23.7918 | 23.7918 | 23.7918 | 23.7918 | 5600.0 |
| 2012-10-05 07:04:00 | AAPL | Stock | 23.7893 | 23.79 | 23.7893 | 23.79 | 11200.0 |
| 2012-10-05 07:05:00 | AAPL | Stock | 23.79 | 23.79 | 23.7786 | 23.7786 | 8400.0 |
| 2012-10-05 07:07:00 | AAPL | Stock | 23.7804 | 23.7804 | 23.7804 | 23.7804 | 2800.0 |
| 2012-10-05 07:08:00 | AAPL | Stock | 23.7918 | 23.7918 | 23.7918 | 23.7918 | 5600.0 |
| 2012-10-05 07:09:00 | AAPL | Stock | 23.7918 | 23.7964 | 23.7918 | 23.7964 | 17080.0 |
| 2012-10-05 07:10:00 | AAPL | Stock | 23.7929 | 23.7929 | 23.7929 | 23.7929 | 4508.0 |
| 2012-10-05 07:12:00 | AAPL | Stock | 23.7804 | 23.7804 | 23.7804 | 23.7804 | 2800.0 |
| 2012-10-05 07:14:00 | AAPL | Stock | 23.7754 | 23.7754 | 23.7714 | 23.7714 | 16828.0 |
| 2012-10-05 07:15:00 | AAPL | Stock | 23.7679 | 23.775 | 23.7679 | 23.775 | 35000.0 |
| 2012-10-05 07:16:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 11200.0 |
| 2012-10-05 07:17:00 | AAPL | Stock | 23.7854 | 23.7854 | 23.7854 | 23.7854 | 2800.0 |
| 2012-10-05 07:19:00 | AAPL | Stock | 23.7786 | 23.7789 | 23.7786 | 23.7789 | 5600.0 |
| 2012-10-05 07:22:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7854 | 23.7854 | 13664.0 |
| 2012-10-05 07:25:00 | AAPL | Stock | 23.7854 | 23.7889 | 23.7854 | 23.7889 | 5600.0 |
| 2012-10-05 07:32:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 2800.0 |
| 2012-10-05 07:33:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 5600.0 |
| 2012-10-05 07:34:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 2800.0 |
| 2012-10-05 07:36:00 | AAPL | Stock | 23.7911 | 23.7946 | 23.7911 | 23.7946 | 8400.0 |
| 2012-10-05 07:37:00 | AAPL | Stock | 23.7946 | 23.7982 | 23.7946 | 23.7971 | 57680.0 |
| 2012-10-05 07:46:00 | AAPL | Stock | 23.7946 | 23.7946 | 23.7946 | 23.7946 | 5600.0 |
| 2012-10-05 07:51:00 | AAPL | Stock | 23.7964 | 23.7964 | 23.7964 | 23.7964 | 7980.0 |
| 2012-10-05 07:52:00 | AAPL | Stock | 23.7964 | 23.7982 | 23.7964 | 23.7982 | 39200.0 |
| 2012-10-05 07:53:00 | AAPL | Stock | 23.8071 | 23.8071 | 23.7964 | 23.7964 | 14000.0 |
| 2012-10-05 07:54:00 | AAPL | Stock | 23.7993 | 23.8075 | 23.7993 | 23.8075 | 11200.0 |
| 2012-10-05 07:55:00 | AAPL | Stock | 23.7993 | 23.8036 | 23.7957 | 23.8036 | 24640.0 |
| 2012-10-05 07:56:00 | AAPL | Stock | 23.7982 | 23.7982 | 23.7982 | 23.7982 | 2800.0 |
| 2012-10-05 07:59:00 | AAPL | Stock | 23.7982 | 23.8032 | 23.7982 | 23.8032 | 5600.0 |
| 2012-10-05 08:00:00 | AAPL | Stock | 23.8018 | 23.8089 | 23.7982 | 23.7982 | 81480.0 |
| 2012-10-05 08:01:00 | AAPL | Stock | 23.7964 | 23.7964 | 23.7857 | 23.7857 | 47320.0 |
| 2012-10-05 08:02:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7625 | 23.7625 | 58828.0 |
| 2012-10-05 08:03:00 | AAPL | Stock | 23.7679 | 23.7686 | 23.7514 | 23.7543 | 50680.0 |
| 2012-10-05 08:04:00 | AAPL | Stock | 23.7539 | 23.7607 | 23.7536 | 23.7607 | 13020.0 |
| 2012-10-05 08:05:00 | AAPL | Stock | 23.7532 | 23.7532 | 23.7479 | 23.7496 | 22512.0 |
| 2012-10-05 08:06:00 | AAPL | Stock | 23.7339 | 23.7339 | 23.7339 | 23.7339 | 2800.0 |
| 2012-10-05 08:07:00 | AAPL | Stock | 23.7396 | 23.7446 | 23.7393 | 23.7446 | 19572.0 |
| 2012-10-05 08:08:00 | AAPL | Stock | 23.7464 | 23.7525 | 23.7464 | 23.7507 | 14000.0 |
| 2012-10-05 08:09:00 | AAPL | Stock | 23.7536 | 23.7536 | 23.7536 | 23.7536 | 3220.0 |
| 2012-10-05 08:10:00 | AAPL | Stock | 23.7661 | 23.7661 | 23.7625 | 23.7625 | 6188.0 |
| 2012-10-05 08:11:00 | AAPL | Stock | 23.7514 | 23.7514 | 23.7507 | 23.7511 | 11200.0 |
| 2012-10-05 08:12:00 | AAPL | Stock | 23.7636 | 23.7636 | 23.7636 | 23.7636 | 2800.0 |
| 2012-10-05 08:13:00 | AAPL | Stock | 23.7561 | 23.7561 | 23.7561 | 23.7561 | 12488.0 |
| 2012-10-05 08:14:00 | AAPL | Stock | 23.7593 | 23.7593 | 23.7593 | 23.7593 | 2800.0 |
| 2012-10-05 08:15:00 | AAPL | Stock | 23.7618 | 23.7625 | 23.7618 | 23.7625 | 5600.0 |
| 2012-10-05 08:16:00 | AAPL | Stock | 23.7668 | 23.7729 | 23.7668 | 23.7729 | 15120.0 |
> showing 50 of 911,043 rows — these rows as CSV