PREVIEW / stock_1min / 2013-10-28
file: by_date/stock_1min/2013/2013-10-28.parquet size: 13.7 MB rows: 1,001,910 symbols: 2,862
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-28 04:00:00 | AAPL | Stock | 18.8518 | 18.8518 | 18.8518 | 18.8518 | 14000.0 |
| 2013-10-28 04:20:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 2800.0 |
| 2013-10-28 04:21:00 | AAPL | Stock | 18.8854 | 18.8854 | 18.8854 | 18.8854 | 2800.0 |
| 2013-10-28 04:39:00 | AAPL | Stock | 18.9036 | 18.905 | 18.9036 | 18.905 | 5600.0 |
| 2013-10-28 04:43:00 | AAPL | Stock | 18.905 | 18.9161 | 18.905 | 18.9161 | 11200.0 |
| 2013-10-28 04:44:00 | AAPL | Stock | 18.9161 | 18.9196 | 18.9161 | 18.9196 | 16800.0 |
| 2013-10-28 04:46:00 | AAPL | Stock | 18.9196 | 18.9196 | 18.9196 | 18.9196 | 5600.0 |
| 2013-10-28 04:50:00 | AAPL | Stock | 18.9268 | 18.9268 | 18.9268 | 18.9268 | 2800.0 |
| 2013-10-28 04:51:00 | AAPL | Stock | 18.9268 | 18.9268 | 18.9268 | 18.9268 | 8400.0 |
| 2013-10-28 04:52:00 | AAPL | Stock | 18.9279 | 18.9279 | 18.9279 | 18.9279 | 2800.0 |
| 2013-10-28 04:57:00 | AAPL | Stock | 18.9282 | 18.9282 | 18.9282 | 18.9282 | 2800.0 |
| 2013-10-28 04:59:00 | AAPL | Stock | 18.9282 | 18.9286 | 18.9268 | 18.9286 | 25368.0 |
| 2013-10-28 05:06:00 | AAPL | Stock | 18.9314 | 18.9314 | 18.9314 | 18.9314 | 2800.0 |
| 2013-10-28 05:09:00 | AAPL | Stock | 18.9429 | 18.9429 | 18.9429 | 18.9429 | 2800.0 |
| 2013-10-28 05:13:00 | AAPL | Stock | 18.9411 | 18.9411 | 18.9411 | 18.9411 | 2800.0 |
| 2013-10-28 05:25:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2013-10-28 05:26:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2013-10-28 05:28:00 | AAPL | Stock | 18.9214 | 18.9214 | 18.9214 | 18.9214 | 5600.0 |
| 2013-10-28 05:33:00 | AAPL | Stock | 18.9068 | 18.9286 | 18.9064 | 18.9286 | 28000.0 |
| 2013-10-28 05:42:00 | AAPL | Stock | 18.925 | 18.9286 | 18.925 | 18.9286 | 37100.0 |
| 2013-10-28 05:43:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2013-10-28 05:51:00 | AAPL | Stock | 18.9054 | 18.9054 | 18.9018 | 18.9018 | 22400.0 |
| 2013-10-28 05:52:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2013-10-28 06:00:00 | AAPL | Stock | 18.9268 | 18.9268 | 18.9268 | 18.9268 | 11900.0 |
| 2013-10-28 06:05:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.9036 | 18.9036 | 5600.0 |
| 2013-10-28 06:06:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.875 | 18.875 | 70000.0 |
| 2013-10-28 06:07:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2013-10-28 06:08:00 | AAPL | Stock | 18.8821 | 18.8821 | 18.8821 | 18.8821 | 7000.0 |
| 2013-10-28 06:09:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8696 | 18.8696 | 2800.0 |
| 2013-10-28 06:17:00 | AAPL | Stock | 18.8764 | 18.8764 | 18.875 | 18.875 | 11200.0 |
| 2013-10-28 06:26:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8571 | 18.8696 | 19600.0 |
| 2013-10-28 06:30:00 | AAPL | Stock | 18.9025 | 18.9025 | 18.9025 | 18.9025 | 2800.0 |
| 2013-10-28 06:31:00 | AAPL | Stock | 18.9018 | 18.9018 | 18.9018 | 18.9018 | 5600.0 |
| 2013-10-28 06:32:00 | AAPL | Stock | 18.8932 | 18.8932 | 18.8929 | 18.8929 | 11200.0 |
| 2013-10-28 06:42:00 | AAPL | Stock | 18.8989 | 18.8989 | 18.8989 | 18.8989 | 2800.0 |
| 2013-10-28 06:49:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 2800.0 |
| 2013-10-28 06:52:00 | AAPL | Stock | 18.8621 | 18.8621 | 18.8621 | 18.8621 | 2800.0 |
| 2013-10-28 06:53:00 | AAPL | Stock | 18.8968 | 18.8968 | 18.8968 | 18.8968 | 2800.0 |
| 2013-10-28 06:54:00 | AAPL | Stock | 18.8632 | 18.8632 | 18.8614 | 18.8614 | 27216.0 |
| 2013-10-28 06:55:00 | AAPL | Stock | 18.8618 | 18.8618 | 18.8607 | 18.8607 | 8400.0 |
| 2013-10-28 07:00:00 | AAPL | Stock | 18.8571 | 18.875 | 18.8571 | 18.875 | 16828.0 |
| 2013-10-28 07:01:00 | AAPL | Stock | 18.8414 | 18.8414 | 18.8396 | 18.8396 | 25200.0 |
| 2013-10-28 07:03:00 | AAPL | Stock | 18.8732 | 18.8732 | 18.8571 | 18.8571 | 50400.0 |
| 2013-10-28 07:04:00 | AAPL | Stock | 18.85 | 18.85 | 18.85 | 18.85 | 2800.0 |
| 2013-10-28 07:07:00 | AAPL | Stock | 18.8411 | 18.8411 | 18.8393 | 18.8396 | 13636.0 |
| 2013-10-28 07:11:00 | AAPL | Stock | 18.8486 | 18.8486 | 18.8486 | 18.8486 | 2800.0 |
| 2013-10-28 07:15:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 8400.0 |
| 2013-10-28 07:22:00 | AAPL | Stock | 18.8643 | 18.8643 | 18.8643 | 18.8643 | 22400.0 |
| 2013-10-28 07:24:00 | AAPL | Stock | 18.8643 | 18.8643 | 18.8643 | 18.8643 | 19796.0 |
| 2013-10-28 07:25:00 | AAPL | Stock | 18.8714 | 18.8714 | 18.8643 | 18.8643 | 19600.0 |
> showing 50 of 1,001,910 rows — these rows as CSV