PREVIEW / stock_1hour / 2000-04-11
file: by_date/stock_1hour/2000/2000-04-11.parquet size: 284 KB rows: 14,444 symbols: 1,159
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-11 09:00:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.0759 | 1.0982 | 35347200.0 |
| 2000-04-11 10:00:00 | AAPL | Stock | 1.0977 | 1.115 | 1.0759 | 1.0982 | 50366400.0 |
| 2000-04-11 11:00:00 | AAPL | Stock | 1.0993 | 1.1049 | 1.0541 | 1.0759 | 137300800.0 |
| 2000-04-11 12:00:00 | AAPL | Stock | 1.077 | 1.0826 | 1.0614 | 1.0714 | 82454400.0 |
| 2000-04-11 13:00:00 | AAPL | Stock | 1.0714 | 1.1083 | 1.0692 | 1.0915 | 80606400.0 |
| 2000-04-11 14:00:00 | AAPL | Stock | 1.0893 | 1.0993 | 1.0714 | 1.0787 | 55507200.0 |
| 2000-04-11 15:00:00 | AAPL | Stock | 1.0804 | 1.0848 | 1.0575 | 1.0658 | 71568000.0 |
| 2000-04-11 16:00:00 | AAPL | Stock | 1.0664 | 1.0664 | 1.0664 | 1.0664 | 369600.0 |
| 2000-04-11 09:00:00 | MSFT | Stock | 42.5625 | 42.9375 | 42.5 | 42.9062 | 10108200.0 |
| 2000-04-11 10:00:00 | MSFT | Stock | 42.9062 | 42.9062 | 42.125 | 42.4375 | 12497800.0 |
| 2000-04-11 11:00:00 | MSFT | Stock | 42.375 | 42.7812 | 42.1875 | 42.6875 | 7162200.0 |
| 2000-04-11 12:00:00 | MSFT | Stock | 42.6875 | 42.7188 | 42.3438 | 42.6875 | 4797000.0 |
| 2000-04-11 13:00:00 | MSFT | Stock | 42.6875 | 43.0312 | 42.5 | 42.5 | 5230400.0 |
| 2000-04-11 14:00:00 | MSFT | Stock | 42.5 | 42.625 | 42.125 | 42.3125 | 9651200.0 |
| 2000-04-11 15:00:00 | MSFT | Stock | 42.3125 | 42.3438 | 41.75 | 41.9375 | 17023200.0 |
| 2000-04-11 16:00:00 | MSFT | Stock | 41.9531 | 41.9688 | 41.9375 | 41.9375 | 152000.0 |
| 2000-04-11 09:00:00 | NVDA | Stock | 0.1812 | 0.1866 | 0.1667 | 0.1832 | 76608000.0 |
| 2000-04-11 10:00:00 | NVDA | Stock | 0.1836 | 0.1867 | 0.1749 | 0.1798 | 49488000.0 |
| 2000-04-11 11:00:00 | NVDA | Stock | 0.1792 | 0.1937 | 0.1792 | 0.1922 | 60576000.0 |
| 2000-04-11 12:00:00 | NVDA | Stock | 0.1914 | 0.1927 | 0.1823 | 0.1875 | 32544000.0 |
| 2000-04-11 13:00:00 | NVDA | Stock | 0.1875 | 0.1979 | 0.1863 | 0.1958 | 85248000.0 |
| 2000-04-11 14:00:00 | NVDA | Stock | 0.1956 | 0.1957 | 0.1865 | 0.1876 | 45264000.0 |
| 2000-04-11 15:00:00 | NVDA | Stock | 0.1891 | 0.1891 | 0.1823 | 0.1835 | 39264000.0 |
| 2000-04-11 16:00:00 | NVDA | Stock | 0.1832 | 0.1832 | 0.1832 | 0.1832 | 48000.0 |
| 2000-04-11 09:00:00 | AMZN | Stock | 3.125 | 3.2375 | 3.0625 | 3.2359 | 12984000.0 |
| 2000-04-11 10:00:00 | AMZN | Stock | 3.2188 | 3.2219 | 3.1062 | 3.1562 | 17200000.0 |
| 2000-04-11 11:00:00 | AMZN | Stock | 3.1562 | 3.2719 | 3.1125 | 3.2656 | 14730000.0 |
| 2000-04-11 12:00:00 | AMZN | Stock | 3.2656 | 3.2812 | 3.1875 | 3.225 | 11432000.0 |
| 2000-04-11 13:00:00 | AMZN | Stock | 3.2219 | 3.3 | 3.2125 | 3.2312 | 8550000.0 |
| 2000-04-11 14:00:00 | AMZN | Stock | 3.2312 | 3.2625 | 3.1688 | 3.2469 | 10502000.0 |
| 2000-04-11 15:00:00 | AMZN | Stock | 3.2469 | 3.25 | 3.1438 | 3.1656 | 12568000.0 |
| 2000-04-11 16:00:00 | AMZN | Stock | 3.1656 | 3.1688 | 3.1625 | 3.1688 | 238000.0 |
| 2000-04-11 09:00:00 | CL | Stock | 30.4375 | 30.5625 | 30.375 | 30.5625 | 594600.0 |
| 2000-04-11 10:00:00 | CL | Stock | 30.5625 | 31.0625 | 30.5312 | 30.6875 | 1073800.0 |
| 2000-04-11 11:00:00 | CL | Stock | 30.6875 | 31.1875 | 30.6562 | 31.0 | 791600.0 |
| 2000-04-11 12:00:00 | CL | Stock | 31.0312 | 31.1875 | 30.8125 | 30.9375 | 573600.0 |
| 2000-04-11 13:00:00 | CL | Stock | 30.9062 | 31.0625 | 30.9062 | 31.0 | 215200.0 |
| 2000-04-11 14:00:00 | CL | Stock | 31.0312 | 31.375 | 31.0312 | 31.2188 | 653200.0 |
| 2000-04-11 15:00:00 | CL | Stock | 31.1875 | 31.4375 | 31.0938 | 31.2812 | 774600.0 |
| 2000-04-11 16:00:00 | CL | Stock | 31.2812 | 31.3125 | 31.25 | 31.3125 | 326000.0 |
> showing 40 of 14,444 rows — these rows as CSV