PREVIEW / stock_1hour / 2001-02-08
file: by_date/stock_1hour/2001/2001-02-08.parquet size: 350 KB rows: 16,257 symbols: 1,271
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-08 08:00:00 | AAPL | Stock | 0.3739 | 0.3739 | 0.3683 | 0.3705 | 772800.0 |
| 2001-02-08 09:00:00 | AAPL | Stock | 0.3705 | 0.375 | 0.3661 | 0.3661 | 103880000.0 |
| 2001-02-08 10:00:00 | AAPL | Stock | 0.3661 | 0.3761 | 0.3661 | 0.3739 | 88295200.0 |
| 2001-02-08 11:00:00 | AAPL | Stock | 0.3728 | 0.375 | 0.3683 | 0.3722 | 84011200.0 |
| 2001-02-08 12:00:00 | AAPL | Stock | 0.3717 | 0.3739 | 0.3683 | 0.3705 | 121172800.0 |
| 2001-02-08 13:00:00 | AAPL | Stock | 0.37 | 0.3705 | 0.3605 | 0.3694 | 42392000.0 |
| 2001-02-08 14:00:00 | AAPL | Stock | 0.3683 | 0.3739 | 0.3683 | 0.3683 | 42980000.0 |
| 2001-02-08 15:00:00 | AAPL | Stock | 0.3694 | 0.3739 | 0.3672 | 0.37 | 70868000.0 |
| 2001-02-08 16:00:00 | AAPL | Stock | 0.3694 | 0.3728 | 0.3672 | 0.3683 | 46412800.0 |
| 2001-02-08 08:00:00 | MSFT | Stock | 32.3125 | 32.3438 | 31.75 | 31.8125 | 629600.0 |
| 2001-02-08 09:00:00 | MSFT | Stock | 31.8438 | 32.125 | 31.5312 | 31.7188 | 16822800.0 |
| 2001-02-08 10:00:00 | MSFT | Stock | 31.6875 | 32.0625 | 31.625 | 31.8438 | 12827000.0 |
| 2001-02-08 11:00:00 | MSFT | Stock | 31.8125 | 31.875 | 31.5938 | 31.6562 | 15018200.0 |
| 2001-02-08 12:00:00 | MSFT | Stock | 31.6875 | 31.875 | 31.5625 | 31.5938 | 7222400.0 |
| 2001-02-08 13:00:00 | MSFT | Stock | 31.6094 | 31.8125 | 31.5 | 31.5625 | 7319200.0 |
| 2001-02-08 14:00:00 | MSFT | Stock | 31.5938 | 31.5938 | 31.25 | 31.4062 | 8948200.0 |
| 2001-02-08 15:00:00 | MSFT | Stock | 31.375 | 31.4375 | 31.0 | 31.0625 | 14538000.0 |
| 2001-02-08 16:00:00 | MSFT | Stock | 31.0938 | 32.0 | 31.0625 | 31.125 | 2435600.0 |
| 2001-02-08 17:00:00 | MSFT | Stock | 31.1562 | 31.8125 | 31.0 | 31.125 | 23800.0 |
| 2001-02-08 18:00:00 | MSFT | Stock | 31.125 | 31.125 | 31.0 | 31.0 | 4600.0 |
| 2001-02-08 09:00:00 | NVDA | Stock | 0.1898 | 0.1932 | 0.187 | 0.1885 | 27768000.0 |
| 2001-02-08 10:00:00 | NVDA | Stock | 0.1887 | 0.1987 | 0.1885 | 0.1958 | 103848000.0 |
| 2001-02-08 11:00:00 | NVDA | Stock | 0.1958 | 0.1961 | 0.1909 | 0.1922 | 74640000.0 |
| 2001-02-08 12:00:00 | NVDA | Stock | 0.1924 | 0.193 | 0.188 | 0.188 | 28272000.0 |
| 2001-02-08 13:00:00 | NVDA | Stock | 0.1883 | 0.1924 | 0.188 | 0.1917 | 28224000.0 |
| 2001-02-08 14:00:00 | NVDA | Stock | 0.1924 | 0.1945 | 0.1906 | 0.1932 | 50352000.0 |
| 2001-02-08 15:00:00 | NVDA | Stock | 0.1924 | 0.1927 | 0.1852 | 0.1858 | 63528000.0 |
| 2001-02-08 16:00:00 | NVDA | Stock | 0.1859 | 0.1875 | 0.1857 | 0.1875 | 2592000.0 |
| 2001-02-08 08:00:00 | AMZN | Stock | 0.7625 | 0.7625 | 0.7531 | 0.7531 | 14000.0 |
| 2001-02-08 09:00:00 | AMZN | Stock | 0.7563 | 0.7875 | 0.7563 | 0.7719 | 13848000.0 |
| 2001-02-08 10:00:00 | AMZN | Stock | 0.775 | 0.7938 | 0.7688 | 0.7812 | 20704000.0 |
| 2001-02-08 11:00:00 | AMZN | Stock | 0.7812 | 0.7875 | 0.75 | 0.7594 | 17040000.0 |
| 2001-02-08 12:00:00 | AMZN | Stock | 0.7563 | 0.7656 | 0.7375 | 0.7375 | 8476000.0 |
| 2001-02-08 13:00:00 | AMZN | Stock | 0.7375 | 0.7469 | 0.7219 | 0.7375 | 14404000.0 |
| 2001-02-08 14:00:00 | AMZN | Stock | 0.7375 | 0.7438 | 0.7281 | 0.7313 | 9210000.0 |
| 2001-02-08 15:00:00 | AMZN | Stock | 0.7313 | 0.7344 | 0.7188 | 0.7188 | 17572000.0 |
| 2001-02-08 16:00:00 | AMZN | Stock | 0.7188 | 0.725 | 0.7125 | 0.7234 | 3276000.0 |
| 2001-02-08 17:00:00 | AMZN | Stock | 0.725 | 0.725 | 0.725 | 0.725 | 74000.0 |
| 2001-02-08 09:00:00 | CL | Stock | 29.8 | 29.81 | 29.41 | 29.595 | 724400.0 |
| 2001-02-08 10:00:00 | CL | Stock | 29.555 | 29.575 | 29.25 | 29.375 | 578000.0 |
| 2001-02-08 11:00:00 | CL | Stock | 29.375 | 29.85 | 29.375 | 29.85 | 501200.0 |
| 2001-02-08 12:00:00 | CL | Stock | 29.875 | 30.05 | 29.8 | 29.96 | 900400.0 |
| 2001-02-08 13:00:00 | CL | Stock | 29.96 | 29.975 | 29.875 | 29.9 | 434800.0 |
| 2001-02-08 14:00:00 | CL | Stock | 29.925 | 30.025 | 29.9 | 29.965 | 1227600.0 |
| 2001-02-08 15:00:00 | CL | Stock | 29.975 | 30.0 | 29.85 | 29.96 | 743400.0 |
| 2001-02-08 16:00:00 | CL | Stock | 29.955 | 29.955 | 29.955 | 29.955 | 47800.0 |
> showing 46 of 16,257 rows — these rows as CSV