PREVIEW / stock_1min / 2012-09-20
file: by_date/stock_1min/2012/2012-09-20.parquet size: 12.6 MB rows: 938,814 symbols: 2,808
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-20 04:21:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 2800.0 |
| 2012-09-20 05:01:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 11200.0 |
| 2012-09-20 05:04:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 5544.0 |
| 2012-09-20 05:06:00 | AAPL | Stock | 24.975 | 24.975 | 24.975 | 24.975 | 5180.0 |
| 2012-09-20 05:07:00 | AAPL | Stock | 24.975 | 24.975 | 24.975 | 24.975 | 5600.0 |
| 2012-09-20 05:09:00 | AAPL | Stock | 24.975 | 24.975 | 24.975 | 24.975 | 2800.0 |
| 2012-09-20 05:10:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 2800.0 |
| 2012-09-20 05:13:00 | AAPL | Stock | 24.9621 | 24.9621 | 24.9621 | 24.9621 | 2800.0 |
| 2012-09-20 05:15:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 2800.0 |
| 2012-09-20 05:35:00 | AAPL | Stock | 24.9429 | 24.9429 | 24.9429 | 24.9429 | 5600.0 |
| 2012-09-20 05:36:00 | AAPL | Stock | 24.9314 | 24.9314 | 24.9314 | 24.9314 | 2800.0 |
| 2012-09-20 05:37:00 | AAPL | Stock | 24.9339 | 24.9339 | 24.9339 | 24.9339 | 4200.0 |
| 2012-09-20 05:48:00 | AAPL | Stock | 24.9468 | 24.9468 | 24.9468 | 24.9468 | 6888.0 |
| 2012-09-20 06:21:00 | AAPL | Stock | 24.9504 | 24.9504 | 24.9504 | 24.9504 | 3276.0 |
| 2012-09-20 06:26:00 | AAPL | Stock | 24.9536 | 24.9536 | 24.9536 | 24.9536 | 2800.0 |
| 2012-09-20 06:31:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 2800.0 |
| 2012-09-20 06:32:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 5600.0 |
| 2012-09-20 06:40:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 7700.0 |
| 2012-09-20 06:46:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 8120.0 |
| 2012-09-20 06:50:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 7980.0 |
| 2012-09-20 07:00:00 | AAPL | Stock | 24.9911 | 24.9911 | 24.9911 | 24.9911 | 5600.0 |
| 2012-09-20 07:01:00 | AAPL | Stock | 24.9989 | 24.9989 | 24.9989 | 24.9989 | 2800.0 |
| 2012-09-20 07:02:00 | AAPL | Stock | 25.0 | 25.0 | 24.9929 | 24.9929 | 11200.0 |
| 2012-09-20 07:03:00 | AAPL | Stock | 24.9929 | 24.9929 | 24.9929 | 24.9929 | 2800.0 |
| 2012-09-20 07:04:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.98 | 24.98 | 8680.0 |
| 2012-09-20 07:07:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 3360.0 |
| 2012-09-20 07:12:00 | AAPL | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 22120.0 |
| 2012-09-20 07:13:00 | AAPL | Stock | 25.0089 | 25.0089 | 25.0089 | 25.0089 | 2800.0 |
| 2012-09-20 07:14:00 | AAPL | Stock | 25.0089 | 25.0089 | 25.0089 | 25.0089 | 2800.0 |
| 2012-09-20 07:15:00 | AAPL | Stock | 25.0071 | 25.0179 | 25.0071 | 25.0179 | 26040.0 |
| 2012-09-20 07:16:00 | AAPL | Stock | 25.0175 | 25.0286 | 25.0175 | 25.0286 | 14476.0 |
| 2012-09-20 07:17:00 | AAPL | Stock | 25.0193 | 25.0193 | 25.0179 | 25.0179 | 5600.0 |
| 2012-09-20 07:19:00 | AAPL | Stock | 25.0168 | 25.0204 | 25.0168 | 25.0204 | 5600.0 |
| 2012-09-20 07:21:00 | AAPL | Stock | 25.0214 | 25.0214 | 25.0214 | 25.0214 | 3920.0 |
| 2012-09-20 07:22:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0125 | 25.0125 | 2800.0 |
| 2012-09-20 07:23:00 | AAPL | Stock | 25.0171 | 25.0171 | 25.0171 | 25.0171 | 5600.0 |
| 2012-09-20 07:24:00 | AAPL | Stock | 25.0125 | 25.0232 | 25.0125 | 25.0232 | 39200.0 |
| 2012-09-20 07:25:00 | AAPL | Stock | 25.0232 | 25.0232 | 25.0232 | 25.0232 | 9100.0 |
| 2012-09-20 07:27:00 | AAPL | Stock | 25.0232 | 25.0232 | 25.0232 | 25.0232 | 2800.0 |
| 2012-09-20 07:33:00 | AAPL | Stock | 25.0179 | 25.0179 | 25.0161 | 25.0161 | 5600.0 |
| 2012-09-20 07:34:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0 | 25.0 | 57148.0 |
| 2012-09-20 07:35:00 | AAPL | Stock | 25.0089 | 25.0089 | 25.0089 | 25.0089 | 2800.0 |
| 2012-09-20 07:36:00 | AAPL | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 2800.0 |
| 2012-09-20 07:39:00 | AAPL | Stock | 24.9893 | 24.9893 | 24.9821 | 24.9821 | 56644.0 |
| 2012-09-20 07:41:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9643 | 24.9643 | 82292.0 |
| 2012-09-20 07:42:00 | AAPL | Stock | 24.9643 | 24.9643 | 24.9643 | 24.9643 | 16800.0 |
| 2012-09-20 07:43:00 | AAPL | Stock | 24.9739 | 24.9739 | 24.9739 | 24.9739 | 2800.0 |
| 2012-09-20 07:44:00 | AAPL | Stock | 24.9821 | 24.9821 | 24.9821 | 24.9821 | 2800.0 |
| 2012-09-20 07:45:00 | AAPL | Stock | 24.9893 | 24.9911 | 24.9821 | 24.9821 | 25200.0 |
| 2012-09-20 07:49:00 | AAPL | Stock | 24.9957 | 24.9964 | 24.9957 | 24.9964 | 25900.0 |
> showing 50 of 938,814 rows — these rows as CSV