PREVIEW / stock_1hour / 2001-02-05
file: by_date/stock_1hour/2001/2001-02-05.parquet size: 350 KB rows: 16,031 symbols: 1,268
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-05 08:00:00 | AAPL | Stock | 0.3672 | 0.3672 | 0.3661 | 0.3661 | 11200.0 |
| 2001-02-05 09:00:00 | AAPL | Stock | 0.3661 | 0.3672 | 0.3594 | 0.3605 | 32793600.0 |
| 2001-02-05 10:00:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3538 | 0.3583 | 71377600.0 |
| 2001-02-05 11:00:00 | AAPL | Stock | 0.3583 | 0.3611 | 0.3571 | 0.3583 | 40124000.0 |
| 2001-02-05 12:00:00 | AAPL | Stock | 0.3583 | 0.3594 | 0.3538 | 0.3571 | 42168000.0 |
| 2001-02-05 13:00:00 | AAPL | Stock | 0.356 | 0.3583 | 0.3527 | 0.356 | 32256000.0 |
| 2001-02-05 14:00:00 | AAPL | Stock | 0.3549 | 0.365 | 0.3538 | 0.3627 | 53670400.0 |
| 2001-02-05 15:00:00 | AAPL | Stock | 0.3616 | 0.3672 | 0.3605 | 0.3605 | 37016000.0 |
| 2001-02-05 16:00:00 | AAPL | Stock | 0.3616 | 0.3622 | 0.3571 | 0.3605 | 3976000.0 |
| 2001-02-05 08:00:00 | MSFT | Stock | 30.4375 | 30.5 | 30.25 | 30.4688 | 71600.0 |
| 2001-02-05 09:00:00 | MSFT | Stock | 30.4688 | 30.625 | 30.11 | 30.3906 | 7122600.0 |
| 2001-02-05 10:00:00 | MSFT | Stock | 30.4062 | 30.875 | 30.375 | 30.5938 | 9915200.0 |
| 2001-02-05 11:00:00 | MSFT | Stock | 30.5938 | 30.7812 | 30.4062 | 30.4688 | 7146000.0 |
| 2001-02-05 12:00:00 | MSFT | Stock | 30.4375 | 30.625 | 30.375 | 30.4688 | 3108400.0 |
| 2001-02-05 13:00:00 | MSFT | Stock | 30.4375 | 30.5625 | 30.1562 | 30.4375 | 10435200.0 |
| 2001-02-05 14:00:00 | MSFT | Stock | 30.4688 | 30.8438 | 30.4375 | 30.7812 | 6714000.0 |
| 2001-02-05 15:00:00 | MSFT | Stock | 30.7812 | 31.0312 | 30.6875 | 30.9688 | 8849200.0 |
| 2001-02-05 16:00:00 | MSFT | Stock | 31.0 | 31.1094 | 30.5781 | 31.0938 | 1460000.0 |
| 2001-02-05 17:00:00 | MSFT | Stock | 31.0 | 31.0625 | 30.9375 | 30.9375 | 66600.0 |
| 2001-02-05 18:00:00 | MSFT | Stock | 31.0625 | 31.0625 | 31.0625 | 31.0625 | 200.0 |
| 2001-02-05 08:00:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 96000.0 |
| 2001-02-05 09:00:00 | NVDA | Stock | 0.1948 | 0.1951 | 0.1833 | 0.1885 | 91224000.0 |
| 2001-02-05 10:00:00 | NVDA | Stock | 0.1891 | 0.1953 | 0.1875 | 0.1924 | 71448000.0 |
| 2001-02-05 11:00:00 | NVDA | Stock | 0.193 | 0.1935 | 0.1857 | 0.187 | 35832000.0 |
| 2001-02-05 12:00:00 | NVDA | Stock | 0.187 | 0.1875 | 0.1857 | 0.1857 | 19560000.0 |
| 2001-02-05 13:00:00 | NVDA | Stock | 0.1857 | 0.1859 | 0.1833 | 0.1844 | 47736000.0 |
| 2001-02-05 14:00:00 | NVDA | Stock | 0.1844 | 0.1906 | 0.1841 | 0.1891 | 39360000.0 |
| 2001-02-05 15:00:00 | NVDA | Stock | 0.1891 | 0.1964 | 0.1875 | 0.1956 | 54888000.0 |
| 2001-02-05 16:00:00 | NVDA | Stock | 0.1956 | 0.1979 | 0.1951 | 0.1956 | 11712000.0 |
| 2001-02-05 08:00:00 | AMZN | Stock | 0.7313 | 0.7688 | 0.7 | 0.708 | 534000.0 |
| 2001-02-05 09:00:00 | AMZN | Stock | 0.725 | 0.7406 | 0.707 | 0.7188 | 32852000.0 |
| 2001-02-05 10:00:00 | AMZN | Stock | 0.7203 | 0.7469 | 0.7188 | 0.7219 | 38674000.0 |
| 2001-02-05 11:00:00 | AMZN | Stock | 0.7219 | 0.7375 | 0.7219 | 0.7344 | 29804000.0 |
| 2001-02-05 12:00:00 | AMZN | Stock | 0.7313 | 0.7344 | 0.7281 | 0.7313 | 12352000.0 |
| 2001-02-05 13:00:00 | AMZN | Stock | 0.7313 | 0.7344 | 0.7219 | 0.725 | 18150000.0 |
| 2001-02-05 14:00:00 | AMZN | Stock | 0.725 | 0.7313 | 0.7219 | 0.725 | 19666000.0 |
| 2001-02-05 15:00:00 | AMZN | Stock | 0.725 | 0.7344 | 0.7219 | 0.725 | 23082000.0 |
| 2001-02-05 16:00:00 | AMZN | Stock | 0.7281 | 0.7313 | 0.7203 | 0.7219 | 4150000.0 |
| 2001-02-05 17:00:00 | AMZN | Stock | 0.7281 | 0.7281 | 0.7219 | 0.725 | 62000.0 |
| 2001-02-05 18:00:00 | AMZN | Stock | 0.7219 | 0.725 | 0.7219 | 0.725 | 26000.0 |
| 2001-02-05 09:00:00 | CL | Stock | 30.4 | 30.575 | 30.3 | 30.57 | 252800.0 |
| 2001-02-05 10:00:00 | CL | Stock | 30.57 | 30.725 | 30.425 | 30.5 | 631400.0 |
| 2001-02-05 11:00:00 | CL | Stock | 30.47 | 30.55 | 30.3 | 30.475 | 348200.0 |
| 2001-02-05 12:00:00 | CL | Stock | 30.435 | 30.5 | 30.305 | 30.445 | 167200.0 |
| 2001-02-05 13:00:00 | CL | Stock | 30.445 | 30.5 | 30.225 | 30.35 | 335800.0 |
| 2001-02-05 14:00:00 | CL | Stock | 30.35 | 30.425 | 30.15 | 30.25 | 383400.0 |
| 2001-02-05 15:00:00 | CL | Stock | 30.25 | 30.34 | 29.85 | 29.95 | 848400.0 |
| 2001-02-05 16:00:00 | CL | Stock | 29.925 | 30.32 | 29.925 | 30.32 | 477800.0 |
| 2001-02-05 17:00:00 | CL | Stock | 29.925 | 29.925 | 29.925 | 29.925 | 40000.0 |
> showing 49 of 16,031 rows — these rows as CSV