PREVIEW / stock_1min / 2012-08-08
file: by_date/stock_1min/2012/2012-08-08.parquet size: 12.2 MB rows: 915,721 symbols: 2,811
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-08-08 04:36:00 | AAPL | Stock | 22.1179 | 22.1179 | 22.1179 | 22.1179 | 6132.0 |
| 2012-08-08 04:51:00 | AAPL | Stock | 22.0911 | 22.0911 | 22.0911 | 22.0911 | 2800.0 |
| 2012-08-08 04:53:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 2800.0 |
| 2012-08-08 05:32:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 7000.0 |
| 2012-08-08 05:35:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 5600.0 |
| 2012-08-08 05:38:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 8400.0 |
| 2012-08-08 05:41:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 5600.0 |
| 2012-08-08 05:42:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 5600.0 |
| 2012-08-08 05:45:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 5600.0 |
| 2012-08-08 06:33:00 | AAPL | Stock | 22.0786 | 22.0786 | 22.0786 | 22.0786 | 8400.0 |
| 2012-08-08 06:34:00 | AAPL | Stock | 22.0804 | 22.0804 | 22.0804 | 22.0804 | 2800.0 |
| 2012-08-08 06:44:00 | AAPL | Stock | 22.0857 | 22.0857 | 22.0857 | 22.0857 | 14000.0 |
| 2012-08-08 07:08:00 | AAPL | Stock | 22.0968 | 22.0968 | 22.0968 | 22.0968 | 5600.0 |
| 2012-08-08 07:09:00 | AAPL | Stock | 22.1064 | 22.1064 | 22.1064 | 22.1064 | 2800.0 |
| 2012-08-08 07:10:00 | AAPL | Stock | 22.1064 | 22.1143 | 22.1064 | 22.1143 | 16800.0 |
| 2012-08-08 07:11:00 | AAPL | Stock | 22.1007 | 22.1007 | 22.0993 | 22.0993 | 13832.0 |
| 2012-08-08 07:12:00 | AAPL | Stock | 22.1161 | 22.1175 | 22.1161 | 22.1175 | 17136.0 |
| 2012-08-08 07:16:00 | AAPL | Stock | 22.1111 | 22.1164 | 22.1111 | 22.1164 | 5600.0 |
| 2012-08-08 07:18:00 | AAPL | Stock | 22.125 | 22.125 | 22.125 | 22.125 | 8400.0 |
| 2012-08-08 07:19:00 | AAPL | Stock | 22.1357 | 22.1357 | 22.1286 | 22.1286 | 5600.0 |
| 2012-08-08 07:21:00 | AAPL | Stock | 22.1375 | 22.1375 | 22.1375 | 22.1375 | 5516.0 |
| 2012-08-08 07:22:00 | AAPL | Stock | 22.1504 | 22.1504 | 22.1361 | 22.1432 | 19600.0 |
| 2012-08-08 07:23:00 | AAPL | Stock | 22.1325 | 22.1325 | 22.1264 | 22.1264 | 11200.0 |
| 2012-08-08 07:24:00 | AAPL | Stock | 22.1286 | 22.1286 | 22.1286 | 22.1286 | 11200.0 |
| 2012-08-08 07:26:00 | AAPL | Stock | 22.125 | 22.125 | 22.1146 | 22.1146 | 14000.0 |
| 2012-08-08 07:31:00 | AAPL | Stock | 22.1139 | 22.1139 | 22.1057 | 22.1057 | 33320.0 |
| 2012-08-08 07:37:00 | AAPL | Stock | 22.1136 | 22.1136 | 22.1071 | 22.1071 | 22120.0 |
| 2012-08-08 07:39:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1071 | 22.1071 | 2800.0 |
| 2012-08-08 07:40:00 | AAPL | Stock | 22.0968 | 22.0968 | 22.0893 | 22.0893 | 8680.0 |
| 2012-08-08 07:42:00 | AAPL | Stock | 22.0879 | 22.0896 | 22.0879 | 22.0896 | 9716.0 |
| 2012-08-08 07:52:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0964 | 22.0964 | 2800.0 |
| 2012-08-08 07:53:00 | AAPL | Stock | 22.0911 | 22.0911 | 22.0911 | 22.0911 | 2800.0 |
| 2012-08-08 07:55:00 | AAPL | Stock | 22.1182 | 22.1214 | 22.1182 | 22.1214 | 25200.0 |
| 2012-08-08 07:58:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1071 | 22.1071 | 14000.0 |
| 2012-08-08 08:00:00 | AAPL | Stock | 22.1504 | 22.1504 | 22.1214 | 22.1214 | 16800.0 |
| 2012-08-08 08:01:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1064 | 22.1064 | 33600.0 |
| 2012-08-08 08:02:00 | AAPL | Stock | 22.1075 | 22.1075 | 22.1071 | 22.1071 | 41636.0 |
| 2012-08-08 08:03:00 | AAPL | Stock | 22.1093 | 22.1143 | 22.1071 | 22.1143 | 36260.0 |
| 2012-08-08 08:04:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1036 | 22.1036 | 72212.0 |
| 2012-08-08 08:06:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 5180.0 |
| 2012-08-08 08:07:00 | AAPL | Stock | 22.1018 | 22.1071 | 22.1018 | 22.1071 | 25200.0 |
| 2012-08-08 08:08:00 | AAPL | Stock | 22.1036 | 22.1036 | 22.0986 | 22.0986 | 5600.0 |
| 2012-08-08 08:09:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0964 | 22.0964 | 2800.0 |
| 2012-08-08 08:10:00 | AAPL | Stock | 22.0936 | 22.0936 | 22.0936 | 22.0936 | 8400.0 |
| 2012-08-08 08:11:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0929 | 22.0929 | 13244.0 |
| 2012-08-08 08:13:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 2800.0 |
| 2012-08-08 08:14:00 | AAPL | Stock | 22.0893 | 22.0893 | 22.0857 | 22.0857 | 64400.0 |
| 2012-08-08 08:16:00 | AAPL | Stock | 22.0832 | 22.095 | 22.0832 | 22.095 | 5600.0 |
| 2012-08-08 08:17:00 | AAPL | Stock | 22.0789 | 22.0804 | 22.0789 | 22.0804 | 6300.0 |
| 2012-08-08 08:18:00 | AAPL | Stock | 22.0893 | 22.0893 | 22.0893 | 22.0893 | 5292.0 |
> showing 50 of 915,721 rows — these rows as CSV