PREVIEW / stock_1min / 2015-10-14
file: by_date/stock_1min/2015/2015-10-14.parquet size: 14.1 MB rows: 1,035,903 symbols: 2,773
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-10-14 04:00:00 | AAPL | Stock | 27.9525 | 27.9525 | 27.8225 | 27.8225 | 800.0 |
| 2015-10-14 05:59:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 400.0 |
| 2015-10-14 06:03:00 | AAPL | Stock | 27.825 | 27.825 | 27.825 | 27.825 | 400.0 |
| 2015-10-14 06:14:00 | AAPL | Stock | 27.8375 | 27.8375 | 27.825 | 27.825 | 50128.0 |
| 2015-10-14 06:15:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.775 | 27.775 | 2000.0 |
| 2015-10-14 06:16:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 800.0 |
| 2015-10-14 06:26:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 800.0 |
| 2015-10-14 06:29:00 | AAPL | Stock | 27.7675 | 27.78 | 27.7575 | 27.775 | 7200.0 |
| 2015-10-14 06:30:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 800.0 |
| 2015-10-14 06:31:00 | AAPL | Stock | 27.775 | 27.775 | 27.75 | 27.75 | 15692.0 |
| 2015-10-14 06:33:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 130684.0 |
| 2015-10-14 06:35:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 1532.0 |
| 2015-10-14 06:42:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.8125 | 27.8125 | 400.0 |
| 2015-10-14 07:10:00 | AAPL | Stock | 27.795 | 27.795 | 27.795 | 27.795 | 800.0 |
| 2015-10-14 07:12:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 400.0 |
| 2015-10-14 07:14:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.775 | 27.775 | 2800.0 |
| 2015-10-14 07:15:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 1200.0 |
| 2015-10-14 07:16:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 2000.0 |
| 2015-10-14 07:19:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.7825 | 27.7825 | 400.0 |
| 2015-10-14 07:21:00 | AAPL | Stock | 27.7825 | 27.7925 | 27.7825 | 27.7925 | 3200.0 |
| 2015-10-14 07:24:00 | AAPL | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 1200.0 |
| 2015-10-14 07:25:00 | AAPL | Stock | 27.79 | 27.79 | 27.79 | 27.79 | 1600.0 |
| 2015-10-14 07:27:00 | AAPL | Stock | 27.7925 | 27.7925 | 27.7875 | 27.7875 | 3600.0 |
| 2015-10-14 07:31:00 | AAPL | Stock | 27.79 | 27.7925 | 27.7625 | 27.7625 | 18000.0 |
| 2015-10-14 07:34:00 | AAPL | Stock | 27.7725 | 27.7725 | 27.7725 | 27.7725 | 912.0 |
| 2015-10-14 07:37:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.7525 | 27.7525 | 12724.0 |
| 2015-10-14 07:41:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 400.0 |
| 2015-10-14 07:42:00 | AAPL | Stock | 27.7775 | 27.7775 | 27.775 | 27.7775 | 6080.0 |
| 2015-10-14 07:43:00 | AAPL | Stock | 27.7775 | 27.78 | 27.7775 | 27.7775 | 16400.0 |
| 2015-10-14 07:44:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 1200.0 |
| 2015-10-14 07:45:00 | AAPL | Stock | 27.775 | 27.775 | 27.745 | 27.745 | 39916.0 |
| 2015-10-14 07:46:00 | AAPL | Stock | 27.7475 | 27.7475 | 27.7275 | 27.7275 | 30240.0 |
| 2015-10-14 07:47:00 | AAPL | Stock | 27.7275 | 27.7375 | 27.7275 | 27.7375 | 1600.0 |
| 2015-10-14 07:48:00 | AAPL | Stock | 27.7375 | 27.7375 | 27.72 | 27.72 | 5600.0 |
| 2015-10-14 07:49:00 | AAPL | Stock | 27.7025 | 27.72 | 27.7025 | 27.72 | 2400.0 |
| 2015-10-14 07:50:00 | AAPL | Stock | 27.735 | 27.75 | 27.735 | 27.75 | 10120.0 |
| 2015-10-14 07:51:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 4000.0 |
| 2015-10-14 07:54:00 | AAPL | Stock | 27.75 | 27.75 | 27.735 | 27.735 | 73568.0 |
| 2015-10-14 07:55:00 | AAPL | Stock | 27.7325 | 27.7325 | 27.7125 | 27.715 | 23652.0 |
| 2015-10-14 07:56:00 | AAPL | Stock | 27.725 | 27.725 | 27.7125 | 27.7125 | 9600.0 |
| 2015-10-14 07:57:00 | AAPL | Stock | 27.725 | 27.7375 | 27.725 | 27.7375 | 5040.0 |
| 2015-10-14 07:58:00 | AAPL | Stock | 27.7525 | 27.7575 | 27.75 | 27.7575 | 1400.0 |
| 2015-10-14 07:59:00 | AAPL | Stock | 27.765 | 27.765 | 27.765 | 27.765 | 400.0 |
| 2015-10-14 08:00:00 | AAPL | Stock | 27.8425 | 27.8425 | 27.755 | 27.7725 | 37780.0 |
| 2015-10-14 08:01:00 | AAPL | Stock | 27.775 | 27.785 | 27.775 | 27.775 | 21920.0 |
| 2015-10-14 08:02:00 | AAPL | Stock | 27.775 | 27.78 | 27.775 | 27.775 | 7708.0 |
| 2015-10-14 08:03:00 | AAPL | Stock | 27.7725 | 27.7725 | 27.7725 | 27.7725 | 932.0 |
| 2015-10-14 08:04:00 | AAPL | Stock | 27.775 | 27.78 | 27.77 | 27.78 | 12320.0 |
| 2015-10-14 08:05:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 2400.0 |
| 2015-10-14 08:06:00 | AAPL | Stock | 27.77 | 27.775 | 27.7675 | 27.7675 | 13600.0 |
> showing 50 of 1,035,903 rows — these rows as CSV