PREVIEW / stock_1min / 2009-01-09
file: by_date/stock_1min/2009/2009-01-09.parquet size: 11.9 MB rows: 926,455 symbols: 2,685
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-09 08:00:00 | AAPL | Stock | 3.2982 | 3.3125 | 3.2982 | 3.3125 | 56000.0 |
| 2009-01-09 08:01:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 15960.0 |
| 2009-01-09 08:03:00 | AAPL | Stock | 3.3193 | 3.3193 | 3.3193 | 3.3193 | 11200.0 |
| 2009-01-09 08:08:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.3071 | 3.3071 | 8400.0 |
| 2009-01-09 08:11:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.3071 | 3.3071 | 2800.0 |
| 2009-01-09 08:12:00 | AAPL | Stock | 3.3075 | 3.3075 | 3.3071 | 3.3071 | 40600.0 |
| 2009-01-09 08:13:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.3071 | 3.3071 | 5600.0 |
| 2009-01-09 08:15:00 | AAPL | Stock | 3.3179 | 3.3211 | 3.3146 | 3.3146 | 26600.0 |
| 2009-01-09 08:16:00 | AAPL | Stock | 3.3171 | 3.3214 | 3.3171 | 3.3214 | 12600.0 |
| 2009-01-09 08:17:00 | AAPL | Stock | 3.3132 | 3.3132 | 3.3125 | 3.3125 | 13300.0 |
| 2009-01-09 08:21:00 | AAPL | Stock | 3.3161 | 3.3161 | 3.3161 | 3.3161 | 7000.0 |
| 2009-01-09 08:22:00 | AAPL | Stock | 3.3171 | 3.3221 | 3.3171 | 3.3221 | 15008.0 |
| 2009-01-09 08:23:00 | AAPL | Stock | 3.3268 | 3.3268 | 3.325 | 3.325 | 30800.0 |
| 2009-01-09 08:25:00 | AAPL | Stock | 3.3246 | 3.325 | 3.3246 | 3.325 | 12600.0 |
| 2009-01-09 08:27:00 | AAPL | Stock | 3.3143 | 3.3143 | 3.3143 | 3.3143 | 14000.0 |
| 2009-01-09 08:28:00 | AAPL | Stock | 3.3143 | 3.3179 | 3.3143 | 3.3179 | 17892.0 |
| 2009-01-09 08:29:00 | AAPL | Stock | 3.3132 | 3.3132 | 3.3132 | 3.3132 | 3612.0 |
| 2009-01-09 08:30:00 | AAPL | Stock | 3.3196 | 3.3482 | 3.3196 | 3.3368 | 309400.0 |
| 2009-01-09 08:31:00 | AAPL | Stock | 3.3254 | 3.3425 | 3.325 | 3.3425 | 109368.0 |
| 2009-01-09 08:32:00 | AAPL | Stock | 3.3393 | 3.3429 | 3.3393 | 3.3429 | 28000.0 |
| 2009-01-09 08:33:00 | AAPL | Stock | 3.3439 | 3.3514 | 3.3439 | 3.3482 | 194180.0 |
| 2009-01-09 08:34:00 | AAPL | Stock | 3.3464 | 3.35 | 3.3464 | 3.3464 | 119168.0 |
| 2009-01-09 08:35:00 | AAPL | Stock | 3.3464 | 3.3493 | 3.3464 | 3.3464 | 58968.0 |
| 2009-01-09 08:36:00 | AAPL | Stock | 3.3421 | 3.3536 | 3.3421 | 3.3536 | 200592.0 |
| 2009-01-09 08:38:00 | AAPL | Stock | 3.345 | 3.3454 | 3.3414 | 3.3421 | 63000.0 |
| 2009-01-09 08:39:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3304 | 3.3304 | 214200.0 |
| 2009-01-09 08:40:00 | AAPL | Stock | 3.3311 | 3.3389 | 3.3311 | 3.3389 | 58800.0 |
| 2009-01-09 08:41:00 | AAPL | Stock | 3.3386 | 3.3386 | 3.3386 | 3.3386 | 5600.0 |
| 2009-01-09 08:42:00 | AAPL | Stock | 3.3357 | 3.3357 | 3.3343 | 3.3357 | 86800.0 |
| 2009-01-09 08:43:00 | AAPL | Stock | 3.3332 | 3.3339 | 3.3293 | 3.3293 | 98700.0 |
| 2009-01-09 08:44:00 | AAPL | Stock | 3.3257 | 3.3257 | 3.3229 | 3.325 | 95900.0 |
| 2009-01-09 08:45:00 | AAPL | Stock | 3.3221 | 3.3261 | 3.3221 | 3.3261 | 19600.0 |
| 2009-01-09 08:46:00 | AAPL | Stock | 3.3261 | 3.3329 | 3.3261 | 3.3318 | 19600.0 |
| 2009-01-09 08:48:00 | AAPL | Stock | 3.3275 | 3.3275 | 3.3268 | 3.3268 | 12600.0 |
| 2009-01-09 08:49:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 5600.0 |
| 2009-01-09 08:51:00 | AAPL | Stock | 3.3321 | 3.3332 | 3.3304 | 3.3304 | 47600.0 |
| 2009-01-09 08:52:00 | AAPL | Stock | 3.3332 | 3.3332 | 3.3321 | 3.3321 | 5600.0 |
| 2009-01-09 08:53:00 | AAPL | Stock | 3.335 | 3.3382 | 3.3332 | 3.3332 | 23800.0 |
| 2009-01-09 08:54:00 | AAPL | Stock | 3.3321 | 3.3343 | 3.3307 | 3.3307 | 25200.0 |
| 2009-01-09 08:56:00 | AAPL | Stock | 3.3314 | 3.3314 | 3.3314 | 3.3314 | 2800.0 |
| 2009-01-09 08:57:00 | AAPL | Stock | 3.3339 | 3.3346 | 3.3339 | 3.3343 | 25200.0 |
| 2009-01-09 09:00:00 | AAPL | Stock | 3.3343 | 3.3343 | 3.3343 | 3.3343 | 2800.0 |
| 2009-01-09 09:02:00 | AAPL | Stock | 3.3304 | 3.3321 | 3.3304 | 3.3307 | 16800.0 |
| 2009-01-09 09:03:00 | AAPL | Stock | 3.3307 | 3.3321 | 3.3307 | 3.3321 | 25200.0 |
| 2009-01-09 09:04:00 | AAPL | Stock | 3.3307 | 3.3307 | 3.3304 | 3.3304 | 11200.0 |
| 2009-01-09 09:05:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 18200.0 |
| 2009-01-09 09:06:00 | AAPL | Stock | 3.3286 | 3.3336 | 3.3286 | 3.3336 | 36400.0 |
| 2009-01-09 09:07:00 | AAPL | Stock | 3.3314 | 3.3314 | 3.3314 | 3.3314 | 27300.0 |
| 2009-01-09 09:08:00 | AAPL | Stock | 3.3293 | 3.3293 | 3.3293 | 3.3293 | 2800.0 |
| 2009-01-09 09:09:00 | AAPL | Stock | 3.3293 | 3.3304 | 3.3293 | 3.3304 | 8708.0 |
> showing 50 of 926,455 rows — these rows as CSV