PREVIEW / stock_1hour / 2004-06-10
file: by_date/stock_1hour/2004/2004-06-10.parquet size: 493 KB rows: 23,665 symbols: 1,780
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-10 08:00:00 | AAPL | Stock | 0.5404 | 0.542 | 0.5404 | 0.5413 | 333200.0 |
| 2004-06-10 09:00:00 | AAPL | Stock | 0.5413 | 0.5479 | 0.5396 | 0.5479 | 33340888.0 |
| 2004-06-10 10:00:00 | AAPL | Stock | 0.548 | 0.553 | 0.5471 | 0.5479 | 82752208.0 |
| 2004-06-10 11:00:00 | AAPL | Stock | 0.5479 | 0.5482 | 0.5421 | 0.545 | 44967720.0 |
| 2004-06-10 12:00:00 | AAPL | Stock | 0.545 | 0.548 | 0.5443 | 0.5471 | 14879760.0 |
| 2004-06-10 13:00:00 | AAPL | Stock | 0.547 | 0.548 | 0.5457 | 0.5475 | 15896776.0 |
| 2004-06-10 14:00:00 | AAPL | Stock | 0.5475 | 0.5502 | 0.5468 | 0.5496 | 16488304.0 |
| 2004-06-10 15:00:00 | AAPL | Stock | 0.5496 | 0.5509 | 0.5477 | 0.5482 | 40106360.0 |
| 2004-06-10 16:00:00 | AAPL | Stock | 0.5482 | 0.5493 | 0.5479 | 0.5489 | 4224640.0 |
| 2004-06-10 17:00:00 | AAPL | Stock | 0.5489 | 0.5496 | 0.5489 | 0.5495 | 463120.0 |
| 2004-06-10 08:00:00 | MSFT | Stock | 26.52 | 26.52 | 26.47 | 26.47 | 8800.0 |
| 2004-06-10 09:00:00 | MSFT | Stock | 26.46 | 26.52 | 26.38 | 26.46 | 4738026.0 |
| 2004-06-10 10:00:00 | MSFT | Stock | 26.46 | 26.601 | 26.45 | 26.54 | 6662944.0 |
| 2004-06-10 11:00:00 | MSFT | Stock | 26.55 | 26.67 | 26.49 | 26.63 | 5542518.0 |
| 2004-06-10 12:00:00 | MSFT | Stock | 26.629 | 26.64 | 26.54 | 26.56 | 3279985.0 |
| 2004-06-10 13:00:00 | MSFT | Stock | 26.56 | 26.63 | 26.51 | 26.59 | 4632022.0 |
| 2004-06-10 14:00:00 | MSFT | Stock | 26.59 | 26.651 | 26.569 | 26.6 | 5277042.0 |
| 2004-06-10 15:00:00 | MSFT | Stock | 26.601 | 26.79 | 26.53 | 26.77 | 14097008.0 |
| 2004-06-10 16:00:00 | MSFT | Stock | 26.77 | 26.82 | 26.75 | 26.76 | 1575101.0 |
| 2004-06-10 17:00:00 | MSFT | Stock | 26.76 | 26.77 | 26.76 | 26.77 | 3100.0 |
| 2004-06-10 18:00:00 | MSFT | Stock | 26.75 | 26.76 | 26.75 | 26.75 | 2400.0 |
| 2004-06-10 09:00:00 | NVDA | Stock | 0.1771 | 0.1782 | 0.1754 | 0.1764 | 91322640.0 |
| 2004-06-10 10:00:00 | NVDA | Stock | 0.1764 | 0.1771 | 0.1751 | 0.1752 | 86556480.0 |
| 2004-06-10 11:00:00 | NVDA | Stock | 0.1752 | 0.1752 | 0.1735 | 0.1735 | 55813440.0 |
| 2004-06-10 12:00:00 | NVDA | Stock | 0.1736 | 0.1737 | 0.1719 | 0.1724 | 68386320.0 |
| 2004-06-10 13:00:00 | NVDA | Stock | 0.1724 | 0.1729 | 0.1717 | 0.1728 | 68420280.0 |
| 2004-06-10 14:00:00 | NVDA | Stock | 0.1727 | 0.1731 | 0.1725 | 0.1727 | 34314600.0 |
| 2004-06-10 15:00:00 | NVDA | Stock | 0.1728 | 0.1737 | 0.1726 | 0.1733 | 120498600.0 |
| 2004-06-10 16:00:00 | NVDA | Stock | 0.1733 | 0.1733 | 0.1727 | 0.1728 | 8779440.0 |
| 2004-06-10 08:00:00 | AMZN | Stock | 2.5175 | 2.525 | 2.515 | 2.515 | 90000.0 |
| 2004-06-10 09:00:00 | AMZN | Stock | 2.515 | 2.5235 | 2.476 | 2.484 | 32837400.0 |
| 2004-06-10 10:00:00 | AMZN | Stock | 2.484 | 2.494 | 2.4635 | 2.4865 | 28326920.0 |
| 2004-06-10 11:00:00 | AMZN | Stock | 2.4865 | 2.4865 | 2.464 | 2.468 | 24088640.0 |
| 2004-06-10 12:00:00 | AMZN | Stock | 2.4685 | 2.4774 | 2.463 | 2.469 | 9349280.0 |
| 2004-06-10 13:00:00 | AMZN | Stock | 2.4685 | 2.484 | 2.465 | 2.475 | 11378420.0 |
| 2004-06-10 14:00:00 | AMZN | Stock | 2.4745 | 2.481 | 2.4705 | 2.4756 | 8263120.0 |
| 2004-06-10 15:00:00 | AMZN | Stock | 2.476 | 2.499 | 2.4685 | 2.499 | 23374560.0 |
| 2004-06-10 16:00:00 | AMZN | Stock | 2.499 | 2.5005 | 2.48 | 2.4925 | 1843840.0 |
| 2004-06-10 17:00:00 | AMZN | Stock | 2.4875 | 2.4875 | 2.4875 | 2.4875 | 8400.0 |
| 2004-06-10 09:00:00 | CL | Stock | 28.955 | 29.03 | 28.92 | 29.03 | 234200.0 |
| 2004-06-10 10:00:00 | CL | Stock | 29.03 | 29.095 | 29.0 | 29.085 | 275400.0 |
| 2004-06-10 11:00:00 | CL | Stock | 29.08 | 29.1 | 29.02 | 29.065 | 388400.0 |
| 2004-06-10 12:00:00 | CL | Stock | 29.065 | 29.065 | 29.0 | 29.05 | 194200.0 |
| 2004-06-10 13:00:00 | CL | Stock | 29.05 | 29.105 | 29.035 | 29.095 | 224600.0 |
| 2004-06-10 14:00:00 | CL | Stock | 29.1 | 29.12 | 29.05 | 29.08 | 200200.0 |
| 2004-06-10 15:00:00 | CL | Stock | 29.08 | 29.095 | 29.06 | 29.08 | 469000.0 |
| 2004-06-10 16:00:00 | CL | Stock | 29.075 | 29.075 | 29.075 | 29.075 | 10200.0 |
| 2004-06-10 17:00:00 | CL | Stock | 29.075 | 29.075 | 29.075 | 29.075 | 1800.0 |
> showing 48 of 23,665 rows — these rows as CSV