PREVIEW / stock_1min / 2015-07-28
file: by_date/stock_1min/2015/2015-07-28.parquet size: 15.5 MB rows: 1,115,328 symbols: 2,846
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-07-28 04:00:00 | AAPL | Stock | 30.8675 | 30.875 | 30.8675 | 30.875 | 4000.0 |
| 2015-07-28 04:15:00 | AAPL | Stock | 30.9325 | 30.9325 | 30.9325 | 30.9325 | 800.0 |
| 2015-07-28 04:18:00 | AAPL | Stock | 30.915 | 30.915 | 30.915 | 30.915 | 400.0 |
| 2015-07-28 04:21:00 | AAPL | Stock | 30.915 | 30.915 | 30.915 | 30.915 | 400.0 |
| 2015-07-28 04:22:00 | AAPL | Stock | 30.975 | 30.975 | 30.975 | 30.975 | 2000.0 |
| 2015-07-28 04:37:00 | AAPL | Stock | 30.9425 | 30.9425 | 30.94 | 30.94 | 1600.0 |
| 2015-07-28 04:45:00 | AAPL | Stock | 30.9375 | 30.9375 | 30.9375 | 30.9375 | 400.0 |
| 2015-07-28 04:55:00 | AAPL | Stock | 30.9425 | 30.9425 | 30.9425 | 30.9425 | 400.0 |
| 2015-07-28 05:01:00 | AAPL | Stock | 30.9425 | 30.9425 | 30.9425 | 30.9425 | 800.0 |
| 2015-07-28 05:02:00 | AAPL | Stock | 30.9425 | 30.9425 | 30.9425 | 30.9425 | 800.0 |
| 2015-07-28 05:08:00 | AAPL | Stock | 30.9675 | 30.97 | 30.9675 | 30.97 | 2000.0 |
| 2015-07-28 05:16:00 | AAPL | Stock | 30.97 | 30.97 | 30.97 | 30.97 | 1200.0 |
| 2015-07-28 05:23:00 | AAPL | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 768.0 |
| 2015-07-28 05:28:00 | AAPL | Stock | 31.005 | 31.005 | 31.0 | 31.0 | 2000.0 |
| 2015-07-28 05:35:00 | AAPL | Stock | 31.0175 | 31.025 | 31.0175 | 31.025 | 2840.0 |
| 2015-07-28 05:46:00 | AAPL | Stock | 31.045 | 31.05 | 31.045 | 31.045 | 4000.0 |
| 2015-07-28 05:51:00 | AAPL | Stock | 31.045 | 31.045 | 31.045 | 31.045 | 4000.0 |
| 2015-07-28 05:55:00 | AAPL | Stock | 31.045 | 31.045 | 31.045 | 31.045 | 400.0 |
| 2015-07-28 05:59:00 | AAPL | Stock | 31.045 | 31.045 | 31.045 | 31.045 | 400.0 |
| 2015-07-28 06:00:00 | AAPL | Stock | 31.02 | 31.05 | 31.02 | 31.05 | 2300.0 |
| 2015-07-28 06:01:00 | AAPL | Stock | 31.05 | 31.05 | 31.05 | 31.05 | 780.0 |
| 2015-07-28 06:02:00 | AAPL | Stock | 31.05 | 31.05 | 31.05 | 31.05 | 800.0 |
| 2015-07-28 06:03:00 | AAPL | Stock | 31.0475 | 31.075 | 31.0475 | 31.075 | 7880.0 |
| 2015-07-28 06:05:00 | AAPL | Stock | 31.03 | 31.03 | 31.03 | 31.03 | 2400.0 |
| 2015-07-28 06:07:00 | AAPL | Stock | 31.05 | 31.05 | 31.05 | 31.05 | 600.0 |
| 2015-07-28 06:21:00 | AAPL | Stock | 31.0675 | 31.0725 | 31.0675 | 31.0725 | 9356.0 |
| 2015-07-28 06:22:00 | AAPL | Stock | 31.07 | 31.07 | 31.07 | 31.07 | 800.0 |
| 2015-07-28 06:24:00 | AAPL | Stock | 31.07 | 31.0725 | 31.07 | 31.0725 | 8000.0 |
| 2015-07-28 06:28:00 | AAPL | Stock | 31.05 | 31.05 | 31.05 | 31.05 | 528.0 |
| 2015-07-28 06:31:00 | AAPL | Stock | 31.0425 | 31.0425 | 31.0375 | 31.0375 | 2396.0 |
| 2015-07-28 06:34:00 | AAPL | Stock | 31.0375 | 31.0375 | 31.0375 | 31.0375 | 4504.0 |
| 2015-07-28 06:41:00 | AAPL | Stock | 31.0125 | 31.0125 | 31.0125 | 31.0125 | 1044.0 |
| 2015-07-28 06:44:00 | AAPL | Stock | 31.03 | 31.03 | 31.03 | 31.03 | 400.0 |
| 2015-07-28 06:46:00 | AAPL | Stock | 31.015 | 31.015 | 31.0025 | 31.0025 | 16384.0 |
| 2015-07-28 06:47:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.945 | 30.945 | 9804.0 |
| 2015-07-28 06:49:00 | AAPL | Stock | 30.9525 | 30.9525 | 30.95 | 30.95 | 3680.0 |
| 2015-07-28 06:54:00 | AAPL | Stock | 30.93 | 30.93 | 30.93 | 30.93 | 800.0 |
| 2015-07-28 06:55:00 | AAPL | Stock | 30.9525 | 30.9525 | 30.9525 | 30.9525 | 520.0 |
| 2015-07-28 07:00:00 | AAPL | Stock | 30.94 | 30.94 | 30.9125 | 30.9125 | 2916.0 |
| 2015-07-28 07:01:00 | AAPL | Stock | 30.9125 | 30.9125 | 30.9075 | 30.9075 | 1756.0 |
| 2015-07-28 07:02:00 | AAPL | Stock | 30.9075 | 30.9075 | 30.9 | 30.9 | 14728.0 |
| 2015-07-28 07:04:00 | AAPL | Stock | 30.8975 | 30.8975 | 30.89 | 30.89 | 1600.0 |
| 2015-07-28 07:05:00 | AAPL | Stock | 30.885 | 30.89 | 30.88 | 30.89 | 4400.0 |
| 2015-07-28 07:06:00 | AAPL | Stock | 30.89 | 30.89 | 30.89 | 30.89 | 6788.0 |
| 2015-07-28 07:12:00 | AAPL | Stock | 30.89 | 30.89 | 30.89 | 30.89 | 3552.0 |
| 2015-07-28 07:14:00 | AAPL | Stock | 30.895 | 30.895 | 30.8875 | 30.8875 | 2000.0 |
| 2015-07-28 07:15:00 | AAPL | Stock | 30.89 | 30.89 | 30.89 | 30.89 | 2400.0 |
| 2015-07-28 07:17:00 | AAPL | Stock | 30.8925 | 30.8975 | 30.8925 | 30.8975 | 1600.0 |
| 2015-07-28 07:18:00 | AAPL | Stock | 30.8975 | 30.8975 | 30.8975 | 30.8975 | 400.0 |
| 2015-07-28 07:21:00 | AAPL | Stock | 30.8975 | 30.8975 | 30.8975 | 30.8975 | 400.0 |
> showing 50 of 1,115,328 rows — these rows as CSV