PREVIEW / stock_1hour / 2004-02-12
file: by_date/stock_1hour/2004/2004-02-12.parquet size: 513 KB rows: 23,485 symbols: 1,715
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-12 08:00:00 | AAPL | Stock | 0.425 | 0.4266 | 0.425 | 0.4266 | 89600.0 |
| 2004-02-12 09:00:00 | AAPL | Stock | 0.4263 | 0.4263 | 0.4214 | 0.4243 | 31479672.0 |
| 2004-02-12 10:00:00 | AAPL | Stock | 0.4245 | 0.4284 | 0.4245 | 0.4266 | 37111256.0 |
| 2004-02-12 11:00:00 | AAPL | Stock | 0.4268 | 0.4273 | 0.4245 | 0.425 | 20244504.0 |
| 2004-02-12 12:00:00 | AAPL | Stock | 0.425 | 0.4263 | 0.4239 | 0.4246 | 16955512.0 |
| 2004-02-12 13:00:00 | AAPL | Stock | 0.4248 | 0.427 | 0.4245 | 0.4263 | 19825736.0 |
| 2004-02-12 14:00:00 | AAPL | Stock | 0.4263 | 0.4275 | 0.4254 | 0.4273 | 17855488.0 |
| 2004-02-12 15:00:00 | AAPL | Stock | 0.4273 | 0.4273 | 0.4241 | 0.4243 | 34244952.0 |
| 2004-02-12 16:00:00 | AAPL | Stock | 0.4243 | 0.4257 | 0.4225 | 0.4238 | 2006872.0 |
| 2004-02-12 17:00:00 | AAPL | Stock | 0.4259 | 0.4259 | 0.4259 | 0.4259 | 22400.0 |
| 2004-02-12 18:00:00 | AAPL | Stock | 0.4266 | 0.4266 | 0.4266 | 0.4266 | 16800.0 |
| 2004-02-12 08:00:00 | MSFT | Stock | 27.2 | 27.25 | 27.08 | 27.15 | 33041.0 |
| 2004-02-12 09:00:00 | MSFT | Stock | 27.13 | 27.16 | 26.98 | 27.05 | 4122050.0 |
| 2004-02-12 10:00:00 | MSFT | Stock | 27.05 | 27.07 | 26.93 | 26.96 | 8665015.0 |
| 2004-02-12 11:00:00 | MSFT | Stock | 26.95 | 27.03 | 26.94 | 27.0 | 6185527.0 |
| 2004-02-12 12:00:00 | MSFT | Stock | 27.0 | 27.04 | 26.95 | 26.98 | 3977470.0 |
| 2004-02-12 13:00:00 | MSFT | Stock | 26.98 | 27.01 | 26.94 | 26.94 | 4418756.0 |
| 2004-02-12 14:00:00 | MSFT | Stock | 26.94 | 27.02 | 26.93 | 26.97 | 4065149.0 |
| 2004-02-12 15:00:00 | MSFT | Stock | 26.98 | 27.01 | 26.93 | 26.96 | 10773381.0 |
| 2004-02-12 16:00:00 | MSFT | Stock | 26.97 | 27.03 | 26.86 | 26.96 | 1122246.0 |
| 2004-02-12 17:00:00 | MSFT | Stock | 26.9 | 26.96 | 26.9 | 26.95 | 236417.0 |
| 2004-02-12 18:00:00 | MSFT | Stock | 26.94 | 26.98 | 26.94 | 26.98 | 27241.0 |
| 2004-02-12 08:00:00 | NVDA | Stock | 0.2014 | 0.2014 | 0.2 | 0.2012 | 252000.0 |
| 2004-02-12 09:00:00 | NVDA | Stock | 0.2012 | 0.2021 | 0.1975 | 0.1995 | 102201240.0 |
| 2004-02-12 10:00:00 | NVDA | Stock | 0.1994 | 0.2008 | 0.1955 | 0.1956 | 112636080.0 |
| 2004-02-12 11:00:00 | NVDA | Stock | 0.1956 | 0.1967 | 0.1929 | 0.1948 | 136693320.0 |
| 2004-02-12 12:00:00 | NVDA | Stock | 0.1949 | 0.1953 | 0.1931 | 0.1937 | 99203160.0 |
| 2004-02-12 13:00:00 | NVDA | Stock | 0.1936 | 0.195 | 0.1933 | 0.1942 | 57602160.0 |
| 2004-02-12 14:00:00 | NVDA | Stock | 0.1942 | 0.1948 | 0.1936 | 0.1947 | 63336480.0 |
| 2004-02-12 15:00:00 | NVDA | Stock | 0.1947 | 0.1969 | 0.1942 | 0.196 | 213043560.0 |
| 2004-02-12 16:00:00 | NVDA | Stock | 0.196 | 0.1964 | 0.1776 | 0.1905 | 96033240.0 |
| 2004-02-12 17:00:00 | NVDA | Stock | 0.19 | 0.1932 | 0.1812 | 0.1831 | 63576840.0 |
| 2004-02-12 18:00:00 | NVDA | Stock | 0.1832 | 0.1845 | 0.1825 | 0.1827 | 4632840.0 |
| 2004-02-12 08:00:00 | AMZN | Stock | 2.3568 | 2.36 | 2.35 | 2.35 | 454000.0 |
| 2004-02-12 09:00:00 | AMZN | Stock | 2.3525 | 2.3725 | 2.3425 | 2.369 | 14412220.0 |
| 2004-02-12 10:00:00 | AMZN | Stock | 2.3685 | 2.405 | 2.3655 | 2.391 | 39439580.0 |
| 2004-02-12 11:00:00 | AMZN | Stock | 2.391 | 2.3925 | 2.3755 | 2.38 | 18537020.0 |
| 2004-02-12 12:00:00 | AMZN | Stock | 2.38 | 2.381 | 2.3625 | 2.3665 | 13316560.0 |
| 2004-02-12 13:00:00 | AMZN | Stock | 2.3655 | 2.368 | 2.357 | 2.3645 | 9433580.0 |
| 2004-02-12 14:00:00 | AMZN | Stock | 2.3644 | 2.3665 | 2.354 | 2.356 | 7607060.0 |
| 2004-02-12 15:00:00 | AMZN | Stock | 2.355 | 2.365 | 2.3355 | 2.3535 | 26013360.0 |
| 2004-02-12 16:00:00 | AMZN | Stock | 2.353 | 2.354 | 2.347 | 2.354 | 330920.0 |
| 2004-02-12 17:00:00 | AMZN | Stock | 2.356 | 2.357 | 2.3501 | 2.354 | 55320.0 |
| 2004-02-12 18:00:00 | AMZN | Stock | 2.353 | 2.353 | 2.3506 | 2.3506 | 5640.0 |
| 2004-02-12 09:00:00 | CL | Stock | 27.515 | 27.625 | 27.51 | 27.555 | 301600.0 |
| 2004-02-12 10:00:00 | CL | Stock | 27.56 | 27.575 | 27.5 | 27.5 | 358200.0 |
| 2004-02-12 11:00:00 | CL | Stock | 27.505 | 27.58 | 27.5 | 27.55 | 311600.0 |
| 2004-02-12 12:00:00 | CL | Stock | 27.555 | 27.59 | 27.55 | 27.565 | 220600.0 |
| 2004-02-12 13:00:00 | CL | Stock | 27.57 | 27.62 | 27.565 | 27.6 | 289400.0 |
| 2004-02-12 14:00:00 | CL | Stock | 27.6 | 27.61 | 27.535 | 27.555 | 249400.0 |
> showing 50 of 23,485 rows — these rows as CSV