PREVIEW / stock_1min / 2009-10-23
file: by_date/stock_1min/2009/2009-10-23.parquet size: 12.8 MB rows: 967,965 symbols: 2,739
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-10-23 04:15:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3214 | 7.3214 | 2800.0 |
| 2009-10-23 05:00:00 | AAPL | Stock | 7.3057 | 7.3057 | 7.3057 | 7.3057 | 2800.0 |
| 2009-10-23 05:17:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 5600.0 |
| 2009-10-23 05:28:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 2800.0 |
| 2009-10-23 06:26:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3375 | 7.3375 | 14000.0 |
| 2009-10-23 06:33:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3357 | 7.3357 | 2800.0 |
| 2009-10-23 06:34:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3357 | 7.3357 | 4564.0 |
| 2009-10-23 06:56:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 2800.0 |
| 2009-10-23 07:01:00 | AAPL | Stock | 7.3286 | 7.3321 | 7.3286 | 7.3321 | 19600.0 |
| 2009-10-23 07:11:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3357 | 7.3357 | 5600.0 |
| 2009-10-23 07:15:00 | AAPL | Stock | 7.3443 | 7.3443 | 7.3443 | 7.3443 | 2800.0 |
| 2009-10-23 07:16:00 | AAPL | Stock | 7.3443 | 7.3443 | 7.3443 | 7.3443 | 20244.0 |
| 2009-10-23 07:17:00 | AAPL | Stock | 7.3443 | 7.3443 | 7.3443 | 7.3443 | 2800.0 |
| 2009-10-23 07:19:00 | AAPL | Stock | 7.3568 | 7.3571 | 7.3568 | 7.3568 | 23660.0 |
| 2009-10-23 07:22:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 14000.0 |
| 2009-10-23 07:23:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-10-23 07:24:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 5600.0 |
| 2009-10-23 07:25:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3511 | 7.3511 | 5600.0 |
| 2009-10-23 07:31:00 | AAPL | Stock | 7.3546 | 7.3568 | 7.3482 | 7.3546 | 57400.0 |
| 2009-10-23 07:32:00 | AAPL | Stock | 7.3564 | 7.3564 | 7.3479 | 7.3479 | 5600.0 |
| 2009-10-23 07:35:00 | AAPL | Stock | 7.3479 | 7.3479 | 7.3479 | 7.3479 | 5600.0 |
| 2009-10-23 07:37:00 | AAPL | Stock | 7.3479 | 7.3479 | 7.3479 | 7.3479 | 2800.0 |
| 2009-10-23 07:39:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 2800.0 |
| 2009-10-23 07:41:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 14000.0 |
| 2009-10-23 07:42:00 | AAPL | Stock | 7.3543 | 7.3543 | 7.3543 | 7.3543 | 11200.0 |
| 2009-10-23 07:55:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-10-23 07:59:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 11200.0 |
| 2009-10-23 08:00:00 | AAPL | Stock | 7.3564 | 7.3568 | 7.35 | 7.3561 | 62244.0 |
| 2009-10-23 08:01:00 | AAPL | Stock | 7.3554 | 7.3554 | 7.3554 | 7.3554 | 2800.0 |
| 2009-10-23 08:02:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-10-23 08:03:00 | AAPL | Stock | 7.3514 | 7.3514 | 7.3514 | 7.3514 | 2800.0 |
| 2009-10-23 08:04:00 | AAPL | Stock | 7.3514 | 7.3514 | 7.3461 | 7.3464 | 16800.0 |
| 2009-10-23 08:07:00 | AAPL | Stock | 7.3471 | 7.3471 | 7.3361 | 7.3361 | 42280.0 |
| 2009-10-23 08:08:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3339 | 7.3339 | 26600.0 |
| 2009-10-23 08:09:00 | AAPL | Stock | 7.3321 | 7.3339 | 7.3279 | 7.3286 | 41020.0 |
| 2009-10-23 08:10:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 5600.0 |
| 2009-10-23 08:11:00 | AAPL | Stock | 7.3246 | 7.3275 | 7.3246 | 7.3275 | 57400.0 |
| 2009-10-23 08:12:00 | AAPL | Stock | 7.3275 | 7.3275 | 7.3257 | 7.3257 | 11200.0 |
| 2009-10-23 08:13:00 | AAPL | Stock | 7.3304 | 7.3375 | 7.3279 | 7.3375 | 112280.0 |
| 2009-10-23 08:14:00 | AAPL | Stock | 7.3389 | 7.3393 | 7.3375 | 7.3375 | 8400.0 |
| 2009-10-23 08:15:00 | AAPL | Stock | 7.3375 | 7.3446 | 7.3368 | 7.3446 | 32200.0 |
| 2009-10-23 08:16:00 | AAPL | Stock | 7.3446 | 7.3468 | 7.3429 | 7.3446 | 64400.0 |
| 2009-10-23 08:17:00 | AAPL | Stock | 7.3446 | 7.3468 | 7.3446 | 7.3446 | 11900.0 |
| 2009-10-23 08:18:00 | AAPL | Stock | 7.3429 | 7.3429 | 7.3427 | 7.3429 | 126420.0 |
| 2009-10-23 08:19:00 | AAPL | Stock | 7.3418 | 7.3418 | 7.3321 | 7.3321 | 39480.0 |
| 2009-10-23 08:21:00 | AAPL | Stock | 7.3407 | 7.3425 | 7.3407 | 7.3425 | 19600.0 |
| 2009-10-23 08:22:00 | AAPL | Stock | 7.3412 | 7.3432 | 7.3393 | 7.3432 | 29400.0 |
| 2009-10-23 08:24:00 | AAPL | Stock | 7.3379 | 7.3379 | 7.3329 | 7.3329 | 25200.0 |
| 2009-10-23 08:25:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 30800.0 |
| 2009-10-23 08:26:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3304 | 7.3304 | 32480.0 |
> showing 50 of 967,965 rows — these rows as CSV