PREVIEW / stock_1min / 2014-02-28
file: by_date/stock_1min/2014/2014-02-28.parquet size: 15.4 MB rows: 1,095,039 symbols: 2,863
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-28 06:12:00 | AAPL | Stock | 18.8943 | 18.9 | 18.8929 | 18.8929 | 16212.0 |
| 2014-02-28 07:01:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 8288.0 |
| 2014-02-28 07:04:00 | AAPL | Stock | 18.8746 | 18.8746 | 18.8746 | 18.8746 | 2800.0 |
| 2014-02-28 07:05:00 | AAPL | Stock | 18.8657 | 18.8664 | 18.8571 | 18.8571 | 33040.0 |
| 2014-02-28 07:06:00 | AAPL | Stock | 18.8289 | 18.8289 | 18.8289 | 18.8289 | 2800.0 |
| 2014-02-28 07:09:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8321 | 18.8321 | 10892.0 |
| 2014-02-28 07:11:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.8296 | 18.8296 | 5600.0 |
| 2014-02-28 07:18:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 25340.0 |
| 2014-02-28 07:19:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.8321 | 18.8321 | 14000.0 |
| 2014-02-28 07:21:00 | AAPL | Stock | 18.8304 | 18.8304 | 18.8304 | 18.8304 | 2800.0 |
| 2014-02-28 07:25:00 | AAPL | Stock | 18.8379 | 18.8393 | 18.8379 | 18.8393 | 5600.0 |
| 2014-02-28 07:26:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8339 | 18.8339 | 18480.0 |
| 2014-02-28 07:31:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 8400.0 |
| 2014-02-28 07:32:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 5600.0 |
| 2014-02-28 07:40:00 | AAPL | Stock | 18.8464 | 18.8464 | 18.8464 | 18.8464 | 2800.0 |
| 2014-02-28 07:43:00 | AAPL | Stock | 18.8432 | 18.8432 | 18.8432 | 18.8432 | 2800.0 |
| 2014-02-28 07:44:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.8429 | 18.8429 | 2800.0 |
| 2014-02-28 07:46:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.8429 | 18.8429 | 2800.0 |
| 2014-02-28 07:49:00 | AAPL | Stock | 18.8404 | 18.8404 | 18.8393 | 18.8393 | 14000.0 |
| 2014-02-28 07:59:00 | AAPL | Stock | 18.8346 | 18.8346 | 18.8346 | 18.8346 | 2800.0 |
| 2014-02-28 08:00:00 | AAPL | Stock | 18.8489 | 18.8493 | 18.8304 | 18.8339 | 41160.0 |
| 2014-02-28 08:01:00 | AAPL | Stock | 18.8429 | 18.8479 | 18.8429 | 18.8475 | 11200.0 |
| 2014-02-28 08:02:00 | AAPL | Stock | 18.8489 | 18.8493 | 18.8489 | 18.8493 | 19600.0 |
| 2014-02-28 08:04:00 | AAPL | Stock | 18.8461 | 18.8461 | 18.8461 | 18.8461 | 14000.0 |
| 2014-02-28 08:05:00 | AAPL | Stock | 18.8461 | 18.8461 | 18.8461 | 18.8461 | 8400.0 |
| 2014-02-28 08:06:00 | AAPL | Stock | 18.8457 | 18.8457 | 18.8457 | 18.8457 | 2800.0 |
| 2014-02-28 08:07:00 | AAPL | Stock | 18.8482 | 18.8482 | 18.8482 | 18.8482 | 13440.0 |
| 2014-02-28 08:08:00 | AAPL | Stock | 18.8461 | 18.8461 | 18.8461 | 18.8461 | 4228.0 |
| 2014-02-28 08:09:00 | AAPL | Stock | 18.8446 | 18.8446 | 18.8446 | 18.8446 | 8400.0 |
| 2014-02-28 08:11:00 | AAPL | Stock | 18.8493 | 18.8493 | 18.8493 | 18.8493 | 2800.0 |
| 2014-02-28 08:15:00 | AAPL | Stock | 18.8421 | 18.8482 | 18.8411 | 18.8482 | 16800.0 |
| 2014-02-28 08:17:00 | AAPL | Stock | 18.8493 | 18.8493 | 18.8493 | 18.8493 | 5600.0 |
| 2014-02-28 08:23:00 | AAPL | Stock | 18.8446 | 18.8446 | 18.8446 | 18.8446 | 2800.0 |
| 2014-02-28 08:24:00 | AAPL | Stock | 18.8446 | 18.8446 | 18.8446 | 18.8446 | 3528.0 |
| 2014-02-28 08:27:00 | AAPL | Stock | 18.8471 | 18.8471 | 18.8471 | 18.8471 | 2800.0 |
| 2014-02-28 08:28:00 | AAPL | Stock | 18.8407 | 18.8407 | 18.8407 | 18.8407 | 2800.0 |
| 2014-02-28 08:29:00 | AAPL | Stock | 18.8479 | 18.8493 | 18.8479 | 18.8493 | 12068.0 |
| 2014-02-28 08:30:00 | AAPL | Stock | 18.8493 | 18.85 | 18.8493 | 18.85 | 5600.0 |
| 2014-02-28 08:31:00 | AAPL | Stock | 18.8446 | 18.8446 | 18.8446 | 18.8446 | 2800.0 |
| 2014-02-28 08:33:00 | AAPL | Stock | 18.8536 | 18.8536 | 18.8536 | 18.8536 | 2800.0 |
| 2014-02-28 08:34:00 | AAPL | Stock | 18.8539 | 18.8579 | 18.8536 | 18.8579 | 10500.0 |
| 2014-02-28 08:36:00 | AAPL | Stock | 18.8579 | 18.8625 | 18.8579 | 18.8625 | 26320.0 |
| 2014-02-28 08:37:00 | AAPL | Stock | 18.8657 | 18.8657 | 18.8625 | 18.8643 | 19600.0 |
| 2014-02-28 08:39:00 | AAPL | Stock | 18.8714 | 18.875 | 18.8714 | 18.875 | 48160.0 |
| 2014-02-28 08:40:00 | AAPL | Stock | 18.8736 | 18.8818 | 18.8736 | 18.8754 | 33600.0 |
| 2014-02-28 08:41:00 | AAPL | Stock | 18.8729 | 18.8746 | 18.8729 | 18.8746 | 6440.0 |
| 2014-02-28 08:42:00 | AAPL | Stock | 18.8732 | 18.8775 | 18.8732 | 18.8775 | 8400.0 |
| 2014-02-28 08:43:00 | AAPL | Stock | 18.8793 | 18.8793 | 18.8793 | 18.8793 | 2800.0 |
| 2014-02-28 08:45:00 | AAPL | Stock | 18.8771 | 18.8771 | 18.8771 | 18.8771 | 2800.0 |
| 2014-02-28 08:47:00 | AAPL | Stock | 18.8804 | 18.8889 | 18.8804 | 18.8889 | 22400.0 |
> showing 50 of 1,095,039 rows — these rows as CSV