PREVIEW / stock_1hour / 2003-12-09
file: by_date/stock_1hour/2003/2003-12-09.parquet size: 495 KB rows: 22,848 symbols: 1,690
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-09 08:00:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.375 | 0.375 | 16800.0 |
| 2003-12-09 09:00:00 | AAPL | Stock | 0.3768 | 0.3795 | 0.3743 | 0.3755 | 13267072.0 |
| 2003-12-09 10:00:00 | AAPL | Stock | 0.3757 | 0.3779 | 0.3738 | 0.3741 | 11614512.0 |
| 2003-12-09 11:00:00 | AAPL | Stock | 0.3739 | 0.375 | 0.3705 | 0.3738 | 19516056.0 |
| 2003-12-09 12:00:00 | AAPL | Stock | 0.3738 | 0.3738 | 0.3714 | 0.3725 | 7511896.0 |
| 2003-12-09 13:00:00 | AAPL | Stock | 0.3725 | 0.3725 | 0.3704 | 0.3721 | 9863448.0 |
| 2003-12-09 14:00:00 | AAPL | Stock | 0.3714 | 0.3738 | 0.3661 | 0.368 | 28970816.0 |
| 2003-12-09 15:00:00 | AAPL | Stock | 0.368 | 0.3713 | 0.3643 | 0.3659 | 36971536.0 |
| 2003-12-09 16:00:00 | AAPL | Stock | 0.3659 | 0.366 | 0.365 | 0.3659 | 1805776.0 |
| 2003-12-09 17:00:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3643 | 0.3643 | 5600.0 |
| 2003-12-09 08:00:00 | MSFT | Stock | 26.39 | 26.4 | 26.28 | 26.35 | 83068.0 |
| 2003-12-09 09:00:00 | MSFT | Stock | 26.35 | 26.47 | 26.0 | 26.38 | 10936748.0 |
| 2003-12-09 10:00:00 | MSFT | Stock | 26.37 | 26.45 | 26.329 | 26.43 | 14082463.0 |
| 2003-12-09 11:00:00 | MSFT | Stock | 26.43 | 26.58 | 26.36 | 26.55 | 14215058.0 |
| 2003-12-09 12:00:00 | MSFT | Stock | 26.55 | 26.56 | 26.47 | 26.54 | 6932266.0 |
| 2003-12-09 13:00:00 | MSFT | Stock | 26.54 | 26.61 | 26.51 | 26.51 | 6966134.0 |
| 2003-12-09 14:00:00 | MSFT | Stock | 26.52 | 26.61 | 26.25 | 26.44 | 23632250.0 |
| 2003-12-09 15:00:00 | MSFT | Stock | 26.44 | 26.56 | 26.33 | 26.39 | 22344005.0 |
| 2003-12-09 16:00:00 | MSFT | Stock | 26.38 | 26.45 | 26.26 | 26.39 | 941189.0 |
| 2003-12-09 17:00:00 | MSFT | Stock | 26.39 | 26.41 | 26.37 | 26.41 | 1040237.0 |
| 2003-12-09 18:00:00 | MSFT | Stock | 26.41 | 26.41 | 26.4 | 26.41 | 7850.0 |
| 2003-12-09 08:00:00 | NVDA | Stock | 0.1717 | 0.1717 | 0.1717 | 0.1717 | 1368000.0 |
| 2003-12-09 09:00:00 | NVDA | Stock | 0.1722 | 0.1728 | 0.17 | 0.1707 | 60018000.0 |
| 2003-12-09 10:00:00 | NVDA | Stock | 0.1707 | 0.1721 | 0.1702 | 0.1705 | 75572640.0 |
| 2003-12-09 11:00:00 | NVDA | Stock | 0.1704 | 0.1705 | 0.1687 | 0.1703 | 37188240.0 |
| 2003-12-09 12:00:00 | NVDA | Stock | 0.1702 | 0.1703 | 0.1685 | 0.1689 | 36375720.0 |
| 2003-12-09 13:00:00 | NVDA | Stock | 0.1689 | 0.169 | 0.1672 | 0.1673 | 52754040.0 |
| 2003-12-09 14:00:00 | NVDA | Stock | 0.1673 | 0.1683 | 0.1627 | 0.1637 | 165928440.0 |
| 2003-12-09 15:00:00 | NVDA | Stock | 0.1637 | 0.1652 | 0.1625 | 0.1628 | 147229680.0 |
| 2003-12-09 16:00:00 | NVDA | Stock | 0.1627 | 0.1634 | 0.1626 | 0.1626 | 13803360.0 |
| 2003-12-09 17:00:00 | NVDA | Stock | 0.163 | 0.1633 | 0.163 | 0.163 | 396000.0 |
| 2003-12-09 18:00:00 | NVDA | Stock | 0.163 | 0.1633 | 0.1625 | 0.1625 | 615720.0 |
| 2003-12-09 08:00:00 | AMZN | Stock | 2.554 | 2.5815 | 2.554 | 2.57 | 26000.0 |
| 2003-12-09 09:00:00 | AMZN | Stock | 2.5635 | 2.5825 | 2.557 | 2.5735 | 22294400.0 |
| 2003-12-09 10:00:00 | AMZN | Stock | 2.573 | 2.581 | 2.5445 | 2.546 | 27009820.0 |
| 2003-12-09 11:00:00 | AMZN | Stock | 2.546 | 2.5575 | 2.5325 | 2.5485 | 22497600.0 |
| 2003-12-09 12:00:00 | AMZN | Stock | 2.5484 | 2.5555 | 2.539 | 2.5495 | 10272640.0 |
| 2003-12-09 13:00:00 | AMZN | Stock | 2.549 | 2.55 | 2.534 | 2.546 | 10390660.0 |
| 2003-12-09 14:00:00 | AMZN | Stock | 2.546 | 2.557 | 2.496 | 2.498 | 46487060.0 |
| 2003-12-09 15:00:00 | AMZN | Stock | 2.4985 | 2.5 | 2.465 | 2.4655 | 65055660.0 |
| 2003-12-09 16:00:00 | AMZN | Stock | 2.471 | 2.474 | 2.465 | 2.465 | 1235260.0 |
| 2003-12-09 17:00:00 | AMZN | Stock | 2.468 | 2.475 | 2.4565 | 2.4565 | 416600.0 |
| 2003-12-09 18:00:00 | AMZN | Stock | 2.4615 | 2.4615 | 2.4565 | 2.4565 | 24000.0 |
| 2003-12-09 09:00:00 | CL | Stock | 26.8 | 26.89 | 26.67 | 26.675 | 417800.0 |
| 2003-12-09 10:00:00 | CL | Stock | 26.67 | 26.68 | 26.575 | 26.675 | 1101400.0 |
| 2003-12-09 11:00:00 | CL | Stock | 26.67 | 26.71 | 26.64 | 26.68 | 677600.0 |
| 2003-12-09 12:00:00 | CL | Stock | 26.675 | 26.76 | 26.65 | 26.715 | 304600.0 |
| 2003-12-09 13:00:00 | CL | Stock | 26.715 | 26.775 | 26.695 | 26.76 | 522200.0 |
| 2003-12-09 14:00:00 | CL | Stock | 26.76 | 26.815 | 26.72 | 26.73 | 832400.0 |
| 2003-12-09 15:00:00 | CL | Stock | 26.73 | 26.735 | 26.435 | 26.5 | 2742800.0 |
> showing 50 of 22,848 rows — these rows as CSV