PREVIEW / stock_5min / 2014-05-15
file: by_date/stock_5min/2014/2014-05-15.parquet size: 5.5 MB rows: 364,861 symbols: 3,537
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-05-15 05:40:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-15 07:00:00 | AAPL | Stock | 21.1964 | 21.2004 | 21.1964 | 21.2004 | 11200.0 |
| 2014-05-15 07:05:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 14000.0 |
| 2014-05-15 07:10:00 | AAPL | Stock | 21.2036 | 21.2111 | 21.2036 | 21.2111 | 22400.0 |
| 2014-05-15 07:15:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.2036 | 21.2036 | 5600.0 |
| 2014-05-15 07:20:00 | AAPL | Stock | 21.2036 | 21.2139 | 21.2036 | 21.2139 | 22288.0 |
| 2014-05-15 07:35:00 | AAPL | Stock | 21.2029 | 21.2029 | 21.2018 | 21.2018 | 5600.0 |
| 2014-05-15 07:40:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-15 08:00:00 | AAPL | Stock | 21.1829 | 21.2029 | 21.1768 | 21.1768 | 79044.0 |
| 2014-05-15 08:05:00 | AAPL | Stock | 21.1986 | 21.1986 | 21.1986 | 21.1986 | 2800.0 |
| 2014-05-15 08:20:00 | AAPL | Stock | 21.1893 | 21.1893 | 21.1893 | 21.1893 | 2800.0 |
| 2014-05-15 08:25:00 | AAPL | Stock | 21.1964 | 21.1964 | 21.1964 | 21.1964 | 2800.0 |
| 2014-05-15 08:30:00 | AAPL | Stock | 21.1996 | 21.2189 | 21.1993 | 21.2143 | 191072.0 |
| 2014-05-15 08:35:00 | AAPL | Stock | 21.215 | 21.2232 | 21.215 | 21.2232 | 5600.0 |
| 2014-05-15 08:40:00 | AAPL | Stock | 21.2246 | 21.2482 | 21.2239 | 21.2268 | 159404.0 |
| 2014-05-15 08:45:00 | AAPL | Stock | 21.2293 | 21.2432 | 21.2236 | 21.2257 | 30800.0 |
| 2014-05-15 08:50:00 | AAPL | Stock | 21.2232 | 21.2232 | 21.2232 | 21.2232 | 2800.0 |
| 2014-05-15 08:55:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2143 | 21.2143 | 11900.0 |
| 2014-05-15 09:00:00 | AAPL | Stock | 21.2143 | 21.2143 | 21.2139 | 21.2139 | 27104.0 |
| 2014-05-15 09:05:00 | AAPL | Stock | 21.2139 | 21.2179 | 21.2139 | 21.2175 | 91616.0 |
| 2014-05-15 09:10:00 | AAPL | Stock | 21.2175 | 21.2179 | 21.2146 | 21.2146 | 28000.0 |
| 2014-05-15 09:15:00 | AAPL | Stock | 21.215 | 21.2218 | 21.215 | 21.2182 | 29540.0 |
| 2014-05-15 09:20:00 | AAPL | Stock | 21.2161 | 21.2179 | 21.2039 | 21.2179 | 14000.0 |
| 2014-05-15 09:25:00 | AAPL | Stock | 21.2071 | 21.2468 | 21.2071 | 21.2289 | 198492.0 |
| 2014-05-15 09:30:00 | AAPL | Stock | 21.2354 | 21.2943 | 21.2232 | 21.2837 | 8957536.0 |
| 2014-05-15 09:35:00 | AAPL | Stock | 21.2831 | 21.3071 | 21.2657 | 21.2843 | 5579840.0 |
| 2014-05-15 09:40:00 | AAPL | Stock | 21.2838 | 21.2893 | 21.2486 | 21.2486 | 3882704.0 |
| 2014-05-15 09:45:00 | AAPL | Stock | 21.2514 | 21.2714 | 21.2396 | 21.2557 | 3802512.0 |
| 2014-05-15 09:50:00 | AAPL | Stock | 21.2596 | 21.2618 | 21.2143 | 21.2246 | 4939648.0 |
| 2014-05-15 09:55:00 | AAPL | Stock | 21.2232 | 21.2446 | 21.1875 | 21.2421 | 5971504.0 |
| 2014-05-15 10:00:00 | AAPL | Stock | 21.2354 | 21.2436 | 21.1611 | 21.1689 | 5632228.0 |
| 2014-05-15 10:05:00 | AAPL | Stock | 21.1639 | 21.195 | 21.1036 | 21.1282 | 4953004.0 |
| 2014-05-15 10:10:00 | AAPL | Stock | 21.1276 | 21.1539 | 21.1107 | 21.1378 | 3519796.0 |
| 2014-05-15 10:15:00 | AAPL | Stock | 21.1307 | 21.1679 | 21.1111 | 21.1564 | 3711316.0 |
| 2014-05-15 10:20:00 | AAPL | Stock | 21.1564 | 21.1607 | 21.1364 | 21.15 | 3206728.0 |
| 2014-05-15 10:25:00 | AAPL | Stock | 21.1454 | 21.1661 | 21.1357 | 21.1568 | 2385292.0 |
| 2014-05-15 10:30:00 | AAPL | Stock | 21.1611 | 21.1818 | 21.1496 | 21.1511 | 2164484.0 |
| 2014-05-15 10:35:00 | AAPL | Stock | 21.1532 | 21.1632 | 21.1289 | 21.1446 | 2555364.0 |
| 2014-05-15 10:40:00 | AAPL | Stock | 21.1461 | 21.1704 | 21.1361 | 21.1684 | 1744820.0 |
| 2014-05-15 10:45:00 | AAPL | Stock | 21.1629 | 21.1711 | 21.1429 | 21.1457 | 1212960.0 |
| 2014-05-15 10:50:00 | AAPL | Stock | 21.1464 | 21.1704 | 21.1382 | 21.1679 | 2144436.0 |
| 2014-05-15 10:55:00 | AAPL | Stock | 21.1671 | 21.1689 | 21.1464 | 21.1554 | 1030792.0 |
| 2014-05-15 11:00:00 | AAPL | Stock | 21.1579 | 21.1607 | 21.1286 | 21.1286 | 1828092.0 |
| 2014-05-15 11:05:00 | AAPL | Stock | 21.1339 | 21.1461 | 21.1171 | 21.1282 | 2008104.0 |
| 2014-05-15 11:10:00 | AAPL | Stock | 21.1218 | 21.13 | 21.0932 | 21.0964 | 2536772.0 |
| 2014-05-15 11:15:00 | AAPL | Stock | 21.0939 | 21.1161 | 21.0836 | 21.0971 | 2193548.0 |
| 2014-05-15 11:20:00 | AAPL | Stock | 21.0996 | 21.1071 | 21.0707 | 21.0811 | 3730440.0 |
| 2014-05-15 11:25:00 | AAPL | Stock | 21.0786 | 21.0964 | 21.0657 | 21.0789 | 2162272.0 |
| 2014-05-15 11:30:00 | AAPL | Stock | 21.0721 | 21.1307 | 21.0721 | 21.1307 | 2210068.0 |
| 2014-05-15 11:35:00 | AAPL | Stock | 21.1275 | 21.1393 | 21.1111 | 21.1359 | 1419432.0 |
> showing 50 of 364,861 rows — these rows as CSV