PREVIEW / stock_1min / 2007-06-22
file: by_date/stock_1min/2007/2007-06-22.parquet size: 11.7 MB rows: 953,563 symbols: 2,479
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-22 09:30:00 | AAPL | Stock | 4.4232 | 4.4375 | 4.4196 | 4.4361 | 6547660.0 |
| 2007-06-22 09:31:00 | AAPL | Stock | 4.4361 | 4.4429 | 4.4214 | 4.4379 | 4963504.0 |
| 2007-06-22 09:32:00 | AAPL | Stock | 4.4313 | 4.4406 | 4.4207 | 4.4211 | 5580008.0 |
| 2007-06-22 09:33:00 | AAPL | Stock | 4.4196 | 4.4336 | 4.4189 | 4.4236 | 3734024.0 |
| 2007-06-22 09:34:00 | AAPL | Stock | 4.4236 | 4.4243 | 4.4139 | 4.4143 | 3440892.0 |
| 2007-06-22 09:35:00 | AAPL | Stock | 4.4143 | 4.42 | 4.4111 | 4.4136 | 3086188.0 |
| 2007-06-22 09:36:00 | AAPL | Stock | 4.4111 | 4.4143 | 4.3996 | 4.4096 | 6162744.0 |
| 2007-06-22 09:37:00 | AAPL | Stock | 4.4096 | 4.4154 | 4.4096 | 4.4139 | 3528028.0 |
| 2007-06-22 09:38:00 | AAPL | Stock | 4.4132 | 4.4161 | 4.4104 | 4.415 | 2947952.0 |
| 2007-06-22 09:39:00 | AAPL | Stock | 4.415 | 4.425 | 4.4125 | 4.4175 | 3059952.0 |
| 2007-06-22 09:40:00 | AAPL | Stock | 4.4182 | 4.4182 | 4.4071 | 4.4132 | 2697492.0 |
| 2007-06-22 09:41:00 | AAPL | Stock | 4.4129 | 4.4157 | 4.4075 | 4.415 | 1830528.0 |
| 2007-06-22 09:42:00 | AAPL | Stock | 4.4139 | 4.4204 | 4.4129 | 4.4129 | 1163344.0 |
| 2007-06-22 09:43:00 | AAPL | Stock | 4.4118 | 4.4135 | 4.4036 | 4.4068 | 2795632.0 |
| 2007-06-22 09:44:00 | AAPL | Stock | 4.4086 | 4.4111 | 4.4018 | 4.4111 | 2766904.0 |
| 2007-06-22 09:45:00 | AAPL | Stock | 4.4114 | 4.4157 | 4.4086 | 4.4089 | 2192372.0 |
| 2007-06-22 09:46:00 | AAPL | Stock | 4.4086 | 4.4086 | 4.4 | 4.4079 | 2632644.0 |
| 2007-06-22 09:47:00 | AAPL | Stock | 4.4071 | 4.4232 | 4.4057 | 4.4221 | 3929184.0 |
| 2007-06-22 09:48:00 | AAPL | Stock | 4.4225 | 4.4225 | 4.4135 | 4.4193 | 1669080.0 |
| 2007-06-22 09:49:00 | AAPL | Stock | 4.4189 | 4.4225 | 4.4164 | 4.4225 | 2254392.0 |
| 2007-06-22 09:50:00 | AAPL | Stock | 4.4225 | 4.4371 | 4.4182 | 4.4354 | 6201132.0 |
| 2007-06-22 09:51:00 | AAPL | Stock | 4.4354 | 4.4446 | 4.4329 | 4.4354 | 5707492.0 |
| 2007-06-22 09:52:00 | AAPL | Stock | 4.4343 | 4.4404 | 4.4311 | 4.4314 | 4241888.0 |
| 2007-06-22 09:53:00 | AAPL | Stock | 4.4312 | 4.4364 | 4.4307 | 4.4329 | 1994888.0 |
| 2007-06-22 09:54:00 | AAPL | Stock | 4.4325 | 4.4329 | 4.4254 | 4.43 | 2903180.0 |
| 2007-06-22 09:55:00 | AAPL | Stock | 4.43 | 4.43 | 4.4236 | 4.4246 | 2524872.0 |
| 2007-06-22 09:56:00 | AAPL | Stock | 4.4243 | 4.4332 | 4.4243 | 4.4304 | 3030944.0 |
| 2007-06-22 09:57:00 | AAPL | Stock | 4.4307 | 4.4314 | 4.4254 | 4.4275 | 1726368.0 |
| 2007-06-22 09:58:00 | AAPL | Stock | 4.4296 | 4.4329 | 4.4261 | 4.4279 | 1719340.0 |
| 2007-06-22 09:59:00 | AAPL | Stock | 4.4278 | 4.43 | 4.4271 | 4.4275 | 979132.0 |
| 2007-06-22 10:00:00 | AAPL | Stock | 4.4275 | 4.4275 | 4.4189 | 4.4214 | 2963436.0 |
| 2007-06-22 10:01:00 | AAPL | Stock | 4.4214 | 4.4286 | 4.4207 | 4.425 | 2050832.0 |
| 2007-06-22 10:02:00 | AAPL | Stock | 4.4246 | 4.4246 | 4.4196 | 4.42 | 1810816.0 |
| 2007-06-22 10:03:00 | AAPL | Stock | 4.42 | 4.4239 | 4.4182 | 4.4182 | 2644152.0 |
| 2007-06-22 10:04:00 | AAPL | Stock | 4.4182 | 4.4239 | 4.4182 | 4.4221 | 1178688.0 |
| 2007-06-22 10:05:00 | AAPL | Stock | 4.4225 | 4.4229 | 4.4146 | 4.4154 | 1900052.0 |
| 2007-06-22 10:06:00 | AAPL | Stock | 4.415 | 4.4167 | 4.4121 | 4.4161 | 2273768.0 |
| 2007-06-22 10:07:00 | AAPL | Stock | 4.4157 | 4.4193 | 4.4154 | 4.4182 | 1333612.0 |
| 2007-06-22 10:08:00 | AAPL | Stock | 4.4186 | 4.4186 | 4.4125 | 4.4132 | 998816.0 |
| 2007-06-22 10:09:00 | AAPL | Stock | 4.4132 | 4.4257 | 4.4132 | 4.425 | 1970500.0 |
| 2007-06-22 10:10:00 | AAPL | Stock | 4.4246 | 4.425 | 4.4175 | 4.4182 | 1607172.0 |
| 2007-06-22 10:11:00 | AAPL | Stock | 4.4192 | 4.4221 | 4.4154 | 4.4221 | 1494612.0 |
| 2007-06-22 10:12:00 | AAPL | Stock | 4.4221 | 4.4321 | 4.4204 | 4.4307 | 3338552.0 |
| 2007-06-22 10:13:00 | AAPL | Stock | 4.4302 | 4.4311 | 4.4261 | 4.4275 | 3564176.0 |
| 2007-06-22 10:14:00 | AAPL | Stock | 4.4282 | 4.4357 | 4.4261 | 4.4332 | 2839900.0 |
| 2007-06-22 10:15:00 | AAPL | Stock | 4.4332 | 4.4375 | 4.4307 | 4.4343 | 3077844.0 |
| 2007-06-22 10:16:00 | AAPL | Stock | 4.4346 | 4.4393 | 4.4325 | 4.4382 | 4143916.0 |
| 2007-06-22 10:17:00 | AAPL | Stock | 4.4379 | 4.4443 | 4.4368 | 4.4407 | 4480364.0 |
| 2007-06-22 10:18:00 | AAPL | Stock | 4.4411 | 4.4446 | 4.4346 | 4.4346 | 3444336.0 |
| 2007-06-22 10:19:00 | AAPL | Stock | 4.435 | 4.4357 | 4.4318 | 4.4334 | 1695764.0 |
> showing 50 of 953,563 rows — these rows as CSV