PREVIEW / stock_1hour / 2004-06-09
file: by_date/stock_1hour/2004/2004-06-09.parquet size: 489 KB rows: 23,582 symbols: 1,779
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-09 08:00:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5402 | 0.5402 | 11200.0 |
| 2004-06-09 09:00:00 | AAPL | Stock | 0.5407 | 0.5484 | 0.5357 | 0.5461 | 66088568.0 |
| 2004-06-09 10:00:00 | AAPL | Stock | 0.5459 | 0.5473 | 0.542 | 0.5441 | 58075640.0 |
| 2004-06-09 11:00:00 | AAPL | Stock | 0.5441 | 0.5454 | 0.5425 | 0.5446 | 28005712.0 |
| 2004-06-09 12:00:00 | AAPL | Stock | 0.5447 | 0.5464 | 0.5441 | 0.5463 | 24488408.0 |
| 2004-06-09 13:00:00 | AAPL | Stock | 0.5463 | 0.5482 | 0.5429 | 0.543 | 50070888.0 |
| 2004-06-09 14:00:00 | AAPL | Stock | 0.5427 | 0.5443 | 0.542 | 0.5432 | 39230240.0 |
| 2004-06-09 15:00:00 | AAPL | Stock | 0.5432 | 0.5443 | 0.5393 | 0.5402 | 59179288.0 |
| 2004-06-09 16:00:00 | AAPL | Stock | 0.5402 | 0.545 | 0.5384 | 0.5396 | 11397680.0 |
| 2004-06-09 08:00:00 | MSFT | Stock | 26.5 | 26.5 | 26.44 | 26.45 | 85640.0 |
| 2004-06-09 09:00:00 | MSFT | Stock | 26.47 | 26.65 | 26.4 | 26.48 | 7169759.0 |
| 2004-06-09 10:00:00 | MSFT | Stock | 26.47 | 26.53 | 26.43 | 26.48 | 5919680.0 |
| 2004-06-09 11:00:00 | MSFT | Stock | 26.49 | 26.54 | 26.42 | 26.52 | 7278856.0 |
| 2004-06-09 12:00:00 | MSFT | Stock | 26.529 | 26.63 | 26.51 | 26.6 | 6192001.0 |
| 2004-06-09 13:00:00 | MSFT | Stock | 26.59 | 26.63 | 26.41 | 26.42 | 7053318.0 |
| 2004-06-09 14:00:00 | MSFT | Stock | 26.41 | 26.54 | 26.4 | 26.51 | 6536545.0 |
| 2004-06-09 15:00:00 | MSFT | Stock | 26.5 | 26.58 | 26.42 | 26.43 | 8742315.0 |
| 2004-06-09 16:00:00 | MSFT | Stock | 26.44 | 26.5041 | 26.43 | 26.47 | 603038.0 |
| 2004-06-09 17:00:00 | MSFT | Stock | 26.4946 | 26.4946 | 26.46 | 26.46 | 5444.0 |
| 2004-06-09 18:00:00 | MSFT | Stock | 26.46 | 26.46 | 26.45 | 26.45 | 300.0 |
| 2004-06-09 08:00:00 | NVDA | Stock | 0.1882 | 0.1882 | 0.1813 | 0.1813 | 72000.0 |
| 2004-06-09 09:00:00 | NVDA | Stock | 0.1836 | 0.185 | 0.1826 | 0.1833 | 33164040.0 |
| 2004-06-09 10:00:00 | NVDA | Stock | 0.1832 | 0.1833 | 0.1784 | 0.1787 | 80216880.0 |
| 2004-06-09 11:00:00 | NVDA | Stock | 0.1786 | 0.1787 | 0.1771 | 0.1778 | 67298520.0 |
| 2004-06-09 12:00:00 | NVDA | Stock | 0.1777 | 0.1785 | 0.1768 | 0.1783 | 39127560.0 |
| 2004-06-09 13:00:00 | NVDA | Stock | 0.1782 | 0.1783 | 0.1754 | 0.1755 | 55901640.0 |
| 2004-06-09 14:00:00 | NVDA | Stock | 0.1755 | 0.1762 | 0.175 | 0.1757 | 71504280.0 |
| 2004-06-09 15:00:00 | NVDA | Stock | 0.1757 | 0.1762 | 0.1745 | 0.1752 | 138477600.0 |
| 2004-06-09 16:00:00 | NVDA | Stock | 0.1751 | 0.1757 | 0.175 | 0.1757 | 3312480.0 |
| 2004-06-09 18:00:00 | NVDA | Stock | 0.1758 | 0.1761 | 0.1758 | 0.1761 | 72000.0 |
| 2004-06-09 08:00:00 | AMZN | Stock | 2.5925 | 2.594 | 2.585 | 2.585 | 52000.0 |
| 2004-06-09 09:00:00 | AMZN | Stock | 2.5855 | 2.5915 | 2.5725 | 2.577 | 12809280.0 |
| 2004-06-09 10:00:00 | AMZN | Stock | 2.5765 | 2.5765 | 2.5575 | 2.5624 | 21920900.0 |
| 2004-06-09 11:00:00 | AMZN | Stock | 2.562 | 2.5675 | 2.5555 | 2.557 | 10541000.0 |
| 2004-06-09 12:00:00 | AMZN | Stock | 2.557 | 2.558 | 2.535 | 2.541 | 19658340.0 |
| 2004-06-09 13:00:00 | AMZN | Stock | 2.5415 | 2.5475 | 2.5165 | 2.519 | 19021600.0 |
| 2004-06-09 14:00:00 | AMZN | Stock | 2.518 | 2.534 | 2.516 | 2.5255 | 14183720.0 |
| 2004-06-09 15:00:00 | AMZN | Stock | 2.5265 | 2.529 | 2.5005 | 2.512 | 28486620.0 |
| 2004-06-09 16:00:00 | AMZN | Stock | 2.512 | 2.5425 | 2.5095 | 2.5135 | 2032780.0 |
| 2004-06-09 17:00:00 | AMZN | Stock | 2.5122 | 2.517 | 2.512 | 2.517 | 593120.0 |
| 2004-06-09 09:00:00 | CL | Stock | 28.89 | 29.12 | 28.88 | 29.035 | 357200.0 |
| 2004-06-09 10:00:00 | CL | Stock | 29.03 | 29.045 | 28.91 | 28.915 | 398400.0 |
| 2004-06-09 11:00:00 | CL | Stock | 28.915 | 29.01 | 28.9 | 28.9 | 295600.0 |
| 2004-06-09 12:00:00 | CL | Stock | 28.895 | 28.97 | 28.875 | 28.925 | 199400.0 |
| 2004-06-09 13:00:00 | CL | Stock | 28.93 | 29.055 | 28.92 | 28.99 | 333800.0 |
| 2004-06-09 14:00:00 | CL | Stock | 28.985 | 29.085 | 28.975 | 29.025 | 500200.0 |
| 2004-06-09 15:00:00 | CL | Stock | 29.02 | 29.11 | 29.005 | 29.045 | 726200.0 |
| 2004-06-09 16:00:00 | CL | Stock | 29.055 | 29.055 | 29.055 | 29.055 | 5000.0 |
> showing 48 of 23,582 rows — these rows as CSV