PREVIEW / stock_1hour / 2003-12-03
file: by_date/stock_1hour/2003/2003-12-03.parquet size: 508 KB rows: 23,252 symbols: 1,681
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-03 09:00:00 | AAPL | Stock | 0.3845 | 0.39 | 0.3841 | 0.388 | 19607448.0 |
| 2003-12-03 10:00:00 | AAPL | Stock | 0.3877 | 0.388 | 0.382 | 0.3856 | 28511000.0 |
| 2003-12-03 11:00:00 | AAPL | Stock | 0.3856 | 0.3889 | 0.3841 | 0.3863 | 19171880.0 |
| 2003-12-03 12:00:00 | AAPL | Stock | 0.3861 | 0.3879 | 0.3849 | 0.3861 | 12951848.0 |
| 2003-12-03 13:00:00 | AAPL | Stock | 0.3859 | 0.3863 | 0.3834 | 0.3834 | 15468600.0 |
| 2003-12-03 14:00:00 | AAPL | Stock | 0.3834 | 0.3848 | 0.3805 | 0.3814 | 19115600.0 |
| 2003-12-03 15:00:00 | AAPL | Stock | 0.3814 | 0.3832 | 0.3746 | 0.3759 | 59153864.0 |
| 2003-12-03 16:00:00 | AAPL | Stock | 0.3754 | 0.3775 | 0.3743 | 0.3759 | 3726856.0 |
| 2003-12-03 17:00:00 | AAPL | Stock | 0.3755 | 0.3755 | 0.3755 | 0.3755 | 890400.0 |
| 2003-12-03 08:00:00 | MSFT | Stock | 25.82 | 25.92 | 25.64 | 25.82 | 178912.0 |
| 2003-12-03 09:00:00 | MSFT | Stock | 25.82 | 25.9 | 25.68 | 25.85 | 7123133.0 |
| 2003-12-03 10:00:00 | MSFT | Stock | 25.85 | 25.93 | 25.74 | 25.92 | 15660152.0 |
| 2003-12-03 11:00:00 | MSFT | Stock | 25.92 | 26.07 | 25.91 | 26.01 | 15602953.0 |
| 2003-12-03 12:00:00 | MSFT | Stock | 26.02 | 26.05 | 25.97 | 25.98 | 9182669.0 |
| 2003-12-03 13:00:00 | MSFT | Stock | 25.98 | 26.0 | 25.85 | 25.94 | 7247416.0 |
| 2003-12-03 14:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.77 | 25.82 | 11471859.0 |
| 2003-12-03 15:00:00 | MSFT | Stock | 25.82 | 25.87 | 25.63 | 25.66 | 21457870.0 |
| 2003-12-03 16:00:00 | MSFT | Stock | 25.63 | 25.8558 | 25.61 | 25.68 | 2114723.0 |
| 2003-12-03 17:00:00 | MSFT | Stock | 25.69 | 25.9176 | 25.62 | 25.71 | 739393.0 |
| 2003-12-03 18:00:00 | MSFT | Stock | 25.71 | 25.71 | 25.69 | 25.69 | 2800.0 |
| 2003-12-03 08:00:00 | NVDA | Stock | 0.18 | 0.18 | 0.1797 | 0.18 | 432000.0 |
| 2003-12-03 09:00:00 | NVDA | Stock | 0.18 | 0.1824 | 0.1792 | 0.1817 | 67054560.0 |
| 2003-12-03 10:00:00 | NVDA | Stock | 0.1817 | 0.1821 | 0.1804 | 0.1818 | 79587960.0 |
| 2003-12-03 11:00:00 | NVDA | Stock | 0.1819 | 0.1833 | 0.1812 | 0.1833 | 77283000.0 |
| 2003-12-03 12:00:00 | NVDA | Stock | 0.1832 | 0.185 | 0.1827 | 0.1845 | 122451960.0 |
| 2003-12-03 13:00:00 | NVDA | Stock | 0.1845 | 0.1849 | 0.1837 | 0.1845 | 68350680.0 |
| 2003-12-03 14:00:00 | NVDA | Stock | 0.1845 | 0.1847 | 0.1807 | 0.1813 | 86040120.0 |
| 2003-12-03 15:00:00 | NVDA | Stock | 0.1811 | 0.1817 | 0.1768 | 0.1769 | 181935120.0 |
| 2003-12-03 16:00:00 | NVDA | Stock | 0.1768 | 0.1842 | 0.1763 | 0.177 | 11187960.0 |
| 2003-12-03 17:00:00 | NVDA | Stock | 0.1771 | 0.1814 | 0.1768 | 0.1768 | 3458400.0 |
| 2003-12-03 08:00:00 | AMZN | Stock | 2.7 | 2.7075 | 2.7 | 2.7075 | 74000.0 |
| 2003-12-03 09:00:00 | AMZN | Stock | 2.7085 | 2.7135 | 2.67 | 2.6845 | 30415060.0 |
| 2003-12-03 10:00:00 | AMZN | Stock | 2.6844 | 2.6875 | 2.643 | 2.652 | 50371720.0 |
| 2003-12-03 11:00:00 | AMZN | Stock | 2.6516 | 2.665 | 2.629 | 2.658 | 35058360.0 |
| 2003-12-03 12:00:00 | AMZN | Stock | 2.658 | 2.6625 | 2.649 | 2.652 | 12077240.0 |
| 2003-12-03 13:00:00 | AMZN | Stock | 2.652 | 2.6565 | 2.6365 | 2.6465 | 13060920.0 |
| 2003-12-03 14:00:00 | AMZN | Stock | 2.646 | 2.6574 | 2.63 | 2.639 | 17286400.0 |
| 2003-12-03 15:00:00 | AMZN | Stock | 2.636 | 2.6395 | 2.568 | 2.5685 | 57980080.0 |
| 2003-12-03 16:00:00 | AMZN | Stock | 2.5685 | 2.58 | 2.567 | 2.575 | 7165260.0 |
| 2003-12-03 17:00:00 | AMZN | Stock | 2.576 | 2.6366 | 2.57 | 2.5715 | 718040.0 |
| 2003-12-03 18:00:00 | AMZN | Stock | 2.5715 | 2.5725 | 2.5715 | 2.5725 | 24000.0 |
| 2003-12-03 09:00:00 | CL | Stock | 26.515 | 26.55 | 26.45 | 26.465 | 340400.0 |
| 2003-12-03 10:00:00 | CL | Stock | 26.465 | 26.465 | 26.335 | 26.43 | 1473800.0 |
| 2003-12-03 11:00:00 | CL | Stock | 26.44 | 26.56 | 26.42 | 26.535 | 1197800.0 |
| 2003-12-03 12:00:00 | CL | Stock | 26.53 | 26.615 | 26.52 | 26.595 | 526000.0 |
| 2003-12-03 13:00:00 | CL | Stock | 26.59 | 26.61 | 26.535 | 26.585 | 446400.0 |
| 2003-12-03 14:00:00 | CL | Stock | 26.59 | 26.665 | 26.58 | 26.65 | 585800.0 |
| 2003-12-03 15:00:00 | CL | Stock | 26.65 | 26.695 | 26.495 | 26.51 | 1338000.0 |
| 2003-12-03 16:00:00 | CL | Stock | 26.5 | 26.5 | 26.495 | 26.5 | 155400.0 |
| 2003-12-03 17:00:00 | CL | Stock | 26.5 | 26.5382 | 26.5 | 26.5382 | 208800.0 |
> showing 50 of 23,252 rows — these rows as CSV