PREVIEW / stock_1hour / 2002-03-06
file: by_date/stock_1hour/2002/2002-03-06.parquet size: 394 KB rows: 18,367 symbols: 1,406
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-06 08:00:00 | AAPL | Stock | 0.4143 | 0.4177 | 0.4109 | 0.4109 | 739200.0 |
| 2002-03-06 09:00:00 | AAPL | Stock | 0.4152 | 0.4195 | 0.4038 | 0.4164 | 27473600.0 |
| 2002-03-06 10:00:00 | AAPL | Stock | 0.4164 | 0.4232 | 0.4095 | 0.4204 | 46172000.0 |
| 2002-03-06 11:00:00 | AAPL | Stock | 0.4204 | 0.4209 | 0.4171 | 0.4193 | 13636000.0 |
| 2002-03-06 12:00:00 | AAPL | Stock | 0.4195 | 0.4254 | 0.4193 | 0.4198 | 17399200.0 |
| 2002-03-06 13:00:00 | AAPL | Stock | 0.4202 | 0.4225 | 0.4182 | 0.4218 | 23592800.0 |
| 2002-03-06 14:00:00 | AAPL | Stock | 0.422 | 0.4329 | 0.4191 | 0.43 | 45556000.0 |
| 2002-03-06 15:00:00 | AAPL | Stock | 0.4298 | 0.4346 | 0.4279 | 0.4298 | 33891200.0 |
| 2002-03-06 16:00:00 | AAPL | Stock | 0.4298 | 0.4325 | 0.4289 | 0.4325 | 5258400.0 |
| 2002-03-06 17:00:00 | AAPL | Stock | 0.433 | 0.4348 | 0.433 | 0.4348 | 173600.0 |
| 2002-03-06 18:00:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 28000.0 |
| 2002-03-06 08:00:00 | MSFT | Stock | 31.475 | 31.55 | 31.4 | 31.545 | 109608.0 |
| 2002-03-06 09:00:00 | MSFT | Stock | 31.5 | 31.545 | 31.185 | 31.44 | 5730400.0 |
| 2002-03-06 10:00:00 | MSFT | Stock | 31.425 | 31.6235 | 31.095 | 31.475 | 10485800.0 |
| 2002-03-06 11:00:00 | MSFT | Stock | 31.465 | 31.55 | 31.2495 | 31.49 | 4385400.0 |
| 2002-03-06 12:00:00 | MSFT | Stock | 31.4905 | 31.675 | 31.49 | 31.5945 | 3669600.0 |
| 2002-03-06 13:00:00 | MSFT | Stock | 31.595 | 31.625 | 31.275 | 31.315 | 4304600.0 |
| 2002-03-06 14:00:00 | MSFT | Stock | 31.315 | 31.6555 | 31.185 | 31.62 | 7536400.0 |
| 2002-03-06 15:00:00 | MSFT | Stock | 31.62 | 31.85 | 31.575 | 31.81 | 9961600.0 |
| 2002-03-06 16:00:00 | MSFT | Stock | 31.815 | 31.82 | 31.309 | 31.735 | 1914200.0 |
| 2002-03-06 17:00:00 | MSFT | Stock | 31.7105 | 31.815 | 31.71 | 31.815 | 343600.0 |
| 2002-03-06 18:00:00 | MSFT | Stock | 31.75 | 31.75 | 31.75 | 31.75 | 200.0 |
| 2002-03-06 08:00:00 | NVDA | Stock | 0.4812 | 0.4913 | 0.475 | 0.4783 | 8700000.0 |
| 2002-03-06 09:00:00 | NVDA | Stock | 0.4783 | 0.4901 | 0.4668 | 0.4685 | 232260000.0 |
| 2002-03-06 10:00:00 | NVDA | Stock | 0.4681 | 0.4779 | 0.4652 | 0.4779 | 314592000.0 |
| 2002-03-06 11:00:00 | NVDA | Stock | 0.4779 | 0.479 | 0.4687 | 0.4711 | 125988000.0 |
| 2002-03-06 12:00:00 | NVDA | Stock | 0.4711 | 0.4762 | 0.4704 | 0.4712 | 141588000.0 |
| 2002-03-06 13:00:00 | NVDA | Stock | 0.4713 | 0.4729 | 0.4657 | 0.47 | 141276000.0 |
| 2002-03-06 14:00:00 | NVDA | Stock | 0.4701 | 0.4728 | 0.4679 | 0.4708 | 141348000.0 |
| 2002-03-06 15:00:00 | NVDA | Stock | 0.4703 | 0.4787 | 0.4702 | 0.4754 | 251028000.0 |
| 2002-03-06 16:00:00 | NVDA | Stock | 0.4754 | 0.4756 | 0.4737 | 0.4756 | 32508000.0 |
| 2002-03-06 17:00:00 | NVDA | Stock | 0.4746 | 0.4756 | 0.4746 | 0.475 | 516000.0 |
| 2002-03-06 18:00:00 | NVDA | Stock | 0.4755 | 0.4755 | 0.4746 | 0.475 | 96000.0 |
| 2002-03-06 08:00:00 | AMZN | Stock | 0.7575 | 0.7625 | 0.742 | 0.7476 | 5938000.0 |
| 2002-03-06 09:00:00 | AMZN | Stock | 0.7475 | 0.772 | 0.7385 | 0.7665 | 66790000.0 |
| 2002-03-06 10:00:00 | AMZN | Stock | 0.767 | 0.7715 | 0.7575 | 0.769 | 40240000.0 |
| 2002-03-06 11:00:00 | AMZN | Stock | 0.7695 | 0.7825 | 0.7685 | 0.7786 | 22334000.0 |
| 2002-03-06 12:00:00 | AMZN | Stock | 0.779 | 0.8 | 0.779 | 0.798 | 23846000.0 |
| 2002-03-06 13:00:00 | AMZN | Stock | 0.798 | 0.8125 | 0.794 | 0.799 | 25488000.0 |
| 2002-03-06 14:00:00 | AMZN | Stock | 0.7973 | 0.82 | 0.7965 | 0.804 | 32346000.0 |
| 2002-03-06 15:00:00 | AMZN | Stock | 0.804 | 0.8295 | 0.801 | 0.816 | 47100000.0 |
| 2002-03-06 16:00:00 | AMZN | Stock | 0.813 | 0.819 | 0.787 | 0.8155 | 5554000.0 |
| 2002-03-06 17:00:00 | AMZN | Stock | 0.8155 | 0.8215 | 0.8155 | 0.8215 | 186000.0 |
| 2002-03-06 18:00:00 | AMZN | Stock | 0.8165 | 0.8175 | 0.8165 | 0.8175 | 52000.0 |
| 2002-03-06 09:00:00 | CL | Stock | 27.775 | 27.865 | 27.575 | 27.805 | 239800.0 |
| 2002-03-06 10:00:00 | CL | Stock | 27.84 | 27.935 | 27.76 | 27.87 | 268200.0 |
| 2002-03-06 11:00:00 | CL | Stock | 27.85 | 27.955 | 27.825 | 27.9 | 244000.0 |
| 2002-03-06 12:00:00 | CL | Stock | 27.9 | 27.94 | 27.85 | 27.925 | 197800.0 |
| 2002-03-06 13:00:00 | CL | Stock | 27.93 | 28.0 | 27.88 | 27.985 | 304200.0 |
| 2002-03-06 14:00:00 | CL | Stock | 27.985 | 28.1 | 27.925 | 28.0 | 724600.0 |
> showing 50 of 18,367 rows — these rows as CSV