PREVIEW / stock_1min / 2008-06-17
file: by_date/stock_1min/2008/2008-06-17.parquet size: 12.0 MB rows: 973,549 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-17 07:08:00 | AAPL | Stock | 6.3425 | 6.3425 | 6.3425 | 6.3425 | 5600.0 |
| 2008-06-17 07:13:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3518 | 6.3518 | 13440.0 |
| 2008-06-17 07:27:00 | AAPL | Stock | 6.3536 | 6.3536 | 6.3536 | 6.3536 | 2800.0 |
| 2008-06-17 07:36:00 | AAPL | Stock | 6.3461 | 6.3461 | 6.3446 | 6.3446 | 24640.0 |
| 2008-06-17 07:38:00 | AAPL | Stock | 6.3464 | 6.3536 | 6.3464 | 6.3536 | 33600.0 |
| 2008-06-17 07:49:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 25452.0 |
| 2008-06-17 07:50:00 | AAPL | Stock | 6.3446 | 6.3446 | 6.3446 | 6.3446 | 2800.0 |
| 2008-06-17 07:51:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 33600.0 |
| 2008-06-17 07:54:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 30800.0 |
| 2008-06-17 07:55:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3482 | 6.3482 | 56000.0 |
| 2008-06-17 07:56:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 2800.0 |
| 2008-06-17 08:00:00 | AAPL | Stock | 6.3482 | 6.35 | 6.3157 | 6.3464 | 190120.0 |
| 2008-06-17 08:01:00 | AAPL | Stock | 6.3429 | 6.3464 | 6.3429 | 6.3464 | 141120.0 |
| 2008-06-17 08:02:00 | AAPL | Stock | 6.3446 | 6.3464 | 6.3446 | 6.3464 | 33600.0 |
| 2008-06-17 08:03:00 | AAPL | Stock | 6.3446 | 6.3482 | 6.3446 | 6.3446 | 90300.0 |
| 2008-06-17 08:04:00 | AAPL | Stock | 6.3479 | 6.3479 | 6.3471 | 6.3479 | 57540.0 |
| 2008-06-17 08:05:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.345 | 6.3482 | 54040.0 |
| 2008-06-17 08:06:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3454 | 6.3454 | 8400.0 |
| 2008-06-17 08:07:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3393 | 6.3393 | 63700.0 |
| 2008-06-17 08:08:00 | AAPL | Stock | 6.3464 | 6.3479 | 6.3464 | 6.3479 | 16800.0 |
| 2008-06-17 08:09:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3475 | 6.3475 | 27300.0 |
| 2008-06-17 08:10:00 | AAPL | Stock | 6.3482 | 6.35 | 6.3482 | 6.35 | 48216.0 |
| 2008-06-17 08:11:00 | AAPL | Stock | 6.35 | 6.35 | 6.3482 | 6.3482 | 34664.0 |
| 2008-06-17 08:12:00 | AAPL | Stock | 6.35 | 6.3514 | 6.3496 | 6.3514 | 74116.0 |
| 2008-06-17 08:13:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.35 | 6.35 | 11284.0 |
| 2008-06-17 08:14:00 | AAPL | Stock | 6.35 | 6.35 | 6.3464 | 6.3471 | 65548.0 |
| 2008-06-17 08:15:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3446 | 6.3446 | 11200.0 |
| 2008-06-17 08:16:00 | AAPL | Stock | 6.345 | 6.345 | 6.3429 | 6.3429 | 19600.0 |
| 2008-06-17 08:17:00 | AAPL | Stock | 6.3429 | 6.3464 | 6.3393 | 6.3396 | 93576.0 |
| 2008-06-17 08:18:00 | AAPL | Stock | 6.3393 | 6.3414 | 6.3336 | 6.3411 | 56896.0 |
| 2008-06-17 08:19:00 | AAPL | Stock | 6.3421 | 6.3421 | 6.3368 | 6.3375 | 75460.0 |
| 2008-06-17 08:20:00 | AAPL | Stock | 6.3379 | 6.3411 | 6.3379 | 6.3407 | 22456.0 |
| 2008-06-17 08:21:00 | AAPL | Stock | 6.3407 | 6.3425 | 6.3396 | 6.3425 | 55944.0 |
| 2008-06-17 08:22:00 | AAPL | Stock | 6.3418 | 6.3425 | 6.3414 | 6.3421 | 22400.0 |
| 2008-06-17 08:23:00 | AAPL | Stock | 6.3421 | 6.3421 | 6.3407 | 6.3407 | 16800.0 |
| 2008-06-17 08:24:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3393 | 6.3393 | 24584.0 |
| 2008-06-17 08:25:00 | AAPL | Stock | 6.3389 | 6.3443 | 6.3307 | 6.3421 | 370720.0 |
| 2008-06-17 08:26:00 | AAPL | Stock | 6.3307 | 6.3321 | 6.325 | 6.3289 | 129808.0 |
| 2008-06-17 08:27:00 | AAPL | Stock | 6.3321 | 6.3368 | 6.3243 | 6.3257 | 140000.0 |
| 2008-06-17 08:28:00 | AAPL | Stock | 6.3239 | 6.3339 | 6.3214 | 6.3271 | 161308.0 |
| 2008-06-17 08:29:00 | AAPL | Stock | 6.3254 | 6.3404 | 6.3254 | 6.3375 | 535500.0 |
| 2008-06-17 08:30:00 | AAPL | Stock | 6.3375 | 6.3411 | 6.3304 | 6.3393 | 208040.0 |
| 2008-06-17 08:31:00 | AAPL | Stock | 6.3418 | 6.3464 | 6.3418 | 6.3425 | 146300.0 |
| 2008-06-17 08:32:00 | AAPL | Stock | 6.3425 | 6.3429 | 6.3404 | 6.3414 | 134400.0 |
| 2008-06-17 08:33:00 | AAPL | Stock | 6.3414 | 6.3429 | 6.3329 | 6.3368 | 105980.0 |
| 2008-06-17 08:34:00 | AAPL | Stock | 6.3368 | 6.3368 | 6.3354 | 6.3357 | 36400.0 |
| 2008-06-17 08:35:00 | AAPL | Stock | 6.3357 | 6.3375 | 6.3354 | 6.3375 | 50540.0 |
| 2008-06-17 08:36:00 | AAPL | Stock | 6.3375 | 6.3429 | 6.3375 | 6.3429 | 27160.0 |
| 2008-06-17 08:37:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3364 | 6.3389 | 70000.0 |
| 2008-06-17 08:38:00 | AAPL | Stock | 6.345 | 6.345 | 6.3429 | 6.3429 | 30800.0 |
> showing 50 of 973,549 rows — these rows as CSV