PREVIEW / stock_1min / 2007-08-10
file: by_date/stock_1min/2007/2007-08-10.parquet size: 14.2 MB rows: 1,115,763 symbols: 2,562
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-08-10 09:30:00 | AAPL | Stock | 4.3971 | 4.4089 | 4.3393 | 4.3471 | 33391540.0 |
| 2007-08-10 09:31:00 | AAPL | Stock | 4.3421 | 4.3963 | 4.3396 | 4.377 | 15017968.0 |
| 2007-08-10 09:32:00 | AAPL | Stock | 4.3814 | 4.3879 | 4.3536 | 4.3629 | 9889936.0 |
| 2007-08-10 09:33:00 | AAPL | Stock | 4.3629 | 4.3889 | 4.3571 | 4.3879 | 6677720.0 |
| 2007-08-10 09:34:00 | AAPL | Stock | 4.3868 | 4.4132 | 4.3864 | 4.4129 | 11291476.0 |
| 2007-08-10 09:35:00 | AAPL | Stock | 4.4118 | 4.4171 | 4.3879 | 4.39 | 7972020.0 |
| 2007-08-10 09:36:00 | AAPL | Stock | 4.3896 | 4.4029 | 4.3825 | 4.3854 | 6018040.0 |
| 2007-08-10 09:37:00 | AAPL | Stock | 4.3843 | 4.4104 | 4.3825 | 4.3929 | 8061984.0 |
| 2007-08-10 09:38:00 | AAPL | Stock | 4.3932 | 4.4064 | 4.3825 | 4.3914 | 4680200.0 |
| 2007-08-10 09:39:00 | AAPL | Stock | 4.3914 | 4.3986 | 4.3775 | 4.3896 | 6124608.0 |
| 2007-08-10 09:40:00 | AAPL | Stock | 4.3911 | 4.3929 | 4.3571 | 4.3621 | 6543544.0 |
| 2007-08-10 09:41:00 | AAPL | Stock | 4.3618 | 4.3625 | 4.3414 | 4.3504 | 8076264.0 |
| 2007-08-10 09:42:00 | AAPL | Stock | 4.35 | 4.3636 | 4.3457 | 4.3629 | 7745724.0 |
| 2007-08-10 09:43:00 | AAPL | Stock | 4.3629 | 4.3761 | 4.3607 | 4.375 | 6990508.0 |
| 2007-08-10 09:44:00 | AAPL | Stock | 4.3761 | 4.3771 | 4.3482 | 4.3493 | 5359032.0 |
| 2007-08-10 09:45:00 | AAPL | Stock | 4.3482 | 4.3618 | 4.3468 | 4.3589 | 4731188.0 |
| 2007-08-10 09:46:00 | AAPL | Stock | 4.3589 | 4.3886 | 4.3579 | 4.3789 | 4878132.0 |
| 2007-08-10 09:47:00 | AAPL | Stock | 4.3857 | 4.3871 | 4.3668 | 4.3718 | 4375700.0 |
| 2007-08-10 09:48:00 | AAPL | Stock | 4.3729 | 4.3786 | 4.3625 | 4.3732 | 1584716.0 |
| 2007-08-10 09:49:00 | AAPL | Stock | 4.3732 | 4.3929 | 4.3732 | 4.3929 | 3182452.0 |
| 2007-08-10 09:50:00 | AAPL | Stock | 4.3929 | 4.4018 | 4.3879 | 4.4018 | 4448164.0 |
| 2007-08-10 09:51:00 | AAPL | Stock | 4.4007 | 4.4154 | 4.3996 | 4.4125 | 5573372.0 |
| 2007-08-10 09:52:00 | AAPL | Stock | 4.4129 | 4.4139 | 4.3957 | 4.4054 | 7496944.0 |
| 2007-08-10 09:53:00 | AAPL | Stock | 4.4054 | 4.4129 | 4.4011 | 4.4054 | 4827340.0 |
| 2007-08-10 09:54:00 | AAPL | Stock | 4.4057 | 4.4236 | 4.3979 | 4.4229 | 7212212.0 |
| 2007-08-10 09:55:00 | AAPL | Stock | 4.4232 | 4.4232 | 4.3989 | 4.4021 | 4908624.0 |
| 2007-08-10 09:56:00 | AAPL | Stock | 4.4011 | 4.4125 | 4.3929 | 4.3932 | 4200980.0 |
| 2007-08-10 09:57:00 | AAPL | Stock | 4.3929 | 4.4004 | 4.3807 | 4.3989 | 5911892.0 |
| 2007-08-10 09:58:00 | AAPL | Stock | 4.3989 | 4.4036 | 4.3875 | 4.3954 | 3581032.0 |
| 2007-08-10 09:59:00 | AAPL | Stock | 4.395 | 4.3975 | 4.3821 | 4.3889 | 3290476.0 |
| 2007-08-10 10:00:00 | AAPL | Stock | 4.3889 | 4.4007 | 4.3836 | 4.3946 | 4280808.0 |
| 2007-08-10 10:01:00 | AAPL | Stock | 4.3943 | 4.3975 | 4.3818 | 4.3861 | 4840220.0 |
| 2007-08-10 10:02:00 | AAPL | Stock | 4.3832 | 4.3936 | 4.3821 | 4.3875 | 2945964.0 |
| 2007-08-10 10:03:00 | AAPL | Stock | 4.3875 | 4.3886 | 4.3675 | 4.3754 | 4397680.0 |
| 2007-08-10 10:04:00 | AAPL | Stock | 4.3754 | 4.3757 | 4.3536 | 4.3546 | 5972176.0 |
| 2007-08-10 10:05:00 | AAPL | Stock | 4.3546 | 4.3693 | 4.35 | 4.3536 | 5171404.0 |
| 2007-08-10 10:06:00 | AAPL | Stock | 4.3554 | 4.3618 | 4.3532 | 4.3571 | 3228512.0 |
| 2007-08-10 10:07:00 | AAPL | Stock | 4.3571 | 4.3607 | 4.3536 | 4.3579 | 2434964.0 |
| 2007-08-10 10:08:00 | AAPL | Stock | 4.3571 | 4.3639 | 4.3571 | 4.3621 | 1299816.0 |
| 2007-08-10 10:09:00 | AAPL | Stock | 4.3611 | 4.3639 | 4.3514 | 4.3519 | 1036140.0 |
| 2007-08-10 10:10:00 | AAPL | Stock | 4.3518 | 4.3836 | 4.3514 | 4.3786 | 6968276.0 |
| 2007-08-10 10:11:00 | AAPL | Stock | 4.3796 | 4.3868 | 4.3718 | 4.375 | 3779300.0 |
| 2007-08-10 10:12:00 | AAPL | Stock | 4.3754 | 4.3882 | 4.3718 | 4.3875 | 3636472.0 |
| 2007-08-10 10:13:00 | AAPL | Stock | 4.3875 | 4.388 | 4.3657 | 4.375 | 3694852.0 |
| 2007-08-10 10:14:00 | AAPL | Stock | 4.3746 | 4.4007 | 4.3743 | 4.3975 | 4961600.0 |
| 2007-08-10 10:15:00 | AAPL | Stock | 4.3957 | 4.4025 | 4.3904 | 4.4004 | 4978092.0 |
| 2007-08-10 10:16:00 | AAPL | Stock | 4.4004 | 4.4036 | 4.3929 | 4.3929 | 2515940.0 |
| 2007-08-10 10:17:00 | AAPL | Stock | 4.3932 | 4.3943 | 4.3754 | 4.3804 | 2704884.0 |
| 2007-08-10 10:18:00 | AAPL | Stock | 4.38 | 4.3875 | 4.3746 | 4.3779 | 2693292.0 |
| 2007-08-10 10:19:00 | AAPL | Stock | 4.3782 | 4.3839 | 4.3671 | 4.3729 | 3494652.0 |
> showing 50 of 1,115,763 rows — these rows as CSV