PREVIEW / stock_5min / 2011-11-01
file: by_date/stock_5min/2011/2011-11-01.parquet size: 5.0 MB rows: 337,421 symbols: 3,497
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-01 04:00:00 | AAPL | Stock | 14.4021 | 14.4021 | 14.4021 | 14.4021 | 11200.0 |
| 2011-11-01 04:05:00 | AAPL | Stock | 14.3171 | 14.3171 | 14.3171 | 14.3171 | 4256.0 |
| 2011-11-01 04:15:00 | AAPL | Stock | 14.3632 | 14.3632 | 14.3632 | 14.3632 | 2800.0 |
| 2011-11-01 04:20:00 | AAPL | Stock | 14.2886 | 14.2886 | 14.2886 | 14.2886 | 6496.0 |
| 2011-11-01 04:25:00 | AAPL | Stock | 14.2529 | 14.2529 | 14.2529 | 14.2529 | 8400.0 |
| 2011-11-01 04:30:00 | AAPL | Stock | 14.2529 | 14.2529 | 14.2529 | 14.2529 | 2800.0 |
| 2011-11-01 04:50:00 | AAPL | Stock | 14.2896 | 14.2896 | 14.2896 | 14.2896 | 2800.0 |
| 2011-11-01 04:55:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3007 | 14.3007 | 5600.0 |
| 2011-11-01 05:00:00 | AAPL | Stock | 14.3204 | 14.3204 | 14.3204 | 14.3204 | 2800.0 |
| 2011-11-01 05:05:00 | AAPL | Stock | 14.3061 | 14.3061 | 14.3061 | 14.3061 | 2800.0 |
| 2011-11-01 05:10:00 | AAPL | Stock | 14.3061 | 14.3061 | 14.3061 | 14.3061 | 2800.0 |
| 2011-11-01 05:15:00 | AAPL | Stock | 14.3143 | 14.3143 | 14.3143 | 14.3143 | 5600.0 |
| 2011-11-01 05:25:00 | AAPL | Stock | 14.3018 | 14.3018 | 14.3018 | 14.3018 | 8400.0 |
| 2011-11-01 05:55:00 | AAPL | Stock | 14.2982 | 14.2982 | 14.2982 | 14.2982 | 2800.0 |
| 2011-11-01 06:00:00 | AAPL | Stock | 14.2821 | 14.2821 | 14.2621 | 14.2621 | 6636.0 |
| 2011-11-01 06:10:00 | AAPL | Stock | 14.2621 | 14.2621 | 14.2614 | 14.2614 | 11200.0 |
| 2011-11-01 06:20:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.2768 | 14.2768 | 3668.0 |
| 2011-11-01 06:25:00 | AAPL | Stock | 14.2625 | 14.2625 | 14.2625 | 14.2625 | 25200.0 |
| 2011-11-01 06:40:00 | AAPL | Stock | 14.2625 | 14.2625 | 14.2625 | 14.2625 | 2800.0 |
| 2011-11-01 07:00:00 | AAPL | Stock | 14.2768 | 14.2786 | 14.2589 | 14.2768 | 68600.0 |
| 2011-11-01 07:05:00 | AAPL | Stock | 14.2807 | 14.2989 | 14.2807 | 14.2989 | 16800.0 |
| 2011-11-01 07:10:00 | AAPL | Stock | 14.3 | 14.3 | 14.2921 | 14.2982 | 16800.0 |
| 2011-11-01 07:15:00 | AAPL | Stock | 14.2861 | 14.2861 | 14.2714 | 14.2771 | 126420.0 |
| 2011-11-01 07:20:00 | AAPL | Stock | 14.2736 | 14.2786 | 14.2714 | 14.2718 | 39200.0 |
| 2011-11-01 07:25:00 | AAPL | Stock | 14.2729 | 14.275 | 14.265 | 14.2661 | 70000.0 |
| 2011-11-01 07:30:00 | AAPL | Stock | 14.2611 | 14.2643 | 14.2518 | 14.2589 | 47908.0 |
| 2011-11-01 07:35:00 | AAPL | Stock | 14.2593 | 14.2643 | 14.2554 | 14.2571 | 43988.0 |
| 2011-11-01 07:40:00 | AAPL | Stock | 14.2607 | 14.2857 | 14.2607 | 14.2857 | 70000.0 |
| 2011-11-01 07:45:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2686 | 14.27 | 28840.0 |
| 2011-11-01 07:50:00 | AAPL | Stock | 14.27 | 14.275 | 14.2146 | 14.2318 | 186928.0 |
| 2011-11-01 07:55:00 | AAPL | Stock | 14.2168 | 14.2457 | 14.1943 | 14.2457 | 160888.0 |
| 2011-11-01 08:00:00 | AAPL | Stock | 14.2571 | 14.2714 | 14.2379 | 14.2379 | 856884.0 |
| 2011-11-01 08:05:00 | AAPL | Stock | 14.25 | 14.2857 | 14.2457 | 14.2821 | 57568.0 |
| 2011-11-01 08:10:00 | AAPL | Stock | 14.275 | 14.285 | 14.2625 | 14.2693 | 223272.0 |
| 2011-11-01 08:15:00 | AAPL | Stock | 14.2654 | 14.2714 | 14.2457 | 14.2457 | 145656.0 |
| 2011-11-01 08:20:00 | AAPL | Stock | 14.25 | 14.2568 | 14.2357 | 14.2375 | 414764.0 |
| 2011-11-01 08:25:00 | AAPL | Stock | 14.2329 | 14.2375 | 14.1968 | 14.2 | 455196.0 |
| 2011-11-01 08:30:00 | AAPL | Stock | 14.2136 | 14.2214 | 14.1986 | 14.1986 | 654192.0 |
| 2011-11-01 08:35:00 | AAPL | Stock | 14.2054 | 14.2179 | 14.1929 | 14.2054 | 723240.0 |
| 2011-11-01 08:40:00 | AAPL | Stock | 14.2143 | 14.2214 | 14.2089 | 14.2214 | 110432.0 |
| 2011-11-01 08:45:00 | AAPL | Stock | 14.2214 | 14.2214 | 14.1929 | 14.2014 | 453012.0 |
| 2011-11-01 08:50:00 | AAPL | Stock | 14.1975 | 14.2089 | 14.1868 | 14.2054 | 424704.0 |
| 2011-11-01 08:55:00 | AAPL | Stock | 14.1971 | 14.2346 | 14.1971 | 14.2136 | 232344.0 |
| 2011-11-01 09:00:00 | AAPL | Stock | 14.2054 | 14.2139 | 14.1825 | 14.1921 | 261940.0 |
| 2011-11-01 09:05:00 | AAPL | Stock | 14.195 | 14.1961 | 14.1643 | 14.1696 | 730744.0 |
| 2011-11-01 09:10:00 | AAPL | Stock | 14.1739 | 14.1786 | 14.1704 | 14.1782 | 429520.0 |
| 2011-11-01 09:15:00 | AAPL | Stock | 14.1779 | 14.1789 | 14.1732 | 14.1764 | 450716.0 |
| 2011-11-01 09:20:00 | AAPL | Stock | 14.1739 | 14.1961 | 14.1714 | 14.1893 | 189448.0 |
| 2011-11-01 09:25:00 | AAPL | Stock | 14.1882 | 14.4564 | 14.1714 | 14.18 | 727972.0 |
| 2011-11-01 09:30:00 | AAPL | Stock | 14.1914 | 14.2589 | 14.1429 | 14.2346 | 26679996.0 |
> showing 50 of 337,421 rows — these rows as CSV