PREVIEW / stock_1hour / 2003-12-01
file: by_date/stock_1hour/2003/2003-12-01.parquet size: 493 KB rows: 23,362 symbols: 1,689
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-01 08:00:00 | AAPL | Stock | 0.3748 | 0.3795 | 0.3748 | 0.3788 | 190400.0 |
| 2003-12-01 09:00:00 | AAPL | Stock | 0.377 | 0.383 | 0.3736 | 0.3827 | 35796488.0 |
| 2003-12-01 10:00:00 | AAPL | Stock | 0.3821 | 0.3876 | 0.3804 | 0.3809 | 60184936.0 |
| 2003-12-01 11:00:00 | AAPL | Stock | 0.3813 | 0.3866 | 0.3805 | 0.3859 | 50599360.0 |
| 2003-12-01 12:00:00 | AAPL | Stock | 0.3855 | 0.388 | 0.3855 | 0.3868 | 28928032.0 |
| 2003-12-01 13:00:00 | AAPL | Stock | 0.3866 | 0.3868 | 0.3846 | 0.3863 | 25364864.0 |
| 2003-12-01 14:00:00 | AAPL | Stock | 0.3861 | 0.3866 | 0.3829 | 0.3859 | 37205224.0 |
| 2003-12-01 15:00:00 | AAPL | Stock | 0.3859 | 0.3893 | 0.3846 | 0.3893 | 48326712.0 |
| 2003-12-01 16:00:00 | AAPL | Stock | 0.3893 | 0.3902 | 0.3848 | 0.3896 | 10166968.0 |
| 2003-12-01 17:00:00 | AAPL | Stock | 0.3884 | 0.3896 | 0.3884 | 0.3893 | 61600.0 |
| 2003-12-01 08:00:00 | MSFT | Stock | 25.89 | 25.94 | 25.81 | 25.87 | 91286.0 |
| 2003-12-01 09:00:00 | MSFT | Stock | 25.88 | 25.97 | 25.7 | 25.97 | 9545143.0 |
| 2003-12-01 10:00:00 | MSFT | Stock | 25.97 | 26.17 | 25.94 | 26.01 | 20612434.0 |
| 2003-12-01 11:00:00 | MSFT | Stock | 26.01 | 26.09 | 25.94 | 25.94 | 10112597.0 |
| 2003-12-01 12:00:00 | MSFT | Stock | 25.941 | 26.04 | 25.93 | 25.96 | 6707263.0 |
| 2003-12-01 13:00:00 | MSFT | Stock | 25.97 | 25.98 | 25.88 | 25.91 | 7765956.0 |
| 2003-12-01 14:00:00 | MSFT | Stock | 25.91 | 25.91 | 25.62 | 25.72 | 15222782.0 |
| 2003-12-01 15:00:00 | MSFT | Stock | 25.71 | 25.93 | 25.7 | 25.84 | 18569406.0 |
| 2003-12-01 16:00:00 | MSFT | Stock | 25.84 | 25.9156 | 25.79 | 25.83 | 730480.0 |
| 2003-12-01 17:00:00 | MSFT | Stock | 25.82 | 25.86 | 25.81 | 25.85 | 529102.0 |
| 2003-12-01 18:00:00 | MSFT | Stock | 25.82 | 25.85 | 25.81 | 25.81 | 2400.0 |
| 2003-12-01 08:00:00 | NVDA | Stock | 0.1775 | 0.1799 | 0.1775 | 0.1783 | 1788000.0 |
| 2003-12-01 09:00:00 | NVDA | Stock | 0.1783 | 0.1807 | 0.1762 | 0.1795 | 64958520.0 |
| 2003-12-01 10:00:00 | NVDA | Stock | 0.1796 | 0.1806 | 0.1785 | 0.1788 | 94931040.0 |
| 2003-12-01 11:00:00 | NVDA | Stock | 0.1788 | 0.1798 | 0.1787 | 0.1792 | 41994360.0 |
| 2003-12-01 12:00:00 | NVDA | Stock | 0.1792 | 0.1797 | 0.1789 | 0.1792 | 30699480.0 |
| 2003-12-01 13:00:00 | NVDA | Stock | 0.1793 | 0.1793 | 0.1783 | 0.1789 | 70336200.0 |
| 2003-12-01 14:00:00 | NVDA | Stock | 0.1789 | 0.1791 | 0.1768 | 0.179 | 96199200.0 |
| 2003-12-01 15:00:00 | NVDA | Stock | 0.179 | 0.18 | 0.1783 | 0.1793 | 71071680.0 |
| 2003-12-01 16:00:00 | NVDA | Stock | 0.1794 | 0.1797 | 0.179 | 0.179 | 8031360.0 |
| 2003-12-01 17:00:00 | NVDA | Stock | 0.1792 | 0.1792 | 0.1792 | 0.1792 | 90000.0 |
| 2003-12-01 18:00:00 | NVDA | Stock | 0.1792 | 0.1792 | 0.1792 | 0.1792 | 120000.0 |
| 2003-12-01 08:00:00 | AMZN | Stock | 2.7105 | 2.7225 | 2.71 | 2.7185 | 765000.0 |
| 2003-12-01 09:00:00 | AMZN | Stock | 2.7195 | 2.7245 | 2.666 | 2.6835 | 35255980.0 |
| 2003-12-01 10:00:00 | AMZN | Stock | 2.685 | 2.7141 | 2.6524 | 2.6625 | 51769200.0 |
| 2003-12-01 11:00:00 | AMZN | Stock | 2.663 | 2.6895 | 2.6615 | 2.683 | 16588660.0 |
| 2003-12-01 12:00:00 | AMZN | Stock | 2.683 | 2.689 | 2.6755 | 2.6805 | 8960820.0 |
| 2003-12-01 13:00:00 | AMZN | Stock | 2.6815 | 2.684 | 2.669 | 2.676 | 8633720.0 |
| 2003-12-01 14:00:00 | AMZN | Stock | 2.6755 | 2.6925 | 2.6545 | 2.69 | 24122000.0 |
| 2003-12-01 15:00:00 | AMZN | Stock | 2.69 | 2.7375 | 2.689 | 2.7325 | 52097460.0 |
| 2003-12-01 16:00:00 | AMZN | Stock | 2.7355 | 2.7405 | 2.7306 | 2.7335 | 1202360.0 |
| 2003-12-01 17:00:00 | AMZN | Stock | 2.733 | 2.7375 | 2.733 | 2.7375 | 226720.0 |
| 2003-12-01 18:00:00 | AMZN | Stock | 2.734 | 2.737 | 2.734 | 2.737 | 48000.0 |
| 2003-12-01 09:00:00 | CL | Stock | 26.3 | 26.395 | 26.295 | 26.325 | 237200.0 |
| 2003-12-01 10:00:00 | CL | Stock | 26.325 | 26.475 | 26.32 | 26.455 | 745800.0 |
| 2003-12-01 11:00:00 | CL | Stock | 26.455 | 26.515 | 26.455 | 26.495 | 372400.0 |
| 2003-12-01 12:00:00 | CL | Stock | 26.49 | 26.6 | 26.46 | 26.57 | 315000.0 |
| 2003-12-01 13:00:00 | CL | Stock | 26.56 | 26.565 | 26.465 | 26.5 | 399600.0 |
| 2003-12-01 14:00:00 | CL | Stock | 26.49 | 26.49 | 26.38 | 26.47 | 538000.0 |
| 2003-12-01 15:00:00 | CL | Stock | 26.465 | 26.48 | 26.415 | 26.45 | 856600.0 |
> showing 50 of 23,362 rows — these rows as CSV