PREVIEW / stock_5min / 2005-06-01
file: by_date/stock_5min/2005/2005-06-01.parquet size: 2.7 MB rows: 198,440 symbols: 1,979
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-06-01 08:00:00 | AAPL | Stock | 1.4129 | 1.4161 | 1.4129 | 1.4161 | 12320.0 |
| 2005-06-01 08:10:00 | AAPL | Stock | 1.4168 | 1.4168 | 1.4168 | 1.4168 | 15120.0 |
| 2005-06-01 08:20:00 | AAPL | Stock | 1.4168 | 1.4221 | 1.4168 | 1.4221 | 53200.0 |
| 2005-06-01 08:30:00 | AAPL | Stock | 1.4196 | 1.4196 | 1.4196 | 1.4196 | 27020.0 |
| 2005-06-01 08:35:00 | AAPL | Stock | 1.4196 | 1.4196 | 1.4196 | 1.4196 | 34580.0 |
| 2005-06-01 08:40:00 | AAPL | Stock | 1.4214 | 1.4214 | 1.4214 | 1.4214 | 9380.0 |
| 2005-06-01 09:00:00 | AAPL | Stock | 1.4196 | 1.4218 | 1.4196 | 1.4214 | 56560.0 |
| 2005-06-01 09:05:00 | AAPL | Stock | 1.4225 | 1.4225 | 1.4221 | 1.4225 | 44800.0 |
| 2005-06-01 09:10:00 | AAPL | Stock | 1.4093 | 1.4229 | 1.4093 | 1.4214 | 118972.0 |
| 2005-06-01 09:15:00 | AAPL | Stock | 1.4229 | 1.4229 | 1.4214 | 1.4214 | 14000.0 |
| 2005-06-01 09:20:00 | AAPL | Stock | 1.4211 | 1.4214 | 1.4211 | 1.4214 | 169484.0 |
| 2005-06-01 09:25:00 | AAPL | Stock | 1.4218 | 1.4293 | 1.4214 | 1.4279 | 1920576.0 |
| 2005-06-01 09:30:00 | AAPL | Stock | 1.4246 | 1.4286 | 1.4236 | 1.4257 | 12528012.0 |
| 2005-06-01 09:35:00 | AAPL | Stock | 1.4257 | 1.4268 | 1.4236 | 1.4257 | 7762748.0 |
| 2005-06-01 09:40:00 | AAPL | Stock | 1.4261 | 1.4339 | 1.4254 | 1.4307 | 8713768.0 |
| 2005-06-01 09:45:00 | AAPL | Stock | 1.4314 | 1.4357 | 1.4282 | 1.4357 | 7376264.0 |
| 2005-06-01 09:50:00 | AAPL | Stock | 1.4354 | 1.4386 | 1.4332 | 1.4336 | 8723092.0 |
| 2005-06-01 09:55:00 | AAPL | Stock | 1.4339 | 1.4379 | 1.4336 | 1.4371 | 6862464.0 |
| 2005-06-01 10:00:00 | AAPL | Stock | 1.4371 | 1.4421 | 1.4368 | 1.4407 | 14370524.0 |
| 2005-06-01 10:05:00 | AAPL | Stock | 1.4409 | 1.4514 | 1.4396 | 1.4507 | 20722968.0 |
| 2005-06-01 10:10:00 | AAPL | Stock | 1.4511 | 1.4518 | 1.4475 | 1.4518 | 15040984.0 |
| 2005-06-01 10:15:00 | AAPL | Stock | 1.4521 | 1.4557 | 1.45 | 1.4504 | 15780268.0 |
| 2005-06-01 10:20:00 | AAPL | Stock | 1.4504 | 1.4529 | 1.4468 | 1.4525 | 7742532.0 |
| 2005-06-01 10:25:00 | AAPL | Stock | 1.4525 | 1.4532 | 1.4414 | 1.4511 | 6780172.0 |
| 2005-06-01 10:30:00 | AAPL | Stock | 1.4514 | 1.4543 | 1.4511 | 1.4521 | 8581356.0 |
| 2005-06-01 10:35:00 | AAPL | Stock | 1.4521 | 1.4536 | 1.4493 | 1.45 | 7853048.0 |
| 2005-06-01 10:40:00 | AAPL | Stock | 1.45 | 1.4507 | 1.4479 | 1.4479 | 6025880.0 |
| 2005-06-01 10:45:00 | AAPL | Stock | 1.4496 | 1.45 | 1.4464 | 1.4475 | 5566204.0 |
| 2005-06-01 10:50:00 | AAPL | Stock | 1.4475 | 1.4475 | 1.4443 | 1.4475 | 6567820.0 |
| 2005-06-01 10:55:00 | AAPL | Stock | 1.4475 | 1.4479 | 1.4464 | 1.4464 | 3880520.0 |
| 2005-06-01 11:00:00 | AAPL | Stock | 1.4468 | 1.4479 | 1.4454 | 1.4468 | 5741064.0 |
| 2005-06-01 11:05:00 | AAPL | Stock | 1.4475 | 1.4489 | 1.4471 | 1.4479 | 5616548.0 |
| 2005-06-01 11:10:00 | AAPL | Stock | 1.4479 | 1.4504 | 1.4475 | 1.4489 | 4357864.0 |
| 2005-06-01 11:15:00 | AAPL | Stock | 1.4489 | 1.4532 | 1.4486 | 1.4514 | 7121044.0 |
| 2005-06-01 11:20:00 | AAPL | Stock | 1.4511 | 1.4529 | 1.45 | 1.4507 | 4799508.0 |
| 2005-06-01 11:25:00 | AAPL | Stock | 1.4511 | 1.4529 | 1.45 | 1.4518 | 3016720.0 |
| 2005-06-01 11:30:00 | AAPL | Stock | 1.4518 | 1.4529 | 1.4511 | 1.4521 | 3907400.0 |
| 2005-06-01 11:35:00 | AAPL | Stock | 1.4521 | 1.4532 | 1.4511 | 1.4514 | 2442524.0 |
| 2005-06-01 11:40:00 | AAPL | Stock | 1.4511 | 1.4511 | 1.4479 | 1.4486 | 6029632.0 |
| 2005-06-01 11:45:00 | AAPL | Stock | 1.4486 | 1.4504 | 1.4486 | 1.45 | 1325940.0 |
| 2005-06-01 11:50:00 | AAPL | Stock | 1.45 | 1.4518 | 1.4493 | 1.4511 | 3614380.0 |
| 2005-06-01 11:55:00 | AAPL | Stock | 1.4511 | 1.4518 | 1.4489 | 1.45 | 6512912.0 |
| 2005-06-01 12:00:00 | AAPL | Stock | 1.4496 | 1.4511 | 1.4496 | 1.4496 | 2971808.0 |
| 2005-06-01 12:05:00 | AAPL | Stock | 1.4496 | 1.4507 | 1.4475 | 1.4482 | 3078992.0 |
| 2005-06-01 12:10:00 | AAPL | Stock | 1.4482 | 1.4493 | 1.4475 | 1.4489 | 2835952.0 |
| 2005-06-01 12:15:00 | AAPL | Stock | 1.4489 | 1.4514 | 1.4489 | 1.45 | 2362304.0 |
| 2005-06-01 12:20:00 | AAPL | Stock | 1.45 | 1.4507 | 1.4496 | 1.4498 | 2450784.0 |
| 2005-06-01 12:25:00 | AAPL | Stock | 1.4496 | 1.4511 | 1.4496 | 1.4511 | 2236444.0 |
| 2005-06-01 12:30:00 | AAPL | Stock | 1.4511 | 1.4511 | 1.45 | 1.45 | 3081540.0 |
| 2005-06-01 12:35:00 | AAPL | Stock | 1.45 | 1.4507 | 1.45 | 1.4507 | 2038568.0 |
> showing 50 of 198,440 rows — these rows as CSV