PREVIEW / stock_1hour / 2004-12-29
file: by_date/stock_1hour/2004/2004-12-29.parquet size: 529 KB rows: 24,908 symbols: 1,911
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-12-29 08:00:00 | AAPL | Stock | 1.1434 | 1.1482 | 1.143 | 1.143 | 427840.0 |
| 2004-12-29 09:00:00 | AAPL | Stock | 1.1446 | 1.1514 | 1.1384 | 1.1466 | 76245568.0 |
| 2004-12-29 10:00:00 | AAPL | Stock | 1.1466 | 1.1604 | 1.1448 | 1.148 | 110908112.0 |
| 2004-12-29 11:00:00 | AAPL | Stock | 1.148 | 1.1516 | 1.1352 | 1.1389 | 70737856.0 |
| 2004-12-29 12:00:00 | AAPL | Stock | 1.1389 | 1.1455 | 1.1379 | 1.1404 | 37282952.0 |
| 2004-12-29 13:00:00 | AAPL | Stock | 1.1402 | 1.1507 | 1.1391 | 1.1482 | 44429672.0 |
| 2004-12-29 14:00:00 | AAPL | Stock | 1.148 | 1.1484 | 1.1414 | 1.1468 | 35173712.0 |
| 2004-12-29 15:00:00 | AAPL | Stock | 1.1468 | 1.1509 | 1.1445 | 1.1505 | 56617680.0 |
| 2004-12-29 16:00:00 | AAPL | Stock | 1.1507 | 1.1509 | 1.1464 | 1.1475 | 8757560.0 |
| 2004-12-29 17:00:00 | AAPL | Stock | 1.1479 | 1.1498 | 1.1479 | 1.1482 | 89600.0 |
| 2004-12-29 18:00:00 | AAPL | Stock | 1.1507 | 1.1507 | 1.15 | 1.15 | 139608.0 |
| 2004-12-29 08:00:00 | MSFT | Stock | 26.92 | 26.935 | 26.89 | 26.89 | 79850.0 |
| 2004-12-29 09:00:00 | MSFT | Stock | 26.89 | 26.95 | 26.83 | 26.91 | 4820104.0 |
| 2004-12-29 10:00:00 | MSFT | Stock | 26.91 | 27.0 | 26.91 | 26.95 | 7473489.0 |
| 2004-12-29 11:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.88 | 26.88 | 7290323.0 |
| 2004-12-29 12:00:00 | MSFT | Stock | 26.89 | 26.93 | 26.87 | 26.88 | 3823277.0 |
| 2004-12-29 13:00:00 | MSFT | Stock | 26.89 | 26.93 | 26.86 | 26.88 | 5374879.0 |
| 2004-12-29 14:00:00 | MSFT | Stock | 26.88 | 26.9 | 26.83 | 26.87 | 6090845.0 |
| 2004-12-29 15:00:00 | MSFT | Stock | 26.87 | 26.9002 | 26.82 | 26.89 | 7913070.0 |
| 2004-12-29 16:00:00 | MSFT | Stock | 26.89 | 26.92 | 26.89 | 26.9 | 4085160.0 |
| 2004-12-29 17:00:00 | MSFT | Stock | 26.9 | 26.905 | 26.84 | 26.88 | 10841.0 |
| 2004-12-29 18:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.84 | 26.88 | 49054.0 |
| 2004-12-29 08:00:00 | NVDA | Stock | 0.1892 | 0.1897 | 0.1892 | 0.1897 | 264000.0 |
| 2004-12-29 09:00:00 | NVDA | Stock | 0.1899 | 0.1921 | 0.1885 | 0.1912 | 53720520.0 |
| 2004-12-29 10:00:00 | NVDA | Stock | 0.1914 | 0.1929 | 0.1909 | 0.1923 | 67511040.0 |
| 2004-12-29 11:00:00 | NVDA | Stock | 0.1923 | 0.1936 | 0.1922 | 0.1923 | 62423880.0 |
| 2004-12-29 12:00:00 | NVDA | Stock | 0.1923 | 0.1927 | 0.1921 | 0.1923 | 19747080.0 |
| 2004-12-29 13:00:00 | NVDA | Stock | 0.1922 | 0.1926 | 0.1918 | 0.192 | 15698640.0 |
| 2004-12-29 14:00:00 | NVDA | Stock | 0.1919 | 0.1921 | 0.1909 | 0.1912 | 25336200.0 |
| 2004-12-29 15:00:00 | NVDA | Stock | 0.1912 | 0.1917 | 0.1909 | 0.1916 | 39076680.0 |
| 2004-12-29 16:00:00 | NVDA | Stock | 0.1916 | 0.1919 | 0.1912 | 0.1915 | 5980320.0 |
| 2004-12-29 17:00:00 | NVDA | Stock | 0.1914 | 0.1914 | 0.1914 | 0.1914 | 60000.0 |
| 2004-12-29 18:00:00 | NVDA | Stock | 0.1912 | 0.1912 | 0.1912 | 0.1912 | 296400.0 |
| 2004-12-29 08:00:00 | AMZN | Stock | 2.2465 | 2.2465 | 2.233 | 2.2365 | 317640.0 |
| 2004-12-29 09:00:00 | AMZN | Stock | 2.2385 | 2.2795 | 2.222 | 2.2715 | 55996500.0 |
| 2004-12-29 10:00:00 | AMZN | Stock | 2.2715 | 2.284 | 2.2535 | 2.2665 | 56852220.0 |
| 2004-12-29 11:00:00 | AMZN | Stock | 2.2662 | 2.274 | 2.26 | 2.2625 | 24913720.0 |
| 2004-12-29 12:00:00 | AMZN | Stock | 2.2615 | 2.2675 | 2.2555 | 2.2565 | 20055880.0 |
| 2004-12-29 13:00:00 | AMZN | Stock | 2.2565 | 2.264 | 2.256 | 2.2575 | 12233100.0 |
| 2004-12-29 14:00:00 | AMZN | Stock | 2.257 | 2.261 | 2.2435 | 2.2515 | 18651720.0 |
| 2004-12-29 15:00:00 | AMZN | Stock | 2.2515 | 2.253 | 2.236 | 2.24 | 38601800.0 |
| 2004-12-29 16:00:00 | AMZN | Stock | 2.241 | 2.244 | 2.2391 | 2.243 | 1975540.0 |
| 2004-12-29 17:00:00 | AMZN | Stock | 2.242 | 2.242 | 2.24 | 2.24 | 166060.0 |
| 2004-12-29 18:00:00 | AMZN | Stock | 2.243 | 2.2455 | 2.243 | 2.245 | 74000.0 |
| 2004-12-29 09:00:00 | CL | Stock | 25.21 | 25.225 | 25.11 | 25.11 | 289200.0 |
| 2004-12-29 10:00:00 | CL | Stock | 25.11 | 25.21 | 25.02 | 25.035 | 432200.0 |
| 2004-12-29 11:00:00 | CL | Stock | 25.03 | 25.14 | 25.02 | 25.055 | 509400.0 |
| 2004-12-29 12:00:00 | CL | Stock | 25.06 | 25.1 | 25.045 | 25.055 | 201200.0 |
| 2004-12-29 13:00:00 | CL | Stock | 25.055 | 25.09 | 25.045 | 25.065 | 242400.0 |
| 2004-12-29 14:00:00 | CL | Stock | 25.065 | 25.085 | 25.005 | 25.035 | 476600.0 |
> showing 50 of 24,908 rows — these rows as CSV