PREVIEW / stock_1hour / 2002-06-17
file: by_date/stock_1hour/2002/2002-06-17.parquet size: 406 KB rows: 18,921 symbols: 1,441
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-06-17 08:00:00 | AAPL | Stock | 0.358 | 0.3598 | 0.3579 | 0.3589 | 459200.0 |
| 2002-06-17 09:00:00 | AAPL | Stock | 0.3597 | 0.3621 | 0.3545 | 0.3577 | 25328800.0 |
| 2002-06-17 10:00:00 | AAPL | Stock | 0.3575 | 0.3684 | 0.3571 | 0.3662 | 72217600.0 |
| 2002-06-17 11:00:00 | AAPL | Stock | 0.3664 | 0.3675 | 0.3636 | 0.3643 | 38550400.0 |
| 2002-06-17 12:00:00 | AAPL | Stock | 0.3645 | 0.3663 | 0.3614 | 0.3654 | 34137600.0 |
| 2002-06-17 13:00:00 | AAPL | Stock | 0.3657 | 0.3661 | 0.3591 | 0.3604 | 35240800.0 |
| 2002-06-17 14:00:00 | AAPL | Stock | 0.3604 | 0.3661 | 0.3602 | 0.3657 | 43825600.0 |
| 2002-06-17 15:00:00 | AAPL | Stock | 0.3657 | 0.3668 | 0.3625 | 0.3666 | 45494400.0 |
| 2002-06-17 16:00:00 | AAPL | Stock | 0.3664 | 0.3696 | 0.3637 | 0.3668 | 10018400.0 |
| 2002-06-17 18:00:00 | AAPL | Stock | 0.3668 | 0.3668 | 0.3668 | 0.3668 | 627200.0 |
| 2002-06-17 08:00:00 | MSFT | Stock | 27.75 | 28.0 | 27.705 | 27.92 | 80000.0 |
| 2002-06-17 09:00:00 | MSFT | Stock | 27.92 | 28.0055 | 27.76 | 27.86 | 12881800.0 |
| 2002-06-17 10:00:00 | MSFT | Stock | 27.865 | 28.15 | 27.815 | 28.09 | 15164200.0 |
| 2002-06-17 11:00:00 | MSFT | Stock | 28.09 | 28.13 | 27.975 | 28.065 | 12408800.0 |
| 2002-06-17 12:00:00 | MSFT | Stock | 28.07 | 28.22 | 28.048 | 28.145 | 8911400.0 |
| 2002-06-17 13:00:00 | MSFT | Stock | 28.145 | 28.19 | 28.065 | 28.098 | 7290800.0 |
| 2002-06-17 14:00:00 | MSFT | Stock | 28.095 | 28.1435 | 27.94 | 28.02 | 11584600.0 |
| 2002-06-17 15:00:00 | MSFT | Stock | 28.01 | 28.05 | 27.685 | 27.84 | 15977800.0 |
| 2002-06-17 16:00:00 | MSFT | Stock | 27.84 | 28.0287 | 27.815 | 27.85 | 5556200.0 |
| 2002-06-17 17:00:00 | MSFT | Stock | 27.9951 | 27.9951 | 27.835 | 27.875 | 2140000.0 |
| 2002-06-17 18:00:00 | MSFT | Stock | 27.84 | 27.865 | 27.84 | 27.865 | 86400.0 |
| 2002-06-17 08:00:00 | NVDA | Stock | 0.2397 | 0.2625 | 0.2376 | 0.2408 | 1584000.0 |
| 2002-06-17 09:00:00 | NVDA | Stock | 0.241 | 0.2417 | 0.2328 | 0.235 | 161232000.0 |
| 2002-06-17 10:00:00 | NVDA | Stock | 0.235 | 0.2432 | 0.2346 | 0.2413 | 220440000.0 |
| 2002-06-17 11:00:00 | NVDA | Stock | 0.2412 | 0.2425 | 0.2392 | 0.2395 | 108576000.0 |
| 2002-06-17 12:00:00 | NVDA | Stock | 0.2394 | 0.2398 | 0.2346 | 0.2375 | 119208000.0 |
| 2002-06-17 13:00:00 | NVDA | Stock | 0.2375 | 0.2383 | 0.235 | 0.2368 | 43776000.0 |
| 2002-06-17 14:00:00 | NVDA | Stock | 0.2368 | 0.2407 | 0.2362 | 0.2396 | 114276000.0 |
| 2002-06-17 15:00:00 | NVDA | Stock | 0.2397 | 0.2401 | 0.2348 | 0.2368 | 138012000.0 |
| 2002-06-17 16:00:00 | NVDA | Stock | 0.2368 | 0.2397 | 0.2354 | 0.2362 | 118368000.0 |
| 2002-06-17 17:00:00 | NVDA | Stock | 0.2382 | 0.2382 | 0.2362 | 0.2371 | 684000.0 |
| 2002-06-17 18:00:00 | NVDA | Stock | 0.2375 | 0.2375 | 0.2369 | 0.2369 | 528000.0 |
| 2002-06-17 08:00:00 | AMZN | Stock | 0.8441 | 0.8441 | 0.844 | 0.844 | 16000.0 |
| 2002-06-17 09:00:00 | AMZN | Stock | 0.845 | 0.8575 | 0.843 | 0.8505 | 16510000.0 |
| 2002-06-17 10:00:00 | AMZN | Stock | 0.8515 | 0.878 | 0.85 | 0.875 | 32364000.0 |
| 2002-06-17 11:00:00 | AMZN | Stock | 0.8745 | 0.901 | 0.873 | 0.896 | 27816000.0 |
| 2002-06-17 12:00:00 | AMZN | Stock | 0.8955 | 0.9025 | 0.8885 | 0.897 | 20714000.0 |
| 2002-06-17 13:00:00 | AMZN | Stock | 0.8985 | 0.9055 | 0.893 | 0.9005 | 18004000.0 |
| 2002-06-17 14:00:00 | AMZN | Stock | 0.903 | 0.9114 | 0.9005 | 0.908 | 19012000.0 |
| 2002-06-17 15:00:00 | AMZN | Stock | 0.908 | 0.924 | 0.9043 | 0.9225 | 35042000.0 |
| 2002-06-17 16:00:00 | AMZN | Stock | 0.922 | 0.93 | 0.898 | 0.9205 | 5522000.0 |
| 2002-06-17 17:00:00 | AMZN | Stock | 0.9295 | 0.93 | 0.9225 | 0.93 | 54000.0 |
| 2002-06-17 18:00:00 | AMZN | Stock | 0.9205 | 0.9205 | 0.9205 | 0.9205 | 136000.0 |
| 2002-06-17 09:00:00 | CL | Stock | 26.5 | 26.505 | 26.43 | 26.5 | 243000.0 |
| 2002-06-17 10:00:00 | CL | Stock | 26.5 | 26.665 | 26.475 | 26.65 | 370400.0 |
| 2002-06-17 11:00:00 | CL | Stock | 26.655 | 26.775 | 26.6 | 26.705 | 482400.0 |
| 2002-06-17 12:00:00 | CL | Stock | 26.685 | 26.685 | 26.555 | 26.6 | 211200.0 |
| 2002-06-17 13:00:00 | CL | Stock | 26.61 | 26.62 | 26.53 | 26.595 | 221200.0 |
| 2002-06-17 14:00:00 | CL | Stock | 26.6 | 26.625 | 26.5 | 26.575 | 252600.0 |
| 2002-06-17 15:00:00 | CL | Stock | 26.575 | 26.875 | 26.57 | 26.86 | 574000.0 |
> showing 50 of 18,921 rows — these rows as CSV