PREVIEW / stock_5min / 2005-07-01
file: by_date/stock_5min/2005/2005-07-01.parquet size: 2.6 MB rows: 192,830 symbols: 2,012
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-07-01 08:00:00 | AAPL | Stock | 1.3179 | 1.3196 | 1.3179 | 1.3196 | 30800.0 |
| 2005-07-01 08:15:00 | AAPL | Stock | 1.3146 | 1.3214 | 1.3146 | 1.3214 | 97944.0 |
| 2005-07-01 08:20:00 | AAPL | Stock | 1.3146 | 1.3214 | 1.3146 | 1.3214 | 110656.0 |
| 2005-07-01 08:25:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3179 | 1.3179 | 37940.0 |
| 2005-07-01 08:50:00 | AAPL | Stock | 1.3196 | 1.3196 | 1.3196 | 1.3196 | 2800.0 |
| 2005-07-01 08:55:00 | AAPL | Stock | 1.3182 | 1.3196 | 1.3182 | 1.3196 | 30800.0 |
| 2005-07-01 09:00:00 | AAPL | Stock | 1.3196 | 1.3196 | 1.3196 | 1.3196 | 53200.0 |
| 2005-07-01 09:05:00 | AAPL | Stock | 1.3196 | 1.3196 | 1.3196 | 1.3196 | 19600.0 |
| 2005-07-01 09:10:00 | AAPL | Stock | 1.3211 | 1.3211 | 1.32 | 1.32 | 19600.0 |
| 2005-07-01 09:15:00 | AAPL | Stock | 1.3204 | 1.3214 | 1.3196 | 1.32 | 112000.0 |
| 2005-07-01 09:20:00 | AAPL | Stock | 1.3214 | 1.3218 | 1.3214 | 1.3218 | 16800.0 |
| 2005-07-01 09:25:00 | AAPL | Stock | 1.3218 | 1.3221 | 1.3143 | 1.3154 | 1398292.0 |
| 2005-07-01 09:30:00 | AAPL | Stock | 1.3154 | 1.3204 | 1.31 | 1.3121 | 14160524.0 |
| 2005-07-01 09:35:00 | AAPL | Stock | 1.3121 | 1.3171 | 1.3121 | 1.3154 | 8620080.0 |
| 2005-07-01 09:40:00 | AAPL | Stock | 1.315 | 1.3157 | 1.3118 | 1.3132 | 5504744.0 |
| 2005-07-01 09:45:00 | AAPL | Stock | 1.3132 | 1.315 | 1.3114 | 1.3132 | 6446804.0 |
| 2005-07-01 09:50:00 | AAPL | Stock | 1.3136 | 1.3143 | 1.31 | 1.3118 | 4648336.0 |
| 2005-07-01 09:55:00 | AAPL | Stock | 1.3111 | 1.3136 | 1.3107 | 1.3125 | 3919160.0 |
| 2005-07-01 10:00:00 | AAPL | Stock | 1.3125 | 1.3154 | 1.3096 | 1.3132 | 5129908.0 |
| 2005-07-01 10:05:00 | AAPL | Stock | 1.3132 | 1.3143 | 1.3111 | 1.3121 | 3531304.0 |
| 2005-07-01 10:10:00 | AAPL | Stock | 1.3125 | 1.3157 | 1.3111 | 1.3132 | 5038348.0 |
| 2005-07-01 10:15:00 | AAPL | Stock | 1.3125 | 1.3154 | 1.3114 | 1.3132 | 4049556.0 |
| 2005-07-01 10:20:00 | AAPL | Stock | 1.3132 | 1.3139 | 1.3111 | 1.3111 | 6143116.0 |
| 2005-07-01 10:25:00 | AAPL | Stock | 1.3111 | 1.3136 | 1.3089 | 1.3125 | 5241012.0 |
| 2005-07-01 10:30:00 | AAPL | Stock | 1.3125 | 1.3179 | 1.3121 | 1.3146 | 7531916.0 |
| 2005-07-01 10:35:00 | AAPL | Stock | 1.3146 | 1.3146 | 1.3125 | 1.3136 | 4187484.0 |
| 2005-07-01 10:40:00 | AAPL | Stock | 1.3132 | 1.3136 | 1.3104 | 1.3129 | 3875480.0 |
| 2005-07-01 10:45:00 | AAPL | Stock | 1.3129 | 1.3132 | 1.3104 | 1.3111 | 2807392.0 |
| 2005-07-01 10:50:00 | AAPL | Stock | 1.3111 | 1.3121 | 1.3104 | 1.3111 | 1403080.0 |
| 2005-07-01 10:55:00 | AAPL | Stock | 1.3118 | 1.3118 | 1.3104 | 1.3114 | 1676668.0 |
| 2005-07-01 11:00:00 | AAPL | Stock | 1.3111 | 1.3118 | 1.3061 | 1.3061 | 5113724.0 |
| 2005-07-01 11:05:00 | AAPL | Stock | 1.3064 | 1.3068 | 1.3043 | 1.3064 | 3914624.0 |
| 2005-07-01 11:10:00 | AAPL | Stock | 1.3064 | 1.3086 | 1.3054 | 1.3057 | 2761864.0 |
| 2005-07-01 11:15:00 | AAPL | Stock | 1.3057 | 1.3107 | 1.3057 | 1.3089 | 2205924.0 |
| 2005-07-01 11:20:00 | AAPL | Stock | 1.3089 | 1.3107 | 1.3054 | 1.3054 | 3592232.0 |
| 2005-07-01 11:25:00 | AAPL | Stock | 1.3054 | 1.3093 | 1.3054 | 1.3054 | 2105096.0 |
| 2005-07-01 11:30:00 | AAPL | Stock | 1.3057 | 1.3079 | 1.3057 | 1.3071 | 1082396.0 |
| 2005-07-01 11:35:00 | AAPL | Stock | 1.3075 | 1.3075 | 1.3021 | 1.3043 | 6265196.0 |
| 2005-07-01 11:40:00 | AAPL | Stock | 1.3043 | 1.305 | 1.3014 | 1.3021 | 2143932.0 |
| 2005-07-01 11:45:00 | AAPL | Stock | 1.3021 | 1.3039 | 1.3021 | 1.3039 | 2822260.0 |
| 2005-07-01 11:50:00 | AAPL | Stock | 1.3039 | 1.3039 | 1.3021 | 1.3032 | 1141336.0 |
| 2005-07-01 11:55:00 | AAPL | Stock | 1.3036 | 1.3039 | 1.3018 | 1.3021 | 2280684.0 |
| 2005-07-01 12:00:00 | AAPL | Stock | 1.3025 | 1.3025 | 1.2996 | 1.3011 | 3801896.0 |
| 2005-07-01 12:05:00 | AAPL | Stock | 1.3011 | 1.3011 | 1.2961 | 1.2975 | 4638564.0 |
| 2005-07-01 12:10:00 | AAPL | Stock | 1.2975 | 1.3 | 1.2971 | 1.3 | 2072840.0 |
| 2005-07-01 12:15:00 | AAPL | Stock | 1.2993 | 1.3004 | 1.2975 | 1.2993 | 1763608.0 |
| 2005-07-01 12:20:00 | AAPL | Stock | 1.2993 | 1.3018 | 1.2975 | 1.2982 | 2138724.0 |
| 2005-07-01 12:25:00 | AAPL | Stock | 1.2986 | 1.2989 | 1.2975 | 1.2979 | 2888200.0 |
| 2005-07-01 12:30:00 | AAPL | Stock | 1.2982 | 1.2982 | 1.2971 | 1.2979 | 2067408.0 |
| 2005-07-01 12:35:00 | AAPL | Stock | 1.2975 | 1.2979 | 1.2961 | 1.2971 | 3155376.0 |
> showing 50 of 192,830 rows — these rows as CSV