PREVIEW / stock_1min / 2005-02-08
file: by_date/stock_1min/2005/2005-02-08.parquet size: 6.6 MB rows: 541,156 symbols: 1,589
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-08 08:02:00 | AAPL | Stock | 1.4096 | 1.4096 | 1.4089 | 1.4089 | 33600.0 |
| 2005-02-08 08:06:00 | AAPL | Stock | 1.408 | 1.408 | 1.408 | 1.408 | 22400.0 |
| 2005-02-08 08:11:00 | AAPL | Stock | 1.408 | 1.408 | 1.408 | 1.408 | 24640.0 |
| 2005-02-08 08:24:00 | AAPL | Stock | 1.408 | 1.408 | 1.4077 | 1.4077 | 50400.0 |
| 2005-02-08 08:25:00 | AAPL | Stock | 1.4077 | 1.4077 | 1.4077 | 1.4077 | 51800.0 |
| 2005-02-08 08:29:00 | AAPL | Stock | 1.4077 | 1.4077 | 1.4077 | 1.4077 | 5600.0 |
| 2005-02-08 08:41:00 | AAPL | Stock | 1.4077 | 1.4077 | 1.4077 | 1.4077 | 11200.0 |
| 2005-02-08 08:49:00 | AAPL | Stock | 1.4077 | 1.4077 | 1.4077 | 1.4077 | 31360.0 |
| 2005-02-08 08:54:00 | AAPL | Stock | 1.407 | 1.407 | 1.407 | 1.407 | 11200.0 |
| 2005-02-08 09:00:00 | AAPL | Stock | 1.407 | 1.407 | 1.407 | 1.407 | 26152.0 |
| 2005-02-08 09:01:00 | AAPL | Stock | 1.407 | 1.407 | 1.407 | 1.407 | 33600.0 |
| 2005-02-08 09:02:00 | AAPL | Stock | 1.4075 | 1.4075 | 1.4075 | 1.4075 | 16800.0 |
| 2005-02-08 09:03:00 | AAPL | Stock | 1.407 | 1.407 | 1.407 | 1.407 | 56000.0 |
| 2005-02-08 09:13:00 | AAPL | Stock | 1.4075 | 1.4075 | 1.4075 | 1.4075 | 5600.0 |
| 2005-02-08 09:14:00 | AAPL | Stock | 1.4075 | 1.4075 | 1.4071 | 1.4071 | 78400.0 |
| 2005-02-08 09:21:00 | AAPL | Stock | 1.4064 | 1.407 | 1.3893 | 1.3991 | 1001616.0 |
| 2005-02-08 09:23:00 | AAPL | Stock | 1.4046 | 1.4046 | 1.4046 | 1.4046 | 33600.0 |
| 2005-02-08 09:24:00 | AAPL | Stock | 1.4036 | 1.4036 | 1.4036 | 1.4036 | 16800.0 |
| 2005-02-08 09:25:00 | AAPL | Stock | 1.4054 | 1.4054 | 1.4054 | 1.4054 | 5600.0 |
| 2005-02-08 09:26:00 | AAPL | Stock | 1.4052 | 1.4052 | 1.4052 | 1.4052 | 11200.0 |
| 2005-02-08 09:28:00 | AAPL | Stock | 1.4052 | 1.4105 | 1.4052 | 1.4105 | 335944.0 |
| 2005-02-08 09:29:00 | AAPL | Stock | 1.4096 | 1.4141 | 1.4089 | 1.4125 | 602000.0 |
| 2005-02-08 09:30:00 | AAPL | Stock | 1.412 | 1.4141 | 1.4075 | 1.4118 | 6828360.0 |
| 2005-02-08 09:31:00 | AAPL | Stock | 1.4121 | 1.4141 | 1.4095 | 1.4102 | 1981560.0 |
| 2005-02-08 09:32:00 | AAPL | Stock | 1.41 | 1.4129 | 1.41 | 1.41 | 2748424.0 |
| 2005-02-08 09:33:00 | AAPL | Stock | 1.4102 | 1.4118 | 1.4098 | 1.4105 | 2646448.0 |
| 2005-02-08 09:34:00 | AAPL | Stock | 1.4102 | 1.4116 | 1.4096 | 1.4105 | 2816800.0 |
| 2005-02-08 09:35:00 | AAPL | Stock | 1.4109 | 1.4109 | 1.4102 | 1.4104 | 1307936.0 |
| 2005-02-08 09:36:00 | AAPL | Stock | 1.4104 | 1.4109 | 1.4086 | 1.4086 | 3964576.0 |
| 2005-02-08 09:37:00 | AAPL | Stock | 1.4086 | 1.4105 | 1.4084 | 1.4091 | 2093616.0 |
| 2005-02-08 09:38:00 | AAPL | Stock | 1.4091 | 1.4105 | 1.4082 | 1.4098 | 1273272.0 |
| 2005-02-08 09:39:00 | AAPL | Stock | 1.4098 | 1.4098 | 1.4095 | 1.4096 | 395920.0 |
| 2005-02-08 09:40:00 | AAPL | Stock | 1.4095 | 1.4096 | 1.407 | 1.4089 | 1530704.0 |
| 2005-02-08 09:41:00 | AAPL | Stock | 1.4089 | 1.4089 | 1.4088 | 1.4089 | 819728.0 |
| 2005-02-08 09:42:00 | AAPL | Stock | 1.4088 | 1.4098 | 1.4088 | 1.4098 | 1623944.0 |
| 2005-02-08 09:43:00 | AAPL | Stock | 1.4095 | 1.4102 | 1.4095 | 1.4098 | 1242080.0 |
| 2005-02-08 09:44:00 | AAPL | Stock | 1.4098 | 1.4134 | 1.4098 | 1.4129 | 2537696.0 |
| 2005-02-08 09:45:00 | AAPL | Stock | 1.4127 | 1.4152 | 1.4125 | 1.4134 | 4653544.0 |
| 2005-02-08 09:46:00 | AAPL | Stock | 1.4134 | 1.4161 | 1.4134 | 1.4154 | 2695504.0 |
| 2005-02-08 09:47:00 | AAPL | Stock | 1.4155 | 1.4164 | 1.4145 | 1.4155 | 3793888.0 |
| 2005-02-08 09:48:00 | AAPL | Stock | 1.415 | 1.4182 | 1.4143 | 1.4178 | 3819144.0 |
| 2005-02-08 09:49:00 | AAPL | Stock | 1.4182 | 1.4207 | 1.4178 | 1.4201 | 6814640.0 |
| 2005-02-08 09:50:00 | AAPL | Stock | 1.4195 | 1.4232 | 1.4188 | 1.4232 | 5308072.0 |
| 2005-02-08 09:51:00 | AAPL | Stock | 1.4234 | 1.425 | 1.4229 | 1.4244 | 6127184.0 |
| 2005-02-08 09:52:00 | AAPL | Stock | 1.4246 | 1.4277 | 1.4243 | 1.4277 | 10789856.0 |
| 2005-02-08 09:53:00 | AAPL | Stock | 1.4277 | 1.4277 | 1.4241 | 1.4259 | 6309296.0 |
| 2005-02-08 09:54:00 | AAPL | Stock | 1.4259 | 1.4266 | 1.4234 | 1.4241 | 3916304.0 |
| 2005-02-08 09:55:00 | AAPL | Stock | 1.4243 | 1.4246 | 1.4221 | 1.4238 | 3502632.0 |
| 2005-02-08 09:56:00 | AAPL | Stock | 1.4236 | 1.4254 | 1.4229 | 1.4243 | 2395400.0 |
| 2005-02-08 09:57:00 | AAPL | Stock | 1.4243 | 1.4277 | 1.4239 | 1.4275 | 3955280.0 |
> showing 50 of 541,156 rows — these rows as CSV