PREVIEW / stock_5min / 2014-02-06
file: by_date/stock_5min/2014/2014-02-06.parquet size: 5.5 MB rows: 359,828 symbols: 3,556
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:15:00 | AAPL | Stock | 18.2661 | 18.2661 | 18.2661 | 18.2661 | 2800.0 |
| 2014-02-06 04:45:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2407 | 18.2407 | 2800.0 |
| 2014-02-06 04:50:00 | AAPL | Stock | 18.2664 | 18.2679 | 18.2664 | 18.2679 | 11480.0 |
| 2014-02-06 05:05:00 | AAPL | Stock | 18.2857 | 18.2914 | 18.2857 | 18.2857 | 25200.0 |
| 2014-02-06 05:10:00 | AAPL | Stock | 18.2843 | 18.2857 | 18.2843 | 18.2857 | 8400.0 |
| 2014-02-06 05:25:00 | AAPL | Stock | 18.2843 | 18.2843 | 18.2754 | 18.2821 | 11200.0 |
| 2014-02-06 06:00:00 | AAPL | Stock | 18.2718 | 18.2732 | 18.2718 | 18.2732 | 7392.0 |
| 2014-02-06 06:05:00 | AAPL | Stock | 18.2679 | 18.2679 | 18.2679 | 18.2679 | 2800.0 |
| 2014-02-06 06:15:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2186 | 18.2186 | 22456.0 |
| 2014-02-06 06:20:00 | AAPL | Stock | 18.2186 | 18.2186 | 18.2129 | 18.2129 | 19488.0 |
| 2014-02-06 06:25:00 | AAPL | Stock | 18.2407 | 18.2407 | 18.2407 | 18.2407 | 22400.0 |
| 2014-02-06 06:30: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 | 25200.0 |
| 2014-02-06 07:00:00 | AAPL | Stock | 18.2321 | 18.2657 | 18.2321 | 18.2657 | 31388.0 |
| 2014-02-06 07:05:00 | AAPL | Stock | 18.2661 | 18.2732 | 18.2571 | 18.2571 | 96600.0 |
| 2014-02-06 07:10:00 | AAPL | Stock | 18.2357 | 18.2357 | 18.2336 | 18.2336 | 37240.0 |
| 2014-02-06 07:15:00 | AAPL | Stock | 18.2393 | 18.2404 | 18.2393 | 18.2404 | 10080.0 |
| 2014-02-06 07:20:00 | AAPL | Stock | 18.2325 | 18.2325 | 18.2321 | 18.2321 | 5600.0 |
| 2014-02-06 07:25:00 | AAPL | Stock | 18.2268 | 18.2268 | 18.2268 | 18.2268 | 5600.0 |
| 2014-02-06 07:30:00 | AAPL | Stock | 18.2179 | 18.2179 | 18.2054 | 18.2086 | 39816.0 |
| 2014-02-06 07:40:00 | AAPL | Stock | 18.2161 | 18.2161 | 18.1964 | 18.1986 | 27916.0 |
| 2014-02-06 07:45:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1825 | 18.1825 | 27720.0 |
| 2014-02-06 07:50:00 | AAPL | Stock | 18.1954 | 18.2196 | 18.1954 | 18.2182 | 72800.0 |
| 2014-02-06 07:55:00 | AAPL | Stock | 18.2086 | 18.2143 | 18.2071 | 18.2071 | 81200.0 |
| 2014-02-06 08:00:00 | AAPL | Stock | 18.1982 | 18.2657 | 18.19 | 18.1982 | 269752.0 |
| 2014-02-06 08:05:00 | AAPL | Stock | 18.2018 | 18.2139 | 18.1846 | 18.2079 | 172032.0 |
| 2014-02-06 08:10:00 | AAPL | Stock | 18.1896 | 18.19 | 18.1875 | 18.1893 | 71400.0 |
| 2014-02-06 08:15:00 | AAPL | Stock | 18.1964 | 18.1971 | 18.1964 | 18.1971 | 19488.0 |
| 2014-02-06 08:20:00 | AAPL | Stock | 18.1964 | 18.2129 | 18.1964 | 18.2071 | 73752.0 |
| 2014-02-06 08:25:00 | AAPL | Stock | 18.2029 | 18.2261 | 18.2029 | 18.2179 | 92204.0 |
| 2014-02-06 08:30:00 | AAPL | Stock | 18.2179 | 18.2264 | 18.2057 | 18.2057 | 231812.0 |
| 2014-02-06 08:35:00 | AAPL | Stock | 18.2054 | 18.2268 | 18.2054 | 18.2143 | 233940.0 |
| 2014-02-06 08:40:00 | AAPL | Stock | 18.2139 | 18.2164 | 18.2136 | 18.2164 | 42000.0 |
| 2014-02-06 08:45:00 | AAPL | Stock | 18.2154 | 18.2179 | 18.1989 | 18.2114 | 248472.0 |
| 2014-02-06 08:50:00 | AAPL | Stock | 18.2107 | 18.2186 | 18.2107 | 18.2154 | 92428.0 |
| 2014-02-06 08:55:00 | AAPL | Stock | 18.2196 | 18.2229 | 18.2179 | 18.2229 | 61936.0 |
| 2014-02-06 09:00:00 | AAPL | Stock | 18.2239 | 18.2257 | 18.2146 | 18.2146 | 65772.0 |
| 2014-02-06 09:05:00 | AAPL | Stock | 18.215 | 18.215 | 18.2118 | 18.2143 | 60480.0 |
| 2014-02-06 09:10:00 | AAPL | Stock | 18.2143 | 18.2179 | 18.2107 | 18.2154 | 169092.0 |
| 2014-02-06 09:15:00 | AAPL | Stock | 18.2143 | 18.2196 | 18.2143 | 18.2196 | 92372.0 |
| 2014-02-06 09:20:00 | AAPL | Stock | 18.2179 | 18.2232 | 18.2179 | 18.2214 | 78960.0 |
| 2014-02-06 09:25:00 | AAPL | Stock | 18.215 | 18.2357 | 18.2068 | 18.2189 | 432068.0 |
| 2014-02-06 09:30:00 | AAPL | Stock | 18.2164 | 18.2996 | 18.2161 | 18.2839 | 11234720.0 |
| 2014-02-06 09:35:00 | AAPL | Stock | 18.2871 | 18.29 | 18.2029 | 18.25 | 7386400.0 |
| 2014-02-06 09:40:00 | AAPL | Stock | 18.2523 | 18.2732 | 18.2332 | 18.2464 | 5335148.0 |
| 2014-02-06 09:45:00 | AAPL | Stock | 18.24 | 18.2482 | 18.1775 | 18.1775 | 6672652.0 |
| 2014-02-06 09:50:00 | AAPL | Stock | 18.1768 | 18.2143 | 18.1661 | 18.1789 | 4418148.0 |
| 2014-02-06 09:55:00 | AAPL | Stock | 18.1786 | 18.1911 | 18.1525 | 18.165 | 4436684.0 |
| 2014-02-06 10:00:00 | AAPL | Stock | 18.165 | 18.1875 | 18.1361 | 18.1864 | 6164844.0 |
> showing 50 of 359,828 rows — these rows as CSV