PREVIEW / stock_30min / 2011-12-30
file: by_date/stock_30min/2011/2011-12-30.parquet size: 1.4 MB rows: 77,624 symbols: 3,599
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-30 05:30:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 28000.0 |
| 2011-12-30 06:00:00 | AAPL | Stock | 14.4675 | 14.4675 | 14.4675 | 14.4675 | 2800.0 |
| 2011-12-30 06:30:00 | AAPL | Stock | 14.4554 | 14.4571 | 14.4554 | 14.4571 | 14700.0 |
| 2011-12-30 07:00:00 | AAPL | Stock | 14.4718 | 14.4839 | 14.4714 | 14.475 | 82600.0 |
| 2011-12-30 07:30:00 | AAPL | Stock | 14.4664 | 14.4754 | 14.4604 | 14.4714 | 68180.0 |
| 2011-12-30 08:00:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.45 | 14.45 | 141260.0 |
| 2011-12-30 08:30:00 | AAPL | Stock | 14.45 | 14.4607 | 14.4286 | 14.4357 | 302876.0 |
| 2011-12-30 09:00:00 | AAPL | Stock | 14.4389 | 14.4504 | 14.3925 | 14.4204 | 1117984.0 |
| 2011-12-30 09:30:00 | AAPL | Stock | 14.4189 | 14.4804 | 14.4104 | 14.4772 | 24998176.0 |
| 2011-12-30 10:00:00 | AAPL | Stock | 14.4775 | 14.51 | 14.4739 | 14.4825 | 18643380.0 |
| 2011-12-30 10:30:00 | AAPL | Stock | 14.4825 | 14.4904 | 14.4686 | 14.4732 | 9753996.0 |
| 2011-12-30 11:00:00 | AAPL | Stock | 14.4711 | 14.4875 | 14.4643 | 14.48 | 9330944.0 |
| 2011-12-30 11:30:00 | AAPL | Stock | 14.4811 | 14.4857 | 14.4671 | 14.4675 | 8263052.0 |
| 2011-12-30 12:00:00 | AAPL | Stock | 14.4675 | 14.4771 | 14.467 | 14.468 | 9265928.0 |
| 2011-12-30 12:30:00 | AAPL | Stock | 14.4682 | 14.4811 | 14.4666 | 14.4782 | 7318332.0 |
| 2011-12-30 13:00:00 | AAPL | Stock | 14.4789 | 14.4857 | 14.4757 | 14.4761 | 6955592.0 |
| 2011-12-30 13:30:00 | AAPL | Stock | 14.4782 | 14.4811 | 14.475 | 14.4789 | 6323380.0 |
| 2011-12-30 14:00:00 | AAPL | Stock | 14.4793 | 14.4814 | 14.4618 | 14.465 | 10276672.0 |
| 2011-12-30 14:30:00 | AAPL | Stock | 14.4646 | 14.4693 | 14.4614 | 14.4643 | 8222172.0 |
| 2011-12-30 15:00:00 | AAPL | Stock | 14.4654 | 14.4707 | 14.4629 | 14.465 | 9736440.0 |
| 2011-12-30 15:30:00 | AAPL | Stock | 14.4643 | 14.4657 | 14.4514 | 14.4639 | 31177580.0 |
| 2011-12-30 16:00:00 | AAPL | Stock | 14.4643 | 14.4708 | 14.4607 | 14.4657 | 13317976.0 |
| 2011-12-30 16:30:00 | AAPL | Stock | 14.4657 | 14.4657 | 14.4607 | 14.4629 | 554512.0 |
| 2011-12-30 17:00:00 | AAPL | Stock | 14.4643 | 14.4679 | 14.4643 | 14.4661 | 51576.0 |
| 2011-12-30 17:30:00 | AAPL | Stock | 14.4643 | 14.4657 | 14.4643 | 14.4657 | 14000.0 |
| 2011-12-30 18:00:00 | AAPL | Stock | 14.4661 | 14.4679 | 14.4643 | 14.4679 | 29540.0 |
| 2011-12-30 18:30:00 | AAPL | Stock | 14.4693 | 14.4693 | 14.4646 | 14.465 | 51800.0 |
| 2011-12-30 19:00:00 | AAPL | Stock | 14.4643 | 14.4646 | 14.46 | 14.4643 | 54180.0 |
| 2011-12-30 19:30:00 | AAPL | Stock | 14.4643 | 14.4668 | 14.4636 | 14.4636 | 18676.0 |
| 2011-12-30 04:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.96 | 25.96 | 100.0 |
| 2011-12-30 05:30:00 | MSFT | Stock | 25.96 | 25.96 | 25.96 | 25.96 | 300.0 |
| 2011-12-30 08:00:00 | MSFT | Stock | 26.02 | 26.02 | 26.02 | 26.02 | 1200.0 |
| 2011-12-30 08:30:00 | MSFT | Stock | 26.03 | 26.03 | 26.02 | 26.02 | 2573.0 |
| 2011-12-30 09:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.96 | 25.99 | 14100.0 |
| 2011-12-30 09:30:00 | MSFT | Stock | 26.0 | 26.04 | 25.95 | 26.0 | 2048551.0 |
| 2011-12-30 10:00:00 | MSFT | Stock | 26.0 | 26.12 | 26.0 | 26.044 | 1916039.0 |
| 2011-12-30 10:30:00 | MSFT | Stock | 26.04 | 26.09 | 26.0 | 26.08 | 1553362.0 |
| 2011-12-30 11:00:00 | MSFT | Stock | 26.08 | 26.12 | 26.06 | 26.11 | 1584935.0 |
| 2011-12-30 11:30:00 | MSFT | Stock | 26.115 | 26.12 | 26.05 | 26.05 | 848071.0 |
| 2011-12-30 12:00:00 | MSFT | Stock | 26.05 | 26.08 | 26.03 | 26.06 | 1428222.0 |
| 2011-12-30 12:30:00 | MSFT | Stock | 26.06 | 26.095 | 26.05 | 26.08 | 713516.0 |
| 2011-12-30 13:00:00 | MSFT | Stock | 26.08 | 26.1 | 26.05 | 26.08 | 929087.0 |
| 2011-12-30 13:30:00 | MSFT | Stock | 26.07 | 26.1 | 26.07 | 26.08 | 903820.0 |
| 2011-12-30 14:00:00 | MSFT | Stock | 26.08 | 26.09 | 25.91 | 25.96 | 3010632.0 |
| 2011-12-30 14:30:00 | MSFT | Stock | 25.96 | 25.99 | 25.95 | 25.951 | 1464765.0 |
| 2011-12-30 15:00:00 | MSFT | Stock | 25.953 | 26.03 | 25.95 | 26.01 | 1680909.0 |
| 2011-12-30 15:30:00 | MSFT | Stock | 26.0 | 26.03 | 25.96 | 25.97 | 3790066.0 |
| 2011-12-30 16:00:00 | MSFT | Stock | 25.961 | 26.03 | 25.95 | 26.0 | 4247602.0 |
| 2011-12-30 16:30:00 | MSFT | Stock | 25.96 | 26.0 | 25.955 | 25.97 | 78732.0 |
| 2011-12-30 17:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.97 | 25.97 | 1000.0 |
> showing 50 of 77,624 rows — these rows as CSV