PREVIEW / stock_1min / 2014-02-06
file: by_date/stock_1min/2014/2014-02-06.parquet size: 14.5 MB rows: 1,058,474 symbols: 2,881
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-06 04:00:00 | AAPL | Stock | 18.2311 | 18.3214 | 18.2311 | 18.3214 | 5600.0 |
| 2014-02-06 04:16:00 | AAPL | Stock | 18.2661 | 18.2661 | 18.2661 | 18.2661 | 2800.0 |
| 2014-02-06 04:49:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2407 | 18.2407 | 2800.0 |
| 2014-02-06 04:53:00 | AAPL | Stock | 18.2664 | 18.2679 | 18.2664 | 18.2679 | 11480.0 |
| 2014-02-06 05:07:00 | AAPL | Stock | 18.2857 | 18.2914 | 18.2857 | 18.2857 | 11200.0 |
| 2014-02-06 05:08:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 5600.0 |
| 2014-02-06 05:09:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 8400.0 |
| 2014-02-06 05:13:00 | AAPL | Stock | 18.2843 | 18.2857 | 18.2843 | 18.2857 | 8400.0 |
| 2014-02-06 05:27:00 | AAPL | Stock | 18.2843 | 18.2843 | 18.2843 | 18.2843 | 2800.0 |
| 2014-02-06 05:28:00 | AAPL | Stock | 18.2754 | 18.2754 | 18.2754 | 18.2754 | 2800.0 |
| 2014-02-06 05:29:00 | AAPL | Stock | 18.2821 | 18.2821 | 18.2821 | 18.2821 | 5600.0 |
| 2014-02-06 06:00:00 | AAPL | Stock | 18.2718 | 18.2732 | 18.2718 | 18.2732 | 7392.0 |
| 2014-02-06 06:08:00 | AAPL | Stock | 18.2679 | 18.2679 | 18.2679 | 18.2679 | 2800.0 |
| 2014-02-06 06:18:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2186 | 18.2186 | 13160.0 |
| 2014-02-06 06:19:00 | AAPL | Stock | 18.2186 | 18.2186 | 18.2186 | 18.2186 | 9296.0 |
| 2014-02-06 06:20:00 | AAPL | Stock | 18.2186 | 18.2186 | 18.2129 | 18.2129 | 19488.0 |
| 2014-02-06 06:29:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2407 | 18.2407 | 22400.0 |
| 2014-02-06 06:32:00 | AAPL | Stock | 18.2514 | 18.2514 | 18.2514 | 18.2514 | 2800.0 |
| 2014-02-06 06:45:00 | AAPL | Stock | 18.2321 | 18.2321 | 18.2321 | 18.2321 | 19600.0 |
| 2014-02-06 06:46:00 | AAPL | Stock | 18.2321 | 18.2321 | 18.2321 | 18.2321 | 5600.0 |
| 2014-02-06 07:00:00 | AAPL | Stock | 18.2321 | 18.2575 | 18.2321 | 18.2575 | 5600.0 |
| 2014-02-06 07:03:00 | AAPL | Stock | 18.2625 | 18.2643 | 18.2625 | 18.2625 | 14000.0 |
| 2014-02-06 07:04:00 | AAPL | Stock | 18.265 | 18.2657 | 18.265 | 18.2657 | 11788.0 |
| 2014-02-06 07:05:00 | AAPL | Stock | 18.2661 | 18.2732 | 18.2657 | 18.2657 | 79800.0 |
| 2014-02-06 07:08:00 | AAPL | Stock | 18.2571 | 18.2571 | 18.2571 | 18.2571 | 16800.0 |
| 2014-02-06 07:11:00 | AAPL | Stock | 18.2357 | 18.2357 | 18.2336 | 18.2336 | 18620.0 |
| 2014-02-06 07:12:00 | AAPL | Stock | 18.2357 | 18.2357 | 18.2336 | 18.2336 | 18620.0 |
| 2014-02-06 07:15:00 | AAPL | Stock | 18.2393 | 18.2393 | 18.2393 | 18.2393 | 4480.0 |
| 2014-02-06 07:19:00 | AAPL | Stock | 18.2404 | 18.2404 | 18.2404 | 18.2404 | 5600.0 |
| 2014-02-06 07:20:00 | AAPL | Stock | 18.2325 | 18.2325 | 18.2321 | 18.2321 | 5600.0 |
| 2014-02-06 07:28:00 | AAPL | Stock | 18.2268 | 18.2268 | 18.2268 | 18.2268 | 2800.0 |
| 2014-02-06 07:29:00 | AAPL | Stock | 18.2268 | 18.2268 | 18.2268 | 18.2268 | 2800.0 |
| 2014-02-06 07:31:00 | AAPL | Stock | 18.2179 | 18.2179 | 18.2143 | 18.2143 | 21672.0 |
| 2014-02-06 07:32:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2054 | 18.2054 | 15344.0 |
| 2014-02-06 07:34:00 | AAPL | Stock | 18.2086 | 18.2086 | 18.2086 | 18.2086 | 2800.0 |
| 2014-02-06 07:42:00 | AAPL | Stock | 18.2161 | 18.2161 | 18.2161 | 18.2161 | 2800.0 |
| 2014-02-06 07:44:00 | AAPL | Stock | 18.1986 | 18.1986 | 18.1964 | 18.1986 | 25116.0 |
| 2014-02-06 07:45:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1857 | 18.1857 | 24920.0 |
| 2014-02-06 07:46:00 | AAPL | Stock | 18.1825 | 18.1825 | 18.1825 | 18.1825 | 2800.0 |
| 2014-02-06 07:51:00 | AAPL | Stock | 18.1954 | 18.1964 | 18.1954 | 18.1964 | 11200.0 |
| 2014-02-06 07:52:00 | AAPL | Stock | 18.2 | 18.2139 | 18.2 | 18.2129 | 39200.0 |
| 2014-02-06 07:53:00 | AAPL | Stock | 18.2161 | 18.2196 | 18.2161 | 18.2182 | 22400.0 |
| 2014-02-06 07:56:00 | AAPL | Stock | 18.2086 | 18.2086 | 18.2071 | 18.2071 | 28000.0 |
| 2014-02-06 07:57:00 | AAPL | Stock | 18.2136 | 18.2143 | 18.2136 | 18.2143 | 19600.0 |
| 2014-02-06 07:58:00 | AAPL | Stock | 18.2071 | 18.2071 | 18.2071 | 18.2071 | 2800.0 |
| 2014-02-06 07:59:00 | AAPL | Stock | 18.2132 | 18.2132 | 18.2071 | 18.2071 | 30800.0 |
| 2014-02-06 08:00:00 | AAPL | Stock | 18.1982 | 18.2657 | 18.1964 | 18.2 | 74172.0 |
| 2014-02-06 08:01:00 | AAPL | Stock | 18.19 | 18.19 | 18.19 | 18.19 | 2800.0 |
| 2014-02-06 08:02:00 | AAPL | Stock | 18.1996 | 18.2171 | 18.1996 | 18.2171 | 153552.0 |
| 2014-02-06 08:03:00 | AAPL | Stock | 18.2171 | 18.2179 | 18.2171 | 18.2179 | 25200.0 |
> showing 50 of 1,058,474 rows — these rows as CSV