PREVIEW / stock_5min / 2013-12-09
file: by_date/stock_5min/2013/2013-12-09.parquet size: 5.3 MB rows: 355,287 symbols: 3,549
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-09 04:05:00 | AAPL | Stock | 20.0864 | 20.0864 | 20.0864 | 20.0864 | 25200.0 |
| 2013-12-09 04:15:00 | AAPL | Stock | 20.0768 | 20.0768 | 20.0768 | 20.0768 | 14000.0 |
| 2013-12-09 04:25:00 | AAPL | Stock | 20.0725 | 20.0725 | 20.0725 | 20.0725 | 5600.0 |
| 2013-12-09 04:45:00 | AAPL | Stock | 20.075 | 20.075 | 20.075 | 20.075 | 5600.0 |
| 2013-12-09 05:30:00 | AAPL | Stock | 20.0621 | 20.0621 | 20.0539 | 20.0539 | 19600.0 |
| 2013-12-09 05:45:00 | AAPL | Stock | 20.0429 | 20.0429 | 20.0429 | 20.0429 | 10220.0 |
| 2013-12-09 06:10:00 | AAPL | Stock | 20.0679 | 20.0714 | 20.0679 | 20.0714 | 14000.0 |
| 2013-12-09 06:35:00 | AAPL | Stock | 20.0714 | 20.0771 | 20.0714 | 20.0771 | 19600.0 |
| 2013-12-09 06:40:00 | AAPL | Stock | 20.0754 | 20.0754 | 20.0754 | 20.0754 | 9828.0 |
| 2013-12-09 06:55:00 | AAPL | Stock | 20.0757 | 20.0757 | 20.0757 | 20.0757 | 2800.0 |
| 2013-12-09 07:00:00 | AAPL | Stock | 20.08 | 20.0804 | 20.0714 | 20.0732 | 32732.0 |
| 2013-12-09 07:05:00 | AAPL | Stock | 20.0657 | 20.0714 | 20.0657 | 20.0714 | 19600.0 |
| 2013-12-09 07:10:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2013-12-09 07:15:00 | AAPL | Stock | 20.0732 | 20.0732 | 20.0732 | 20.0732 | 33572.0 |
| 2013-12-09 07:20:00 | AAPL | Stock | 20.0818 | 20.0889 | 20.0786 | 20.0786 | 33600.0 |
| 2013-12-09 07:25:00 | AAPL | Stock | 20.0886 | 20.1071 | 20.0832 | 20.0832 | 34160.0 |
| 2013-12-09 07:30:00 | AAPL | Stock | 20.1061 | 20.1143 | 20.0914 | 20.0914 | 8400.0 |
| 2013-12-09 07:35:00 | AAPL | Stock | 20.0929 | 20.1086 | 20.0929 | 20.1086 | 8400.0 |
| 2013-12-09 07:40:00 | AAPL | Stock | 20.0918 | 20.1161 | 20.0918 | 20.1075 | 36400.0 |
| 2013-12-09 07:50:00 | AAPL | Stock | 20.1057 | 20.1071 | 20.1057 | 20.1071 | 33600.0 |
| 2013-12-09 08:00:00 | AAPL | Stock | 20.0982 | 20.1107 | 20.0661 | 20.0779 | 587776.0 |
| 2013-12-09 08:05:00 | AAPL | Stock | 20.0711 | 20.0711 | 20.0643 | 20.0696 | 55608.0 |
| 2013-12-09 08:10:00 | AAPL | Stock | 20.0696 | 20.075 | 20.0596 | 20.0636 | 65128.0 |
| 2013-12-09 08:15:00 | AAPL | Stock | 20.0643 | 20.0654 | 20.0536 | 20.0618 | 118552.0 |
| 2013-12-09 08:20:00 | AAPL | Stock | 20.0554 | 20.0768 | 20.0518 | 20.0714 | 232736.0 |
| 2013-12-09 08:25:00 | AAPL | Stock | 20.0761 | 20.0893 | 20.0732 | 20.0829 | 226688.0 |
| 2013-12-09 08:30:00 | AAPL | Stock | 20.0839 | 20.0896 | 20.0679 | 20.0896 | 113820.0 |
| 2013-12-09 08:35:00 | AAPL | Stock | 20.0857 | 20.0896 | 20.0754 | 20.0754 | 109760.0 |
| 2013-12-09 08:40:00 | AAPL | Stock | 20.0786 | 20.0786 | 20.0754 | 20.0771 | 49952.0 |
| 2013-12-09 08:45:00 | AAPL | Stock | 20.0871 | 20.0957 | 20.0857 | 20.0857 | 118664.0 |
| 2013-12-09 08:50:00 | AAPL | Stock | 20.0864 | 20.0889 | 20.0825 | 20.0889 | 56028.0 |
| 2013-12-09 08:55:00 | AAPL | Stock | 20.0857 | 20.0889 | 20.0721 | 20.0725 | 131852.0 |
| 2013-12-09 09:00:00 | AAPL | Stock | 20.0775 | 20.0786 | 20.0696 | 20.0714 | 65800.0 |
| 2013-12-09 09:05:00 | AAPL | Stock | 20.0707 | 20.0746 | 20.0664 | 20.0721 | 80836.0 |
| 2013-12-09 09:10:00 | AAPL | Stock | 20.0768 | 20.0889 | 20.0768 | 20.0875 | 123144.0 |
| 2013-12-09 09:15:00 | AAPL | Stock | 20.0861 | 20.0871 | 20.0789 | 20.0846 | 72800.0 |
| 2013-12-09 09:20:00 | AAPL | Stock | 20.0836 | 20.0861 | 20.0821 | 20.0829 | 49420.0 |
| 2013-12-09 09:25:00 | AAPL | Stock | 20.0829 | 20.0893 | 20.0186 | 20.0371 | 725452.0 |
| 2013-12-09 09:30:00 | AAPL | Stock | 20.0321 | 20.1604 | 20.0321 | 20.1571 | 15318296.0 |
| 2013-12-09 09:35:00 | AAPL | Stock | 20.1557 | 20.1679 | 20.1221 | 20.1574 | 8003660.0 |
| 2013-12-09 09:40:00 | AAPL | Stock | 20.1582 | 20.2134 | 20.1554 | 20.1929 | 9392236.0 |
| 2013-12-09 09:45:00 | AAPL | Stock | 20.1925 | 20.1993 | 20.1704 | 20.1779 | 5034092.0 |
| 2013-12-09 09:50:00 | AAPL | Stock | 20.1786 | 20.1836 | 20.1361 | 20.1536 | 5798744.0 |
| 2013-12-09 09:55:00 | AAPL | Stock | 20.1514 | 20.1718 | 20.1161 | 20.1256 | 6158320.0 |
| 2013-12-09 10:00:00 | AAPL | Stock | 20.1339 | 20.1571 | 20.1114 | 20.1409 | 5183612.0 |
| 2013-12-09 10:05:00 | AAPL | Stock | 20.1404 | 20.1596 | 20.1292 | 20.1525 | 2632588.0 |
| 2013-12-09 10:10:00 | AAPL | Stock | 20.1525 | 20.19 | 20.1496 | 20.1684 | 4383344.0 |
| 2013-12-09 10:15:00 | AAPL | Stock | 20.1704 | 20.1704 | 20.1511 | 20.1557 | 2357684.0 |
| 2013-12-09 10:20:00 | AAPL | Stock | 20.1571 | 20.1714 | 20.1496 | 20.1639 | 3436832.0 |
| 2013-12-09 10:25:00 | AAPL | Stock | 20.1645 | 20.1714 | 20.1386 | 20.1479 | 3169572.0 |
> showing 50 of 355,287 rows — these rows as CSV