PREVIEW / stock_1hour / 2005-02-11
file: by_date/stock_1hour/2005/2005-02-11.parquet size: 543 KB rows: 25,281 symbols: 1,932
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-11 08:00:00 | AAPL | Stock | 1.4016 | 1.4409 | 1.4 | 1.4284 | 36476048.0 |
| 2005-02-11 09:00:00 | AAPL | Stock | 1.4284 | 1.432 | 1.4096 | 1.4261 | 205091768.0 |
| 2005-02-11 10:00:00 | AAPL | Stock | 1.4259 | 1.4596 | 1.425 | 1.4498 | 316878240.0 |
| 2005-02-11 11:00:00 | AAPL | Stock | 1.4495 | 1.46 | 1.4439 | 1.4448 | 201359704.0 |
| 2005-02-11 12:00:00 | AAPL | Stock | 1.445 | 1.4543 | 1.4429 | 1.4496 | 107444008.0 |
| 2005-02-11 13:00:00 | AAPL | Stock | 1.4496 | 1.452 | 1.4439 | 1.4488 | 88487896.0 |
| 2005-02-11 14:00:00 | AAPL | Stock | 1.4491 | 1.4525 | 1.4421 | 1.4495 | 89454680.0 |
| 2005-02-11 15:00:00 | AAPL | Stock | 1.4493 | 1.4552 | 1.4455 | 1.4511 | 144524632.0 |
| 2005-02-11 16:00:00 | AAPL | Stock | 1.4502 | 1.4543 | 1.4496 | 1.4534 | 4165224.0 |
| 2005-02-11 17:00:00 | AAPL | Stock | 1.4534 | 1.4541 | 1.4527 | 1.4539 | 809816.0 |
| 2005-02-11 18:00:00 | AAPL | Stock | 1.4539 | 1.4543 | 1.4527 | 1.4534 | 268632.0 |
| 2005-02-11 08:00:00 | MSFT | Stock | 26.05 | 26.05 | 26.01 | 26.02 | 10360.0 |
| 2005-02-11 09:00:00 | MSFT | Stock | 26.02 | 26.09 | 25.87 | 25.9 | 8959329.0 |
| 2005-02-11 10:00:00 | MSFT | Stock | 25.9 | 25.91 | 25.81 | 25.86 | 13302576.0 |
| 2005-02-11 11:00:00 | MSFT | Stock | 25.86 | 26.07 | 25.86 | 25.98 | 19356913.0 |
| 2005-02-11 12:00:00 | MSFT | Stock | 25.97 | 26.07 | 25.95 | 26.05 | 7240931.0 |
| 2005-02-11 13:00:00 | MSFT | Stock | 26.05 | 26.06 | 25.93 | 26.0 | 6842217.0 |
| 2005-02-11 14:00:00 | MSFT | Stock | 26.0 | 26.12 | 25.93 | 26.1 | 11409704.0 |
| 2005-02-11 15:00:00 | MSFT | Stock | 26.1 | 26.11 | 25.92 | 25.97 | 15209829.0 |
| 2005-02-11 16:00:00 | MSFT | Stock | 25.97 | 26.0 | 25.95 | 25.98 | 492946.0 |
| 2005-02-11 17:00:00 | MSFT | Stock | 25.97 | 25.98 | 25.96 | 25.98 | 17550.0 |
| 2005-02-11 18:00:00 | MSFT | Stock | 25.98 | 25.98 | 25.97 | 25.98 | 4500.0 |
| 2005-02-11 08:00:00 | NVDA | Stock | 0.2112 | 0.2113 | 0.2112 | 0.2113 | 216000.0 |
| 2005-02-11 09:00:00 | NVDA | Stock | 0.2112 | 0.2125 | 0.2097 | 0.2099 | 31853880.0 |
| 2005-02-11 10:00:00 | NVDA | Stock | 0.2099 | 0.2142 | 0.2098 | 0.2137 | 65717040.0 |
| 2005-02-11 11:00:00 | NVDA | Stock | 0.2138 | 0.2158 | 0.2134 | 0.2146 | 85807560.0 |
| 2005-02-11 12:00:00 | NVDA | Stock | 0.2145 | 0.2162 | 0.2132 | 0.216 | 61887960.0 |
| 2005-02-11 13:00:00 | NVDA | Stock | 0.2162 | 0.2193 | 0.2156 | 0.2187 | 127568880.0 |
| 2005-02-11 14:00:00 | NVDA | Stock | 0.2186 | 0.2195 | 0.2178 | 0.2191 | 64266840.0 |
| 2005-02-11 15:00:00 | NVDA | Stock | 0.2191 | 0.2192 | 0.2169 | 0.2179 | 113584800.0 |
| 2005-02-11 16:00:00 | NVDA | Stock | 0.2179 | 0.2182 | 0.2175 | 0.2182 | 1878240.0 |
| 2005-02-11 17:00:00 | NVDA | Stock | 0.2182 | 0.2182 | 0.2182 | 0.2182 | 102000.0 |
| 2005-02-11 18:00:00 | NVDA | Stock | 0.2179 | 0.2179 | 0.2179 | 0.2179 | 180000.0 |
| 2005-02-11 08:00:00 | AMZN | Stock | 1.787 | 1.787 | 1.787 | 1.787 | 2000.0 |
| 2005-02-11 09:00:00 | AMZN | Stock | 1.7865 | 1.7875 | 1.7525 | 1.7535 | 15874400.0 |
| 2005-02-11 10:00:00 | AMZN | Stock | 1.752 | 1.782 | 1.75 | 1.773 | 41087900.0 |
| 2005-02-11 11:00:00 | AMZN | Stock | 1.773 | 1.7895 | 1.77 | 1.779 | 30447320.0 |
| 2005-02-11 12:00:00 | AMZN | Stock | 1.7785 | 1.7975 | 1.775 | 1.7925 | 16092700.0 |
| 2005-02-11 13:00:00 | AMZN | Stock | 1.792 | 1.793 | 1.781 | 1.7855 | 13039940.0 |
| 2005-02-11 14:00:00 | AMZN | Stock | 1.785 | 1.785 | 1.779 | 1.781 | 11802260.0 |
| 2005-02-11 15:00:00 | AMZN | Stock | 1.7805 | 1.792 | 1.78 | 1.7895 | 22407600.0 |
| 2005-02-11 16:00:00 | AMZN | Stock | 1.789 | 1.79 | 1.7805 | 1.7805 | 582800.0 |
| 2005-02-11 18:00:00 | AMZN | Stock | 1.781 | 1.781 | 1.781 | 1.781 | 20000.0 |
| 2005-02-11 09:00:00 | CL | Stock | 27.05 | 27.145 | 27.05 | 27.115 | 403200.0 |
| 2005-02-11 10:00:00 | CL | Stock | 27.11 | 27.2 | 27.085 | 27.17 | 715800.0 |
| 2005-02-11 11:00:00 | CL | Stock | 27.17 | 27.365 | 27.165 | 27.245 | 1222200.0 |
| 2005-02-11 12:00:00 | CL | Stock | 27.25 | 27.365 | 27.225 | 27.34 | 585400.0 |
| 2005-02-11 13:00:00 | CL | Stock | 27.34 | 27.35 | 27.24 | 27.26 | 280000.0 |
| 2005-02-11 14:00:00 | CL | Stock | 27.255 | 27.37 | 27.22 | 27.355 | 417800.0 |
| 2005-02-11 15:00:00 | CL | Stock | 27.345 | 27.405 | 27.33 | 27.355 | 705400.0 |
> showing 50 of 25,281 rows — these rows as CSV