PREVIEW / stock_1min / 2011-02-11
file: by_date/stock_1min/2011/2011-02-11.parquet size: 13.2 MB rows: 979,796 symbols: 2,869
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-02-11 04:12:00 | AAPL | Stock | 12.6032 | 12.6032 | 12.6032 | 12.6032 | 2800.0 |
| 2011-02-11 04:17:00 | AAPL | Stock | 12.6086 | 12.6086 | 12.6086 | 12.6086 | 2800.0 |
| 2011-02-11 04:30:00 | AAPL | Stock | 12.5929 | 12.5929 | 12.5929 | 12.5929 | 5600.0 |
| 2011-02-11 04:35:00 | AAPL | Stock | 12.6075 | 12.6075 | 12.6075 | 12.6075 | 2800.0 |
| 2011-02-11 04:44:00 | AAPL | Stock | 12.615 | 12.615 | 12.6036 | 12.6036 | 8400.0 |
| 2011-02-11 05:01:00 | AAPL | Stock | 12.6043 | 12.6043 | 12.6043 | 12.6043 | 5600.0 |
| 2011-02-11 06:06:00 | AAPL | Stock | 12.5786 | 12.5786 | 12.5786 | 12.5786 | 8400.0 |
| 2011-02-11 06:07:00 | AAPL | Stock | 12.5786 | 12.5786 | 12.5786 | 12.5786 | 2800.0 |
| 2011-02-11 06:18:00 | AAPL | Stock | 12.6089 | 12.6089 | 12.6089 | 12.6089 | 2800.0 |
| 2011-02-11 06:25:00 | AAPL | Stock | 12.5857 | 12.5857 | 12.5857 | 12.5857 | 2912.0 |
| 2011-02-11 07:00:00 | AAPL | Stock | 12.6071 | 12.6071 | 12.6071 | 12.6071 | 2800.0 |
| 2011-02-11 07:04:00 | AAPL | Stock | 12.6246 | 12.6246 | 12.6246 | 12.6246 | 2800.0 |
| 2011-02-11 07:05:00 | AAPL | Stock | 12.625 | 12.6343 | 12.6246 | 12.6343 | 8400.0 |
| 2011-02-11 07:06:00 | AAPL | Stock | 12.6571 | 12.6571 | 12.6536 | 12.6536 | 5600.0 |
| 2011-02-11 07:08:00 | AAPL | Stock | 12.6561 | 12.6561 | 12.6429 | 12.6429 | 16800.0 |
| 2011-02-11 07:09:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-02-11 07:14:00 | AAPL | Stock | 12.6304 | 12.6304 | 12.6282 | 12.6282 | 5600.0 |
| 2011-02-11 07:17:00 | AAPL | Stock | 12.6321 | 12.6321 | 12.6321 | 12.6321 | 2800.0 |
| 2011-02-11 07:20:00 | AAPL | Stock | 12.6271 | 12.6404 | 12.6232 | 12.6404 | 30800.0 |
| 2011-02-11 07:28:00 | AAPL | Stock | 12.6418 | 12.6418 | 12.6418 | 12.6418 | 2800.0 |
| 2011-02-11 07:29:00 | AAPL | Stock | 12.64 | 12.6429 | 12.6375 | 12.6375 | 13160.0 |
| 2011-02-11 07:30:00 | AAPL | Stock | 12.6164 | 12.6164 | 12.6164 | 12.6164 | 5040.0 |
| 2011-02-11 07:33:00 | AAPL | Stock | 12.6304 | 12.6304 | 12.6304 | 12.6304 | 2800.0 |
| 2011-02-11 07:36:00 | AAPL | Stock | 12.6332 | 12.6332 | 12.6332 | 12.6332 | 2800.0 |
| 2011-02-11 07:42:00 | AAPL | Stock | 12.6321 | 12.6336 | 12.6318 | 12.6336 | 18200.0 |
| 2011-02-11 07:45:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6418 | 12.6418 | 12040.0 |
| 2011-02-11 07:47:00 | AAPL | Stock | 12.6464 | 12.6564 | 12.6464 | 12.6564 | 11676.0 |
| 2011-02-11 07:48:00 | AAPL | Stock | 12.6564 | 12.6564 | 12.6564 | 12.6564 | 14000.0 |
| 2011-02-11 07:49:00 | AAPL | Stock | 12.6432 | 12.6432 | 12.6429 | 12.6429 | 75600.0 |
| 2011-02-11 07:52:00 | AAPL | Stock | 12.6357 | 12.6582 | 12.6357 | 12.6582 | 54600.0 |
| 2011-02-11 07:56:00 | AAPL | Stock | 12.655 | 12.655 | 12.655 | 12.655 | 2800.0 |
| 2011-02-11 07:57:00 | AAPL | Stock | 12.655 | 12.6554 | 12.655 | 12.6554 | 25060.0 |
| 2011-02-11 08:00:00 | AAPL | Stock | 12.6446 | 12.6596 | 12.64 | 12.6596 | 42140.0 |
| 2011-02-11 08:01:00 | AAPL | Stock | 12.6596 | 12.6643 | 12.6596 | 12.6643 | 6160.0 |
| 2011-02-11 08:02:00 | AAPL | Stock | 12.6661 | 12.6775 | 12.6643 | 12.6775 | 72240.0 |
| 2011-02-11 08:03:00 | AAPL | Stock | 12.6786 | 12.6964 | 12.6786 | 12.6964 | 88060.0 |
| 2011-02-11 08:04:00 | AAPL | Stock | 12.7025 | 12.7032 | 12.6964 | 12.7 | 62720.0 |
| 2011-02-11 08:05:00 | AAPL | Stock | 12.7 | 12.7 | 12.6911 | 12.6929 | 98560.0 |
| 2011-02-11 08:06:00 | AAPL | Stock | 12.6929 | 12.6996 | 12.6929 | 12.6996 | 11200.0 |
| 2011-02-11 08:07:00 | AAPL | Stock | 12.6961 | 12.6982 | 12.6861 | 12.6861 | 57736.0 |
| 2011-02-11 08:08:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6875 | 12.6964 | 19460.0 |
| 2011-02-11 08:09:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6911 | 12.6964 | 18200.0 |
| 2011-02-11 08:10:00 | AAPL | Stock | 12.6893 | 12.6893 | 12.6857 | 12.6857 | 35140.0 |
| 2011-02-11 08:11:00 | AAPL | Stock | 12.6886 | 12.6921 | 12.6886 | 12.6921 | 8400.0 |
| 2011-02-11 08:12:00 | AAPL | Stock | 12.6882 | 12.6882 | 12.6857 | 12.6857 | 33600.0 |
| 2011-02-11 08:13:00 | AAPL | Stock | 12.6854 | 12.6921 | 12.6854 | 12.6921 | 11200.0 |
| 2011-02-11 08:15:00 | AAPL | Stock | 12.6911 | 12.6911 | 12.6861 | 12.6861 | 19600.0 |
| 2011-02-11 08:16:00 | AAPL | Stock | 12.6875 | 12.6875 | 12.6843 | 12.6843 | 7504.0 |
| 2011-02-11 08:17:00 | AAPL | Stock | 12.6911 | 12.6925 | 12.6893 | 12.6893 | 14000.0 |
| 2011-02-11 08:18:00 | AAPL | Stock | 12.6879 | 12.6879 | 12.6879 | 12.6879 | 2800.0 |
> showing 50 of 979,796 rows — these rows as CSV