PREVIEW / stock_5min / 2013-05-02
file: by_date/stock_5min/2013/2013-05-02.parquet size: 5.1 MB rows: 338,889 symbols: 3,482
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-05-02 05:15:00 | AAPL | Stock | 15.7171 | 15.7171 | 15.7171 | 15.7171 | 2800.0 |
| 2013-05-02 06:25:00 | AAPL | Stock | 15.7411 | 15.7479 | 15.7411 | 15.7479 | 8400.0 |
| 2013-05-02 06:30:00 | AAPL | Stock | 15.7482 | 15.7482 | 15.7482 | 15.7482 | 2800.0 |
| 2013-05-02 06:55:00 | AAPL | Stock | 15.7407 | 15.75 | 15.7407 | 15.75 | 29512.0 |
| 2013-05-02 07:00:00 | AAPL | Stock | 15.7675 | 15.7732 | 15.7675 | 15.7679 | 45024.0 |
| 2013-05-02 07:05:00 | AAPL | Stock | 15.7729 | 15.7729 | 15.7679 | 15.7679 | 29400.0 |
| 2013-05-02 07:10:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 11200.0 |
| 2013-05-02 07:20:00 | AAPL | Stock | 15.7554 | 15.7661 | 15.7554 | 15.7661 | 61600.0 |
| 2013-05-02 07:25:00 | AAPL | Stock | 15.7675 | 15.7821 | 15.7675 | 15.7821 | 53200.0 |
| 2013-05-02 07:30:00 | AAPL | Stock | 15.7796 | 15.7807 | 15.7793 | 15.78 | 19600.0 |
| 2013-05-02 07:35:00 | AAPL | Stock | 15.7711 | 15.7879 | 15.7711 | 15.7879 | 94612.0 |
| 2013-05-02 07:40:00 | AAPL | Stock | 15.8018 | 15.8129 | 15.7896 | 15.7896 | 53200.0 |
| 2013-05-02 07:45:00 | AAPL | Stock | 15.8018 | 15.8311 | 15.8018 | 15.8143 | 288512.0 |
| 2013-05-02 07:50:00 | AAPL | Stock | 15.8214 | 15.8393 | 15.8214 | 15.8214 | 166068.0 |
| 2013-05-02 07:55:00 | AAPL | Stock | 15.8214 | 15.84 | 15.8214 | 15.825 | 93828.0 |
| 2013-05-02 08:00:00 | AAPL | Stock | 15.825 | 15.8346 | 15.7607 | 15.7854 | 498876.0 |
| 2013-05-02 08:05:00 | AAPL | Stock | 15.785 | 15.8 | 15.7729 | 15.7861 | 117460.0 |
| 2013-05-02 08:10:00 | AAPL | Stock | 15.7968 | 15.7982 | 15.7918 | 15.7929 | 72912.0 |
| 2013-05-02 08:15:00 | AAPL | Stock | 15.7943 | 15.7982 | 15.7893 | 15.7943 | 153020.0 |
| 2013-05-02 08:20:00 | AAPL | Stock | 15.7968 | 15.8036 | 15.7893 | 15.7989 | 89236.0 |
| 2013-05-02 08:25:00 | AAPL | Stock | 15.7979 | 15.8061 | 15.7964 | 15.8036 | 241220.0 |
| 2013-05-02 08:30:00 | AAPL | Stock | 15.8089 | 15.8357 | 15.8089 | 15.8321 | 405664.0 |
| 2013-05-02 08:35:00 | AAPL | Stock | 15.8343 | 15.8393 | 15.8304 | 15.8393 | 285768.0 |
| 2013-05-02 08:40:00 | AAPL | Stock | 15.8325 | 15.8379 | 15.8143 | 15.8157 | 194264.0 |
| 2013-05-02 08:45:00 | AAPL | Stock | 15.8146 | 15.8211 | 15.8118 | 15.815 | 246288.0 |
| 2013-05-02 08:50:00 | AAPL | Stock | 15.8157 | 15.8211 | 15.7979 | 15.8039 | 614180.0 |
| 2013-05-02 08:55:00 | AAPL | Stock | 15.8089 | 15.8107 | 15.7964 | 15.8086 | 192556.0 |
| 2013-05-02 09:00:00 | AAPL | Stock | 15.8089 | 15.8107 | 15.7893 | 15.7957 | 449848.0 |
| 2013-05-02 09:05:00 | AAPL | Stock | 15.7964 | 15.7968 | 15.785 | 15.7868 | 585144.0 |
| 2013-05-02 09:10:00 | AAPL | Stock | 15.7821 | 15.7821 | 15.7718 | 15.7793 | 367220.0 |
| 2013-05-02 09:15:00 | AAPL | Stock | 15.7793 | 15.7793 | 15.7725 | 15.7725 | 113708.0 |
| 2013-05-02 09:20:00 | AAPL | Stock | 15.7782 | 15.7911 | 15.7739 | 15.7911 | 212912.0 |
| 2013-05-02 09:25:00 | AAPL | Stock | 15.7911 | 15.7911 | 15.7736 | 15.7779 | 234892.0 |
| 2013-05-02 09:30:00 | AAPL | Stock | 15.7804 | 15.8729 | 15.7368 | 15.8686 | 18215736.0 |
| 2013-05-02 09:35:00 | AAPL | Stock | 15.8718 | 15.9275 | 15.8375 | 15.9114 | 16349396.0 |
| 2013-05-02 09:40:00 | AAPL | Stock | 15.9125 | 15.9454 | 15.8968 | 15.9104 | 13948256.0 |
| 2013-05-02 09:45:00 | AAPL | Stock | 15.9104 | 15.9748 | 15.9093 | 15.9489 | 16551724.0 |
| 2013-05-02 09:50:00 | AAPL | Stock | 15.9506 | 15.9711 | 15.9021 | 15.9061 | 9535288.0 |
| 2013-05-02 09:55:00 | AAPL | Stock | 15.9058 | 15.9243 | 15.8751 | 15.8846 | 8338988.0 |
| 2013-05-02 10:00:00 | AAPL | Stock | 15.8807 | 15.9354 | 15.875 | 15.9079 | 7462028.0 |
| 2013-05-02 10:05:00 | AAPL | Stock | 15.9064 | 15.9643 | 15.9018 | 15.9639 | 6654004.0 |
| 2013-05-02 10:10:00 | AAPL | Stock | 15.9636 | 15.9829 | 15.9479 | 15.9521 | 8650040.0 |
| 2013-05-02 10:15:00 | AAPL | Stock | 15.9561 | 15.9885 | 15.9514 | 15.9575 | 7024640.0 |
| 2013-05-02 10:20:00 | AAPL | Stock | 15.9575 | 15.9818 | 15.9564 | 15.9696 | 5641888.0 |
| 2013-05-02 10:25:00 | AAPL | Stock | 15.9736 | 15.9871 | 15.9339 | 15.9386 | 6955872.0 |
| 2013-05-02 10:30:00 | AAPL | Stock | 15.9371 | 15.9714 | 15.9248 | 15.9714 | 4448808.0 |
| 2013-05-02 10:35:00 | AAPL | Stock | 15.97 | 15.9757 | 15.9197 | 15.9357 | 5820024.0 |
| 2013-05-02 10:40:00 | AAPL | Stock | 15.9357 | 15.9536 | 15.9329 | 15.9346 | 2824808.0 |
| 2013-05-02 10:45:00 | AAPL | Stock | 15.9364 | 15.9832 | 15.935 | 15.9729 | 5858832.0 |
| 2013-05-02 10:50:00 | AAPL | Stock | 15.9732 | 15.9771 | 15.9539 | 15.9698 | 2931460.0 |
> showing 50 of 338,889 rows — these rows as CSV