PREVIEW / stock_1min / 2007-08-17
file: by_date/stock_1min/2007/2007-08-17.parquet size: 12.9 MB rows: 1,046,352 symbols: 2,579
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-08-17 09:30:00 | AAPL | Stock | 4.3575 | 4.3743 | 4.3311 | 4.3571 | 60924108.0 |
| 2007-08-17 09:31:00 | AAPL | Stock | 4.3564 | 4.3821 | 4.35 | 4.3809 | 11274228.0 |
| 2007-08-17 09:32:00 | AAPL | Stock | 4.3814 | 4.3907 | 4.3743 | 4.3871 | 13349392.0 |
| 2007-08-17 09:33:00 | AAPL | Stock | 4.3871 | 4.39 | 4.3857 | 4.3868 | 7244104.0 |
| 2007-08-17 09:34:00 | AAPL | Stock | 4.3868 | 4.3929 | 4.3718 | 4.3814 | 9354072.0 |
| 2007-08-17 09:35:00 | AAPL | Stock | 4.3807 | 4.3821 | 4.35 | 4.3657 | 9546712.0 |
| 2007-08-17 09:36:00 | AAPL | Stock | 4.3654 | 4.3804 | 4.3586 | 4.375 | 6586412.0 |
| 2007-08-17 09:37:00 | AAPL | Stock | 4.3729 | 4.3789 | 4.3679 | 4.3754 | 5350828.0 |
| 2007-08-17 09:38:00 | AAPL | Stock | 4.3764 | 4.3843 | 4.3679 | 4.3836 | 5721380.0 |
| 2007-08-17 09:39:00 | AAPL | Stock | 4.3836 | 4.3929 | 4.3736 | 4.3925 | 5702844.0 |
| 2007-08-17 09:40:00 | AAPL | Stock | 4.3925 | 4.3964 | 4.3721 | 4.3764 | 7385448.0 |
| 2007-08-17 09:41:00 | AAPL | Stock | 4.3779 | 4.3793 | 4.3696 | 4.3732 | 4968264.0 |
| 2007-08-17 09:42:00 | AAPL | Stock | 4.3721 | 4.3775 | 4.3696 | 4.3729 | 3830428.0 |
| 2007-08-17 09:43:00 | AAPL | Stock | 4.3729 | 4.3759 | 4.3525 | 4.3568 | 8944012.0 |
| 2007-08-17 09:44:00 | AAPL | Stock | 4.3571 | 4.3668 | 4.3535 | 4.3634 | 4390344.0 |
| 2007-08-17 09:45:00 | AAPL | Stock | 4.3629 | 4.3637 | 4.3418 | 4.3436 | 7593012.0 |
| 2007-08-17 09:46:00 | AAPL | Stock | 4.3432 | 4.3432 | 4.3271 | 4.3271 | 5893244.0 |
| 2007-08-17 09:47:00 | AAPL | Stock | 4.3274 | 4.3414 | 4.3225 | 4.3268 | 7052360.0 |
| 2007-08-17 09:48:00 | AAPL | Stock | 4.3271 | 4.3311 | 4.3121 | 4.3232 | 6781152.0 |
| 2007-08-17 09:49:00 | AAPL | Stock | 4.3225 | 4.3368 | 4.3161 | 4.3304 | 5773684.0 |
| 2007-08-17 09:50:00 | AAPL | Stock | 4.3314 | 4.3339 | 4.3214 | 4.3229 | 4554424.0 |
| 2007-08-17 09:51:00 | AAPL | Stock | 4.3229 | 4.3339 | 4.3214 | 4.3339 | 4517100.0 |
| 2007-08-17 09:52:00 | AAPL | Stock | 4.3336 | 4.335 | 4.3279 | 4.3296 | 4362960.0 |
| 2007-08-17 09:53:00 | AAPL | Stock | 4.3296 | 4.3325 | 4.3118 | 4.3132 | 4697280.0 |
| 2007-08-17 09:54:00 | AAPL | Stock | 4.3132 | 4.3143 | 4.3032 | 4.3114 | 5639844.0 |
| 2007-08-17 09:55:00 | AAPL | Stock | 4.3096 | 4.3121 | 4.295 | 4.3021 | 4850608.0 |
| 2007-08-17 09:56:00 | AAPL | Stock | 4.3021 | 4.3032 | 4.2936 | 4.2996 | 5765620.0 |
| 2007-08-17 09:57:00 | AAPL | Stock | 4.2986 | 4.3154 | 4.2964 | 4.3111 | 5349792.0 |
| 2007-08-17 09:58:00 | AAPL | Stock | 4.3125 | 4.3257 | 4.3075 | 4.3132 | 4666872.0 |
| 2007-08-17 09:59:00 | AAPL | Stock | 4.3131 | 4.3196 | 4.3036 | 4.3068 | 3040912.0 |
| 2007-08-17 10:00:00 | AAPL | Stock | 4.3068 | 4.3121 | 4.2879 | 4.3068 | 5252072.0 |
| 2007-08-17 10:01:00 | AAPL | Stock | 4.3071 | 4.3093 | 4.2921 | 4.2964 | 3193064.0 |
| 2007-08-17 10:02:00 | AAPL | Stock | 4.2968 | 4.2968 | 4.2857 | 4.2871 | 4499908.0 |
| 2007-08-17 10:03:00 | AAPL | Stock | 4.2882 | 4.2961 | 4.2857 | 4.2929 | 3458896.0 |
| 2007-08-17 10:04:00 | AAPL | Stock | 4.2946 | 4.3111 | 4.2871 | 4.3093 | 2156308.0 |
| 2007-08-17 10:05:00 | AAPL | Stock | 4.3089 | 4.3293 | 4.3044 | 4.3264 | 4222988.0 |
| 2007-08-17 10:06:00 | AAPL | Stock | 4.3275 | 4.3336 | 4.3186 | 4.3336 | 3976476.0 |
| 2007-08-17 10:07:00 | AAPL | Stock | 4.3318 | 4.3389 | 4.3246 | 4.3345 | 5427352.0 |
| 2007-08-17 10:08:00 | AAPL | Stock | 4.3346 | 4.3371 | 4.3286 | 4.3293 | 3978464.0 |
| 2007-08-17 10:09:00 | AAPL | Stock | 4.3279 | 4.3389 | 4.32 | 4.3296 | 4781476.0 |
| 2007-08-17 10:10:00 | AAPL | Stock | 4.33 | 4.3311 | 4.3125 | 4.3189 | 3145212.0 |
| 2007-08-17 10:11:00 | AAPL | Stock | 4.3194 | 4.3304 | 4.3154 | 4.33 | 3461556.0 |
| 2007-08-17 10:12:00 | AAPL | Stock | 4.33 | 4.3343 | 4.3246 | 4.3307 | 4434080.0 |
| 2007-08-17 10:13:00 | AAPL | Stock | 4.3293 | 4.335 | 4.3196 | 4.3221 | 3155572.0 |
| 2007-08-17 10:14:00 | AAPL | Stock | 4.3225 | 4.3254 | 4.3168 | 4.3214 | 4770696.0 |
| 2007-08-17 10:15:00 | AAPL | Stock | 4.3214 | 4.3279 | 4.3193 | 4.3218 | 4722312.0 |
| 2007-08-17 10:16:00 | AAPL | Stock | 4.3223 | 4.3354 | 4.3214 | 4.3214 | 5231296.0 |
| 2007-08-17 10:17:00 | AAPL | Stock | 4.3214 | 4.3268 | 4.3164 | 4.32 | 4413556.0 |
| 2007-08-17 10:18:00 | AAPL | Stock | 4.3184 | 4.3214 | 4.3075 | 4.3081 | 5995724.0 |
| 2007-08-17 10:19:00 | AAPL | Stock | 4.3079 | 4.3132 | 4.3032 | 4.3104 | 4961208.0 |
> showing 50 of 1,046,352 rows — these rows as CSV