PREVIEW / stock_1min / 2009-11-25
file: by_date/stock_1min/2009/2009-11-25.parquet size: 11.5 MB rows: 875,441 symbols: 2,774
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-11-25 04:15:00 | AAPL | Stock | 7.2996 | 7.2996 | 7.2996 | 7.2996 | 2800.0 |
| 2009-11-25 04:59:00 | AAPL | Stock | 7.3546 | 7.3546 | 7.3546 | 7.3546 | 2800.0 |
| 2009-11-25 06:52:00 | AAPL | Stock | 7.3564 | 7.3564 | 7.3564 | 7.3564 | 2800.0 |
| 2009-11-25 07:01:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3375 | 7.3375 | 4060.0 |
| 2009-11-25 07:06:00 | AAPL | Stock | 7.3307 | 7.3307 | 7.3304 | 7.3304 | 19600.0 |
| 2009-11-25 07:11:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 2800.0 |
| 2009-11-25 07:13:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3214 | 7.3214 | 5600.0 |
| 2009-11-25 07:14:00 | AAPL | Stock | 7.3232 | 7.3232 | 7.3232 | 7.3232 | 14000.0 |
| 2009-11-25 07:16:00 | AAPL | Stock | 7.3218 | 7.3218 | 7.3218 | 7.3218 | 2800.0 |
| 2009-11-25 07:17:00 | AAPL | Stock | 7.3232 | 7.3232 | 7.3232 | 7.3232 | 2800.0 |
| 2009-11-25 07:24:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 14000.0 |
| 2009-11-25 07:26:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 11200.0 |
| 2009-11-25 07:29:00 | AAPL | Stock | 7.3268 | 7.3268 | 7.3268 | 7.3268 | 28000.0 |
| 2009-11-25 07:30:00 | AAPL | Stock | 7.3286 | 7.3286 | 7.3286 | 7.3286 | 16800.0 |
| 2009-11-25 07:31:00 | AAPL | Stock | 7.3286 | 7.3286 | 7.3286 | 7.3286 | 11200.0 |
| 2009-11-25 07:33:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 14000.0 |
| 2009-11-25 07:34:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 3892.0 |
| 2009-11-25 07:37:00 | AAPL | Stock | 7.3304 | 7.3321 | 7.325 | 7.325 | 22708.0 |
| 2009-11-25 07:45:00 | AAPL | Stock | 7.33 | 7.33 | 7.33 | 7.33 | 2800.0 |
| 2009-11-25 07:55:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 2800.0 |
| 2009-11-25 07:56:00 | AAPL | Stock | 7.3318 | 7.3318 | 7.3318 | 7.3318 | 5600.0 |
| 2009-11-25 07:57:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 8400.0 |
| 2009-11-25 07:59:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 4956.0 |
| 2009-11-25 08:00:00 | AAPL | Stock | 7.3321 | 7.3411 | 7.3304 | 7.3411 | 294364.0 |
| 2009-11-25 08:01:00 | AAPL | Stock | 7.3393 | 7.3429 | 7.3393 | 7.3421 | 148764.0 |
| 2009-11-25 08:02:00 | AAPL | Stock | 7.3411 | 7.3429 | 7.3393 | 7.3393 | 88760.0 |
| 2009-11-25 08:03:00 | AAPL | Stock | 7.3414 | 7.3443 | 7.3404 | 7.3404 | 16380.0 |
| 2009-11-25 08:05:00 | AAPL | Stock | 7.3418 | 7.3418 | 7.3418 | 7.3418 | 5600.0 |
| 2009-11-25 08:06:00 | AAPL | Stock | 7.3389 | 7.3389 | 7.3339 | 7.3339 | 5600.0 |
| 2009-11-25 08:07:00 | AAPL | Stock | 7.3343 | 7.3343 | 7.3304 | 7.3304 | 41020.0 |
| 2009-11-25 08:08:00 | AAPL | Stock | 7.33 | 7.3332 | 7.3286 | 7.3332 | 56224.0 |
| 2009-11-25 08:09:00 | AAPL | Stock | 7.3332 | 7.3332 | 7.3286 | 7.3304 | 133364.0 |
| 2009-11-25 08:10:00 | AAPL | Stock | 7.3321 | 7.335 | 7.3304 | 7.3321 | 187880.0 |
| 2009-11-25 08:12:00 | AAPL | Stock | 7.3275 | 7.3275 | 7.3271 | 7.3271 | 16800.0 |
| 2009-11-25 08:14:00 | AAPL | Stock | 7.3275 | 7.3318 | 7.3271 | 7.3318 | 19600.0 |
| 2009-11-25 08:15:00 | AAPL | Stock | 7.3275 | 7.3275 | 7.3271 | 7.3271 | 8400.0 |
| 2009-11-25 08:16:00 | AAPL | Stock | 7.3293 | 7.3293 | 7.3286 | 7.3286 | 32116.0 |
| 2009-11-25 08:18:00 | AAPL | Stock | 7.33 | 7.33 | 7.3286 | 7.3286 | 32284.0 |
| 2009-11-25 08:19:00 | AAPL | Stock | 7.3314 | 7.3318 | 7.3275 | 7.3318 | 48888.0 |
| 2009-11-25 08:21:00 | AAPL | Stock | 7.3271 | 7.3271 | 7.3271 | 7.3271 | 8400.0 |
| 2009-11-25 08:22:00 | AAPL | Stock | 7.3279 | 7.3286 | 7.325 | 7.3268 | 36120.0 |
| 2009-11-25 08:23:00 | AAPL | Stock | 7.3282 | 7.3282 | 7.3282 | 7.3282 | 5600.0 |
| 2009-11-25 08:24:00 | AAPL | Stock | 7.3286 | 7.3286 | 7.3286 | 7.3286 | 5600.0 |
| 2009-11-25 08:25:00 | AAPL | Stock | 7.3286 | 7.3286 | 7.3286 | 7.3286 | 25200.0 |
| 2009-11-25 08:26:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 11200.0 |
| 2009-11-25 08:27:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 13020.0 |
| 2009-11-25 08:28:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 8288.0 |
| 2009-11-25 08:29:00 | AAPL | Stock | 7.3268 | 7.3268 | 7.3268 | 7.3268 | 2800.0 |
| 2009-11-25 08:30:00 | AAPL | Stock | 7.3321 | 7.3393 | 7.3304 | 7.3393 | 321160.0 |
| 2009-11-25 08:31:00 | AAPL | Stock | 7.3389 | 7.3393 | 7.3268 | 7.3321 | 138880.0 |
> showing 50 of 875,441 rows — these rows as CSV