PREVIEW / stock_1min / 2013-02-11
file: by_date/stock_1min/2013/2013-02-11.parquet size: 12.5 MB rows: 925,394 symbols: 2,825
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-02-11 04:00:00 | AAPL | Stock | 17.0393 | 17.0393 | 17.0393 | 17.0393 | 55440.0 |
| 2013-02-11 04:03:00 | AAPL | Stock | 17.0357 | 17.0357 | 17.0357 | 17.0357 | 2800.0 |
| 2013-02-11 04:08:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 2800.0 |
| 2013-02-11 04:10:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 9380.0 |
| 2013-02-11 04:20:00 | AAPL | Stock | 17.0871 | 17.0893 | 17.0871 | 17.0893 | 19600.0 |
| 2013-02-11 04:31:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 4620.0 |
| 2013-02-11 04:43:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 2800.0 |
| 2013-02-11 04:44:00 | AAPL | Stock | 17.0804 | 17.0804 | 17.0804 | 17.0804 | 14000.0 |
| 2013-02-11 05:03:00 | AAPL | Stock | 17.0718 | 17.0718 | 17.0718 | 17.0718 | 7000.0 |
| 2013-02-11 05:15:00 | AAPL | Stock | 17.0739 | 17.0739 | 17.0714 | 17.0714 | 14000.0 |
| 2013-02-11 05:17:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2013-02-11 05:18:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.0536 | 17.0536 | 5600.0 |
| 2013-02-11 05:19:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.0536 | 17.0536 | 5600.0 |
| 2013-02-11 05:20:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.0536 | 17.0536 | 5600.0 |
| 2013-02-11 05:24:00 | AAPL | Stock | 17.0589 | 17.0589 | 17.0589 | 17.0589 | 2800.0 |
| 2013-02-11 05:34:00 | AAPL | Stock | 17.0464 | 17.0464 | 17.0464 | 17.0464 | 8400.0 |
| 2013-02-11 05:41:00 | AAPL | Stock | 17.0689 | 17.0689 | 17.0689 | 17.0689 | 5040.0 |
| 2013-02-11 05:55:00 | AAPL | Stock | 17.0668 | 17.0668 | 17.0668 | 17.0668 | 2800.0 |
| 2013-02-11 06:02:00 | AAPL | Stock | 17.0689 | 17.0689 | 17.0689 | 17.0689 | 2800.0 |
| 2013-02-11 06:11:00 | AAPL | Stock | 17.0711 | 17.0711 | 17.0711 | 17.0711 | 5600.0 |
| 2013-02-11 06:14:00 | AAPL | Stock | 17.0582 | 17.0582 | 17.0579 | 17.0579 | 8400.0 |
| 2013-02-11 06:17:00 | AAPL | Stock | 17.0643 | 17.0643 | 17.0643 | 17.0643 | 2800.0 |
| 2013-02-11 06:19:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 2800.0 |
| 2013-02-11 06:22:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 2800.0 |
| 2013-02-11 06:23:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 2800.0 |
| 2013-02-11 06:25:00 | AAPL | Stock | 17.0571 | 17.0571 | 17.0571 | 17.0571 | 5600.0 |
| 2013-02-11 06:32:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2013-02-11 06:39:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 5600.0 |
| 2013-02-11 06:57:00 | AAPL | Stock | 17.0696 | 17.0696 | 17.0696 | 17.0696 | 2800.0 |
| 2013-02-11 06:58:00 | AAPL | Stock | 17.0696 | 17.0696 | 17.0696 | 17.0696 | 2800.0 |
| 2013-02-11 07:00:00 | AAPL | Stock | 17.0696 | 17.0714 | 17.0554 | 17.0671 | 179200.0 |
| 2013-02-11 07:03:00 | AAPL | Stock | 17.0646 | 17.0646 | 17.0646 | 17.0646 | 5600.0 |
| 2013-02-11 07:04:00 | AAPL | Stock | 17.0546 | 17.0546 | 17.0543 | 17.0543 | 8400.0 |
| 2013-02-11 07:05:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0536 | 17.0621 | 8400.0 |
| 2013-02-11 07:06:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.0518 | 17.0518 | 16800.0 |
| 2013-02-11 07:07:00 | AAPL | Stock | 17.0554 | 17.0554 | 17.0554 | 17.0554 | 2800.0 |
| 2013-02-11 07:08:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.04 | 17.04 | 32200.0 |
| 2013-02-11 07:09:00 | AAPL | Stock | 17.0471 | 17.0471 | 17.0393 | 17.0393 | 25200.0 |
| 2013-02-11 07:10:00 | AAPL | Stock | 17.0379 | 17.0429 | 17.0321 | 17.0357 | 50400.0 |
| 2013-02-11 07:11:00 | AAPL | Stock | 17.0357 | 17.0429 | 17.0357 | 17.0429 | 11536.0 |
| 2013-02-11 07:12:00 | AAPL | Stock | 17.0393 | 17.0393 | 17.0393 | 17.0393 | 2800.0 |
| 2013-02-11 07:13:00 | AAPL | Stock | 17.0393 | 17.0475 | 17.0393 | 17.0475 | 16800.0 |
| 2013-02-11 07:14:00 | AAPL | Stock | 17.0536 | 17.0536 | 17.0536 | 17.0536 | 5600.0 |
| 2013-02-11 07:15:00 | AAPL | Stock | 17.0536 | 17.0539 | 17.0536 | 17.0539 | 8400.0 |
| 2013-02-11 07:16:00 | AAPL | Stock | 17.0607 | 17.0607 | 17.0607 | 17.0607 | 2800.0 |
| 2013-02-11 07:17:00 | AAPL | Stock | 17.0614 | 17.0643 | 17.0614 | 17.0643 | 19488.0 |
| 2013-02-11 07:18:00 | AAPL | Stock | 17.0657 | 17.0696 | 17.0657 | 17.0696 | 15848.0 |
| 2013-02-11 07:19:00 | AAPL | Stock | 17.0693 | 17.0696 | 17.0689 | 17.0696 | 50400.0 |
| 2013-02-11 07:20:00 | AAPL | Stock | 17.0696 | 17.0696 | 17.0643 | 17.0689 | 18228.0 |
| 2013-02-11 07:21:00 | AAPL | Stock | 17.0679 | 17.0679 | 17.0679 | 17.0679 | 2800.0 |
> showing 50 of 925,394 rows — these rows as CSV