PREVIEW / stock_1min / 2009-12-30
file: by_date/stock_1min/2009/2009-12-30.parquet size: 11.8 MB rows: 894,040 symbols: 2,822
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-30 05:29:00 | AAPL | Stock | 7.4336 | 7.4336 | 7.4336 | 7.4336 | 8400.0 |
| 2009-12-30 06:43:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4289 | 7.4289 | 2800.0 |
| 2009-12-30 06:49:00 | AAPL | Stock | 7.4221 | 7.4221 | 7.4221 | 7.4221 | 2800.0 |
| 2009-12-30 06:51:00 | AAPL | Stock | 7.4229 | 7.4229 | 7.4229 | 7.4229 | 44800.0 |
| 2009-12-30 06:57:00 | AAPL | Stock | 7.4125 | 7.4125 | 7.4125 | 7.4125 | 2800.0 |
| 2009-12-30 07:00:00 | AAPL | Stock | 7.4211 | 7.4211 | 7.4211 | 7.4211 | 2800.0 |
| 2009-12-30 07:01:00 | AAPL | Stock | 7.4211 | 7.4211 | 7.4211 | 7.4211 | 11200.0 |
| 2009-12-30 07:03:00 | AAPL | Stock | 7.4196 | 7.4196 | 7.4196 | 7.4196 | 2800.0 |
| 2009-12-30 07:07:00 | AAPL | Stock | 7.4243 | 7.4243 | 7.4243 | 7.4243 | 18900.0 |
| 2009-12-30 07:22:00 | AAPL | Stock | 7.4204 | 7.4204 | 7.4196 | 7.4196 | 14000.0 |
| 2009-12-30 07:25:00 | AAPL | Stock | 7.4254 | 7.4254 | 7.4254 | 7.4254 | 5600.0 |
| 2009-12-30 07:28:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 8400.0 |
| 2009-12-30 07:29:00 | AAPL | Stock | 7.4268 | 7.4275 | 7.4268 | 7.4275 | 18200.0 |
| 2009-12-30 07:30:00 | AAPL | Stock | 7.4264 | 7.4264 | 7.4264 | 7.4264 | 2800.0 |
| 2009-12-30 07:34:00 | AAPL | Stock | 7.4275 | 7.4275 | 7.4275 | 7.4275 | 5600.0 |
| 2009-12-30 07:35:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4282 | 7.4282 | 19600.0 |
| 2009-12-30 07:36:00 | AAPL | Stock | 7.4257 | 7.4271 | 7.425 | 7.4271 | 45780.0 |
| 2009-12-30 07:37:00 | AAPL | Stock | 7.4271 | 7.4271 | 7.4271 | 7.4271 | 2828.0 |
| 2009-12-30 07:39:00 | AAPL | Stock | 7.4275 | 7.4275 | 7.4275 | 7.4275 | 2800.0 |
| 2009-12-30 07:40:00 | AAPL | Stock | 7.4282 | 7.4282 | 7.4282 | 7.4282 | 9800.0 |
| 2009-12-30 07:57:00 | AAPL | Stock | 7.445 | 7.4571 | 7.445 | 7.4571 | 25200.0 |
| 2009-12-30 07:58:00 | AAPL | Stock | 7.4461 | 7.4464 | 7.4461 | 7.4464 | 18480.0 |
| 2009-12-30 07:59:00 | AAPL | Stock | 7.4464 | 7.4525 | 7.4464 | 7.4468 | 11200.0 |
| 2009-12-30 08:00:00 | AAPL | Stock | 7.4468 | 7.4582 | 7.4464 | 7.4571 | 252308.0 |
| 2009-12-30 08:01:00 | AAPL | Stock | 7.4554 | 7.4643 | 7.4554 | 7.4639 | 120064.0 |
| 2009-12-30 08:02:00 | AAPL | Stock | 7.4607 | 7.4636 | 7.4571 | 7.4571 | 45080.0 |
| 2009-12-30 08:03:00 | AAPL | Stock | 7.4536 | 7.4571 | 7.4536 | 7.4543 | 47880.0 |
| 2009-12-30 08:04:00 | AAPL | Stock | 7.4571 | 7.4686 | 7.4561 | 7.4618 | 106792.0 |
| 2009-12-30 08:05:00 | AAPL | Stock | 7.4589 | 7.4589 | 7.4589 | 7.4589 | 5600.0 |
| 2009-12-30 08:06:00 | AAPL | Stock | 7.4589 | 7.4593 | 7.4571 | 7.4571 | 85036.0 |
| 2009-12-30 08:07:00 | AAPL | Stock | 7.4539 | 7.4539 | 7.4511 | 7.4529 | 24220.0 |
| 2009-12-30 08:08:00 | AAPL | Stock | 7.4482 | 7.45 | 7.4464 | 7.4468 | 19600.0 |
| 2009-12-30 08:09:00 | AAPL | Stock | 7.4496 | 7.4496 | 7.4461 | 7.4475 | 111720.0 |
| 2009-12-30 08:10:00 | AAPL | Stock | 7.4525 | 7.4536 | 7.4475 | 7.4518 | 100800.0 |
| 2009-12-30 08:11:00 | AAPL | Stock | 7.4525 | 7.4525 | 7.4504 | 7.4504 | 14000.0 |
| 2009-12-30 08:12:00 | AAPL | Stock | 7.4536 | 7.4554 | 7.4536 | 7.4554 | 11200.0 |
| 2009-12-30 08:13:00 | AAPL | Stock | 7.4554 | 7.4643 | 7.4554 | 7.4643 | 137200.0 |
| 2009-12-30 08:14:00 | AAPL | Stock | 7.4668 | 7.4668 | 7.4643 | 7.4643 | 50680.0 |
| 2009-12-30 08:15:00 | AAPL | Stock | 7.4593 | 7.4636 | 7.4589 | 7.4589 | 45360.0 |
| 2009-12-30 08:16:00 | AAPL | Stock | 7.4575 | 7.4586 | 7.4571 | 7.4586 | 11200.0 |
| 2009-12-30 08:17:00 | AAPL | Stock | 7.4571 | 7.46 | 7.4561 | 7.4579 | 50400.0 |
| 2009-12-30 08:18:00 | AAPL | Stock | 7.46 | 7.46 | 7.4482 | 7.4504 | 96320.0 |
| 2009-12-30 08:19:00 | AAPL | Stock | 7.4536 | 7.4536 | 7.4482 | 7.4482 | 81760.0 |
| 2009-12-30 08:20:00 | AAPL | Stock | 7.4486 | 7.4486 | 7.4486 | 7.4486 | 2800.0 |
| 2009-12-30 08:21:00 | AAPL | Stock | 7.4532 | 7.4536 | 7.4518 | 7.4518 | 22540.0 |
| 2009-12-30 08:22:00 | AAPL | Stock | 7.4518 | 7.4571 | 7.4518 | 7.4571 | 23800.0 |
| 2009-12-30 08:25:00 | AAPL | Stock | 7.4568 | 7.4568 | 7.4568 | 7.4568 | 4200.0 |
| 2009-12-30 08:26:00 | AAPL | Stock | 7.4536 | 7.455 | 7.4507 | 7.4507 | 31948.0 |
| 2009-12-30 08:27:00 | AAPL | Stock | 7.4511 | 7.4511 | 7.4504 | 7.4504 | 32200.0 |
| 2009-12-30 08:28:00 | AAPL | Stock | 7.4532 | 7.4532 | 7.45 | 7.45 | 17080.0 |
> showing 50 of 894,040 rows — these rows as CSV