PREVIEW / stock_1hour / 2003-12-15
file: by_date/stock_1hour/2003/2003-12-15.parquet size: 520 KB rows: 24,393 symbols: 1,696
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-15 08:00:00 | AAPL | Stock | 0.3821 | 0.3834 | 0.3793 | 0.3834 | 238560.0 |
| 2003-12-15 09:00:00 | AAPL | Stock | 0.3821 | 0.3839 | 0.3804 | 0.3812 | 50649872.0 |
| 2003-12-15 10:00:00 | AAPL | Stock | 0.3813 | 0.3818 | 0.3782 | 0.3784 | 37748312.0 |
| 2003-12-15 11:00:00 | AAPL | Stock | 0.3786 | 0.3813 | 0.3759 | 0.3805 | 28462504.0 |
| 2003-12-15 12:00:00 | AAPL | Stock | 0.3804 | 0.3807 | 0.3768 | 0.3773 | 20631464.0 |
| 2003-12-15 13:00:00 | AAPL | Stock | 0.3773 | 0.3784 | 0.3729 | 0.3732 | 28284424.0 |
| 2003-12-15 14:00:00 | AAPL | Stock | 0.3732 | 0.3754 | 0.3677 | 0.3677 | 46355120.0 |
| 2003-12-15 15:00:00 | AAPL | Stock | 0.3677 | 0.3688 | 0.3591 | 0.3605 | 115988320.0 |
| 2003-12-15 16:00:00 | AAPL | Stock | 0.3605 | 0.3763 | 0.358 | 0.3605 | 35022064.0 |
| 2003-12-15 17:00:00 | AAPL | Stock | 0.3604 | 0.3604 | 0.3604 | 0.3604 | 190456.0 |
| 2003-12-15 18:00:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3573 | 0.3579 | 106400.0 |
| 2003-12-15 08:00:00 | MSFT | Stock | 27.12 | 27.27 | 26.95 | 27.1 | 648169.0 |
| 2003-12-15 09:00:00 | MSFT | Stock | 27.11 | 27.13 | 26.89 | 26.92 | 13338563.0 |
| 2003-12-15 10:00:00 | MSFT | Stock | 26.92 | 27.02 | 26.85 | 26.87 | 13773492.0 |
| 2003-12-15 11:00:00 | MSFT | Stock | 26.87 | 26.99 | 26.81 | 26.97 | 8687402.0 |
| 2003-12-15 12:00:00 | MSFT | Stock | 26.97 | 26.99 | 26.84 | 26.9 | 4771879.0 |
| 2003-12-15 13:00:00 | MSFT | Stock | 26.9 | 26.93 | 26.8 | 26.87 | 6621574.0 |
| 2003-12-15 14:00:00 | MSFT | Stock | 26.88 | 26.98 | 26.87 | 26.94 | 12733561.0 |
| 2003-12-15 15:00:00 | MSFT | Stock | 26.94 | 26.97 | 26.68 | 26.76 | 19665681.0 |
| 2003-12-15 16:00:00 | MSFT | Stock | 26.76 | 26.88 | 26.71 | 26.8 | 3103554.0 |
| 2003-12-15 17:00:00 | MSFT | Stock | 26.8 | 26.84 | 26.76 | 26.8 | 156652.0 |
| 2003-12-15 18:00:00 | MSFT | Stock | 26.8 | 26.82 | 26.76 | 26.76 | 5000.0 |
| 2003-12-15 08:00:00 | NVDA | Stock | 0.1771 | 0.1792 | 0.1771 | 0.1792 | 1371600.0 |
| 2003-12-15 09:00:00 | NVDA | Stock | 0.1787 | 0.1792 | 0.1761 | 0.1776 | 147243720.0 |
| 2003-12-15 10:00:00 | NVDA | Stock | 0.1776 | 0.178 | 0.175 | 0.1767 | 100308120.0 |
| 2003-12-15 11:00:00 | NVDA | Stock | 0.1767 | 0.1767 | 0.1752 | 0.1759 | 45309120.0 |
| 2003-12-15 12:00:00 | NVDA | Stock | 0.1758 | 0.1758 | 0.1737 | 0.1742 | 33429120.0 |
| 2003-12-15 13:00:00 | NVDA | Stock | 0.1742 | 0.1744 | 0.1711 | 0.1726 | 51809520.0 |
| 2003-12-15 14:00:00 | NVDA | Stock | 0.1726 | 0.1745 | 0.1724 | 0.1726 | 84710880.0 |
| 2003-12-15 15:00:00 | NVDA | Stock | 0.1726 | 0.1734 | 0.1699 | 0.1701 | 122381760.0 |
| 2003-12-15 16:00:00 | NVDA | Stock | 0.17 | 0.1748 | 0.1692 | 0.1702 | 16754280.0 |
| 2003-12-15 17:00:00 | NVDA | Stock | 0.1703 | 0.1703 | 0.1703 | 0.1703 | 241440.0 |
| 2003-12-15 08:00:00 | AMZN | Stock | 2.595 | 2.6245 | 2.595 | 2.62 | 979680.0 |
| 2003-12-15 09:00:00 | AMZN | Stock | 2.62 | 2.62 | 2.57 | 2.58 | 30513540.0 |
| 2003-12-15 10:00:00 | AMZN | Stock | 2.5795 | 2.595 | 2.575 | 2.5765 | 25960380.0 |
| 2003-12-15 11:00:00 | AMZN | Stock | 2.5755 | 2.58 | 2.555 | 2.5665 | 18293500.0 |
| 2003-12-15 12:00:00 | AMZN | Stock | 2.5675 | 2.572 | 2.5025 | 2.519 | 23435280.0 |
| 2003-12-15 13:00:00 | AMZN | Stock | 2.5195 | 2.5515 | 2.5086 | 2.548 | 32095840.0 |
| 2003-12-15 14:00:00 | AMZN | Stock | 2.548 | 2.5655 | 2.5332 | 2.5345 | 23700400.0 |
| 2003-12-15 15:00:00 | AMZN | Stock | 2.5345 | 2.5565 | 2.5045 | 2.517 | 31116340.0 |
| 2003-12-15 16:00:00 | AMZN | Stock | 2.518 | 2.521 | 2.495 | 2.495 | 1774740.0 |
| 2003-12-15 17:00:00 | AMZN | Stock | 2.4955 | 2.516 | 2.4945 | 2.4945 | 447880.0 |
| 2003-12-15 18:00:00 | AMZN | Stock | 2.495 | 2.495 | 2.4905 | 2.4925 | 32000.0 |
| 2003-12-15 09:00:00 | CL | Stock | 26.875 | 26.9 | 26.665 | 26.745 | 397600.0 |
| 2003-12-15 10:00:00 | CL | Stock | 26.745 | 26.85 | 26.73 | 26.77 | 434000.0 |
| 2003-12-15 11:00:00 | CL | Stock | 26.779 | 26.895 | 26.71 | 26.845 | 540800.0 |
| 2003-12-15 12:00:00 | CL | Stock | 26.845 | 26.875 | 26.765 | 26.875 | 199600.0 |
| 2003-12-15 13:00:00 | CL | Stock | 26.87 | 26.9 | 26.79 | 26.88 | 389800.0 |
| 2003-12-15 14:00:00 | CL | Stock | 26.88 | 26.965 | 26.85 | 26.855 | 526000.0 |
| 2003-12-15 15:00:00 | CL | Stock | 26.855 | 26.885 | 26.77 | 26.785 | 804200.0 |
> showing 50 of 24,393 rows — these rows as CSV