PREVIEW / stock_1min / 2012-12-04
file: by_date/stock_1min/2012/2012-12-04.parquet size: 12.7 MB rows: 946,015 symbols: 2,796
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-12-04 04:53:00 | AAPL | Stock | 20.8975 | 20.8975 | 20.8975 | 20.8975 | 2800.0 |
| 2012-12-04 05:25:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 2800.0 |
| 2012-12-04 05:29:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 2800.0 |
| 2012-12-04 05:35:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 6244.0 |
| 2012-12-04 06:13:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 7532.0 |
| 2012-12-04 06:15:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 5600.0 |
| 2012-12-04 06:20:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 2800.0 |
| 2012-12-04 06:22:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 2800.0 |
| 2012-12-04 06:23:00 | AAPL | Stock | 20.9336 | 20.9336 | 20.9336 | 20.9336 | 2800.0 |
| 2012-12-04 06:24:00 | AAPL | Stock | 20.9336 | 20.9336 | 20.9336 | 20.9336 | 2800.0 |
| 2012-12-04 06:47:00 | AAPL | Stock | 20.9296 | 20.9296 | 20.9286 | 20.9286 | 8400.0 |
| 2012-12-04 07:02:00 | AAPL | Stock | 20.9214 | 20.9214 | 20.9214 | 20.9214 | 5600.0 |
| 2012-12-04 07:03:00 | AAPL | Stock | 20.9114 | 20.9114 | 20.9054 | 20.9054 | 18200.0 |
| 2012-12-04 07:04:00 | AAPL | Stock | 20.9054 | 20.9057 | 20.9018 | 20.9018 | 19600.0 |
| 2012-12-04 07:06:00 | AAPL | Stock | 20.905 | 20.9107 | 20.905 | 20.9107 | 5600.0 |
| 2012-12-04 07:09:00 | AAPL | Stock | 20.9243 | 20.9243 | 20.9243 | 20.9243 | 5600.0 |
| 2012-12-04 07:10:00 | AAPL | Stock | 20.9243 | 20.925 | 20.9143 | 20.9143 | 22400.0 |
| 2012-12-04 07:11:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 5600.0 |
| 2012-12-04 07:15:00 | AAPL | Stock | 20.9075 | 20.9075 | 20.9018 | 20.9018 | 22120.0 |
| 2012-12-04 07:17:00 | AAPL | Stock | 20.8975 | 20.8975 | 20.8929 | 20.8929 | 35280.0 |
| 2012-12-04 07:20:00 | AAPL | Stock | 20.8939 | 20.8939 | 20.8929 | 20.8929 | 11200.0 |
| 2012-12-04 07:21:00 | AAPL | Stock | 20.8925 | 20.8932 | 20.8925 | 20.8932 | 21224.0 |
| 2012-12-04 07:26:00 | AAPL | Stock | 20.8911 | 20.8911 | 20.8857 | 20.8857 | 8400.0 |
| 2012-12-04 07:27:00 | AAPL | Stock | 20.8857 | 20.8857 | 20.8857 | 20.8857 | 2800.0 |
| 2012-12-04 07:32:00 | AAPL | Stock | 20.8857 | 20.8857 | 20.8857 | 20.8857 | 5600.0 |
| 2012-12-04 07:33:00 | AAPL | Stock | 20.8857 | 20.8857 | 20.8857 | 20.8857 | 2800.0 |
| 2012-12-04 07:37:00 | AAPL | Stock | 20.8925 | 20.8929 | 20.8925 | 20.8929 | 28000.0 |
| 2012-12-04 07:39:00 | AAPL | Stock | 20.9111 | 20.9143 | 20.9075 | 20.9143 | 11200.0 |
| 2012-12-04 07:42:00 | AAPL | Stock | 20.9007 | 20.9007 | 20.9 | 20.9 | 6160.0 |
| 2012-12-04 07:45:00 | AAPL | Stock | 20.9104 | 20.9104 | 20.9104 | 20.9104 | 5600.0 |
| 2012-12-04 07:48:00 | AAPL | Stock | 20.9107 | 20.9171 | 20.9107 | 20.9171 | 13720.0 |
| 2012-12-04 07:50:00 | AAPL | Stock | 20.9214 | 20.9229 | 20.9214 | 20.9229 | 8400.0 |
| 2012-12-04 07:52:00 | AAPL | Stock | 20.9179 | 20.9236 | 20.9121 | 20.9121 | 21840.0 |
| 2012-12-04 07:53:00 | AAPL | Stock | 20.9118 | 20.9118 | 20.9107 | 20.9107 | 32480.0 |
| 2012-12-04 07:56:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 2800.0 |
| 2012-12-04 07:57:00 | AAPL | Stock | 20.9032 | 20.9032 | 20.9032 | 20.9032 | 2800.0 |
| 2012-12-04 07:58:00 | AAPL | Stock | 20.9 | 20.9 | 20.9 | 20.9 | 5040.0 |
| 2012-12-04 08:00:00 | AAPL | Stock | 20.9079 | 20.9111 | 20.8929 | 20.9107 | 101584.0 |
| 2012-12-04 08:01:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9021 | 20.9071 | 20160.0 |
| 2012-12-04 08:02:00 | AAPL | Stock | 20.9071 | 20.9071 | 20.9071 | 20.9071 | 4200.0 |
| 2012-12-04 08:03:00 | AAPL | Stock | 20.9089 | 20.9125 | 20.9089 | 20.9125 | 8400.0 |
| 2012-12-04 08:04:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.9071 | 20.9071 | 14000.0 |
| 2012-12-04 08:06:00 | AAPL | Stock | 20.9036 | 20.9071 | 20.9036 | 20.9071 | 6804.0 |
| 2012-12-04 08:08:00 | AAPL | Stock | 20.9068 | 20.9071 | 20.8929 | 20.8929 | 60060.0 |
| 2012-12-04 08:10:00 | AAPL | Stock | 20.9014 | 20.9018 | 20.9014 | 20.9018 | 24024.0 |
| 2012-12-04 08:12:00 | AAPL | Stock | 20.9036 | 20.9036 | 20.8964 | 20.8964 | 5600.0 |
| 2012-12-04 08:13:00 | AAPL | Stock | 20.8993 | 20.8993 | 20.8993 | 20.8993 | 2800.0 |
| 2012-12-04 08:14:00 | AAPL | Stock | 20.8968 | 20.8968 | 20.8929 | 20.8929 | 47740.0 |
| 2012-12-04 08:15:00 | AAPL | Stock | 20.8961 | 20.8971 | 20.8871 | 20.8961 | 19600.0 |
| 2012-12-04 08:16:00 | AAPL | Stock | 20.8954 | 20.9161 | 20.8954 | 20.9161 | 150052.0 |
> showing 50 of 946,015 rows — these rows as CSV