PREVIEW / stock_5min / 2017-02-08
file: by_date/stock_5min/2017/2017-02-08.parquet size: 5.4 MB rows: 356,028 symbols: 3,097
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-08 05:05:00 | AAPL | Stock | 32.9125 | 32.9125 | 32.9125 | 32.9125 | 2808.0 |
| 2017-02-08 05:10:00 | AAPL | Stock | 32.935 | 32.9375 | 32.935 | 32.9375 | 4400.0 |
| 2017-02-08 05:15:00 | AAPL | Stock | 32.8975 | 32.8975 | 32.8975 | 32.8975 | 708.0 |
| 2017-02-08 05:30:00 | AAPL | Stock | 32.9475 | 32.9475 | 32.9475 | 32.9475 | 800.0 |
| 2017-02-08 06:05:00 | AAPL | Stock | 32.9475 | 32.9475 | 32.9475 | 32.9475 | 2000.0 |
| 2017-02-08 06:10:00 | AAPL | Stock | 32.95 | 32.95 | 32.95 | 32.95 | 400.0 |
| 2017-02-08 06:30:00 | AAPL | Stock | 32.9475 | 32.97 | 32.9475 | 32.97 | 2400.0 |
| 2017-02-08 06:35:00 | AAPL | Stock | 32.9325 | 32.9325 | 32.9325 | 32.9325 | 400.0 |
| 2017-02-08 06:40:00 | AAPL | Stock | 32.92 | 32.92 | 32.92 | 32.92 | 400.0 |
| 2017-02-08 06:50:00 | AAPL | Stock | 32.925 | 32.925 | 32.925 | 32.925 | 5600.0 |
| 2017-02-08 06:55:00 | AAPL | Stock | 32.9325 | 32.9325 | 32.9325 | 32.9325 | 3144.0 |
| 2017-02-08 07:00:00 | AAPL | Stock | 32.925 | 32.925 | 32.92 | 32.925 | 10644.0 |
| 2017-02-08 07:15:00 | AAPL | Stock | 32.9125 | 32.9125 | 32.9125 | 32.9125 | 400.0 |
| 2017-02-08 07:20:00 | AAPL | Stock | 32.9025 | 32.9025 | 32.9025 | 32.9025 | 5200.0 |
| 2017-02-08 07:25:00 | AAPL | Stock | 32.9025 | 32.9125 | 32.9025 | 32.9125 | 3600.0 |
| 2017-02-08 07:35:00 | AAPL | Stock | 32.915 | 32.925 | 32.915 | 32.925 | 2400.0 |
| 2017-02-08 07:40:00 | AAPL | Stock | 32.925 | 32.925 | 32.92 | 32.92 | 8000.0 |
| 2017-02-08 07:45:00 | AAPL | Stock | 32.9225 | 32.9325 | 32.9125 | 32.9125 | 18332.0 |
| 2017-02-08 07:50:00 | AAPL | Stock | 32.91 | 32.9125 | 32.9075 | 32.9075 | 6988.0 |
| 2017-02-08 07:55:00 | AAPL | Stock | 32.9175 | 32.9175 | 32.9 | 32.9 | 26128.0 |
| 2017-02-08 08:00:00 | AAPL | Stock | 32.925 | 32.925 | 32.8 | 32.89 | 32392.0 |
| 2017-02-08 08:05:00 | AAPL | Stock | 32.88 | 32.88 | 32.87 | 32.8725 | 9980.0 |
| 2017-02-08 08:10:00 | AAPL | Stock | 32.875 | 32.89 | 32.875 | 32.89 | 4400.0 |
| 2017-02-08 08:15:00 | AAPL | Stock | 32.8925 | 32.895 | 32.8925 | 32.895 | 1600.0 |
| 2017-02-08 08:20:00 | AAPL | Stock | 32.895 | 32.895 | 32.89 | 32.8925 | 23316.0 |
| 2017-02-08 08:25:00 | AAPL | Stock | 32.895 | 32.895 | 32.875 | 32.8875 | 12924.0 |
| 2017-02-08 08:30:00 | AAPL | Stock | 32.88 | 32.88 | 32.87 | 32.875 | 20864.0 |
| 2017-02-08 08:35:00 | AAPL | Stock | 32.87 | 32.8725 | 32.8625 | 32.8625 | 18000.0 |
| 2017-02-08 08:40:00 | AAPL | Stock | 32.8725 | 32.8725 | 32.84 | 32.8625 | 25956.0 |
| 2017-02-08 08:45:00 | AAPL | Stock | 32.8625 | 32.8725 | 32.85 | 32.8725 | 23280.0 |
| 2017-02-08 08:50:00 | AAPL | Stock | 32.875 | 32.895 | 32.875 | 32.895 | 4800.0 |
| 2017-02-08 08:55:00 | AAPL | Stock | 32.8925 | 32.9125 | 32.8925 | 32.8975 | 25036.0 |
| 2017-02-08 09:00:00 | AAPL | Stock | 32.8975 | 32.9 | 32.8375 | 32.8375 | 146512.0 |
| 2017-02-08 09:05:00 | AAPL | Stock | 32.8475 | 32.8625 | 32.8125 | 32.83 | 56384.0 |
| 2017-02-08 09:10:00 | AAPL | Stock | 32.8375 | 32.84 | 32.8375 | 32.84 | 800.0 |
| 2017-02-08 09:15:00 | AAPL | Stock | 32.85 | 32.855 | 32.85 | 32.855 | 8400.0 |
| 2017-02-08 09:20:00 | AAPL | Stock | 32.86 | 32.86 | 32.8275 | 32.8275 | 27036.0 |
| 2017-02-08 09:25:00 | AAPL | Stock | 32.845 | 32.845 | 32.825 | 32.83 | 25888.0 |
| 2017-02-08 09:30:00 | AAPL | Stock | 32.835 | 32.9325 | 32.805 | 32.883 | 5849872.0 |
| 2017-02-08 09:35:00 | AAPL | Stock | 32.885 | 32.95 | 32.8725 | 32.885 | 2963468.0 |
| 2017-02-08 09:40:00 | AAPL | Stock | 32.8775 | 32.93 | 32.8625 | 32.9052 | 1950724.0 |
| 2017-02-08 09:45:00 | AAPL | Stock | 32.9088 | 32.915 | 32.8725 | 32.8785 | 1851924.0 |
| 2017-02-08 09:50:00 | AAPL | Stock | 32.88 | 32.8825 | 32.82 | 32.8325 | 2072740.0 |
| 2017-02-08 09:55:00 | AAPL | Stock | 32.8338 | 32.86 | 32.82 | 32.8375 | 1072056.0 |
| 2017-02-08 10:00:00 | AAPL | Stock | 32.8375 | 32.8475 | 32.82 | 32.84 | 1253620.0 |
| 2017-02-08 10:05:00 | AAPL | Stock | 32.84 | 32.8525 | 32.805 | 32.8212 | 1058316.0 |
| 2017-02-08 10:10:00 | AAPL | Stock | 32.82 | 32.905 | 32.8175 | 32.9 | 1436812.0 |
| 2017-02-08 10:15:00 | AAPL | Stock | 32.9 | 32.902 | 32.865 | 32.887 | 788448.0 |
| 2017-02-08 10:20:00 | AAPL | Stock | 32.8875 | 32.8875 | 32.86 | 32.8688 | 549700.0 |
| 2017-02-08 10:25:00 | AAPL | Stock | 32.87 | 32.874 | 32.85 | 32.86 | 542156.0 |
> showing 50 of 356,028 rows — these rows as CSV