PREVIEW / stock_1min / 2007-07-02
file: by_date/stock_1min/2007/2007-07-02.parquet size: 11.3 MB rows: 932,821 symbols: 2,488
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-07-02 09:30:00 | AAPL | Stock | 4.3232 | 4.3257 | 4.3107 | 4.32 | 30558304.0 |
| 2007-07-02 09:31:00 | AAPL | Stock | 4.3204 | 4.3393 | 4.3114 | 4.3393 | 10852856.0 |
| 2007-07-02 09:32:00 | AAPL | Stock | 4.3393 | 4.3471 | 4.3218 | 4.3364 | 10063116.0 |
| 2007-07-02 09:33:00 | AAPL | Stock | 4.3361 | 4.3392 | 4.3304 | 4.3336 | 6462120.0 |
| 2007-07-02 09:34:00 | AAPL | Stock | 4.3336 | 4.3343 | 4.3036 | 4.3041 | 12365808.0 |
| 2007-07-02 09:35:00 | AAPL | Stock | 4.3036 | 4.3111 | 4.3004 | 4.3014 | 10305036.0 |
| 2007-07-02 09:36:00 | AAPL | Stock | 4.3014 | 4.3354 | 4.2789 | 4.28 | 16296336.0 |
| 2007-07-02 09:37:00 | AAPL | Stock | 4.28 | 4.2857 | 4.2736 | 4.28 | 13935824.0 |
| 2007-07-02 09:38:00 | AAPL | Stock | 4.2804 | 4.2807 | 4.2607 | 4.2696 | 12345732.0 |
| 2007-07-02 09:39:00 | AAPL | Stock | 4.2704 | 4.2868 | 4.2621 | 4.2821 | 14329588.0 |
| 2007-07-02 09:40:00 | AAPL | Stock | 4.2821 | 4.3018 | 4.2811 | 4.2975 | 11207224.0 |
| 2007-07-02 09:41:00 | AAPL | Stock | 4.2975 | 4.2993 | 4.2832 | 4.2929 | 7424480.0 |
| 2007-07-02 09:42:00 | AAPL | Stock | 4.2932 | 4.3007 | 4.2893 | 4.2911 | 4723068.0 |
| 2007-07-02 09:43:00 | AAPL | Stock | 4.2907 | 4.2961 | 4.2875 | 4.2918 | 5053356.0 |
| 2007-07-02 09:44:00 | AAPL | Stock | 4.2918 | 4.2979 | 4.29 | 4.2921 | 5327812.0 |
| 2007-07-02 09:45:00 | AAPL | Stock | 4.2918 | 4.2929 | 4.2857 | 4.2868 | 4990972.0 |
| 2007-07-02 09:46:00 | AAPL | Stock | 4.2864 | 4.2904 | 4.285 | 4.2886 | 5636260.0 |
| 2007-07-02 09:47:00 | AAPL | Stock | 4.2886 | 4.3014 | 4.2864 | 4.2986 | 5533360.0 |
| 2007-07-02 09:48:00 | AAPL | Stock | 4.2986 | 4.3 | 4.2964 | 4.2982 | 4336444.0 |
| 2007-07-02 09:49:00 | AAPL | Stock | 4.2982 | 4.3143 | 4.2982 | 4.3143 | 9713928.0 |
| 2007-07-02 09:50:00 | AAPL | Stock | 4.3146 | 4.3214 | 4.3005 | 4.3214 | 8378692.0 |
| 2007-07-02 09:51:00 | AAPL | Stock | 4.3211 | 4.3218 | 4.3104 | 4.3204 | 7657384.0 |
| 2007-07-02 09:52:00 | AAPL | Stock | 4.3171 | 4.3196 | 4.3114 | 4.3139 | 3998680.0 |
| 2007-07-02 09:53:00 | AAPL | Stock | 4.3132 | 4.3536 | 4.3064 | 4.3104 | 9241260.0 |
| 2007-07-02 09:54:00 | AAPL | Stock | 4.31 | 4.3154 | 4.3093 | 4.3146 | 2952740.0 |
| 2007-07-02 09:55:00 | AAPL | Stock | 4.3143 | 4.315 | 4.3093 | 4.3117 | 3197908.0 |
| 2007-07-02 09:56:00 | AAPL | Stock | 4.3125 | 4.3261 | 4.31 | 4.3254 | 10156888.0 |
| 2007-07-02 09:57:00 | AAPL | Stock | 4.3261 | 4.3261 | 4.3154 | 4.3218 | 7878836.0 |
| 2007-07-02 09:58:00 | AAPL | Stock | 4.3221 | 4.3336 | 4.3214 | 4.3314 | 6980008.0 |
| 2007-07-02 09:59:00 | AAPL | Stock | 4.3314 | 4.3604 | 4.3264 | 4.3464 | 11108356.0 |
| 2007-07-02 10:00:00 | AAPL | Stock | 4.3464 | 4.3571 | 4.3454 | 4.3557 | 8280832.0 |
| 2007-07-02 10:01:00 | AAPL | Stock | 4.3561 | 4.3571 | 4.3429 | 4.3432 | 7380296.0 |
| 2007-07-02 10:02:00 | AAPL | Stock | 4.3436 | 4.3464 | 4.3411 | 4.3412 | 5693296.0 |
| 2007-07-02 10:03:00 | AAPL | Stock | 4.3418 | 4.3464 | 4.3339 | 4.3343 | 5476856.0 |
| 2007-07-02 10:04:00 | AAPL | Stock | 4.3339 | 4.3429 | 4.3239 | 4.3282 | 6020840.0 |
| 2007-07-02 10:05:00 | AAPL | Stock | 4.3282 | 4.3329 | 4.3225 | 4.325 | 5338508.0 |
| 2007-07-02 10:06:00 | AAPL | Stock | 4.3257 | 4.3482 | 4.3171 | 4.3186 | 4553584.0 |
| 2007-07-02 10:07:00 | AAPL | Stock | 4.3186 | 4.3232 | 4.3157 | 4.3232 | 4125996.0 |
| 2007-07-02 10:08:00 | AAPL | Stock | 4.3229 | 4.3268 | 4.3196 | 4.3257 | 3771824.0 |
| 2007-07-02 10:09:00 | AAPL | Stock | 4.3257 | 4.3275 | 4.3214 | 4.326 | 2747640.0 |
| 2007-07-02 10:10:00 | AAPL | Stock | 4.3261 | 4.3282 | 4.3139 | 4.3164 | 4356800.0 |
| 2007-07-02 10:11:00 | AAPL | Stock | 4.3182 | 4.3214 | 4.3132 | 4.3168 | 2549484.0 |
| 2007-07-02 10:12:00 | AAPL | Stock | 4.3175 | 4.3271 | 4.3171 | 4.3264 | 2615424.0 |
| 2007-07-02 10:13:00 | AAPL | Stock | 4.3257 | 4.3271 | 4.3218 | 4.3268 | 1570156.0 |
| 2007-07-02 10:14:00 | AAPL | Stock | 4.3275 | 4.3371 | 4.3268 | 4.3321 | 3504340.0 |
| 2007-07-02 10:15:00 | AAPL | Stock | 4.3321 | 4.3354 | 4.3261 | 4.3289 | 2391984.0 |
| 2007-07-02 10:16:00 | AAPL | Stock | 4.3289 | 4.3293 | 4.3204 | 4.3221 | 3298176.0 |
| 2007-07-02 10:17:00 | AAPL | Stock | 4.3221 | 4.3221 | 4.3179 | 4.3196 | 2679824.0 |
| 2007-07-02 10:18:00 | AAPL | Stock | 4.3196 | 4.3211 | 4.3036 | 4.3189 | 2118060.0 |
| 2007-07-02 10:19:00 | AAPL | Stock | 4.32 | 4.3211 | 4.3132 | 4.3189 | 2719136.0 |
> showing 50 of 932,821 rows — these rows as CSV