PREVIEW / stock_5min / 2012-02-09
file: by_date/stock_5min/2012/2012-02-09.parquet size: 4.9 MB rows: 328,009 symbols: 3,546
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-02-09 04:00:00 | AAPL | Stock | 17.0754 | 17.0754 | 17.0754 | 17.0754 | 11200.0 |
| 2012-02-09 04:05:00 | AAPL | Stock | 17.0664 | 17.0664 | 17.0654 | 17.0654 | 11200.0 |
| 2012-02-09 04:10:00 | AAPL | Stock | 17.0654 | 17.0654 | 17.05 | 17.05 | 7000.0 |
| 2012-02-09 04:15:00 | AAPL | Stock | 17.0682 | 17.0682 | 17.0682 | 17.0682 | 5600.0 |
| 2012-02-09 04:20:00 | AAPL | Stock | 17.0604 | 17.0604 | 17.0604 | 17.0604 | 5600.0 |
| 2012-02-09 04:30:00 | AAPL | Stock | 17.1007 | 17.1007 | 17.0936 | 17.0936 | 8680.0 |
| 2012-02-09 04:35:00 | AAPL | Stock | 17.0857 | 17.0857 | 17.0757 | 17.0757 | 24808.0 |
| 2012-02-09 04:50:00 | AAPL | Stock | 17.075 | 17.075 | 17.0632 | 17.0632 | 28000.0 |
| 2012-02-09 04:55:00 | AAPL | Stock | 17.0643 | 17.0643 | 17.0632 | 17.0632 | 30800.0 |
| 2012-02-09 05:20:00 | AAPL | Stock | 17.0825 | 17.0825 | 17.0825 | 17.0825 | 5600.0 |
| 2012-02-09 05:25:00 | AAPL | Stock | 17.0804 | 17.0804 | 17.0804 | 17.0804 | 5600.0 |
| 2012-02-09 05:35:00 | AAPL | Stock | 17.0736 | 17.0736 | 17.0736 | 17.0736 | 2800.0 |
| 2012-02-09 05:45:00 | AAPL | Stock | 17.0729 | 17.0729 | 17.0729 | 17.0729 | 5600.0 |
| 2012-02-09 05:55:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 5600.0 |
| 2012-02-09 06:00:00 | AAPL | Stock | 17.0632 | 17.0632 | 17.0632 | 17.0632 | 21756.0 |
| 2012-02-09 06:10:00 | AAPL | Stock | 17.0679 | 17.0679 | 17.05 | 17.05 | 5600.0 |
| 2012-02-09 06:15:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 5600.0 |
| 2012-02-09 06:20:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2012-02-09 06:25:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2012-02-09 06:35:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 5600.0 |
| 2012-02-09 06:45:00 | AAPL | Stock | 17.0554 | 17.0679 | 17.0536 | 17.0679 | 38780.0 |
| 2012-02-09 06:50:00 | AAPL | Stock | 17.0571 | 17.0571 | 17.0357 | 17.0357 | 24444.0 |
| 2012-02-09 07:00:00 | AAPL | Stock | 17.0382 | 17.0568 | 17.0357 | 17.0357 | 61796.0 |
| 2012-02-09 07:05:00 | AAPL | Stock | 17.0454 | 17.0454 | 17.0375 | 17.0393 | 36400.0 |
| 2012-02-09 07:10:00 | AAPL | Stock | 17.0414 | 17.0589 | 17.0414 | 17.0589 | 22400.0 |
| 2012-02-09 07:15:00 | AAPL | Stock | 17.0607 | 17.0607 | 17.0607 | 17.0607 | 5600.0 |
| 2012-02-09 07:20:00 | AAPL | Stock | 17.0571 | 17.0575 | 17.0571 | 17.0575 | 14000.0 |
| 2012-02-09 07:25:00 | AAPL | Stock | 17.0604 | 17.0643 | 17.0604 | 17.0643 | 25200.0 |
| 2012-02-09 07:30:00 | AAPL | Stock | 17.0571 | 17.0711 | 17.0557 | 17.0711 | 48132.0 |
| 2012-02-09 07:35:00 | AAPL | Stock | 17.0668 | 17.0886 | 17.0668 | 17.0871 | 124824.0 |
| 2012-02-09 07:40:00 | AAPL | Stock | 17.0857 | 17.0954 | 17.0732 | 17.0732 | 174356.0 |
| 2012-02-09 07:45:00 | AAPL | Stock | 17.0814 | 17.0893 | 17.0754 | 17.0821 | 54628.0 |
| 2012-02-09 07:50:00 | AAPL | Stock | 17.0786 | 17.0786 | 17.0714 | 17.0779 | 76860.0 |
| 2012-02-09 07:55:00 | AAPL | Stock | 17.0721 | 17.0786 | 17.0714 | 17.0775 | 50400.0 |
| 2012-02-09 08:00:00 | AAPL | Stock | 17.0714 | 17.0775 | 17.0661 | 17.0707 | 219408.0 |
| 2012-02-09 08:05:00 | AAPL | Stock | 17.0707 | 17.0779 | 16.9893 | 17.0768 | 249648.0 |
| 2012-02-09 08:10:00 | AAPL | Stock | 17.0768 | 17.1036 | 17.0714 | 17.1 | 393400.0 |
| 2012-02-09 08:15:00 | AAPL | Stock | 17.0982 | 17.1139 | 17.0939 | 17.1136 | 408296.0 |
| 2012-02-09 08:20:00 | AAPL | Stock | 17.1139 | 17.1321 | 17.1071 | 17.1193 | 426832.0 |
| 2012-02-09 08:25:00 | AAPL | Stock | 17.1161 | 17.1314 | 17.1118 | 17.1279 | 393176.0 |
| 2012-02-09 08:30:00 | AAPL | Stock | 17.1289 | 17.1371 | 17.115 | 17.1289 | 976724.0 |
| 2012-02-09 08:35:00 | AAPL | Stock | 17.1286 | 17.1314 | 17.1089 | 17.1279 | 548044.0 |
| 2012-02-09 08:40:00 | AAPL | Stock | 17.1254 | 17.1318 | 17.125 | 17.1286 | 356692.0 |
| 2012-02-09 08:45:00 | AAPL | Stock | 17.1261 | 17.1357 | 17.125 | 17.125 | 296604.0 |
| 2012-02-09 08:50:00 | AAPL | Stock | 17.1254 | 17.1464 | 17.1254 | 17.1429 | 1033480.0 |
| 2012-02-09 08:55:00 | AAPL | Stock | 17.1436 | 17.1507 | 17.1436 | 17.1464 | 555828.0 |
| 2012-02-09 09:00:00 | AAPL | Stock | 17.1482 | 17.1611 | 17.1429 | 17.1543 | 694624.0 |
| 2012-02-09 09:05:00 | AAPL | Stock | 17.1554 | 17.16 | 17.1432 | 17.1518 | 477904.0 |
| 2012-02-09 09:10:00 | AAPL | Stock | 17.1536 | 17.1664 | 17.1482 | 17.1575 | 587720.0 |
| 2012-02-09 09:15:00 | AAPL | Stock | 17.1607 | 17.1761 | 17.1607 | 17.1704 | 716212.0 |
> showing 50 of 328,009 rows — these rows as CSV