PREVIEW / stock_1min / 2014-01-10
file: by_date/stock_1min/2014/2014-01-10.parquet size: 14.6 MB rows: 1,056,327 symbols: 2,849
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-01-10 04:02:00 | AAPL | Stock | 19.1957 | 19.1957 | 19.175 | 19.175 | 5600.0 |
| 2014-01-10 04:18:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 6020.0 |
| 2014-01-10 04:25:00 | AAPL | Stock | 19.1968 | 19.1968 | 19.1968 | 19.1968 | 2800.0 |
| 2014-01-10 04:26:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2014-01-10 04:36:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 11900.0 |
| 2014-01-10 05:33:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 2800.0 |
| 2014-01-10 05:39:00 | AAPL | Stock | 19.2579 | 19.2579 | 19.2579 | 19.2579 | 5600.0 |
| 2014-01-10 05:42:00 | AAPL | Stock | 19.2468 | 19.2468 | 19.2464 | 19.2464 | 5600.0 |
| 2014-01-10 06:02:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 5600.0 |
| 2014-01-10 06:04:00 | AAPL | Stock | 19.2504 | 19.2504 | 19.2504 | 19.2504 | 2800.0 |
| 2014-01-10 06:23:00 | AAPL | Stock | 19.2464 | 19.2575 | 19.2464 | 19.2575 | 8400.0 |
| 2014-01-10 06:38:00 | AAPL | Stock | 19.2575 | 19.2575 | 19.2575 | 19.2575 | 4900.0 |
| 2014-01-10 06:46:00 | AAPL | Stock | 19.2464 | 19.2464 | 19.2464 | 19.2464 | 5600.0 |
| 2014-01-10 06:47:00 | AAPL | Stock | 19.2464 | 19.2464 | 19.2464 | 19.2464 | 2800.0 |
| 2014-01-10 06:48:00 | AAPL | Stock | 19.2479 | 19.2479 | 19.2479 | 19.2479 | 2800.0 |
| 2014-01-10 06:55:00 | AAPL | Stock | 19.2504 | 19.2504 | 19.2504 | 19.2504 | 2800.0 |
| 2014-01-10 06:57:00 | AAPL | Stock | 19.2479 | 19.2479 | 19.2439 | 19.2439 | 8400.0 |
| 2014-01-10 06:58:00 | AAPL | Stock | 19.2407 | 19.2407 | 19.2407 | 19.2407 | 2800.0 |
| 2014-01-10 07:05:00 | AAPL | Stock | 19.2532 | 19.2532 | 19.25 | 19.25 | 8400.0 |
| 2014-01-10 07:07:00 | AAPL | Stock | 19.2461 | 19.25 | 19.2461 | 19.25 | 8400.0 |
| 2014-01-10 07:08:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 2800.0 |
| 2014-01-10 07:09:00 | AAPL | Stock | 19.2464 | 19.2464 | 19.2464 | 19.2464 | 5600.0 |
| 2014-01-10 07:10:00 | AAPL | Stock | 19.2464 | 19.2464 | 19.2464 | 19.2464 | 2800.0 |
| 2014-01-10 07:18:00 | AAPL | Stock | 19.2457 | 19.2464 | 19.2457 | 19.2464 | 5600.0 |
| 2014-01-10 07:22:00 | AAPL | Stock | 19.2411 | 19.2411 | 19.2411 | 19.2411 | 2800.0 |
| 2014-01-10 07:25:00 | AAPL | Stock | 19.2364 | 19.2364 | 19.2364 | 19.2364 | 5600.0 |
| 2014-01-10 07:33:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 6692.0 |
| 2014-01-10 07:35:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 8428.0 |
| 2014-01-10 07:40:00 | AAPL | Stock | 19.2468 | 19.2536 | 19.2468 | 19.25 | 15820.0 |
| 2014-01-10 07:42:00 | AAPL | Stock | 19.255 | 19.2607 | 19.255 | 19.2579 | 22400.0 |
| 2014-01-10 07:43:00 | AAPL | Stock | 19.2618 | 19.2621 | 19.2618 | 19.2621 | 5600.0 |
| 2014-01-10 07:44:00 | AAPL | Stock | 19.2621 | 19.2621 | 19.2621 | 19.2621 | 2800.0 |
| 2014-01-10 07:46:00 | AAPL | Stock | 19.2668 | 19.2679 | 19.2643 | 19.2643 | 148400.0 |
| 2014-01-10 07:47:00 | AAPL | Stock | 19.2629 | 19.2679 | 19.2629 | 19.2675 | 8400.0 |
| 2014-01-10 07:48:00 | AAPL | Stock | 19.2671 | 19.2971 | 19.2632 | 19.2971 | 55440.0 |
| 2014-01-10 07:49:00 | AAPL | Stock | 19.3086 | 19.3086 | 19.3086 | 19.3086 | 2800.0 |
| 2014-01-10 07:50:00 | AAPL | Stock | 19.3157 | 19.3157 | 19.3118 | 19.3157 | 70000.0 |
| 2014-01-10 07:51:00 | AAPL | Stock | 19.3104 | 19.3179 | 19.3104 | 19.3179 | 61600.0 |
| 2014-01-10 07:52:00 | AAPL | Stock | 19.3389 | 19.3739 | 19.3389 | 19.3561 | 120400.0 |
| 2014-01-10 07:53:00 | AAPL | Stock | 19.3571 | 19.3629 | 19.3521 | 19.3529 | 58800.0 |
| 2014-01-10 07:54:00 | AAPL | Stock | 19.3521 | 19.3521 | 19.3393 | 19.3518 | 36400.0 |
| 2014-01-10 07:55:00 | AAPL | Stock | 19.3564 | 19.3693 | 19.3564 | 19.3693 | 75600.0 |
| 2014-01-10 07:56:00 | AAPL | Stock | 19.3593 | 19.3607 | 19.3593 | 19.3607 | 5600.0 |
| 2014-01-10 07:57:00 | AAPL | Stock | 19.3611 | 19.3661 | 19.3571 | 19.3571 | 64400.0 |
| 2014-01-10 07:58:00 | AAPL | Stock | 19.3571 | 19.3571 | 19.3543 | 19.3543 | 5600.0 |
| 2014-01-10 07:59:00 | AAPL | Stock | 19.3661 | 19.3679 | 19.3661 | 19.3679 | 44800.0 |
| 2014-01-10 08:00:00 | AAPL | Stock | 19.3625 | 19.3625 | 19.2857 | 19.3571 | 173320.0 |
| 2014-01-10 08:01:00 | AAPL | Stock | 19.3571 | 19.3589 | 19.3518 | 19.3518 | 51520.0 |
| 2014-01-10 08:02:00 | AAPL | Stock | 19.3411 | 19.3411 | 19.3336 | 19.3336 | 31948.0 |
| 2014-01-10 08:03:00 | AAPL | Stock | 19.3254 | 19.3254 | 19.3157 | 19.3182 | 14000.0 |
> showing 50 of 1,056,327 rows — these rows as CSV