PREVIEW / stock_1hour / 2003-12-05
file: by_date/stock_1hour/2003/2003-12-05.parquet size: 484 KB rows: 22,271 symbols: 1,683
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-05 08:00:00 | AAPL | Stock | 0.3775 | 0.3775 | 0.375 | 0.375 | 733600.0 |
| 2003-12-05 09:00:00 | AAPL | Stock | 0.3729 | 0.375 | 0.3705 | 0.3748 | 16644768.0 |
| 2003-12-05 10:00:00 | AAPL | Stock | 0.3746 | 0.3771 | 0.3734 | 0.375 | 16389408.0 |
| 2003-12-05 11:00:00 | AAPL | Stock | 0.375 | 0.3777 | 0.3737 | 0.375 | 23341136.0 |
| 2003-12-05 12:00:00 | AAPL | Stock | 0.3748 | 0.3752 | 0.3721 | 0.3741 | 15459192.0 |
| 2003-12-05 13:00:00 | AAPL | Stock | 0.3741 | 0.3743 | 0.3705 | 0.3716 | 24294760.0 |
| 2003-12-05 14:00:00 | AAPL | Stock | 0.3716 | 0.3718 | 0.3702 | 0.3714 | 18880680.0 |
| 2003-12-05 15:00:00 | AAPL | Stock | 0.3714 | 0.3741 | 0.3704 | 0.373 | 30729440.0 |
| 2003-12-05 16:00:00 | AAPL | Stock | 0.3732 | 0.3777 | 0.3707 | 0.3723 | 6363616.0 |
| 2003-12-05 08:00:00 | MSFT | Stock | 26.03 | 26.1 | 25.91 | 25.95 | 139104.0 |
| 2003-12-05 09:00:00 | MSFT | Stock | 25.95 | 27.0 | 25.92 | 26.2 | 8457667.0 |
| 2003-12-05 10:00:00 | MSFT | Stock | 26.19 | 26.46 | 26.14 | 26.22 | 15501566.0 |
| 2003-12-05 11:00:00 | MSFT | Stock | 26.21 | 26.39 | 26.15 | 26.21 | 9582367.0 |
| 2003-12-05 12:00:00 | MSFT | Stock | 26.21 | 26.26 | 26.12 | 26.21 | 10059513.0 |
| 2003-12-05 13:00:00 | MSFT | Stock | 26.22 | 26.23 | 26.05 | 26.05 | 11596801.0 |
| 2003-12-05 14:00:00 | MSFT | Stock | 26.05 | 26.12 | 26.01 | 26.07 | 10037579.0 |
| 2003-12-05 15:00:00 | MSFT | Stock | 26.07 | 26.1 | 25.919 | 25.99 | 14470542.0 |
| 2003-12-05 16:00:00 | MSFT | Stock | 25.97 | 26.2 | 25.9 | 25.94 | 1420360.0 |
| 2003-12-05 17:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.94 | 25.96 | 14669.0 |
| 2003-12-05 18:00:00 | MSFT | Stock | 25.97 | 25.97 | 25.94 | 25.96 | 3705.0 |
| 2003-12-05 08:00:00 | NVDA | Stock | 0.1765 | 0.1765 | 0.1712 | 0.1712 | 828000.0 |
| 2003-12-05 09:00:00 | NVDA | Stock | 0.1712 | 0.1726 | 0.1702 | 0.1717 | 40031160.0 |
| 2003-12-05 10:00:00 | NVDA | Stock | 0.1719 | 0.1739 | 0.1711 | 0.173 | 46937160.0 |
| 2003-12-05 11:00:00 | NVDA | Stock | 0.1731 | 0.1765 | 0.172 | 0.1759 | 89596920.0 |
| 2003-12-05 12:00:00 | NVDA | Stock | 0.1762 | 0.1762 | 0.1739 | 0.1749 | 67413240.0 |
| 2003-12-05 13:00:00 | NVDA | Stock | 0.175 | 0.1751 | 0.1691 | 0.1697 | 89858880.0 |
| 2003-12-05 14:00:00 | NVDA | Stock | 0.1697 | 0.171 | 0.1688 | 0.1702 | 50468760.0 |
| 2003-12-05 15:00:00 | NVDA | Stock | 0.1703 | 0.1718 | 0.1689 | 0.1708 | 82384440.0 |
| 2003-12-05 16:00:00 | NVDA | Stock | 0.1706 | 0.1759 | 0.1699 | 0.17 | 6257520.0 |
| 2003-12-05 17:00:00 | NVDA | Stock | 0.1702 | 0.1702 | 0.17 | 0.17 | 276000.0 |
| 2003-12-05 08:00:00 | AMZN | Stock | 2.59 | 2.59 | 2.5575 | 2.5695 | 276000.0 |
| 2003-12-05 09:00:00 | AMZN | Stock | 2.5575 | 2.622 | 2.5556 | 2.6145 | 23148000.0 |
| 2003-12-05 10:00:00 | AMZN | Stock | 2.6145 | 2.635 | 2.5995 | 2.6095 | 27887060.0 |
| 2003-12-05 11:00:00 | AMZN | Stock | 2.6107 | 2.621 | 2.5955 | 2.6 | 11685200.0 |
| 2003-12-05 12:00:00 | AMZN | Stock | 2.6 | 2.6205 | 2.59 | 2.6205 | 10997740.0 |
| 2003-12-05 13:00:00 | AMZN | Stock | 2.6205 | 2.6215 | 2.578 | 2.5815 | 13786620.0 |
| 2003-12-05 14:00:00 | AMZN | Stock | 2.579 | 2.5875 | 2.5695 | 2.578 | 14160400.0 |
| 2003-12-05 15:00:00 | AMZN | Stock | 2.578 | 2.5925 | 2.5685 | 2.574 | 18367300.0 |
| 2003-12-05 16:00:00 | AMZN | Stock | 2.573 | 2.59 | 2.572 | 2.573 | 2308740.0 |
| 2003-12-05 17:00:00 | AMZN | Stock | 2.576 | 2.58 | 2.576 | 2.576 | 68380.0 |
| 2003-12-05 09:00:00 | CL | Stock | 26.75 | 26.83 | 26.735 | 26.8 | 248600.0 |
| 2003-12-05 10:00:00 | CL | Stock | 26.805 | 26.925 | 26.775 | 26.915 | 688400.0 |
| 2003-12-05 11:00:00 | CL | Stock | 26.915 | 26.985 | 26.885 | 26.985 | 314800.0 |
| 2003-12-05 12:00:00 | CL | Stock | 26.99 | 27.0 | 26.91 | 26.955 | 900800.0 |
| 2003-12-05 13:00:00 | CL | Stock | 26.96 | 26.97 | 26.83 | 26.865 | 412800.0 |
| 2003-12-05 14:00:00 | CL | Stock | 26.87 | 26.895 | 26.815 | 26.895 | 591400.0 |
| 2003-12-05 15:00:00 | CL | Stock | 26.895 | 26.945 | 26.84 | 26.93 | 680800.0 |
| 2003-12-05 16:00:00 | CL | Stock | 26.935 | 26.935 | 26.893 | 26.893 | 61800.0 |
> showing 48 of 22,271 rows — these rows as CSV