PREVIEW / stock_1min / 2011-08-30
file: by_date/stock_1min/2011/2011-08-30.parquet size: 13.4 MB rows: 1,010,033 symbols: 2,845
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-30 04:32:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-08-30 04:33:00 | AAPL | Stock | 13.8682 | 13.8682 | 13.8682 | 13.8682 | 2800.0 |
| 2011-08-30 05:13:00 | AAPL | Stock | 13.8789 | 13.8789 | 13.8789 | 13.8789 | 2800.0 |
| 2011-08-30 06:19:00 | AAPL | Stock | 13.8743 | 13.8743 | 13.8661 | 13.8661 | 9240.0 |
| 2011-08-30 06:25:00 | AAPL | Stock | 13.8632 | 13.8632 | 13.8632 | 13.8632 | 2800.0 |
| 2011-08-30 06:29:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 2800.0 |
| 2011-08-30 06:48:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 2800.0 |
| 2011-08-30 06:49:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 11536.0 |
| 2011-08-30 06:50:00 | AAPL | Stock | 13.8871 | 13.8871 | 13.8871 | 13.8871 | 2800.0 |
| 2011-08-30 07:02:00 | AAPL | Stock | 13.8918 | 13.8929 | 13.8918 | 13.8929 | 13860.0 |
| 2011-08-30 07:08:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-08-30 07:10:00 | AAPL | Stock | 13.8854 | 13.8929 | 13.8725 | 13.8929 | 63196.0 |
| 2011-08-30 07:20:00 | AAPL | Stock | 13.8754 | 13.8754 | 13.8754 | 13.8754 | 2800.0 |
| 2011-08-30 07:23:00 | AAPL | Stock | 13.875 | 13.875 | 13.875 | 13.875 | 5600.0 |
| 2011-08-30 07:24:00 | AAPL | Stock | 13.875 | 13.875 | 13.875 | 13.875 | 5600.0 |
| 2011-08-30 07:31:00 | AAPL | Stock | 13.8804 | 13.8804 | 13.8804 | 13.8804 | 2800.0 |
| 2011-08-30 07:32:00 | AAPL | Stock | 13.8882 | 13.8889 | 13.8882 | 13.8889 | 6440.0 |
| 2011-08-30 07:37:00 | AAPL | Stock | 13.8736 | 13.8736 | 13.8714 | 13.8714 | 7560.0 |
| 2011-08-30 07:38:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8714 | 13.8714 | 8400.0 |
| 2011-08-30 07:49:00 | AAPL | Stock | 13.8821 | 13.8875 | 13.8789 | 13.8875 | 16800.0 |
| 2011-08-30 07:53:00 | AAPL | Stock | 13.8725 | 13.8725 | 13.8714 | 13.8714 | 21616.0 |
| 2011-08-30 07:54:00 | AAPL | Stock | 13.8664 | 13.8664 | 13.8664 | 13.8664 | 2800.0 |
| 2011-08-30 07:55:00 | AAPL | Stock | 13.8686 | 13.8686 | 13.8686 | 13.8686 | 8400.0 |
| 2011-08-30 07:56:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8714 | 13.8714 | 2800.0 |
| 2011-08-30 07:59:00 | AAPL | Stock | 13.875 | 13.8786 | 13.875 | 13.8761 | 9156.0 |
| 2011-08-30 08:00:00 | AAPL | Stock | 13.8875 | 13.8875 | 13.8661 | 13.8664 | 128492.0 |
| 2011-08-30 08:01:00 | AAPL | Stock | 13.8668 | 13.8696 | 13.8632 | 13.8632 | 19600.0 |
| 2011-08-30 08:02:00 | AAPL | Stock | 13.8679 | 13.8696 | 13.8625 | 13.8625 | 38836.0 |
| 2011-08-30 08:03:00 | AAPL | Stock | 13.8679 | 13.8696 | 13.8614 | 13.8614 | 11200.0 |
| 2011-08-30 08:04:00 | AAPL | Stock | 13.8629 | 13.875 | 13.8614 | 13.875 | 47600.0 |
| 2011-08-30 08:05:00 | AAPL | Stock | 13.875 | 13.875 | 13.8607 | 13.8625 | 115360.0 |
| 2011-08-30 08:06:00 | AAPL | Stock | 13.8639 | 13.8639 | 13.8639 | 13.8639 | 8400.0 |
| 2011-08-30 08:07:00 | AAPL | Stock | 13.8639 | 13.8696 | 13.8639 | 13.8696 | 17612.0 |
| 2011-08-30 08:08:00 | AAPL | Stock | 13.8632 | 13.8632 | 13.8518 | 13.8536 | 103600.0 |
| 2011-08-30 08:10:00 | AAPL | Stock | 13.8532 | 13.8554 | 13.8532 | 13.8554 | 19600.0 |
| 2011-08-30 08:11:00 | AAPL | Stock | 13.8536 | 13.8564 | 13.8536 | 13.8536 | 11200.0 |
| 2011-08-30 08:12:00 | AAPL | Stock | 13.8536 | 13.8564 | 13.8525 | 13.8525 | 22400.0 |
| 2011-08-30 08:13:00 | AAPL | Stock | 13.8518 | 13.8536 | 13.8518 | 13.8536 | 131600.0 |
| 2011-08-30 08:14:00 | AAPL | Stock | 13.8532 | 13.8571 | 13.8518 | 13.8518 | 171080.0 |
| 2011-08-30 08:15:00 | AAPL | Stock | 13.8564 | 13.8564 | 13.8564 | 13.8564 | 2800.0 |
| 2011-08-30 08:16:00 | AAPL | Stock | 13.8711 | 13.8714 | 13.8568 | 13.8607 | 38892.0 |
| 2011-08-30 08:17:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8571 | 13.8571 | 19600.0 |
| 2011-08-30 08:18:00 | AAPL | Stock | 13.8568 | 13.8568 | 13.8568 | 13.8568 | 2800.0 |
| 2011-08-30 08:19:00 | AAPL | Stock | 13.86 | 13.8661 | 13.8596 | 13.8661 | 14000.0 |
| 2011-08-30 08:20:00 | AAPL | Stock | 13.8625 | 13.8625 | 13.8607 | 13.8607 | 8400.0 |
| 2011-08-30 08:21:00 | AAPL | Stock | 13.8614 | 13.8614 | 13.8614 | 13.8614 | 14000.0 |
| 2011-08-30 08:22:00 | AAPL | Stock | 13.8571 | 13.8596 | 13.8482 | 13.8571 | 54516.0 |
| 2011-08-30 08:23:00 | AAPL | Stock | 13.8536 | 13.8536 | 13.8536 | 13.8536 | 5600.0 |
| 2011-08-30 08:24:00 | AAPL | Stock | 13.8504 | 13.8604 | 13.8504 | 13.8604 | 30800.0 |
| 2011-08-30 08:25:00 | AAPL | Stock | 13.8607 | 13.875 | 13.8571 | 13.8571 | 71400.0 |
> showing 50 of 1,010,033 rows — these rows as CSV