PREVIEW / stock_5min / 2014-03-13
file: by_date/stock_5min/2014/2014-03-13.parquet size: 5.6 MB rows: 367,255 symbols: 3,538
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-13 04:35:00 | AAPL | Stock | 19.1857 | 19.1857 | 19.1857 | 19.1857 | 2800.0 |
| 2014-03-13 04:50:00 | AAPL | Stock | 19.1857 | 19.1857 | 19.1857 | 19.1857 | 11200.0 |
| 2014-03-13 05:00:00 | AAPL | Stock | 19.2061 | 19.2061 | 19.2061 | 19.2061 | 2800.0 |
| 2014-03-13 05:30:00 | AAPL | Stock | 19.1796 | 19.1796 | 19.1796 | 19.1796 | 2800.0 |
| 2014-03-13 07:00:00 | AAPL | Stock | 19.2 | 19.2064 | 19.2 | 19.2064 | 11200.0 |
| 2014-03-13 07:05:00 | AAPL | Stock | 19.2146 | 19.2179 | 19.2146 | 19.2179 | 8400.0 |
| 2014-03-13 07:10:00 | AAPL | Stock | 19.2293 | 19.2343 | 19.2286 | 19.2343 | 8400.0 |
| 2014-03-13 07:20:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2143 | 19.2143 | 44800.0 |
| 2014-03-13 07:30:00 | AAPL | Stock | 19.2139 | 19.2357 | 19.2139 | 19.2357 | 19600.0 |
| 2014-03-13 07:35:00 | AAPL | Stock | 19.2286 | 19.2286 | 19.2286 | 19.2286 | 4200.0 |
| 2014-03-13 07:40:00 | AAPL | Stock | 19.2271 | 19.2271 | 19.2207 | 19.2207 | 47600.0 |
| 2014-03-13 07:45:00 | AAPL | Stock | 19.2146 | 19.2236 | 19.2146 | 19.2236 | 8400.0 |
| 2014-03-13 08:00:00 | AAPL | Stock | 19.2064 | 19.2286 | 19.19 | 19.1968 | 97020.0 |
| 2014-03-13 08:05:00 | AAPL | Stock | 19.1961 | 19.2104 | 19.1961 | 19.2068 | 76300.0 |
| 2014-03-13 08:10:00 | AAPL | Stock | 19.2054 | 19.2161 | 19.2054 | 19.2161 | 96376.0 |
| 2014-03-13 08:15:00 | AAPL | Stock | 19.2143 | 19.2164 | 19.2143 | 19.2143 | 26040.0 |
| 2014-03-13 08:20:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2129 | 19.2129 | 27496.0 |
| 2014-03-13 08:25:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2143 | 19.2143 | 2800.0 |
| 2014-03-13 08:35:00 | AAPL | Stock | 19.2143 | 19.2207 | 19.2039 | 19.2139 | 43400.0 |
| 2014-03-13 08:40:00 | AAPL | Stock | 19.2068 | 19.2082 | 19.1964 | 19.2043 | 138264.0 |
| 2014-03-13 08:45:00 | AAPL | Stock | 19.2039 | 19.2107 | 19.2039 | 19.2071 | 88760.0 |
| 2014-03-13 08:50:00 | AAPL | Stock | 19.2068 | 19.2129 | 19.2054 | 19.2111 | 70000.0 |
| 2014-03-13 08:55:00 | AAPL | Stock | 19.2064 | 19.2064 | 19.2064 | 19.2064 | 2800.0 |
| 2014-03-13 09:00:00 | AAPL | Stock | 19.2046 | 19.2107 | 19.2046 | 19.2107 | 39200.0 |
| 2014-03-13 09:05:00 | AAPL | Stock | 19.2089 | 19.2089 | 19.2068 | 19.2071 | 72800.0 |
| 2014-03-13 09:10:00 | AAPL | Stock | 19.2104 | 19.2107 | 19.2061 | 19.2089 | 81816.0 |
| 2014-03-13 09:15:00 | AAPL | Stock | 19.2089 | 19.2107 | 19.2089 | 19.2089 | 42000.0 |
| 2014-03-13 09:20:00 | AAPL | Stock | 19.2075 | 19.2079 | 19.1943 | 19.1943 | 77000.0 |
| 2014-03-13 09:25:00 | AAPL | Stock | 19.1982 | 19.2029 | 19.1961 | 19.1961 | 28000.0 |
| 2014-03-13 09:30:00 | AAPL | Stock | 19.1907 | 19.1957 | 19.1293 | 19.1518 | 9606408.0 |
| 2014-03-13 09:35:00 | AAPL | Stock | 19.1518 | 19.1757 | 19.125 | 19.1321 | 4113620.0 |
| 2014-03-13 09:40:00 | AAPL | Stock | 19.1325 | 19.1511 | 19.1089 | 19.132 | 4126696.0 |
| 2014-03-13 09:45:00 | AAPL | Stock | 19.135 | 19.2464 | 19.1346 | 19.2404 | 7147896.0 |
| 2014-03-13 09:50:00 | AAPL | Stock | 19.24 | 19.2475 | 19.2114 | 19.2189 | 4898432.0 |
| 2014-03-13 09:55:00 | AAPL | Stock | 19.2179 | 19.2371 | 19.2107 | 19.2311 | 3691548.0 |
| 2014-03-13 10:00:00 | AAPL | Stock | 19.2307 | 19.265 | 19.2196 | 19.2579 | 6229944.0 |
| 2014-03-13 10:05:00 | AAPL | Stock | 19.2582 | 19.2736 | 19.2414 | 19.2489 | 4349548.0 |
| 2014-03-13 10:10:00 | AAPL | Stock | 19.2457 | 19.2543 | 19.1996 | 19.2025 | 4526060.0 |
| 2014-03-13 10:15:00 | AAPL | Stock | 19.2043 | 19.2229 | 19.1996 | 19.2154 | 3500364.0 |
| 2014-03-13 10:20:00 | AAPL | Stock | 19.2186 | 19.2221 | 19.2007 | 19.2176 | 1639848.0 |
| 2014-03-13 10:25:00 | AAPL | Stock | 19.2193 | 19.2246 | 19.2014 | 19.2207 | 1697752.0 |
| 2014-03-13 10:30:00 | AAPL | Stock | 19.2225 | 19.2225 | 19.1871 | 19.1961 | 2402288.0 |
| 2014-03-13 10:35:00 | AAPL | Stock | 19.1957 | 19.1957 | 19.1632 | 19.1705 | 2349900.0 |
| 2014-03-13 10:40:00 | AAPL | Stock | 19.1686 | 19.1723 | 19.1546 | 19.1636 | 2453780.0 |
| 2014-03-13 10:45:00 | AAPL | Stock | 19.1604 | 19.1604 | 19.1361 | 19.1525 | 2395092.0 |
| 2014-03-13 10:50:00 | AAPL | Stock | 19.1507 | 19.1839 | 19.1496 | 19.1736 | 2764216.0 |
| 2014-03-13 10:55:00 | AAPL | Stock | 19.1736 | 19.1843 | 19.1639 | 19.1679 | 2035712.0 |
| 2014-03-13 11:00:00 | AAPL | Stock | 19.1707 | 19.185 | 19.1529 | 19.1732 | 2057776.0 |
| 2014-03-13 11:05:00 | AAPL | Stock | 19.1718 | 19.1754 | 19.1396 | 19.1518 | 1587488.0 |
| 2014-03-13 11:10:00 | AAPL | Stock | 19.1507 | 19.1573 | 19.1386 | 19.1414 | 1104040.0 |
> showing 50 of 367,255 rows — these rows as CSV