PREVIEW / stock_1hour / 2005-02-16
file: by_date/stock_1hour/2005/2005-02-16.parquet size: 561 KB rows: 26,082 symbols: 1,938
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-16 08:00:00 | AAPL | Stock | 1.5882 | 1.5921 | 1.5593 | 1.5679 | 15849288.0 |
| 2005-02-16 09:00:00 | AAPL | Stock | 1.5675 | 1.5788 | 1.5598 | 1.5759 | 219582888.0 |
| 2005-02-16 10:00:00 | AAPL | Stock | 1.5759 | 1.5948 | 1.5634 | 1.5761 | 409585624.0 |
| 2005-02-16 11:00:00 | AAPL | Stock | 1.5761 | 1.5848 | 1.5688 | 1.5754 | 156686768.0 |
| 2005-02-16 12:00:00 | AAPL | Stock | 1.5754 | 1.5889 | 1.5705 | 1.5841 | 117526080.0 |
| 2005-02-16 13:00:00 | AAPL | Stock | 1.5845 | 1.597 | 1.5807 | 1.5918 | 188090952.0 |
| 2005-02-16 14:00:00 | AAPL | Stock | 1.5916 | 1.6027 | 1.5896 | 1.6023 | 170385096.0 |
| 2005-02-16 15:00:00 | AAPL | Stock | 1.602 | 1.6107 | 1.6013 | 1.6093 | 331387784.0 |
| 2005-02-16 16:00:00 | AAPL | Stock | 1.6093 | 1.6154 | 1.6064 | 1.6107 | 8529976.0 |
| 2005-02-16 17:00:00 | AAPL | Stock | 1.6107 | 1.6134 | 1.6091 | 1.6123 | 2227512.0 |
| 2005-02-16 18:00:00 | AAPL | Stock | 1.6125 | 1.6141 | 1.5868 | 1.6141 | 801920.0 |
| 2005-02-16 08:00:00 | MSFT | Stock | 25.9 | 25.93 | 25.83 | 25.87 | 64397.0 |
| 2005-02-16 09:00:00 | MSFT | Stock | 25.87 | 25.93 | 25.83 | 25.85 | 5680751.0 |
| 2005-02-16 10:00:00 | MSFT | Stock | 25.85 | 25.93 | 25.829 | 25.859 | 8965286.0 |
| 2005-02-16 11:00:00 | MSFT | Stock | 25.859 | 25.87 | 25.76 | 25.782 | 7297078.0 |
| 2005-02-16 12:00:00 | MSFT | Stock | 25.782 | 25.85 | 25.7 | 25.74 | 6775004.0 |
| 2005-02-16 13:00:00 | MSFT | Stock | 25.75 | 25.86 | 25.67 | 25.77 | 7809802.0 |
| 2005-02-16 14:00:00 | MSFT | Stock | 25.77 | 25.86 | 25.75 | 25.85 | 8042321.0 |
| 2005-02-16 15:00:00 | MSFT | Stock | 25.852 | 25.88 | 25.78 | 25.79 | 10087703.0 |
| 2005-02-16 16:00:00 | MSFT | Stock | 25.79 | 25.85 | 25.78 | 25.8 | 585146.0 |
| 2005-02-16 17:00:00 | MSFT | Stock | 25.8 | 25.81 | 25.771 | 25.771 | 30264.0 |
| 2005-02-16 18:00:00 | MSFT | Stock | 25.79 | 25.817 | 25.79 | 25.81 | 3614.0 |
| 2005-02-16 08:00:00 | NVDA | Stock | 0.2156 | 0.2187 | 0.2133 | 0.2137 | 468000.0 |
| 2005-02-16 09:00:00 | NVDA | Stock | 0.2157 | 0.2162 | 0.2107 | 0.2151 | 76242000.0 |
| 2005-02-16 10:00:00 | NVDA | Stock | 0.2151 | 0.2177 | 0.2135 | 0.2148 | 78436920.0 |
| 2005-02-16 11:00:00 | NVDA | Stock | 0.2148 | 0.2157 | 0.2128 | 0.2136 | 51520680.0 |
| 2005-02-16 12:00:00 | NVDA | Stock | 0.2136 | 0.2147 | 0.2126 | 0.2132 | 37957680.0 |
| 2005-02-16 13:00:00 | NVDA | Stock | 0.2133 | 0.2144 | 0.2127 | 0.2133 | 44902920.0 |
| 2005-02-16 14:00:00 | NVDA | Stock | 0.2134 | 0.2162 | 0.2132 | 0.2162 | 61161240.0 |
| 2005-02-16 15:00:00 | NVDA | Stock | 0.216 | 0.2162 | 0.2133 | 0.2144 | 103028760.0 |
| 2005-02-16 16:00:00 | NVDA | Stock | 0.2145 | 0.2149 | 0.2137 | 0.2145 | 3601680.0 |
| 2005-02-16 17:00:00 | NVDA | Stock | 0.2137 | 0.2142 | 0.2137 | 0.2142 | 578400.0 |
| 2005-02-16 18:00:00 | NVDA | Stock | 0.2142 | 0.2145 | 0.2142 | 0.2145 | 300000.0 |
| 2005-02-16 08:00:00 | AMZN | Stock | 1.81 | 1.81 | 1.805 | 1.805 | 12000.0 |
| 2005-02-16 09:00:00 | AMZN | Stock | 1.807 | 1.809 | 1.79 | 1.797 | 14275760.0 |
| 2005-02-16 10:00:00 | AMZN | Stock | 1.797 | 1.8175 | 1.792 | 1.795 | 27302000.0 |
| 2005-02-16 11:00:00 | AMZN | Stock | 1.795 | 1.8015 | 1.791 | 1.7955 | 14540600.0 |
| 2005-02-16 12:00:00 | AMZN | Stock | 1.795 | 1.7965 | 1.791 | 1.792 | 6329900.0 |
| 2005-02-16 13:00:00 | AMZN | Stock | 1.7915 | 1.8 | 1.779 | 1.787 | 12993220.0 |
| 2005-02-16 14:00:00 | AMZN | Stock | 1.787 | 1.792 | 1.783 | 1.7895 | 10710680.0 |
| 2005-02-16 15:00:00 | AMZN | Stock | 1.7895 | 1.791 | 1.7795 | 1.782 | 15296280.0 |
| 2005-02-16 16:00:00 | AMZN | Stock | 1.783 | 1.787 | 1.78 | 1.787 | 756200.0 |
| 2005-02-16 17:00:00 | AMZN | Stock | 1.787 | 1.787 | 1.787 | 1.787 | 9400.0 |
| 2005-02-16 18:00:00 | AMZN | Stock | 1.783 | 1.783 | 1.783 | 1.783 | 10000.0 |
| 2005-02-16 09:00:00 | CL | Stock | 26.96 | 27.01 | 26.85 | 26.87 | 395800.0 |
| 2005-02-16 10:00:00 | CL | Stock | 26.87 | 26.94 | 26.79 | 26.865 | 929000.0 |
| 2005-02-16 11:00:00 | CL | Stock | 26.865 | 27.0 | 26.84 | 26.99 | 664000.0 |
| 2005-02-16 12:00:00 | CL | Stock | 26.99 | 27.0 | 26.95 | 26.955 | 532000.0 |
| 2005-02-16 13:00:00 | CL | Stock | 26.955 | 27.01 | 26.925 | 26.99 | 609000.0 |
| 2005-02-16 14:00:00 | CL | Stock | 27.0 | 27.03 | 26.965 | 27.015 | 559000.0 |
> showing 50 of 26,082 rows — these rows as CSV