PREVIEW / stock_5min / 2016-02-09
file: by_date/stock_5min/2016/2016-02-09.parquet size: 5.5 MB rows: 366,974 symbols: 3,347
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-02-09 04:00:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 1200.0 |
| 2016-02-09 04:05:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 800.0 |
| 2016-02-09 04:10:00 | AAPL | Stock | 23.6875 | 23.75 | 23.6875 | 23.75 | 14108.0 |
| 2016-02-09 05:00:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 400.0 |
| 2016-02-09 05:10:00 | AAPL | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 400.0 |
| 2016-02-09 05:30:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 880.0 |
| 2016-02-09 05:45:00 | AAPL | Stock | 23.7475 | 23.7475 | 23.7475 | 23.7475 | 800.0 |
| 2016-02-09 05:55:00 | AAPL | Stock | 23.7 | 23.7 | 23.69 | 23.69 | 2720.0 |
| 2016-02-09 06:00:00 | AAPL | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 1120.0 |
| 2016-02-09 06:05:00 | AAPL | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 1540.0 |
| 2016-02-09 06:20:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.65 | 23.65 | 2860.0 |
| 2016-02-09 06:25:00 | AAPL | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 680.0 |
| 2016-02-09 07:00:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 2000.0 |
| 2016-02-09 07:05:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 1708.0 |
| 2016-02-09 07:10:00 | AAPL | Stock | 23.6 | 23.6 | 23.5875 | 23.6 | 5464.0 |
| 2016-02-09 07:15:00 | AAPL | Stock | 23.6 | 23.6 | 23.5875 | 23.5875 | 5600.0 |
| 2016-02-09 07:20:00 | AAPL | Stock | 23.575 | 23.575 | 23.575 | 23.575 | 8000.0 |
| 2016-02-09 07:25:00 | AAPL | Stock | 23.58 | 23.58 | 23.58 | 23.58 | 400.0 |
| 2016-02-09 07:35:00 | AAPL | Stock | 23.5925 | 23.5925 | 23.5925 | 23.5925 | 400.0 |
| 2016-02-09 07:40:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.5475 | 23.5475 | 7200.0 |
| 2016-02-09 07:45:00 | AAPL | Stock | 23.5275 | 23.555 | 23.5275 | 23.5375 | 14604.0 |
| 2016-02-09 07:50:00 | AAPL | Stock | 23.5425 | 23.555 | 23.5425 | 23.555 | 5324.0 |
| 2016-02-09 07:55:00 | AAPL | Stock | 23.5425 | 23.5625 | 23.5425 | 23.56 | 13112.0 |
| 2016-02-09 08:00:00 | AAPL | Stock | 23.58 | 23.6 | 23.5425 | 23.5975 | 57436.0 |
| 2016-02-09 08:05:00 | AAPL | Stock | 23.595 | 23.595 | 23.5625 | 23.5625 | 31296.0 |
| 2016-02-09 08:10:00 | AAPL | Stock | 23.56 | 23.5675 | 23.535 | 23.5375 | 65856.0 |
| 2016-02-09 08:15:00 | AAPL | Stock | 23.53 | 23.565 | 23.525 | 23.5475 | 80276.0 |
| 2016-02-09 08:20:00 | AAPL | Stock | 23.5375 | 23.56 | 23.5375 | 23.56 | 15544.0 |
| 2016-02-09 08:25:00 | AAPL | Stock | 23.55 | 23.5575 | 23.5375 | 23.55 | 84892.0 |
| 2016-02-09 08:30:00 | AAPL | Stock | 23.555 | 23.555 | 23.5375 | 23.55 | 88828.0 |
| 2016-02-09 08:35:00 | AAPL | Stock | 23.5425 | 23.565 | 23.5375 | 23.5375 | 57312.0 |
| 2016-02-09 08:40:00 | AAPL | Stock | 23.5375 | 23.5875 | 23.5375 | 23.575 | 95264.0 |
| 2016-02-09 08:45:00 | AAPL | Stock | 23.5875 | 23.5975 | 23.575 | 23.5775 | 25140.0 |
| 2016-02-09 08:50:00 | AAPL | Stock | 23.5875 | 23.6125 | 23.5775 | 23.5775 | 37192.0 |
| 2016-02-09 08:55:00 | AAPL | Stock | 23.575 | 23.5875 | 23.5675 | 23.5875 | 24244.0 |
| 2016-02-09 09:00:00 | AAPL | Stock | 23.5875 | 23.5975 | 23.565 | 23.565 | 36072.0 |
| 2016-02-09 09:05:00 | AAPL | Stock | 23.5675 | 23.57 | 23.5575 | 23.56 | 15148.0 |
| 2016-02-09 09:10:00 | AAPL | Stock | 23.56 | 23.5875 | 23.5575 | 23.5875 | 36668.0 |
| 2016-02-09 09:15:00 | AAPL | Stock | 23.5875 | 23.6 | 23.5525 | 23.5525 | 28100.0 |
| 2016-02-09 09:20:00 | AAPL | Stock | 23.55 | 23.55 | 23.5375 | 23.5375 | 28908.0 |
| 2016-02-09 09:25:00 | AAPL | Stock | 23.54 | 23.5875 | 23.54 | 23.5725 | 93904.0 |
| 2016-02-09 09:30:00 | AAPL | Stock | 23.5725 | 23.6725 | 23.5175 | 23.642 | 4532876.0 |
| 2016-02-09 09:35:00 | AAPL | Stock | 23.64 | 23.8225 | 23.58 | 23.775 | 3740276.0 |
| 2016-02-09 09:40:00 | AAPL | Stock | 23.77 | 23.7925 | 23.6775 | 23.7325 | 4083820.0 |
| 2016-02-09 09:45:00 | AAPL | Stock | 23.7275 | 23.8375 | 23.7 | 23.8275 | 4619980.0 |
| 2016-02-09 09:50:00 | AAPL | Stock | 23.8275 | 23.845 | 23.75 | 23.825 | 3646468.0 |
| 2016-02-09 09:55:00 | AAPL | Stock | 23.8275 | 23.829 | 23.6875 | 23.695 | 2754436.0 |
| 2016-02-09 10:00:00 | AAPL | Stock | 23.695 | 23.7725 | 23.6375 | 23.6775 | 3630928.0 |
| 2016-02-09 10:05:00 | AAPL | Stock | 23.6775 | 23.82 | 23.645 | 23.785 | 3835420.0 |
| 2016-02-09 10:10:00 | AAPL | Stock | 23.785 | 23.7975 | 23.665 | 23.6725 | 2876008.0 |
> showing 50 of 366,974 rows — these rows as CSV