PREVIEW / stock_5min / 2016-09-19
file: by_date/stock_5min/2016/2016-09-19.parquet size: 5.3 MB rows: 349,642 symbols: 3,223
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 |
|---|---|---|---|---|---|---|---|
| 2016-09-19 04:00:00 | AAPL | Stock | 28.7625 | 28.85 | 28.7625 | 28.85 | 7840.0 |
| 2016-09-19 04:05:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8625 | 28.8625 | 400.0 |
| 2016-09-19 04:10:00 | AAPL | Stock | 28.8125 | 28.8125 | 28.8125 | 28.8125 | 400.0 |
| 2016-09-19 04:25:00 | AAPL | Stock | 28.855 | 28.8575 | 28.855 | 28.8575 | 3200.0 |
| 2016-09-19 05:05:00 | AAPL | Stock | 28.8325 | 28.8375 | 28.8325 | 28.8375 | 23912.0 |
| 2016-09-19 05:10:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 14000.0 |
| 2016-09-19 05:15:00 | AAPL | Stock | 28.8375 | 28.8425 | 28.8325 | 28.8375 | 14772.0 |
| 2016-09-19 05:25:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 1616.0 |
| 2016-09-19 05:30:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 400.0 |
| 2016-09-19 05:35:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 2800.0 |
| 2016-09-19 05:40:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 6000.0 |
| 2016-09-19 05:45:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 1184.0 |
| 2016-09-19 05:50:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 400.0 |
| 2016-09-19 05:55:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8375 | 28.8375 | 400.0 |
| 2016-09-19 06:00:00 | AAPL | Stock | 28.825 | 28.85 | 28.825 | 28.85 | 7984.0 |
| 2016-09-19 06:05:00 | AAPL | Stock | 28.8575 | 28.8575 | 28.855 | 28.8575 | 10404.0 |
| 2016-09-19 06:15:00 | AAPL | Stock | 28.8525 | 28.8525 | 28.8525 | 28.8525 | 3800.0 |
| 2016-09-19 06:20:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8175 | 28.8175 | 3200.0 |
| 2016-09-19 06:25:00 | AAPL | Stock | 28.8425 | 28.8425 | 28.8125 | 28.8125 | 48188.0 |
| 2016-09-19 06:30:00 | AAPL | Stock | 28.8125 | 28.8125 | 28.8125 | 28.8125 | 800.0 |
| 2016-09-19 06:35:00 | AAPL | Stock | 28.8125 | 28.8125 | 28.7975 | 28.7975 | 7984.0 |
| 2016-09-19 06:40:00 | AAPL | Stock | 28.7925 | 28.7925 | 28.7925 | 28.7925 | 25200.0 |
| 2016-09-19 06:45:00 | AAPL | Stock | 28.795 | 28.8 | 28.795 | 28.8 | 7640.0 |
| 2016-09-19 06:50:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 14400.0 |
| 2016-09-19 06:55:00 | AAPL | Stock | 28.7925 | 28.7925 | 28.7925 | 28.7925 | 400.0 |
| 2016-09-19 07:00:00 | AAPL | Stock | 28.8125 | 28.85 | 28.7875 | 28.8125 | 23600.0 |
| 2016-09-19 07:05:00 | AAPL | Stock | 28.7875 | 28.8 | 28.7525 | 28.7875 | 18400.0 |
| 2016-09-19 07:10:00 | AAPL | Stock | 28.7625 | 28.775 | 28.75 | 28.75 | 35160.0 |
| 2016-09-19 07:15:00 | AAPL | Stock | 28.765 | 28.765 | 28.6775 | 28.69 | 33400.0 |
| 2016-09-19 07:20:00 | AAPL | Stock | 28.675 | 28.69 | 28.61 | 28.61 | 61664.0 |
| 2016-09-19 07:25:00 | AAPL | Stock | 28.61 | 28.6675 | 28.61 | 28.6675 | 47124.0 |
| 2016-09-19 07:30:00 | AAPL | Stock | 28.65 | 28.6675 | 28.65 | 28.6675 | 2668.0 |
| 2016-09-19 07:35:00 | AAPL | Stock | 28.685 | 28.685 | 28.675 | 28.685 | 2800.0 |
| 2016-09-19 07:40:00 | AAPL | Stock | 28.685 | 28.7375 | 28.685 | 28.725 | 31952.0 |
| 2016-09-19 07:45:00 | AAPL | Stock | 28.725 | 28.725 | 28.705 | 28.725 | 8800.0 |
| 2016-09-19 07:50:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7125 | 28.725 | 55972.0 |
| 2016-09-19 07:55:00 | AAPL | Stock | 28.7175 | 28.725 | 28.705 | 28.705 | 4000.0 |
| 2016-09-19 08:00:00 | AAPL | Stock | 28.72 | 28.8575 | 28.625 | 28.7 | 241264.0 |
| 2016-09-19 08:05:00 | AAPL | Stock | 28.705 | 28.7325 | 28.705 | 28.7275 | 82828.0 |
| 2016-09-19 08:10:00 | AAPL | Stock | 28.735 | 28.7875 | 28.735 | 28.785 | 138092.0 |
| 2016-09-19 08:15:00 | AAPL | Stock | 28.7825 | 28.8325 | 28.765 | 28.8275 | 94596.0 |
| 2016-09-19 08:20:00 | AAPL | Stock | 28.83 | 28.8325 | 28.805 | 28.805 | 67336.0 |
| 2016-09-19 08:25:00 | AAPL | Stock | 28.805 | 28.8525 | 28.805 | 28.8375 | 153756.0 |
| 2016-09-19 08:30:00 | AAPL | Stock | 28.8375 | 28.9025 | 28.8375 | 28.8775 | 166736.0 |
| 2016-09-19 08:35:00 | AAPL | Stock | 28.8775 | 28.8775 | 28.82 | 28.85 | 276928.0 |
| 2016-09-19 08:40:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8475 | 28.8475 | 96064.0 |
| 2016-09-19 08:45:00 | AAPL | Stock | 28.8375 | 28.845 | 28.82 | 28.8275 | 69528.0 |
| 2016-09-19 08:50:00 | AAPL | Stock | 28.83 | 28.8575 | 28.825 | 28.85 | 67340.0 |
| 2016-09-19 08:55:00 | AAPL | Stock | 28.855 | 28.8675 | 28.8525 | 28.86 | 103224.0 |
| 2016-09-19 09:00:00 | AAPL | Stock | 28.86 | 28.8625 | 28.795 | 28.8125 | 343732.0 |
> showing 50 of 349,642 rows — these rows as CSV