PREVIEW / stock_5min / 2015-11-02
file: by_date/stock_5min/2015/2015-11-02.parquet size: 5.5 MB rows: 366,153 symbols: 3,432
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-02 04:10:00 | AAPL | Stock | 29.815 | 29.815 | 29.8125 | 29.8125 | 3716.0 |
| 2015-11-02 04:15:00 | AAPL | Stock | 29.85 | 29.86 | 29.85 | 29.86 | 4608.0 |
| 2015-11-02 04:40:00 | AAPL | Stock | 29.8725 | 29.8875 | 29.8725 | 29.885 | 13600.0 |
| 2015-11-02 04:45:00 | AAPL | Stock | 29.905 | 29.905 | 29.905 | 29.905 | 1048.0 |
| 2015-11-02 04:55:00 | AAPL | Stock | 29.8825 | 29.8825 | 29.8825 | 29.8825 | 400.0 |
| 2015-11-02 05:05:00 | AAPL | Stock | 29.8775 | 29.8975 | 29.8775 | 29.8975 | 800.0 |
| 2015-11-02 05:30:00 | AAPL | Stock | 29.87 | 29.87 | 29.87 | 29.87 | 1600.0 |
| 2015-11-02 05:50:00 | AAPL | Stock | 29.8775 | 29.8775 | 29.8775 | 29.8775 | 1600.0 |
| 2015-11-02 05:55:00 | AAPL | Stock | 29.895 | 29.9025 | 29.895 | 29.9025 | 800.0 |
| 2015-11-02 06:05:00 | AAPL | Stock | 29.89 | 29.89 | 29.8875 | 29.8875 | 4400.0 |
| 2015-11-02 06:10:00 | AAPL | Stock | 29.8825 | 29.8875 | 29.8825 | 29.8875 | 8000.0 |
| 2015-11-02 06:15:00 | AAPL | Stock | 29.8875 | 29.8875 | 29.8875 | 29.8875 | 4000.0 |
| 2015-11-02 06:20:00 | AAPL | Stock | 29.895 | 29.895 | 29.875 | 29.875 | 22800.0 |
| 2015-11-02 06:25:00 | AAPL | Stock | 29.875 | 29.9 | 29.875 | 29.9 | 10000.0 |
| 2015-11-02 06:35:00 | AAPL | Stock | 29.9 | 29.9 | 29.9 | 29.9 | 1832.0 |
| 2015-11-02 06:40:00 | AAPL | Stock | 29.91 | 29.91 | 29.91 | 29.91 | 1600.0 |
| 2015-11-02 06:45:00 | AAPL | Stock | 29.9 | 29.9075 | 29.9 | 29.9 | 6000.0 |
| 2015-11-02 06:50:00 | AAPL | Stock | 29.885 | 29.9 | 29.875 | 29.875 | 13388.0 |
| 2015-11-02 06:55:00 | AAPL | Stock | 29.875 | 29.875 | 29.875 | 29.875 | 800.0 |
| 2015-11-02 07:00:00 | AAPL | Stock | 29.875 | 29.875 | 29.85 | 29.85 | 26100.0 |
| 2015-11-02 07:05:00 | AAPL | Stock | 29.8475 | 29.925 | 29.8475 | 29.925 | 40000.0 |
| 2015-11-02 07:15:00 | AAPL | Stock | 29.9125 | 29.92 | 29.9125 | 29.92 | 2800.0 |
| 2015-11-02 07:20:00 | AAPL | Stock | 29.9175 | 29.9175 | 29.9175 | 29.9175 | 800.0 |
| 2015-11-02 07:25:00 | AAPL | Stock | 29.9175 | 29.9175 | 29.9175 | 29.9175 | 1600.0 |
| 2015-11-02 07:30:00 | AAPL | Stock | 29.9125 | 29.915 | 29.9125 | 29.9125 | 2800.0 |
| 2015-11-02 07:35:00 | AAPL | Stock | 29.9025 | 29.905 | 29.9 | 29.9 | 10600.0 |
| 2015-11-02 07:40:00 | AAPL | Stock | 29.9 | 29.9025 | 29.9 | 29.9 | 5400.0 |
| 2015-11-02 07:45:00 | AAPL | Stock | 29.8975 | 29.92 | 29.8975 | 29.92 | 16060.0 |
| 2015-11-02 07:50:00 | AAPL | Stock | 29.9075 | 29.9075 | 29.905 | 29.905 | 2000.0 |
| 2015-11-02 07:55:00 | AAPL | Stock | 29.925 | 29.935 | 29.925 | 29.935 | 3996.0 |
| 2015-11-02 08:00:00 | AAPL | Stock | 29.92 | 29.9375 | 29.8625 | 29.9125 | 107544.0 |
| 2015-11-02 08:05:00 | AAPL | Stock | 29.9225 | 29.925 | 29.9175 | 29.925 | 7360.0 |
| 2015-11-02 08:10:00 | AAPL | Stock | 29.9175 | 29.925 | 29.9175 | 29.9225 | 21412.0 |
| 2015-11-02 08:15:00 | AAPL | Stock | 29.9225 | 29.925 | 29.9225 | 29.925 | 8944.0 |
| 2015-11-02 08:20:00 | AAPL | Stock | 29.925 | 29.9375 | 29.925 | 29.935 | 22164.0 |
| 2015-11-02 08:25:00 | AAPL | Stock | 29.9375 | 29.9625 | 29.9375 | 29.9625 | 54184.0 |
| 2015-11-02 08:30:00 | AAPL | Stock | 29.9625 | 29.9625 | 29.93 | 29.94 | 32648.0 |
| 2015-11-02 08:35:00 | AAPL | Stock | 29.9425 | 29.96 | 29.935 | 29.95 | 56620.0 |
| 2015-11-02 08:40:00 | AAPL | Stock | 29.955 | 29.965 | 29.9525 | 29.9625 | 29680.0 |
| 2015-11-02 08:45:00 | AAPL | Stock | 29.955 | 29.965 | 29.95 | 29.9525 | 37928.0 |
| 2015-11-02 08:50:00 | AAPL | Stock | 29.95 | 29.96 | 29.9425 | 29.96 | 24000.0 |
| 2015-11-02 08:55:00 | AAPL | Stock | 29.955 | 29.96 | 29.95 | 29.9575 | 21240.0 |
| 2015-11-02 09:00:00 | AAPL | Stock | 29.9575 | 29.9575 | 29.875 | 29.9525 | 24752.0 |
| 2015-11-02 09:05:00 | AAPL | Stock | 29.95 | 29.965 | 29.9475 | 29.965 | 56448.0 |
| 2015-11-02 09:10:00 | AAPL | Stock | 29.955 | 29.96 | 29.9375 | 29.95 | 44704.0 |
| 2015-11-02 09:15:00 | AAPL | Stock | 29.945 | 29.95 | 29.9425 | 29.9475 | 16452.0 |
| 2015-11-02 09:20:00 | AAPL | Stock | 29.9475 | 29.9475 | 29.9375 | 29.945 | 24180.0 |
| 2015-11-02 09:25:00 | AAPL | Stock | 29.945 | 29.9675 | 29.9225 | 29.965 | 160588.0 |
| 2015-11-02 09:30:00 | AAPL | Stock | 29.9675 | 30.0025 | 29.9025 | 29.9925 | 4858164.0 |
| 2015-11-02 09:35:00 | AAPL | Stock | 29.9925 | 30.005 | 29.93 | 29.9665 | 2624596.0 |
> showing 50 of 366,153 rows — these rows as CSV