PREVIEW / stock_1min / 2009-09-16
file: by_date/stock_1min/2009/2009-09-16.parquet size: 13.1 MB rows: 987,826 symbols: 2,759
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-09-16 04:15:00 | AAPL | Stock | 6.3389 | 6.3389 | 6.3354 | 6.3354 | 5600.0 |
| 2009-09-16 04:16:00 | AAPL | Stock | 6.3357 | 6.3357 | 6.3357 | 6.3357 | 2800.0 |
| 2009-09-16 04:18:00 | AAPL | Stock | 6.3389 | 6.3389 | 6.3389 | 6.3389 | 12544.0 |
| 2009-09-16 05:27:00 | AAPL | Stock | 6.3525 | 6.3525 | 6.3525 | 6.3525 | 2800.0 |
| 2009-09-16 05:59:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 2800.0 |
| 2009-09-16 06:21:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 15904.0 |
| 2009-09-16 06:40:00 | AAPL | Stock | 6.3425 | 6.3425 | 6.3425 | 6.3425 | 2800.0 |
| 2009-09-16 06:44:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 2800.0 |
| 2009-09-16 06:46:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3432 | 6.3432 | 5600.0 |
| 2009-09-16 06:47:00 | AAPL | Stock | 6.3439 | 6.3439 | 6.3439 | 6.3439 | 8400.0 |
| 2009-09-16 06:52:00 | AAPL | Stock | 6.3507 | 6.3507 | 6.3507 | 6.3507 | 2800.0 |
| 2009-09-16 06:54:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 2800.0 |
| 2009-09-16 06:56:00 | AAPL | Stock | 6.3611 | 6.3611 | 6.3611 | 6.3611 | 2800.0 |
| 2009-09-16 06:57:00 | AAPL | Stock | 6.3682 | 6.3682 | 6.3646 | 6.3657 | 22400.0 |
| 2009-09-16 06:58:00 | AAPL | Stock | 6.3696 | 6.3714 | 6.3696 | 6.3714 | 5600.0 |
| 2009-09-16 06:59:00 | AAPL | Stock | 6.3729 | 6.3804 | 6.3729 | 6.3804 | 5600.0 |
| 2009-09-16 07:00:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.3696 | 6.3696 | 5600.0 |
| 2009-09-16 07:01:00 | AAPL | Stock | 6.3679 | 6.3679 | 6.3611 | 6.3611 | 23520.0 |
| 2009-09-16 07:04:00 | AAPL | Stock | 6.3675 | 6.3696 | 6.3675 | 6.3696 | 34468.0 |
| 2009-09-16 07:05:00 | AAPL | Stock | 6.3679 | 6.3679 | 6.3679 | 6.3679 | 5600.0 |
| 2009-09-16 07:06:00 | AAPL | Stock | 6.3643 | 6.3643 | 6.3625 | 6.3639 | 42000.0 |
| 2009-09-16 07:07:00 | AAPL | Stock | 6.3629 | 6.3632 | 6.3625 | 6.3625 | 32200.0 |
| 2009-09-16 07:08:00 | AAPL | Stock | 6.3689 | 6.3689 | 6.3625 | 6.3625 | 8372.0 |
| 2009-09-16 07:10:00 | AAPL | Stock | 6.3625 | 6.3625 | 6.3611 | 6.3611 | 22400.0 |
| 2009-09-16 07:13:00 | AAPL | Stock | 6.3579 | 6.3582 | 6.3579 | 6.3579 | 21392.0 |
| 2009-09-16 07:14:00 | AAPL | Stock | 6.3579 | 6.3579 | 6.3579 | 6.3579 | 14000.0 |
| 2009-09-16 07:17:00 | AAPL | Stock | 6.3532 | 6.3532 | 6.3525 | 6.3525 | 42056.0 |
| 2009-09-16 07:19:00 | AAPL | Stock | 6.3514 | 6.3514 | 6.3514 | 6.3514 | 3864.0 |
| 2009-09-16 07:20:00 | AAPL | Stock | 6.3507 | 6.3536 | 6.3507 | 6.3532 | 14000.0 |
| 2009-09-16 07:21:00 | AAPL | Stock | 6.355 | 6.355 | 6.355 | 6.355 | 14868.0 |
| 2009-09-16 07:22:00 | AAPL | Stock | 6.3554 | 6.3554 | 6.3518 | 6.3536 | 42000.0 |
| 2009-09-16 07:23:00 | AAPL | Stock | 6.3536 | 6.3536 | 6.3518 | 6.3518 | 11200.0 |
| 2009-09-16 07:24:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3518 | 6.3518 | 49140.0 |
| 2009-09-16 07:25:00 | AAPL | Stock | 6.3511 | 6.3511 | 6.35 | 6.35 | 11200.0 |
| 2009-09-16 07:28:00 | AAPL | Stock | 6.3543 | 6.3543 | 6.3543 | 6.3543 | 2800.0 |
| 2009-09-16 07:29:00 | AAPL | Stock | 6.3579 | 6.3579 | 6.3536 | 6.3536 | 30240.0 |
| 2009-09-16 07:30:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3389 | 6.3393 | 188048.0 |
| 2009-09-16 07:31:00 | AAPL | Stock | 6.3393 | 6.3396 | 6.3393 | 6.3393 | 159264.0 |
| 2009-09-16 07:32:00 | AAPL | Stock | 6.3411 | 6.3411 | 6.3411 | 6.3411 | 2800.0 |
| 2009-09-16 07:33:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3393 | 6.3425 | 66612.0 |
| 2009-09-16 07:34:00 | AAPL | Stock | 6.3371 | 6.3371 | 6.3371 | 6.3371 | 5600.0 |
| 2009-09-16 07:35:00 | AAPL | Stock | 6.34 | 6.34 | 6.34 | 6.34 | 2800.0 |
| 2009-09-16 07:37:00 | AAPL | Stock | 6.3379 | 6.3379 | 6.3354 | 6.3354 | 44800.0 |
| 2009-09-16 07:38:00 | AAPL | Stock | 6.335 | 6.3354 | 6.335 | 6.3354 | 5628.0 |
| 2009-09-16 07:40:00 | AAPL | Stock | 6.3361 | 6.3393 | 6.3361 | 6.3393 | 14000.0 |
| 2009-09-16 07:41:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 5600.0 |
| 2009-09-16 07:42:00 | AAPL | Stock | 6.3375 | 6.3411 | 6.3375 | 6.3411 | 46648.0 |
| 2009-09-16 07:43:00 | AAPL | Stock | 6.3411 | 6.3443 | 6.3411 | 6.3443 | 8540.0 |
| 2009-09-16 07:45:00 | AAPL | Stock | 6.3443 | 6.3446 | 6.3393 | 6.3393 | 79660.0 |
| 2009-09-16 07:46:00 | AAPL | Stock | 6.3361 | 6.3389 | 6.3357 | 6.3357 | 25200.0 |
> showing 50 of 987,826 rows — these rows as CSV