PREVIEW / stock_1min / 2016-07-28
file: by_date/stock_1min/2016/2016-07-28.parquet size: 14.2 MB rows: 1,038,363 symbols: 2,671
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-28 04:00:00 | AAPL | Stock | 25.85 | 25.875 | 25.85 | 25.875 | 2320.0 |
| 2016-07-28 04:05:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 7600.0 |
| 2016-07-28 04:07:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1600.0 |
| 2016-07-28 04:30:00 | AAPL | Stock | 25.8025 | 25.8025 | 25.8 | 25.8 | 2000.0 |
| 2016-07-28 04:35:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8125 | 25.8125 | 1144.0 |
| 2016-07-28 04:38:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8125 | 25.8125 | 1600.0 |
| 2016-07-28 04:51:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1028.0 |
| 2016-07-28 04:57:00 | AAPL | Stock | 25.8025 | 25.8025 | 25.8025 | 25.8025 | 1200.0 |
| 2016-07-28 05:04:00 | AAPL | Stock | 25.8075 | 25.8075 | 25.8 | 25.8 | 6200.0 |
| 2016-07-28 05:05:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8125 | 25.8125 | 2000.0 |
| 2016-07-28 05:06:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8125 | 25.8125 | 1200.0 |
| 2016-07-28 05:09:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 3200.0 |
| 2016-07-28 05:20:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 760.0 |
| 2016-07-28 05:22:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 400.0 |
| 2016-07-28 05:23:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 400.0 |
| 2016-07-28 05:25:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 400.0 |
| 2016-07-28 05:37:00 | AAPL | Stock | 25.7775 | 25.7775 | 25.7775 | 25.7775 | 1200.0 |
| 2016-07-28 05:45:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 644.0 |
| 2016-07-28 05:58:00 | AAPL | Stock | 25.81 | 25.8325 | 25.7825 | 25.7825 | 6064.0 |
| 2016-07-28 06:35:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.7875 | 25.7875 | 1392.0 |
| 2016-07-28 06:44:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 2116.0 |
| 2016-07-28 06:45:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 1044.0 |
| 2016-07-28 06:54:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 1200.0 |
| 2016-07-28 06:55:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.78 | 25.78 | 4144.0 |
| 2016-07-28 07:04:00 | AAPL | Stock | 25.765 | 25.765 | 25.76 | 25.76 | 8800.0 |
| 2016-07-28 07:05:00 | AAPL | Stock | 25.76 | 25.76 | 25.76 | 25.76 | 2800.0 |
| 2016-07-28 07:07:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 4000.0 |
| 2016-07-28 07:09:00 | AAPL | Stock | 25.755 | 25.755 | 25.7375 | 25.7375 | 5800.0 |
| 2016-07-28 07:10:00 | AAPL | Stock | 25.7375 | 25.7675 | 25.7375 | 25.7675 | 13740.0 |
| 2016-07-28 07:12:00 | AAPL | Stock | 25.7375 | 25.7375 | 25.735 | 25.735 | 3640.0 |
| 2016-07-28 07:14:00 | AAPL | Stock | 25.735 | 25.735 | 25.735 | 25.735 | 2000.0 |
| 2016-07-28 07:18:00 | AAPL | Stock | 25.7425 | 25.745 | 25.7425 | 25.745 | 4400.0 |
| 2016-07-28 07:22:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 1576.0 |
| 2016-07-28 07:28:00 | AAPL | Stock | 25.7475 | 25.7475 | 25.7475 | 25.7475 | 2000.0 |
| 2016-07-28 07:31:00 | AAPL | Stock | 25.745 | 25.745 | 25.745 | 25.745 | 1724.0 |
| 2016-07-28 07:33:00 | AAPL | Stock | 25.745 | 25.7525 | 25.745 | 25.7525 | 4032.0 |
| 2016-07-28 07:34:00 | AAPL | Stock | 25.775 | 25.785 | 25.775 | 25.785 | 1596.0 |
| 2016-07-28 07:35:00 | AAPL | Stock | 25.785 | 25.785 | 25.785 | 25.785 | 4164.0 |
| 2016-07-28 07:39:00 | AAPL | Stock | 25.775 | 25.775 | 25.775 | 25.775 | 2000.0 |
| 2016-07-28 07:42:00 | AAPL | Stock | 25.755 | 25.755 | 25.7525 | 25.7525 | 2172.0 |
| 2016-07-28 07:43:00 | AAPL | Stock | 25.755 | 25.755 | 25.74 | 25.74 | 14640.0 |
| 2016-07-28 07:45:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 400.0 |
| 2016-07-28 07:46:00 | AAPL | Stock | 25.745 | 25.745 | 25.74 | 25.74 | 3400.0 |
| 2016-07-28 07:48:00 | AAPL | Stock | 25.74 | 25.74 | 25.7375 | 25.7375 | 9200.0 |
| 2016-07-28 07:50:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 840.0 |
| 2016-07-28 07:54:00 | AAPL | Stock | 25.7375 | 25.7375 | 25.725 | 25.725 | 13280.0 |
| 2016-07-28 07:56:00 | AAPL | Stock | 25.725 | 25.725 | 25.7025 | 25.7025 | 3844.0 |
| 2016-07-28 07:57:00 | AAPL | Stock | 25.7225 | 25.7225 | 25.7225 | 25.7225 | 1400.0 |
| 2016-07-28 08:00:00 | AAPL | Stock | 25.7225 | 25.77 | 25.7125 | 25.77 | 33840.0 |
| 2016-07-28 08:01:00 | AAPL | Stock | 25.675 | 25.7375 | 25.675 | 25.7375 | 4632.0 |
> showing 50 of 1,038,363 rows — these rows as CSV