PREVIEW / stock_5min / 2007-06-26
file: by_date/stock_5min/2007/2007-06-26.parquet size: 4.1 MB rows: 299,339 symbols: 3,036
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-26 09:30:00 | AAPL | Stock | 4.4279 | 4.4286 | 4.4125 | 4.4196 | 47357884.0 |
| 2007-06-26 09:35:00 | AAPL | Stock | 4.4196 | 4.4279 | 4.4071 | 4.426 | 26828032.0 |
| 2007-06-26 09:40:00 | AAPL | Stock | 4.4257 | 4.4275 | 4.3814 | 4.3957 | 30261252.0 |
| 2007-06-26 09:45:00 | AAPL | Stock | 4.3968 | 4.4068 | 4.3918 | 4.4046 | 18833836.0 |
| 2007-06-26 09:50:00 | AAPL | Stock | 4.4043 | 4.4068 | 4.3971 | 4.3993 | 10680320.0 |
| 2007-06-26 09:55:00 | AAPL | Stock | 4.3986 | 4.4036 | 4.3839 | 4.3907 | 18020772.0 |
| 2007-06-26 10:00:00 | AAPL | Stock | 4.3904 | 4.3925 | 4.365 | 4.3679 | 31352272.0 |
| 2007-06-26 10:05:00 | AAPL | Stock | 4.3675 | 4.3736 | 4.3525 | 4.3618 | 27013168.0 |
| 2007-06-26 10:10:00 | AAPL | Stock | 4.3621 | 4.3632 | 4.3421 | 4.3554 | 24458308.0 |
| 2007-06-26 10:15:00 | AAPL | Stock | 4.3564 | 4.3711 | 4.3482 | 4.3504 | 20048112.0 |
| 2007-06-26 10:20:00 | AAPL | Stock | 4.3504 | 4.3557 | 4.3286 | 4.3346 | 31863468.0 |
| 2007-06-26 10:25:00 | AAPL | Stock | 4.3343 | 4.3343 | 4.3057 | 4.3211 | 38922072.0 |
| 2007-06-26 10:30:00 | AAPL | Stock | 4.3211 | 4.33 | 4.3157 | 4.3264 | 17646216.0 |
| 2007-06-26 10:35:00 | AAPL | Stock | 4.3261 | 4.3532 | 4.3225 | 4.35 | 23499896.0 |
| 2007-06-26 10:40:00 | AAPL | Stock | 4.3496 | 4.3514 | 4.3329 | 4.3329 | 13832644.0 |
| 2007-06-26 10:45:00 | AAPL | Stock | 4.3329 | 4.3464 | 4.3325 | 4.3439 | 11851420.0 |
| 2007-06-26 10:50:00 | AAPL | Stock | 4.3429 | 4.3482 | 4.3329 | 4.3375 | 11575508.0 |
| 2007-06-26 10:55:00 | AAPL | Stock | 4.3379 | 4.3414 | 4.3218 | 4.3229 | 11325244.0 |
| 2007-06-26 11:00:00 | AAPL | Stock | 4.3225 | 4.3275 | 4.3125 | 4.3239 | 15686860.0 |
| 2007-06-26 11:05:00 | AAPL | Stock | 4.3239 | 4.325 | 4.3046 | 4.3071 | 15616468.0 |
| 2007-06-26 11:10:00 | AAPL | Stock | 4.3071 | 4.3196 | 4.3057 | 4.3175 | 14947828.0 |
| 2007-06-26 11:15:00 | AAPL | Stock | 4.3179 | 4.3279 | 4.3129 | 4.3136 | 14920192.0 |
| 2007-06-26 11:20:00 | AAPL | Stock | 4.3136 | 4.3146 | 4.2939 | 4.2957 | 24705268.0 |
| 2007-06-26 11:25:00 | AAPL | Stock | 4.2957 | 4.2964 | 4.2504 | 4.2639 | 61192936.0 |
| 2007-06-26 11:30:00 | AAPL | Stock | 4.2639 | 4.2875 | 4.2589 | 4.2857 | 31890852.0 |
| 2007-06-26 11:35:00 | AAPL | Stock | 4.2854 | 4.2957 | 4.2821 | 4.2843 | 18219656.0 |
| 2007-06-26 11:40:00 | AAPL | Stock | 4.2843 | 4.2886 | 4.2746 | 4.2839 | 20048980.0 |
| 2007-06-26 11:45:00 | AAPL | Stock | 4.2832 | 4.2946 | 4.2786 | 4.2811 | 15859032.0 |
| 2007-06-26 11:50:00 | AAPL | Stock | 4.2821 | 4.2836 | 4.265 | 4.2685 | 16671144.0 |
| 2007-06-26 11:55:00 | AAPL | Stock | 4.2679 | 4.2786 | 4.2668 | 4.275 | 12803028.0 |
| 2007-06-26 12:00:00 | AAPL | Stock | 4.275 | 4.2836 | 4.2732 | 4.2743 | 14286216.0 |
| 2007-06-26 12:05:00 | AAPL | Stock | 4.2743 | 4.2793 | 4.2696 | 4.27 | 9533692.0 |
| 2007-06-26 12:10:00 | AAPL | Stock | 4.2707 | 4.2714 | 4.2525 | 4.2589 | 18598664.0 |
| 2007-06-26 12:15:00 | AAPL | Stock | 4.2586 | 4.2782 | 4.2586 | 4.2725 | 10366384.0 |
| 2007-06-26 12:20:00 | AAPL | Stock | 4.2732 | 4.2804 | 4.2668 | 4.2714 | 9534000.0 |
| 2007-06-26 12:25:00 | AAPL | Stock | 4.2714 | 4.2904 | 4.2714 | 4.2846 | 12981276.0 |
| 2007-06-26 12:30:00 | AAPL | Stock | 4.2846 | 4.2882 | 4.2736 | 4.2761 | 9392488.0 |
| 2007-06-26 12:35:00 | AAPL | Stock | 4.2761 | 4.2786 | 4.2696 | 4.2775 | 7875000.0 |
| 2007-06-26 12:40:00 | AAPL | Stock | 4.2782 | 4.2782 | 4.2707 | 4.2757 | 5659836.0 |
| 2007-06-26 12:45:00 | AAPL | Stock | 4.2757 | 4.2757 | 4.2629 | 4.2682 | 10483396.0 |
| 2007-06-26 12:50:00 | AAPL | Stock | 4.2682 | 4.275 | 4.2593 | 4.2746 | 17478384.0 |
| 2007-06-26 12:55:00 | AAPL | Stock | 4.2746 | 4.2804 | 4.2679 | 4.2764 | 9284800.0 |
| 2007-06-26 13:00:00 | AAPL | Stock | 4.2761 | 4.2882 | 4.2754 | 4.2875 | 15465156.0 |
| 2007-06-26 13:05:00 | AAPL | Stock | 4.2875 | 4.2993 | 4.2857 | 4.2968 | 13098680.0 |
| 2007-06-26 13:10:00 | AAPL | Stock | 4.2968 | 4.3064 | 4.2968 | 4.3014 | 19082672.0 |
| 2007-06-26 13:15:00 | AAPL | Stock | 4.3014 | 4.3161 | 4.2986 | 4.3086 | 14827400.0 |
| 2007-06-26 13:20:00 | AAPL | Stock | 4.3086 | 4.3089 | 4.2929 | 4.3029 | 11385136.0 |
| 2007-06-26 13:25:00 | AAPL | Stock | 4.3036 | 4.3039 | 4.295 | 4.2968 | 6107332.0 |
| 2007-06-26 13:30:00 | AAPL | Stock | 4.2979 | 4.3021 | 4.2796 | 4.2843 | 12269544.0 |
| 2007-06-26 13:35:00 | AAPL | Stock | 4.2843 | 4.2893 | 4.2821 | 4.2875 | 7765268.0 |
> showing 50 of 299,339 rows — these rows as CSV