PREVIEW / stock_5min / 2006-08-09
file: by_date/stock_5min/2006/2006-08-09.parquet size: 3.2 MB rows: 227,580 symbols: 2,316
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-09 07:30:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 16800.0 |
| 2006-08-09 08:00:00 | AAPL | Stock | 2.3232 | 2.3429 | 2.3214 | 2.3336 | 281540.0 |
| 2006-08-09 08:05:00 | AAPL | Stock | 2.3339 | 2.3389 | 2.3339 | 2.3375 | 276388.0 |
| 2006-08-09 08:10:00 | AAPL | Stock | 2.3325 | 2.3371 | 2.3325 | 2.3339 | 72800.0 |
| 2006-08-09 08:15:00 | AAPL | Stock | 2.3339 | 2.3368 | 2.3307 | 2.3357 | 71344.0 |
| 2006-08-09 08:20:00 | AAPL | Stock | 2.3357 | 2.3357 | 2.3339 | 2.3357 | 170800.0 |
| 2006-08-09 08:25:00 | AAPL | Stock | 2.3354 | 2.3357 | 2.335 | 2.335 | 97440.0 |
| 2006-08-09 08:30:00 | AAPL | Stock | 2.335 | 2.3357 | 2.3339 | 2.3339 | 53508.0 |
| 2006-08-09 08:35:00 | AAPL | Stock | 2.3357 | 2.3357 | 2.3332 | 2.335 | 63000.0 |
| 2006-08-09 08:40:00 | AAPL | Stock | 2.3357 | 2.3357 | 2.3314 | 2.3314 | 208236.0 |
| 2006-08-09 08:45:00 | AAPL | Stock | 2.3339 | 2.3339 | 2.3304 | 2.3304 | 139160.0 |
| 2006-08-09 08:50:00 | AAPL | Stock | 2.3314 | 2.3339 | 2.3314 | 2.3339 | 347200.0 |
| 2006-08-09 08:55:00 | AAPL | Stock | 2.3339 | 2.3357 | 2.3321 | 2.3339 | 148400.0 |
| 2006-08-09 09:00:00 | AAPL | Stock | 2.3339 | 2.3357 | 2.3339 | 2.3357 | 633332.0 |
| 2006-08-09 09:05:00 | AAPL | Stock | 2.3357 | 2.3411 | 2.3357 | 2.3411 | 554988.0 |
| 2006-08-09 09:10:00 | AAPL | Stock | 2.3396 | 2.3432 | 2.3357 | 2.3393 | 489160.0 |
| 2006-08-09 09:15:00 | AAPL | Stock | 2.3393 | 2.3418 | 2.3375 | 2.3375 | 232120.0 |
| 2006-08-09 09:20:00 | AAPL | Stock | 2.3375 | 2.3375 | 2.3339 | 2.3339 | 74480.0 |
| 2006-08-09 09:25:00 | AAPL | Stock | 2.3354 | 2.3389 | 2.3321 | 2.3389 | 423164.0 |
| 2006-08-09 09:30:00 | AAPL | Stock | 2.3368 | 2.3429 | 2.3043 | 2.3043 | 29097712.0 |
| 2006-08-09 09:35:00 | AAPL | Stock | 2.3046 | 2.3161 | 2.2861 | 2.2896 | 35055328.0 |
| 2006-08-09 09:40:00 | AAPL | Stock | 2.2896 | 2.3304 | 2.2864 | 2.3014 | 30511740.0 |
| 2006-08-09 09:45:00 | AAPL | Stock | 2.3018 | 2.3143 | 2.3004 | 2.3082 | 22445808.0 |
| 2006-08-09 09:50:00 | AAPL | Stock | 2.3081 | 2.3139 | 2.3046 | 2.3114 | 18358760.0 |
| 2006-08-09 09:55:00 | AAPL | Stock | 2.3118 | 2.325 | 2.2989 | 2.3079 | 18348512.0 |
| 2006-08-09 10:00:00 | AAPL | Stock | 2.3079 | 2.3079 | 2.3 | 2.3025 | 12245492.0 |
| 2006-08-09 10:05:00 | AAPL | Stock | 2.3025 | 2.3093 | 2.2943 | 2.3068 | 14502852.0 |
| 2006-08-09 10:10:00 | AAPL | Stock | 2.3071 | 2.3089 | 2.3029 | 2.3064 | 8791272.0 |
| 2006-08-09 10:15:00 | AAPL | Stock | 2.3068 | 2.3068 | 2.2996 | 2.3032 | 8391376.0 |
| 2006-08-09 10:20:00 | AAPL | Stock | 2.3036 | 2.3104 | 2.3021 | 2.3068 | 15250200.0 |
| 2006-08-09 10:25:00 | AAPL | Stock | 2.3068 | 2.3068 | 2.2957 | 2.2957 | 19865244.0 |
| 2006-08-09 10:30:00 | AAPL | Stock | 2.2961 | 2.2996 | 2.2925 | 2.2929 | 14688240.0 |
| 2006-08-09 10:35:00 | AAPL | Stock | 2.2925 | 2.2929 | 2.2832 | 2.2832 | 21502740.0 |
| 2006-08-09 10:40:00 | AAPL | Stock | 2.2832 | 2.289 | 2.2786 | 2.285 | 25349016.0 |
| 2006-08-09 10:45:00 | AAPL | Stock | 2.2846 | 2.285 | 2.2764 | 2.2789 | 18777948.0 |
| 2006-08-09 10:50:00 | AAPL | Stock | 2.2789 | 2.2875 | 2.2775 | 2.2868 | 21824264.0 |
| 2006-08-09 10:55:00 | AAPL | Stock | 2.2868 | 2.2975 | 2.2843 | 2.2918 | 17555188.0 |
| 2006-08-09 11:00:00 | AAPL | Stock | 2.2914 | 2.305 | 2.2904 | 2.3014 | 16343572.0 |
| 2006-08-09 11:05:00 | AAPL | Stock | 2.3018 | 2.3036 | 2.2986 | 2.3011 | 12236980.0 |
| 2006-08-09 11:10:00 | AAPL | Stock | 2.3011 | 2.3068 | 2.2993 | 2.3039 | 15248604.0 |
| 2006-08-09 11:15:00 | AAPL | Stock | 2.3039 | 2.3071 | 2.3021 | 2.3054 | 11602920.0 |
| 2006-08-09 11:20:00 | AAPL | Stock | 2.3057 | 2.3104 | 2.3036 | 2.3039 | 13840624.0 |
| 2006-08-09 11:25:00 | AAPL | Stock | 2.3036 | 2.3057 | 2.3018 | 2.3039 | 10296832.0 |
| 2006-08-09 11:30:00 | AAPL | Stock | 2.3039 | 2.3082 | 2.3025 | 2.3061 | 12654628.0 |
| 2006-08-09 11:35:00 | AAPL | Stock | 2.3064 | 2.3132 | 2.3061 | 2.3125 | 14539196.0 |
| 2006-08-09 11:40:00 | AAPL | Stock | 2.3121 | 2.3361 | 2.3121 | 2.3318 | 30612512.0 |
| 2006-08-09 11:45:00 | AAPL | Stock | 2.3318 | 2.3332 | 2.3254 | 2.3289 | 15075872.0 |
| 2006-08-09 11:50:00 | AAPL | Stock | 2.3286 | 2.3304 | 2.3218 | 2.3264 | 12898732.0 |
| 2006-08-09 11:55:00 | AAPL | Stock | 2.3264 | 2.3321 | 2.3257 | 2.3307 | 13626788.0 |
| 2006-08-09 12:00:00 | AAPL | Stock | 2.3304 | 2.3306 | 2.3189 | 2.3204 | 11099676.0 |
> showing 50 of 227,580 rows — these rows as CSV