PREVIEW / stock_5min / 2013-07-30
file: by_date/stock_5min/2013/2013-07-30.parquet size: 5.1 MB rows: 335,095 symbols: 3,537
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-07-30 04:00:00 | AAPL | Stock | 16.0461 | 16.0536 | 16.0461 | 16.0536 | 8400.0 |
| 2013-07-30 04:10:00 | AAPL | Stock | 16.0193 | 16.0193 | 16.0193 | 16.0193 | 2800.0 |
| 2013-07-30 06:40:00 | AAPL | Stock | 16.0289 | 16.0289 | 16.0289 | 16.0289 | 16968.0 |
| 2013-07-30 07:00:00 | AAPL | Stock | 16.0357 | 16.0432 | 16.0357 | 16.0432 | 15960.0 |
| 2013-07-30 07:05:00 | AAPL | Stock | 16.0411 | 16.0536 | 16.0407 | 16.0536 | 39200.0 |
| 2013-07-30 07:10:00 | AAPL | Stock | 16.0539 | 16.0539 | 16.0486 | 16.0486 | 22400.0 |
| 2013-07-30 07:15:00 | AAPL | Stock | 16.0536 | 16.0893 | 16.0536 | 16.0893 | 113652.0 |
| 2013-07-30 07:20:00 | AAPL | Stock | 16.0821 | 16.0821 | 16.0643 | 16.0643 | 28392.0 |
| 2013-07-30 07:25:00 | AAPL | Stock | 16.0714 | 16.075 | 16.0714 | 16.075 | 16800.0 |
| 2013-07-30 07:30:00 | AAPL | Stock | 16.0793 | 16.0889 | 16.0786 | 16.0786 | 88340.0 |
| 2013-07-30 07:35:00 | AAPL | Stock | 16.0882 | 16.0882 | 16.0875 | 16.0875 | 11200.0 |
| 2013-07-30 07:40:00 | AAPL | Stock | 16.0821 | 16.0821 | 16.0643 | 16.0643 | 92372.0 |
| 2013-07-30 07:45:00 | AAPL | Stock | 16.0718 | 16.0718 | 16.0643 | 16.0643 | 27300.0 |
| 2013-07-30 07:50:00 | AAPL | Stock | 16.0718 | 16.0718 | 16.0679 | 16.0718 | 72520.0 |
| 2013-07-30 07:55:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0679 | 16.0679 | 42000.0 |
| 2013-07-30 08:00:00 | AAPL | Stock | 16.0643 | 16.0804 | 15.9643 | 16.0532 | 323372.0 |
| 2013-07-30 08:05:00 | AAPL | Stock | 16.0468 | 16.0539 | 16.0464 | 16.0464 | 72800.0 |
| 2013-07-30 08:10:00 | AAPL | Stock | 16.05 | 16.0536 | 16.0464 | 16.0536 | 11200.0 |
| 2013-07-30 08:15:00 | AAPL | Stock | 16.055 | 16.0679 | 16.055 | 16.0679 | 195132.0 |
| 2013-07-30 08:20:00 | AAPL | Stock | 16.0682 | 16.0793 | 16.0682 | 16.0721 | 127680.0 |
| 2013-07-30 08:25:00 | AAPL | Stock | 16.0729 | 16.0957 | 16.0729 | 16.0954 | 254436.0 |
| 2013-07-30 08:30:00 | AAPL | Stock | 16.0921 | 16.0961 | 16.0807 | 16.0882 | 300412.0 |
| 2013-07-30 08:35:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0714 | 16.0804 | 196140.0 |
| 2013-07-30 08:40:00 | AAPL | Stock | 16.08 | 16.0893 | 16.0793 | 16.0857 | 109284.0 |
| 2013-07-30 08:45:00 | AAPL | Stock | 16.0854 | 16.0875 | 16.0821 | 16.0875 | 81760.0 |
| 2013-07-30 08:50:00 | AAPL | Stock | 16.0857 | 16.0864 | 16.0811 | 16.0811 | 80276.0 |
| 2013-07-30 08:55:00 | AAPL | Stock | 16.0804 | 16.0804 | 16.0714 | 16.0764 | 92372.0 |
| 2013-07-30 09:00:00 | AAPL | Stock | 16.0768 | 16.0786 | 16.0743 | 16.075 | 168644.0 |
| 2013-07-30 09:05:00 | AAPL | Stock | 16.0768 | 16.0825 | 16.0768 | 16.0818 | 65632.0 |
| 2013-07-30 09:10:00 | AAPL | Stock | 16.0804 | 16.0825 | 16.0754 | 16.0754 | 65800.0 |
| 2013-07-30 09:15:00 | AAPL | Stock | 16.0764 | 16.0839 | 16.0732 | 16.0775 | 211904.0 |
| 2013-07-30 09:20:00 | AAPL | Stock | 16.0732 | 16.1 | 16.0732 | 16.0864 | 244888.0 |
| 2013-07-30 09:25:00 | AAPL | Stock | 16.0939 | 16.0946 | 16.0625 | 16.0696 | 283976.0 |
| 2013-07-30 09:30:00 | AAPL | Stock | 16.07 | 16.1071 | 16.0439 | 16.0661 | 17069584.0 |
| 2013-07-30 09:35:00 | AAPL | Stock | 16.0678 | 16.1243 | 16.0471 | 16.1232 | 8429764.0 |
| 2013-07-30 09:40:00 | AAPL | Stock | 16.1232 | 16.1464 | 16.1071 | 16.1271 | 10384808.0 |
| 2013-07-30 09:45:00 | AAPL | Stock | 16.1318 | 16.1721 | 16.1304 | 16.1483 | 8218140.0 |
| 2013-07-30 09:50:00 | AAPL | Stock | 16.1529 | 16.1568 | 16.135 | 16.1554 | 6078604.0 |
| 2013-07-30 09:55:00 | AAPL | Stock | 16.1568 | 16.1675 | 16.1275 | 16.1289 | 4651584.0 |
| 2013-07-30 10:00:00 | AAPL | Stock | 16.1307 | 16.1507 | 16.1132 | 16.1436 | 3948196.0 |
| 2013-07-30 10:05:00 | AAPL | Stock | 16.145 | 16.1718 | 16.1425 | 16.1711 | 4084528.0 |
| 2013-07-30 10:10:00 | AAPL | Stock | 16.169 | 16.1721 | 16.1432 | 16.1607 | 3547348.0 |
| 2013-07-30 10:15:00 | AAPL | Stock | 16.1611 | 16.1943 | 16.1604 | 16.1843 | 6702024.0 |
| 2013-07-30 10:20:00 | AAPL | Stock | 16.1843 | 16.2029 | 16.1804 | 16.1915 | 4734072.0 |
| 2013-07-30 10:25:00 | AAPL | Stock | 16.1904 | 16.1925 | 16.1571 | 16.1668 | 5372500.0 |
| 2013-07-30 10:30:00 | AAPL | Stock | 16.1668 | 16.185 | 16.1611 | 16.1689 | 4941412.0 |
| 2013-07-30 10:35:00 | AAPL | Stock | 16.1679 | 16.1893 | 16.1654 | 16.1882 | 2186548.0 |
| 2013-07-30 10:40:00 | AAPL | Stock | 16.1882 | 16.1988 | 16.1786 | 16.1893 | 2713172.0 |
| 2013-07-30 10:45:00 | AAPL | Stock | 16.1879 | 16.1978 | 16.1714 | 16.1918 | 2606632.0 |
| 2013-07-30 10:50:00 | AAPL | Stock | 16.1918 | 16.2261 | 16.1876 | 16.2214 | 6145804.0 |
> showing 50 of 335,095 rows — these rows as CSV