PREVIEW / stock_5min / 2016-07-05
file: by_date/stock_5min/2016/2016-07-05.parquet size: 5.4 MB rows: 358,797 symbols: 3,255
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-07-05 04:00:00 | AAPL | Stock | 23.95 | 23.95 | 23.85 | 23.85 | 19600.0 |
| 2016-07-05 04:05:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 1200.0 |
| 2016-07-05 04:15:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 800.0 |
| 2016-07-05 04:25:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.8175 | 23.8175 | 2708.0 |
| 2016-07-05 04:30:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 800.0 |
| 2016-07-05 04:35:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 400.0 |
| 2016-07-05 05:00:00 | AAPL | Stock | 23.79 | 23.79 | 23.7875 | 23.7875 | 5888.0 |
| 2016-07-05 05:05:00 | AAPL | Stock | 23.785 | 23.785 | 23.755 | 23.755 | 5720.0 |
| 2016-07-05 05:15:00 | AAPL | Stock | 23.73 | 23.73 | 23.73 | 23.73 | 7300.0 |
| 2016-07-05 05:20:00 | AAPL | Stock | 23.7625 | 23.77 | 23.7625 | 23.77 | 2400.0 |
| 2016-07-05 05:35:00 | AAPL | Stock | 23.7475 | 23.7475 | 23.7475 | 23.7475 | 668.0 |
| 2016-07-05 05:45:00 | AAPL | Stock | 23.725 | 23.725 | 23.7175 | 23.7175 | 20128.0 |
| 2016-07-05 05:50:00 | AAPL | Stock | 23.7275 | 23.7475 | 23.7275 | 23.7475 | 5200.0 |
| 2016-07-05 06:10:00 | AAPL | Stock | 23.745 | 23.745 | 23.745 | 23.745 | 5948.0 |
| 2016-07-05 06:15:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 1800.0 |
| 2016-07-05 06:20:00 | AAPL | Stock | 23.745 | 23.745 | 23.745 | 23.745 | 4000.0 |
| 2016-07-05 06:35:00 | AAPL | Stock | 23.7275 | 23.75 | 23.7275 | 23.7275 | 1200.0 |
| 2016-07-05 06:40:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 4400.0 |
| 2016-07-05 06:45:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 800.0 |
| 2016-07-05 06:50:00 | AAPL | Stock | 23.7475 | 23.7475 | 23.735 | 23.735 | 2400.0 |
| 2016-07-05 06:55:00 | AAPL | Stock | 23.755 | 23.7575 | 23.755 | 23.7575 | 7400.0 |
| 2016-07-05 07:00:00 | AAPL | Stock | 23.7725 | 23.775 | 23.7725 | 23.775 | 5200.0 |
| 2016-07-05 07:05:00 | AAPL | Stock | 23.79 | 23.795 | 23.7875 | 23.7875 | 46276.0 |
| 2016-07-05 07:10:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 1840.0 |
| 2016-07-05 07:15:00 | AAPL | Stock | 23.7775 | 23.8 | 23.755 | 23.775 | 60064.0 |
| 2016-07-05 07:20:00 | AAPL | Stock | 23.755 | 23.755 | 23.745 | 23.745 | 3892.0 |
| 2016-07-05 07:25:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.7575 | 23.7575 | 1680.0 |
| 2016-07-05 07:30:00 | AAPL | Stock | 23.7675 | 23.7675 | 23.7275 | 23.7275 | 50080.0 |
| 2016-07-05 07:35:00 | AAPL | Stock | 23.725 | 23.725 | 23.7125 | 23.7125 | 12956.0 |
| 2016-07-05 07:40:00 | AAPL | Stock | 23.7225 | 23.735 | 23.7225 | 23.735 | 5696.0 |
| 2016-07-05 07:45:00 | AAPL | Stock | 23.7225 | 23.75 | 23.7225 | 23.7475 | 5000.0 |
| 2016-07-05 07:50:00 | AAPL | Stock | 23.745 | 23.745 | 23.7375 | 23.745 | 7600.0 |
| 2016-07-05 07:55:00 | AAPL | Stock | 23.7475 | 23.7475 | 23.74 | 23.74 | 1996.0 |
| 2016-07-05 08:00:00 | AAPL | Stock | 23.7512 | 23.8 | 23.7275 | 23.78 | 68532.0 |
| 2016-07-05 08:05:00 | AAPL | Stock | 23.765 | 23.815 | 23.7625 | 23.815 | 42436.0 |
| 2016-07-05 08:10:00 | AAPL | Stock | 23.7975 | 23.7975 | 23.795 | 23.7975 | 4400.0 |
| 2016-07-05 08:15:00 | AAPL | Stock | 23.7975 | 23.8 | 23.7975 | 23.7975 | 6400.0 |
| 2016-07-05 08:20:00 | AAPL | Stock | 23.7925 | 23.7975 | 23.7875 | 23.79 | 6600.0 |
| 2016-07-05 08:25:00 | AAPL | Stock | 23.79 | 23.7975 | 23.79 | 23.795 | 6040.0 |
| 2016-07-05 08:30:00 | AAPL | Stock | 23.795 | 23.8125 | 23.795 | 23.8125 | 10200.0 |
| 2016-07-05 08:35:00 | AAPL | Stock | 23.805 | 23.8075 | 23.7975 | 23.7975 | 5040.0 |
| 2016-07-05 08:40:00 | AAPL | Stock | 23.8125 | 23.83 | 23.8125 | 23.8175 | 16080.0 |
| 2016-07-05 08:45:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.7975 | 23.8 | 35140.0 |
| 2016-07-05 08:50:00 | AAPL | Stock | 23.8 | 23.81 | 23.7875 | 23.7875 | 50520.0 |
| 2016-07-05 08:55:00 | AAPL | Stock | 23.8025 | 23.8075 | 23.8 | 23.8075 | 48408.0 |
| 2016-07-05 09:00:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.7875 | 23.7975 | 14384.0 |
| 2016-07-05 09:05:00 | AAPL | Stock | 23.7975 | 23.815 | 23.7875 | 23.815 | 11000.0 |
| 2016-07-05 09:10:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.785 | 23.785 | 22880.0 |
| 2016-07-05 09:15:00 | AAPL | Stock | 23.8 | 23.8 | 23.79 | 23.79 | 10824.0 |
| 2016-07-05 09:20:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 5404.0 |
> showing 50 of 358,797 rows — these rows as CSV