PREVIEW / stock_1hour / 2003-12-02
file: by_date/stock_1hour/2003/2003-12-02.parquet size: 512 KB rows: 23,712 symbols: 1,684
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-02 08:00:00 | AAPL | Stock | 0.3885 | 0.3907 | 0.3875 | 0.3879 | 1557360.0 |
| 2003-12-02 09:00:00 | AAPL | Stock | 0.3857 | 0.39 | 0.3823 | 0.3845 | 28687400.0 |
| 2003-12-02 10:00:00 | AAPL | Stock | 0.3845 | 0.3877 | 0.3839 | 0.3866 | 26359256.0 |
| 2003-12-02 11:00:00 | AAPL | Stock | 0.3864 | 0.3911 | 0.3864 | 0.3909 | 21304304.0 |
| 2003-12-02 12:00:00 | AAPL | Stock | 0.3907 | 0.3909 | 0.3871 | 0.3871 | 26863424.0 |
| 2003-12-02 13:00:00 | AAPL | Stock | 0.387 | 0.391 | 0.3868 | 0.3909 | 13666016.0 |
| 2003-12-02 14:00:00 | AAPL | Stock | 0.3909 | 0.3909 | 0.3848 | 0.3854 | 32609808.0 |
| 2003-12-02 15:00:00 | AAPL | Stock | 0.385 | 0.3879 | 0.3838 | 0.3839 | 35108976.0 |
| 2003-12-02 16:00:00 | AAPL | Stock | 0.3845 | 0.3854 | 0.3834 | 0.3843 | 5841472.0 |
| 2003-12-02 17:00:00 | AAPL | Stock | 0.383 | 0.3845 | 0.383 | 0.3845 | 767200.0 |
| 2003-12-02 18:00:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3866 | 0.3866 | 683200.0 |
| 2003-12-02 08:00:00 | MSFT | Stock | 25.74 | 25.89 | 25.3 | 25.85 | 68160.0 |
| 2003-12-02 09:00:00 | MSFT | Stock | 25.85 | 25.97 | 25.775 | 25.91 | 10535607.0 |
| 2003-12-02 10:00:00 | MSFT | Stock | 25.91 | 25.96 | 25.87 | 25.92 | 14660007.0 |
| 2003-12-02 11:00:00 | MSFT | Stock | 25.92 | 26.09 | 25.9 | 26.02 | 9435506.0 |
| 2003-12-02 12:00:00 | MSFT | Stock | 26.02 | 26.03 | 25.86 | 25.91 | 6085568.0 |
| 2003-12-02 13:00:00 | MSFT | Stock | 25.91 | 25.99 | 25.9 | 25.94 | 5934511.0 |
| 2003-12-02 14:00:00 | MSFT | Stock | 25.94 | 25.95 | 25.61 | 25.64 | 12749441.0 |
| 2003-12-02 15:00:00 | MSFT | Stock | 25.64 | 25.79 | 25.62 | 25.67 | 14697313.0 |
| 2003-12-02 16:00:00 | MSFT | Stock | 25.66 | 25.75 | 25.638 | 25.643 | 2848343.0 |
| 2003-12-02 17:00:00 | MSFT | Stock | 25.74 | 25.74 | 25.68 | 25.73 | 113121.0 |
| 2003-12-02 18:00:00 | MSFT | Stock | 25.74 | 25.74 | 25.72 | 25.72 | 8935.0 |
| 2003-12-02 08:00:00 | NVDA | Stock | 0.1794 | 0.1799 | 0.1787 | 0.1787 | 3876000.0 |
| 2003-12-02 09:00:00 | NVDA | Stock | 0.1788 | 0.1809 | 0.1776 | 0.18 | 64694760.0 |
| 2003-12-02 10:00:00 | NVDA | Stock | 0.18 | 0.1811 | 0.1796 | 0.1801 | 80819040.0 |
| 2003-12-02 11:00:00 | NVDA | Stock | 0.1801 | 0.1822 | 0.1801 | 0.1822 | 113713560.0 |
| 2003-12-02 12:00:00 | NVDA | Stock | 0.1822 | 0.1823 | 0.1804 | 0.1805 | 47156760.0 |
| 2003-12-02 13:00:00 | NVDA | Stock | 0.1806 | 0.1812 | 0.1802 | 0.181 | 40349520.0 |
| 2003-12-02 14:00:00 | NVDA | Stock | 0.181 | 0.181 | 0.179 | 0.179 | 72009000.0 |
| 2003-12-02 15:00:00 | NVDA | Stock | 0.179 | 0.1797 | 0.1783 | 0.1783 | 78911280.0 |
| 2003-12-02 16:00:00 | NVDA | Stock | 0.1786 | 0.1789 | 0.1782 | 0.1785 | 18394200.0 |
| 2003-12-02 17:00:00 | NVDA | Stock | 0.1786 | 0.1786 | 0.1782 | 0.1786 | 607200.0 |
| 2003-12-02 18:00:00 | NVDA | Stock | 0.1781 | 0.1781 | 0.1781 | 0.1781 | 12000.0 |
| 2003-12-02 08:00:00 | AMZN | Stock | 2.7275 | 2.735 | 2.719 | 2.729 | 228000.0 |
| 2003-12-02 09:00:00 | AMZN | Stock | 2.725 | 2.7315 | 2.703 | 2.7097 | 16694620.0 |
| 2003-12-02 10:00:00 | AMZN | Stock | 2.7095 | 2.7185 | 2.702 | 2.709 | 15523040.0 |
| 2003-12-02 11:00:00 | AMZN | Stock | 2.709 | 2.7365 | 2.705 | 2.736 | 14795900.0 |
| 2003-12-02 12:00:00 | AMZN | Stock | 2.7355 | 2.7365 | 2.722 | 2.724 | 10951000.0 |
| 2003-12-02 13:00:00 | AMZN | Stock | 2.724 | 2.7375 | 2.7235 | 2.734 | 8171640.0 |
| 2003-12-02 14:00:00 | AMZN | Stock | 2.7335 | 2.7345 | 2.705 | 2.705 | 22546120.0 |
| 2003-12-02 15:00:00 | AMZN | Stock | 2.7055 | 2.714 | 2.6925 | 2.7 | 23068760.0 |
| 2003-12-02 16:00:00 | AMZN | Stock | 2.699 | 2.72 | 2.6925 | 2.695 | 1361520.0 |
| 2003-12-02 17:00:00 | AMZN | Stock | 2.6965 | 2.699 | 2.6965 | 2.6975 | 1655120.0 |
| 2003-12-02 18:00:00 | AMZN | Stock | 2.6975 | 2.7059 | 2.6975 | 2.699 | 132740.0 |
| 2003-12-02 09:00:00 | CL | Stock | 26.435 | 26.5 | 26.425 | 26.465 | 262400.0 |
| 2003-12-02 10:00:00 | CL | Stock | 26.465 | 26.51 | 26.425 | 26.455 | 310200.0 |
| 2003-12-02 11:00:00 | CL | Stock | 26.45 | 26.455 | 26.385 | 26.44 | 357800.0 |
| 2003-12-02 12:00:00 | CL | Stock | 26.435 | 26.45 | 26.4 | 26.435 | 285800.0 |
| 2003-12-02 13:00:00 | CL | Stock | 26.435 | 26.525 | 26.425 | 26.505 | 218400.0 |
| 2003-12-02 14:00:00 | CL | Stock | 26.51 | 26.525 | 26.4 | 26.43 | 520600.0 |
> showing 50 of 23,712 rows — these rows as CSV