PREVIEW / stock_5min / 2008-07-14
file: by_date/stock_5min/2008/2008-07-14.parquet size: 4.5 MB rows: 320,918 symbols: 3,354
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-14 06:15:00 | AAPL | Stock | 6.225 | 6.225 | 6.225 | 6.225 | 2800.0 |
| 2008-07-14 06:40:00 | AAPL | Stock | 6.2246 | 6.225 | 6.2246 | 6.225 | 25200.0 |
| 2008-07-14 07:00:00 | AAPL | Stock | 6.2636 | 6.2639 | 6.2636 | 6.2636 | 36400.0 |
| 2008-07-14 07:05:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2443 | 6.2443 | 16800.0 |
| 2008-07-14 07:10:00 | AAPL | Stock | 6.2604 | 6.2639 | 6.2604 | 6.2607 | 128660.0 |
| 2008-07-14 07:15:00 | AAPL | Stock | 6.2639 | 6.2768 | 6.2639 | 6.2768 | 78540.0 |
| 2008-07-14 07:20:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2696 | 6.2714 | 22400.0 |
| 2008-07-14 07:25:00 | AAPL | Stock | 6.2854 | 6.2964 | 6.27 | 6.2964 | 186200.0 |
| 2008-07-14 07:30:00 | AAPL | Stock | 6.2961 | 6.3007 | 6.2961 | 6.2964 | 33600.0 |
| 2008-07-14 07:35:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2964 | 6.2964 | 28000.0 |
| 2008-07-14 07:40:00 | AAPL | Stock | 6.2964 | 6.3014 | 6.2857 | 6.2896 | 84000.0 |
| 2008-07-14 07:45:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 56000.0 |
| 2008-07-14 07:50:00 | AAPL | Stock | 6.2854 | 6.2854 | 6.2854 | 6.2854 | 8400.0 |
| 2008-07-14 07:55:00 | AAPL | Stock | 6.285 | 6.285 | 6.2718 | 6.2718 | 106400.0 |
| 2008-07-14 08:00:00 | AAPL | Stock | 6.275 | 6.2786 | 6.25 | 6.2643 | 544824.0 |
| 2008-07-14 08:05:00 | AAPL | Stock | 6.2654 | 6.2654 | 6.2511 | 6.2514 | 210504.0 |
| 2008-07-14 08:10:00 | AAPL | Stock | 6.2514 | 6.2621 | 6.2511 | 6.2539 | 262276.0 |
| 2008-07-14 08:15:00 | AAPL | Stock | 6.2518 | 6.2589 | 6.2518 | 6.2589 | 84000.0 |
| 2008-07-14 08:20:00 | AAPL | Stock | 6.2564 | 6.2589 | 6.2536 | 6.2571 | 117404.0 |
| 2008-07-14 08:25:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2539 | 6.2557 | 78036.0 |
| 2008-07-14 08:30:00 | AAPL | Stock | 6.2543 | 6.3143 | 6.2529 | 6.3125 | 3535056.0 |
| 2008-07-14 08:35:00 | AAPL | Stock | 6.3125 | 6.4018 | 6.3093 | 6.3964 | 5191032.0 |
| 2008-07-14 08:40:00 | AAPL | Stock | 6.395 | 6.4414 | 6.395 | 6.415 | 5685680.0 |
| 2008-07-14 08:45:00 | AAPL | Stock | 6.4136 | 6.4321 | 6.4018 | 6.4143 | 2051196.0 |
| 2008-07-14 08:50:00 | AAPL | Stock | 6.4146 | 6.4264 | 6.4107 | 6.4239 | 826336.0 |
| 2008-07-14 08:55:00 | AAPL | Stock | 6.4246 | 6.4364 | 6.4157 | 6.4357 | 1995756.0 |
| 2008-07-14 09:00:00 | AAPL | Stock | 6.4286 | 6.4546 | 6.4286 | 6.4454 | 3186484.0 |
| 2008-07-14 09:05:00 | AAPL | Stock | 6.4461 | 6.4507 | 6.4282 | 6.4371 | 1536780.0 |
| 2008-07-14 09:10:00 | AAPL | Stock | 6.4339 | 6.4361 | 6.4071 | 6.4089 | 1171324.0 |
| 2008-07-14 09:15:00 | AAPL | Stock | 6.4107 | 6.4207 | 6.4107 | 6.4136 | 336588.0 |
| 2008-07-14 09:20:00 | AAPL | Stock | 6.4136 | 6.4175 | 6.4018 | 6.4089 | 859348.0 |
| 2008-07-14 09:25:00 | AAPL | Stock | 6.4061 | 6.4107 | 6.3954 | 6.4029 | 1133720.0 |
| 2008-07-14 09:30:00 | AAPL | Stock | 6.4032 | 6.4036 | 6.3232 | 6.355 | 42501900.0 |
| 2008-07-14 09:35:00 | AAPL | Stock | 6.3556 | 6.3661 | 6.3254 | 6.3296 | 26608848.0 |
| 2008-07-14 09:40:00 | AAPL | Stock | 6.3371 | 6.3589 | 6.3111 | 6.3268 | 21535668.0 |
| 2008-07-14 09:45:00 | AAPL | Stock | 6.3257 | 6.3571 | 6.325 | 6.3396 | 19128872.0 |
| 2008-07-14 09:50:00 | AAPL | Stock | 6.3393 | 6.3475 | 6.2896 | 6.3146 | 23176048.0 |
| 2008-07-14 09:55:00 | AAPL | Stock | 6.3155 | 6.3214 | 6.3032 | 6.3036 | 12727428.0 |
| 2008-07-14 10:00:00 | AAPL | Stock | 6.3036 | 6.3061 | 6.2682 | 6.2836 | 20832560.0 |
| 2008-07-14 10:05:00 | AAPL | Stock | 6.285 | 6.3421 | 6.2807 | 6.3354 | 23121756.0 |
| 2008-07-14 10:10:00 | AAPL | Stock | 6.3346 | 6.335 | 6.3029 | 6.3318 | 13375236.0 |
| 2008-07-14 10:15:00 | AAPL | Stock | 6.3321 | 6.3532 | 6.3218 | 6.3371 | 14787948.0 |
| 2008-07-14 10:20:00 | AAPL | Stock | 6.3379 | 6.3536 | 6.3089 | 6.3089 | 13441596.0 |
| 2008-07-14 10:25:00 | AAPL | Stock | 6.3089 | 6.3114 | 6.2554 | 6.2693 | 20118028.0 |
| 2008-07-14 10:30:00 | AAPL | Stock | 6.2693 | 6.3196 | 6.2679 | 6.2857 | 15022784.0 |
| 2008-07-14 10:35:00 | AAPL | Stock | 6.2857 | 6.3143 | 6.2854 | 6.3029 | 12403776.0 |
| 2008-07-14 10:40:00 | AAPL | Stock | 6.3021 | 6.3107 | 6.2879 | 6.2986 | 10102316.0 |
| 2008-07-14 10:45:00 | AAPL | Stock | 6.2989 | 6.3075 | 6.2775 | 6.3039 | 9814616.0 |
| 2008-07-14 10:50:00 | AAPL | Stock | 6.3029 | 6.3196 | 6.2971 | 6.3179 | 10525704.0 |
| 2008-07-14 10:55:00 | AAPL | Stock | 6.3175 | 6.3482 | 6.3171 | 6.3307 | 11139240.0 |
> showing 50 of 320,918 rows — these rows as CSV