PREVIEW / stock_5min / 2013-12-16
file: by_date/stock_5min/2013/2013-12-16.parquet size: 5.5 MB rows: 366,293 symbols: 3,554
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-16 04:00:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 5600.0 |
| 2013-12-16 04:05:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 24640.0 |
| 2013-12-16 04:10:00 | AAPL | Stock | 19.7875 | 19.7875 | 19.7875 | 19.7875 | 5600.0 |
| 2013-12-16 04:20:00 | AAPL | Stock | 19.7918 | 19.8107 | 19.7918 | 19.8107 | 8400.0 |
| 2013-12-16 04:35:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.8125 | 19.8125 | 2800.0 |
| 2013-12-16 05:00:00 | AAPL | Stock | 19.8511 | 19.8511 | 19.84 | 19.84 | 5600.0 |
| 2013-12-16 05:05:00 | AAPL | Stock | 19.8396 | 19.8396 | 19.8396 | 19.8396 | 2800.0 |
| 2013-12-16 05:10:00 | AAPL | Stock | 19.8479 | 19.8479 | 19.8479 | 19.8479 | 8400.0 |
| 2013-12-16 05:20:00 | AAPL | Stock | 19.8732 | 19.8764 | 19.8732 | 19.875 | 58800.0 |
| 2013-12-16 05:25:00 | AAPL | Stock | 19.875 | 19.8857 | 19.875 | 19.8857 | 12600.0 |
| 2013-12-16 05:30:00 | AAPL | Stock | 19.8771 | 19.8771 | 19.8771 | 19.8771 | 4200.0 |
| 2013-12-16 05:50:00 | AAPL | Stock | 19.8786 | 19.8786 | 19.8761 | 19.8761 | 15624.0 |
| 2013-12-16 06:00:00 | AAPL | Stock | 19.8929 | 19.8964 | 19.8929 | 19.8964 | 5600.0 |
| 2013-12-16 06:05:00 | AAPL | Stock | 19.8839 | 19.8839 | 19.8789 | 19.8789 | 9632.0 |
| 2013-12-16 06:10:00 | AAPL | Stock | 19.8768 | 19.8768 | 19.8482 | 19.8482 | 78400.0 |
| 2013-12-16 06:15:00 | AAPL | Stock | 19.8561 | 19.8561 | 19.8561 | 19.8561 | 2800.0 |
| 2013-12-16 06:25:00 | AAPL | Stock | 19.875 | 19.875 | 19.8571 | 19.8571 | 8400.0 |
| 2013-12-16 06:30:00 | AAPL | Stock | 19.8739 | 19.8739 | 19.8521 | 19.8521 | 21000.0 |
| 2013-12-16 06:55:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 14000.0 |
| 2013-12-16 07:00:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8571 | 19.8643 | 34132.0 |
| 2013-12-16 07:05:00 | AAPL | Stock | 19.8661 | 19.8679 | 19.8661 | 19.8679 | 10668.0 |
| 2013-12-16 07:10:00 | AAPL | Stock | 19.8782 | 19.8782 | 19.8664 | 19.8664 | 32340.0 |
| 2013-12-16 07:15:00 | AAPL | Stock | 19.8714 | 19.8714 | 19.8714 | 19.8714 | 14000.0 |
| 2013-12-16 07:20:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8661 | 19.8661 | 4480.0 |
| 2013-12-16 07:25:00 | AAPL | Stock | 19.8668 | 19.8668 | 19.8661 | 19.8664 | 16800.0 |
| 2013-12-16 07:30:00 | AAPL | Stock | 19.8668 | 19.875 | 19.8664 | 19.8714 | 47600.0 |
| 2013-12-16 07:35:00 | AAPL | Stock | 19.8729 | 19.9 | 19.8729 | 19.9 | 96236.0 |
| 2013-12-16 07:40:00 | AAPL | Stock | 19.9 | 19.9089 | 19.9 | 19.9089 | 34272.0 |
| 2013-12-16 07:45:00 | AAPL | Stock | 19.9086 | 19.9143 | 19.895 | 19.9143 | 75600.0 |
| 2013-12-16 07:50:00 | AAPL | Stock | 19.9068 | 19.9068 | 19.8975 | 19.8975 | 12488.0 |
| 2013-12-16 07:55:00 | AAPL | Stock | 19.9036 | 19.9068 | 19.9036 | 19.9068 | 28140.0 |
| 2013-12-16 08:00:00 | AAPL | Stock | 19.9068 | 19.9068 | 19.85 | 19.8746 | 483616.0 |
| 2013-12-16 08:05:00 | AAPL | Stock | 19.8732 | 19.8739 | 19.8607 | 19.8643 | 84280.0 |
| 2013-12-16 08:10:00 | AAPL | Stock | 19.8643 | 19.87 | 19.8532 | 19.87 | 71624.0 |
| 2013-12-16 08:15:00 | AAPL | Stock | 19.8693 | 19.8732 | 19.8693 | 19.8732 | 161168.0 |
| 2013-12-16 08:20:00 | AAPL | Stock | 19.8725 | 19.8789 | 19.8711 | 19.8789 | 101528.0 |
| 2013-12-16 08:25:00 | AAPL | Stock | 19.8789 | 19.8864 | 19.875 | 19.8804 | 119924.0 |
| 2013-12-16 08:30:00 | AAPL | Stock | 19.8814 | 19.8814 | 19.875 | 19.8804 | 135352.0 |
| 2013-12-16 08:35:00 | AAPL | Stock | 19.8811 | 19.8811 | 19.8771 | 19.8771 | 19600.0 |
| 2013-12-16 08:40:00 | AAPL | Stock | 19.8836 | 19.8864 | 19.8821 | 19.8864 | 64036.0 |
| 2013-12-16 08:45:00 | AAPL | Stock | 19.8864 | 19.9068 | 19.8864 | 19.9068 | 179564.0 |
| 2013-12-16 08:50:00 | AAPL | Stock | 19.9018 | 19.9068 | 19.8871 | 19.8925 | 151312.0 |
| 2013-12-16 08:55:00 | AAPL | Stock | 19.8925 | 19.9007 | 19.8918 | 19.8993 | 125300.0 |
| 2013-12-16 09:00:00 | AAPL | Stock | 19.8993 | 19.9104 | 19.8993 | 19.9089 | 173264.0 |
| 2013-12-16 09:05:00 | AAPL | Stock | 19.9071 | 19.9118 | 19.8929 | 19.8929 | 129528.0 |
| 2013-12-16 09:10:00 | AAPL | Stock | 19.8982 | 19.8982 | 19.8886 | 19.8936 | 184660.0 |
| 2013-12-16 09:15:00 | AAPL | Stock | 19.8929 | 19.8996 | 19.8929 | 19.8936 | 85848.0 |
| 2013-12-16 09:20:00 | AAPL | Stock | 19.8929 | 19.9 | 19.8914 | 19.8929 | 129108.0 |
| 2013-12-16 09:25:00 | AAPL | Stock | 19.8964 | 19.9 | 19.8143 | 19.8225 | 822052.0 |
| 2013-12-16 09:30:00 | AAPL | Stock | 19.8239 | 19.9014 | 19.8218 | 19.8486 | 12702536.0 |
> showing 50 of 366,293 rows — these rows as CSV