PREVIEW / stock_1min / 2005-06-29
file: by_date/stock_1min/2005/2005-06-29.parquet size: 6.6 MB rows: 551,948 symbols: 1,654
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:07:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 28000.0 |
| 2005-06-29 08:18:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.3268 | 1.3268 | 5600.0 |
| 2005-06-29 08:21:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.3268 | 1.3268 | 22456.0 |
| 2005-06-29 08:31:00 | AAPL | Stock | 1.3261 | 1.3261 | 1.3261 | 1.3261 | 140000.0 |
| 2005-06-29 08:35:00 | AAPL | Stock | 1.325 | 1.325 | 1.325 | 1.325 | 28000.0 |
| 2005-06-29 08:36:00 | AAPL | Stock | 1.3254 | 1.3254 | 1.3254 | 1.3254 | 8400.0 |
| 2005-06-29 08:37:00 | AAPL | Stock | 1.325 | 1.325 | 1.325 | 1.325 | 19600.0 |
| 2005-06-29 08:38:00 | AAPL | Stock | 1.325 | 1.325 | 1.325 | 1.325 | 28000.0 |
| 2005-06-29 08:39:00 | AAPL | Stock | 1.3268 | 1.3286 | 1.3268 | 1.3282 | 54600.0 |
| 2005-06-29 08:44:00 | AAPL | Stock | 1.3282 | 1.3321 | 1.3229 | 1.3282 | 44800.0 |
| 2005-06-29 08:46:00 | AAPL | Stock | 1.3279 | 1.3279 | 1.3279 | 1.3279 | 28000.0 |
| 2005-06-29 08:47:00 | AAPL | Stock | 1.3279 | 1.3282 | 1.3279 | 1.3282 | 28000.0 |
| 2005-06-29 08:48:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 84000.0 |
| 2005-06-29 08:49:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 64400.0 |
| 2005-06-29 08:50:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 5600.0 |
| 2005-06-29 08:51:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3279 | 1.3279 | 8400.0 |
| 2005-06-29 08:52:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 8400.0 |
| 2005-06-29 08:54:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 42000.0 |
| 2005-06-29 08:56:00 | AAPL | Stock | 1.3296 | 1.3296 | 1.3296 | 1.3296 | 2800.0 |
| 2005-06-29 09:00:00 | AAPL | Stock | 1.3296 | 1.3296 | 1.3293 | 1.3293 | 47600.0 |
| 2005-06-29 09:01:00 | AAPL | Stock | 1.3286 | 1.3296 | 1.3286 | 1.3286 | 67200.0 |
| 2005-06-29 09:02:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 19600.0 |
| 2005-06-29 09:03:00 | AAPL | Stock | 1.3296 | 1.3304 | 1.3293 | 1.3296 | 86800.0 |
| 2005-06-29 09:04:00 | AAPL | Stock | 1.3311 | 1.3311 | 1.3304 | 1.3304 | 86800.0 |
| 2005-06-29 09:05:00 | AAPL | Stock | 1.3286 | 1.3286 | 1.3286 | 1.3286 | 420000.0 |
| 2005-06-29 09:06:00 | AAPL | Stock | 1.3304 | 1.3311 | 1.3304 | 1.3311 | 21000.0 |
| 2005-06-29 09:07:00 | AAPL | Stock | 1.3311 | 1.3321 | 1.3311 | 1.3321 | 30800.0 |
| 2005-06-29 09:08:00 | AAPL | Stock | 1.3321 | 1.3321 | 1.3304 | 1.3304 | 79520.0 |
| 2005-06-29 09:09:00 | AAPL | Stock | 1.3304 | 1.3332 | 1.3304 | 1.3332 | 119000.0 |
| 2005-06-29 09:11:00 | AAPL | Stock | 1.3332 | 1.3332 | 1.3321 | 1.3321 | 42000.0 |
| 2005-06-29 09:13:00 | AAPL | Stock | 1.3332 | 1.3332 | 1.3332 | 1.3332 | 22400.0 |
| 2005-06-29 09:23:00 | AAPL | Stock | 1.3336 | 1.3336 | 1.3336 | 1.3336 | 2800.0 |
| 2005-06-29 09:29: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.3271 | 1.3289 | 3885280.0 |
| 2005-06-29 09:31:00 | AAPL | Stock | 1.3289 | 1.3304 | 1.3275 | 1.3282 | 1980552.0 |
| 2005-06-29 09:32:00 | AAPL | Stock | 1.3282 | 1.3289 | 1.3246 | 1.325 | 2974384.0 |
| 2005-06-29 09:33:00 | AAPL | Stock | 1.325 | 1.3264 | 1.3225 | 1.3239 | 2592828.0 |
| 2005-06-29 09:34:00 | AAPL | Stock | 1.3243 | 1.3261 | 1.3229 | 1.3232 | 2458512.0 |
| 2005-06-29 09:35:00 | AAPL | Stock | 1.3239 | 1.3239 | 1.3193 | 1.3193 | 3524836.0 |
| 2005-06-29 09:36:00 | AAPL | Stock | 1.3196 | 1.32 | 1.3171 | 1.3186 | 3802232.0 |
| 2005-06-29 09:37:00 | AAPL | Stock | 1.3186 | 1.3204 | 1.3182 | 1.3193 | 2063852.0 |
| 2005-06-29 09:38:00 | AAPL | Stock | 1.3189 | 1.3193 | 1.3171 | 1.3175 | 1414756.0 |
| 2005-06-29 09:39:00 | AAPL | Stock | 1.3175 | 1.32 | 1.3161 | 1.3164 | 2040976.0 |
| 2005-06-29 09:40:00 | AAPL | Stock | 1.3164 | 1.3179 | 1.3157 | 1.3157 | 2047192.0 |
| 2005-06-29 09:41:00 | AAPL | Stock | 1.3157 | 1.3175 | 1.3154 | 1.3161 | 3085908.0 |
| 2005-06-29 09:42:00 | AAPL | Stock | 1.3161 | 1.3164 | 1.3129 | 1.3139 | 5009900.0 |
| 2005-06-29 09:43:00 | AAPL | Stock | 1.3139 | 1.3143 | 1.3125 | 1.3125 | 2499588.0 |
| 2005-06-29 09:44:00 | AAPL | Stock | 1.3125 | 1.3157 | 1.3114 | 1.3136 | 2389576.0 |
| 2005-06-29 09:45:00 | AAPL | Stock | 1.3136 | 1.3179 | 1.3136 | 1.3171 | 2738260.0 |
> showing 50 of 551,948 rows — these rows as CSV