PREVIEW / stock_1hour / 2002-03-07
file: by_date/stock_1hour/2002/2002-03-07.parquet size: 392 KB rows: 18,291 symbols: 1,396
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-07 08:00:00 | AAPL | Stock | 0.4299 | 0.4304 | 0.4299 | 0.4304 | 3421600.0 |
| 2002-03-07 09:00:00 | AAPL | Stock | 0.4309 | 0.4321 | 0.4223 | 0.4232 | 26952800.0 |
| 2002-03-07 10:00:00 | AAPL | Stock | 0.4229 | 0.4279 | 0.4216 | 0.4264 | 45533600.0 |
| 2002-03-07 11:00:00 | AAPL | Stock | 0.427 | 0.4321 | 0.4245 | 0.4255 | 21470400.0 |
| 2002-03-07 12:00:00 | AAPL | Stock | 0.4252 | 0.4282 | 0.4227 | 0.4264 | 11933600.0 |
| 2002-03-07 13:00:00 | AAPL | Stock | 0.4264 | 0.4266 | 0.4225 | 0.4241 | 22288000.0 |
| 2002-03-07 14:00:00 | AAPL | Stock | 0.4241 | 0.4338 | 0.4232 | 0.4305 | 45337600.0 |
| 2002-03-07 15:00:00 | AAPL | Stock | 0.4304 | 0.438 | 0.4289 | 0.4354 | 63436800.0 |
| 2002-03-07 16:00:00 | AAPL | Stock | 0.4352 | 0.4379 | 0.4265 | 0.4375 | 4832800.0 |
| 2002-03-07 17:00:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4375 | 0.4375 | 5600.0 |
| 2002-03-07 08:00:00 | MSFT | Stock | 31.6 | 32.0 | 31.5 | 31.92 | 70200.0 |
| 2002-03-07 09:00:00 | MSFT | Stock | 31.92 | 31.945 | 31.5 | 31.52 | 7973200.0 |
| 2002-03-07 10:00:00 | MSFT | Stock | 31.5105 | 31.9445 | 31.37 | 31.51 | 11625000.0 |
| 2002-03-07 11:00:00 | MSFT | Stock | 31.5095 | 31.655 | 31.375 | 31.5 | 6108400.0 |
| 2002-03-07 12:00:00 | MSFT | Stock | 31.51 | 31.645 | 31.305 | 31.52 | 5358000.0 |
| 2002-03-07 13:00:00 | MSFT | Stock | 31.5105 | 31.56 | 31.015 | 31.03 | 6378800.0 |
| 2002-03-07 14:00:00 | MSFT | Stock | 31.03 | 31.275 | 30.93 | 31.13 | 7005200.0 |
| 2002-03-07 15:00:00 | MSFT | Stock | 31.13 | 31.37 | 30.97 | 31.36 | 9546000.0 |
| 2002-03-07 16:00:00 | MSFT | Stock | 31.355 | 31.6172 | 31.0818 | 31.375 | 1834400.0 |
| 2002-03-07 17:00:00 | MSFT | Stock | 31.375 | 31.375 | 31.28 | 31.28 | 19000.0 |
| 2002-03-07 18:00:00 | MSFT | Stock | 31.28 | 31.305 | 31.28 | 31.305 | 3200.0 |
| 2002-03-07 08:00:00 | NVDA | Stock | 0.4783 | 0.4812 | 0.4742 | 0.4742 | 9372000.0 |
| 2002-03-07 09:00:00 | NVDA | Stock | 0.4751 | 0.4838 | 0.4673 | 0.4712 | 247536000.0 |
| 2002-03-07 10:00:00 | NVDA | Stock | 0.4711 | 0.475 | 0.4585 | 0.4651 | 344172000.0 |
| 2002-03-07 11:00:00 | NVDA | Stock | 0.4648 | 0.4692 | 0.4616 | 0.4642 | 138228000.0 |
| 2002-03-07 12:00:00 | NVDA | Stock | 0.4642 | 0.4684 | 0.4621 | 0.4673 | 106164000.0 |
| 2002-03-07 13:00:00 | NVDA | Stock | 0.4673 | 0.4707 | 0.4654 | 0.4676 | 118380000.0 |
| 2002-03-07 14:00:00 | NVDA | Stock | 0.4683 | 0.4683 | 0.4601 | 0.465 | 129072000.0 |
| 2002-03-07 15:00:00 | NVDA | Stock | 0.4648 | 0.4749 | 0.4633 | 0.4722 | 179340000.0 |
| 2002-03-07 16:00:00 | NVDA | Stock | 0.4719 | 0.4748 | 0.4696 | 0.4742 | 12816000.0 |
| 2002-03-07 17:00:00 | NVDA | Stock | 0.4742 | 0.4748 | 0.4708 | 0.4708 | 612000.0 |
| 2002-03-07 18:00:00 | NVDA | Stock | 0.4708 | 0.4717 | 0.4708 | 0.4717 | 48000.0 |
| 2002-03-07 08:00:00 | AMZN | Stock | 0.8125 | 0.825 | 0.8125 | 0.825 | 294000.0 |
| 2002-03-07 09:00:00 | AMZN | Stock | 0.823 | 0.8475 | 0.817 | 0.817 | 31688000.0 |
| 2002-03-07 10:00:00 | AMZN | Stock | 0.8166 | 0.835 | 0.8005 | 0.808 | 35004000.0 |
| 2002-03-07 11:00:00 | AMZN | Stock | 0.8065 | 0.82 | 0.8065 | 0.8115 | 12332000.0 |
| 2002-03-07 12:00:00 | AMZN | Stock | 0.812 | 0.8145 | 0.8035 | 0.8035 | 10564000.0 |
| 2002-03-07 13:00:00 | AMZN | Stock | 0.804 | 0.804 | 0.7835 | 0.786 | 19432000.0 |
| 2002-03-07 14:00:00 | AMZN | Stock | 0.787 | 0.794 | 0.7755 | 0.779 | 23222000.0 |
| 2002-03-07 15:00:00 | AMZN | Stock | 0.779 | 0.79 | 0.77 | 0.7825 | 35544000.0 |
| 2002-03-07 16:00:00 | AMZN | Stock | 0.781 | 0.787 | 0.773 | 0.781 | 5436000.0 |
| 2002-03-07 17:00:00 | AMZN | Stock | 0.785 | 0.785 | 0.7725 | 0.775 | 372000.0 |
| 2002-03-07 18:00:00 | AMZN | Stock | 0.7825 | 0.7825 | 0.78 | 0.78 | 26000.0 |
| 2002-03-07 09:00:00 | CL | Stock | 27.875 | 27.875 | 27.38 | 27.38 | 519600.0 |
| 2002-03-07 10:00:00 | CL | Stock | 27.38 | 27.475 | 27.2 | 27.41 | 959600.0 |
| 2002-03-07 11:00:00 | CL | Stock | 27.375 | 27.445 | 27.25 | 27.3 | 442400.0 |
| 2002-03-07 12:00:00 | CL | Stock | 27.315 | 27.395 | 27.225 | 27.295 | 283000.0 |
| 2002-03-07 13:00:00 | CL | Stock | 27.295 | 27.325 | 27.25 | 27.28 | 234000.0 |
| 2002-03-07 14:00:00 | CL | Stock | 27.28 | 27.305 | 27.125 | 27.245 | 729000.0 |
| 2002-03-07 15:00:00 | CL | Stock | 27.245 | 27.325 | 27.15 | 27.265 | 841000.0 |
> showing 50 of 18,291 rows — these rows as CSV