PREVIEW / stock_1min / 2014-03-24
file: by_date/stock_1min/2014/2014-03-24.parquet size: 15.4 MB rows: 1,099,379 symbols: 2,876
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-03-24 04:00:00 | AAPL | Stock | 19.1425 | 19.1511 | 19.1425 | 19.1511 | 5600.0 |
| 2014-03-24 04:03:00 | AAPL | Stock | 19.2321 | 19.2321 | 19.2321 | 19.2321 | 2800.0 |
| 2014-03-24 04:14:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 2800.0 |
| 2014-03-24 04:15:00 | AAPL | Stock | 19.2607 | 19.2857 | 19.2607 | 19.2857 | 14560.0 |
| 2014-03-24 04:18:00 | AAPL | Stock | 19.3439 | 19.3443 | 19.3439 | 19.3443 | 11200.0 |
| 2014-03-24 04:19:00 | AAPL | Stock | 19.3571 | 19.3711 | 19.3571 | 19.3711 | 11200.0 |
| 2014-03-24 04:22:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2929 | 19.2929 | 2800.0 |
| 2014-03-24 04:30:00 | AAPL | Stock | 19.3086 | 19.3086 | 19.3054 | 19.3054 | 5600.0 |
| 2014-03-24 04:31:00 | AAPL | Stock | 19.3054 | 19.3054 | 19.3054 | 19.3054 | 19600.0 |
| 2014-03-24 04:32:00 | AAPL | Stock | 19.3054 | 19.3214 | 19.3054 | 19.3214 | 8400.0 |
| 2014-03-24 04:34:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 28000.0 |
| 2014-03-24 04:35:00 | AAPL | Stock | 19.3057 | 19.3057 | 19.3057 | 19.3057 | 2800.0 |
| 2014-03-24 04:36:00 | AAPL | Stock | 19.2929 | 19.3057 | 19.2929 | 19.3057 | 16800.0 |
| 2014-03-24 04:37:00 | AAPL | Stock | 19.3057 | 19.3079 | 19.3057 | 19.3079 | 5600.0 |
| 2014-03-24 04:39:00 | AAPL | Stock | 19.2886 | 19.2886 | 19.2886 | 19.2886 | 26376.0 |
| 2014-03-24 04:41:00 | AAPL | Stock | 19.2889 | 19.2889 | 19.2889 | 19.2889 | 2800.0 |
| 2014-03-24 04:45:00 | AAPL | Stock | 19.2889 | 19.2964 | 19.2889 | 19.2964 | 30800.0 |
| 2014-03-24 04:46:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.29 | 19.29 | 18228.0 |
| 2014-03-24 04:49:00 | AAPL | Stock | 19.2964 | 19.3036 | 19.2964 | 19.3036 | 30800.0 |
| 2014-03-24 04:50:00 | AAPL | Stock | 19.3204 | 19.3214 | 19.3204 | 19.3214 | 27944.0 |
| 2014-03-24 04:51:00 | AAPL | Stock | 19.3086 | 19.3086 | 19.3086 | 19.3086 | 5628.0 |
| 2014-03-24 04:53:00 | AAPL | Stock | 19.2775 | 19.2964 | 19.2743 | 19.2964 | 42000.0 |
| 2014-03-24 04:55:00 | AAPL | Stock | 19.2871 | 19.2871 | 19.2871 | 19.2871 | 5600.0 |
| 2014-03-24 04:56:00 | AAPL | Stock | 19.2871 | 19.2871 | 19.2871 | 19.2871 | 56000.0 |
| 2014-03-24 04:57:00 | AAPL | Stock | 19.2875 | 19.2875 | 19.2857 | 19.2857 | 30800.0 |
| 2014-03-24 04:58:00 | AAPL | Stock | 19.2964 | 19.2964 | 19.2964 | 19.2964 | 28000.0 |
| 2014-03-24 05:00:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 29400.0 |
| 2014-03-24 05:02:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2856.0 |
| 2014-03-24 05:05:00 | AAPL | Stock | 19.2946 | 19.2946 | 19.2946 | 19.2946 | 28000.0 |
| 2014-03-24 05:07:00 | AAPL | Stock | 19.2946 | 19.2946 | 19.2743 | 19.2743 | 30800.0 |
| 2014-03-24 05:12:00 | AAPL | Stock | 19.2679 | 19.2693 | 19.2679 | 19.2693 | 11228.0 |
| 2014-03-24 05:13:00 | AAPL | Stock | 19.2625 | 19.2625 | 19.2625 | 19.2625 | 3920.0 |
| 2014-03-24 05:15:00 | AAPL | Stock | 19.2539 | 19.2539 | 19.2161 | 19.2161 | 47600.0 |
| 2014-03-24 05:20:00 | AAPL | Stock | 19.2179 | 19.2179 | 19.2179 | 19.2179 | 28000.0 |
| 2014-03-24 05:22:00 | AAPL | Stock | 19.2111 | 19.2111 | 19.2111 | 19.2111 | 40572.0 |
| 2014-03-24 05:23:00 | AAPL | Stock | 19.2111 | 19.2111 | 19.2111 | 19.2111 | 11200.0 |
| 2014-03-24 05:26:00 | AAPL | Stock | 19.1879 | 19.1918 | 19.1786 | 19.1918 | 86828.0 |
| 2014-03-24 05:27:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1786 | 19.1786 | 5600.0 |
| 2014-03-24 05:30:00 | AAPL | Stock | 19.1821 | 19.1857 | 19.1821 | 19.1857 | 28000.0 |
| 2014-03-24 05:32:00 | AAPL | Stock | 19.2054 | 19.2064 | 19.2043 | 19.2064 | 30296.0 |
| 2014-03-24 05:33:00 | AAPL | Stock | 19.2064 | 19.2071 | 19.2064 | 19.2071 | 14000.0 |
| 2014-03-24 05:36:00 | AAPL | Stock | 19.2071 | 19.2071 | 19.2071 | 19.2071 | 18200.0 |
| 2014-03-24 05:44:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2068 | 19.2068 | 5600.0 |
| 2014-03-24 05:48:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 28000.0 |
| 2014-03-24 05:51:00 | AAPL | Stock | 19.1857 | 19.1857 | 19.1789 | 19.1789 | 30016.0 |
| 2014-03-24 05:59:00 | AAPL | Stock | 19.2282 | 19.2282 | 19.2282 | 19.2282 | 14000.0 |
| 2014-03-24 06:02:00 | AAPL | Stock | 19.2279 | 19.2279 | 19.2279 | 19.2279 | 2800.0 |
| 2014-03-24 06:05:00 | AAPL | Stock | 19.2279 | 19.2279 | 19.2279 | 19.2279 | 2800.0 |
| 2014-03-24 06:21:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1971 | 19.1971 | 5404.0 |
| 2014-03-24 06:22:00 | AAPL | Stock | 19.1804 | 19.1971 | 19.1804 | 19.1971 | 5600.0 |
> showing 50 of 1,099,379 rows — these rows as CSV