PREVIEW / stock_1min / 2008-10-23
file: by_date/stock_1min/2008/2008-10-23.parquet size: 13.3 MB rows: 1,042,513 symbols: 2,697
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-23 04:15:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 2800.0 |
| 2008-10-23 04:16:00 | AAPL | Stock | 3.4971 | 3.4971 | 3.4971 | 3.4971 | 2800.0 |
| 2008-10-23 04:17:00 | AAPL | Stock | 3.5 | 3.5 | 3.5 | 3.5 | 11200.0 |
| 2008-10-23 07:05:00 | AAPL | Stock | 3.4536 | 3.4536 | 3.4536 | 3.4536 | 2800.0 |
| 2008-10-23 07:19:00 | AAPL | Stock | 3.4543 | 3.4554 | 3.4543 | 3.4554 | 16800.0 |
| 2008-10-23 07:20:00 | AAPL | Stock | 3.4554 | 3.4643 | 3.4554 | 3.4643 | 11060.0 |
| 2008-10-23 07:21:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 2800.0 |
| 2008-10-23 07:23:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 19740.0 |
| 2008-10-23 07:24:00 | AAPL | Stock | 3.4554 | 3.4554 | 3.4554 | 3.4554 | 19740.0 |
| 2008-10-23 07:28:00 | AAPL | Stock | 3.4464 | 3.4464 | 3.4464 | 3.4464 | 2800.0 |
| 2008-10-23 07:30:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 14000.0 |
| 2008-10-23 07:31:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 13440.0 |
| 2008-10-23 07:37:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 3360.0 |
| 2008-10-23 07:42:00 | AAPL | Stock | 3.4393 | 3.4632 | 3.4286 | 3.4286 | 70980.0 |
| 2008-10-23 07:43:00 | AAPL | Stock | 3.4118 | 3.4118 | 3.4118 | 3.4118 | 2800.0 |
| 2008-10-23 07:54:00 | AAPL | Stock | 3.3993 | 3.3993 | 3.395 | 3.395 | 13300.0 |
| 2008-10-23 07:57:00 | AAPL | Stock | 3.4107 | 3.4264 | 3.4107 | 3.4264 | 28000.0 |
| 2008-10-23 07:58:00 | AAPL | Stock | 3.4125 | 3.4125 | 3.4125 | 3.4125 | 2800.0 |
| 2008-10-23 08:00:00 | AAPL | Stock | 3.4107 | 3.4207 | 3.4107 | 3.4132 | 38136.0 |
| 2008-10-23 08:01:00 | AAPL | Stock | 3.4129 | 3.4189 | 3.4111 | 3.4189 | 15960.0 |
| 2008-10-23 08:02:00 | AAPL | Stock | 3.4129 | 3.4129 | 3.4107 | 3.4107 | 19600.0 |
| 2008-10-23 08:03:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4032 | 3.4032 | 168980.0 |
| 2008-10-23 08:04:00 | AAPL | Stock | 3.4032 | 3.4089 | 3.4 | 3.4089 | 42000.0 |
| 2008-10-23 08:05:00 | AAPL | Stock | 3.4079 | 3.4236 | 3.4079 | 3.4236 | 39368.0 |
| 2008-10-23 08:06:00 | AAPL | Stock | 3.4232 | 3.4232 | 3.4114 | 3.42 | 30800.0 |
| 2008-10-23 08:07:00 | AAPL | Stock | 3.4114 | 3.4114 | 3.4107 | 3.4107 | 24500.0 |
| 2008-10-23 08:09:00 | AAPL | Stock | 3.4154 | 3.4164 | 3.4089 | 3.4161 | 106400.0 |
| 2008-10-23 08:10:00 | AAPL | Stock | 3.4086 | 3.4086 | 3.4086 | 3.4086 | 2800.0 |
| 2008-10-23 08:12:00 | AAPL | Stock | 3.4168 | 3.4207 | 3.4125 | 3.4125 | 11200.0 |
| 2008-10-23 08:13:00 | AAPL | Stock | 3.4161 | 3.4161 | 3.4121 | 3.4121 | 21840.0 |
| 2008-10-23 08:14:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 2800.0 |
| 2008-10-23 08:15:00 | AAPL | Stock | 3.4089 | 3.4136 | 3.4071 | 3.4136 | 45108.0 |
| 2008-10-23 08:17:00 | AAPL | Stock | 3.4136 | 3.4175 | 3.4136 | 3.4175 | 53900.0 |
| 2008-10-23 08:18:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.4175 | 3.4196 | 20300.0 |
| 2008-10-23 08:19:00 | AAPL | Stock | 3.4179 | 3.4214 | 3.4175 | 3.4214 | 14000.0 |
| 2008-10-23 08:20:00 | AAPL | Stock | 3.4146 | 3.4243 | 3.4143 | 3.4243 | 22596.0 |
| 2008-10-23 08:21:00 | AAPL | Stock | 3.4225 | 3.4225 | 3.4179 | 3.4179 | 30324.0 |
| 2008-10-23 08:22:00 | AAPL | Stock | 3.4179 | 3.4179 | 3.4179 | 3.4179 | 5824.0 |
| 2008-10-23 08:23:00 | AAPL | Stock | 3.4179 | 3.4179 | 3.4143 | 3.4143 | 54628.0 |
| 2008-10-23 08:24:00 | AAPL | Stock | 3.4146 | 3.4179 | 3.4143 | 3.4143 | 33600.0 |
| 2008-10-23 08:25:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4139 | 3.4143 | 33600.0 |
| 2008-10-23 08:27:00 | AAPL | Stock | 3.4179 | 3.4186 | 3.4179 | 3.4179 | 13860.0 |
| 2008-10-23 08:28:00 | AAPL | Stock | 3.4211 | 3.4268 | 3.4211 | 3.425 | 94640.0 |
| 2008-10-23 08:29:00 | AAPL | Stock | 3.4268 | 3.4289 | 3.4268 | 3.4289 | 52080.0 |
| 2008-10-23 08:30:00 | AAPL | Stock | 3.4289 | 3.4375 | 3.4286 | 3.4375 | 334572.0 |
| 2008-10-23 08:31:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4211 | 3.4211 | 37800.0 |
| 2008-10-23 08:32:00 | AAPL | Stock | 3.4225 | 3.4225 | 3.4211 | 3.4218 | 64400.0 |
| 2008-10-23 08:33:00 | AAPL | Stock | 3.4221 | 3.4221 | 3.4221 | 3.4221 | 2800.0 |
| 2008-10-23 08:34:00 | AAPL | Stock | 3.4214 | 3.4321 | 3.4214 | 3.4314 | 186004.0 |
| 2008-10-23 08:35:00 | AAPL | Stock | 3.4318 | 3.4375 | 3.4311 | 3.4375 | 64400.0 |
> showing 50 of 1,042,513 rows — these rows as CSV