PREVIEW / stock_5min / 2016-02-02
file: by_date/stock_5min/2016/2016-02-02.parquet size: 5.3 MB rows: 356,721 symbols: 3,366
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-02 04:05:00 | AAPL | Stock | 23.9675 | 23.9675 | 23.9675 | 23.9675 | 400.0 |
| 2016-02-02 04:15:00 | AAPL | Stock | 23.9375 | 23.9375 | 23.9375 | 23.9375 | 400.0 |
| 2016-02-02 04:20:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8825 | 23.8825 | 800.0 |
| 2016-02-02 04:35:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.85 | 23.85 | 1628.0 |
| 2016-02-02 04:40:00 | AAPL | Stock | 23.85 | 23.85 | 23.85 | 23.85 | 844.0 |
| 2016-02-02 04:50:00 | AAPL | Stock | 23.8075 | 23.835 | 23.8025 | 23.835 | 2400.0 |
| 2016-02-02 05:15:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.8775 | 23.8775 | 520.0 |
| 2016-02-02 05:20:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.8175 | 23.8175 | 800.0 |
| 2016-02-02 06:15:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 800.0 |
| 2016-02-02 06:20:00 | AAPL | Stock | 23.805 | 23.805 | 23.7775 | 23.7775 | 27704.0 |
| 2016-02-02 06:30:00 | AAPL | Stock | 23.8475 | 23.85 | 23.8475 | 23.85 | 7716.0 |
| 2016-02-02 06:40:00 | AAPL | Stock | 23.9125 | 23.9125 | 23.9125 | 23.9125 | 600.0 |
| 2016-02-02 06:45:00 | AAPL | Stock | 23.91 | 23.91 | 23.91 | 23.91 | 1600.0 |
| 2016-02-02 07:00:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8275 | 23.8275 | 4000.0 |
| 2016-02-02 07:10:00 | AAPL | Stock | 23.875 | 23.875 | 23.875 | 23.875 | 1600.0 |
| 2016-02-02 07:15:00 | AAPL | Stock | 23.83 | 23.875 | 23.83 | 23.875 | 2800.0 |
| 2016-02-02 07:25:00 | AAPL | Stock | 23.8825 | 23.8825 | 23.875 | 23.875 | 5800.0 |
| 2016-02-02 07:30:00 | AAPL | Stock | 23.8375 | 23.85 | 23.8375 | 23.8375 | 7700.0 |
| 2016-02-02 07:35:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.825 | 23.825 | 10400.0 |
| 2016-02-02 07:40:00 | AAPL | Stock | 23.8125 | 23.8325 | 23.8125 | 23.8325 | 4028.0 |
| 2016-02-02 07:45:00 | AAPL | Stock | 23.8175 | 23.8375 | 23.8175 | 23.8375 | 1964.0 |
| 2016-02-02 07:50:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.835 | 23.8375 | 9200.0 |
| 2016-02-02 07:55:00 | AAPL | Stock | 23.835 | 23.835 | 23.835 | 23.835 | 2780.0 |
| 2016-02-02 08:00:00 | AAPL | Stock | 23.84 | 23.89 | 23.815 | 23.8875 | 25476.0 |
| 2016-02-02 08:05:00 | AAPL | Stock | 23.875 | 23.88 | 23.875 | 23.88 | 12000.0 |
| 2016-02-02 08:10:00 | AAPL | Stock | 23.88 | 23.9 | 23.8675 | 23.8725 | 73672.0 |
| 2016-02-02 08:15:00 | AAPL | Stock | 23.8725 | 23.875 | 23.8525 | 23.875 | 34316.0 |
| 2016-02-02 08:20:00 | AAPL | Stock | 23.875 | 23.88 | 23.8375 | 23.8375 | 64648.0 |
| 2016-02-02 08:25:00 | AAPL | Stock | 23.83 | 23.85 | 23.83 | 23.85 | 19120.0 |
| 2016-02-02 08:30:00 | AAPL | Stock | 23.86 | 24.1075 | 23.8475 | 23.85 | 68016.0 |
| 2016-02-02 08:35:00 | AAPL | Stock | 23.86 | 23.86 | 23.8225 | 23.8275 | 65640.0 |
| 2016-02-02 08:40:00 | AAPL | Stock | 23.825 | 23.835 | 23.8125 | 23.835 | 21368.0 |
| 2016-02-02 08:45:00 | AAPL | Stock | 23.84 | 23.85 | 23.8375 | 23.85 | 28204.0 |
| 2016-02-02 08:50:00 | AAPL | Stock | 23.8425 | 23.8425 | 23.815 | 23.8425 | 6636.0 |
| 2016-02-02 08:55:00 | AAPL | Stock | 23.835 | 23.85 | 23.805 | 23.85 | 61580.0 |
| 2016-02-02 09:00:00 | AAPL | Stock | 23.835 | 23.8725 | 23.835 | 23.8625 | 45612.0 |
| 2016-02-02 09:05:00 | AAPL | Stock | 23.8625 | 23.8625 | 23.845 | 23.85 | 49796.0 |
| 2016-02-02 09:10:00 | AAPL | Stock | 23.8375 | 23.875 | 23.825 | 23.875 | 44240.0 |
| 2016-02-02 09:15:00 | AAPL | Stock | 23.855 | 23.855 | 23.8375 | 23.8525 | 25320.0 |
| 2016-02-02 09:20:00 | AAPL | Stock | 23.8575 | 23.9 | 23.8525 | 23.8825 | 34304.0 |
| 2016-02-02 09:25:00 | AAPL | Stock | 23.9 | 23.9125 | 23.8475 | 23.8675 | 82212.0 |
| 2016-02-02 09:30:00 | AAPL | Stock | 23.855 | 23.9975 | 23.82 | 23.995 | 4731144.0 |
| 2016-02-02 09:35:00 | AAPL | Stock | 23.995 | 24.01 | 23.8775 | 23.8947 | 2755316.0 |
| 2016-02-02 09:40:00 | AAPL | Stock | 23.8925 | 23.9375 | 23.865 | 23.8875 | 2531344.0 |
| 2016-02-02 09:45:00 | AAPL | Stock | 23.8875 | 23.892 | 23.7625 | 23.7725 | 3606252.0 |
| 2016-02-02 09:50:00 | AAPL | Stock | 23.77 | 23.8098 | 23.765 | 23.795 | 2260608.0 |
| 2016-02-02 09:55:00 | AAPL | Stock | 23.795 | 23.8675 | 23.775 | 23.8225 | 2494216.0 |
| 2016-02-02 10:00:00 | AAPL | Stock | 23.8225 | 23.887 | 23.8025 | 23.87 | 2057232.0 |
| 2016-02-02 10:05:00 | AAPL | Stock | 23.87 | 23.9125 | 23.8525 | 23.9 | 1882188.0 |
| 2016-02-02 10:10:00 | AAPL | Stock | 23.9 | 23.9 | 23.8375 | 23.8438 | 1500076.0 |
> showing 50 of 356,721 rows — these rows as CSV