PREVIEW / stock_5min / 2014-03-24
file: by_date/stock_5min/2014/2014-03-24.parquet size: 5.5 MB rows: 363,968 symbols: 3,552
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.2321 | 19.1425 | 19.2321 | 8400.0 |
| 2014-03-24 04:10:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 2800.0 |
| 2014-03-24 04:15:00 | AAPL | Stock | 19.2607 | 19.3711 | 19.2607 | 19.3711 | 36960.0 |
| 2014-03-24 04:20:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2929 | 19.2929 | 2800.0 |
| 2014-03-24 04:30:00 | AAPL | Stock | 19.3086 | 19.3214 | 19.3054 | 19.3214 | 61600.0 |
| 2014-03-24 04:35:00 | AAPL | Stock | 19.3057 | 19.3079 | 19.2886 | 19.2886 | 51576.0 |
| 2014-03-24 04:40:00 | AAPL | Stock | 19.2889 | 19.2889 | 19.2889 | 19.2889 | 2800.0 |
| 2014-03-24 04:45:00 | AAPL | Stock | 19.2889 | 19.3036 | 19.2889 | 19.3036 | 79828.0 |
| 2014-03-24 04:50:00 | AAPL | Stock | 19.3204 | 19.3214 | 19.2743 | 19.2964 | 75572.0 |
| 2014-03-24 04:55:00 | AAPL | Stock | 19.2871 | 19.2964 | 19.2857 | 19.2964 | 120400.0 |
| 2014-03-24 05:00:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2857 | 19.2857 | 32256.0 |
| 2014-03-24 05:05:00 | AAPL | Stock | 19.2946 | 19.2946 | 19.2743 | 19.2743 | 58800.0 |
| 2014-03-24 05:10:00 | AAPL | Stock | 19.2679 | 19.2693 | 19.2625 | 19.2625 | 15148.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.2111 | 19.2111 | 79772.0 |
| 2014-03-24 05:25:00 | AAPL | Stock | 19.1879 | 19.1964 | 19.1786 | 19.1786 | 92428.0 |
| 2014-03-24 05:30:00 | AAPL | Stock | 19.1821 | 19.2071 | 19.1821 | 19.2071 | 72296.0 |
| 2014-03-24 05:35:00 | AAPL | Stock | 19.2071 | 19.2071 | 19.2071 | 19.2071 | 18200.0 |
| 2014-03-24 05:40:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2068 | 19.2068 | 5600.0 |
| 2014-03-24 05:45:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 28000.0 |
| 2014-03-24 05:50:00 | AAPL | Stock | 19.1857 | 19.1857 | 19.1789 | 19.1789 | 30016.0 |
| 2014-03-24 05:55:00 | AAPL | Stock | 19.2282 | 19.2282 | 19.2282 | 19.2282 | 14000.0 |
| 2014-03-24 06:00: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:20:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1804 | 19.1971 | 11004.0 |
| 2014-03-24 06:25:00 | AAPL | Stock | 19.1971 | 19.1975 | 19.1971 | 19.1975 | 14756.0 |
| 2014-03-24 06:30:00 | AAPL | Stock | 19.1907 | 19.2 | 19.1907 | 19.2 | 16800.0 |
| 2014-03-24 06:40:00 | AAPL | Stock | 19.1979 | 19.1979 | 19.1964 | 19.1964 | 5600.0 |
| 2014-03-24 06:45:00 | AAPL | Stock | 19.1964 | 19.2107 | 19.1964 | 19.2107 | 39200.0 |
| 2014-03-24 06:55:00 | AAPL | Stock | 19.2125 | 19.2125 | 19.2125 | 19.2125 | 5600.0 |
| 2014-03-24 07:00:00 | AAPL | Stock | 19.215 | 19.25 | 19.2093 | 19.2446 | 87360.0 |
| 2014-03-24 07:05:00 | AAPL | Stock | 19.25 | 19.2729 | 19.2471 | 19.2661 | 104720.0 |
| 2014-03-24 07:10:00 | AAPL | Stock | 19.2654 | 19.2821 | 19.2571 | 19.2821 | 161756.0 |
| 2014-03-24 07:15:00 | AAPL | Stock | 19.2836 | 19.3179 | 19.2821 | 19.3071 | 209076.0 |
| 2014-03-24 07:20:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2939 | 19.2946 | 20020.0 |
| 2014-03-24 07:25:00 | AAPL | Stock | 19.285 | 19.285 | 19.25 | 19.2636 | 101080.0 |
| 2014-03-24 07:30:00 | AAPL | Stock | 19.2643 | 19.2782 | 19.2582 | 19.2782 | 77672.0 |
| 2014-03-24 07:35:00 | AAPL | Stock | 19.2729 | 19.2768 | 19.2668 | 19.2768 | 11340.0 |
| 2014-03-24 07:40:00 | AAPL | Stock | 19.2682 | 19.2682 | 19.26 | 19.26 | 42000.0 |
| 2014-03-24 07:45:00 | AAPL | Stock | 19.2643 | 19.2739 | 19.25 | 19.25 | 72800.0 |
| 2014-03-24 07:50:00 | AAPL | Stock | 19.2621 | 19.2646 | 19.2504 | 19.2646 | 45640.0 |
| 2014-03-24 07:55:00 | AAPL | Stock | 19.2646 | 19.2893 | 19.2625 | 19.2893 | 151312.0 |
| 2014-03-24 08:00:00 | AAPL | Stock | 19.2871 | 19.3152 | 19.2164 | 19.225 | 834652.0 |
| 2014-03-24 08:05:00 | AAPL | Stock | 19.2204 | 19.2304 | 19.2057 | 19.21 | 225456.0 |
| 2014-03-24 08:10:00 | AAPL | Stock | 19.21 | 19.2443 | 19.21 | 19.2443 | 212744.0 |
| 2014-03-24 08:15:00 | AAPL | Stock | 19.2432 | 19.2589 | 19.2368 | 19.2518 | 314944.0 |
| 2014-03-24 08:20:00 | AAPL | Stock | 19.25 | 19.25 | 19.2236 | 19.2321 | 266364.0 |
| 2014-03-24 08:25:00 | AAPL | Stock | 19.2322 | 19.2357 | 19.2182 | 19.2182 | 154000.0 |
| 2014-03-24 08:30:00 | AAPL | Stock | 19.2321 | 19.2321 | 19.2179 | 19.2221 | 184660.0 |
| 2014-03-24 08:35:00 | AAPL | Stock | 19.2318 | 19.2418 | 19.2239 | 19.2239 | 152040.0 |
> showing 50 of 363,968 rows — these rows as CSV