PREVIEW / stock_1hour / 2004-05-14
file: by_date/stock_1hour/2004/2004-05-14.parquet size: 496 KB rows: 23,452 symbols: 1,766
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-14 09:00:00 | AAPL | Stock | 0.4855 | 0.4879 | 0.4768 | 0.4782 | 30632336.0 |
| 2004-05-14 10:00:00 | AAPL | Stock | 0.4779 | 0.4811 | 0.4725 | 0.48 | 46071144.0 |
| 2004-05-14 11:00:00 | AAPL | Stock | 0.4802 | 0.482 | 0.4741 | 0.4768 | 19229672.0 |
| 2004-05-14 12:00:00 | AAPL | Stock | 0.4768 | 0.4768 | 0.4723 | 0.4745 | 24312456.0 |
| 2004-05-14 13:00:00 | AAPL | Stock | 0.4745 | 0.4832 | 0.4745 | 0.4827 | 28936488.0 |
| 2004-05-14 14:00:00 | AAPL | Stock | 0.4825 | 0.4879 | 0.4823 | 0.4838 | 28646520.0 |
| 2004-05-14 15:00:00 | AAPL | Stock | 0.4836 | 0.4843 | 0.4811 | 0.4821 | 63680456.0 |
| 2004-05-14 16:00:00 | AAPL | Stock | 0.4821 | 0.4832 | 0.4805 | 0.4805 | 2665880.0 |
| 2004-05-14 17:00:00 | AAPL | Stock | 0.4832 | 0.4832 | 0.4832 | 0.4832 | 448000.0 |
| 2004-05-14 08:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.86 | 25.9 | 83990.0 |
| 2004-05-14 09:00:00 | MSFT | Stock | 25.93 | 26.065 | 25.73 | 25.761 | 5649997.0 |
| 2004-05-14 10:00:00 | MSFT | Stock | 25.77 | 25.99 | 25.64 | 25.93 | 9493440.0 |
| 2004-05-14 11:00:00 | MSFT | Stock | 25.93 | 25.94 | 25.76 | 25.83 | 5173529.0 |
| 2004-05-14 12:00:00 | MSFT | Stock | 25.85 | 26.0 | 25.82 | 25.98 | 3914149.0 |
| 2004-05-14 13:00:00 | MSFT | Stock | 25.98 | 26.09 | 25.93 | 26.0 | 3954223.0 |
| 2004-05-14 14:00:00 | MSFT | Stock | 26.001 | 26.17 | 25.94 | 25.96 | 5106324.0 |
| 2004-05-14 15:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.83 | 25.86 | 7709083.0 |
| 2004-05-14 16:00:00 | MSFT | Stock | 25.86 | 25.93 | 25.85 | 25.89 | 567693.0 |
| 2004-05-14 17:00:00 | MSFT | Stock | 25.89 | 25.89 | 25.88 | 25.88 | 25800.0 |
| 2004-05-14 18:00:00 | MSFT | Stock | 25.89 | 25.89 | 25.89 | 25.89 | 5400.0 |
| 2004-05-14 09:00:00 | NVDA | Stock | 0.1781 | 0.1832 | 0.1781 | 0.1807 | 79637280.0 |
| 2004-05-14 10:00:00 | NVDA | Stock | 0.1807 | 0.181 | 0.1783 | 0.1792 | 110769120.0 |
| 2004-05-14 11:00:00 | NVDA | Stock | 0.1792 | 0.1803 | 0.1788 | 0.1793 | 58130640.0 |
| 2004-05-14 12:00:00 | NVDA | Stock | 0.1792 | 0.1803 | 0.179 | 0.1797 | 27800160.0 |
| 2004-05-14 13:00:00 | NVDA | Stock | 0.1799 | 0.1809 | 0.1795 | 0.1808 | 29423400.0 |
| 2004-05-14 14:00:00 | NVDA | Stock | 0.1808 | 0.1823 | 0.18 | 0.18 | 66532320.0 |
| 2004-05-14 15:00:00 | NVDA | Stock | 0.1801 | 0.1801 | 0.1787 | 0.1792 | 65456520.0 |
| 2004-05-14 16:00:00 | NVDA | Stock | 0.1792 | 0.1799 | 0.1787 | 0.1787 | 5022120.0 |
| 2004-05-14 17:00:00 | NVDA | Stock | 0.18 | 0.18 | 0.18 | 0.18 | 21600.0 |
| 2004-05-14 08:00:00 | AMZN | Stock | 2.175 | 2.1795 | 2.1625 | 2.1625 | 48000.0 |
| 2004-05-14 09:00:00 | AMZN | Stock | 2.1805 | 2.19 | 2.1425 | 2.146 | 14516220.0 |
| 2004-05-14 10:00:00 | AMZN | Stock | 2.147 | 2.168 | 2.138 | 2.161 | 20669400.0 |
| 2004-05-14 11:00:00 | AMZN | Stock | 2.1605 | 2.1715 | 2.1435 | 2.1575 | 11630040.0 |
| 2004-05-14 12:00:00 | AMZN | Stock | 2.158 | 2.161 | 2.147 | 2.1555 | 6245120.0 |
| 2004-05-14 13:00:00 | AMZN | Stock | 2.156 | 2.187 | 2.1546 | 2.187 | 13615760.0 |
| 2004-05-14 14:00:00 | AMZN | Stock | 2.1865 | 2.196 | 2.168 | 2.173 | 13104620.0 |
| 2004-05-14 15:00:00 | AMZN | Stock | 2.1725 | 2.1735 | 2.153 | 2.154 | 16966400.0 |
| 2004-05-14 16:00:00 | AMZN | Stock | 2.154 | 2.159 | 2.15 | 2.1525 | 1448440.0 |
| 2004-05-14 17:00:00 | AMZN | Stock | 2.1525 | 2.1525 | 2.1525 | 2.1525 | 423680.0 |
| 2004-05-14 18:00:00 | AMZN | Stock | 2.16 | 2.16 | 2.16 | 2.16 | 2000.0 |
| 2004-05-14 09:00:00 | CL | Stock | 27.975 | 28.09 | 27.62 | 27.645 | 501000.0 |
| 2004-05-14 10:00:00 | CL | Stock | 27.65 | 27.99 | 27.575 | 27.96 | 1030000.0 |
| 2004-05-14 11:00:00 | CL | Stock | 27.955 | 28.175 | 27.945 | 28.09 | 653600.0 |
| 2004-05-14 12:00:00 | CL | Stock | 28.095 | 28.12 | 27.96 | 28.005 | 348200.0 |
| 2004-05-14 13:00:00 | CL | Stock | 28.005 | 28.085 | 27.915 | 27.94 | 551400.0 |
| 2004-05-14 14:00:00 | CL | Stock | 27.935 | 27.965 | 27.9 | 27.93 | 749400.0 |
| 2004-05-14 15:00:00 | CL | Stock | 27.93 | 27.93 | 27.825 | 27.87 | 912800.0 |
| 2004-05-14 16:00:00 | CL | Stock | 27.88 | 27.88 | 27.875 | 27.875 | 140000.0 |
> showing 48 of 23,452 rows — these rows as CSV