PREVIEW / stock_1min / 2010-10-06
file: by_date/stock_1min/2010/2010-10-06.parquet size: 12.7 MB rows: 961,387 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-06 04:03:00 | AAPL | Stock | 10.3607 | 10.3607 | 10.3607 | 10.3607 | 4508.0 |
| 2010-10-06 06:05:00 | AAPL | Stock | 10.3821 | 10.3821 | 10.3821 | 10.3821 | 2800.0 |
| 2010-10-06 06:33:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 16800.0 |
| 2010-10-06 06:36:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 5600.0 |
| 2010-10-06 06:39:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 4200.0 |
| 2010-10-06 07:01:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3571 | 10.3571 | 5600.0 |
| 2010-10-06 07:05:00 | AAPL | Stock | 10.3525 | 10.3525 | 10.3525 | 10.3525 | 11200.0 |
| 2010-10-06 07:08:00 | AAPL | Stock | 10.3529 | 10.3571 | 10.3529 | 10.3571 | 14000.0 |
| 2010-10-06 07:11:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3536 | 10.3571 | 22400.0 |
| 2010-10-06 07:12:00 | AAPL | Stock | 10.3646 | 10.3646 | 10.3646 | 10.3646 | 2800.0 |
| 2010-10-06 07:13:00 | AAPL | Stock | 10.3657 | 10.3661 | 10.3657 | 10.3661 | 28000.0 |
| 2010-10-06 07:16:00 | AAPL | Stock | 10.3671 | 10.3671 | 10.3671 | 10.3671 | 2800.0 |
| 2010-10-06 07:18:00 | AAPL | Stock | 10.3575 | 10.3575 | 10.3571 | 10.3571 | 25200.0 |
| 2010-10-06 07:19:00 | AAPL | Stock | 10.3568 | 10.3568 | 10.3568 | 10.3568 | 2800.0 |
| 2010-10-06 07:21:00 | AAPL | Stock | 10.3546 | 10.3546 | 10.3546 | 10.3546 | 11200.0 |
| 2010-10-06 07:25:00 | AAPL | Stock | 10.3518 | 10.3536 | 10.3518 | 10.3536 | 8400.0 |
| 2010-10-06 07:27:00 | AAPL | Stock | 10.3529 | 10.3536 | 10.3529 | 10.3536 | 10360.0 |
| 2010-10-06 07:28:00 | AAPL | Stock | 10.3539 | 10.3539 | 10.3536 | 10.3536 | 14000.0 |
| 2010-10-06 07:30:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3571 | 10.3571 | 21560.0 |
| 2010-10-06 07:31:00 | AAPL | Stock | 10.3571 | 10.3657 | 10.3554 | 10.3657 | 21140.0 |
| 2010-10-06 07:32:00 | AAPL | Stock | 10.3568 | 10.3571 | 10.3568 | 10.3571 | 22400.0 |
| 2010-10-06 07:34:00 | AAPL | Stock | 10.3571 | 10.3643 | 10.3571 | 10.3643 | 8400.0 |
| 2010-10-06 07:36:00 | AAPL | Stock | 10.3657 | 10.375 | 10.3657 | 10.3714 | 53200.0 |
| 2010-10-06 07:38:00 | AAPL | Stock | 10.3732 | 10.375 | 10.3732 | 10.375 | 85400.0 |
| 2010-10-06 07:39:00 | AAPL | Stock | 10.3679 | 10.3679 | 10.3679 | 10.3679 | 2800.0 |
| 2010-10-06 07:46:00 | AAPL | Stock | 10.3704 | 10.3704 | 10.3704 | 10.3704 | 5600.0 |
| 2010-10-06 07:47:00 | AAPL | Stock | 10.3704 | 10.3704 | 10.3675 | 10.3679 | 72800.0 |
| 2010-10-06 07:48:00 | AAPL | Stock | 10.3704 | 10.3707 | 10.3704 | 10.3707 | 5600.0 |
| 2010-10-06 07:49:00 | AAPL | Stock | 10.3732 | 10.3732 | 10.3714 | 10.3714 | 28000.0 |
| 2010-10-06 07:50:00 | AAPL | Stock | 10.3729 | 10.3729 | 10.3729 | 10.3729 | 8400.0 |
| 2010-10-06 07:51:00 | AAPL | Stock | 10.375 | 10.375 | 10.3746 | 10.375 | 89768.0 |
| 2010-10-06 07:52:00 | AAPL | Stock | 10.3757 | 10.3818 | 10.3757 | 10.3811 | 11200.0 |
| 2010-10-06 07:53:00 | AAPL | Stock | 10.3818 | 10.3818 | 10.3746 | 10.3746 | 21700.0 |
| 2010-10-06 07:57:00 | AAPL | Stock | 10.3729 | 10.375 | 10.3729 | 10.375 | 39172.0 |
| 2010-10-06 08:00:00 | AAPL | Stock | 10.3768 | 10.3821 | 10.3571 | 10.3643 | 328188.0 |
| 2010-10-06 08:01:00 | AAPL | Stock | 10.3729 | 10.375 | 10.3661 | 10.375 | 68572.0 |
| 2010-10-06 08:02:00 | AAPL | Stock | 10.3746 | 10.3804 | 10.3746 | 10.3804 | 74732.0 |
| 2010-10-06 08:03:00 | AAPL | Stock | 10.3804 | 10.3807 | 10.3718 | 10.3768 | 118832.0 |
| 2010-10-06 08:04:00 | AAPL | Stock | 10.3768 | 10.3786 | 10.375 | 10.375 | 37044.0 |
| 2010-10-06 08:05:00 | AAPL | Stock | 10.375 | 10.3789 | 10.375 | 10.3789 | 15680.0 |
| 2010-10-06 08:06:00 | AAPL | Stock | 10.3789 | 10.3789 | 10.3789 | 10.3789 | 5600.0 |
| 2010-10-06 08:07:00 | AAPL | Stock | 10.3768 | 10.3768 | 10.3696 | 10.3746 | 100520.0 |
| 2010-10-06 08:08:00 | AAPL | Stock | 10.3721 | 10.3721 | 10.3693 | 10.3693 | 53200.0 |
| 2010-10-06 08:09:00 | AAPL | Stock | 10.3736 | 10.3736 | 10.3689 | 10.3689 | 42644.0 |
| 2010-10-06 08:11:00 | AAPL | Stock | 10.3696 | 10.3739 | 10.3696 | 10.3739 | 60200.0 |
| 2010-10-06 08:12:00 | AAPL | Stock | 10.3739 | 10.375 | 10.3725 | 10.375 | 103964.0 |
| 2010-10-06 08:13:00 | AAPL | Stock | 10.3786 | 10.3796 | 10.3786 | 10.3796 | 14280.0 |
| 2010-10-06 08:14:00 | AAPL | Stock | 10.3768 | 10.3768 | 10.375 | 10.3768 | 108444.0 |
| 2010-10-06 08:15:00 | AAPL | Stock | 10.3725 | 10.3768 | 10.3521 | 10.3521 | 461020.0 |
| 2010-10-06 08:16:00 | AAPL | Stock | 10.3421 | 10.3571 | 10.3421 | 10.3571 | 66220.0 |
> showing 50 of 961,387 rows — these rows as CSV