PREVIEW / stock_5min / 2014-02-12
file: by_date/stock_5min/2014/2014-02-12.parquet size: 5.4 MB rows: 358,689 symbols: 3,535
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-12 04:15:00 | AAPL | Stock | 19.1929 | 19.1929 | 19.1929 | 19.1929 | 5600.0 |
| 2014-02-12 05:00:00 | AAPL | Stock | 19.2107 | 19.2304 | 19.2107 | 19.2304 | 36400.0 |
| 2014-02-12 05:05:00 | AAPL | Stock | 19.2271 | 19.2271 | 19.1896 | 19.1896 | 38304.0 |
| 2014-02-12 05:10:00 | AAPL | Stock | 19.2314 | 19.2314 | 19.2314 | 19.2314 | 8400.0 |
| 2014-02-12 05:20:00 | AAPL | Stock | 19.2304 | 19.2304 | 19.2304 | 19.2304 | 2800.0 |
| 2014-02-12 05:35:00 | AAPL | Stock | 19.2204 | 19.2204 | 19.2168 | 19.2168 | 5600.0 |
| 2014-02-12 05:40:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.2057 | 19.2057 | 2800.0 |
| 2014-02-12 05:45:00 | AAPL | Stock | 19.2039 | 19.2039 | 19.2039 | 19.2039 | 2800.0 |
| 2014-02-12 05:55:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.2057 | 19.2057 | 5600.0 |
| 2014-02-12 06:00:00 | AAPL | Stock | 19.2011 | 19.2011 | 19.2011 | 19.2011 | 5600.0 |
| 2014-02-12 06:20:00 | AAPL | Stock | 19.1811 | 19.1811 | 19.1768 | 19.1768 | 5600.0 |
| 2014-02-12 06:25:00 | AAPL | Stock | 19.1807 | 19.1811 | 19.1754 | 19.1754 | 11200.0 |
| 2014-02-12 06:50:00 | AAPL | Stock | 19.1754 | 19.1754 | 19.1754 | 19.1754 | 4200.0 |
| 2014-02-12 06:55:00 | AAPL | Stock | 19.1764 | 19.1764 | 19.1764 | 19.1764 | 4060.0 |
| 2014-02-12 07:00:00 | AAPL | Stock | 19.1393 | 19.1393 | 19.1393 | 19.1393 | 3220.0 |
| 2014-02-12 07:20:00 | AAPL | Stock | 19.1407 | 19.1511 | 19.1407 | 19.1511 | 12600.0 |
| 2014-02-12 07:30:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1679 | 19.1679 | 2800.0 |
| 2014-02-12 07:35:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1679 | 19.1679 | 2800.0 |
| 2014-02-12 07:40:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1589 | 19.1589 | 5600.0 |
| 2014-02-12 07:45:00 | AAPL | Stock | 19.1518 | 19.1546 | 19.1518 | 19.1546 | 14000.0 |
| 2014-02-12 07:50:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1432 | 19.1471 | 31108.0 |
| 2014-02-12 07:55:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1429 | 19.1429 | 28000.0 |
| 2014-02-12 08:00:00 | AAPL | Stock | 19.1457 | 19.1914 | 19.1393 | 19.1471 | 142828.0 |
| 2014-02-12 08:05:00 | AAPL | Stock | 19.1475 | 19.1475 | 19.1429 | 19.1475 | 58800.0 |
| 2014-02-12 08:10:00 | AAPL | Stock | 19.1454 | 19.1611 | 19.1454 | 19.1536 | 24640.0 |
| 2014-02-12 08:15:00 | AAPL | Stock | 19.1571 | 19.1607 | 19.1571 | 19.1571 | 34720.0 |
| 2014-02-12 08:20:00 | AAPL | Stock | 19.1625 | 19.1625 | 19.1586 | 19.1593 | 22820.0 |
| 2014-02-12 08:25:00 | AAPL | Stock | 19.1668 | 19.1668 | 19.1664 | 19.1664 | 5600.0 |
| 2014-02-12 08:30:00 | AAPL | Stock | 19.1668 | 19.1671 | 19.1646 | 19.1646 | 72268.0 |
| 2014-02-12 08:35:00 | AAPL | Stock | 19.1693 | 19.1854 | 19.1693 | 19.1854 | 59640.0 |
| 2014-02-12 08:40:00 | AAPL | Stock | 19.1821 | 19.1821 | 19.1732 | 19.175 | 67816.0 |
| 2014-02-12 08:45:00 | AAPL | Stock | 19.1768 | 19.1814 | 19.175 | 19.1804 | 134400.0 |
| 2014-02-12 08:50:00 | AAPL | Stock | 19.1857 | 19.1943 | 19.1857 | 19.1943 | 78624.0 |
| 2014-02-12 08:55:00 | AAPL | Stock | 19.1939 | 19.1964 | 19.1921 | 19.1921 | 58940.0 |
| 2014-02-12 09:00:00 | AAPL | Stock | 19.1925 | 19.1925 | 19.1875 | 19.19 | 98700.0 |
| 2014-02-12 09:05:00 | AAPL | Stock | 19.1914 | 19.1929 | 19.1846 | 19.1857 | 108696.0 |
| 2014-02-12 09:10:00 | AAPL | Stock | 19.1925 | 19.1925 | 19.1864 | 19.1925 | 92820.0 |
| 2014-02-12 09:15:00 | AAPL | Stock | 19.1882 | 19.1882 | 19.1414 | 19.1768 | 237384.0 |
| 2014-02-12 09:20:00 | AAPL | Stock | 19.1779 | 19.1786 | 19.17 | 19.1711 | 103992.0 |
| 2014-02-12 09:25:00 | AAPL | Stock | 19.1782 | 19.1861 | 19.17 | 19.175 | 173264.0 |
| 2014-02-12 09:30:00 | AAPL | Stock | 19.1768 | 19.27 | 19.1696 | 19.2371 | 14081592.0 |
| 2014-02-12 09:35:00 | AAPL | Stock | 19.2412 | 19.2432 | 19.2071 | 19.2193 | 11493580.0 |
| 2014-02-12 09:40:00 | AAPL | Stock | 19.2211 | 19.2293 | 19.1818 | 19.2168 | 7540792.0 |
| 2014-02-12 09:45:00 | AAPL | Stock | 19.2177 | 19.2186 | 19.1368 | 19.14 | 8397536.0 |
| 2014-02-12 09:50:00 | AAPL | Stock | 19.1439 | 19.1471 | 19.1004 | 19.1096 | 6857956.0 |
| 2014-02-12 09:55:00 | AAPL | Stock | 19.1082 | 19.1536 | 19.1071 | 19.1536 | 6221544.0 |
| 2014-02-12 10:00:00 | AAPL | Stock | 19.1529 | 19.1571 | 19.1275 | 19.1294 | 3185672.0 |
| 2014-02-12 10:05:00 | AAPL | Stock | 19.1289 | 19.1414 | 19.0746 | 19.0893 | 5530980.0 |
| 2014-02-12 10:10:00 | AAPL | Stock | 19.0871 | 19.0886 | 19.0514 | 19.0629 | 5834416.0 |
| 2014-02-12 10:15:00 | AAPL | Stock | 19.0611 | 19.0849 | 19.0443 | 19.0771 | 3301760.0 |
> showing 50 of 358,689 rows — these rows as CSV