PREVIEW / stock_1min / 2011-11-23
file: by_date/stock_1min/2011/2011-11-23.parquet size: 13.0 MB rows: 986,578 symbols: 2,861
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-23 06:30:00 | AAPL | Stock | 13.3421 | 13.3421 | 13.3421 | 13.3421 | 5600.0 |
| 2011-11-23 06:41:00 | AAPL | Stock | 13.3543 | 13.3543 | 13.3543 | 13.3543 | 5600.0 |
| 2011-11-23 06:53:00 | AAPL | Stock | 13.375 | 13.375 | 13.375 | 13.375 | 2800.0 |
| 2011-11-23 07:01:00 | AAPL | Stock | 13.3893 | 13.3893 | 13.3893 | 13.3893 | 4452.0 |
| 2011-11-23 07:02:00 | AAPL | Stock | 13.3679 | 13.3679 | 13.3679 | 13.3679 | 4200.0 |
| 2011-11-23 07:05:00 | AAPL | Stock | 13.3786 | 13.3786 | 13.3679 | 13.3679 | 11200.0 |
| 2011-11-23 07:06:00 | AAPL | Stock | 13.3679 | 13.3679 | 13.3596 | 13.3596 | 18200.0 |
| 2011-11-23 07:09:00 | AAPL | Stock | 13.3614 | 13.3614 | 13.3614 | 13.3614 | 5600.0 |
| 2011-11-23 07:10:00 | AAPL | Stock | 13.3675 | 13.3675 | 13.3675 | 13.3675 | 2800.0 |
| 2011-11-23 07:11:00 | AAPL | Stock | 13.3725 | 13.3739 | 13.3725 | 13.3739 | 5600.0 |
| 2011-11-23 07:14:00 | AAPL | Stock | 13.3714 | 13.3714 | 13.3714 | 13.3714 | 14000.0 |
| 2011-11-23 07:16:00 | AAPL | Stock | 13.3732 | 13.3732 | 13.3714 | 13.3714 | 19600.0 |
| 2011-11-23 07:17:00 | AAPL | Stock | 13.3618 | 13.3836 | 13.3618 | 13.3821 | 30800.0 |
| 2011-11-23 07:18:00 | AAPL | Stock | 13.3636 | 13.3636 | 13.3636 | 13.3636 | 5600.0 |
| 2011-11-23 07:21:00 | AAPL | Stock | 13.3614 | 13.3614 | 13.3614 | 13.3614 | 2800.0 |
| 2011-11-23 07:22:00 | AAPL | Stock | 13.3579 | 13.3579 | 13.3571 | 13.3571 | 8400.0 |
| 2011-11-23 07:24:00 | AAPL | Stock | 13.3571 | 13.3571 | 13.3571 | 13.3571 | 11200.0 |
| 2011-11-23 07:26:00 | AAPL | Stock | 13.3411 | 13.3411 | 13.3411 | 13.3411 | 2800.0 |
| 2011-11-23 07:27:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3393 | 13.3393 | 2800.0 |
| 2011-11-23 07:28:00 | AAPL | Stock | 13.3543 | 13.3543 | 13.3543 | 13.3543 | 2800.0 |
| 2011-11-23 07:31:00 | AAPL | Stock | 13.3464 | 13.3464 | 13.3464 | 13.3464 | 3080.0 |
| 2011-11-23 07:32:00 | AAPL | Stock | 13.3429 | 13.3429 | 13.3429 | 13.3429 | 8400.0 |
| 2011-11-23 07:33:00 | AAPL | Stock | 13.3429 | 13.3471 | 13.3393 | 13.3471 | 18200.0 |
| 2011-11-23 07:34:00 | AAPL | Stock | 13.3429 | 13.3429 | 13.3429 | 13.3429 | 5600.0 |
| 2011-11-23 07:35:00 | AAPL | Stock | 13.3357 | 13.3357 | 13.3357 | 13.3357 | 2800.0 |
| 2011-11-23 07:36:00 | AAPL | Stock | 13.3375 | 13.3429 | 13.3375 | 13.3429 | 13160.0 |
| 2011-11-23 07:38:00 | AAPL | Stock | 13.3482 | 13.3557 | 13.3482 | 13.3557 | 17640.0 |
| 2011-11-23 07:40:00 | AAPL | Stock | 13.3561 | 13.3571 | 13.3561 | 13.3571 | 14000.0 |
| 2011-11-23 07:41:00 | AAPL | Stock | 13.3571 | 13.3571 | 13.3529 | 13.3529 | 58100.0 |
| 2011-11-23 07:42:00 | AAPL | Stock | 13.3529 | 13.3529 | 13.35 | 13.35 | 8400.0 |
| 2011-11-23 07:44:00 | AAPL | Stock | 13.3564 | 13.3568 | 13.3564 | 13.3568 | 5600.0 |
| 2011-11-23 07:45:00 | AAPL | Stock | 13.3564 | 13.3564 | 13.3564 | 13.3564 | 2800.0 |
| 2011-11-23 07:46:00 | AAPL | Stock | 13.3571 | 13.36 | 13.3571 | 13.36 | 14000.0 |
| 2011-11-23 07:51:00 | AAPL | Stock | 13.3439 | 13.3439 | 13.3439 | 13.3439 | 2800.0 |
| 2011-11-23 07:53:00 | AAPL | Stock | 13.3564 | 13.36 | 13.3564 | 13.36 | 22400.0 |
| 2011-11-23 08:00:00 | AAPL | Stock | 13.3554 | 13.3575 | 13.3504 | 13.3568 | 130760.0 |
| 2011-11-23 08:01:00 | AAPL | Stock | 13.3511 | 13.36 | 13.3511 | 13.36 | 54628.0 |
| 2011-11-23 08:02:00 | AAPL | Stock | 13.3721 | 13.3721 | 13.3671 | 13.3675 | 44800.0 |
| 2011-11-23 08:03:00 | AAPL | Stock | 13.3596 | 13.3596 | 13.3596 | 13.3596 | 2800.0 |
| 2011-11-23 08:04:00 | AAPL | Stock | 13.3596 | 13.3643 | 13.3575 | 13.3575 | 33600.0 |
| 2011-11-23 08:05:00 | AAPL | Stock | 13.3557 | 13.3557 | 13.3543 | 13.3543 | 19600.0 |
| 2011-11-23 08:06:00 | AAPL | Stock | 13.3489 | 13.3536 | 13.3482 | 13.3482 | 22120.0 |
| 2011-11-23 08:09:00 | AAPL | Stock | 13.3507 | 13.3507 | 13.3504 | 13.3504 | 7000.0 |
| 2011-11-23 08:10:00 | AAPL | Stock | 13.3518 | 13.3518 | 13.3482 | 13.3482 | 76804.0 |
| 2011-11-23 08:12:00 | AAPL | Stock | 13.3429 | 13.3464 | 13.3243 | 13.3329 | 47012.0 |
| 2011-11-23 08:13:00 | AAPL | Stock | 13.3268 | 13.3393 | 13.3268 | 13.3393 | 16800.0 |
| 2011-11-23 08:15:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3393 | 13.3393 | 26600.0 |
| 2011-11-23 08:16:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3286 | 13.3286 | 34720.0 |
| 2011-11-23 08:17:00 | AAPL | Stock | 13.3289 | 13.3289 | 13.3289 | 13.3289 | 5600.0 |
| 2011-11-23 08:18:00 | AAPL | Stock | 13.3339 | 13.3393 | 13.3289 | 13.3393 | 22400.0 |
> showing 50 of 986,578 rows — these rows as CSV