PREVIEW / stock_5min / 2014-05-01
file: by_date/stock_5min/2014/2014-05-01.parquet size: 5.5 MB rows: 370,887 symbols: 3,540
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-01 06:30:00 | AAPL | Stock | 21.0757 | 21.0757 | 21.0757 | 21.0757 | 7392.0 |
| 2014-05-01 07:05:00 | AAPL | Stock | 21.1404 | 21.1404 | 21.1404 | 21.1404 | 7812.0 |
| 2014-05-01 07:15:00 | AAPL | Stock | 21.1632 | 21.1632 | 21.1632 | 21.1632 | 19600.0 |
| 2014-05-01 07:20:00 | AAPL | Stock | 21.1436 | 21.1436 | 21.1436 | 21.1436 | 2800.0 |
| 2014-05-01 07:25:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 2800.0 |
| 2014-05-01 07:30:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 28000.0 |
| 2014-05-01 07:35:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 11200.0 |
| 2014-05-01 07:40:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 5600.0 |
| 2014-05-01 07:45:00 | AAPL | Stock | 21.1296 | 21.1407 | 21.1296 | 21.1407 | 8400.0 |
| 2014-05-01 07:55:00 | AAPL | Stock | 21.1336 | 21.14 | 21.1071 | 21.14 | 122388.0 |
| 2014-05-01 08:00:00 | AAPL | Stock | 21.1371 | 21.1786 | 21.1314 | 21.1407 | 231980.0 |
| 2014-05-01 08:05:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1329 | 21.1382 | 143556.0 |
| 2014-05-01 08:10:00 | AAPL | Stock | 21.1429 | 21.1607 | 21.1429 | 21.1429 | 98868.0 |
| 2014-05-01 08:15:00 | AAPL | Stock | 21.1482 | 21.1571 | 21.1482 | 21.1571 | 29960.0 |
| 2014-05-01 08:20:00 | AAPL | Stock | 21.15 | 21.1857 | 21.1429 | 21.1857 | 210504.0 |
| 2014-05-01 08:25:00 | AAPL | Stock | 21.1643 | 21.1786 | 21.1507 | 21.1693 | 43400.0 |
| 2014-05-01 08:30:00 | AAPL | Stock | 21.1607 | 21.1764 | 21.1429 | 21.1589 | 84000.0 |
| 2014-05-01 08:35:00 | AAPL | Stock | 21.1429 | 21.1554 | 21.1429 | 21.1554 | 39200.0 |
| 2014-05-01 08:40:00 | AAPL | Stock | 21.1536 | 21.1786 | 21.1536 | 21.1643 | 64120.0 |
| 2014-05-01 08:45:00 | AAPL | Stock | 21.1611 | 21.1771 | 21.1589 | 21.1729 | 65240.0 |
| 2014-05-01 08:50:00 | AAPL | Stock | 21.1643 | 21.1689 | 21.1643 | 21.1689 | 14000.0 |
| 2014-05-01 08:55:00 | AAPL | Stock | 21.1639 | 21.1689 | 21.1571 | 21.1571 | 77700.0 |
| 2014-05-01 09:00:00 | AAPL | Stock | 21.1589 | 21.1607 | 21.1589 | 21.1607 | 11340.0 |
| 2014-05-01 09:05:00 | AAPL | Stock | 21.1675 | 21.1739 | 21.1664 | 21.1679 | 352800.0 |
| 2014-05-01 09:10:00 | AAPL | Stock | 21.1504 | 21.1629 | 21.145 | 21.1464 | 89180.0 |
| 2014-05-01 09:15:00 | AAPL | Stock | 21.1589 | 21.1596 | 21.1354 | 21.155 | 170352.0 |
| 2014-05-01 09:20:00 | AAPL | Stock | 21.1446 | 21.1446 | 21.1429 | 21.1429 | 6440.0 |
| 2014-05-01 09:25:00 | AAPL | Stock | 21.1357 | 21.1661 | 21.1179 | 21.1429 | 324352.0 |
| 2014-05-01 09:30:00 | AAPL | Stock | 21.145 | 21.1564 | 21.0807 | 21.0976 | 10522792.0 |
| 2014-05-01 09:35:00 | AAPL | Stock | 21.0957 | 21.23 | 21.0946 | 21.2107 | 10140956.0 |
| 2014-05-01 09:40:00 | AAPL | Stock | 21.2057 | 21.2229 | 21.1743 | 21.1807 | 3892084.0 |
| 2014-05-01 09:45:00 | AAPL | Stock | 21.1854 | 21.1882 | 21.144 | 21.1668 | 4827592.0 |
| 2014-05-01 09:50:00 | AAPL | Stock | 21.1693 | 21.1739 | 21.1211 | 21.1429 | 5612572.0 |
| 2014-05-01 09:55:00 | AAPL | Stock | 21.1429 | 21.1671 | 21.1157 | 21.1429 | 2712528.0 |
| 2014-05-01 10:00:00 | AAPL | Stock | 21.1418 | 21.1961 | 21.1075 | 21.1918 | 3688776.0 |
| 2014-05-01 10:05:00 | AAPL | Stock | 21.1889 | 21.2429 | 21.1864 | 21.1989 | 6444956.0 |
| 2014-05-01 10:10:00 | AAPL | Stock | 21.1986 | 21.2296 | 21.1905 | 21.1982 | 2605792.0 |
| 2014-05-01 10:15:00 | AAPL | Stock | 21.2029 | 21.2075 | 21.1632 | 21.1796 | 3014536.0 |
| 2014-05-01 10:20:00 | AAPL | Stock | 21.1786 | 21.2236 | 21.1707 | 21.2125 | 2881452.0 |
| 2014-05-01 10:25:00 | AAPL | Stock | 21.2143 | 21.2286 | 21.2044 | 21.2218 | 2016000.0 |
| 2014-05-01 10:30:00 | AAPL | Stock | 21.2196 | 21.2382 | 21.2107 | 21.2304 | 2621836.0 |
| 2014-05-01 10:35:00 | AAPL | Stock | 21.2329 | 21.2371 | 21.1911 | 21.2 | 2899232.0 |
| 2014-05-01 10:40:00 | AAPL | Stock | 21.2021 | 21.22 | 21.1893 | 21.2064 | 1842960.0 |
| 2014-05-01 10:45:00 | AAPL | Stock | 21.2014 | 21.2304 | 21.1914 | 21.2211 | 1990520.0 |
| 2014-05-01 10:50:00 | AAPL | Stock | 21.2279 | 21.2386 | 21.1921 | 21.197 | 2006984.0 |
| 2014-05-01 10:55:00 | AAPL | Stock | 21.2 | 21.2221 | 21.1964 | 21.2114 | 1116108.0 |
| 2014-05-01 11:00:00 | AAPL | Stock | 21.2143 | 21.2354 | 21.2071 | 21.2218 | 1073016.0 |
| 2014-05-01 11:05:00 | AAPL | Stock | 21.2211 | 21.2229 | 21.1796 | 21.1943 | 1667876.0 |
| 2014-05-01 11:10:00 | AAPL | Stock | 21.1964 | 21.2129 | 21.1868 | 21.1968 | 891408.0 |
| 2014-05-01 11:15:00 | AAPL | Stock | 21.195 | 21.2104 | 21.175 | 21.1868 | 1118992.0 |
> showing 50 of 370,887 rows — these rows as CSV