PREVIEW / stock_1min / 2007-07-03
file: by_date/stock_1min/2007/2007-07-03.parquet size: 6.3 MB rows: 506,203 symbols: 2,459
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-03 09:30:00 | AAPL | Stock | 4.3571 | 4.3575 | 4.3529 | 4.3554 | 5795748.0 |
| 2007-07-03 09:31:00 | AAPL | Stock | 4.3554 | 4.3571 | 4.3443 | 4.3443 | 4549076.0 |
| 2007-07-03 09:32:00 | AAPL | Stock | 4.3457 | 4.3568 | 4.3411 | 4.3475 | 3953656.0 |
| 2007-07-03 09:33:00 | AAPL | Stock | 4.3479 | 4.3496 | 4.3411 | 4.3496 | 3098452.0 |
| 2007-07-03 09:34:00 | AAPL | Stock | 4.3496 | 4.35 | 4.3481 | 4.3493 | 3076304.0 |
| 2007-07-03 09:35:00 | AAPL | Stock | 4.3489 | 4.35 | 4.3396 | 4.3396 | 3304112.0 |
| 2007-07-03 09:36:00 | AAPL | Stock | 4.3396 | 4.3436 | 4.3393 | 4.3418 | 2803752.0 |
| 2007-07-03 09:37:00 | AAPL | Stock | 4.3418 | 4.3536 | 4.3414 | 4.3514 | 3123652.0 |
| 2007-07-03 09:38:00 | AAPL | Stock | 4.35 | 4.3518 | 4.3464 | 4.3479 | 2629480.0 |
| 2007-07-03 09:39:00 | AAPL | Stock | 4.3475 | 4.3518 | 4.3473 | 4.3514 | 4321940.0 |
| 2007-07-03 09:40:00 | AAPL | Stock | 4.3518 | 4.355 | 4.3486 | 4.3525 | 6632556.0 |
| 2007-07-03 09:41:00 | AAPL | Stock | 4.3529 | 4.3536 | 4.3493 | 4.3518 | 2897440.0 |
| 2007-07-03 09:42:00 | AAPL | Stock | 4.3518 | 4.3539 | 4.3468 | 4.3475 | 4459168.0 |
| 2007-07-03 09:43:00 | AAPL | Stock | 4.3475 | 4.3514 | 4.3446 | 4.3496 | 2659300.0 |
| 2007-07-03 09:44:00 | AAPL | Stock | 4.3493 | 4.3507 | 4.3493 | 4.3493 | 1148504.0 |
| 2007-07-03 09:45:00 | AAPL | Stock | 4.3496 | 4.3514 | 4.3482 | 4.3482 | 4077780.0 |
| 2007-07-03 09:46:00 | AAPL | Stock | 4.3482 | 4.3486 | 4.3439 | 4.3457 | 2829232.0 |
| 2007-07-03 09:47:00 | AAPL | Stock | 4.3457 | 4.3514 | 4.345 | 4.3482 | 2017848.0 |
| 2007-07-03 09:48:00 | AAPL | Stock | 4.3482 | 4.3525 | 4.3482 | 4.3507 | 2009896.0 |
| 2007-07-03 09:49:00 | AAPL | Stock | 4.3507 | 4.3543 | 4.3504 | 4.3518 | 4793040.0 |
| 2007-07-03 09:50:00 | AAPL | Stock | 4.3521 | 4.3539 | 4.3512 | 4.3536 | 2345000.0 |
| 2007-07-03 09:51:00 | AAPL | Stock | 4.3536 | 4.3543 | 4.3518 | 4.3532 | 2466436.0 |
| 2007-07-03 09:52:00 | AAPL | Stock | 4.3536 | 4.3607 | 4.3532 | 4.3578 | 10736096.0 |
| 2007-07-03 09:53:00 | AAPL | Stock | 4.3578 | 4.3579 | 4.3536 | 4.355 | 4841620.0 |
| 2007-07-03 09:54:00 | AAPL | Stock | 4.3561 | 4.3732 | 4.3544 | 4.3714 | 10961664.0 |
| 2007-07-03 09:55:00 | AAPL | Stock | 4.3711 | 4.3721 | 4.3682 | 4.3694 | 9049852.0 |
| 2007-07-03 09:56:00 | AAPL | Stock | 4.3696 | 4.3696 | 4.3657 | 4.3686 | 3515120.0 |
| 2007-07-03 09:57:00 | AAPL | Stock | 4.3686 | 4.3711 | 4.3679 | 4.3704 | 2966488.0 |
| 2007-07-03 09:58:00 | AAPL | Stock | 4.3704 | 4.3707 | 4.365 | 4.3675 | 4323816.0 |
| 2007-07-03 09:59:00 | AAPL | Stock | 4.3675 | 4.3746 | 4.3671 | 4.3725 | 5032664.0 |
| 2007-07-03 10:00:00 | AAPL | Stock | 4.3721 | 4.3743 | 4.3661 | 4.3714 | 5596304.0 |
| 2007-07-03 10:01:00 | AAPL | Stock | 4.3713 | 4.3782 | 4.3689 | 4.3775 | 6621720.0 |
| 2007-07-03 10:02:00 | AAPL | Stock | 4.3775 | 4.3839 | 4.3771 | 4.3818 | 8947708.0 |
| 2007-07-03 10:03:00 | AAPL | Stock | 4.3818 | 4.3868 | 4.38 | 4.3864 | 6262592.0 |
| 2007-07-03 10:04:00 | AAPL | Stock | 4.3868 | 4.3886 | 4.3839 | 4.3875 | 4331040.0 |
| 2007-07-03 10:05:00 | AAPL | Stock | 4.3879 | 4.3886 | 4.3786 | 4.3854 | 6549928.0 |
| 2007-07-03 10:06:00 | AAPL | Stock | 4.3854 | 4.4043 | 4.3854 | 4.4029 | 8894732.0 |
| 2007-07-03 10:07:00 | AAPL | Stock | 4.4032 | 4.4125 | 4.3929 | 4.4096 | 11029088.0 |
| 2007-07-03 10:08:00 | AAPL | Stock | 4.4093 | 4.4132 | 4.4057 | 4.4089 | 8329104.0 |
| 2007-07-03 10:09:00 | AAPL | Stock | 4.4086 | 4.4275 | 4.4082 | 4.4267 | 9121728.0 |
| 2007-07-03 10:10:00 | AAPL | Stock | 4.4261 | 4.4396 | 4.4146 | 4.4357 | 17624992.0 |
| 2007-07-03 10:11:00 | AAPL | Stock | 4.4357 | 4.4607 | 4.4339 | 4.4554 | 18728752.0 |
| 2007-07-03 10:12:00 | AAPL | Stock | 4.4554 | 4.4643 | 4.45 | 4.4607 | 17335052.0 |
| 2007-07-03 10:13:00 | AAPL | Stock | 4.4607 | 4.4643 | 4.4521 | 4.4632 | 12966548.0 |
| 2007-07-03 10:14:00 | AAPL | Stock | 4.4632 | 4.4639 | 4.4514 | 4.4614 | 11634896.0 |
| 2007-07-03 10:15:00 | AAPL | Stock | 4.4625 | 4.4625 | 4.4179 | 4.4561 | 10313828.0 |
| 2007-07-03 10:16:00 | AAPL | Stock | 4.4564 | 4.4643 | 4.4493 | 4.4596 | 18158252.0 |
| 2007-07-03 10:17:00 | AAPL | Stock | 4.4593 | 4.461 | 4.4439 | 4.4532 | 10060820.0 |
| 2007-07-03 10:18:00 | AAPL | Stock | 4.4539 | 4.4557 | 4.4514 | 4.4535 | 8858108.0 |
| 2007-07-03 10:19:00 | AAPL | Stock | 4.4535 | 4.4621 | 4.45 | 4.4607 | 11452560.0 |
> showing 50 of 506,203 rows — these rows as CSV