PREVIEW / stock_1min / 2013-10-24
file: by_date/stock_1min/2013/2013-10-24.parquet size: 13.8 MB rows: 1,002,930 symbols: 2,867
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-24 04:09:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 4900.0 |
| 2013-10-24 04:10:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 4900.0 |
| 2013-10-24 04:15:00 | AAPL | Stock | 18.8036 | 18.8179 | 18.8036 | 18.8179 | 8400.0 |
| 2013-10-24 05:01:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 9100.0 |
| 2013-10-24 05:03:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 4900.0 |
| 2013-10-24 05:31:00 | AAPL | Stock | 18.8232 | 18.8232 | 18.8232 | 18.8232 | 2800.0 |
| 2013-10-24 05:33:00 | AAPL | Stock | 18.8461 | 18.8461 | 18.8461 | 18.8461 | 5600.0 |
| 2013-10-24 05:44:00 | AAPL | Stock | 18.8532 | 18.8532 | 18.8532 | 18.8532 | 2800.0 |
| 2013-10-24 05:46:00 | AAPL | Stock | 18.8389 | 18.8389 | 18.8389 | 18.8389 | 2800.0 |
| 2013-10-24 05:52:00 | AAPL | Stock | 18.8279 | 18.8279 | 18.8279 | 18.8279 | 2800.0 |
| 2013-10-24 05:53:00 | AAPL | Stock | 18.8125 | 18.8125 | 18.8125 | 18.8125 | 3556.0 |
| 2013-10-24 06:02:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8325 | 18.8325 | 19600.0 |
| 2013-10-24 06:05:00 | AAPL | Stock | 18.8175 | 18.8175 | 18.8175 | 18.8175 | 2800.0 |
| 2013-10-24 06:08:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 5600.0 |
| 2013-10-24 06:09:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 5600.0 |
| 2013-10-24 06:10:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 2800.0 |
| 2013-10-24 06:15:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 14980.0 |
| 2013-10-24 06:46:00 | AAPL | Stock | 18.8357 | 18.8357 | 18.8357 | 18.8357 | 2800.0 |
| 2013-10-24 06:47:00 | AAPL | Stock | 18.8357 | 18.8357 | 18.8357 | 18.8357 | 5600.0 |
| 2013-10-24 06:48:00 | AAPL | Stock | 18.8357 | 18.8357 | 18.8357 | 18.8357 | 2800.0 |
| 2013-10-24 06:49:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 7784.0 |
| 2013-10-24 06:50:00 | AAPL | Stock | 18.8393 | 18.8461 | 18.8393 | 18.8461 | 31080.0 |
| 2013-10-24 06:51:00 | AAPL | Stock | 18.8554 | 18.8557 | 18.8482 | 18.8557 | 13160.0 |
| 2013-10-24 07:00:00 | AAPL | Stock | 18.8721 | 18.8729 | 18.8721 | 18.8729 | 11060.0 |
| 2013-10-24 07:01:00 | AAPL | Stock | 18.875 | 18.875 | 18.8661 | 18.8661 | 16800.0 |
| 2013-10-24 07:02:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 44800.0 |
| 2013-10-24 07:03:00 | AAPL | Stock | 18.8661 | 18.8829 | 18.8661 | 18.8829 | 59220.0 |
| 2013-10-24 07:04:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8571 | 18.8571 | 12040.0 |
| 2013-10-24 07:06:00 | AAPL | Stock | 18.8393 | 18.8571 | 18.8393 | 18.8571 | 7280.0 |
| 2013-10-24 07:12:00 | AAPL | Stock | 18.8489 | 18.8489 | 18.8332 | 18.8332 | 5600.0 |
| 2013-10-24 07:14:00 | AAPL | Stock | 18.8393 | 18.8571 | 18.8393 | 18.8571 | 63224.0 |
| 2013-10-24 07:15:00 | AAPL | Stock | 18.8536 | 18.8536 | 18.8536 | 18.8536 | 2800.0 |
| 2013-10-24 07:16:00 | AAPL | Stock | 18.8536 | 18.8536 | 18.8536 | 18.8536 | 8400.0 |
| 2013-10-24 07:17:00 | AAPL | Stock | 18.8536 | 18.8536 | 18.8536 | 18.8536 | 5600.0 |
| 2013-10-24 07:18:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 5600.0 |
| 2013-10-24 07:19:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8461 | 18.8461 | 41160.0 |
| 2013-10-24 07:22:00 | AAPL | Stock | 18.8304 | 18.8304 | 18.8304 | 18.8304 | 6972.0 |
| 2013-10-24 07:23:00 | AAPL | Stock | 18.8429 | 18.8464 | 18.8429 | 18.8464 | 24668.0 |
| 2013-10-24 07:26:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 4480.0 |
| 2013-10-24 07:28:00 | AAPL | Stock | 18.8271 | 18.8271 | 18.8271 | 18.8271 | 2800.0 |
| 2013-10-24 07:31:00 | AAPL | Stock | 18.8293 | 18.8293 | 18.8254 | 18.8254 | 8400.0 |
| 2013-10-24 07:32:00 | AAPL | Stock | 18.8311 | 18.8321 | 18.8311 | 18.8321 | 5600.0 |
| 2013-10-24 07:33:00 | AAPL | Stock | 18.8264 | 18.8264 | 18.8214 | 18.8214 | 32760.0 |
| 2013-10-24 07:36:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 6440.0 |
| 2013-10-24 07:37:00 | AAPL | Stock | 18.8125 | 18.8125 | 18.8125 | 18.8125 | 2800.0 |
| 2013-10-24 07:38:00 | AAPL | Stock | 18.8129 | 18.8129 | 18.8125 | 18.8125 | 5600.0 |
| 2013-10-24 07:41:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2013-10-24 07:42:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 45360.0 |
| 2013-10-24 07:44:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2013-10-24 07:45:00 | AAPL | Stock | 18.8182 | 18.8182 | 18.8182 | 18.8182 | 3920.0 |
> showing 50 of 1,002,930 rows — these rows as CSV