PREVIEW / stock_1min / 2007-06-19
file: by_date/stock_1min/2007/2007-06-19.parquet size: 11.0 MB rows: 909,858 symbols: 2,492
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-19 09:30:00 | AAPL | Stock | 4.4532 | 4.455 | 4.4461 | 4.4482 | 10563028.0 |
| 2007-06-19 09:31:00 | AAPL | Stock | 4.4489 | 4.4646 | 4.4475 | 4.4575 | 6814528.0 |
| 2007-06-19 09:32:00 | AAPL | Stock | 4.4571 | 4.4582 | 4.4436 | 4.4443 | 5504996.0 |
| 2007-06-19 09:33:00 | AAPL | Stock | 4.4443 | 4.4639 | 4.4436 | 4.4536 | 4175024.0 |
| 2007-06-19 09:34:00 | AAPL | Stock | 4.4537 | 4.4543 | 4.4467 | 4.4479 | 3847340.0 |
| 2007-06-19 09:35:00 | AAPL | Stock | 4.4479 | 4.4489 | 4.4361 | 4.4375 | 5742296.0 |
| 2007-06-19 09:36:00 | AAPL | Stock | 4.4379 | 4.4446 | 4.4368 | 4.4436 | 4509540.0 |
| 2007-06-19 09:37:00 | AAPL | Stock | 4.4439 | 4.4511 | 4.4436 | 4.4507 | 3380944.0 |
| 2007-06-19 09:38:00 | AAPL | Stock | 4.4496 | 4.4504 | 4.4432 | 4.445 | 4207672.0 |
| 2007-06-19 09:39:00 | AAPL | Stock | 4.4454 | 4.4464 | 4.4393 | 4.44 | 4207644.0 |
| 2007-06-19 09:40:00 | AAPL | Stock | 4.44 | 4.4411 | 4.4221 | 4.4232 | 8174740.0 |
| 2007-06-19 09:41:00 | AAPL | Stock | 4.4239 | 4.4282 | 4.4146 | 4.4171 | 8401148.0 |
| 2007-06-19 09:42:00 | AAPL | Stock | 4.4175 | 4.4279 | 4.4146 | 4.4249 | 6288212.0 |
| 2007-06-19 09:43:00 | AAPL | Stock | 4.4246 | 4.4286 | 4.4232 | 4.4264 | 5223932.0 |
| 2007-06-19 09:44:00 | AAPL | Stock | 4.4264 | 4.4282 | 4.4214 | 4.4282 | 4867044.0 |
| 2007-06-19 09:45:00 | AAPL | Stock | 4.4282 | 4.43 | 4.425 | 4.4268 | 4361364.0 |
| 2007-06-19 09:46:00 | AAPL | Stock | 4.4268 | 4.4275 | 4.4207 | 4.4221 | 3268244.0 |
| 2007-06-19 09:47:00 | AAPL | Stock | 4.4221 | 4.4225 | 4.4111 | 4.4129 | 5782252.0 |
| 2007-06-19 09:48:00 | AAPL | Stock | 4.4129 | 4.4189 | 4.4114 | 4.4189 | 3329200.0 |
| 2007-06-19 09:49:00 | AAPL | Stock | 4.4189 | 4.4189 | 4.4093 | 4.4121 | 6520752.0 |
| 2007-06-19 09:50:00 | AAPL | Stock | 4.4121 | 4.4121 | 4.4 | 4.4061 | 7370972.0 |
| 2007-06-19 09:51:00 | AAPL | Stock | 4.4061 | 4.4061 | 4.3975 | 4.4025 | 7046032.0 |
| 2007-06-19 09:52:00 | AAPL | Stock | 4.4029 | 4.4111 | 4.4004 | 4.4107 | 5296900.0 |
| 2007-06-19 09:53:00 | AAPL | Stock | 4.41 | 4.4154 | 4.4079 | 4.4146 | 5415564.0 |
| 2007-06-19 09:54:00 | AAPL | Stock | 4.4143 | 4.4143 | 4.4071 | 4.4107 | 3844316.0 |
| 2007-06-19 09:55:00 | AAPL | Stock | 4.4104 | 4.4114 | 4.4036 | 4.4039 | 3025400.0 |
| 2007-06-19 09:56:00 | AAPL | Stock | 4.4039 | 4.4068 | 4.3993 | 4.4068 | 4239172.0 |
| 2007-06-19 09:57:00 | AAPL | Stock | 4.4064 | 4.4107 | 4.4054 | 4.4107 | 2833488.0 |
| 2007-06-19 09:58:00 | AAPL | Stock | 4.4107 | 4.4136 | 4.4079 | 4.4121 | 3286248.0 |
| 2007-06-19 09:59:00 | AAPL | Stock | 4.4114 | 4.4182 | 4.4114 | 4.4164 | 4278736.0 |
| 2007-06-19 10:00:00 | AAPL | Stock | 4.4154 | 4.4196 | 4.4125 | 4.4186 | 3050460.0 |
| 2007-06-19 10:01:00 | AAPL | Stock | 4.4186 | 4.4221 | 4.4164 | 4.4164 | 3280172.0 |
| 2007-06-19 10:02:00 | AAPL | Stock | 4.4168 | 4.4179 | 4.4146 | 4.415 | 1723568.0 |
| 2007-06-19 10:03:00 | AAPL | Stock | 4.4157 | 4.4161 | 4.4079 | 4.4154 | 3585624.0 |
| 2007-06-19 10:04:00 | AAPL | Stock | 4.4154 | 4.4163 | 4.4118 | 4.4146 | 1716204.0 |
| 2007-06-19 10:05:00 | AAPL | Stock | 4.4146 | 4.4193 | 4.4142 | 4.4193 | 2376556.0 |
| 2007-06-19 10:06:00 | AAPL | Stock | 4.4189 | 4.4193 | 4.4129 | 4.4129 | 2004688.0 |
| 2007-06-19 10:07:00 | AAPL | Stock | 4.4125 | 4.415 | 4.4111 | 4.4143 | 2119544.0 |
| 2007-06-19 10:08:00 | AAPL | Stock | 4.415 | 4.42 | 4.4148 | 4.4168 | 2510816.0 |
| 2007-06-19 10:09:00 | AAPL | Stock | 4.4168 | 4.4239 | 4.4164 | 4.4193 | 3133340.0 |
| 2007-06-19 10:10:00 | AAPL | Stock | 4.4193 | 4.4204 | 4.4136 | 4.4175 | 2354632.0 |
| 2007-06-19 10:11:00 | AAPL | Stock | 4.4179 | 4.4199 | 4.4154 | 4.4182 | 1365140.0 |
| 2007-06-19 10:12:00 | AAPL | Stock | 4.4182 | 4.4225 | 4.4164 | 4.4214 | 1932784.0 |
| 2007-06-19 10:13:00 | AAPL | Stock | 4.4221 | 4.4229 | 4.4186 | 4.4207 | 2087904.0 |
| 2007-06-19 10:14:00 | AAPL | Stock | 4.4204 | 4.4211 | 4.4125 | 4.4132 | 3123400.0 |
| 2007-06-19 10:15:00 | AAPL | Stock | 4.4132 | 4.4132 | 4.4082 | 4.4089 | 3763928.0 |
| 2007-06-19 10:16:00 | AAPL | Stock | 4.4086 | 4.4107 | 4.4054 | 4.4104 | 2870672.0 |
| 2007-06-19 10:17:00 | AAPL | Stock | 4.4104 | 4.4107 | 4.4089 | 4.4104 | 2142672.0 |
| 2007-06-19 10:18:00 | AAPL | Stock | 4.4104 | 4.4121 | 4.4086 | 4.4118 | 2036776.0 |
| 2007-06-19 10:19:00 | AAPL | Stock | 4.4114 | 4.4114 | 4.4071 | 4.4079 | 1899408.0 |
> showing 50 of 909,858 rows — these rows as CSV