PREVIEW / stock_5min / 2008-06-25
file: by_date/stock_5min/2008/2008-06-25.parquet size: 4.5 MB rows: 316,902 symbols: 3,347
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-06-25 07:50:00 | AAPL | Stock | 6.2318 | 6.2318 | 6.2318 | 6.2318 | 2800.0 |
| 2008-06-25 07:55:00 | AAPL | Stock | 6.2389 | 6.2396 | 6.2389 | 6.2396 | 40600.0 |
| 2008-06-25 08:00:00 | AAPL | Stock | 6.2396 | 6.24 | 6.22 | 6.2318 | 304388.0 |
| 2008-06-25 08:05:00 | AAPL | Stock | 6.2304 | 6.2318 | 6.225 | 6.225 | 99960.0 |
| 2008-06-25 08:10:00 | AAPL | Stock | 6.225 | 6.2268 | 6.2207 | 6.2229 | 223608.0 |
| 2008-06-25 08:15:00 | AAPL | Stock | 6.2229 | 6.2268 | 6.2229 | 6.2268 | 19600.0 |
| 2008-06-25 08:20:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2257 | 6.2271 | 23800.0 |
| 2008-06-25 08:25:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2214 | 6.2214 | 155428.0 |
| 2008-06-25 08:30:00 | AAPL | Stock | 6.2218 | 6.2268 | 6.2214 | 6.2268 | 291816.0 |
| 2008-06-25 08:35:00 | AAPL | Stock | 6.2264 | 6.2404 | 6.225 | 6.2396 | 189252.0 |
| 2008-06-25 08:40:00 | AAPL | Stock | 6.2389 | 6.2404 | 6.2343 | 6.2396 | 320404.0 |
| 2008-06-25 08:45:00 | AAPL | Stock | 6.2396 | 6.2461 | 6.2396 | 6.2429 | 278460.0 |
| 2008-06-25 08:50:00 | AAPL | Stock | 6.2414 | 6.2457 | 6.2375 | 6.2429 | 81760.0 |
| 2008-06-25 08:55:00 | AAPL | Stock | 6.2429 | 6.2432 | 6.235 | 6.2354 | 108444.0 |
| 2008-06-25 09:00:00 | AAPL | Stock | 6.2386 | 6.2425 | 6.2354 | 6.2354 | 82292.0 |
| 2008-06-25 09:05:00 | AAPL | Stock | 6.2321 | 6.2421 | 6.2304 | 6.2421 | 210588.0 |
| 2008-06-25 09:10:00 | AAPL | Stock | 6.2425 | 6.2432 | 6.2361 | 6.2364 | 324828.0 |
| 2008-06-25 09:15:00 | AAPL | Stock | 6.2364 | 6.2468 | 6.235 | 6.2468 | 64400.0 |
| 2008-06-25 09:20:00 | AAPL | Stock | 6.2386 | 6.24 | 6.2386 | 6.24 | 22400.0 |
| 2008-06-25 09:25:00 | AAPL | Stock | 6.2357 | 6.2411 | 6.2296 | 6.2321 | 491736.0 |
| 2008-06-25 09:30:00 | AAPL | Stock | 6.2332 | 6.2839 | 6.2321 | 6.2714 | 19732916.0 |
| 2008-06-25 09:35:00 | AAPL | Stock | 6.2721 | 6.2761 | 6.21 | 6.2325 | 18729340.0 |
| 2008-06-25 09:40:00 | AAPL | Stock | 6.2336 | 6.2557 | 6.2318 | 6.2532 | 10210648.0 |
| 2008-06-25 09:45:00 | AAPL | Stock | 6.2529 | 6.2664 | 6.2482 | 6.2543 | 9269904.0 |
| 2008-06-25 09:50:00 | AAPL | Stock | 6.2543 | 6.2679 | 6.2482 | 6.2632 | 8015140.0 |
| 2008-06-25 09:55:00 | AAPL | Stock | 6.2639 | 6.2654 | 6.2482 | 6.2607 | 7347480.0 |
| 2008-06-25 10:00:00 | AAPL | Stock | 6.2604 | 6.27 | 6.2514 | 6.2696 | 10051944.0 |
| 2008-06-25 10:05:00 | AAPL | Stock | 6.2693 | 6.27 | 6.2389 | 6.2457 | 10917900.0 |
| 2008-06-25 10:10:00 | AAPL | Stock | 6.2464 | 6.2493 | 6.2336 | 6.2382 | 8628760.0 |
| 2008-06-25 10:15:00 | AAPL | Stock | 6.2389 | 6.2518 | 6.2364 | 6.2457 | 4654972.0 |
| 2008-06-25 10:20:00 | AAPL | Stock | 6.2461 | 6.2536 | 6.2364 | 6.2507 | 4758712.0 |
| 2008-06-25 10:25:00 | AAPL | Stock | 6.2518 | 6.2546 | 6.2411 | 6.2446 | 3887940.0 |
| 2008-06-25 10:30:00 | AAPL | Stock | 6.2436 | 6.2668 | 6.2414 | 6.2639 | 7975044.0 |
| 2008-06-25 10:35:00 | AAPL | Stock | 6.2636 | 6.2793 | 6.2636 | 6.2714 | 10194324.0 |
| 2008-06-25 10:40:00 | AAPL | Stock | 6.2714 | 6.2779 | 6.2689 | 6.2761 | 6274688.0 |
| 2008-06-25 10:45:00 | AAPL | Stock | 6.2761 | 6.2968 | 6.2679 | 6.2968 | 9775808.0 |
| 2008-06-25 10:50:00 | AAPL | Stock | 6.2971 | 6.3175 | 6.2933 | 6.3121 | 12442752.0 |
| 2008-06-25 10:55:00 | AAPL | Stock | 6.3121 | 6.3125 | 6.2925 | 6.2989 | 7858872.0 |
| 2008-06-25 11:00:00 | AAPL | Stock | 6.2989 | 6.3014 | 6.2882 | 6.2944 | 5057192.0 |
| 2008-06-25 11:05:00 | AAPL | Stock | 6.2946 | 6.3093 | 6.2921 | 6.2999 | 4399276.0 |
| 2008-06-25 11:10:00 | AAPL | Stock | 6.2994 | 6.3014 | 6.2925 | 6.2946 | 3989272.0 |
| 2008-06-25 11:15:00 | AAPL | Stock | 6.2946 | 6.3036 | 6.2929 | 6.3007 | 4660236.0 |
| 2008-06-25 11:20:00 | AAPL | Stock | 6.2996 | 6.315 | 6.2996 | 6.3093 | 5749212.0 |
| 2008-06-25 11:25:00 | AAPL | Stock | 6.3092 | 6.3111 | 6.3007 | 6.3043 | 4231416.0 |
| 2008-06-25 11:30:00 | AAPL | Stock | 6.3046 | 6.3071 | 6.2986 | 6.3046 | 2961112.0 |
| 2008-06-25 11:35:00 | AAPL | Stock | 6.3046 | 6.3054 | 6.2918 | 6.2925 | 4110120.0 |
| 2008-06-25 11:40:00 | AAPL | Stock | 6.2925 | 6.2957 | 6.2836 | 6.2925 | 5668796.0 |
| 2008-06-25 11:45:00 | AAPL | Stock | 6.2925 | 6.2975 | 6.2846 | 6.2893 | 3675112.0 |
| 2008-06-25 11:50:00 | AAPL | Stock | 6.2893 | 6.2946 | 6.2843 | 6.2932 | 2552676.0 |
| 2008-06-25 11:55:00 | AAPL | Stock | 6.2943 | 6.3061 | 6.2936 | 6.3018 | 4421424.0 |
> showing 50 of 316,902 rows — these rows as CSV