PREVIEW / stock_5min / 2005-06-29
file: by_date/stock_5min/2005/2005-06-29.parquet size: 2.7 MB rows: 197,157 symbols: 2,015
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-29 08:00:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.3268 | 1.3268 | 5600.0 |
| 2005-06-29 08:05:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 28000.0 |
| 2005-06-29 08:15:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.3268 | 1.3268 | 5600.0 |
| 2005-06-29 08:20:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.3268 | 1.3268 | 22456.0 |
| 2005-06-29 08:30:00 | AAPL | Stock | 1.3261 | 1.3261 | 1.3261 | 1.3261 | 140000.0 |
| 2005-06-29 08:35:00 | AAPL | Stock | 1.325 | 1.3286 | 1.325 | 1.3282 | 138600.0 |
| 2005-06-29 08:40:00 | AAPL | Stock | 1.3282 | 1.3321 | 1.3229 | 1.3282 | 44800.0 |
| 2005-06-29 08:45:00 | AAPL | Stock | 1.3279 | 1.3286 | 1.3279 | 1.3286 | 204400.0 |
| 2005-06-29 08:50:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3279 | 1.3286 | 64400.0 |
| 2005-06-29 08:55:00 | AAPL | Stock | 1.3296 | 1.3296 | 1.3296 | 1.3296 | 2800.0 |
| 2005-06-29 09:00:00 | AAPL | Stock | 1.3296 | 1.3311 | 1.3286 | 1.3304 | 308000.0 |
| 2005-06-29 09:05:00 | AAPL | Stock | 1.3286 | 1.3332 | 1.3286 | 1.3332 | 670320.0 |
| 2005-06-29 09:10:00 | AAPL | Stock | 1.3332 | 1.3332 | 1.3321 | 1.3332 | 64400.0 |
| 2005-06-29 09:20:00 | AAPL | Stock | 1.3336 | 1.3336 | 1.3336 | 1.3336 | 2800.0 |
| 2005-06-29 09:25:00 | AAPL | Stock | 1.3307 | 1.3311 | 1.3293 | 1.3293 | 72800.0 |
| 2005-06-29 09:30:00 | AAPL | Stock | 1.3296 | 1.3318 | 1.3225 | 1.3232 | 13891556.0 |
| 2005-06-29 09:35:00 | AAPL | Stock | 1.3239 | 1.3239 | 1.3161 | 1.3164 | 12846652.0 |
| 2005-06-29 09:40:00 | AAPL | Stock | 1.3164 | 1.3179 | 1.3114 | 1.3136 | 15032164.0 |
| 2005-06-29 09:45:00 | AAPL | Stock | 1.3136 | 1.3182 | 1.3132 | 1.3136 | 8603252.0 |
| 2005-06-29 09:50:00 | AAPL | Stock | 1.3136 | 1.3182 | 1.3129 | 1.315 | 7205268.0 |
| 2005-06-29 09:55:00 | AAPL | Stock | 1.3154 | 1.3157 | 1.2986 | 1.3036 | 21221256.0 |
| 2005-06-29 10:00:00 | AAPL | Stock | 1.3036 | 1.3089 | 1.2996 | 1.3068 | 14787276.0 |
| 2005-06-29 10:05:00 | AAPL | Stock | 1.3068 | 1.3068 | 1.3018 | 1.3039 | 6693008.0 |
| 2005-06-29 10:10:00 | AAPL | Stock | 1.3036 | 1.3057 | 1.3014 | 1.3029 | 5537196.0 |
| 2005-06-29 10:15:00 | AAPL | Stock | 1.3029 | 1.3036 | 1.3 | 1.3029 | 5747924.0 |
| 2005-06-29 10:20:00 | AAPL | Stock | 1.3029 | 1.3032 | 1.2986 | 1.2989 | 5082896.0 |
| 2005-06-29 10:25:00 | AAPL | Stock | 1.2989 | 1.3 | 1.295 | 1.2982 | 9678032.0 |
| 2005-06-29 10:30:00 | AAPL | Stock | 1.2982 | 1.3018 | 1.2971 | 1.3004 | 13171480.0 |
| 2005-06-29 10:35:00 | AAPL | Stock | 1.3004 | 1.3011 | 1.2957 | 1.2964 | 7948528.0 |
| 2005-06-29 10:40:00 | AAPL | Stock | 1.2961 | 1.3007 | 1.2961 | 1.2993 | 5619460.0 |
| 2005-06-29 10:45:00 | AAPL | Stock | 1.3 | 1.3004 | 1.2989 | 1.3 | 9033472.0 |
| 2005-06-29 10:50:00 | AAPL | Stock | 1.3 | 1.3011 | 1.2989 | 1.2989 | 6137936.0 |
| 2005-06-29 10:55:00 | AAPL | Stock | 1.2996 | 1.3004 | 1.2961 | 1.2993 | 8600480.0 |
| 2005-06-29 11:00:00 | AAPL | Stock | 1.2989 | 1.3018 | 1.2982 | 1.3 | 9220204.0 |
| 2005-06-29 11:05:00 | AAPL | Stock | 1.3 | 1.3046 | 1.2996 | 1.3018 | 7100100.0 |
| 2005-06-29 11:10:00 | AAPL | Stock | 1.3021 | 1.3021 | 1.3 | 1.3007 | 4439960.0 |
| 2005-06-29 11:15:00 | AAPL | Stock | 1.3007 | 1.3011 | 1.2971 | 1.2986 | 5703572.0 |
| 2005-06-29 11:20:00 | AAPL | Stock | 1.2986 | 1.3025 | 1.2982 | 1.3018 | 2944592.0 |
| 2005-06-29 11:25:00 | AAPL | Stock | 1.3018 | 1.3032 | 1.3014 | 1.3021 | 3868956.0 |
| 2005-06-29 11:30:00 | AAPL | Stock | 1.3021 | 1.3039 | 1.3018 | 1.3029 | 5217716.0 |
| 2005-06-29 11:35:00 | AAPL | Stock | 1.3029 | 1.3032 | 1.3 | 1.3018 | 4747120.0 |
| 2005-06-29 11:40:00 | AAPL | Stock | 1.3018 | 1.3032 | 1.3007 | 1.3032 | 2769452.0 |
| 2005-06-29 11:45:00 | AAPL | Stock | 1.3032 | 1.3054 | 1.3031 | 1.3043 | 4106340.0 |
| 2005-06-29 11:50:00 | AAPL | Stock | 1.3043 | 1.3079 | 1.3039 | 1.3054 | 5922672.0 |
| 2005-06-29 11:55:00 | AAPL | Stock | 1.3054 | 1.3064 | 1.3 | 1.305 | 3928736.0 |
| 2005-06-29 12:00:00 | AAPL | Stock | 1.305 | 1.3061 | 1.3046 | 1.305 | 2559732.0 |
| 2005-06-29 12:05:00 | AAPL | Stock | 1.3054 | 1.3054 | 1.3046 | 1.3054 | 2220344.0 |
| 2005-06-29 12:10:00 | AAPL | Stock | 1.3046 | 1.305 | 1.3043 | 1.3046 | 1865892.0 |
| 2005-06-29 12:15:00 | AAPL | Stock | 1.3046 | 1.3046 | 1.3029 | 1.3032 | 3337572.0 |
| 2005-06-29 12:20:00 | AAPL | Stock | 1.3029 | 1.3036 | 1.3014 | 1.3032 | 5440204.0 |
> showing 50 of 197,157 rows — these rows as CSV