PREVIEW / stock_1min / 2009-01-29
file: by_date/stock_1min/2009/2009-01-29.parquet size: 11.7 MB rows: 916,376 symbols: 2,671
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-29 05:57:00 | AAPL | Stock | 3.3096 | 3.3096 | 3.3096 | 3.3096 | 6132.0 |
| 2009-01-29 08:00:00 | AAPL | Stock | 3.3214 | 3.3225 | 3.3214 | 3.3225 | 17080.0 |
| 2009-01-29 08:01:00 | AAPL | Stock | 3.3225 | 3.3225 | 3.3225 | 3.3225 | 28000.0 |
| 2009-01-29 08:02:00 | AAPL | Stock | 3.3364 | 3.3364 | 3.3364 | 3.3364 | 5600.0 |
| 2009-01-29 08:04:00 | AAPL | Stock | 3.3357 | 3.3357 | 3.3357 | 3.3357 | 3920.0 |
| 2009-01-29 08:05:00 | AAPL | Stock | 3.3357 | 3.3371 | 3.3357 | 3.3371 | 13076.0 |
| 2009-01-29 08:06:00 | AAPL | Stock | 3.3329 | 3.3329 | 3.3329 | 3.3329 | 4116.0 |
| 2009-01-29 08:07:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3321 | 3.3321 | 2800.0 |
| 2009-01-29 08:08:00 | AAPL | Stock | 3.3311 | 3.3311 | 3.3304 | 3.3304 | 33600.0 |
| 2009-01-29 08:10:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 5600.0 |
| 2009-01-29 08:11:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3232 | 3.3232 | 2800.0 |
| 2009-01-29 08:12:00 | AAPL | Stock | 3.325 | 3.325 | 3.3232 | 3.3232 | 28000.0 |
| 2009-01-29 08:13:00 | AAPL | Stock | 3.3236 | 3.3268 | 3.3236 | 3.3268 | 19600.0 |
| 2009-01-29 08:14:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 5600.0 |
| 2009-01-29 08:15:00 | AAPL | Stock | 3.3289 | 3.3289 | 3.3286 | 3.3286 | 24500.0 |
| 2009-01-29 08:17:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 28000.0 |
| 2009-01-29 08:19:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 5600.0 |
| 2009-01-29 08:20:00 | AAPL | Stock | 3.3304 | 3.3304 | 3.3304 | 3.3304 | 3500.0 |
| 2009-01-29 08:22:00 | AAPL | Stock | 3.3304 | 3.3321 | 3.3304 | 3.3321 | 18900.0 |
| 2009-01-29 08:25:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3321 | 3.3321 | 6580.0 |
| 2009-01-29 08:26:00 | AAPL | Stock | 3.3311 | 3.3357 | 3.3311 | 3.3357 | 33600.0 |
| 2009-01-29 08:29:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3339 | 3.3339 | 3724.0 |
| 2009-01-29 08:30:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3286 | 3.3286 | 55776.0 |
| 2009-01-29 08:31:00 | AAPL | Stock | 3.3289 | 3.3289 | 3.3268 | 3.3268 | 71400.0 |
| 2009-01-29 08:32:00 | AAPL | Stock | 3.3268 | 3.3271 | 3.3268 | 3.3268 | 79576.0 |
| 2009-01-29 08:33:00 | AAPL | Stock | 3.3246 | 3.3246 | 3.3232 | 3.3246 | 32200.0 |
| 2009-01-29 08:34:00 | AAPL | Stock | 3.3232 | 3.325 | 3.3232 | 3.325 | 42000.0 |
| 2009-01-29 08:35:00 | AAPL | Stock | 3.3268 | 3.3275 | 3.3268 | 3.3275 | 14000.0 |
| 2009-01-29 08:38:00 | AAPL | Stock | 3.3279 | 3.3279 | 3.3279 | 3.3279 | 8400.0 |
| 2009-01-29 08:39:00 | AAPL | Stock | 3.3311 | 3.3346 | 3.3286 | 3.3286 | 24920.0 |
| 2009-01-29 08:41:00 | AAPL | Stock | 3.3314 | 3.3321 | 3.3314 | 3.3321 | 16996.0 |
| 2009-01-29 08:42:00 | AAPL | Stock | 3.3321 | 3.3321 | 3.3321 | 3.3321 | 4200.0 |
| 2009-01-29 08:44:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3339 | 3.3339 | 2800.0 |
| 2009-01-29 08:45:00 | AAPL | Stock | 3.3293 | 3.3293 | 3.3286 | 3.3286 | 5600.0 |
| 2009-01-29 08:49:00 | AAPL | Stock | 3.33 | 3.33 | 3.33 | 3.33 | 4900.0 |
| 2009-01-29 08:50:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 11536.0 |
| 2009-01-29 08:51:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3275 | 3.3275 | 21280.0 |
| 2009-01-29 08:52:00 | AAPL | Stock | 3.3268 | 3.3268 | 3.3268 | 3.3268 | 2800.0 |
| 2009-01-29 08:53:00 | AAPL | Stock | 3.3275 | 3.3275 | 3.3254 | 3.3254 | 18816.0 |
| 2009-01-29 08:54:00 | AAPL | Stock | 3.3254 | 3.3254 | 3.3254 | 3.3254 | 7000.0 |
| 2009-01-29 08:56:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3232 | 3.3232 | 10500.0 |
| 2009-01-29 08:57:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3232 | 3.3232 | 2800.0 |
| 2009-01-29 08:58:00 | AAPL | Stock | 3.3236 | 3.3236 | 3.3225 | 3.3236 | 18984.0 |
| 2009-01-29 08:59:00 | AAPL | Stock | 3.325 | 3.325 | 3.325 | 3.325 | 2800.0 |
| 2009-01-29 09:00:00 | AAPL | Stock | 3.3268 | 3.3271 | 3.3225 | 3.3225 | 82740.0 |
| 2009-01-29 09:01:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3225 | 3.3225 | 16800.0 |
| 2009-01-29 09:02:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3232 | 3.3232 | 2800.0 |
| 2009-01-29 09:05:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3232 | 3.3232 | 33572.0 |
| 2009-01-29 09:06:00 | AAPL | Stock | 3.3239 | 3.3239 | 3.3225 | 3.3225 | 17080.0 |
| 2009-01-29 09:07:00 | AAPL | Stock | 3.3246 | 3.3246 | 3.3232 | 3.3232 | 17948.0 |
> showing 50 of 916,376 rows — these rows as CSV