PREVIEW / stock_5min / 2007-07-27
file: by_date/stock_5min/2007/2007-07-27.parquet size: 4.4 MB rows: 311,121 symbols: 3,081
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-27 09:30:00 | AAPL | Stock | 5.2211 | 5.2771 | 5.2096 | 5.2661 | 44160984.0 |
| 2007-07-27 09:35:00 | AAPL | Stock | 5.2679 | 5.2821 | 5.225 | 5.245 | 31119116.0 |
| 2007-07-27 09:40:00 | AAPL | Stock | 5.2443 | 5.2454 | 5.2139 | 5.2407 | 30212056.0 |
| 2007-07-27 09:45:00 | AAPL | Stock | 5.2407 | 5.2661 | 5.2321 | 5.2657 | 29090712.0 |
| 2007-07-27 09:50:00 | AAPL | Stock | 5.2661 | 5.2857 | 5.2564 | 5.2789 | 32430244.0 |
| 2007-07-27 09:55:00 | AAPL | Stock | 5.2775 | 5.2857 | 5.2746 | 5.2793 | 22452472.0 |
| 2007-07-27 10:00:00 | AAPL | Stock | 5.279 | 5.2943 | 5.2629 | 5.2943 | 33949300.0 |
| 2007-07-27 10:05:00 | AAPL | Stock | 5.294 | 5.3186 | 5.2893 | 5.2964 | 44123296.0 |
| 2007-07-27 10:10:00 | AAPL | Stock | 5.2968 | 5.3125 | 5.2768 | 5.2868 | 25523708.0 |
| 2007-07-27 10:15:00 | AAPL | Stock | 5.285 | 5.3 | 5.2789 | 5.2968 | 14994448.0 |
| 2007-07-27 10:20:00 | AAPL | Stock | 5.2964 | 5.2966 | 5.2679 | 5.2793 | 18749976.0 |
| 2007-07-27 10:25:00 | AAPL | Stock | 5.2793 | 5.2857 | 5.2679 | 5.2714 | 13926360.0 |
| 2007-07-27 10:30:00 | AAPL | Stock | 5.2714 | 5.285 | 5.2704 | 5.2754 | 11025280.0 |
| 2007-07-27 10:35:00 | AAPL | Stock | 5.2754 | 5.2857 | 5.2693 | 5.2732 | 15863680.0 |
| 2007-07-27 10:40:00 | AAPL | Stock | 5.2736 | 5.2739 | 5.2571 | 5.2654 | 18039028.0 |
| 2007-07-27 10:45:00 | AAPL | Stock | 5.2661 | 5.2696 | 5.25 | 5.2561 | 17764068.0 |
| 2007-07-27 10:50:00 | AAPL | Stock | 5.2554 | 5.2686 | 5.2389 | 5.2625 | 20672372.0 |
| 2007-07-27 10:55:00 | AAPL | Stock | 5.2618 | 5.2732 | 5.2525 | 5.2632 | 15423380.0 |
| 2007-07-27 11:00:00 | AAPL | Stock | 5.2625 | 5.2721 | 5.2479 | 5.2636 | 14215712.0 |
| 2007-07-27 11:05:00 | AAPL | Stock | 5.2639 | 5.2875 | 5.2639 | 5.2843 | 15424724.0 |
| 2007-07-27 11:10:00 | AAPL | Stock | 5.2839 | 5.2843 | 5.2728 | 5.2729 | 8399552.0 |
| 2007-07-27 11:15:00 | AAPL | Stock | 5.2729 | 5.2775 | 5.2621 | 5.2711 | 7969528.0 |
| 2007-07-27 11:20:00 | AAPL | Stock | 5.2714 | 5.2736 | 5.2607 | 5.2639 | 6612396.0 |
| 2007-07-27 11:25:00 | AAPL | Stock | 5.2639 | 5.2671 | 5.2518 | 5.2536 | 9751084.0 |
| 2007-07-27 11:30:00 | AAPL | Stock | 5.2536 | 5.2568 | 5.2371 | 5.2499 | 13871564.0 |
| 2007-07-27 11:35:00 | AAPL | Stock | 5.25 | 5.2508 | 5.2218 | 5.2343 | 15772568.0 |
| 2007-07-27 11:40:00 | AAPL | Stock | 5.2343 | 5.2517 | 5.2304 | 5.2486 | 9810864.0 |
| 2007-07-27 11:45:00 | AAPL | Stock | 5.2493 | 5.25 | 5.2321 | 5.2321 | 6929272.0 |
| 2007-07-27 11:50:00 | AAPL | Stock | 5.2321 | 5.2332 | 5.2143 | 5.2196 | 13961696.0 |
| 2007-07-27 11:55:00 | AAPL | Stock | 5.2196 | 5.2404 | 5.2154 | 5.2364 | 9894108.0 |
| 2007-07-27 12:00:00 | AAPL | Stock | 5.2336 | 5.2461 | 5.2232 | 5.2232 | 7176764.0 |
| 2007-07-27 12:05:00 | AAPL | Stock | 5.2229 | 5.2404 | 5.2218 | 5.2375 | 8437128.0 |
| 2007-07-27 12:10:00 | AAPL | Stock | 5.2379 | 5.2396 | 5.2304 | 5.2318 | 8287272.0 |
| 2007-07-27 12:15:00 | AAPL | Stock | 5.2318 | 5.2339 | 5.2189 | 5.2236 | 11404008.0 |
| 2007-07-27 12:20:00 | AAPL | Stock | 5.2243 | 5.2264 | 5.2032 | 5.205 | 16823072.0 |
| 2007-07-27 12:25:00 | AAPL | Stock | 5.2054 | 5.2175 | 5.195 | 5.1961 | 16415476.0 |
| 2007-07-27 12:30:00 | AAPL | Stock | 5.1954 | 5.1974 | 5.1518 | 5.1518 | 21956508.0 |
| 2007-07-27 12:35:00 | AAPL | Stock | 5.1521 | 5.1718 | 5.1371 | 5.1539 | 33565896.0 |
| 2007-07-27 12:40:00 | AAPL | Stock | 5.1529 | 5.1975 | 5.1482 | 5.1964 | 22630356.0 |
| 2007-07-27 12:45:00 | AAPL | Stock | 5.1964 | 5.1993 | 5.1718 | 5.1796 | 12775280.0 |
| 2007-07-27 12:50:00 | AAPL | Stock | 5.1789 | 5.1921 | 5.1732 | 5.1879 | 7343644.0 |
| 2007-07-27 12:55:00 | AAPL | Stock | 5.1882 | 5.1893 | 5.1714 | 5.1825 | 6868680.0 |
| 2007-07-27 13:00:00 | AAPL | Stock | 5.1822 | 5.1868 | 5.1732 | 5.185 | 4944912.0 |
| 2007-07-27 13:05:00 | AAPL | Stock | 5.185 | 5.1929 | 5.1804 | 5.1896 | 6682032.0 |
| 2007-07-27 13:10:00 | AAPL | Stock | 5.1893 | 5.1964 | 5.1807 | 5.185 | 6509552.0 |
| 2007-07-27 13:15:00 | AAPL | Stock | 5.1854 | 5.2093 | 5.1843 | 5.2054 | 9731232.0 |
| 2007-07-27 13:20:00 | AAPL | Stock | 5.2046 | 5.2082 | 5.1964 | 5.2029 | 8847916.0 |
| 2007-07-27 13:25:00 | AAPL | Stock | 5.2029 | 5.2036 | 5.185 | 5.1886 | 6197856.0 |
| 2007-07-27 13:30:00 | AAPL | Stock | 5.1882 | 5.1896 | 5.1714 | 5.1768 | 7677544.0 |
| 2007-07-27 13:35:00 | AAPL | Stock | 5.1768 | 5.1918 | 5.1768 | 5.1886 | 5327644.0 |
> showing 50 of 311,121 rows — these rows as CSV