PREVIEW / stock_1hour / 2000-03-21
file: by_date/stock_1hour/2000/2000-03-21.parquet size: 278 KB rows: 14,280 symbols: 1,148
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-03-21 09:00:00 | AAPL | Stock | 1.0943 | 1.0982 | 1.0859 | 1.0915 | 16139200.0 |
| 2000-03-21 10:00:00 | AAPL | Stock | 1.0938 | 1.1445 | 1.0904 | 1.1406 | 59841600.0 |
| 2000-03-21 11:00:00 | AAPL | Stock | 1.1417 | 1.1523 | 1.1373 | 1.1468 | 55955200.0 |
| 2000-03-21 12:00:00 | AAPL | Stock | 1.1451 | 1.1507 | 1.1429 | 1.1473 | 25603200.0 |
| 2000-03-21 13:00:00 | AAPL | Stock | 1.1462 | 1.1641 | 1.1429 | 1.1607 | 57209600.0 |
| 2000-03-21 14:00:00 | AAPL | Stock | 1.1607 | 1.183 | 1.1395 | 1.1786 | 125798400.0 |
| 2000-03-21 15:00:00 | AAPL | Stock | 1.1786 | 1.221 | 1.1769 | 1.2048 | 140974400.0 |
| 2000-03-21 16:00:00 | AAPL | Stock | 1.2059 | 1.2059 | 1.2042 | 1.2048 | 884800.0 |
| 2000-03-21 09:00:00 | MSFT | Stock | 48.375 | 48.625 | 48.25 | 48.5938 | 4426200.0 |
| 2000-03-21 10:00:00 | MSFT | Stock | 48.625 | 49.5 | 48.4688 | 49.4375 | 10518400.0 |
| 2000-03-21 11:00:00 | MSFT | Stock | 49.4688 | 49.5938 | 48.9688 | 49.4375 | 7213000.0 |
| 2000-03-21 12:00:00 | MSFT | Stock | 49.4062 | 49.4688 | 49.0625 | 49.2812 | 5460200.0 |
| 2000-03-21 13:00:00 | MSFT | Stock | 49.2812 | 50.0938 | 49.25 | 49.8125 | 11412800.0 |
| 2000-03-21 14:00:00 | MSFT | Stock | 49.7812 | 50.0 | 49.125 | 50.0 | 12644200.0 |
| 2000-03-21 15:00:00 | MSFT | Stock | 50.0 | 51.5625 | 49.9375 | 51.375 | 24751000.0 |
| 2000-03-21 16:00:00 | MSFT | Stock | 51.375 | 51.4062 | 51.25 | 51.375 | 114200.0 |
| 2000-03-21 09:00:00 | NVDA | Stock | 0.2083 | 0.2102 | 0.1937 | 0.1937 | 40560000.0 |
| 2000-03-21 10:00:00 | NVDA | Stock | 0.1932 | 0.1943 | 0.1812 | 0.1865 | 146352000.0 |
| 2000-03-21 11:00:00 | NVDA | Stock | 0.1865 | 0.1979 | 0.1863 | 0.1875 | 74400000.0 |
| 2000-03-21 12:00:00 | NVDA | Stock | 0.1875 | 0.1891 | 0.1844 | 0.1885 | 45360000.0 |
| 2000-03-21 13:00:00 | NVDA | Stock | 0.1883 | 0.1898 | 0.1867 | 0.1896 | 44784000.0 |
| 2000-03-21 14:00:00 | NVDA | Stock | 0.1898 | 0.1958 | 0.1893 | 0.19 | 33840000.0 |
| 2000-03-21 15:00:00 | NVDA | Stock | 0.19 | 0.1975 | 0.1891 | 0.1975 | 88704000.0 |
| 2000-03-21 09:00:00 | AMZN | Stock | 3.2562 | 3.2688 | 3.1188 | 3.1219 | 22048000.0 |
| 2000-03-21 10:00:00 | AMZN | Stock | 3.1219 | 3.25 | 3.1125 | 3.2406 | 31566000.0 |
| 2000-03-21 11:00:00 | AMZN | Stock | 3.2406 | 3.3688 | 3.2344 | 3.3188 | 47246000.0 |
| 2000-03-21 12:00:00 | AMZN | Stock | 3.3188 | 3.3625 | 3.3 | 3.3438 | 19456000.0 |
| 2000-03-21 13:00:00 | AMZN | Stock | 3.3438 | 3.4 | 3.3375 | 3.3844 | 23728000.0 |
| 2000-03-21 14:00:00 | AMZN | Stock | 3.3844 | 3.5938 | 3.3312 | 3.5844 | 84518000.0 |
| 2000-03-21 15:00:00 | AMZN | Stock | 3.5922 | 3.65 | 3.525 | 3.625 | 90274000.0 |
| 2000-03-21 16:00:00 | AMZN | Stock | 3.6156 | 3.6344 | 3.6125 | 3.6188 | 326000.0 |
| 2000-03-21 09:00:00 | CL | Stock | 24.9375 | 25.0 | 24.875 | 24.875 | 329000.0 |
| 2000-03-21 10:00:00 | CL | Stock | 24.9062 | 25.375 | 24.9062 | 25.1875 | 955600.0 |
| 2000-03-21 11:00:00 | CL | Stock | 25.1562 | 25.5 | 25.125 | 25.3438 | 541800.0 |
| 2000-03-21 12:00:00 | CL | Stock | 25.4688 | 25.75 | 25.4062 | 25.5625 | 565600.0 |
| 2000-03-21 13:00:00 | CL | Stock | 25.5625 | 25.625 | 25.375 | 25.4375 | 502600.0 |
| 2000-03-21 14:00:00 | CL | Stock | 25.4688 | 25.4688 | 24.875 | 25.0938 | 435400.0 |
| 2000-03-21 15:00:00 | CL | Stock | 25.0938 | 25.25 | 25.0312 | 25.0625 | 668000.0 |
| 2000-03-21 16:00:00 | CL | Stock | 25.0938 | 25.1562 | 25.0625 | 25.1562 | 174800.0 |
> showing 39 of 14,280 rows — these rows as CSV