PREVIEW / stock_1min / 2011-01-10
file: by_date/stock_1min/2011/2011-01-10.parquet size: 13.3 MB rows: 998,876 symbols: 2,856
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-01-10 04:06:00 | AAPL | Stock | 12.0786 | 12.0786 | 12.0786 | 12.0786 | 14000.0 |
| 2011-01-10 04:21:00 | AAPL | Stock | 12.0879 | 12.0889 | 12.0879 | 12.0889 | 5600.0 |
| 2011-01-10 04:57:00 | AAPL | Stock | 12.1093 | 12.1093 | 12.1093 | 12.1093 | 2800.0 |
| 2011-01-10 05:15:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 05:35:00 | AAPL | Stock | 12.1179 | 12.1179 | 12.1179 | 12.1179 | 2800.0 |
| 2011-01-10 05:42:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1071 | 12.1071 | 14000.0 |
| 2011-01-10 05:47:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 05:55:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 16800.0 |
| 2011-01-10 05:59:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 11200.0 |
| 2011-01-10 06:03:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1157 | 12.1157 | 2800.0 |
| 2011-01-10 06:06:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 8400.0 |
| 2011-01-10 06:08:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 06:10:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1157 | 12.1157 | 5600.0 |
| 2011-01-10 06:12:00 | AAPL | Stock | 12.1075 | 12.1157 | 12.1075 | 12.1157 | 6916.0 |
| 2011-01-10 06:21:00 | AAPL | Stock | 12.12 | 12.12 | 12.12 | 12.12 | 11200.0 |
| 2011-01-10 06:22:00 | AAPL | Stock | 12.1357 | 12.1357 | 12.1357 | 12.1357 | 2800.0 |
| 2011-01-10 06:32:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 2800.0 |
| 2011-01-10 06:33:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 14000.0 |
| 2011-01-10 06:38:00 | AAPL | Stock | 12.125 | 12.125 | 12.125 | 12.125 | 2800.0 |
| 2011-01-10 06:39:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 13888.0 |
| 2011-01-10 06:42:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 2800.0 |
| 2011-01-10 06:54:00 | AAPL | Stock | 12.1161 | 12.1161 | 12.1161 | 12.1161 | 14000.0 |
| 2011-01-10 06:56:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 15400.0 |
| 2011-01-10 06:57:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 06:58:00 | AAPL | Stock | 12.1046 | 12.1071 | 12.1046 | 12.1071 | 5600.0 |
| 2011-01-10 06:59:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 07:00:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 07:01:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 07:02:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 8400.0 |
| 2011-01-10 07:03:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 07:04:00 | AAPL | Stock | 12.1 | 12.1071 | 12.1 | 12.1071 | 5600.0 |
| 2011-01-10 07:05:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 07:09:00 | AAPL | Stock | 12.1 | 12.1 | 12.0986 | 12.0986 | 5600.0 |
| 2011-01-10 07:10:00 | AAPL | Stock | 12.1 | 12.1 | 12.1 | 12.1 | 2800.0 |
| 2011-01-10 07:11:00 | AAPL | Stock | 12.1068 | 12.1071 | 12.1068 | 12.1071 | 5600.0 |
| 2011-01-10 07:12:00 | AAPL | Stock | 12.1061 | 12.1061 | 12.1061 | 12.1061 | 2800.0 |
| 2011-01-10 07:18:00 | AAPL | Stock | 12.0843 | 12.0857 | 12.0843 | 12.0857 | 14000.0 |
| 2011-01-10 07:19:00 | AAPL | Stock | 12.0939 | 12.0939 | 12.0936 | 12.0939 | 36400.0 |
| 2011-01-10 07:20:00 | AAPL | Stock | 12.0893 | 12.0893 | 12.0893 | 12.0893 | 4200.0 |
| 2011-01-10 07:23:00 | AAPL | Stock | 12.0971 | 12.0971 | 12.0971 | 12.0971 | 2800.0 |
| 2011-01-10 07:24:00 | AAPL | Stock | 12.1018 | 12.1018 | 12.1018 | 12.1018 | 14000.0 |
| 2011-01-10 07:28:00 | AAPL | Stock | 12.0964 | 12.0964 | 12.0964 | 12.0964 | 4788.0 |
| 2011-01-10 07:29:00 | AAPL | Stock | 12.0954 | 12.1 | 12.0954 | 12.1 | 22176.0 |
| 2011-01-10 07:30:00 | AAPL | Stock | 12.0961 | 12.0964 | 12.0961 | 12.0964 | 11284.0 |
| 2011-01-10 07:31:00 | AAPL | Stock | 12.0896 | 12.0896 | 12.0896 | 12.0896 | 5600.0 |
| 2011-01-10 07:32:00 | AAPL | Stock | 12.0896 | 12.0896 | 12.0896 | 12.0896 | 14084.0 |
| 2011-01-10 07:35:00 | AAPL | Stock | 12.0929 | 12.0929 | 12.0929 | 12.0929 | 14000.0 |
| 2011-01-10 07:36:00 | AAPL | Stock | 12.1014 | 12.1032 | 12.1014 | 12.1029 | 48608.0 |
| 2011-01-10 07:39:00 | AAPL | Stock | 12.0986 | 12.0986 | 12.0986 | 12.0986 | 4200.0 |
| 2011-01-10 07:41:00 | AAPL | Stock | 12.0989 | 12.0989 | 12.0989 | 12.0989 | 2800.0 |
> showing 50 of 998,876 rows — these rows as CSV