PREVIEW / stock_1min / 2013-12-12
file: by_date/stock_1min/2013/2013-12-12.parquet size: 14.2 MB rows: 1,049,231 symbols: 2,859
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-12 04:00:00 | AAPL | Stock | 20.0357 | 20.0489 | 20.0357 | 20.0489 | 16800.0 |
| 2013-12-12 04:06:00 | AAPL | Stock | 20.0332 | 20.0332 | 20.0332 | 20.0332 | 8400.0 |
| 2013-12-12 04:22:00 | AAPL | Stock | 20.0096 | 20.0096 | 20.0096 | 20.0096 | 2800.0 |
| 2013-12-12 04:34:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0157 | 20.0157 | 2800.0 |
| 2013-12-12 04:57:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0157 | 20.0157 | 2800.0 |
| 2013-12-12 05:33:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0111 | 20.0111 | 11956.0 |
| 2013-12-12 05:39:00 | AAPL | Stock | 20.0111 | 20.0111 | 20.0111 | 20.0111 | 2800.0 |
| 2013-12-12 05:44:00 | AAPL | Stock | 20.0118 | 20.0118 | 20.0096 | 20.0096 | 11200.0 |
| 2013-12-12 05:52:00 | AAPL | Stock | 20.0025 | 20.0025 | 20.0025 | 20.0025 | 2884.0 |
| 2013-12-12 05:57:00 | AAPL | Stock | 19.9929 | 19.9929 | 19.9929 | 19.9929 | 2800.0 |
| 2013-12-12 06:10:00 | AAPL | Stock | 20.0011 | 20.0025 | 20.0011 | 20.0025 | 12488.0 |
| 2013-12-12 06:21:00 | AAPL | Stock | 20.0111 | 20.0111 | 20.0111 | 20.0111 | 2800.0 |
| 2013-12-12 06:25:00 | AAPL | Stock | 20.0114 | 20.0114 | 20.0114 | 20.0114 | 2800.0 |
| 2013-12-12 06:58:00 | AAPL | Stock | 20.0057 | 20.0057 | 20.0057 | 20.0057 | 2800.0 |
| 2013-12-12 07:01:00 | AAPL | Stock | 20.0118 | 20.0182 | 20.0118 | 20.0182 | 8400.0 |
| 2013-12-12 07:04:00 | AAPL | Stock | 20.0275 | 20.0286 | 20.0275 | 20.0286 | 5600.0 |
| 2013-12-12 07:07:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2013-12-12 07:11:00 | AAPL | Stock | 20.0364 | 20.0364 | 20.0357 | 20.0357 | 18060.0 |
| 2013-12-12 07:13:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2013-12-12 07:15:00 | AAPL | Stock | 20.0361 | 20.0361 | 20.0321 | 20.0321 | 19600.0 |
| 2013-12-12 07:20:00 | AAPL | Stock | 20.0107 | 20.0114 | 20.0107 | 20.0114 | 5936.0 |
| 2013-12-12 07:24:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0157 | 20.0157 | 5600.0 |
| 2013-12-12 07:28:00 | AAPL | Stock | 20.0186 | 20.0357 | 20.0186 | 20.0357 | 8400.0 |
| 2013-12-12 07:30:00 | AAPL | Stock | 20.0493 | 20.0493 | 20.0432 | 20.0432 | 18732.0 |
| 2013-12-12 07:31:00 | AAPL | Stock | 20.0582 | 20.0654 | 20.0582 | 20.0654 | 8400.0 |
| 2013-12-12 07:32:00 | AAPL | Stock | 20.0675 | 20.0675 | 20.0675 | 20.0675 | 2800.0 |
| 2013-12-12 07:39:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 14000.0 |
| 2013-12-12 07:40:00 | AAPL | Stock | 20.0782 | 20.0786 | 20.0782 | 20.0786 | 14000.0 |
| 2013-12-12 07:41:00 | AAPL | Stock | 20.0664 | 20.0732 | 20.0664 | 20.0732 | 14840.0 |
| 2013-12-12 07:42:00 | AAPL | Stock | 20.0775 | 20.0786 | 20.0714 | 20.0786 | 17640.0 |
| 2013-12-12 07:43:00 | AAPL | Stock | 20.075 | 20.0754 | 20.075 | 20.0754 | 18200.0 |
| 2013-12-12 07:44:00 | AAPL | Stock | 20.0743 | 20.0843 | 20.0743 | 20.0843 | 44800.0 |
| 2013-12-12 07:46:00 | AAPL | Stock | 20.0932 | 20.0932 | 20.0932 | 20.0932 | 2800.0 |
| 2013-12-12 07:47:00 | AAPL | Stock | 20.0946 | 20.1 | 20.0946 | 20.1 | 21000.0 |
| 2013-12-12 07:50:00 | AAPL | Stock | 20.1025 | 20.1179 | 20.1025 | 20.1179 | 30800.0 |
| 2013-12-12 07:51:00 | AAPL | Stock | 20.1161 | 20.1182 | 20.1079 | 20.1143 | 25200.0 |
| 2013-12-12 07:52:00 | AAPL | Stock | 20.1211 | 20.1236 | 20.1132 | 20.1236 | 35000.0 |
| 2013-12-12 07:53:00 | AAPL | Stock | 20.1161 | 20.1196 | 20.1161 | 20.1196 | 13440.0 |
| 2013-12-12 07:57:00 | AAPL | Stock | 20.1143 | 20.1143 | 20.1143 | 20.1143 | 2800.0 |
| 2013-12-12 07:58:00 | AAPL | Stock | 20.1161 | 20.1161 | 20.1161 | 20.1161 | 5600.0 |
| 2013-12-12 07:59:00 | AAPL | Stock | 20.1179 | 20.1214 | 20.1179 | 20.1214 | 29400.0 |
| 2013-12-12 08:00:00 | AAPL | Stock | 20.1179 | 20.125 | 20.0321 | 20.1107 | 108668.0 |
| 2013-12-12 08:01:00 | AAPL | Stock | 20.0357 | 20.1071 | 20.0357 | 20.1018 | 84420.0 |
| 2013-12-12 08:02:00 | AAPL | Stock | 20.0486 | 20.0989 | 20.0486 | 20.0989 | 10332.0 |
| 2013-12-12 08:03:00 | AAPL | Stock | 20.0975 | 20.0975 | 20.0804 | 20.0893 | 86240.0 |
| 2013-12-12 08:04:00 | AAPL | Stock | 20.0893 | 20.1082 | 20.0893 | 20.1082 | 53200.0 |
| 2013-12-12 08:05:00 | AAPL | Stock | 20.1075 | 20.1143 | 20.1071 | 20.1111 | 55720.0 |
| 2013-12-12 08:06:00 | AAPL | Stock | 20.1146 | 20.1146 | 20.1146 | 20.1146 | 2800.0 |
| 2013-12-12 08:07:00 | AAPL | Stock | 20.1146 | 20.1214 | 20.1146 | 20.1207 | 28000.0 |
| 2013-12-12 08:09:00 | AAPL | Stock | 20.1161 | 20.1161 | 20.1161 | 20.1161 | 14000.0 |
> showing 50 of 1,049,231 rows — these rows as CSV