PREVIEW / stock_1min / 2007-06-26
file: by_date/stock_1min/2007/2007-06-26.parquet size: 11.6 MB rows: 957,204 symbols: 2,497
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-06-26 09:30:00 | AAPL | Stock | 4.4279 | 4.4282 | 4.4204 | 4.4243 | 18006324.0 |
| 2007-06-26 09:31:00 | AAPL | Stock | 4.4229 | 4.4282 | 4.4146 | 4.4154 | 8674400.0 |
| 2007-06-26 09:32:00 | AAPL | Stock | 4.415 | 4.4286 | 4.4125 | 4.4161 | 7428680.0 |
| 2007-06-26 09:33:00 | AAPL | Stock | 4.4157 | 4.4243 | 4.415 | 4.4168 | 6219304.0 |
| 2007-06-26 09:34:00 | AAPL | Stock | 4.4168 | 4.4204 | 4.415 | 4.4196 | 7029176.0 |
| 2007-06-26 09:35:00 | AAPL | Stock | 4.4196 | 4.42 | 4.4071 | 4.4121 | 7515564.0 |
| 2007-06-26 09:36:00 | AAPL | Stock | 4.4125 | 4.42 | 4.4121 | 4.4154 | 5353208.0 |
| 2007-06-26 09:37:00 | AAPL | Stock | 4.4154 | 4.4168 | 4.4111 | 4.4154 | 3836420.0 |
| 2007-06-26 09:38:00 | AAPL | Stock | 4.4154 | 4.425 | 4.415 | 4.4229 | 5959520.0 |
| 2007-06-26 09:39:00 | AAPL | Stock | 4.4221 | 4.4279 | 4.4196 | 4.426 | 4163320.0 |
| 2007-06-26 09:40:00 | AAPL | Stock | 4.4257 | 4.4275 | 4.4186 | 4.4221 | 3917508.0 |
| 2007-06-26 09:41:00 | AAPL | Stock | 4.4207 | 4.4232 | 4.4146 | 4.4154 | 3802512.0 |
| 2007-06-26 09:42:00 | AAPL | Stock | 4.415 | 4.4161 | 4.3982 | 4.3982 | 7037464.0 |
| 2007-06-26 09:43:00 | AAPL | Stock | 4.3982 | 4.41 | 4.3936 | 4.395 | 6112820.0 |
| 2007-06-26 09:44:00 | AAPL | Stock | 4.395 | 4.4025 | 4.3814 | 4.3957 | 9390948.0 |
| 2007-06-26 09:45:00 | AAPL | Stock | 4.3968 | 4.4025 | 4.3918 | 4.3971 | 5864852.0 |
| 2007-06-26 09:46:00 | AAPL | Stock | 4.3971 | 4.4036 | 4.3921 | 4.4021 | 3597160.0 |
| 2007-06-26 09:47:00 | AAPL | Stock | 4.4021 | 4.4025 | 4.3936 | 4.3982 | 3233972.0 |
| 2007-06-26 09:48:00 | AAPL | Stock | 4.3982 | 4.4011 | 4.3961 | 4.3961 | 2264304.0 |
| 2007-06-26 09:49:00 | AAPL | Stock | 4.3961 | 4.4068 | 4.3961 | 4.4046 | 3873548.0 |
| 2007-06-26 09:50:00 | AAPL | Stock | 4.4043 | 4.4068 | 4.4007 | 4.4064 | 2149084.0 |
| 2007-06-26 09:51:00 | AAPL | Stock | 4.4064 | 4.4068 | 4.3982 | 4.4 | 2697828.0 |
| 2007-06-26 09:52:00 | AAPL | Stock | 4.3996 | 4.4046 | 4.3989 | 4.4029 | 2371964.0 |
| 2007-06-26 09:53:00 | AAPL | Stock | 4.4029 | 4.4032 | 4.3971 | 4.4018 | 2166304.0 |
| 2007-06-26 09:54:00 | AAPL | Stock | 4.4018 | 4.4036 | 4.3986 | 4.3993 | 1295140.0 |
| 2007-06-26 09:55:00 | AAPL | Stock | 4.3986 | 4.4036 | 4.3954 | 4.4014 | 3172512.0 |
| 2007-06-26 09:56:00 | AAPL | Stock | 4.4018 | 4.4021 | 4.3914 | 4.3961 | 4144560.0 |
| 2007-06-26 09:57:00 | AAPL | Stock | 4.3961 | 4.3979 | 4.3893 | 4.3914 | 3673264.0 |
| 2007-06-26 09:58:00 | AAPL | Stock | 4.3914 | 4.3939 | 4.3839 | 4.3879 | 5256300.0 |
| 2007-06-26 09:59:00 | AAPL | Stock | 4.3882 | 4.3914 | 4.3857 | 4.3907 | 1774136.0 |
| 2007-06-26 10:00:00 | AAPL | Stock | 4.3904 | 4.3925 | 4.3829 | 4.3839 | 4287444.0 |
| 2007-06-26 10:01:00 | AAPL | Stock | 4.3836 | 4.39 | 4.383 | 4.3864 | 5672912.0 |
| 2007-06-26 10:02:00 | AAPL | Stock | 4.3871 | 4.3882 | 4.3721 | 4.3761 | 7522424.0 |
| 2007-06-26 10:03:00 | AAPL | Stock | 4.3761 | 4.385 | 4.3721 | 4.3739 | 6309968.0 |
| 2007-06-26 10:04:00 | AAPL | Stock | 4.3736 | 4.3736 | 4.365 | 4.3679 | 7559524.0 |
| 2007-06-26 10:05:00 | AAPL | Stock | 4.3675 | 4.3729 | 4.3668 | 4.3675 | 4899356.0 |
| 2007-06-26 10:06:00 | AAPL | Stock | 4.3675 | 4.3736 | 4.3629 | 4.3671 | 5486740.0 |
| 2007-06-26 10:07:00 | AAPL | Stock | 4.3664 | 4.3675 | 4.3582 | 4.36 | 5989816.0 |
| 2007-06-26 10:08:00 | AAPL | Stock | 4.36 | 4.3618 | 4.3525 | 4.3589 | 6712496.0 |
| 2007-06-26 10:09:00 | AAPL | Stock | 4.3589 | 4.3639 | 4.3589 | 4.3618 | 3924760.0 |
| 2007-06-26 10:10:00 | AAPL | Stock | 4.3621 | 4.3629 | 4.3536 | 4.355 | 3427592.0 |
| 2007-06-26 10:11:00 | AAPL | Stock | 4.355 | 4.3621 | 4.3486 | 4.3525 | 5591040.0 |
| 2007-06-26 10:12:00 | AAPL | Stock | 4.3525 | 4.3536 | 4.3421 | 4.3439 | 5256692.0 |
| 2007-06-26 10:13:00 | AAPL | Stock | 4.3436 | 4.3521 | 4.3436 | 4.3496 | 3971464.0 |
| 2007-06-26 10:14:00 | AAPL | Stock | 4.3496 | 4.3632 | 4.3479 | 4.3554 | 6211520.0 |
| 2007-06-26 10:15:00 | AAPL | Stock | 4.3564 | 4.3711 | 4.3482 | 4.3571 | 4296208.0 |
| 2007-06-26 10:16:00 | AAPL | Stock | 4.3575 | 4.3611 | 4.3546 | 4.3586 | 4016544.0 |
| 2007-06-26 10:17:00 | AAPL | Stock | 4.3586 | 4.3618 | 4.3529 | 4.3529 | 4392332.0 |
| 2007-06-26 10:18:00 | AAPL | Stock | 4.3532 | 4.3586 | 4.3521 | 4.3561 | 3236884.0 |
| 2007-06-26 10:19:00 | AAPL | Stock | 4.3561 | 4.3582 | 4.3486 | 4.3504 | 4106144.0 |
> showing 50 of 957,204 rows — these rows as CSV