PREVIEW / stock_5min / 2008-02-07
file: by_date/stock_5min/2008/2008-02-07.parquet size: 4.4 MB rows: 319,011 symbols: 3,254
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-07 04:20:00 | AAPL | Stock | 4.3225 | 4.3225 | 4.3225 | 4.3225 | 2800.0 |
| 2008-02-07 05:05:00 | AAPL | Stock | 4.3232 | 4.3232 | 4.3207 | 4.3207 | 58800.0 |
| 2008-02-07 05:55:00 | AAPL | Stock | 4.3104 | 4.3107 | 4.3104 | 4.3107 | 28000.0 |
| 2008-02-07 06:05:00 | AAPL | Stock | 4.3114 | 4.3114 | 4.3114 | 4.3114 | 2800.0 |
| 2008-02-07 06:10:00 | AAPL | Stock | 4.3064 | 4.3082 | 4.3064 | 4.3082 | 11200.0 |
| 2008-02-07 06:20:00 | AAPL | Stock | 4.305 | 4.305 | 4.305 | 4.305 | 11200.0 |
| 2008-02-07 06:55:00 | AAPL | Stock | 4.3107 | 4.3107 | 4.3107 | 4.3107 | 3500.0 |
| 2008-02-07 07:00:00 | AAPL | Stock | 4.3107 | 4.3136 | 4.2964 | 4.3121 | 44100.0 |
| 2008-02-07 07:20:00 | AAPL | Stock | 4.3 | 4.3 | 4.3 | 4.3 | 2800.0 |
| 2008-02-07 07:25:00 | AAPL | Stock | 4.2943 | 4.2943 | 4.2939 | 4.2939 | 28000.0 |
| 2008-02-07 07:30:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2929 | 4.2929 | 47404.0 |
| 2008-02-07 07:35:00 | AAPL | Stock | 4.2964 | 4.2964 | 4.29 | 4.29 | 8400.0 |
| 2008-02-07 07:40:00 | AAPL | Stock | 4.2946 | 4.2982 | 4.2875 | 4.2875 | 28896.0 |
| 2008-02-07 07:45:00 | AAPL | Stock | 4.2964 | 4.3 | 4.2964 | 4.2964 | 84000.0 |
| 2008-02-07 07:50:00 | AAPL | Stock | 4.2879 | 4.2893 | 4.2839 | 4.2839 | 147812.0 |
| 2008-02-07 07:55:00 | AAPL | Stock | 4.2839 | 4.2839 | 4.2743 | 4.2743 | 68600.0 |
| 2008-02-07 08:00:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.2411 | 4.2464 | 828828.0 |
| 2008-02-07 08:05:00 | AAPL | Stock | 4.2479 | 4.2571 | 4.2468 | 4.2536 | 618156.0 |
| 2008-02-07 08:10:00 | AAPL | Stock | 4.25 | 4.2518 | 4.2429 | 4.2432 | 187908.0 |
| 2008-02-07 08:15:00 | AAPL | Stock | 4.2479 | 4.2625 | 4.2357 | 4.2625 | 815248.0 |
| 2008-02-07 08:20:00 | AAPL | Stock | 4.2607 | 4.2607 | 4.25 | 4.2564 | 388864.0 |
| 2008-02-07 08:25:00 | AAPL | Stock | 4.2571 | 4.2625 | 4.25 | 4.2571 | 555576.0 |
| 2008-02-07 08:30:00 | AAPL | Stock | 4.25 | 4.2607 | 4.2382 | 4.25 | 980224.0 |
| 2008-02-07 08:35:00 | AAPL | Stock | 4.25 | 4.2761 | 4.2479 | 4.2732 | 943320.0 |
| 2008-02-07 08:40:00 | AAPL | Stock | 4.2718 | 4.2718 | 4.2607 | 4.2657 | 264068.0 |
| 2008-02-07 08:45:00 | AAPL | Stock | 4.2657 | 4.27 | 4.2579 | 4.2679 | 335636.0 |
| 2008-02-07 08:50:00 | AAPL | Stock | 4.265 | 4.2682 | 4.2596 | 4.2679 | 474068.0 |
| 2008-02-07 08:55:00 | AAPL | Stock | 4.2679 | 4.2696 | 4.2607 | 4.2668 | 540904.0 |
| 2008-02-07 09:00:00 | AAPL | Stock | 4.2657 | 4.2818 | 4.2643 | 4.2789 | 855624.0 |
| 2008-02-07 09:05:00 | AAPL | Stock | 4.2807 | 4.2993 | 4.2786 | 4.2982 | 2561888.0 |
| 2008-02-07 09:10:00 | AAPL | Stock | 4.2982 | 4.3571 | 4.2868 | 4.2918 | 1158164.0 |
| 2008-02-07 09:15:00 | AAPL | Stock | 4.2918 | 4.2961 | 4.2904 | 4.2929 | 691460.0 |
| 2008-02-07 09:20:00 | AAPL | Stock | 4.2932 | 4.3107 | 4.2929 | 4.3071 | 1263752.0 |
| 2008-02-07 09:25:00 | AAPL | Stock | 4.3089 | 4.3104 | 4.2786 | 4.2857 | 4491396.0 |
| 2008-02-07 09:30:00 | AAPL | Stock | 4.2846 | 4.3139 | 4.2743 | 4.3135 | 69780872.0 |
| 2008-02-07 09:35:00 | AAPL | Stock | 4.3132 | 4.3393 | 4.2786 | 4.2921 | 55261976.0 |
| 2008-02-07 09:40:00 | AAPL | Stock | 4.2918 | 4.3114 | 4.2782 | 4.2989 | 35239652.0 |
| 2008-02-07 09:45:00 | AAPL | Stock | 4.3 | 4.3014 | 4.2525 | 4.2568 | 40687976.0 |
| 2008-02-07 09:50:00 | AAPL | Stock | 4.2561 | 4.2857 | 4.2179 | 4.2275 | 49183120.0 |
| 2008-02-07 09:55:00 | AAPL | Stock | 4.2279 | 4.2318 | 4.1882 | 4.2107 | 54934404.0 |
| 2008-02-07 10:00:00 | AAPL | Stock | 4.2118 | 4.2707 | 4.2096 | 4.2693 | 54455800.0 |
| 2008-02-07 10:05:00 | AAPL | Stock | 4.2686 | 4.2857 | 4.2571 | 4.2754 | 53587660.0 |
| 2008-02-07 10:10:00 | AAPL | Stock | 4.2754 | 4.3093 | 4.2514 | 4.2964 | 53913412.0 |
| 2008-02-07 10:15:00 | AAPL | Stock | 4.2964 | 4.3411 | 4.2929 | 4.3143 | 55698440.0 |
| 2008-02-07 10:20:00 | AAPL | Stock | 4.3143 | 4.3386 | 4.2986 | 4.33 | 40176864.0 |
| 2008-02-07 10:25:00 | AAPL | Stock | 4.3293 | 4.3536 | 4.2993 | 4.3114 | 48307280.0 |
| 2008-02-07 10:30:00 | AAPL | Stock | 4.3125 | 4.3182 | 4.2811 | 4.2943 | 35332920.0 |
| 2008-02-07 10:35:00 | AAPL | Stock | 4.2946 | 4.3054 | 4.2643 | 4.2679 | 31216052.0 |
| 2008-02-07 10:40:00 | AAPL | Stock | 4.2679 | 4.2679 | 4.2361 | 4.2614 | 39106060.0 |
| 2008-02-07 10:45:00 | AAPL | Stock | 4.2614 | 4.2936 | 4.2443 | 4.2936 | 25929820.0 |
> showing 50 of 319,011 rows — these rows as CSV