PREVIEW / stock_1hour / 2000-12-08
file: by_date/stock_1hour/2000/2000-12-08.parquet size: 327 KB rows: 16,874 symbols: 1,255
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-12-08 08:00:00 | AAPL | Stock | 0.26 | 0.2634 | 0.2589 | 0.2595 | 123200.0 |
| 2000-12-08 09:00:00 | AAPL | Stock | 0.2634 | 0.2667 | 0.2578 | 0.2617 | 46704000.0 |
| 2000-12-08 10:00:00 | AAPL | Stock | 0.2623 | 0.2667 | 0.26 | 0.2656 | 70347200.0 |
| 2000-12-08 11:00:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2623 | 0.2634 | 37346400.0 |
| 2000-12-08 12:00:00 | AAPL | Stock | 0.2645 | 0.269 | 0.2634 | 0.2679 | 49408800.0 |
| 2000-12-08 13:00:00 | AAPL | Stock | 0.2679 | 0.2712 | 0.2667 | 0.2712 | 52998400.0 |
| 2000-12-08 14:00:00 | AAPL | Stock | 0.2712 | 0.2734 | 0.2656 | 0.2667 | 65721600.0 |
| 2000-12-08 15:00:00 | AAPL | Stock | 0.2656 | 0.2734 | 0.2645 | 0.269 | 72665600.0 |
| 2000-12-08 16:00:00 | AAPL | Stock | 0.2701 | 0.2701 | 0.26 | 0.269 | 12532800.0 |
| 2000-12-08 17:00:00 | AAPL | Stock | 0.269 | 0.2695 | 0.2634 | 0.2634 | 2609600.0 |
| 2000-12-08 18:00:00 | AAPL | Stock | 0.2623 | 0.2667 | 0.2595 | 0.2623 | 117600.0 |
| 2000-12-08 08:00:00 | MSFT | Stock | 26.875 | 27.625 | 26.5625 | 27.625 | 1082000.0 |
| 2000-12-08 09:00:00 | MSFT | Stock | 27.5 | 27.5 | 26.7188 | 27.0625 | 14644400.0 |
| 2000-12-08 10:00:00 | MSFT | Stock | 27.0625 | 27.0938 | 26.7812 | 26.9062 | 22767200.0 |
| 2000-12-08 11:00:00 | MSFT | Stock | 26.9375 | 27.1406 | 26.8125 | 26.9062 | 11830600.0 |
| 2000-12-08 12:00:00 | MSFT | Stock | 26.9375 | 27.4688 | 26.9062 | 27.4062 | 16693400.0 |
| 2000-12-08 13:00:00 | MSFT | Stock | 27.4062 | 27.4375 | 27.1875 | 27.3438 | 10597600.0 |
| 2000-12-08 14:00:00 | MSFT | Stock | 27.375 | 27.9375 | 27.0625 | 27.1875 | 19549400.0 |
| 2000-12-08 15:00:00 | MSFT | Stock | 27.1875 | 27.3125 | 26.8906 | 27.2188 | 12172200.0 |
| 2000-12-08 16:00:00 | MSFT | Stock | 27.2188 | 27.25 | 25.875 | 26.375 | 3464400.0 |
| 2000-12-08 17:00:00 | MSFT | Stock | 26.3125 | 27.2188 | 26.0 | 26.3125 | 211200.0 |
| 2000-12-08 18:00:00 | MSFT | Stock | 26.3438 | 26.375 | 26.25 | 26.3438 | 48600.0 |
| 2000-12-08 08:00:00 | NVDA | Stock | 0.168 | 0.1771 | 0.168 | 0.1771 | 3624000.0 |
| 2000-12-08 09:00:00 | NVDA | Stock | 0.1792 | 0.188 | 0.1688 | 0.1742 | 113904000.0 |
| 2000-12-08 10:00:00 | NVDA | Stock | 0.174 | 0.1844 | 0.1721 | 0.1826 | 106344000.0 |
| 2000-12-08 11:00:00 | NVDA | Stock | 0.1818 | 0.1839 | 0.1755 | 0.1794 | 44232000.0 |
| 2000-12-08 12:00:00 | NVDA | Stock | 0.1794 | 0.1872 | 0.1792 | 0.1852 | 81504000.0 |
| 2000-12-08 13:00:00 | NVDA | Stock | 0.1859 | 0.1947 | 0.1841 | 0.1932 | 74688000.0 |
| 2000-12-08 14:00:00 | NVDA | Stock | 0.1938 | 0.2021 | 0.1909 | 0.2021 | 161616000.0 |
| 2000-12-08 15:00:00 | NVDA | Stock | 0.2021 | 0.2083 | 0.1995 | 0.207 | 183336000.0 |
| 2000-12-08 16:00:00 | NVDA | Stock | 0.2065 | 0.2073 | 0.1875 | 0.1938 | 12576000.0 |
| 2000-12-08 17:00:00 | NVDA | Stock | 0.1938 | 0.1943 | 0.1938 | 0.1943 | 696000.0 |
| 2000-12-08 18:00:00 | NVDA | Stock | 0.1938 | 0.1938 | 0.1938 | 0.1938 | 288000.0 |
| 2000-12-08 08:00:00 | AMZN | Stock | 1.1375 | 1.2062 | 1.125 | 1.15 | 1652000.0 |
| 2000-12-08 09:00:00 | AMZN | Stock | 1.1562 | 1.225 | 1.1 | 1.1469 | 42620000.0 |
| 2000-12-08 10:00:00 | AMZN | Stock | 1.1469 | 1.1531 | 1.1188 | 1.1219 | 26120000.0 |
| 2000-12-08 11:00:00 | AMZN | Stock | 1.1219 | 1.125 | 1.0625 | 1.0906 | 28696000.0 |
| 2000-12-08 12:00:00 | AMZN | Stock | 1.0938 | 1.1594 | 1.0906 | 1.1375 | 26280000.0 |
| 2000-12-08 13:00:00 | AMZN | Stock | 1.1375 | 1.2062 | 1.1344 | 1.2062 | 31644000.0 |
| 2000-12-08 14:00:00 | AMZN | Stock | 1.2062 | 1.2344 | 1.1312 | 1.1375 | 44276000.0 |
| 2000-12-08 15:00:00 | AMZN | Stock | 1.1344 | 1.1906 | 1.125 | 1.1688 | 32192000.0 |
| 2000-12-08 16:00:00 | AMZN | Stock | 1.1703 | 1.1844 | 1.1156 | 1.125 | 5354000.0 |
| 2000-12-08 17:00:00 | AMZN | Stock | 1.125 | 1.1625 | 1.1188 | 1.1281 | 428000.0 |
| 2000-12-08 18:00:00 | AMZN | Stock | 1.1312 | 1.1344 | 1.1281 | 1.1344 | 14000.0 |
| 2000-12-08 09:00:00 | CL | Stock | 29.5 | 29.5 | 29.095 | 29.175 | 374400.0 |
| 2000-12-08 10:00:00 | CL | Stock | 29.175 | 29.21 | 28.875 | 28.965 | 470400.0 |
| 2000-12-08 11:00:00 | CL | Stock | 28.975 | 29.7 | 28.965 | 29.695 | 375600.0 |
| 2000-12-08 12:00:00 | CL | Stock | 29.69 | 29.825 | 29.625 | 29.655 | 231600.0 |
| 2000-12-08 13:00:00 | CL | Stock | 29.655 | 29.655 | 29.49 | 29.65 | 258600.0 |
| 2000-12-08 14:00:00 | CL | Stock | 29.625 | 29.675 | 29.425 | 29.435 | 381200.0 |
> showing 50 of 16,874 rows — these rows as CSV