PREVIEW / stock_1hour / 2002-02-08
file: by_date/stock_1hour/2002/2002-02-08.parquet size: 384 KB rows: 18,526 symbols: 1,400
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-02-08 08:00:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4357 | 0.4366 | 364000.0 |
| 2002-02-08 09:00:00 | AAPL | Stock | 0.4373 | 0.44 | 0.4268 | 0.4273 | 56677600.0 |
| 2002-02-08 10:00:00 | AAPL | Stock | 0.4271 | 0.4341 | 0.4266 | 0.433 | 43954400.0 |
| 2002-02-08 11:00:00 | AAPL | Stock | 0.433 | 0.4357 | 0.4309 | 0.4334 | 19840800.0 |
| 2002-02-08 12:00:00 | AAPL | Stock | 0.4331 | 0.4341 | 0.4278 | 0.428 | 28145600.0 |
| 2002-02-08 13:00:00 | AAPL | Stock | 0.4279 | 0.4293 | 0.4223 | 0.4234 | 42436800.0 |
| 2002-02-08 14:00:00 | AAPL | Stock | 0.4236 | 0.4246 | 0.4173 | 0.4238 | 50635200.0 |
| 2002-02-08 15:00:00 | AAPL | Stock | 0.4241 | 0.4298 | 0.4223 | 0.4289 | 69820800.0 |
| 2002-02-08 16:00:00 | AAPL | Stock | 0.4289 | 0.4298 | 0.4277 | 0.4282 | 15276800.0 |
| 2002-02-08 17:00:00 | AAPL | Stock | 0.4291 | 0.4304 | 0.4286 | 0.4304 | 123200.0 |
| 2002-02-08 08:00:00 | MSFT | Stock | 30.075 | 30.13 | 29.9025 | 30.0 | 333400.0 |
| 2002-02-08 09:00:00 | MSFT | Stock | 30.025 | 30.135 | 29.75 | 30.02 | 8420000.0 |
| 2002-02-08 10:00:00 | MSFT | Stock | 30.025 | 30.1 | 29.725 | 29.98 | 12249800.0 |
| 2002-02-08 11:00:00 | MSFT | Stock | 29.985 | 30.055 | 29.72 | 29.7595 | 6948400.0 |
| 2002-02-08 12:00:00 | MSFT | Stock | 29.75 | 29.805 | 29.53 | 29.535 | 5421200.0 |
| 2002-02-08 13:00:00 | MSFT | Stock | 29.54 | 29.63 | 29.415 | 29.575 | 5746800.0 |
| 2002-02-08 14:00:00 | MSFT | Stock | 29.5749 | 29.87 | 29.505 | 29.76 | 6793800.0 |
| 2002-02-08 15:00:00 | MSFT | Stock | 29.7605 | 30.325 | 29.725 | 30.315 | 11629000.0 |
| 2002-02-08 16:00:00 | MSFT | Stock | 30.325 | 30.4 | 29.485 | 30.275 | 1935200.0 |
| 2002-02-08 17:00:00 | MSFT | Stock | 30.325 | 30.335 | 30.25 | 30.325 | 329000.0 |
| 2002-02-08 18:00:00 | MSFT | Stock | 30.3 | 30.32 | 30.3 | 30.32 | 2200.0 |
| 2002-02-08 08:00:00 | NVDA | Stock | 0.5056 | 0.5125 | 0.5012 | 0.5012 | 1200000.0 |
| 2002-02-08 09:00:00 | NVDA | Stock | 0.5021 | 0.5062 | 0.4852 | 0.4877 | 192540000.0 |
| 2002-02-08 10:00:00 | NVDA | Stock | 0.4877 | 0.4916 | 0.473 | 0.4806 | 369156000.0 |
| 2002-02-08 11:00:00 | NVDA | Stock | 0.4794 | 0.4869 | 0.4722 | 0.4749 | 267024000.0 |
| 2002-02-08 12:00:00 | NVDA | Stock | 0.4751 | 0.4774 | 0.4625 | 0.4657 | 242628000.0 |
| 2002-02-08 13:00:00 | NVDA | Stock | 0.4656 | 0.4719 | 0.4637 | 0.4672 | 176688000.0 |
| 2002-02-08 14:00:00 | NVDA | Stock | 0.4671 | 0.4724 | 0.462 | 0.4717 | 213672000.0 |
| 2002-02-08 15:00:00 | NVDA | Stock | 0.4717 | 0.4885 | 0.4697 | 0.481 | 352056000.0 |
| 2002-02-08 16:00:00 | NVDA | Stock | 0.4805 | 0.4869 | 0.4733 | 0.4837 | 22344000.0 |
| 2002-02-08 17:00:00 | NVDA | Stock | 0.4837 | 0.4845 | 0.4808 | 0.4808 | 564000.0 |
| 2002-02-08 18:00:00 | NVDA | Stock | 0.4809 | 0.4809 | 0.4808 | 0.4808 | 24000.0 |
| 2002-02-08 08:00:00 | AMZN | Stock | 0.565 | 0.5725 | 0.565 | 0.5725 | 18000.0 |
| 2002-02-08 09:00:00 | AMZN | Stock | 0.575 | 0.59 | 0.572 | 0.5825 | 11290000.0 |
| 2002-02-08 10:00:00 | AMZN | Stock | 0.5825 | 0.596 | 0.5795 | 0.591 | 17294000.0 |
| 2002-02-08 11:00:00 | AMZN | Stock | 0.592 | 0.5965 | 0.586 | 0.592 | 14650000.0 |
| 2002-02-08 12:00:00 | AMZN | Stock | 0.5924 | 0.595 | 0.5805 | 0.5885 | 9282000.0 |
| 2002-02-08 13:00:00 | AMZN | Stock | 0.5885 | 0.59 | 0.5825 | 0.587 | 5050000.0 |
| 2002-02-08 14:00:00 | AMZN | Stock | 0.5865 | 0.5905 | 0.5855 | 0.59 | 11642000.0 |
| 2002-02-08 15:00:00 | AMZN | Stock | 0.5905 | 0.6335 | 0.5895 | 0.626 | 44204000.0 |
| 2002-02-08 16:00:00 | AMZN | Stock | 0.6265 | 0.6323 | 0.592 | 0.625 | 4300000.0 |
| 2002-02-08 17:00:00 | AMZN | Stock | 0.626 | 0.6305 | 0.626 | 0.63 | 64000.0 |
| 2002-02-08 18:00:00 | AMZN | Stock | 0.6325 | 0.635 | 0.6325 | 0.635 | 16000.0 |
| 2002-02-08 09:00:00 | CL | Stock | 27.1 | 27.125 | 26.905 | 26.99 | 386800.0 |
| 2002-02-08 10:00:00 | CL | Stock | 26.99 | 27.125 | 26.875 | 26.875 | 754600.0 |
| 2002-02-08 11:00:00 | CL | Stock | 26.85 | 27.05 | 26.85 | 26.95 | 518600.0 |
| 2002-02-08 12:00:00 | CL | Stock | 26.945 | 27.0 | 26.875 | 26.95 | 457200.0 |
| 2002-02-08 13:00:00 | CL | Stock | 26.95 | 27.025 | 26.85 | 26.96 | 410200.0 |
| 2002-02-08 14:00:00 | CL | Stock | 26.96 | 27.0 | 26.895 | 26.925 | 865600.0 |
| 2002-02-08 15:00:00 | CL | Stock | 26.925 | 27.215 | 26.915 | 27.215 | 1093400.0 |
> showing 50 of 18,526 rows — these rows as CSV