PREVIEW / stock_1min / 2014-03-12
file: by_date/stock_1min/2014/2014-03-12.parquet size: 14.4 MB rows: 1,051,180 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-12 04:05:00 | AAPL | Stock | 19.1446 | 19.1446 | 19.1446 | 19.1446 | 2800.0 |
| 2014-03-12 06:06:00 | AAPL | Stock | 19.1082 | 19.1082 | 19.1082 | 19.1082 | 2800.0 |
| 2014-03-12 06:07:00 | AAPL | Stock | 19.1079 | 19.1079 | 19.1079 | 19.1079 | 2800.0 |
| 2014-03-12 06:16:00 | AAPL | Stock | 19.1043 | 19.1043 | 19.1043 | 19.1043 | 2800.0 |
| 2014-03-12 06:39:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0829 | 19.0829 | 5600.0 |
| 2014-03-12 06:41:00 | AAPL | Stock | 19.0754 | 19.0754 | 19.0754 | 19.0754 | 2800.0 |
| 2014-03-12 06:46:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2014-03-12 06:49:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 8400.0 |
| 2014-03-12 06:50:00 | AAPL | Stock | 19.0614 | 19.0614 | 19.0614 | 19.0614 | 2800.0 |
| 2014-03-12 07:01:00 | AAPL | Stock | 19.0893 | 19.09 | 19.0893 | 19.09 | 11200.0 |
| 2014-03-12 07:13:00 | AAPL | Stock | 19.105 | 19.105 | 19.105 | 19.105 | 2800.0 |
| 2014-03-12 07:14:00 | AAPL | Stock | 19.1054 | 19.1196 | 19.1054 | 19.1196 | 8400.0 |
| 2014-03-12 07:16:00 | AAPL | Stock | 19.1293 | 19.1293 | 19.1293 | 19.1293 | 2800.0 |
| 2014-03-12 07:17:00 | AAPL | Stock | 19.1286 | 19.1286 | 19.1139 | 19.1139 | 44800.0 |
| 2014-03-12 07:20:00 | AAPL | Stock | 19.1143 | 19.1143 | 19.1143 | 19.1143 | 2800.0 |
| 2014-03-12 07:32:00 | AAPL | Stock | 19.1179 | 19.1179 | 19.1179 | 19.1179 | 2800.0 |
| 2014-03-12 07:45:00 | AAPL | Stock | 19.12 | 19.12 | 19.1146 | 19.1179 | 61600.0 |
| 2014-03-12 07:51:00 | AAPL | Stock | 19.1086 | 19.1086 | 19.1086 | 19.1086 | 5600.0 |
| 2014-03-12 07:57:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 14000.0 |
| 2014-03-12 07:59:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2014-03-12 08:00:00 | AAPL | Stock | 19.0896 | 19.0896 | 19.0896 | 19.0896 | 2884.0 |
| 2014-03-12 08:01:00 | AAPL | Stock | 19.125 | 19.125 | 19.09 | 19.09 | 14000.0 |
| 2014-03-12 08:05:00 | AAPL | Stock | 19.0968 | 19.0968 | 19.0964 | 19.0964 | 5600.0 |
| 2014-03-12 08:09:00 | AAPL | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 2800.0 |
| 2014-03-12 08:17:00 | AAPL | Stock | 19.1018 | 19.1018 | 19.1 | 19.1 | 11200.0 |
| 2014-03-12 08:20:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 5600.0 |
| 2014-03-12 08:22:00 | AAPL | Stock | 19.1036 | 19.1036 | 19.0982 | 19.0982 | 21700.0 |
| 2014-03-12 08:23:00 | AAPL | Stock | 19.0982 | 19.0982 | 19.0971 | 19.0971 | 11200.0 |
| 2014-03-12 08:25:00 | AAPL | Stock | 19.1 | 19.1 | 19.0893 | 19.0975 | 22960.0 |
| 2014-03-12 08:26:00 | AAPL | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 5600.0 |
| 2014-03-12 08:27:00 | AAPL | Stock | 19.1018 | 19.1036 | 19.1018 | 19.1036 | 14000.0 |
| 2014-03-12 08:28:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 4200.0 |
| 2014-03-12 08:30:00 | AAPL | Stock | 19.1057 | 19.1057 | 19.1014 | 19.1014 | 5600.0 |
| 2014-03-12 08:31:00 | AAPL | Stock | 19.1107 | 19.1107 | 19.1011 | 19.1011 | 14000.0 |
| 2014-03-12 08:32:00 | AAPL | Stock | 19.1054 | 19.1054 | 19.1054 | 19.1054 | 2800.0 |
| 2014-03-12 08:34:00 | AAPL | Stock | 19.1 | 19.1 | 19.0964 | 19.0964 | 11200.0 |
| 2014-03-12 08:35:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0964 | 19.0964 | 9688.0 |
| 2014-03-12 08:38:00 | AAPL | Stock | 19.0975 | 19.0975 | 19.0936 | 19.0936 | 11536.0 |
| 2014-03-12 08:39:00 | AAPL | Stock | 19.0964 | 19.1014 | 19.0896 | 19.0896 | 14000.0 |
| 2014-03-12 08:47:00 | AAPL | Stock | 19.0829 | 19.0829 | 19.0821 | 19.0821 | 16800.0 |
| 2014-03-12 08:48:00 | AAPL | Stock | 19.0725 | 19.0729 | 19.0725 | 19.0729 | 6720.0 |
| 2014-03-12 08:49:00 | AAPL | Stock | 19.0736 | 19.0736 | 19.0721 | 19.0721 | 18312.0 |
| 2014-03-12 08:50:00 | AAPL | Stock | 19.0679 | 19.0679 | 19.0679 | 19.0679 | 2800.0 |
| 2014-03-12 08:51:00 | AAPL | Stock | 19.0711 | 19.0714 | 19.0646 | 19.0646 | 25396.0 |
| 2014-03-12 08:53:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 14056.0 |
| 2014-03-12 08:55:00 | AAPL | Stock | 19.0661 | 19.0696 | 19.0661 | 19.0696 | 8400.0 |
| 2014-03-12 08:56:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0661 | 19.0661 | 53592.0 |
| 2014-03-12 08:57:00 | AAPL | Stock | 19.0675 | 19.0675 | 19.0675 | 19.0675 | 2800.0 |
| 2014-03-12 08:58:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0707 | 19.0711 | 11200.0 |
| 2014-03-12 08:59:00 | AAPL | Stock | 19.0657 | 19.0657 | 19.0646 | 19.0646 | 5600.0 |
> showing 50 of 1,051,180 rows — these rows as CSV