PREVIEW / stock_5min / 2016-11-29
file: by_date/stock_5min/2016/2016-11-29.parquet size: 5.4 MB rows: 357,036 symbols: 3,184
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-11-29 04:00:00 | AAPL | Stock | 27.8825 | 27.8825 | 27.8825 | 27.8825 | 400.0 |
| 2016-11-29 04:05:00 | AAPL | Stock | 27.8825 | 27.8825 | 27.8825 | 27.8825 | 1200.0 |
| 2016-11-29 04:20:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 400.0 |
| 2016-11-29 05:10:00 | AAPL | Stock | 27.9 | 27.9 | 27.8925 | 27.8925 | 6000.0 |
| 2016-11-29 05:20:00 | AAPL | Stock | 27.875 | 27.875 | 27.85 | 27.85 | 1680.0 |
| 2016-11-29 05:40:00 | AAPL | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 400.0 |
| 2016-11-29 06:20:00 | AAPL | Stock | 27.85 | 27.85 | 27.825 | 27.825 | 9376.0 |
| 2016-11-29 06:25:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 6328.0 |
| 2016-11-29 06:30:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 3648.0 |
| 2016-11-29 06:35:00 | AAPL | Stock | 27.835 | 27.8375 | 27.8125 | 27.8125 | 2800.0 |
| 2016-11-29 06:50:00 | AAPL | Stock | 27.835 | 27.8375 | 27.835 | 27.8375 | 8000.0 |
| 2016-11-29 06:55:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 10800.0 |
| 2016-11-29 07:00:00 | AAPL | Stock | 27.825 | 27.8375 | 27.805 | 27.8375 | 13000.0 |
| 2016-11-29 07:05:00 | AAPL | Stock | 27.83 | 27.83 | 27.83 | 27.83 | 480.0 |
| 2016-11-29 07:10:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8 | 27.8 | 2000.0 |
| 2016-11-29 07:15:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 18400.0 |
| 2016-11-29 07:20:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.8375 | 27.8375 | 7308.0 |
| 2016-11-29 07:25:00 | AAPL | Stock | 27.8275 | 27.8275 | 27.7675 | 27.7675 | 26248.0 |
| 2016-11-29 07:30:00 | AAPL | Stock | 27.77 | 27.77 | 27.7475 | 27.7475 | 16448.0 |
| 2016-11-29 07:35:00 | AAPL | Stock | 27.7525 | 27.7525 | 27.65 | 27.65 | 39452.0 |
| 2016-11-29 07:40:00 | AAPL | Stock | 27.6875 | 27.72 | 27.6875 | 27.72 | 1200.0 |
| 2016-11-29 07:45:00 | AAPL | Stock | 27.6975 | 27.6975 | 27.665 | 27.6875 | 5600.0 |
| 2016-11-29 07:50:00 | AAPL | Stock | 27.7 | 27.7125 | 27.7 | 27.7125 | 4400.0 |
| 2016-11-29 07:55:00 | AAPL | Stock | 27.7125 | 27.75 | 27.7125 | 27.725 | 22548.0 |
| 2016-11-29 08:00:00 | AAPL | Stock | 27.745 | 27.8025 | 27.665 | 27.7125 | 30064.0 |
| 2016-11-29 08:05:00 | AAPL | Stock | 27.725 | 27.725 | 27.7225 | 27.725 | 6200.0 |
| 2016-11-29 08:10:00 | AAPL | Stock | 27.725 | 27.73 | 27.6925 | 27.6925 | 82464.0 |
| 2016-11-29 08:15:00 | AAPL | Stock | 27.6925 | 27.715 | 27.6925 | 27.71 | 6480.0 |
| 2016-11-29 08:20:00 | AAPL | Stock | 27.695 | 27.715 | 27.685 | 27.7125 | 8952.0 |
| 2016-11-29 08:25:00 | AAPL | Stock | 27.735 | 27.7525 | 27.735 | 27.745 | 7040.0 |
| 2016-11-29 08:30:00 | AAPL | Stock | 27.75 | 27.75 | 27.7375 | 27.745 | 17024.0 |
| 2016-11-29 08:35:00 | AAPL | Stock | 27.75 | 27.75 | 27.725 | 27.725 | 13756.0 |
| 2016-11-29 08:40:00 | AAPL | Stock | 27.74 | 27.7425 | 27.6875 | 27.6875 | 17332.0 |
| 2016-11-29 08:45:00 | AAPL | Stock | 27.7 | 27.7 | 27.6925 | 27.7 | 24720.0 |
| 2016-11-29 08:50:00 | AAPL | Stock | 27.7 | 27.7625 | 27.6875 | 27.7325 | 90084.0 |
| 2016-11-29 08:55:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7125 | 27.7125 | 15260.0 |
| 2016-11-29 09:00:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7075 | 27.71 | 18424.0 |
| 2016-11-29 09:05:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.705 | 27.705 | 2540.0 |
| 2016-11-29 09:10:00 | AAPL | Stock | 27.7075 | 27.7125 | 27.6775 | 27.7 | 31440.0 |
| 2016-11-29 09:15:00 | AAPL | Stock | 27.7 | 27.7 | 27.6925 | 27.7 | 13224.0 |
| 2016-11-29 09:20:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.6725 | 27.675 | 73164.0 |
| 2016-11-29 09:25:00 | AAPL | Stock | 27.675 | 27.6975 | 27.65 | 27.68 | 147672.0 |
| 2016-11-29 09:30:00 | AAPL | Stock | 27.695 | 27.7625 | 27.635 | 27.6422 | 6042892.0 |
| 2016-11-29 09:35:00 | AAPL | Stock | 27.6422 | 27.6638 | 27.5675 | 27.6575 | 4002192.0 |
| 2016-11-29 09:40:00 | AAPL | Stock | 27.6575 | 27.72 | 27.635 | 27.6922 | 2692588.0 |
| 2016-11-29 09:45:00 | AAPL | Stock | 27.69 | 27.6925 | 27.62 | 27.6362 | 2869444.0 |
| 2016-11-29 09:50:00 | AAPL | Stock | 27.6375 | 27.645 | 27.5675 | 27.57 | 2567012.0 |
| 2016-11-29 09:55:00 | AAPL | Stock | 27.5688 | 27.61 | 27.5525 | 27.575 | 2172440.0 |
| 2016-11-29 10:00:00 | AAPL | Stock | 27.5775 | 27.6075 | 27.5175 | 27.5475 | 2780216.0 |
| 2016-11-29 10:05:00 | AAPL | Stock | 27.55 | 27.6088 | 27.535 | 27.595 | 1804508.0 |
> showing 50 of 357,036 rows — these rows as CSV