PREVIEW / stock_5min / 2008-01-11
file: by_date/stock_5min/2008/2008-01-11.parquet size: 4.4 MB rows: 322,418 symbols: 3,259
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-01-11 06:55:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 11200.0 |
| 2008-01-11 07:00:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 19600.0 |
| 2008-01-11 07:10:00 | AAPL | Stock | 6.3032 | 6.3032 | 6.2857 | 6.2857 | 39480.0 |
| 2008-01-11 07:15:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 8708.0 |
| 2008-01-11 07:20:00 | AAPL | Stock | 6.2946 | 6.2946 | 6.2857 | 6.2857 | 73080.0 |
| 2008-01-11 07:45:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2854 | 6.2857 | 44800.0 |
| 2008-01-11 07:50:00 | AAPL | Stock | 6.2929 | 6.3011 | 6.2929 | 6.3011 | 52220.0 |
| 2008-01-11 07:55:00 | AAPL | Stock | 6.3032 | 6.3171 | 6.3032 | 6.3168 | 33600.0 |
| 2008-01-11 08:00:00 | AAPL | Stock | 6.3107 | 6.3107 | 6.2786 | 6.285 | 758212.0 |
| 2008-01-11 08:05:00 | AAPL | Stock | 6.2789 | 6.2857 | 6.2704 | 6.2775 | 669564.0 |
| 2008-01-11 08:10:00 | AAPL | Stock | 6.2775 | 6.2925 | 6.2771 | 6.2925 | 260652.0 |
| 2008-01-11 08:15:00 | AAPL | Stock | 6.2929 | 6.2929 | 6.2821 | 6.2857 | 457352.0 |
| 2008-01-11 08:20:00 | AAPL | Stock | 6.2807 | 6.2857 | 6.2771 | 6.2857 | 332276.0 |
| 2008-01-11 08:25:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2771 | 6.2771 | 182812.0 |
| 2008-01-11 08:30:00 | AAPL | Stock | 6.2771 | 6.2771 | 6.2643 | 6.275 | 656460.0 |
| 2008-01-11 08:35:00 | AAPL | Stock | 6.2707 | 6.2911 | 6.2707 | 6.2911 | 238028.0 |
| 2008-01-11 08:40:00 | AAPL | Stock | 6.2857 | 6.2946 | 6.2857 | 6.2861 | 273924.0 |
| 2008-01-11 08:45:00 | AAPL | Stock | 6.2911 | 6.2946 | 6.2875 | 6.2875 | 84560.0 |
| 2008-01-11 08:50:00 | AAPL | Stock | 6.2893 | 6.2932 | 6.2804 | 6.2911 | 271628.0 |
| 2008-01-11 08:55:00 | AAPL | Stock | 6.2871 | 6.2907 | 6.2857 | 6.2857 | 75712.0 |
| 2008-01-11 09:00:00 | AAPL | Stock | 6.2893 | 6.3025 | 6.2857 | 6.2943 | 483000.0 |
| 2008-01-11 09:05:00 | AAPL | Stock | 6.2996 | 6.3111 | 6.2979 | 6.3107 | 317044.0 |
| 2008-01-11 09:10:00 | AAPL | Stock | 6.3107 | 6.3139 | 6.29 | 6.2957 | 348012.0 |
| 2008-01-11 09:15:00 | AAPL | Stock | 6.2993 | 6.3032 | 6.2832 | 6.2929 | 215600.0 |
| 2008-01-11 09:20:00 | AAPL | Stock | 6.2964 | 6.3 | 6.2929 | 6.2954 | 105616.0 |
| 2008-01-11 09:25:00 | AAPL | Stock | 6.2911 | 6.2925 | 6.2821 | 6.2857 | 330400.0 |
| 2008-01-11 09:30:00 | AAPL | Stock | 6.2857 | 6.3146 | 6.2811 | 6.2925 | 23196684.0 |
| 2008-01-11 09:35:00 | AAPL | Stock | 6.2929 | 6.3518 | 6.2679 | 6.3293 | 28245392.0 |
| 2008-01-11 09:40:00 | AAPL | Stock | 6.3286 | 6.3507 | 6.2971 | 6.3064 | 25693976.0 |
| 2008-01-11 09:45:00 | AAPL | Stock | 6.3068 | 6.3293 | 6.2768 | 6.3239 | 20628748.0 |
| 2008-01-11 09:50:00 | AAPL | Stock | 6.3239 | 6.3314 | 6.2821 | 6.3079 | 13456324.0 |
| 2008-01-11 09:55:00 | AAPL | Stock | 6.3071 | 6.3161 | 6.2821 | 6.3011 | 18631592.0 |
| 2008-01-11 10:00:00 | AAPL | Stock | 6.2979 | 6.3071 | 6.2864 | 6.2989 | 10581480.0 |
| 2008-01-11 10:05:00 | AAPL | Stock | 6.3004 | 6.3032 | 6.2825 | 6.293 | 14256620.0 |
| 2008-01-11 10:10:00 | AAPL | Stock | 6.2929 | 6.3254 | 6.2929 | 6.3 | 18280360.0 |
| 2008-01-11 10:15:00 | AAPL | Stock | 6.2993 | 6.3179 | 6.2982 | 6.3125 | 9703652.0 |
| 2008-01-11 10:20:00 | AAPL | Stock | 6.3132 | 6.34 | 6.3114 | 6.3171 | 16577008.0 |
| 2008-01-11 10:25:00 | AAPL | Stock | 6.3196 | 6.32 | 6.3 | 6.3143 | 11175920.0 |
| 2008-01-11 10:30:00 | AAPL | Stock | 6.3146 | 6.3186 | 6.2982 | 6.3079 | 10311056.0 |
| 2008-01-11 10:35:00 | AAPL | Stock | 6.3086 | 6.3161 | 6.2996 | 6.3129 | 8902684.0 |
| 2008-01-11 10:40:00 | AAPL | Stock | 6.3129 | 6.3243 | 6.3018 | 6.3111 | 9234316.0 |
| 2008-01-11 10:45:00 | AAPL | Stock | 6.3114 | 6.3157 | 6.3054 | 6.3086 | 5220264.0 |
| 2008-01-11 10:50:00 | AAPL | Stock | 6.3089 | 6.3143 | 6.2986 | 6.3039 | 12593364.0 |
| 2008-01-11 10:55:00 | AAPL | Stock | 6.3039 | 6.3046 | 6.2704 | 6.2786 | 18852540.0 |
| 2008-01-11 11:00:00 | AAPL | Stock | 6.2786 | 6.2857 | 6.2443 | 6.26 | 26895904.0 |
| 2008-01-11 11:05:00 | AAPL | Stock | 6.2607 | 6.2686 | 6.2393 | 6.2661 | 17811192.0 |
| 2008-01-11 11:10:00 | AAPL | Stock | 6.2654 | 6.2811 | 6.26 | 6.2736 | 9422084.0 |
| 2008-01-11 11:15:00 | AAPL | Stock | 6.2739 | 6.2811 | 6.2375 | 6.2479 | 12840128.0 |
| 2008-01-11 11:20:00 | AAPL | Stock | 6.2489 | 6.2604 | 6.2261 | 6.2421 | 14232484.0 |
| 2008-01-11 11:25:00 | AAPL | Stock | 6.2429 | 6.2711 | 6.2429 | 6.2568 | 6328840.0 |
> showing 50 of 322,418 rows — these rows as CSV