PREVIEW / stock_5min / 2005-06-10
file: by_date/stock_5min/2005/2005-06-10.parquet size: 2.6 MB rows: 188,531 symbols: 1,987
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-10 07:20:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3393 | 1.3393 | 81200.0 |
| 2005-06-10 07:30:00 | AAPL | Stock | 1.3429 | 1.3429 | 1.3429 | 1.3429 | 27244.0 |
| 2005-06-10 07:55:00 | AAPL | Stock | 1.3464 | 1.3536 | 1.3464 | 1.35 | 417200.0 |
| 2005-06-10 08:00:00 | AAPL | Stock | 1.3482 | 1.3543 | 1.3429 | 1.3429 | 1974672.0 |
| 2005-06-10 08:05:00 | AAPL | Stock | 1.3429 | 1.3464 | 1.3429 | 1.345 | 342328.0 |
| 2005-06-10 08:10:00 | AAPL | Stock | 1.3471 | 1.3471 | 1.3461 | 1.3464 | 244104.0 |
| 2005-06-10 08:15:00 | AAPL | Stock | 1.3457 | 1.3461 | 1.3454 | 1.3461 | 58800.0 |
| 2005-06-10 08:20:00 | AAPL | Stock | 1.3457 | 1.3457 | 1.3446 | 1.3446 | 51828.0 |
| 2005-06-10 08:30:00 | AAPL | Stock | 1.3446 | 1.3446 | 1.3446 | 1.3446 | 14000.0 |
| 2005-06-10 08:35:00 | AAPL | Stock | 1.345 | 1.345 | 1.345 | 1.345 | 19600.0 |
| 2005-06-10 08:45:00 | AAPL | Stock | 1.345 | 1.345 | 1.345 | 1.345 | 2800.0 |
| 2005-06-10 08:50:00 | AAPL | Stock | 1.345 | 1.345 | 1.345 | 1.345 | 28000.0 |
| 2005-06-10 08:55:00 | AAPL | Stock | 1.345 | 1.345 | 1.3446 | 1.3446 | 50400.0 |
| 2005-06-10 09:05:00 | AAPL | Stock | 1.3439 | 1.3439 | 1.3439 | 1.3439 | 14000.0 |
| 2005-06-10 09:10:00 | AAPL | Stock | 1.3439 | 1.3439 | 1.3432 | 1.3432 | 25200.0 |
| 2005-06-10 09:15:00 | AAPL | Stock | 1.3439 | 1.3446 | 1.3414 | 1.3414 | 36400.0 |
| 2005-06-10 09:20:00 | AAPL | Stock | 1.34 | 1.3462 | 1.3396 | 1.3404 | 235200.0 |
| 2005-06-10 09:25:00 | AAPL | Stock | 1.3404 | 1.3404 | 1.3321 | 1.3329 | 1184764.0 |
| 2005-06-10 09:30:00 | AAPL | Stock | 1.3357 | 1.3357 | 1.3018 | 1.3025 | 32395356.0 |
| 2005-06-10 09:35:00 | AAPL | Stock | 1.3025 | 1.3179 | 1.3007 | 1.31 | 25700080.0 |
| 2005-06-10 09:40:00 | AAPL | Stock | 1.31 | 1.3214 | 1.3086 | 1.3104 | 16840124.0 |
| 2005-06-10 09:45:00 | AAPL | Stock | 1.3104 | 1.3143 | 1.3104 | 1.3121 | 13006476.0 |
| 2005-06-10 09:50:00 | AAPL | Stock | 1.3125 | 1.3125 | 1.3071 | 1.3075 | 10848404.0 |
| 2005-06-10 09:55:00 | AAPL | Stock | 1.3079 | 1.3107 | 1.3039 | 1.305 | 15993376.0 |
| 2005-06-10 10:00:00 | AAPL | Stock | 1.305 | 1.3071 | 1.3036 | 1.3054 | 9267468.0 |
| 2005-06-10 10:05:00 | AAPL | Stock | 1.3054 | 1.3064 | 1.3021 | 1.3039 | 9801960.0 |
| 2005-06-10 10:10:00 | AAPL | Stock | 1.3039 | 1.3107 | 1.3014 | 1.3021 | 11913300.0 |
| 2005-06-10 10:15:00 | AAPL | Stock | 1.3021 | 1.3093 | 1.3018 | 1.3057 | 10316656.0 |
| 2005-06-10 10:20:00 | AAPL | Stock | 1.3057 | 1.3057 | 1.3007 | 1.3029 | 12140968.0 |
| 2005-06-10 10:25:00 | AAPL | Stock | 1.3029 | 1.3029 | 1.2957 | 1.3004 | 14033292.0 |
| 2005-06-10 10:30:00 | AAPL | Stock | 1.3 | 1.3021 | 1.2986 | 1.3 | 11201260.0 |
| 2005-06-10 10:35:00 | AAPL | Stock | 1.3 | 1.3007 | 1.2982 | 1.2993 | 7377104.0 |
| 2005-06-10 10:40:00 | AAPL | Stock | 1.2996 | 1.3036 | 1.295 | 1.2961 | 10586016.0 |
| 2005-06-10 10:45:00 | AAPL | Stock | 1.2961 | 1.2989 | 1.2954 | 1.2986 | 6245176.0 |
| 2005-06-10 10:50:00 | AAPL | Stock | 1.2986 | 1.3071 | 1.2975 | 1.3029 | 8589280.0 |
| 2005-06-10 10:55:00 | AAPL | Stock | 1.3029 | 1.3043 | 1.3011 | 1.3021 | 4307016.0 |
| 2005-06-10 11:00:00 | AAPL | Stock | 1.3021 | 1.3043 | 1.3007 | 1.3011 | 4207644.0 |
| 2005-06-10 11:05:00 | AAPL | Stock | 1.3007 | 1.3029 | 1.3007 | 1.3018 | 2202732.0 |
| 2005-06-10 11:10:00 | AAPL | Stock | 1.3014 | 1.3029 | 1.3014 | 1.3025 | 1574076.0 |
| 2005-06-10 11:15:00 | AAPL | Stock | 1.3029 | 1.3036 | 1.3018 | 1.3018 | 2798124.0 |
| 2005-06-10 11:20:00 | AAPL | Stock | 1.3018 | 1.3025 | 1.2968 | 1.2975 | 7890876.0 |
| 2005-06-10 11:25:00 | AAPL | Stock | 1.2971 | 1.3014 | 1.2971 | 1.2975 | 6452376.0 |
| 2005-06-10 11:30:00 | AAPL | Stock | 1.2971 | 1.2971 | 1.2929 | 1.2932 | 6912584.0 |
| 2005-06-10 11:35:00 | AAPL | Stock | 1.2932 | 1.2971 | 1.2932 | 1.2968 | 6349056.0 |
| 2005-06-10 11:40:00 | AAPL | Stock | 1.2968 | 1.2993 | 1.2964 | 1.2968 | 3566444.0 |
| 2005-06-10 11:45:00 | AAPL | Stock | 1.2968 | 1.2982 | 1.295 | 1.2954 | 2792608.0 |
| 2005-06-10 11:50:00 | AAPL | Stock | 1.2957 | 1.2975 | 1.2936 | 1.2943 | 4015424.0 |
| 2005-06-10 11:55:00 | AAPL | Stock | 1.2939 | 1.2939 | 1.2893 | 1.29 | 10318112.0 |
| 2005-06-10 12:00:00 | AAPL | Stock | 1.29 | 1.2907 | 1.2861 | 1.2864 | 10568264.0 |
| 2005-06-10 12:05:00 | AAPL | Stock | 1.2864 | 1.29 | 1.2861 | 1.2893 | 9730868.0 |
> showing 50 of 188,531 rows — these rows as CSV