PREVIEW / stock_5min / 2014-01-06
file: by_date/stock_5min/2014/2014-01-06.parquet size: 5.5 MB rows: 366,174 symbols: 3,532
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-01-06 04:05:00 | AAPL | Stock | 19.3504 | 19.3504 | 19.3504 | 19.3504 | 2800.0 |
| 2014-01-06 04:10:00 | AAPL | Stock | 19.3443 | 19.3443 | 19.32 | 19.32 | 14000.0 |
| 2014-01-06 04:20:00 | AAPL | Stock | 19.32 | 19.32 | 19.32 | 19.32 | 3668.0 |
| 2014-01-06 04:25:00 | AAPL | Stock | 19.3175 | 19.3175 | 19.3175 | 19.3175 | 8400.0 |
| 2014-01-06 04:35:00 | AAPL | Stock | 19.3186 | 19.32 | 19.3161 | 19.32 | 16800.0 |
| 2014-01-06 04:45:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.3161 | 19.3161 | 2800.0 |
| 2014-01-06 04:50:00 | AAPL | Stock | 19.3171 | 19.3171 | 19.3171 | 19.3171 | 2800.0 |
| 2014-01-06 04:55:00 | AAPL | Stock | 19.3171 | 19.3171 | 19.3171 | 19.3171 | 2800.0 |
| 2014-01-06 05:00:00 | AAPL | Stock | 19.3182 | 19.3214 | 19.3179 | 19.3214 | 17276.0 |
| 2014-01-06 05:20:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2800.0 |
| 2014-01-06 05:30:00 | AAPL | Stock | 19.3125 | 19.3125 | 19.3125 | 19.3125 | 2800.0 |
| 2014-01-06 05:35:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.3036 | 19.3036 | 2800.0 |
| 2014-01-06 05:50:00 | AAPL | Stock | 19.3214 | 19.3214 | 19.3214 | 19.3214 | 2828.0 |
| 2014-01-06 05:55:00 | AAPL | Stock | 19.3161 | 19.3161 | 19.2679 | 19.2679 | 49364.0 |
| 2014-01-06 06:00:00 | AAPL | Stock | 19.2511 | 19.2611 | 19.1607 | 19.1607 | 56392.0 |
| 2014-01-06 06:05:00 | AAPL | Stock | 19.16 | 19.16 | 19.1089 | 19.1161 | 52500.0 |
| 2014-01-06 06:10:00 | AAPL | Stock | 19.1089 | 19.1089 | 19.0754 | 19.0893 | 76440.0 |
| 2014-01-06 06:15:00 | AAPL | Stock | 19.0732 | 19.0821 | 19.0536 | 19.0821 | 120176.0 |
| 2014-01-06 06:20:00 | AAPL | Stock | 19.0821 | 19.1429 | 19.0821 | 19.1329 | 107044.0 |
| 2014-01-06 06:30:00 | AAPL | Stock | 19.1361 | 19.1361 | 19.1361 | 19.1361 | 6244.0 |
| 2014-01-06 06:35:00 | AAPL | Stock | 19.1179 | 19.1179 | 19.1036 | 19.1036 | 36456.0 |
| 2014-01-06 06:40:00 | AAPL | Stock | 19.1014 | 19.1071 | 19.1014 | 19.1071 | 16800.0 |
| 2014-01-06 06:45:00 | AAPL | Stock | 19.1036 | 19.1164 | 19.0971 | 19.1071 | 69300.0 |
| 2014-01-06 06:50:00 | AAPL | Stock | 19.0975 | 19.1071 | 19.0857 | 19.0946 | 72520.0 |
| 2014-01-06 06:55:00 | AAPL | Stock | 19.0964 | 19.1139 | 19.0964 | 19.1061 | 57204.0 |
| 2014-01-06 07:00:00 | AAPL | Stock | 19.1061 | 19.15 | 19.1061 | 19.1429 | 162960.0 |
| 2014-01-06 07:05:00 | AAPL | Stock | 19.1604 | 19.2139 | 19.1604 | 19.1893 | 95900.0 |
| 2014-01-06 07:10:00 | AAPL | Stock | 19.1693 | 19.1786 | 19.1664 | 19.1664 | 66080.0 |
| 2014-01-06 07:15:00 | AAPL | Stock | 19.1696 | 19.1736 | 19.1696 | 19.1736 | 25200.0 |
| 2014-01-06 07:20:00 | AAPL | Stock | 19.1696 | 19.1786 | 19.1607 | 19.1607 | 99456.0 |
| 2014-01-06 07:25:00 | AAPL | Stock | 19.1639 | 19.1646 | 19.1636 | 19.1639 | 36400.0 |
| 2014-01-06 07:30:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1675 | 19.1714 | 30800.0 |
| 2014-01-06 07:35:00 | AAPL | Stock | 19.1675 | 19.1675 | 19.1557 | 19.1607 | 75544.0 |
| 2014-01-06 07:40:00 | AAPL | Stock | 19.1571 | 19.1761 | 19.1571 | 19.175 | 187404.0 |
| 2014-01-06 07:45:00 | AAPL | Stock | 19.1754 | 19.2107 | 19.175 | 19.1957 | 184156.0 |
| 2014-01-06 07:50:00 | AAPL | Stock | 19.1986 | 19.2321 | 19.19 | 19.2318 | 176120.0 |
| 2014-01-06 07:55:00 | AAPL | Stock | 19.2221 | 19.2286 | 19.2143 | 19.2186 | 98168.0 |
| 2014-01-06 08:00:00 | AAPL | Stock | 19.2143 | 19.3368 | 19.1571 | 19.2279 | 712544.0 |
| 2014-01-06 08:05:00 | AAPL | Stock | 19.2346 | 19.2346 | 19.2114 | 19.225 | 163128.0 |
| 2014-01-06 08:10:00 | AAPL | Stock | 19.2311 | 19.2621 | 19.2311 | 19.2607 | 110572.0 |
| 2014-01-06 08:15:00 | AAPL | Stock | 19.2657 | 19.2657 | 19.2393 | 19.25 | 56616.0 |
| 2014-01-06 08:20:00 | AAPL | Stock | 19.245 | 19.2679 | 19.245 | 19.2607 | 60060.0 |
| 2014-01-06 08:25:00 | AAPL | Stock | 19.2589 | 19.2679 | 19.25 | 19.2543 | 76160.0 |
| 2014-01-06 08:30:00 | AAPL | Stock | 19.2657 | 19.2661 | 19.2521 | 19.2521 | 22540.0 |
| 2014-01-06 08:35:00 | AAPL | Stock | 19.2518 | 19.2518 | 19.2271 | 19.2321 | 84588.0 |
| 2014-01-06 08:40:00 | AAPL | Stock | 19.2268 | 19.2318 | 19.2064 | 19.2142 | 220528.0 |
| 2014-01-06 08:45:00 | AAPL | Stock | 19.2143 | 19.2179 | 19.1821 | 19.1964 | 308980.0 |
| 2014-01-06 08:50:00 | AAPL | Stock | 19.1968 | 19.2071 | 19.1929 | 19.1964 | 138600.0 |
| 2014-01-06 08:55:00 | AAPL | Stock | 19.2007 | 19.2071 | 19.1929 | 19.2071 | 118048.0 |
| 2014-01-06 09:00:00 | AAPL | Stock | 19.2071 | 19.2132 | 19.2018 | 19.2118 | 92288.0 |
> showing 50 of 366,174 rows — these rows as CSV