PREVIEW / stock_5min / 2008-07-10
file: by_date/stock_5min/2008/2008-07-10.parquet size: 4.5 MB rows: 319,532 symbols: 3,315
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-07-10 04:15:00 | AAPL | Stock | 6.2621 | 6.2621 | 6.2621 | 6.2621 | 2800.0 |
| 2008-07-10 06:30:00 | AAPL | Stock | 6.2757 | 6.29 | 6.2757 | 6.2757 | 68488.0 |
| 2008-07-10 07:00:00 | AAPL | Stock | 6.2643 | 6.2643 | 6.2643 | 6.2643 | 16800.0 |
| 2008-07-10 07:05:00 | AAPL | Stock | 6.2564 | 6.2564 | 6.2564 | 6.2564 | 2800.0 |
| 2008-07-10 07:10:00 | AAPL | Stock | 6.2671 | 6.2679 | 6.2671 | 6.2679 | 61600.0 |
| 2008-07-10 07:15:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 2800.0 |
| 2008-07-10 07:20:00 | AAPL | Stock | 6.2757 | 6.2757 | 6.2757 | 6.2757 | 21644.0 |
| 2008-07-10 07:25:00 | AAPL | Stock | 6.2746 | 6.2857 | 6.2746 | 6.2857 | 58128.0 |
| 2008-07-10 07:30:00 | AAPL | Stock | 6.2875 | 6.3207 | 6.2875 | 6.3207 | 214956.0 |
| 2008-07-10 07:35:00 | AAPL | Stock | 6.3175 | 6.3289 | 6.3161 | 6.3289 | 38388.0 |
| 2008-07-10 07:40:00 | AAPL | Stock | 6.3214 | 6.3454 | 6.3214 | 6.3214 | 89404.0 |
| 2008-07-10 07:45:00 | AAPL | Stock | 6.3143 | 6.3214 | 6.3143 | 6.3214 | 145600.0 |
| 2008-07-10 07:50:00 | AAPL | Stock | 6.3143 | 6.3143 | 6.3057 | 6.3143 | 58800.0 |
| 2008-07-10 07:55:00 | AAPL | Stock | 6.3204 | 6.3207 | 6.3086 | 6.3086 | 229600.0 |
| 2008-07-10 08:00:00 | AAPL | Stock | 6.3086 | 6.32 | 6.3068 | 6.3146 | 422016.0 |
| 2008-07-10 08:05:00 | AAPL | Stock | 6.3193 | 6.3239 | 6.3168 | 6.3196 | 445480.0 |
| 2008-07-10 08:10:00 | AAPL | Stock | 6.3196 | 6.3196 | 6.3018 | 6.3036 | 494116.0 |
| 2008-07-10 08:15:00 | AAPL | Stock | 6.3039 | 6.3071 | 6.2929 | 6.2932 | 208516.0 |
| 2008-07-10 08:20:00 | AAPL | Stock | 6.2929 | 6.295 | 6.28 | 6.2857 | 347060.0 |
| 2008-07-10 08:25:00 | AAPL | Stock | 6.2857 | 6.3036 | 6.2857 | 6.2989 | 266756.0 |
| 2008-07-10 08:30:00 | AAPL | Stock | 6.3025 | 6.3182 | 6.2914 | 6.2914 | 840448.0 |
| 2008-07-10 08:35:00 | AAPL | Stock | 6.2964 | 6.3029 | 6.2929 | 6.2961 | 182280.0 |
| 2008-07-10 08:40:00 | AAPL | Stock | 6.2946 | 6.2946 | 6.2729 | 6.28 | 506380.0 |
| 2008-07-10 08:45:00 | AAPL | Stock | 6.2868 | 6.2875 | 6.2739 | 6.2739 | 181636.0 |
| 2008-07-10 08:50:00 | AAPL | Stock | 6.2761 | 6.2786 | 6.2539 | 6.2607 | 432376.0 |
| 2008-07-10 08:55:00 | AAPL | Stock | 6.2646 | 6.2679 | 6.26 | 6.2629 | 566580.0 |
| 2008-07-10 09:00:00 | AAPL | Stock | 6.2671 | 6.2696 | 6.2261 | 6.2357 | 1734236.0 |
| 2008-07-10 09:05:00 | AAPL | Stock | 6.2404 | 6.25 | 6.2339 | 6.25 | 1306368.0 |
| 2008-07-10 09:10:00 | AAPL | Stock | 6.2496 | 6.2496 | 6.2346 | 6.2375 | 257264.0 |
| 2008-07-10 09:15:00 | AAPL | Stock | 6.2375 | 6.2464 | 6.2375 | 6.2464 | 177800.0 |
| 2008-07-10 09:20:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2379 | 6.2386 | 167580.0 |
| 2008-07-10 09:25:00 | AAPL | Stock | 6.2382 | 6.2471 | 6.2321 | 6.2471 | 536116.0 |
| 2008-07-10 09:30:00 | AAPL | Stock | 6.2464 | 6.313 | 6.2432 | 6.2986 | 22528996.0 |
| 2008-07-10 09:35:00 | AAPL | Stock | 6.2986 | 6.3161 | 6.2714 | 6.2721 | 20317836.0 |
| 2008-07-10 09:40:00 | AAPL | Stock | 6.2718 | 6.3139 | 6.2536 | 6.3 | 22684172.0 |
| 2008-07-10 09:45:00 | AAPL | Stock | 6.2993 | 6.3214 | 6.2796 | 6.3146 | 19351724.0 |
| 2008-07-10 09:50:00 | AAPL | Stock | 6.3146 | 6.3179 | 6.2896 | 6.2921 | 13269508.0 |
| 2008-07-10 09:55:00 | AAPL | Stock | 6.2914 | 6.2961 | 6.2654 | 6.2761 | 14951496.0 |
| 2008-07-10 10:00:00 | AAPL | Stock | 6.2771 | 6.3011 | 6.26 | 6.275 | 12828228.0 |
| 2008-07-10 10:05:00 | AAPL | Stock | 6.2746 | 6.275 | 6.2386 | 6.2461 | 16987124.0 |
| 2008-07-10 10:10:00 | AAPL | Stock | 6.2461 | 6.2761 | 6.2454 | 6.2489 | 10592932.0 |
| 2008-07-10 10:15:00 | AAPL | Stock | 6.2486 | 6.2536 | 6.2057 | 6.2246 | 16899232.0 |
| 2008-07-10 10:20:00 | AAPL | Stock | 6.2243 | 6.2461 | 6.2093 | 6.2266 | 14955556.0 |
| 2008-07-10 10:25:00 | AAPL | Stock | 6.2264 | 6.2904 | 6.2157 | 6.2857 | 13872740.0 |
| 2008-07-10 10:30:00 | AAPL | Stock | 6.2836 | 6.3007 | 6.2746 | 6.2783 | 14172872.0 |
| 2008-07-10 10:35:00 | AAPL | Stock | 6.2768 | 6.278 | 6.2507 | 6.2725 | 9975728.0 |
| 2008-07-10 10:40:00 | AAPL | Stock | 6.2743 | 6.3139 | 6.2625 | 6.3114 | 12541928.0 |
| 2008-07-10 10:45:00 | AAPL | Stock | 6.3129 | 6.3279 | 6.3014 | 6.3079 | 14470932.0 |
| 2008-07-10 10:50:00 | AAPL | Stock | 6.3079 | 6.3125 | 6.2929 | 6.2946 | 7040236.0 |
| 2008-07-10 10:55:00 | AAPL | Stock | 6.2957 | 6.3146 | 6.2889 | 6.2968 | 7458612.0 |
> showing 50 of 319,532 rows — these rows as CSV