PREVIEW / stock_1min / 2017-04-04
file: by_date/stock_1min/2017/2017-04-04.parquet size: 14.5 MB rows: 1,064,474 symbols: 2,523
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-04 04:00:00 | AAPL | Stock | 35.8375 | 35.8975 | 35.8275 | 35.8975 | 7028.0 |
| 2017-04-04 05:06:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 800.0 |
| 2017-04-04 05:14:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 800.0 |
| 2017-04-04 05:31:00 | AAPL | Stock | 35.9025 | 35.9025 | 35.9025 | 35.9025 | 400.0 |
| 2017-04-04 05:39:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.885 | 35.885 | 800.0 |
| 2017-04-04 05:40:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 800.0 |
| 2017-04-04 05:41:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 400.0 |
| 2017-04-04 05:50:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.8875 | 35.8875 | 400.0 |
| 2017-04-04 05:51:00 | AAPL | Stock | 35.895 | 35.895 | 35.895 | 35.895 | 1212.0 |
| 2017-04-04 05:52:00 | AAPL | Stock | 35.895 | 35.895 | 35.895 | 35.895 | 800.0 |
| 2017-04-04 06:10:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.8875 | 35.8875 | 400.0 |
| 2017-04-04 06:14:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 400.0 |
| 2017-04-04 06:23:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 760.0 |
| 2017-04-04 06:38:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 492.0 |
| 2017-04-04 06:49:00 | AAPL | Stock | 35.8775 | 35.8775 | 35.8775 | 35.8775 | 900.0 |
| 2017-04-04 06:58:00 | AAPL | Stock | 35.8775 | 35.8775 | 35.875 | 35.875 | 1200.0 |
| 2017-04-04 07:04:00 | AAPL | Stock | 35.875 | 35.875 | 35.875 | 35.875 | 2872.0 |
| 2017-04-04 07:10:00 | AAPL | Stock | 35.875 | 35.875 | 35.875 | 35.875 | 800.0 |
| 2017-04-04 07:15:00 | AAPL | Stock | 35.875 | 35.875 | 35.8625 | 35.8625 | 1176.0 |
| 2017-04-04 07:18:00 | AAPL | Stock | 35.8625 | 35.8625 | 35.8625 | 35.8625 | 424.0 |
| 2017-04-04 07:29:00 | AAPL | Stock | 35.8625 | 35.8625 | 35.85 | 35.85 | 11976.0 |
| 2017-04-04 07:30:00 | AAPL | Stock | 35.845 | 35.845 | 35.83 | 35.845 | 3600.0 |
| 2017-04-04 07:31:00 | AAPL | Stock | 35.8375 | 35.8375 | 35.825 | 35.825 | 1200.0 |
| 2017-04-04 07:32:00 | AAPL | Stock | 35.825 | 35.825 | 35.825 | 35.825 | 1600.0 |
| 2017-04-04 07:35:00 | AAPL | Stock | 35.8275 | 35.8275 | 35.825 | 35.825 | 2000.0 |
| 2017-04-04 07:39:00 | AAPL | Stock | 35.8175 | 35.8175 | 35.8125 | 35.8125 | 1600.0 |
| 2017-04-04 07:40:00 | AAPL | Stock | 35.8075 | 35.8075 | 35.8025 | 35.8075 | 4292.0 |
| 2017-04-04 07:41:00 | AAPL | Stock | 35.8075 | 35.8075 | 35.8075 | 35.8075 | 592.0 |
| 2017-04-04 07:44:00 | AAPL | Stock | 35.82 | 35.825 | 35.82 | 35.825 | 4400.0 |
| 2017-04-04 07:45:00 | AAPL | Stock | 35.8 | 35.8225 | 35.8 | 35.8225 | 5600.0 |
| 2017-04-04 07:46:00 | AAPL | Stock | 35.8075 | 35.81 | 35.8075 | 35.81 | 800.0 |
| 2017-04-04 07:47:00 | AAPL | Stock | 35.81 | 35.81 | 35.8 | 35.8 | 1084.0 |
| 2017-04-04 07:49:00 | AAPL | Stock | 35.8 | 35.8125 | 35.8 | 35.8125 | 800.0 |
| 2017-04-04 08:00:00 | AAPL | Stock | 35.85 | 35.85 | 35.8225 | 35.825 | 10800.0 |
| 2017-04-04 08:01:00 | AAPL | Stock | 35.825 | 35.825 | 35.825 | 35.825 | 400.0 |
| 2017-04-04 08:04:00 | AAPL | Stock | 35.8175 | 35.8175 | 35.8125 | 35.8125 | 10660.0 |
| 2017-04-04 08:05:00 | AAPL | Stock | 35.8075 | 35.8075 | 35.8075 | 35.8075 | 5956.0 |
| 2017-04-04 08:06:00 | AAPL | Stock | 35.8025 | 35.8125 | 35.8025 | 35.8125 | 3200.0 |
| 2017-04-04 08:08:00 | AAPL | Stock | 35.8125 | 35.8125 | 35.8125 | 35.8125 | 400.0 |
| 2017-04-04 08:09:00 | AAPL | Stock | 35.83 | 35.83 | 35.83 | 35.83 | 4592.0 |
| 2017-04-04 08:10:00 | AAPL | Stock | 35.8275 | 35.83 | 35.805 | 35.8075 | 12800.0 |
| 2017-04-04 08:11:00 | AAPL | Stock | 35.82 | 35.82 | 35.82 | 35.82 | 1352.0 |
| 2017-04-04 08:12:00 | AAPL | Stock | 35.8075 | 35.8075 | 35.8075 | 35.8075 | 600.0 |
| 2017-04-04 08:13:00 | AAPL | Stock | 35.81 | 35.82 | 35.81 | 35.82 | 1308.0 |
| 2017-04-04 08:16:00 | AAPL | Stock | 35.82 | 35.82 | 35.82 | 35.82 | 3468.0 |
| 2017-04-04 08:18:00 | AAPL | Stock | 35.815 | 35.815 | 35.8125 | 35.8125 | 3480.0 |
| 2017-04-04 08:19:00 | AAPL | Stock | 35.815 | 35.815 | 35.815 | 35.815 | 400.0 |
| 2017-04-04 08:24:00 | AAPL | Stock | 35.825 | 35.825 | 35.82 | 35.82 | 1800.0 |
| 2017-04-04 08:30:00 | AAPL | Stock | 35.825 | 35.825 | 35.825 | 35.825 | 400.0 |
| 2017-04-04 08:31:00 | AAPL | Stock | 35.825 | 35.825 | 35.825 | 35.825 | 7200.0 |
> showing 50 of 1,064,474 rows — these rows as CSV