PREVIEW / stock_5min / 2013-12-12
file: by_date/stock_5min/2013/2013-12-12.parquet size: 5.4 MB rows: 359,072 symbols: 3,533
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:05:00 | AAPL | Stock | 20.0332 | 20.0332 | 20.0332 | 20.0332 | 8400.0 |
| 2013-12-12 04:20:00 | AAPL | Stock | 20.0096 | 20.0096 | 20.0096 | 20.0096 | 2800.0 |
| 2013-12-12 04:30:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0157 | 20.0157 | 2800.0 |
| 2013-12-12 04:55:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0157 | 20.0157 | 2800.0 |
| 2013-12-12 05:30:00 | AAPL | Stock | 20.0157 | 20.0157 | 20.0111 | 20.0111 | 11956.0 |
| 2013-12-12 05:35:00 | AAPL | Stock | 20.0111 | 20.0111 | 20.0111 | 20.0111 | 2800.0 |
| 2013-12-12 05:40:00 | AAPL | Stock | 20.0118 | 20.0118 | 20.0096 | 20.0096 | 11200.0 |
| 2013-12-12 05:50:00 | AAPL | Stock | 20.0025 | 20.0025 | 20.0025 | 20.0025 | 2884.0 |
| 2013-12-12 05:55: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:20: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:55:00 | AAPL | Stock | 20.0057 | 20.0057 | 20.0057 | 20.0057 | 2800.0 |
| 2013-12-12 07:00:00 | AAPL | Stock | 20.0118 | 20.0286 | 20.0118 | 20.0286 | 14000.0 |
| 2013-12-12 07:05:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2013-12-12 07:10:00 | AAPL | Stock | 20.0364 | 20.0364 | 20.0357 | 20.0357 | 20860.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.0157 | 20.0107 | 20.0157 | 11536.0 |
| 2013-12-12 07:25:00 | AAPL | Stock | 20.0186 | 20.0357 | 20.0186 | 20.0357 | 8400.0 |
| 2013-12-12 07:30:00 | AAPL | Stock | 20.0493 | 20.0675 | 20.0432 | 20.0675 | 29932.0 |
| 2013-12-12 07:35:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 14000.0 |
| 2013-12-12 07:40:00 | AAPL | Stock | 20.0782 | 20.0843 | 20.0664 | 20.0843 | 109480.0 |
| 2013-12-12 07:45:00 | AAPL | Stock | 20.0932 | 20.1 | 20.0932 | 20.1 | 23800.0 |
| 2013-12-12 07:50:00 | AAPL | Stock | 20.1025 | 20.1236 | 20.1025 | 20.1196 | 104440.0 |
| 2013-12-12 07:55:00 | AAPL | Stock | 20.1143 | 20.1214 | 20.1143 | 20.1214 | 37800.0 |
| 2013-12-12 08:00:00 | AAPL | Stock | 20.1179 | 20.125 | 20.0321 | 20.1082 | 342860.0 |
| 2013-12-12 08:05:00 | AAPL | Stock | 20.1075 | 20.1214 | 20.1071 | 20.1161 | 100520.0 |
| 2013-12-12 08:10:00 | AAPL | Stock | 20.1161 | 20.1161 | 20.1071 | 20.1071 | 75600.0 |
| 2013-12-12 08:15:00 | AAPL | Stock | 20.1107 | 20.1196 | 20.1018 | 20.1179 | 61600.0 |
| 2013-12-12 08:20:00 | AAPL | Stock | 20.1071 | 20.1125 | 20.1071 | 20.1079 | 24640.0 |
| 2013-12-12 08:25:00 | AAPL | Stock | 20.1118 | 20.1154 | 20.1075 | 20.1107 | 57960.0 |
| 2013-12-12 08:30:00 | AAPL | Stock | 20.1096 | 20.1189 | 20.1079 | 20.1079 | 122360.0 |
| 2013-12-12 08:35:00 | AAPL | Stock | 20.1093 | 20.1143 | 20.1093 | 20.1143 | 16800.0 |
| 2013-12-12 08:40:00 | AAPL | Stock | 20.1182 | 20.1525 | 20.1182 | 20.1507 | 243236.0 |
| 2013-12-12 08:45:00 | AAPL | Stock | 20.15 | 20.1511 | 20.1289 | 20.1393 | 124600.0 |
| 2013-12-12 08:50:00 | AAPL | Stock | 20.1425 | 20.1429 | 20.1343 | 20.1357 | 83048.0 |
| 2013-12-12 08:55:00 | AAPL | Stock | 20.1368 | 20.1375 | 20.1357 | 20.1361 | 22400.0 |
| 2013-12-12 09:00:00 | AAPL | Stock | 20.1375 | 20.1393 | 20.1311 | 20.1311 | 22176.0 |
| 2013-12-12 09:05:00 | AAPL | Stock | 20.1304 | 20.1304 | 20.1268 | 20.1268 | 19600.0 |
| 2013-12-12 09:10:00 | AAPL | Stock | 20.1336 | 20.1336 | 20.1304 | 20.1304 | 5600.0 |
| 2013-12-12 09:15:00 | AAPL | Stock | 20.1304 | 20.1421 | 20.1254 | 20.1418 | 142800.0 |
| 2013-12-12 09:20:00 | AAPL | Stock | 20.1264 | 20.1275 | 20.1243 | 20.125 | 24276.0 |
| 2013-12-12 09:25:00 | AAPL | Stock | 20.1264 | 20.1264 | 20.0729 | 20.0789 | 354256.0 |
| 2013-12-12 09:30:00 | AAPL | Stock | 20.0765 | 20.1521 | 20.0718 | 20.0862 | 11934636.0 |
| 2013-12-12 09:35:00 | AAPL | Stock | 20.0875 | 20.1489 | 20.0859 | 20.1379 | 6844684.0 |
| 2013-12-12 09:40:00 | AAPL | Stock | 20.1361 | 20.1429 | 20.1035 | 20.1179 | 4097016.0 |
| 2013-12-12 09:45:00 | AAPL | Stock | 20.1179 | 20.1213 | 20.0536 | 20.0825 | 6216056.0 |
| 2013-12-12 09:50:00 | AAPL | Stock | 20.0782 | 20.0825 | 20.0269 | 20.0582 | 5552848.0 |
| 2013-12-12 09:55:00 | AAPL | Stock | 20.0529 | 20.085 | 20.0525 | 20.0775 | 3922184.0 |
> showing 50 of 359,072 rows — these rows as CSV