PREVIEW / stock_5min / 2014-04-04
file: by_date/stock_5min/2014/2014-04-04.parquet size: 5.7 MB rows: 372,685 symbols: 3,544
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-04-04 05:20:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2754 | 19.2754 | 2884.0 |
| 2014-04-04 06:00:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2754 | 19.2754 | 2800.0 |
| 2014-04-04 06:05:00 | AAPL | Stock | 19.2893 | 19.2896 | 19.2893 | 19.2896 | 14000.0 |
| 2014-04-04 07:30:00 | AAPL | Stock | 19.2839 | 19.2839 | 19.2839 | 19.2839 | 2800.0 |
| 2014-04-04 07:35:00 | AAPL | Stock | 19.2821 | 19.2821 | 19.2821 | 19.2821 | 22400.0 |
| 2014-04-04 07:55:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2696 | 19.2696 | 17836.0 |
| 2014-04-04 08:00:00 | AAPL | Stock | 19.2739 | 19.2779 | 19.1429 | 19.1429 | 42000.0 |
| 2014-04-04 08:10:00 | AAPL | Stock | 19.2743 | 19.2743 | 19.2743 | 19.2743 | 2800.0 |
| 2014-04-04 08:15:00 | AAPL | Stock | 19.2714 | 19.2729 | 19.2714 | 19.2721 | 18564.0 |
| 2014-04-04 08:20:00 | AAPL | Stock | 19.275 | 19.2804 | 19.275 | 19.28 | 46928.0 |
| 2014-04-04 08:25:00 | AAPL | Stock | 19.2811 | 19.2821 | 19.2682 | 19.2682 | 17108.0 |
| 2014-04-04 08:30:00 | AAPL | Stock | 19.2636 | 19.2925 | 19.2521 | 19.2582 | 191772.0 |
| 2014-04-04 08:35:00 | AAPL | Stock | 19.2639 | 19.2679 | 19.2425 | 19.2486 | 173040.0 |
| 2014-04-04 08:40:00 | AAPL | Stock | 19.2464 | 19.2657 | 19.2425 | 19.2589 | 109200.0 |
| 2014-04-04 08:45:00 | AAPL | Stock | 19.2543 | 19.2639 | 19.2518 | 19.2639 | 70000.0 |
| 2014-04-04 08:50:00 | AAPL | Stock | 19.2632 | 19.2643 | 19.2632 | 19.2643 | 27888.0 |
| 2014-04-04 08:55:00 | AAPL | Stock | 19.2611 | 19.2757 | 19.2593 | 19.2757 | 136472.0 |
| 2014-04-04 09:00:00 | AAPL | Stock | 19.2632 | 19.2632 | 19.2632 | 19.2632 | 5600.0 |
| 2014-04-04 09:05:00 | AAPL | Stock | 19.2696 | 19.2736 | 19.2689 | 19.2689 | 44828.0 |
| 2014-04-04 09:10:00 | AAPL | Stock | 19.2732 | 19.2732 | 19.2629 | 19.2629 | 43400.0 |
| 2014-04-04 09:15:00 | AAPL | Stock | 19.2654 | 19.2679 | 19.2625 | 19.2625 | 14000.0 |
| 2014-04-04 09:20:00 | AAPL | Stock | 19.2614 | 19.2657 | 19.2614 | 19.2657 | 46200.0 |
| 2014-04-04 09:25:00 | AAPL | Stock | 19.2579 | 19.2918 | 19.2543 | 19.2861 | 356048.0 |
| 2014-04-04 09:30:00 | AAPL | Stock | 19.2804 | 19.2857 | 19.2261 | 19.2289 | 8884568.0 |
| 2014-04-04 09:35:00 | AAPL | Stock | 19.2289 | 19.245 | 19.2146 | 19.2214 | 3243100.0 |
| 2014-04-04 09:40:00 | AAPL | Stock | 19.2227 | 19.2243 | 19.1946 | 19.2161 | 3193792.0 |
| 2014-04-04 09:45:00 | AAPL | Stock | 19.2114 | 19.2132 | 19.1654 | 19.1875 | 4996040.0 |
| 2014-04-04 09:50:00 | AAPL | Stock | 19.185 | 19.2054 | 19.1561 | 19.1614 | 3689448.0 |
| 2014-04-04 09:55:00 | AAPL | Stock | 19.1575 | 19.2032 | 19.1546 | 19.185 | 2923340.0 |
| 2014-04-04 10:00:00 | AAPL | Stock | 19.185 | 19.1925 | 19.1507 | 19.185 | 3699304.0 |
| 2014-04-04 10:05:00 | AAPL | Stock | 19.186 | 19.2107 | 19.1654 | 19.2054 | 3212412.0 |
| 2014-04-04 10:10:00 | AAPL | Stock | 19.2014 | 19.2071 | 19.1688 | 19.1696 | 2329628.0 |
| 2014-04-04 10:15:00 | AAPL | Stock | 19.1696 | 19.1746 | 19.1525 | 19.1564 | 2265788.0 |
| 2014-04-04 10:20:00 | AAPL | Stock | 19.1595 | 19.1682 | 19.1421 | 19.1614 | 4075120.0 |
| 2014-04-04 10:25:00 | AAPL | Stock | 19.1629 | 19.1861 | 19.14 | 19.1857 | 2151100.0 |
| 2014-04-04 10:30:00 | AAPL | Stock | 19.1882 | 19.1896 | 19.1686 | 19.1707 | 1607956.0 |
| 2014-04-04 10:35:00 | AAPL | Stock | 19.1761 | 19.1843 | 19.1536 | 19.1557 | 1760164.0 |
| 2014-04-04 10:40:00 | AAPL | Stock | 19.1554 | 19.1679 | 19.1368 | 19.1429 | 2831248.0 |
| 2014-04-04 10:45:00 | AAPL | Stock | 19.1389 | 19.1493 | 19.1207 | 19.1343 | 3112872.0 |
| 2014-04-04 10:50:00 | AAPL | Stock | 19.1298 | 19.1435 | 19.12 | 19.1321 | 2224600.0 |
| 2014-04-04 10:55:00 | AAPL | Stock | 19.1357 | 19.1382 | 19.1 | 19.1086 | 4096708.0 |
| 2014-04-04 11:00:00 | AAPL | Stock | 19.1079 | 19.1125 | 19.0954 | 19.0986 | 2902536.0 |
| 2014-04-04 11:05:00 | AAPL | Stock | 19.0964 | 19.1054 | 19.0825 | 19.0857 | 3197572.0 |
| 2014-04-04 11:10:00 | AAPL | Stock | 19.0861 | 19.1089 | 19.0829 | 19.0957 | 1994832.0 |
| 2014-04-04 11:15:00 | AAPL | Stock | 19.0957 | 19.1011 | 19.0625 | 19.0714 | 3418156.0 |
| 2014-04-04 11:20:00 | AAPL | Stock | 19.0711 | 19.0914 | 19.0611 | 19.0775 | 2181732.0 |
| 2014-04-04 11:25:00 | AAPL | Stock | 19.0725 | 19.0746 | 19.0536 | 19.0714 | 2754052.0 |
| 2014-04-04 11:30:00 | AAPL | Stock | 19.0675 | 19.0954 | 19.0661 | 19.0921 | 3172064.0 |
| 2014-04-04 11:35:00 | AAPL | Stock | 19.0886 | 19.0996 | 19.0721 | 19.0946 | 1385244.0 |
| 2014-04-04 11:40:00 | AAPL | Stock | 19.0893 | 19.0961 | 19.0661 | 19.0775 | 2645916.0 |
> showing 50 of 372,685 rows — these rows as CSV