PREVIEW / stock_1hour / 2004-12-30
file: by_date/stock_1hour/2004/2004-12-30.parquet size: 534 KB rows: 25,624 symbols: 1,903
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-30 08:00:00 | AAPL | Stock | 1.1557 | 1.1714 | 1.1554 | 1.1625 | 3093888.0 |
| 2004-12-30 09:00:00 | AAPL | Stock | 1.1623 | 1.1643 | 1.1502 | 1.153 | 63863632.0 |
| 2004-12-30 10:00:00 | AAPL | Stock | 1.1534 | 1.1568 | 1.1477 | 1.1482 | 88814600.0 |
| 2004-12-30 11:00:00 | AAPL | Stock | 1.1482 | 1.1534 | 1.1468 | 1.152 | 38457888.0 |
| 2004-12-30 12:00:00 | AAPL | Stock | 1.152 | 1.155 | 1.15 | 1.1534 | 22645560.0 |
| 2004-12-30 13:00:00 | AAPL | Stock | 1.153 | 1.1563 | 1.1507 | 1.155 | 22867320.0 |
| 2004-12-30 14:00:00 | AAPL | Stock | 1.1548 | 1.1589 | 1.1545 | 1.1571 | 39377016.0 |
| 2004-12-30 15:00:00 | AAPL | Stock | 1.1573 | 1.1596 | 1.1548 | 1.1573 | 53605832.0 |
| 2004-12-30 16:00:00 | AAPL | Stock | 1.1575 | 1.1577 | 1.1534 | 1.1557 | 8200416.0 |
| 2004-12-30 17:00:00 | AAPL | Stock | 1.1577 | 1.1577 | 1.1541 | 1.1541 | 1537872.0 |
| 2004-12-30 18:00:00 | AAPL | Stock | 1.1554 | 1.1555 | 1.1552 | 1.1554 | 120512.0 |
| 2004-12-30 08:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.88 | 26.89 | 12500.0 |
| 2004-12-30 09:00:00 | MSFT | Stock | 26.89 | 26.94 | 26.849 | 26.87 | 4739233.0 |
| 2004-12-30 10:00:00 | MSFT | Stock | 26.87 | 26.89 | 26.83 | 26.849 | 6511571.0 |
| 2004-12-30 11:00:00 | MSFT | Stock | 26.84 | 26.86 | 26.81 | 26.82 | 5320986.0 |
| 2004-12-30 12:00:00 | MSFT | Stock | 26.82 | 26.87 | 26.82 | 26.86 | 4477985.0 |
| 2004-12-30 13:00:00 | MSFT | Stock | 26.85 | 26.87 | 26.83 | 26.85 | 5585504.0 |
| 2004-12-30 14:00:00 | MSFT | Stock | 26.851 | 26.86 | 26.81 | 26.83 | 8758320.0 |
| 2004-12-30 15:00:00 | MSFT | Stock | 26.83 | 26.85 | 26.749 | 26.75 | 8234023.0 |
| 2004-12-30 16:00:00 | MSFT | Stock | 26.75 | 26.85 | 26.7 | 26.85 | 3373900.0 |
| 2004-12-30 17:00:00 | MSFT | Stock | 26.75 | 26.77 | 26.74 | 26.77 | 50167.0 |
| 2004-12-30 18:00:00 | MSFT | Stock | 26.76 | 26.77 | 26.76 | 26.77 | 1000.0 |
| 2004-12-30 09:00:00 | NVDA | Stock | 0.1908 | 0.1929 | 0.1902 | 0.1917 | 42424320.0 |
| 2004-12-30 10:00:00 | NVDA | Stock | 0.1917 | 0.1921 | 0.1912 | 0.1914 | 36792240.0 |
| 2004-12-30 11:00:00 | NVDA | Stock | 0.1914 | 0.1916 | 0.1904 | 0.1907 | 31966320.0 |
| 2004-12-30 12:00:00 | NVDA | Stock | 0.1907 | 0.1911 | 0.1897 | 0.1898 | 44245560.0 |
| 2004-12-30 13:00:00 | NVDA | Stock | 0.1898 | 0.1902 | 0.1897 | 0.19 | 31355880.0 |
| 2004-12-30 14:00:00 | NVDA | Stock | 0.19 | 0.1909 | 0.1898 | 0.1907 | 14837040.0 |
| 2004-12-30 15:00:00 | NVDA | Stock | 0.1907 | 0.1908 | 0.19 | 0.1904 | 45097080.0 |
| 2004-12-30 16:00:00 | NVDA | Stock | 0.1904 | 0.1907 | 0.1903 | 0.1906 | 8856000.0 |
| 2004-12-30 17:00:00 | NVDA | Stock | 0.1905 | 0.1905 | 0.1897 | 0.1905 | 250080.0 |
| 2004-12-30 18:00:00 | NVDA | Stock | 0.1905 | 0.1905 | 0.1905 | 0.1905 | 3120000.0 |
| 2004-12-30 08:00:00 | AMZN | Stock | 2.25 | 2.26 | 2.247 | 2.258 | 523200.0 |
| 2004-12-30 09:00:00 | AMZN | Stock | 2.2595 | 2.2765 | 2.2495 | 2.269 | 24986760.0 |
| 2004-12-30 10:00:00 | AMZN | Stock | 2.2685 | 2.272 | 2.244 | 2.248 | 33974520.0 |
| 2004-12-30 11:00:00 | AMZN | Stock | 2.2475 | 2.248 | 2.2275 | 2.241 | 28609440.0 |
| 2004-12-30 12:00:00 | AMZN | Stock | 2.241 | 2.245 | 2.238 | 2.244 | 7315960.0 |
| 2004-12-30 13:00:00 | AMZN | Stock | 2.244 | 2.254 | 2.2435 | 2.251 | 11842280.0 |
| 2004-12-30 14:00:00 | AMZN | Stock | 2.251 | 2.2525 | 2.243 | 2.25 | 11285720.0 |
| 2004-12-30 15:00:00 | AMZN | Stock | 2.251 | 2.253 | 2.2395 | 2.2485 | 17481820.0 |
| 2004-12-30 16:00:00 | AMZN | Stock | 2.247 | 2.2575 | 2.24 | 2.248 | 458060.0 |
| 2004-12-30 17:00:00 | AMZN | Stock | 2.2485 | 2.2505 | 2.242 | 2.2425 | 243400.0 |
| 2004-12-30 18:00:00 | AMZN | Stock | 2.242 | 2.242 | 2.241 | 2.241 | 18000.0 |
| 2004-12-30 09:00:00 | CL | Stock | 25.25 | 25.4 | 25.25 | 25.38 | 423200.0 |
| 2004-12-30 10:00:00 | CL | Stock | 25.385 | 25.5 | 25.375 | 25.415 | 790000.0 |
| 2004-12-30 11:00:00 | CL | Stock | 25.42 | 25.515 | 25.375 | 25.515 | 430000.0 |
| 2004-12-30 12:00:00 | CL | Stock | 25.515 | 25.61 | 25.515 | 25.575 | 551200.0 |
| 2004-12-30 13:00:00 | CL | Stock | 25.58 | 25.67 | 25.565 | 25.665 | 528600.0 |
| 2004-12-30 14:00:00 | CL | Stock | 25.67 | 25.735 | 25.665 | 25.71 | 592600.0 |
| 2004-12-30 15:00:00 | CL | Stock | 25.71 | 25.74 | 25.64 | 25.67 | 745400.0 |
> showing 50 of 25,624 rows — these rows as CSV