PREVIEW / stock_1min / 2008-11-14
file: by_date/stock_1min/2008/2008-11-14.parquet size: 12.3 MB rows: 986,107 symbols: 2,688
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-14 07:03:00 | AAPL | Stock | 3.4071 | 3.4071 | 3.4071 | 3.4071 | 2800.0 |
| 2008-11-14 07:30:00 | AAPL | Stock | 3.3789 | 3.3789 | 3.3789 | 3.3789 | 2800.0 |
| 2008-11-14 08:00:00 | AAPL | Stock | 3.3954 | 3.4039 | 3.3879 | 3.3932 | 90692.0 |
| 2008-11-14 08:01:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3875 | 3.3875 | 62272.0 |
| 2008-11-14 08:02:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3893 | 3.3893 | 77280.0 |
| 2008-11-14 08:03:00 | AAPL | Stock | 3.3839 | 3.3896 | 3.3786 | 3.3839 | 48916.0 |
| 2008-11-14 08:04:00 | AAPL | Stock | 3.3839 | 3.3839 | 3.3761 | 3.3761 | 74200.0 |
| 2008-11-14 08:05:00 | AAPL | Stock | 3.3761 | 3.3786 | 3.3679 | 3.3679 | 38696.0 |
| 2008-11-14 08:06:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.3518 | 3.3571 | 318220.0 |
| 2008-11-14 08:07:00 | AAPL | Stock | 3.3521 | 3.3571 | 3.3461 | 3.3461 | 28756.0 |
| 2008-11-14 08:08:00 | AAPL | Stock | 3.3521 | 3.3571 | 3.3489 | 3.3489 | 51800.0 |
| 2008-11-14 08:09:00 | AAPL | Stock | 3.3532 | 3.3579 | 3.3532 | 3.3579 | 342104.0 |
| 2008-11-14 08:10:00 | AAPL | Stock | 3.3593 | 3.3593 | 3.3582 | 3.3582 | 14000.0 |
| 2008-11-14 08:11:00 | AAPL | Stock | 3.3589 | 3.3711 | 3.3589 | 3.3661 | 156520.0 |
| 2008-11-14 08:12:00 | AAPL | Stock | 3.3679 | 3.3714 | 3.3661 | 3.37 | 169400.0 |
| 2008-11-14 08:13:00 | AAPL | Stock | 3.37 | 3.3714 | 3.3679 | 3.3714 | 73360.0 |
| 2008-11-14 08:14:00 | AAPL | Stock | 3.37 | 3.375 | 3.37 | 3.375 | 28000.0 |
| 2008-11-14 08:15:00 | AAPL | Stock | 3.3829 | 3.3829 | 3.375 | 3.375 | 14000.0 |
| 2008-11-14 08:16:00 | AAPL | Stock | 3.375 | 3.3825 | 3.37 | 3.37 | 121800.0 |
| 2008-11-14 08:17:00 | AAPL | Stock | 3.37 | 3.37 | 3.3589 | 3.3589 | 57624.0 |
| 2008-11-14 08:18:00 | AAPL | Stock | 3.3589 | 3.3589 | 3.3536 | 3.3571 | 129696.0 |
| 2008-11-14 08:19:00 | AAPL | Stock | 3.3643 | 3.3746 | 3.3643 | 3.3732 | 43400.0 |
| 2008-11-14 08:20:00 | AAPL | Stock | 3.3643 | 3.3732 | 3.3643 | 3.3671 | 19572.0 |
| 2008-11-14 08:21:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.35 | 3.35 | 130872.0 |
| 2008-11-14 08:22:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3457 | 3.3464 | 199052.0 |
| 2008-11-14 08:23:00 | AAPL | Stock | 3.3518 | 3.3521 | 3.35 | 3.35 | 33600.0 |
| 2008-11-14 08:24:00 | AAPL | Stock | 3.3604 | 3.3607 | 3.3571 | 3.3607 | 138432.0 |
| 2008-11-14 08:25:00 | AAPL | Stock | 3.3593 | 3.3625 | 3.3571 | 3.3625 | 100800.0 |
| 2008-11-14 08:26:00 | AAPL | Stock | 3.3571 | 3.3625 | 3.3571 | 3.3625 | 43316.0 |
| 2008-11-14 08:27:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 4620.0 |
| 2008-11-14 08:28:00 | AAPL | Stock | 3.3593 | 3.3593 | 3.3568 | 3.3571 | 87640.0 |
| 2008-11-14 08:29:00 | AAPL | Stock | 3.3575 | 3.3575 | 3.3393 | 3.3554 | 182840.0 |
| 2008-11-14 08:30:00 | AAPL | Stock | 3.3536 | 3.3607 | 3.3536 | 3.3571 | 75600.0 |
| 2008-11-14 08:31:00 | AAPL | Stock | 3.3532 | 3.3557 | 3.3532 | 3.3557 | 27580.0 |
| 2008-11-14 08:32:00 | AAPL | Stock | 3.3557 | 3.3593 | 3.3557 | 3.3593 | 229320.0 |
| 2008-11-14 08:33:00 | AAPL | Stock | 3.3654 | 3.3721 | 3.3643 | 3.3696 | 64120.0 |
| 2008-11-14 08:34:00 | AAPL | Stock | 3.3643 | 3.3675 | 3.3643 | 3.3643 | 25228.0 |
| 2008-11-14 08:35:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 15092.0 |
| 2008-11-14 08:36:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 2800.0 |
| 2008-11-14 08:38:00 | AAPL | Stock | 3.3643 | 3.3671 | 3.3596 | 3.3636 | 59276.0 |
| 2008-11-14 08:39:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3582 | 3.3582 | 8400.0 |
| 2008-11-14 08:40:00 | AAPL | Stock | 3.3589 | 3.3593 | 3.3571 | 3.3571 | 28000.0 |
| 2008-11-14 08:41:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3571 | 3.3571 | 58352.0 |
| 2008-11-14 08:42:00 | AAPL | Stock | 3.3571 | 3.3582 | 3.3571 | 3.3571 | 40600.0 |
| 2008-11-14 08:43:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3554 | 3.3554 | 30800.0 |
| 2008-11-14 08:44:00 | AAPL | Stock | 3.3546 | 3.3546 | 3.3546 | 3.3546 | 2800.0 |
| 2008-11-14 08:46:00 | AAPL | Stock | 3.3582 | 3.3582 | 3.3571 | 3.3571 | 83720.0 |
| 2008-11-14 08:47:00 | AAPL | Stock | 3.3582 | 3.3596 | 3.3575 | 3.3596 | 15400.0 |
| 2008-11-14 08:48:00 | AAPL | Stock | 3.3571 | 3.3607 | 3.3571 | 3.3607 | 100800.0 |
| 2008-11-14 08:49:00 | AAPL | Stock | 3.3607 | 3.3614 | 3.3604 | 3.3614 | 19600.0 |
> showing 50 of 986,107 rows — these rows as CSV