PREVIEW / stock_5min / 2008-09-11
file: by_date/stock_5min/2008/2008-09-11.parquet size: 4.5 MB rows: 321,091 symbols: 3,332
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-09-11 05:50:00 | AAPL | Stock | 5.3679 | 5.3679 | 5.3679 | 5.3679 | 2800.0 |
| 2008-09-11 07:40:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 2800.0 |
| 2008-09-11 07:45:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 2800.0 |
| 2008-09-11 07:55:00 | AAPL | Stock | 5.3321 | 5.3321 | 5.3321 | 5.3321 | 14000.0 |
| 2008-09-11 08:00:00 | AAPL | Stock | 5.3261 | 5.3464 | 5.3221 | 5.3304 | 70644.0 |
| 2008-09-11 08:05:00 | AAPL | Stock | 5.3268 | 5.3321 | 5.3246 | 5.3314 | 218932.0 |
| 2008-09-11 08:10:00 | AAPL | Stock | 5.3314 | 5.3321 | 5.3236 | 5.325 | 158928.0 |
| 2008-09-11 08:15:00 | AAPL | Stock | 5.3214 | 5.3232 | 5.3036 | 5.3214 | 191520.0 |
| 2008-09-11 08:20:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.295 | 5.3118 | 174580.0 |
| 2008-09-11 08:25:00 | AAPL | Stock | 5.3129 | 5.3129 | 5.3 | 5.3 | 458528.0 |
| 2008-09-11 08:30:00 | AAPL | Stock | 5.2982 | 5.3068 | 5.2868 | 5.3036 | 914340.0 |
| 2008-09-11 08:35:00 | AAPL | Stock | 5.3071 | 5.3071 | 5.2832 | 5.2961 | 284620.0 |
| 2008-09-11 08:40:00 | AAPL | Stock | 5.3 | 5.3 | 5.2886 | 5.2914 | 201600.0 |
| 2008-09-11 08:45:00 | AAPL | Stock | 5.2886 | 5.2886 | 5.2804 | 5.2839 | 264096.0 |
| 2008-09-11 08:50:00 | AAPL | Stock | 5.2839 | 5.2911 | 5.2818 | 5.2882 | 304472.0 |
| 2008-09-11 08:55:00 | AAPL | Stock | 5.2861 | 5.2971 | 5.2804 | 5.2929 | 190456.0 |
| 2008-09-11 09:00:00 | AAPL | Stock | 5.2886 | 5.2886 | 5.2718 | 5.2754 | 154644.0 |
| 2008-09-11 09:05:00 | AAPL | Stock | 5.2725 | 5.2779 | 5.2593 | 5.275 | 656656.0 |
| 2008-09-11 09:10:00 | AAPL | Stock | 5.2779 | 5.2937 | 5.2764 | 5.2857 | 1940344.0 |
| 2008-09-11 09:15:00 | AAPL | Stock | 5.2893 | 5.2918 | 5.2857 | 5.2914 | 235508.0 |
| 2008-09-11 09:20:00 | AAPL | Stock | 5.2893 | 5.3011 | 5.2857 | 5.2925 | 1667344.0 |
| 2008-09-11 09:25:00 | AAPL | Stock | 5.2857 | 5.2989 | 5.2857 | 5.2932 | 490252.0 |
| 2008-09-11 09:30:00 | AAPL | Stock | 5.2921 | 5.3036 | 5.2714 | 5.2886 | 36459304.0 |
| 2008-09-11 09:35:00 | AAPL | Stock | 5.2886 | 5.3107 | 5.2536 | 5.2618 | 25948524.0 |
| 2008-09-11 09:40:00 | AAPL | Stock | 5.2611 | 5.2639 | 5.2143 | 5.2232 | 30233840.0 |
| 2008-09-11 09:45:00 | AAPL | Stock | 5.2236 | 5.2639 | 5.2225 | 5.2479 | 18583236.0 |
| 2008-09-11 09:50:00 | AAPL | Stock | 5.2479 | 5.2839 | 5.2439 | 5.2682 | 23652076.0 |
| 2008-09-11 09:55:00 | AAPL | Stock | 5.2679 | 5.2786 | 5.2361 | 5.2361 | 15429792.0 |
| 2008-09-11 10:00:00 | AAPL | Stock | 5.2395 | 5.2768 | 5.2304 | 5.2561 | 21143808.0 |
| 2008-09-11 10:05:00 | AAPL | Stock | 5.2571 | 5.2654 | 5.2479 | 5.2636 | 16392656.0 |
| 2008-09-11 10:10:00 | AAPL | Stock | 5.2632 | 5.2679 | 5.2182 | 5.2521 | 25972996.0 |
| 2008-09-11 10:15:00 | AAPL | Stock | 5.2521 | 5.2929 | 5.2511 | 5.2904 | 20556900.0 |
| 2008-09-11 10:20:00 | AAPL | Stock | 5.2918 | 5.3214 | 5.2684 | 5.3011 | 19108180.0 |
| 2008-09-11 10:25:00 | AAPL | Stock | 5.3018 | 5.3161 | 5.28 | 5.2825 | 15947260.0 |
| 2008-09-11 10:30:00 | AAPL | Stock | 5.2821 | 5.2882 | 5.2686 | 5.2804 | 10142328.0 |
| 2008-09-11 10:35:00 | AAPL | Stock | 5.2804 | 5.285 | 5.2679 | 5.2829 | 7856800.0 |
| 2008-09-11 10:40:00 | AAPL | Stock | 5.2841 | 5.3125 | 5.2721 | 5.3125 | 12916204.0 |
| 2008-09-11 10:45:00 | AAPL | Stock | 5.3111 | 5.3279 | 5.2975 | 5.3107 | 13337688.0 |
| 2008-09-11 10:50:00 | AAPL | Stock | 5.3107 | 5.325 | 5.2912 | 5.3182 | 12611452.0 |
| 2008-09-11 10:55:00 | AAPL | Stock | 5.3182 | 5.3214 | 5.3036 | 5.3182 | 11315332.0 |
| 2008-09-11 11:00:00 | AAPL | Stock | 5.3182 | 5.3368 | 5.3054 | 5.3132 | 14035868.0 |
| 2008-09-11 11:05:00 | AAPL | Stock | 5.3139 | 5.3275 | 5.3 | 5.3 | 10324048.0 |
| 2008-09-11 11:10:00 | AAPL | Stock | 5.3 | 5.3054 | 5.2911 | 5.2946 | 8848728.0 |
| 2008-09-11 11:15:00 | AAPL | Stock | 5.2964 | 5.3059 | 5.2921 | 5.2982 | 5629764.0 |
| 2008-09-11 11:20:00 | AAPL | Stock | 5.2986 | 5.3036 | 5.2846 | 5.2929 | 7294952.0 |
| 2008-09-11 11:25:00 | AAPL | Stock | 5.2929 | 5.3004 | 5.2857 | 5.2982 | 6544580.0 |
| 2008-09-11 11:30:00 | AAPL | Stock | 5.2993 | 5.3214 | 5.2954 | 5.3154 | 8624084.0 |
| 2008-09-11 11:35:00 | AAPL | Stock | 5.3154 | 5.3332 | 5.3086 | 5.3275 | 9891672.0 |
| 2008-09-11 11:40:00 | AAPL | Stock | 5.3282 | 5.3464 | 5.2857 | 5.34 | 14842716.0 |
| 2008-09-11 11:45:00 | AAPL | Stock | 5.3404 | 5.3432 | 5.3268 | 5.3364 | 7603176.0 |
> showing 50 of 321,091 rows — these rows as CSV