PREVIEW / stock_5min / 2010-02-17
file: by_date/stock_5min/2010/2010-02-17.parquet size: 4.6 MB rows: 319,344 symbols: 3,447
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-17 06:05:00 | AAPL | Stock | 7.2696 | 7.2696 | 7.2696 | 7.2696 | 3752.0 |
| 2010-02-17 07:15:00 | AAPL | Stock | 7.2732 | 7.2732 | 7.2732 | 7.2732 | 2800.0 |
| 2010-02-17 07:30:00 | AAPL | Stock | 7.2807 | 7.2807 | 7.2793 | 7.2807 | 14000.0 |
| 2010-02-17 07:40:00 | AAPL | Stock | 7.2807 | 7.2854 | 7.2807 | 7.2854 | 14280.0 |
| 2010-02-17 07:45:00 | AAPL | Stock | 7.2854 | 7.2946 | 7.2854 | 7.2946 | 74144.0 |
| 2010-02-17 07:50:00 | AAPL | Stock | 7.2939 | 7.2939 | 7.2939 | 7.2939 | 2800.0 |
| 2010-02-17 07:55:00 | AAPL | Stock | 7.2921 | 7.2921 | 7.2921 | 7.2921 | 14000.0 |
| 2010-02-17 08:00:00 | AAPL | Stock | 7.2857 | 7.2946 | 7.2804 | 7.2918 | 672140.0 |
| 2010-02-17 08:05:00 | AAPL | Stock | 7.2879 | 7.2918 | 7.2875 | 7.2914 | 71820.0 |
| 2010-02-17 08:10:00 | AAPL | Stock | 7.2896 | 7.2929 | 7.2875 | 7.2929 | 121968.0 |
| 2010-02-17 08:15:00 | AAPL | Stock | 7.2929 | 7.2964 | 7.2918 | 7.2964 | 182672.0 |
| 2010-02-17 08:20:00 | AAPL | Stock | 7.2961 | 7.2964 | 7.2893 | 7.2893 | 183092.0 |
| 2010-02-17 08:25:00 | AAPL | Stock | 7.2929 | 7.2964 | 7.2929 | 7.2946 | 44324.0 |
| 2010-02-17 08:30:00 | AAPL | Stock | 7.2929 | 7.3036 | 7.2914 | 7.3004 | 207340.0 |
| 2010-02-17 08:35:00 | AAPL | Stock | 7.3007 | 7.3018 | 7.2946 | 7.2946 | 152628.0 |
| 2010-02-17 08:40:00 | AAPL | Stock | 7.2946 | 7.2964 | 7.2896 | 7.2896 | 85400.0 |
| 2010-02-17 08:45:00 | AAPL | Stock | 7.2914 | 7.2918 | 7.2907 | 7.2918 | 25200.0 |
| 2010-02-17 08:50:00 | AAPL | Stock | 7.2911 | 7.2911 | 7.2911 | 7.2911 | 2800.0 |
| 2010-02-17 08:55:00 | AAPL | Stock | 7.2946 | 7.2964 | 7.2936 | 7.2961 | 68040.0 |
| 2010-02-17 09:00:00 | AAPL | Stock | 7.295 | 7.2982 | 7.295 | 7.2964 | 80220.0 |
| 2010-02-17 09:05:00 | AAPL | Stock | 7.2979 | 7.2979 | 7.2911 | 7.2946 | 134456.0 |
| 2010-02-17 09:10:00 | AAPL | Stock | 7.2946 | 7.2982 | 7.2914 | 7.2964 | 178220.0 |
| 2010-02-17 09:15:00 | AAPL | Stock | 7.2964 | 7.3 | 7.2929 | 7.2934 | 404096.0 |
| 2010-02-17 09:20:00 | AAPL | Stock | 7.295 | 7.2964 | 7.2914 | 7.2929 | 140280.0 |
| 2010-02-17 09:25:00 | AAPL | Stock | 7.2921 | 7.2943 | 7.2843 | 7.2929 | 526260.0 |
| 2010-02-17 09:30:00 | AAPL | Stock | 7.2925 | 7.2968 | 7.2729 | 7.2857 | 14371056.0 |
| 2010-02-17 09:35:00 | AAPL | Stock | 7.2857 | 7.2882 | 7.2561 | 7.2739 | 16868096.0 |
| 2010-02-17 09:40:00 | AAPL | Stock | 7.2732 | 7.2732 | 7.2457 | 7.2532 | 13629840.0 |
| 2010-02-17 09:45:00 | AAPL | Stock | 7.2536 | 7.2639 | 7.2507 | 7.2639 | 9464140.0 |
| 2010-02-17 09:50:00 | AAPL | Stock | 7.2639 | 7.2679 | 7.2546 | 7.265 | 8325100.0 |
| 2010-02-17 09:55:00 | AAPL | Stock | 7.2643 | 7.2711 | 7.2571 | 7.2618 | 8269688.0 |
| 2010-02-17 10:00:00 | AAPL | Stock | 7.2625 | 7.2711 | 7.2589 | 7.2604 | 10453800.0 |
| 2010-02-17 10:05:00 | AAPL | Stock | 7.2611 | 7.2796 | 7.26 | 7.2771 | 8684256.0 |
| 2010-02-17 10:10:00 | AAPL | Stock | 7.2779 | 7.2846 | 7.2739 | 7.2804 | 6934956.0 |
| 2010-02-17 10:15:00 | AAPL | Stock | 7.2789 | 7.2818 | 7.2696 | 7.2725 | 6338220.0 |
| 2010-02-17 10:20:00 | AAPL | Stock | 7.2721 | 7.2732 | 7.2589 | 7.26 | 6761776.0 |
| 2010-02-17 10:25:00 | AAPL | Stock | 7.26 | 7.2693 | 7.2589 | 7.2607 | 4425904.0 |
| 2010-02-17 10:30:00 | AAPL | Stock | 7.2601 | 7.275 | 7.2589 | 7.2668 | 5573960.0 |
| 2010-02-17 10:35:00 | AAPL | Stock | 7.2661 | 7.2714 | 7.2543 | 7.2568 | 7522536.0 |
| 2010-02-17 10:40:00 | AAPL | Stock | 7.2557 | 7.2607 | 7.2489 | 7.2554 | 6398952.0 |
| 2010-02-17 10:45:00 | AAPL | Stock | 7.2557 | 7.2625 | 7.2507 | 7.2529 | 4853100.0 |
| 2010-02-17 10:50:00 | AAPL | Stock | 7.2525 | 7.2614 | 7.2514 | 7.257 | 4967004.0 |
| 2010-02-17 10:55:00 | AAPL | Stock | 7.2579 | 7.26 | 7.2486 | 7.2593 | 5135312.0 |
| 2010-02-17 11:00:00 | AAPL | Stock | 7.2589 | 7.2599 | 7.2461 | 7.2461 | 5572504.0 |
| 2010-02-17 11:05:00 | AAPL | Stock | 7.2464 | 7.2496 | 7.2218 | 7.2271 | 11310600.0 |
| 2010-02-17 11:10:00 | AAPL | Stock | 7.2271 | 7.2332 | 7.2193 | 7.2307 | 6889932.0 |
| 2010-02-17 11:15:00 | AAPL | Stock | 7.2307 | 7.2329 | 7.2271 | 7.2329 | 3693340.0 |
| 2010-02-17 11:20:00 | AAPL | Stock | 7.2318 | 7.2346 | 7.2293 | 7.2311 | 6308848.0 |
| 2010-02-17 11:25:00 | AAPL | Stock | 7.2314 | 7.2318 | 7.1943 | 7.2004 | 11171552.0 |
| 2010-02-17 11:30:00 | AAPL | Stock | 7.2006 | 7.2079 | 7.1896 | 7.2054 | 8092756.0 |
> showing 50 of 319,344 rows — these rows as CSV