PREVIEW / stock_30min / 2006-03-02
file: by_date/stock_30min/2006/2006-03-02.parquet size: 904 KB rows: 48,341 symbols: 2,193
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-02 06:00:00 | AAPL | Stock | 2.4643 | 2.4643 | 2.4643 | 2.4643 | 28000.0 |
| 2006-03-02 07:00:00 | AAPL | Stock | 2.475 | 2.475 | 2.4639 | 2.4643 | 140280.0 |
| 2006-03-02 07:30:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.4661 | 2.4661 | 2800.0 |
| 2006-03-02 08:00:00 | AAPL | Stock | 2.4821 | 2.4821 | 2.4696 | 2.4729 | 677600.0 |
| 2006-03-02 08:30:00 | AAPL | Stock | 2.4704 | 2.4704 | 2.4596 | 2.4643 | 511028.0 |
| 2006-03-02 09:00:00 | AAPL | Stock | 2.4643 | 2.4661 | 2.4582 | 2.4643 | 944776.0 |
| 2006-03-02 09:30:00 | AAPL | Stock | 2.4637 | 2.4954 | 2.4575 | 2.4786 | 96699372.0 |
| 2006-03-02 10:00:00 | AAPL | Stock | 2.4786 | 2.4889 | 2.4593 | 2.4643 | 66995544.0 |
| 2006-03-02 10:30:00 | AAPL | Stock | 2.4643 | 2.4779 | 2.4525 | 2.4754 | 56504812.0 |
| 2006-03-02 11:00:00 | AAPL | Stock | 2.4754 | 2.4893 | 2.4736 | 2.4768 | 47180364.0 |
| 2006-03-02 11:30:00 | AAPL | Stock | 2.4764 | 2.4814 | 2.47 | 2.4721 | 34875988.0 |
| 2006-03-02 12:00:00 | AAPL | Stock | 2.4721 | 2.4725 | 2.46 | 2.4629 | 31163552.0 |
| 2006-03-02 12:30:00 | AAPL | Stock | 2.4632 | 2.4721 | 2.4607 | 2.4704 | 24647392.0 |
| 2006-03-02 13:00:00 | AAPL | Stock | 2.4704 | 2.4818 | 2.4682 | 2.4743 | 21898072.0 |
| 2006-03-02 13:30:00 | AAPL | Stock | 2.4746 | 2.4875 | 2.4721 | 2.4854 | 30225328.0 |
| 2006-03-02 14:00:00 | AAPL | Stock | 2.4857 | 2.4911 | 2.4732 | 2.4757 | 34360536.0 |
| 2006-03-02 14:30:00 | AAPL | Stock | 2.4761 | 2.485 | 2.475 | 2.4818 | 26374488.0 |
| 2006-03-02 15:00:00 | AAPL | Stock | 2.4821 | 2.4996 | 2.4814 | 2.4964 | 55166972.0 |
| 2006-03-02 15:30:00 | AAPL | Stock | 2.4968 | 2.4968 | 2.4714 | 2.4861 | 63747824.0 |
| 2006-03-02 16:00:00 | AAPL | Stock | 2.4864 | 2.4893 | 2.4807 | 2.4868 | 1104572.0 |
| 2006-03-02 16:30:00 | AAPL | Stock | 2.4889 | 2.4889 | 2.4861 | 2.4875 | 331940.0 |
| 2006-03-02 17:00:00 | AAPL | Stock | 2.4875 | 2.4911 | 2.4875 | 2.4886 | 427112.0 |
| 2006-03-02 17:30:00 | AAPL | Stock | 2.4886 | 2.4918 | 2.4886 | 2.4918 | 149856.0 |
| 2006-03-02 18:00:00 | AAPL | Stock | 2.4911 | 2.4918 | 2.4882 | 2.4911 | 308532.0 |
| 2006-03-02 07:00:00 | MSFT | Stock | 27.07 | 27.07 | 27.07 | 27.07 | 1000.0 |
| 2006-03-02 08:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.07 | 27.09 | 8973.0 |
| 2006-03-02 08:30:00 | MSFT | Stock | 27.08 | 27.11 | 27.08 | 27.11 | 15084.0 |
| 2006-03-02 09:00:00 | MSFT | Stock | 27.11 | 27.11 | 27.0 | 27.01 | 96653.0 |
| 2006-03-02 09:30:00 | MSFT | Stock | 27.02 | 27.05 | 26.97 | 26.99 | 4181606.0 |
| 2006-03-02 10:00:00 | MSFT | Stock | 27.0 | 27.04 | 26.95 | 27.03 | 3988241.0 |
| 2006-03-02 10:30:00 | MSFT | Stock | 27.03 | 27.06 | 27.0 | 27.03 | 2580502.0 |
| 2006-03-02 11:00:00 | MSFT | Stock | 27.03 | 27.1 | 27.01 | 27.04 | 2859086.0 |
| 2006-03-02 11:30:00 | MSFT | Stock | 27.04 | 27.05 | 26.97 | 26.99 | 2854918.0 |
| 2006-03-02 12:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.92 | 26.92 | 2418638.0 |
| 2006-03-02 12:30:00 | MSFT | Stock | 26.93 | 26.97 | 26.9 | 26.95 | 2408335.0 |
| 2006-03-02 13:00:00 | MSFT | Stock | 26.942 | 27.01 | 26.94 | 26.962 | 2965874.0 |
| 2006-03-02 13:30:00 | MSFT | Stock | 26.96 | 27.0 | 26.96 | 27.0 | 1591085.0 |
| 2006-03-02 14:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.91 | 26.92 | 3156280.0 |
| 2006-03-02 14:30:00 | MSFT | Stock | 26.91 | 27.0 | 26.91 | 26.962 | 1746677.0 |
| 2006-03-02 15:00:00 | MSFT | Stock | 26.97 | 27.07 | 26.96 | 27.032 | 3835619.0 |
| 2006-03-02 15:30:00 | MSFT | Stock | 27.04 | 27.04 | 26.96 | 26.98 | 4934360.0 |
| 2006-03-02 16:00:00 | MSFT | Stock | 26.98 | 27.02 | 26.97 | 27.0 | 278373.0 |
| 2006-03-02 16:30:00 | MSFT | Stock | 26.97 | 26.99 | 26.97 | 26.99 | 118579.0 |
| 2006-03-02 17:00:00 | MSFT | Stock | 27.0 | 27.015 | 26.99 | 26.99 | 24110.0 |
| 2006-03-02 17:30:00 | MSFT | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 300.0 |
| 2006-03-02 18:00:00 | MSFT | Stock | 27.0 | 27.0 | 26.97 | 26.97 | 6075.0 |
| 2006-03-02 07:00:00 | NVDA | Stock | 0.425 | 0.425 | 0.425 | 0.425 | 24000.0 |
| 2006-03-02 08:00:00 | NVDA | Stock | 0.4108 | 0.4115 | 0.4099 | 0.4099 | 192000.0 |
| 2006-03-02 08:30:00 | NVDA | Stock | 0.4086 | 0.4086 | 0.4086 | 0.4086 | 60000.0 |
| 2006-03-02 09:00:00 | NVDA | Stock | 0.4086 | 0.4086 | 0.4062 | 0.4065 | 948120.0 |
> showing 50 of 48,341 rows — these rows as CSV