PREVIEW / stock_5min / 2009-04-29
file: by_date/stock_5min/2009/2009-04-29.parquet size: 4.5 MB rows: 311,908 symbols: 3,324
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-04-29 07:40:00 | AAPL | Stock | 4.4636 | 4.4643 | 4.4636 | 4.4643 | 11144.0 |
| 2009-04-29 07:45:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4732 | 4.4732 | 5600.0 |
| 2009-04-29 07:50:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4732 | 4.4732 | 16800.0 |
| 2009-04-29 07:55:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4732 | 4.4732 | 28000.0 |
| 2009-04-29 08:00:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4571 | 4.4579 | 104300.0 |
| 2009-04-29 08:05:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4636 | 4.4643 | 47544.0 |
| 2009-04-29 08:10:00 | AAPL | Stock | 4.4671 | 4.4679 | 4.4632 | 4.4643 | 210476.0 |
| 2009-04-29 08:15:00 | AAPL | Stock | 4.4661 | 4.4696 | 4.4661 | 4.4671 | 132048.0 |
| 2009-04-29 08:20:00 | AAPL | Stock | 4.4696 | 4.4696 | 4.4671 | 4.4696 | 17052.0 |
| 2009-04-29 08:25:00 | AAPL | Stock | 4.4671 | 4.4693 | 4.4664 | 4.4664 | 58772.0 |
| 2009-04-29 08:30:00 | AAPL | Stock | 4.4679 | 4.4743 | 4.4575 | 4.4732 | 463120.0 |
| 2009-04-29 08:35:00 | AAPL | Stock | 4.4732 | 4.4761 | 4.4643 | 4.4643 | 308280.0 |
| 2009-04-29 08:40:00 | AAPL | Stock | 4.465 | 4.4696 | 4.4643 | 4.4696 | 72912.0 |
| 2009-04-29 08:45:00 | AAPL | Stock | 4.4696 | 4.4707 | 4.4661 | 4.4661 | 54880.0 |
| 2009-04-29 08:50:00 | AAPL | Stock | 4.4668 | 4.4679 | 4.4621 | 4.4621 | 129920.0 |
| 2009-04-29 08:55:00 | AAPL | Stock | 4.4621 | 4.4643 | 4.4607 | 4.4607 | 92400.0 |
| 2009-04-29 09:00:00 | AAPL | Stock | 4.4593 | 4.4593 | 4.4593 | 4.4593 | 2800.0 |
| 2009-04-29 09:05:00 | AAPL | Stock | 4.4607 | 4.4643 | 4.4593 | 4.4593 | 174720.0 |
| 2009-04-29 09:10:00 | AAPL | Stock | 4.4586 | 4.4607 | 4.4586 | 4.4586 | 194600.0 |
| 2009-04-29 09:15:00 | AAPL | Stock | 4.4586 | 4.4586 | 4.4586 | 4.4586 | 22036.0 |
| 2009-04-29 09:20:00 | AAPL | Stock | 4.4586 | 4.4604 | 4.4586 | 4.4604 | 19236.0 |
| 2009-04-29 09:25:00 | AAPL | Stock | 4.46 | 4.46 | 4.4536 | 4.46 | 57400.0 |
| 2009-04-29 09:30:00 | AAPL | Stock | 4.46 | 4.4614 | 4.4225 | 4.4389 | 12814172.0 |
| 2009-04-29 09:35:00 | AAPL | Stock | 4.4389 | 4.4575 | 4.4371 | 4.4575 | 7230496.0 |
| 2009-04-29 09:40:00 | AAPL | Stock | 4.4575 | 4.4596 | 4.4339 | 4.4536 | 9615816.0 |
| 2009-04-29 09:45:00 | AAPL | Stock | 4.4529 | 4.47 | 4.4496 | 4.4496 | 10761604.0 |
| 2009-04-29 09:50:00 | AAPL | Stock | 4.4496 | 4.4671 | 4.4496 | 4.4593 | 8125068.0 |
| 2009-04-29 09:55:00 | AAPL | Stock | 4.4593 | 4.4636 | 4.4557 | 4.4632 | 4147108.0 |
| 2009-04-29 10:00:00 | AAPL | Stock | 4.4625 | 4.4679 | 4.4521 | 4.4532 | 6414016.0 |
| 2009-04-29 10:05:00 | AAPL | Stock | 4.4525 | 4.4604 | 4.4504 | 4.4582 | 6356700.0 |
| 2009-04-29 10:10:00 | AAPL | Stock | 4.4579 | 4.4596 | 4.4343 | 4.4379 | 9954784.0 |
| 2009-04-29 10:15:00 | AAPL | Stock | 4.4379 | 4.4568 | 4.4375 | 4.4564 | 7743204.0 |
| 2009-04-29 10:20:00 | AAPL | Stock | 4.4564 | 4.4661 | 4.45 | 4.4639 | 8588776.0 |
| 2009-04-29 10:25:00 | AAPL | Stock | 4.4639 | 4.4679 | 4.4611 | 4.4621 | 4627840.0 |
| 2009-04-29 10:30:00 | AAPL | Stock | 4.4621 | 4.4668 | 4.4536 | 4.4571 | 4867240.0 |
| 2009-04-29 10:35:00 | AAPL | Stock | 4.4561 | 4.4618 | 4.4532 | 4.4589 | 3400936.0 |
| 2009-04-29 10:40:00 | AAPL | Stock | 4.4589 | 4.4661 | 4.4564 | 4.4643 | 5164348.0 |
| 2009-04-29 10:45:00 | AAPL | Stock | 4.4636 | 4.4643 | 4.4554 | 4.4568 | 4447604.0 |
| 2009-04-29 10:50:00 | AAPL | Stock | 4.4566 | 4.4636 | 4.4554 | 4.4618 | 4164104.0 |
| 2009-04-29 10:55:00 | AAPL | Stock | 4.4618 | 4.4643 | 4.4564 | 4.463 | 3077284.0 |
| 2009-04-29 11:00:00 | AAPL | Stock | 4.4625 | 4.4664 | 4.4475 | 4.4514 | 6690292.0 |
| 2009-04-29 11:05:00 | AAPL | Stock | 4.4512 | 4.4554 | 4.4436 | 4.45 | 5491500.0 |
| 2009-04-29 11:10:00 | AAPL | Stock | 4.45 | 4.4625 | 4.4489 | 4.4604 | 4679948.0 |
| 2009-04-29 11:15:00 | AAPL | Stock | 4.4607 | 4.4761 | 4.4586 | 4.47 | 7353556.0 |
| 2009-04-29 11:20:00 | AAPL | Stock | 4.47 | 4.4829 | 4.4675 | 4.4804 | 6459992.0 |
| 2009-04-29 11:25:00 | AAPL | Stock | 4.4804 | 4.4864 | 4.4804 | 4.4821 | 6323156.0 |
| 2009-04-29 11:30:00 | AAPL | Stock | 4.4829 | 4.4846 | 4.4754 | 4.4775 | 3907176.0 |
| 2009-04-29 11:35:00 | AAPL | Stock | 4.4779 | 4.4854 | 4.4736 | 4.4793 | 2789388.0 |
| 2009-04-29 11:40:00 | AAPL | Stock | 4.4804 | 4.4846 | 4.4732 | 4.4739 | 2571940.0 |
| 2009-04-29 11:45:00 | AAPL | Stock | 4.4739 | 4.4818 | 4.4736 | 4.48 | 2538508.0 |
> showing 50 of 311,908 rows — these rows as CSV