PREVIEW / stock_1min / 2013-05-14
file: by_date/stock_1min/2013/2013-05-14.parquet size: 13.5 MB rows: 986,229 symbols: 2,850
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-05-14 05:00:00 | AAPL | Stock | 16.1929 | 16.1929 | 16.1929 | 16.1929 | 3920.0 |
| 2013-05-14 05:59:00 | AAPL | Stock | 16.1871 | 16.1871 | 16.1871 | 16.1871 | 7364.0 |
| 2013-05-14 06:01:00 | AAPL | Stock | 16.1804 | 16.1804 | 16.1804 | 16.1804 | 2800.0 |
| 2013-05-14 07:14:00 | AAPL | Stock | 16.1982 | 16.1982 | 16.1982 | 16.1982 | 3192.0 |
| 2013-05-14 07:23:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 8400.0 |
| 2013-05-14 07:27:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 2800.0 |
| 2013-05-14 07:28:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 2800.0 |
| 2013-05-14 07:30:00 | AAPL | Stock | 16.2018 | 16.2018 | 16.2018 | 16.2018 | 2800.0 |
| 2013-05-14 07:34:00 | AAPL | Stock | 16.2054 | 16.2054 | 16.2054 | 16.2054 | 5600.0 |
| 2013-05-14 07:35:00 | AAPL | Stock | 16.2054 | 16.2054 | 16.1646 | 16.1646 | 43568.0 |
| 2013-05-14 07:39:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 16800.0 |
| 2013-05-14 07:44:00 | AAPL | Stock | 16.1964 | 16.1964 | 16.1964 | 16.1964 | 11200.0 |
| 2013-05-14 07:45:00 | AAPL | Stock | 16.2121 | 16.2143 | 16.2121 | 16.2143 | 8904.0 |
| 2013-05-14 07:46:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2121 | 16.2121 | 8428.0 |
| 2013-05-14 07:50:00 | AAPL | Stock | 16.2243 | 16.2321 | 16.2232 | 16.2321 | 9800.0 |
| 2013-05-14 07:51:00 | AAPL | Stock | 16.2321 | 16.25 | 16.2321 | 16.25 | 16800.0 |
| 2013-05-14 07:52:00 | AAPL | Stock | 16.2643 | 16.2643 | 16.2643 | 16.2643 | 2800.0 |
| 2013-05-14 07:54:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 25200.0 |
| 2013-05-14 07:55:00 | AAPL | Stock | 16.2507 | 16.2511 | 16.25 | 16.25 | 30800.0 |
| 2013-05-14 07:57:00 | AAPL | Stock | 16.2675 | 16.2675 | 16.2675 | 16.2675 | 5600.0 |
| 2013-05-14 08:00:00 | AAPL | Stock | 16.2589 | 16.2782 | 16.1786 | 16.2679 | 110740.0 |
| 2013-05-14 08:01:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 5600.0 |
| 2013-05-14 08:02:00 | AAPL | Stock | 16.2636 | 16.2679 | 16.2636 | 16.2679 | 5600.0 |
| 2013-05-14 08:03:00 | AAPL | Stock | 16.2679 | 16.2857 | 16.2679 | 16.2857 | 74760.0 |
| 2013-05-14 08:04:00 | AAPL | Stock | 16.2904 | 16.2904 | 16.2771 | 16.2771 | 29568.0 |
| 2013-05-14 08:05:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 8400.0 |
| 2013-05-14 08:08:00 | AAPL | Stock | 16.2711 | 16.2843 | 16.2711 | 16.2843 | 28028.0 |
| 2013-05-14 08:10:00 | AAPL | Stock | 16.2821 | 16.2821 | 16.2814 | 16.2814 | 5600.0 |
| 2013-05-14 08:13:00 | AAPL | Stock | 16.265 | 16.2679 | 16.2625 | 16.2679 | 22400.0 |
| 2013-05-14 08:14:00 | AAPL | Stock | 16.2643 | 16.2679 | 16.26 | 16.2679 | 63840.0 |
| 2013-05-14 08:15:00 | AAPL | Stock | 16.2589 | 16.2761 | 16.2514 | 16.2521 | 121296.0 |
| 2013-05-14 08:16:00 | AAPL | Stock | 16.2589 | 16.2589 | 16.2471 | 16.2471 | 43652.0 |
| 2013-05-14 08:17:00 | AAPL | Stock | 16.2507 | 16.2618 | 16.2507 | 16.2618 | 58800.0 |
| 2013-05-14 08:18:00 | AAPL | Stock | 16.2511 | 16.2532 | 16.2511 | 16.2511 | 14000.0 |
| 2013-05-14 08:19:00 | AAPL | Stock | 16.2475 | 16.25 | 16.2475 | 16.25 | 16520.0 |
| 2013-05-14 08:20:00 | AAPL | Stock | 16.2414 | 16.2496 | 16.2407 | 16.2496 | 11200.0 |
| 2013-05-14 08:21:00 | AAPL | Stock | 16.2379 | 16.2379 | 16.2379 | 16.2379 | 11200.0 |
| 2013-05-14 08:22:00 | AAPL | Stock | 16.2446 | 16.2446 | 16.2325 | 16.2325 | 30800.0 |
| 2013-05-14 08:23:00 | AAPL | Stock | 16.2411 | 16.2411 | 16.2411 | 16.2411 | 5600.0 |
| 2013-05-14 08:24:00 | AAPL | Stock | 16.2482 | 16.25 | 16.2482 | 16.25 | 18200.0 |
| 2013-05-14 08:25:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-05-14 08:26:00 | AAPL | Stock | 16.2661 | 16.2671 | 16.25 | 16.25 | 55384.0 |
| 2013-05-14 08:27:00 | AAPL | Stock | 16.25 | 16.25 | 16.2325 | 16.2325 | 30800.0 |
| 2013-05-14 08:28:00 | AAPL | Stock | 16.2232 | 16.2232 | 16.2143 | 16.2143 | 28000.0 |
| 2013-05-14 08:29:00 | AAPL | Stock | 16.2143 | 16.2232 | 16.2143 | 16.2232 | 13804.0 |
| 2013-05-14 08:30:00 | AAPL | Stock | 16.2161 | 16.2218 | 16.2161 | 16.2218 | 5600.0 |
| 2013-05-14 08:31:00 | AAPL | Stock | 16.2214 | 16.2214 | 16.2179 | 16.2179 | 19600.0 |
| 2013-05-14 08:33:00 | AAPL | Stock | 16.2146 | 16.2146 | 16.2061 | 16.2107 | 26600.0 |
| 2013-05-14 08:34:00 | AAPL | Stock | 16.2071 | 16.2071 | 16.2054 | 16.2071 | 8624.0 |
| 2013-05-14 08:36:00 | AAPL | Stock | 16.1964 | 16.2036 | 16.1964 | 16.2036 | 32228.0 |
> showing 50 of 986,229 rows — these rows as CSV