PREVIEW / stock_1min / 2015-08-07
file: by_date/stock_1min/2015/2015-08-07.parquet size: 15.2 MB rows: 1,101,068 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-07 04:04:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 2000.0 |
| 2015-08-07 04:05:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 1200.0 |
| 2015-08-07 04:11:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 400.0 |
| 2015-08-07 04:14:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 1080.0 |
| 2015-08-07 04:15:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 4612.0 |
| 2015-08-07 05:07:00 | AAPL | Stock | 28.82 | 28.82 | 28.82 | 28.82 | 692.0 |
| 2015-08-07 05:15:00 | AAPL | Stock | 28.775 | 28.775 | 28.775 | 28.775 | 3200.0 |
| 2015-08-07 05:36:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7875 | 28.7875 | 1200.0 |
| 2015-08-07 05:41:00 | AAPL | Stock | 28.775 | 28.775 | 28.775 | 28.775 | 776.0 |
| 2015-08-07 06:13:00 | AAPL | Stock | 28.7725 | 28.775 | 28.7725 | 28.775 | 1100.0 |
| 2015-08-07 06:16:00 | AAPL | Stock | 28.765 | 28.765 | 28.765 | 28.765 | 664.0 |
| 2015-08-07 06:17:00 | AAPL | Stock | 28.7325 | 28.75 | 28.73 | 28.75 | 8164.0 |
| 2015-08-07 06:26:00 | AAPL | Stock | 28.77 | 28.77 | 28.77 | 28.77 | 440.0 |
| 2015-08-07 06:30:00 | AAPL | Stock | 28.75 | 28.75 | 28.7475 | 28.7475 | 2800.0 |
| 2015-08-07 06:32:00 | AAPL | Stock | 28.77 | 28.77 | 28.77 | 28.77 | 988.0 |
| 2015-08-07 06:39:00 | AAPL | Stock | 28.75 | 28.75 | 28.75 | 28.75 | 560.0 |
| 2015-08-07 06:50:00 | AAPL | Stock | 28.7125 | 28.7125 | 28.7125 | 28.7125 | 1120.0 |
| 2015-08-07 06:54:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7375 | 28.7375 | 400.0 |
| 2015-08-07 06:58:00 | AAPL | Stock | 28.75 | 28.75 | 28.75 | 28.75 | 488.0 |
| 2015-08-07 07:00:00 | AAPL | Stock | 28.725 | 28.725 | 28.725 | 28.725 | 600.0 |
| 2015-08-07 07:02:00 | AAPL | Stock | 28.72 | 28.72 | 28.72 | 28.72 | 400.0 |
| 2015-08-07 07:09:00 | AAPL | Stock | 28.725 | 28.7375 | 28.71 | 28.7375 | 3472.0 |
| 2015-08-07 07:12:00 | AAPL | Stock | 28.71 | 28.7225 | 28.71 | 28.7225 | 5808.0 |
| 2015-08-07 07:15:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7375 | 28.7375 | 1448.0 |
| 2015-08-07 07:19:00 | AAPL | Stock | 28.73 | 28.73 | 28.73 | 28.73 | 432.0 |
| 2015-08-07 07:21:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7375 | 28.7375 | 400.0 |
| 2015-08-07 07:22:00 | AAPL | Stock | 28.7275 | 28.7275 | 28.725 | 28.725 | 3156.0 |
| 2015-08-07 07:27:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7375 | 28.7375 | 400.0 |
| 2015-08-07 07:28:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.7375 | 28.7375 | 2000.0 |
| 2015-08-07 07:29:00 | AAPL | Stock | 28.7275 | 28.7275 | 28.725 | 28.725 | 12400.0 |
| 2015-08-07 07:33:00 | AAPL | Stock | 28.725 | 28.725 | 28.725 | 28.725 | 13088.0 |
| 2015-08-07 07:38:00 | AAPL | Stock | 28.715 | 28.715 | 28.7125 | 28.7125 | 1600.0 |
| 2015-08-07 07:42:00 | AAPL | Stock | 28.7125 | 28.7125 | 28.7125 | 28.7125 | 1600.0 |
| 2015-08-07 07:43:00 | AAPL | Stock | 28.7125 | 28.7125 | 28.7125 | 28.7125 | 1500.0 |
| 2015-08-07 07:44:00 | AAPL | Stock | 28.7075 | 28.7075 | 28.7075 | 28.7075 | 2400.0 |
| 2015-08-07 07:47:00 | AAPL | Stock | 28.72 | 28.7225 | 28.72 | 28.7225 | 880.0 |
| 2015-08-07 07:48:00 | AAPL | Stock | 28.73 | 28.73 | 28.73 | 28.73 | 800.0 |
| 2015-08-07 07:54:00 | AAPL | Stock | 28.7175 | 28.7175 | 28.7125 | 28.7125 | 2940.0 |
| 2015-08-07 07:57:00 | AAPL | Stock | 28.71 | 28.71 | 28.71 | 28.71 | 3968.0 |
| 2015-08-07 07:59:00 | AAPL | Stock | 28.7125 | 28.7125 | 28.7125 | 28.7125 | 800.0 |
| 2015-08-07 08:00:00 | AAPL | Stock | 28.7125 | 28.7625 | 28.7075 | 28.7218 | 27684.0 |
| 2015-08-07 08:01:00 | AAPL | Stock | 28.71 | 28.7125 | 28.7075 | 28.7075 | 18000.0 |
| 2015-08-07 08:02:00 | AAPL | Stock | 28.71 | 28.7125 | 28.71 | 28.71 | 6400.0 |
| 2015-08-07 08:03:00 | AAPL | Stock | 28.71 | 28.7125 | 28.71 | 28.7125 | 7680.0 |
| 2015-08-07 08:04:00 | AAPL | Stock | 28.715 | 28.715 | 28.715 | 28.715 | 14400.0 |
| 2015-08-07 08:05:00 | AAPL | Stock | 28.715 | 28.715 | 28.7075 | 28.7075 | 14200.0 |
| 2015-08-07 08:06:00 | AAPL | Stock | 28.7075 | 28.7075 | 28.705 | 28.705 | 5412.0 |
| 2015-08-07 08:07:00 | AAPL | Stock | 28.705 | 28.7075 | 28.705 | 28.7075 | 27600.0 |
| 2015-08-07 08:08:00 | AAPL | Stock | 28.7025 | 28.7025 | 28.7 | 28.7 | 5600.0 |
| 2015-08-07 08:09:00 | AAPL | Stock | 28.7 | 28.7 | 28.685 | 28.685 | 8408.0 |
> showing 50 of 1,101,068 rows — these rows as CSV