PREVIEW / stock_5min / 2013-03-28
file: by_date/stock_5min/2013/2013-03-28.parquet size: 5.0 MB rows: 336,648 symbols: 3,494
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-03-28 04:00:00 | AAPL | Stock | 16.0936 | 16.0936 | 16.0936 | 16.0936 | 2800.0 |
| 2013-03-28 07:00:00 | AAPL | Stock | 16.1564 | 16.1564 | 16.1564 | 16.1564 | 5012.0 |
| 2013-03-28 07:15:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 14224.0 |
| 2013-03-28 07:20:00 | AAPL | Stock | 16.1493 | 16.1493 | 16.1493 | 16.1493 | 2800.0 |
| 2013-03-28 07:35:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 5600.0 |
| 2013-03-28 07:45:00 | AAPL | Stock | 16.1682 | 16.1682 | 16.1682 | 16.1682 | 28000.0 |
| 2013-03-28 08:00:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.125 | 16.1696 | 75320.0 |
| 2013-03-28 08:05:00 | AAPL | Stock | 16.1696 | 16.1696 | 16.1607 | 16.1607 | 63840.0 |
| 2013-03-28 08:10:00 | AAPL | Stock | 16.1611 | 16.1611 | 16.1607 | 16.1607 | 13356.0 |
| 2013-03-28 08:15:00 | AAPL | Stock | 16.1611 | 16.1611 | 16.1611 | 16.1611 | 11200.0 |
| 2013-03-28 08:20:00 | AAPL | Stock | 16.1664 | 16.1664 | 16.1643 | 16.1643 | 8400.0 |
| 2013-03-28 08:25:00 | AAPL | Stock | 16.1636 | 16.1636 | 16.1554 | 16.1554 | 19320.0 |
| 2013-03-28 08:30:00 | AAPL | Stock | 16.155 | 16.155 | 16.1286 | 16.1321 | 162120.0 |
| 2013-03-28 08:35:00 | AAPL | Stock | 16.1339 | 16.1343 | 16.1332 | 16.1336 | 30800.0 |
| 2013-03-28 08:40:00 | AAPL | Stock | 16.125 | 16.1432 | 16.125 | 16.1429 | 103852.0 |
| 2013-03-28 08:45:00 | AAPL | Stock | 16.1375 | 16.1429 | 16.1339 | 16.1339 | 63504.0 |
| 2013-03-28 08:50:00 | AAPL | Stock | 16.1282 | 16.1339 | 16.1129 | 16.1129 | 75880.0 |
| 2013-03-28 08:55:00 | AAPL | Stock | 16.1107 | 16.1107 | 16.0929 | 16.1018 | 149100.0 |
| 2013-03-28 09:00:00 | AAPL | Stock | 16.1061 | 16.1071 | 16.0964 | 16.1071 | 227976.0 |
| 2013-03-28 09:05:00 | AAPL | Stock | 16.1021 | 16.1071 | 16.1 | 16.1071 | 47600.0 |
| 2013-03-28 09:10:00 | AAPL | Stock | 16.1004 | 16.1071 | 16.0911 | 16.1071 | 203700.0 |
| 2013-03-28 09:15:00 | AAPL | Stock | 16.0979 | 16.1071 | 16.0957 | 16.1071 | 119420.0 |
| 2013-03-28 09:20:00 | AAPL | Stock | 16.0996 | 16.0996 | 16.0896 | 16.0896 | 94248.0 |
| 2013-03-28 09:25:00 | AAPL | Stock | 16.0929 | 16.0929 | 16.0564 | 16.0643 | 827904.0 |
| 2013-03-28 09:30:00 | AAPL | Stock | 16.0711 | 16.1 | 16.0032 | 16.0282 | 17033436.0 |
| 2013-03-28 09:35:00 | AAPL | Stock | 16.0275 | 16.0443 | 16.0125 | 16.035 | 8273888.0 |
| 2013-03-28 09:40:00 | AAPL | Stock | 16.0329 | 16.0904 | 16.0257 | 16.0746 | 9751504.0 |
| 2013-03-28 09:45:00 | AAPL | Stock | 16.0771 | 16.1364 | 16.077 | 16.1168 | 12869640.0 |
| 2013-03-28 09:50:00 | AAPL | Stock | 16.115 | 16.1246 | 16.0875 | 16.0982 | 7268660.0 |
| 2013-03-28 09:55:00 | AAPL | Stock | 16.0989 | 16.0989 | 16.0571 | 16.0714 | 7304192.0 |
| 2013-03-28 10:00:00 | AAPL | Stock | 16.0714 | 16.0929 | 16.0629 | 16.0843 | 4156096.0 |
| 2013-03-28 10:05:00 | AAPL | Stock | 16.0839 | 16.0879 | 16.0339 | 16.0393 | 6493172.0 |
| 2013-03-28 10:10:00 | AAPL | Stock | 16.0407 | 16.0507 | 16.0268 | 16.0454 | 5384988.0 |
| 2013-03-28 10:15:00 | AAPL | Stock | 16.0482 | 16.0518 | 16.0196 | 16.0321 | 4757900.0 |
| 2013-03-28 10:20:00 | AAPL | Stock | 16.0307 | 16.0625 | 16.0282 | 16.0407 | 4604824.0 |
| 2013-03-28 10:25:00 | AAPL | Stock | 16.0423 | 16.0443 | 16.0143 | 16.0209 | 3908520.0 |
| 2013-03-28 10:30:00 | AAPL | Stock | 16.0236 | 16.0429 | 16.0196 | 16.0264 | 4846632.0 |
| 2013-03-28 10:35:00 | AAPL | Stock | 16.0257 | 16.035 | 16.0179 | 16.0316 | 3324160.0 |
| 2013-03-28 10:40:00 | AAPL | Stock | 16.0298 | 16.0489 | 16.0246 | 16.0414 | 4966584.0 |
| 2013-03-28 10:45:00 | AAPL | Stock | 16.04 | 16.045 | 16.0054 | 16.0068 | 4689916.0 |
| 2013-03-28 10:50:00 | AAPL | Stock | 16.0075 | 16.015 | 15.9871 | 15.9971 | 6983676.0 |
| 2013-03-28 10:55:00 | AAPL | Stock | 15.9986 | 16.025 | 15.9936 | 16.0168 | 4940488.0 |
| 2013-03-28 11:00:00 | AAPL | Stock | 16.02 | 16.024 | 16.0021 | 16.0089 | 2581824.0 |
| 2013-03-28 11:05:00 | AAPL | Stock | 16.0096 | 16.0145 | 15.9925 | 15.995 | 2522436.0 |
| 2013-03-28 11:10:00 | AAPL | Stock | 15.9943 | 16.0136 | 15.9893 | 15.9993 | 2329040.0 |
| 2013-03-28 11:15:00 | AAPL | Stock | 15.9993 | 16.0039 | 15.9682 | 15.9696 | 4802140.0 |
| 2013-03-28 11:20:00 | AAPL | Stock | 15.9718 | 15.9768 | 15.9611 | 15.9736 | 4748688.0 |
| 2013-03-28 11:25:00 | AAPL | Stock | 15.9703 | 15.9725 | 15.9375 | 15.945 | 6327076.0 |
| 2013-03-28 11:30:00 | AAPL | Stock | 15.9439 | 15.9493 | 15.8871 | 15.8959 | 13559952.0 |
| 2013-03-28 11:35:00 | AAPL | Stock | 15.8964 | 15.9207 | 15.8925 | 15.8929 | 6524308.0 |
> showing 50 of 336,648 rows — these rows as CSV