PREVIEW / stock_1min / 2007-06-18
file: by_date/stock_1min/2007/2007-06-18.parquet size: 11.0 MB rows: 908,248 symbols: 2,491
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-18 09:30:00 | AAPL | Stock | 4.4029 | 4.4075 | 4.3879 | 4.3925 | 8680308.0 |
| 2007-06-18 09:31:00 | AAPL | Stock | 4.3911 | 4.4054 | 4.3825 | 4.3893 | 7224084.0 |
| 2007-06-18 09:32:00 | AAPL | Stock | 4.3886 | 4.3982 | 4.3832 | 4.3911 | 6189680.0 |
| 2007-06-18 09:33:00 | AAPL | Stock | 4.3911 | 4.3961 | 4.3843 | 4.3893 | 4540620.0 |
| 2007-06-18 09:34:00 | AAPL | Stock | 4.3893 | 4.3929 | 4.3764 | 4.385 | 6039600.0 |
| 2007-06-18 09:35:00 | AAPL | Stock | 4.3864 | 4.3889 | 4.3807 | 4.3871 | 3682672.0 |
| 2007-06-18 09:36:00 | AAPL | Stock | 4.3864 | 4.3907 | 4.385 | 4.3882 | 3696000.0 |
| 2007-06-18 09:37:00 | AAPL | Stock | 4.3879 | 4.4036 | 4.3871 | 4.3993 | 9970744.0 |
| 2007-06-18 09:38:00 | AAPL | Stock | 4.3989 | 4.4029 | 4.3954 | 4.4004 | 4992848.0 |
| 2007-06-18 09:39:00 | AAPL | Stock | 4.4 | 4.4071 | 4.3896 | 4.3925 | 8215312.0 |
| 2007-06-18 09:40:00 | AAPL | Stock | 4.3919 | 4.3964 | 4.39 | 4.3901 | 5092948.0 |
| 2007-06-18 09:41:00 | AAPL | Stock | 4.3907 | 4.3943 | 4.3839 | 4.3868 | 4147444.0 |
| 2007-06-18 09:42:00 | AAPL | Stock | 4.3868 | 4.3957 | 4.385 | 4.3957 | 3492832.0 |
| 2007-06-18 09:43:00 | AAPL | Stock | 4.3964 | 4.41 | 4.3875 | 4.41 | 6172068.0 |
| 2007-06-18 09:44:00 | AAPL | Stock | 4.41 | 4.4182 | 4.4046 | 4.4182 | 11886924.0 |
| 2007-06-18 09:45:00 | AAPL | Stock | 4.4186 | 4.4268 | 4.4179 | 4.4221 | 9509024.0 |
| 2007-06-18 09:46:00 | AAPL | Stock | 4.4214 | 4.425 | 4.4175 | 4.4218 | 7567448.0 |
| 2007-06-18 09:47:00 | AAPL | Stock | 4.4214 | 4.43 | 4.4214 | 4.4286 | 9477692.0 |
| 2007-06-18 09:48:00 | AAPL | Stock | 4.4286 | 4.4379 | 4.4271 | 4.4318 | 9129652.0 |
| 2007-06-18 09:49:00 | AAPL | Stock | 4.4325 | 4.4357 | 4.4304 | 4.4346 | 4989264.0 |
| 2007-06-18 09:50:00 | AAPL | Stock | 4.4347 | 4.4357 | 4.4257 | 4.4296 | 6909392.0 |
| 2007-06-18 09:51:00 | AAPL | Stock | 4.4293 | 4.4314 | 4.4225 | 4.4225 | 5133212.0 |
| 2007-06-18 09:52:00 | AAPL | Stock | 4.4232 | 4.4236 | 4.4132 | 4.4171 | 6050688.0 |
| 2007-06-18 09:53:00 | AAPL | Stock | 4.4171 | 4.425 | 4.4164 | 4.4246 | 3041864.0 |
| 2007-06-18 09:54:00 | AAPL | Stock | 4.4244 | 4.4246 | 4.4171 | 4.4196 | 2212980.0 |
| 2007-06-18 09:55:00 | AAPL | Stock | 4.4193 | 4.4204 | 4.4036 | 4.4189 | 2684528.0 |
| 2007-06-18 09:56:00 | AAPL | Stock | 4.4188 | 4.4221 | 4.4182 | 4.4214 | 1908200.0 |
| 2007-06-18 09:57:00 | AAPL | Stock | 4.4214 | 4.4239 | 4.4207 | 4.4214 | 1969604.0 |
| 2007-06-18 09:58:00 | AAPL | Stock | 4.4214 | 4.4239 | 4.4168 | 4.4171 | 2471336.0 |
| 2007-06-18 09:59:00 | AAPL | Stock | 4.4171 | 4.4179 | 4.4107 | 4.4107 | 3442516.0 |
| 2007-06-18 10:00:00 | AAPL | Stock | 4.4107 | 4.4114 | 4.4054 | 4.4057 | 4174072.0 |
| 2007-06-18 10:01:00 | AAPL | Stock | 4.406 | 4.4096 | 4.4029 | 4.4079 | 4379480.0 |
| 2007-06-18 10:02:00 | AAPL | Stock | 4.4075 | 4.4107 | 4.4054 | 4.4082 | 4068372.0 |
| 2007-06-18 10:03:00 | AAPL | Stock | 4.4082 | 4.4146 | 4.4079 | 4.4121 | 3162096.0 |
| 2007-06-18 10:04:00 | AAPL | Stock | 4.4118 | 4.4139 | 4.405 | 4.4068 | 4268852.0 |
| 2007-06-18 10:05:00 | AAPL | Stock | 4.4066 | 4.4089 | 4.405 | 4.4054 | 2818228.0 |
| 2007-06-18 10:06:00 | AAPL | Stock | 4.405 | 4.4089 | 4.4039 | 4.4082 | 3164252.0 |
| 2007-06-18 10:07:00 | AAPL | Stock | 4.4079 | 4.4089 | 4.4018 | 4.4018 | 2904076.0 |
| 2007-06-18 10:08:00 | AAPL | Stock | 4.4018 | 4.405 | 4.4011 | 4.4021 | 2747836.0 |
| 2007-06-18 10:09:00 | AAPL | Stock | 4.4021 | 4.4139 | 4.4016 | 4.4118 | 2963772.0 |
| 2007-06-18 10:10:00 | AAPL | Stock | 4.4114 | 4.4139 | 4.4089 | 4.4111 | 1881068.0 |
| 2007-06-18 10:11:00 | AAPL | Stock | 4.4111 | 4.4179 | 4.4107 | 4.4165 | 3096856.0 |
| 2007-06-18 10:12:00 | AAPL | Stock | 4.4164 | 4.4196 | 4.4146 | 4.4196 | 1314180.0 |
| 2007-06-18 10:13:00 | AAPL | Stock | 4.4193 | 4.4196 | 4.4125 | 4.4129 | 2311008.0 |
| 2007-06-18 10:14:00 | AAPL | Stock | 4.4129 | 4.4157 | 4.4125 | 4.4157 | 813400.0 |
| 2007-06-18 10:15:00 | AAPL | Stock | 4.4154 | 4.4168 | 4.4071 | 4.4118 | 3370668.0 |
| 2007-06-18 10:16:00 | AAPL | Stock | 4.4118 | 4.4164 | 4.4086 | 4.4086 | 1992088.0 |
| 2007-06-18 10:17:00 | AAPL | Stock | 4.4086 | 4.4125 | 4.4071 | 4.4096 | 2084628.0 |
| 2007-06-18 10:18:00 | AAPL | Stock | 4.4094 | 4.4129 | 4.4089 | 4.4107 | 1827420.0 |
| 2007-06-18 10:19:00 | AAPL | Stock | 4.4114 | 4.4164 | 4.4096 | 4.4133 | 2720816.0 |
> showing 50 of 908,248 rows — these rows as CSV