PREVIEW / stock_1min / 2014-10-30
file: by_date/stock_1min/2014/2014-10-30.parquet size: 13.7 MB rows: 998,784 symbols: 2,897
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-30 04:00:00 | AAPL | Stock | 26.8 | 26.8125 | 26.8 | 26.8125 | 4000.0 |
| 2014-10-30 04:05:00 | AAPL | Stock | 26.825 | 26.825 | 26.825 | 26.825 | 2000.0 |
| 2014-10-30 04:06:00 | AAPL | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 2000.0 |
| 2014-10-30 04:23:00 | AAPL | Stock | 26.85 | 26.85 | 26.825 | 26.825 | 4400.0 |
| 2014-10-30 04:30:00 | AAPL | Stock | 26.825 | 26.825 | 26.805 | 26.805 | 4800.0 |
| 2014-10-30 04:38:00 | AAPL | Stock | 26.8125 | 26.8125 | 26.8125 | 26.8125 | 4000.0 |
| 2014-10-30 04:39:00 | AAPL | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 1600.0 |
| 2014-10-30 04:41:00 | AAPL | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 920.0 |
| 2014-10-30 04:42:00 | AAPL | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 400.0 |
| 2014-10-30 04:43:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.7875 | 26.7875 | 4000.0 |
| 2014-10-30 04:45:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 8000.0 |
| 2014-10-30 04:46:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 12000.0 |
| 2014-10-30 04:47:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 400.0 |
| 2014-10-30 04:51:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 04:55:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 05:01:00 | AAPL | Stock | 26.775 | 26.775 | 26.775 | 26.775 | 4000.0 |
| 2014-10-30 05:07:00 | AAPL | Stock | 26.7725 | 26.7725 | 26.7625 | 26.7625 | 800.0 |
| 2014-10-30 05:13:00 | AAPL | Stock | 26.745 | 26.745 | 26.745 | 26.745 | 2000.0 |
| 2014-10-30 05:14:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 400.0 |
| 2014-10-30 05:15:00 | AAPL | Stock | 26.745 | 26.745 | 26.7375 | 26.7375 | 7284.0 |
| 2014-10-30 05:20:00 | AAPL | Stock | 26.75 | 26.75 | 26.7125 | 26.7125 | 2800.0 |
| 2014-10-30 05:27:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.7025 | 26.7025 | 800.0 |
| 2014-10-30 05:29:00 | AAPL | Stock | 26.71 | 26.715 | 26.71 | 26.715 | 4000.0 |
| 2014-10-30 05:46:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.695 | 26.695 | 8716.0 |
| 2014-10-30 05:47:00 | AAPL | Stock | 26.695 | 26.695 | 26.6875 | 26.6875 | 3200.0 |
| 2014-10-30 05:51:00 | AAPL | Stock | 26.685 | 26.685 | 26.675 | 26.675 | 2048.0 |
| 2014-10-30 05:52:00 | AAPL | Stock | 26.6825 | 26.6825 | 26.675 | 26.675 | 1600.0 |
| 2014-10-30 05:53:00 | AAPL | Stock | 26.69 | 26.69 | 26.69 | 26.69 | 4000.0 |
| 2014-10-30 05:56:00 | AAPL | Stock | 26.665 | 26.665 | 26.665 | 26.665 | 400.0 |
| 2014-10-30 05:57:00 | AAPL | Stock | 26.69 | 26.69 | 26.69 | 26.69 | 1200.0 |
| 2014-10-30 06:01:00 | AAPL | Stock | 26.68 | 26.68 | 26.67 | 26.675 | 15316.0 |
| 2014-10-30 06:02:00 | AAPL | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 6800.0 |
| 2014-10-30 06:03:00 | AAPL | Stock | 26.69 | 26.69 | 26.69 | 26.69 | 400.0 |
| 2014-10-30 06:04:00 | AAPL | Stock | 26.69 | 26.69 | 26.69 | 26.69 | 5200.0 |
| 2014-10-30 06:05:00 | AAPL | Stock | 26.6875 | 26.6875 | 26.68 | 26.68 | 10612.0 |
| 2014-10-30 06:06:00 | AAPL | Stock | 26.68 | 26.6875 | 26.68 | 26.6875 | 2132.0 |
| 2014-10-30 06:09:00 | AAPL | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 400.0 |
| 2014-10-30 06:11:00 | AAPL | Stock | 26.6775 | 26.6775 | 26.675 | 26.675 | 1920.0 |
| 2014-10-30 06:12:00 | AAPL | Stock | 26.675 | 26.675 | 26.675 | 26.675 | 1200.0 |
| 2014-10-30 06:13:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 1600.0 |
| 2014-10-30 06:18:00 | AAPL | Stock | 26.685 | 26.705 | 26.685 | 26.705 | 1360.0 |
| 2014-10-30 06:20:00 | AAPL | Stock | 26.7025 | 26.71 | 26.7025 | 26.71 | 3384.0 |
| 2014-10-30 06:21:00 | AAPL | Stock | 26.71 | 26.71 | 26.71 | 26.71 | 1820.0 |
| 2014-10-30 06:33:00 | AAPL | Stock | 26.7075 | 26.7075 | 26.7075 | 26.7075 | 1000.0 |
| 2014-10-30 06:39:00 | AAPL | Stock | 26.7075 | 26.7075 | 26.7075 | 26.7075 | 5024.0 |
| 2014-10-30 06:40:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.7025 | 26.7025 | 800.0 |
| 2014-10-30 06:41:00 | AAPL | Stock | 26.69 | 26.69 | 26.6875 | 26.6875 | 3900.0 |
| 2014-10-30 06:43:00 | AAPL | Stock | 26.6775 | 26.6775 | 26.6775 | 26.6775 | 2000.0 |
| 2014-10-30 06:45:00 | AAPL | Stock | 26.6625 | 26.6625 | 26.6625 | 26.6625 | 7200.0 |
| 2014-10-30 06:49:00 | AAPL | Stock | 26.655 | 26.655 | 26.655 | 26.655 | 1532.0 |
> showing 50 of 998,784 rows — these rows as CSV