PREVIEW / stock_5min / 2005-06-15
file: by_date/stock_5min/2005/2005-06-15.parquet size: 2.7 MB rows: 199,124 symbols: 1,990
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-15 07:10:00 | AAPL | Stock | 1.3 | 1.3068 | 1.3 | 1.3068 | 5600.0 |
| 2005-06-15 07:20:00 | AAPL | Stock | 1.3039 | 1.3039 | 1.3039 | 1.3039 | 2800.0 |
| 2005-06-15 07:45:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 28140.0 |
| 2005-06-15 08:00:00 | AAPL | Stock | 1.3018 | 1.3054 | 1.2982 | 1.3018 | 301336.0 |
| 2005-06-15 08:05:00 | AAPL | Stock | 1.3 | 1.3 | 1.3 | 1.3 | 92400.0 |
| 2005-06-15 08:10:00 | AAPL | Stock | 1.3004 | 1.3004 | 1.2964 | 1.2964 | 149156.0 |
| 2005-06-15 08:15:00 | AAPL | Stock | 1.2968 | 1.3 | 1.2946 | 1.3 | 211988.0 |
| 2005-06-15 08:20:00 | AAPL | Stock | 1.2971 | 1.2971 | 1.2964 | 1.2964 | 42000.0 |
| 2005-06-15 08:25:00 | AAPL | Stock | 1.3 | 1.3 | 1.3 | 1.3 | 42000.0 |
| 2005-06-15 08:30:00 | AAPL | Stock | 1.3 | 1.3054 | 1.3 | 1.3054 | 362068.0 |
| 2005-06-15 08:35:00 | AAPL | Stock | 1.3036 | 1.305 | 1.3025 | 1.305 | 430556.0 |
| 2005-06-15 08:40:00 | AAPL | Stock | 1.3036 | 1.3071 | 1.3036 | 1.3071 | 1066660.0 |
| 2005-06-15 08:45:00 | AAPL | Stock | 1.3071 | 1.3107 | 1.3071 | 1.3096 | 310464.0 |
| 2005-06-15 08:50:00 | AAPL | Stock | 1.3089 | 1.3096 | 1.3071 | 1.3075 | 324464.0 |
| 2005-06-15 08:55:00 | AAPL | Stock | 1.3075 | 1.3082 | 1.3004 | 1.3064 | 1038296.0 |
| 2005-06-15 09:00:00 | AAPL | Stock | 1.3057 | 1.315 | 1.3036 | 1.3121 | 3357564.0 |
| 2005-06-15 09:05:00 | AAPL | Stock | 1.3121 | 1.3146 | 1.3104 | 1.3146 | 1437688.0 |
| 2005-06-15 09:10:00 | AAPL | Stock | 1.3146 | 1.3196 | 1.3146 | 1.3196 | 1845676.0 |
| 2005-06-15 09:15:00 | AAPL | Stock | 1.3193 | 1.3214 | 1.315 | 1.3168 | 1361640.0 |
| 2005-06-15 09:20:00 | AAPL | Stock | 1.3161 | 1.3161 | 1.3125 | 1.3125 | 517440.0 |
| 2005-06-15 09:25:00 | AAPL | Stock | 1.3125 | 1.3168 | 1.31 | 1.3168 | 1882244.0 |
| 2005-06-15 09:30:00 | AAPL | Stock | 1.3168 | 1.3296 | 1.3136 | 1.3296 | 39839940.0 |
| 2005-06-15 09:35:00 | AAPL | Stock | 1.3293 | 1.3321 | 1.3246 | 1.3254 | 24572492.0 |
| 2005-06-15 09:40:00 | AAPL | Stock | 1.3261 | 1.3286 | 1.3243 | 1.325 | 12098324.0 |
| 2005-06-15 09:45:00 | AAPL | Stock | 1.3254 | 1.3268 | 1.3232 | 1.3236 | 12426932.0 |
| 2005-06-15 09:50:00 | AAPL | Stock | 1.3236 | 1.3243 | 1.3179 | 1.3207 | 19821900.0 |
| 2005-06-15 09:55:00 | AAPL | Stock | 1.3214 | 1.3221 | 1.3182 | 1.3207 | 9074632.0 |
| 2005-06-15 10:00:00 | AAPL | Stock | 1.3207 | 1.3232 | 1.3193 | 1.3193 | 9969568.0 |
| 2005-06-15 10:05:00 | AAPL | Stock | 1.3193 | 1.3214 | 1.3164 | 1.3168 | 16785468.0 |
| 2005-06-15 10:10:00 | AAPL | Stock | 1.3168 | 1.32 | 1.3132 | 1.3143 | 17567816.0 |
| 2005-06-15 10:15:00 | AAPL | Stock | 1.3143 | 1.315 | 1.3111 | 1.3143 | 12830216.0 |
| 2005-06-15 10:20:00 | AAPL | Stock | 1.3143 | 1.3175 | 1.3132 | 1.3139 | 7783496.0 |
| 2005-06-15 10:25:00 | AAPL | Stock | 1.3136 | 1.3139 | 1.3079 | 1.3104 | 8812020.0 |
| 2005-06-15 10:30:00 | AAPL | Stock | 1.3104 | 1.3104 | 1.3036 | 1.3064 | 14795704.0 |
| 2005-06-15 10:35:00 | AAPL | Stock | 1.3064 | 1.3089 | 1.3046 | 1.3082 | 8982344.0 |
| 2005-06-15 10:40:00 | AAPL | Stock | 1.3075 | 1.3104 | 1.3046 | 1.3046 | 6581148.0 |
| 2005-06-15 10:45:00 | AAPL | Stock | 1.305 | 1.305 | 1.2993 | 1.3021 | 11721556.0 |
| 2005-06-15 10:50:00 | AAPL | Stock | 1.3021 | 1.3043 | 1.2996 | 1.3014 | 7916076.0 |
| 2005-06-15 10:55:00 | AAPL | Stock | 1.3014 | 1.3036 | 1.2975 | 1.2982 | 7087668.0 |
| 2005-06-15 11:00:00 | AAPL | Stock | 1.2982 | 1.3025 | 1.2979 | 1.3025 | 6797896.0 |
| 2005-06-15 11:05:00 | AAPL | Stock | 1.3025 | 1.3046 | 1.3018 | 1.3029 | 7550312.0 |
| 2005-06-15 11:10:00 | AAPL | Stock | 1.3025 | 1.3032 | 1.3018 | 1.3018 | 2916508.0 |
| 2005-06-15 11:15:00 | AAPL | Stock | 1.3018 | 1.3046 | 1.3007 | 1.3046 | 6293924.0 |
| 2005-06-15 11:20:00 | AAPL | Stock | 1.3046 | 1.3096 | 1.3043 | 1.3082 | 10403960.0 |
| 2005-06-15 11:25:00 | AAPL | Stock | 1.3082 | 1.3082 | 1.3043 | 1.305 | 3567228.0 |
| 2005-06-15 11:30:00 | AAPL | Stock | 1.3054 | 1.3071 | 1.305 | 1.3064 | 3329004.0 |
| 2005-06-15 11:35:00 | AAPL | Stock | 1.3064 | 1.3075 | 1.3061 | 1.3064 | 2516108.0 |
| 2005-06-15 11:40:00 | AAPL | Stock | 1.3064 | 1.3086 | 1.3054 | 1.3075 | 3462508.0 |
| 2005-06-15 11:45:00 | AAPL | Stock | 1.3079 | 1.3079 | 1.3025 | 1.3028 | 3779524.0 |
| 2005-06-15 11:50:00 | AAPL | Stock | 1.3028 | 1.3029 | 1.3004 | 1.3004 | 3981208.0 |
> showing 50 of 199,124 rows — these rows as CSV