PREVIEW / stock_1hour / 2004-05-13
file: by_date/stock_1hour/2004/2004-05-13.parquet size: 504 KB rows: 23,850 symbols: 1,770
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-13 08:00:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4875 | 0.4875 | 33600.0 |
| 2004-05-13 09:00:00 | AAPL | Stock | 0.4857 | 0.4866 | 0.4814 | 0.4855 | 27695808.0 |
| 2004-05-13 10:00:00 | AAPL | Stock | 0.4848 | 0.4907 | 0.4804 | 0.4897 | 31148544.0 |
| 2004-05-13 11:00:00 | AAPL | Stock | 0.4896 | 0.495 | 0.488 | 0.4927 | 45206560.0 |
| 2004-05-13 12:00:00 | AAPL | Stock | 0.4927 | 0.4932 | 0.4861 | 0.4861 | 22314768.0 |
| 2004-05-13 13:00:00 | AAPL | Stock | 0.4864 | 0.488 | 0.4839 | 0.4846 | 16648352.0 |
| 2004-05-13 14:00:00 | AAPL | Stock | 0.4846 | 0.4873 | 0.4821 | 0.4834 | 23362808.0 |
| 2004-05-13 15:00:00 | AAPL | Stock | 0.4832 | 0.4893 | 0.483 | 0.4857 | 30035768.0 |
| 2004-05-13 16:00:00 | AAPL | Stock | 0.4866 | 0.487 | 0.4813 | 0.4854 | 16684024.0 |
| 2004-05-13 17:00:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4855 | 0.4855 | 299880.0 |
| 2004-05-13 08:00:00 | MSFT | Stock | 25.87 | 25.94 | 25.85 | 25.86 | 23800.0 |
| 2004-05-13 09:00:00 | MSFT | Stock | 25.86 | 26.16 | 25.72 | 26.07 | 7627817.0 |
| 2004-05-13 10:00:00 | MSFT | Stock | 26.07 | 26.13 | 25.94 | 26.1 | 10762790.0 |
| 2004-05-13 11:00:00 | MSFT | Stock | 26.1 | 26.12 | 25.95 | 26.08 | 7200555.0 |
| 2004-05-13 12:00:00 | MSFT | Stock | 26.08 | 26.11 | 25.94 | 25.96 | 4574875.0 |
| 2004-05-13 13:00:00 | MSFT | Stock | 25.95 | 26.02 | 25.84 | 25.92 | 5150545.0 |
| 2004-05-13 14:00:00 | MSFT | Stock | 25.93 | 26.02 | 25.79 | 25.99 | 7844275.0 |
| 2004-05-13 15:00:00 | MSFT | Stock | 25.99 | 26.19 | 25.99 | 26.07 | 13846419.0 |
| 2004-05-13 16:00:00 | MSFT | Stock | 26.07 | 26.13 | 25.95 | 26.01 | 2575636.0 |
| 2004-05-13 17:00:00 | MSFT | Stock | 26.05 | 26.1 | 26.0 | 26.0 | 65040.0 |
| 2004-05-13 18:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.99 | 26.0 | 2700.0 |
| 2004-05-13 09:00:00 | NVDA | Stock | 0.1783 | 0.1808 | 0.1771 | 0.1789 | 57306120.0 |
| 2004-05-13 10:00:00 | NVDA | Stock | 0.1788 | 0.1801 | 0.1767 | 0.1797 | 63787080.0 |
| 2004-05-13 11:00:00 | NVDA | Stock | 0.1798 | 0.1825 | 0.1796 | 0.1825 | 39394680.0 |
| 2004-05-13 12:00:00 | NVDA | Stock | 0.1823 | 0.1825 | 0.1791 | 0.1794 | 40217760.0 |
| 2004-05-13 13:00:00 | NVDA | Stock | 0.1794 | 0.1802 | 0.1791 | 0.1797 | 24530640.0 |
| 2004-05-13 14:00:00 | NVDA | Stock | 0.1796 | 0.1804 | 0.1782 | 0.1792 | 46787520.0 |
| 2004-05-13 15:00:00 | NVDA | Stock | 0.1792 | 0.1806 | 0.1791 | 0.1792 | 44523600.0 |
| 2004-05-13 16:00:00 | NVDA | Stock | 0.1792 | 0.1796 | 0.1781 | 0.1781 | 1434720.0 |
| 2004-05-13 17:00:00 | NVDA | Stock | 0.1792 | 0.1793 | 0.1785 | 0.1785 | 503400.0 |
| 2004-05-13 18:00:00 | NVDA | Stock | 0.1785 | 0.1785 | 0.1785 | 0.1785 | 144000.0 |
| 2004-05-13 08:00:00 | AMZN | Stock | 2.1485 | 2.1485 | 2.1375 | 2.1375 | 30000.0 |
| 2004-05-13 09:00:00 | AMZN | Stock | 2.14 | 2.1425 | 2.1125 | 2.127 | 18537980.0 |
| 2004-05-13 10:00:00 | AMZN | Stock | 2.126 | 2.1625 | 2.12 | 2.162 | 20098900.0 |
| 2004-05-13 11:00:00 | AMZN | Stock | 2.162 | 2.205 | 2.1585 | 2.2005 | 34042920.0 |
| 2004-05-13 12:00:00 | AMZN | Stock | 2.2 | 2.2065 | 2.1875 | 2.195 | 24017760.0 |
| 2004-05-13 13:00:00 | AMZN | Stock | 2.1955 | 2.2055 | 2.1795 | 2.189 | 16955180.0 |
| 2004-05-13 14:00:00 | AMZN | Stock | 2.1895 | 2.202 | 2.18 | 2.19 | 16364120.0 |
| 2004-05-13 15:00:00 | AMZN | Stock | 2.1905 | 2.202 | 2.179 | 2.186 | 21532300.0 |
| 2004-05-13 16:00:00 | AMZN | Stock | 2.186 | 2.19 | 2.179 | 2.189 | 3356840.0 |
| 2004-05-13 17:00:00 | AMZN | Stock | 2.192 | 2.192 | 2.1805 | 2.181 | 138960.0 |
| 2004-05-13 09:00:00 | CL | Stock | 28.465 | 28.58 | 28.415 | 28.5 | 268000.0 |
| 2004-05-13 10:00:00 | CL | Stock | 28.495 | 28.495 | 28.21 | 28.275 | 362200.0 |
| 2004-05-13 11:00:00 | CL | Stock | 28.26 | 28.3 | 28.13 | 28.19 | 327000.0 |
| 2004-05-13 12:00:00 | CL | Stock | 28.19 | 28.21 | 28.105 | 28.125 | 389200.0 |
| 2004-05-13 13:00:00 | CL | Stock | 28.12 | 28.165 | 28.025 | 28.045 | 482800.0 |
| 2004-05-13 14:00:00 | CL | Stock | 28.045 | 28.05 | 27.945 | 27.99 | 867800.0 |
| 2004-05-13 15:00:00 | CL | Stock | 27.99 | 28.085 | 27.975 | 27.995 | 1268200.0 |
| 2004-05-13 16:00:00 | CL | Stock | 28.01 | 28.01 | 27.98 | 27.995 | 3800.0 |
> showing 49 of 23,850 rows — these rows as CSV