PREVIEW / stock_1min / 2012-10-25
file: by_date/stock_1min/2012/2012-10-25.parquet size: 12.3 MB rows: 911,041 symbols: 2,831
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-10-25 04:00:00 | AAPL | Stock | 22.0271 | 22.0271 | 22.0271 | 22.0271 | 2800.0 |
| 2012-10-25 04:02:00 | AAPL | Stock | 22.0929 | 22.1071 | 22.0929 | 22.1071 | 36400.0 |
| 2012-10-25 04:04:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 14000.0 |
| 2012-10-25 04:05:00 | AAPL | Stock | 22.125 | 22.125 | 22.125 | 22.125 | 11200.0 |
| 2012-10-25 04:06:00 | AAPL | Stock | 22.125 | 22.125 | 22.1214 | 22.1214 | 13720.0 |
| 2012-10-25 04:10:00 | AAPL | Stock | 22.1214 | 22.1214 | 22.1214 | 22.1214 | 13776.0 |
| 2012-10-25 04:16:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0982 | 22.0982 | 2800.0 |
| 2012-10-25 04:18:00 | AAPL | Stock | 22.1143 | 22.1143 | 22.1143 | 22.1143 | 8400.0 |
| 2012-10-25 04:23:00 | AAPL | Stock | 22.125 | 22.125 | 22.125 | 22.125 | 2800.0 |
| 2012-10-25 04:30:00 | AAPL | Stock | 22.1246 | 22.1246 | 22.1246 | 22.1246 | 11200.0 |
| 2012-10-25 04:33:00 | AAPL | Stock | 22.1 | 22.1 | 22.1 | 22.1 | 5600.0 |
| 2012-10-25 04:45:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 3416.0 |
| 2012-10-25 05:35:00 | AAPL | Stock | 22.1032 | 22.1032 | 22.1032 | 22.1032 | 26516.0 |
| 2012-10-25 05:44:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1071 | 22.1071 | 14000.0 |
| 2012-10-25 05:45:00 | AAPL | Stock | 22.1161 | 22.1161 | 22.1161 | 22.1161 | 2800.0 |
| 2012-10-25 05:51:00 | AAPL | Stock | 22.1068 | 22.1068 | 22.1068 | 22.1068 | 14000.0 |
| 2012-10-25 05:53:00 | AAPL | Stock | 22.1068 | 22.1068 | 22.0964 | 22.0964 | 51800.0 |
| 2012-10-25 06:35:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 2800.0 |
| 2012-10-25 06:36:00 | AAPL | Stock | 22.1061 | 22.1061 | 22.1061 | 22.1061 | 2968.0 |
| 2012-10-25 07:00:00 | AAPL | Stock | 22.0932 | 22.1 | 22.0932 | 22.1 | 8400.0 |
| 2012-10-25 07:01:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0964 | 22.0964 | 28000.0 |
| 2012-10-25 07:02:00 | AAPL | Stock | 22.0964 | 22.105 | 22.09 | 22.1011 | 64960.0 |
| 2012-10-25 07:04:00 | AAPL | Stock | 22.1 | 22.1 | 22.0918 | 22.0918 | 14000.0 |
| 2012-10-25 07:05:00 | AAPL | Stock | 22.0918 | 22.0918 | 22.0918 | 22.0918 | 8400.0 |
| 2012-10-25 07:06:00 | AAPL | Stock | 22.0929 | 22.1 | 22.0929 | 22.1 | 32144.0 |
| 2012-10-25 07:07:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.09 | 22.0929 | 54180.0 |
| 2012-10-25 07:10:00 | AAPL | Stock | 22.0957 | 22.0982 | 22.0957 | 22.0982 | 21840.0 |
| 2012-10-25 07:11:00 | AAPL | Stock | 22.1043 | 22.1043 | 22.1043 | 22.1043 | 2800.0 |
| 2012-10-25 07:13:00 | AAPL | Stock | 22.0932 | 22.0932 | 22.0929 | 22.0929 | 14000.0 |
| 2012-10-25 07:17:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0964 | 22.0964 | 5600.0 |
| 2012-10-25 07:18:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0946 | 22.0982 | 16800.0 |
| 2012-10-25 07:19:00 | AAPL | Stock | 22.0946 | 22.0946 | 22.09 | 22.09 | 42000.0 |
| 2012-10-25 07:20:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0982 | 22.0982 | 14000.0 |
| 2012-10-25 07:23:00 | AAPL | Stock | 22.09 | 22.09 | 22.09 | 22.09 | 2800.0 |
| 2012-10-25 07:25:00 | AAPL | Stock | 22.09 | 22.09 | 22.09 | 22.09 | 5600.0 |
| 2012-10-25 07:26:00 | AAPL | Stock | 22.1007 | 22.1036 | 22.0893 | 22.0893 | 11900.0 |
| 2012-10-25 07:28:00 | AAPL | Stock | 22.1071 | 22.1161 | 22.1071 | 22.1161 | 11200.0 |
| 2012-10-25 07:30:00 | AAPL | Stock | 22.1329 | 22.1336 | 22.1329 | 22.1336 | 20720.0 |
| 2012-10-25 07:31:00 | AAPL | Stock | 22.1339 | 22.1439 | 22.1339 | 22.1439 | 13300.0 |
| 2012-10-25 07:32:00 | AAPL | Stock | 22.1589 | 22.1604 | 22.1589 | 22.1604 | 5600.0 |
| 2012-10-25 07:33:00 | AAPL | Stock | 22.1596 | 22.1596 | 22.1518 | 22.1518 | 8400.0 |
| 2012-10-25 07:36:00 | AAPL | Stock | 22.1564 | 22.1607 | 22.1564 | 22.1607 | 17360.0 |
| 2012-10-25 07:37:00 | AAPL | Stock | 22.1607 | 22.1607 | 22.1607 | 22.1607 | 2800.0 |
| 2012-10-25 07:40:00 | AAPL | Stock | 22.1607 | 22.1607 | 22.1607 | 22.1607 | 2800.0 |
| 2012-10-25 07:45:00 | AAPL | Stock | 22.1643 | 22.1721 | 22.1643 | 22.1714 | 42000.0 |
| 2012-10-25 07:46:00 | AAPL | Stock | 22.1725 | 22.1732 | 22.1725 | 22.1732 | 11200.0 |
| 2012-10-25 07:47:00 | AAPL | Stock | 22.1729 | 22.175 | 22.1729 | 22.175 | 11312.0 |
| 2012-10-25 07:49:00 | AAPL | Stock | 22.1696 | 22.17 | 22.1696 | 22.17 | 5600.0 |
| 2012-10-25 07:50:00 | AAPL | Stock | 22.1714 | 22.1714 | 22.1607 | 22.1607 | 25200.0 |
| 2012-10-25 07:51:00 | AAPL | Stock | 22.1571 | 22.1575 | 22.1571 | 22.1575 | 12040.0 |
> showing 50 of 911,041 rows — these rows as CSV