PREVIEW / stock_1min / 2014-01-14
file: by_date/stock_1min/2014/2014-01-14.parquet size: 14.7 MB rows: 1,058,686 symbols: 2,845
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-14 06:03:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1482 | 19.1482 | 2800.0 |
| 2014-01-14 06:06:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1482 | 19.1482 | 2800.0 |
| 2014-01-14 06:42:00 | AAPL | Stock | 19.16 | 19.1607 | 19.16 | 19.1607 | 8120.0 |
| 2014-01-14 06:43:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 2800.0 |
| 2014-01-14 06:45:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 5880.0 |
| 2014-01-14 06:47:00 | AAPL | Stock | 19.1668 | 19.1668 | 19.1668 | 19.1668 | 2800.0 |
| 2014-01-14 06:52:00 | AAPL | Stock | 19.1707 | 19.1707 | 19.1707 | 19.1707 | 2800.0 |
| 2014-01-14 06:54:00 | AAPL | Stock | 19.1575 | 19.1575 | 19.1575 | 19.1575 | 2800.0 |
| 2014-01-14 06:58:00 | AAPL | Stock | 19.1704 | 19.1704 | 19.1704 | 19.1704 | 2800.0 |
| 2014-01-14 07:00:00 | AAPL | Stock | 19.1704 | 19.1704 | 19.1704 | 19.1704 | 3080.0 |
| 2014-01-14 07:01:00 | AAPL | Stock | 19.1714 | 19.1714 | 19.1714 | 19.1714 | 8400.0 |
| 2014-01-14 07:02:00 | AAPL | Stock | 19.1714 | 19.1714 | 19.1714 | 19.1714 | 6664.0 |
| 2014-01-14 07:03:00 | AAPL | Stock | 19.1864 | 19.1864 | 19.1786 | 19.1786 | 7280.0 |
| 2014-01-14 07:05:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1768 | 19.1768 | 19600.0 |
| 2014-01-14 07:06:00 | AAPL | Stock | 19.1864 | 19.1864 | 19.1864 | 19.1864 | 4200.0 |
| 2014-01-14 07:10:00 | AAPL | Stock | 19.1875 | 19.1875 | 19.1875 | 19.1875 | 11200.0 |
| 2014-01-14 07:12:00 | AAPL | Stock | 19.1875 | 19.1875 | 19.1875 | 19.1875 | 3416.0 |
| 2014-01-14 07:15:00 | AAPL | Stock | 19.1875 | 19.2039 | 19.1875 | 19.2039 | 25060.0 |
| 2014-01-14 07:18:00 | AAPL | Stock | 19.2082 | 19.2093 | 19.2082 | 19.2093 | 5600.0 |
| 2014-01-14 07:19:00 | AAPL | Stock | 19.2146 | 19.2146 | 19.2146 | 19.2146 | 2800.0 |
| 2014-01-14 07:20:00 | AAPL | Stock | 19.2186 | 19.2196 | 19.2186 | 19.2196 | 5600.0 |
| 2014-01-14 07:21:00 | AAPL | Stock | 19.2196 | 19.2207 | 19.2196 | 19.2207 | 7700.0 |
| 2014-01-14 07:22:00 | AAPL | Stock | 19.2164 | 19.25 | 19.2164 | 19.2321 | 32564.0 |
| 2014-01-14 07:23:00 | AAPL | Stock | 19.25 | 19.25 | 19.2496 | 19.2496 | 8400.0 |
| 2014-01-14 07:24:00 | AAPL | Stock | 19.2496 | 19.2496 | 19.2496 | 19.2496 | 2800.0 |
| 2014-01-14 07:26:00 | AAPL | Stock | 19.2471 | 19.2471 | 19.2471 | 19.2471 | 2800.0 |
| 2014-01-14 07:30:00 | AAPL | Stock | 19.2346 | 19.2346 | 19.2346 | 19.2346 | 2800.0 |
| 2014-01-14 07:32:00 | AAPL | Stock | 19.2361 | 19.2414 | 19.2361 | 19.2414 | 5600.0 |
| 2014-01-14 07:34:00 | AAPL | Stock | 19.2486 | 19.25 | 19.2486 | 19.25 | 18424.0 |
| 2014-01-14 07:35:00 | AAPL | Stock | 19.2429 | 19.2429 | 19.2429 | 19.2429 | 63868.0 |
| 2014-01-14 07:36:00 | AAPL | Stock | 19.2504 | 19.255 | 19.2464 | 19.2464 | 8400.0 |
| 2014-01-14 07:37:00 | AAPL | Stock | 19.2482 | 19.2482 | 19.2482 | 19.2482 | 5600.0 |
| 2014-01-14 07:38:00 | AAPL | Stock | 19.2464 | 19.2468 | 19.2464 | 19.2468 | 8400.0 |
| 2014-01-14 07:40:00 | AAPL | Stock | 19.2504 | 19.2586 | 19.2504 | 19.2586 | 55440.0 |
| 2014-01-14 07:41:00 | AAPL | Stock | 19.2625 | 19.2629 | 19.2625 | 19.2629 | 8400.0 |
| 2014-01-14 07:42:00 | AAPL | Stock | 19.2543 | 19.2543 | 19.2536 | 19.2536 | 8400.0 |
| 2014-01-14 07:43:00 | AAPL | Stock | 19.2518 | 19.2518 | 19.2518 | 19.2518 | 5600.0 |
| 2014-01-14 07:44:00 | AAPL | Stock | 19.2568 | 19.2596 | 19.2504 | 19.2514 | 33600.0 |
| 2014-01-14 07:45:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 15260.0 |
| 2014-01-14 07:50:00 | AAPL | Stock | 19.2493 | 19.2514 | 19.2493 | 19.2507 | 8400.0 |
| 2014-01-14 07:55:00 | AAPL | Stock | 19.2564 | 19.2564 | 19.2564 | 19.2564 | 2800.0 |
| 2014-01-14 07:57:00 | AAPL | Stock | 19.2539 | 19.2575 | 19.2536 | 19.2575 | 19880.0 |
| 2014-01-14 07:59:00 | AAPL | Stock | 19.265 | 19.2679 | 19.26 | 19.26 | 22400.0 |
| 2014-01-14 08:00:00 | AAPL | Stock | 19.2654 | 19.2654 | 19.1875 | 19.2518 | 135660.0 |
| 2014-01-14 08:01:00 | AAPL | Stock | 19.2568 | 19.2568 | 19.2446 | 19.245 | 191520.0 |
| 2014-01-14 08:02:00 | AAPL | Stock | 19.2446 | 19.2482 | 19.2411 | 19.2482 | 76496.0 |
| 2014-01-14 08:03:00 | AAPL | Stock | 19.2357 | 19.2464 | 19.2357 | 19.2357 | 44800.0 |
| 2014-01-14 08:05:00 | AAPL | Stock | 19.2332 | 19.2332 | 19.2321 | 19.2321 | 5600.0 |
| 2014-01-14 08:06:00 | AAPL | Stock | 19.23 | 19.2321 | 19.2275 | 19.2275 | 91504.0 |
| 2014-01-14 08:07:00 | AAPL | Stock | 19.2321 | 19.2321 | 19.2232 | 19.2232 | 24500.0 |
> showing 50 of 1,058,686 rows — these rows as CSV