PREVIEW / stock_1hour / 2004-12-06
file: by_date/stock_1hour/2004/2004-12-06.parquet size: 545 KB rows: 25,558 symbols: 1,887
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-06 08:00:00 | AAPL | Stock | 1.1355 | 1.1464 | 1.1289 | 1.1382 | 15906576.0 |
| 2004-12-06 09:00:00 | AAPL | Stock | 1.1382 | 1.1545 | 1.1221 | 1.1405 | 236908392.0 |
| 2004-12-06 10:00:00 | AAPL | Stock | 1.1407 | 1.1439 | 1.1241 | 1.1293 | 206008208.0 |
| 2004-12-06 11:00:00 | AAPL | Stock | 1.1293 | 1.1407 | 1.1245 | 1.137 | 111691496.0 |
| 2004-12-06 12:00:00 | AAPL | Stock | 1.137 | 1.1439 | 1.1348 | 1.1427 | 90940304.0 |
| 2004-12-06 13:00:00 | AAPL | Stock | 1.1427 | 1.1516 | 1.1427 | 1.1516 | 100254448.0 |
| 2004-12-06 14:00:00 | AAPL | Stock | 1.1516 | 1.1777 | 1.1509 | 1.1771 | 221228392.0 |
| 2004-12-06 15:00:00 | AAPL | Stock | 1.1771 | 1.1829 | 1.1679 | 1.1755 | 225987104.0 |
| 2004-12-06 16:00:00 | AAPL | Stock | 1.1759 | 1.1761 | 1.1616 | 1.1718 | 14436632.0 |
| 2004-12-06 17:00:00 | AAPL | Stock | 1.1721 | 1.1746 | 1.1679 | 1.1693 | 1995112.0 |
| 2004-12-06 18:00:00 | AAPL | Stock | 1.1704 | 1.1704 | 1.1691 | 1.17 | 242200.0 |
| 2004-12-06 08:00:00 | MSFT | Stock | 27.25 | 27.31 | 27.2 | 27.2 | 33961.0 |
| 2004-12-06 09:00:00 | MSFT | Stock | 27.22 | 27.251 | 27.07 | 27.24 | 8348684.0 |
| 2004-12-06 10:00:00 | MSFT | Stock | 27.24 | 27.34 | 27.19 | 27.282 | 9775772.0 |
| 2004-12-06 11:00:00 | MSFT | Stock | 27.29 | 27.34 | 27.26 | 27.33 | 6460228.0 |
| 2004-12-06 12:00:00 | MSFT | Stock | 27.33 | 27.331 | 27.24 | 27.271 | 5091121.0 |
| 2004-12-06 13:00:00 | MSFT | Stock | 27.28 | 27.39 | 27.26 | 27.37 | 6475434.0 |
| 2004-12-06 14:00:00 | MSFT | Stock | 27.372 | 27.42 | 27.33 | 27.41 | 7685571.0 |
| 2004-12-06 15:00:00 | MSFT | Stock | 27.42 | 27.44 | 27.33 | 27.33 | 9398800.0 |
| 2004-12-06 16:00:00 | MSFT | Stock | 27.33 | 27.361 | 27.28 | 27.32 | 603082.0 |
| 2004-12-06 17:00:00 | MSFT | Stock | 27.31 | 27.33 | 27.3 | 27.32 | 35006.0 |
| 2004-12-06 18:00:00 | MSFT | Stock | 27.32 | 27.32 | 27.32 | 27.32 | 6353.0 |
| 2004-12-06 08:00:00 | NVDA | Stock | 0.1743 | 0.1807 | 0.1737 | 0.1807 | 450000.0 |
| 2004-12-06 09:00:00 | NVDA | Stock | 0.1747 | 0.1747 | 0.1705 | 0.1727 | 67047960.0 |
| 2004-12-06 10:00:00 | NVDA | Stock | 0.1726 | 0.1735 | 0.1718 | 0.1728 | 82455600.0 |
| 2004-12-06 11:00:00 | NVDA | Stock | 0.1726 | 0.1754 | 0.1724 | 0.175 | 130940040.0 |
| 2004-12-06 12:00:00 | NVDA | Stock | 0.175 | 0.1779 | 0.175 | 0.1777 | 143174400.0 |
| 2004-12-06 13:00:00 | NVDA | Stock | 0.1777 | 0.1799 | 0.1776 | 0.1796 | 95463000.0 |
| 2004-12-06 14:00:00 | NVDA | Stock | 0.1796 | 0.1817 | 0.1794 | 0.1817 | 137817720.0 |
| 2004-12-06 15:00:00 | NVDA | Stock | 0.1816 | 0.1824 | 0.1807 | 0.1811 | 284917200.0 |
| 2004-12-06 16:00:00 | NVDA | Stock | 0.1811 | 0.1817 | 0.1807 | 0.1817 | 5699520.0 |
| 2004-12-06 17:00:00 | NVDA | Stock | 0.181 | 0.1823 | 0.181 | 0.1823 | 233760.0 |
| 2004-12-06 18:00:00 | NVDA | Stock | 0.1824 | 0.1825 | 0.1823 | 0.1825 | 261000.0 |
| 2004-12-06 08:00:00 | AMZN | Stock | 1.992 | 1.992 | 1.9875 | 1.9875 | 10000.0 |
| 2004-12-06 09:00:00 | AMZN | Stock | 1.993 | 1.9995 | 1.967 | 1.974 | 17663040.0 |
| 2004-12-06 10:00:00 | AMZN | Stock | 1.9735 | 1.9765 | 1.9575 | 1.9635 | 22304360.0 |
| 2004-12-06 11:00:00 | AMZN | Stock | 1.9635 | 1.9735 | 1.9617 | 1.9695 | 18535700.0 |
| 2004-12-06 12:00:00 | AMZN | Stock | 1.97 | 1.9765 | 1.965 | 1.9705 | 13249980.0 |
| 2004-12-06 13:00:00 | AMZN | Stock | 1.9705 | 1.9735 | 1.965 | 1.9695 | 10611380.0 |
| 2004-12-06 14:00:00 | AMZN | Stock | 1.9695 | 1.975 | 1.9655 | 1.9725 | 14612580.0 |
| 2004-12-06 15:00:00 | AMZN | Stock | 1.973 | 1.9755 | 1.9685 | 1.972 | 20049860.0 |
| 2004-12-06 16:00:00 | AMZN | Stock | 1.973 | 1.9745 | 1.9685 | 1.974 | 1667780.0 |
| 2004-12-06 17:00:00 | AMZN | Stock | 1.9745 | 1.99 | 1.9695 | 1.99 | 166800.0 |
| 2004-12-06 09:00:00 | CL | Stock | 23.425 | 23.45 | 23.125 | 23.215 | 583000.0 |
| 2004-12-06 10:00:00 | CL | Stock | 23.23 | 23.245 | 23.09 | 23.11 | 1087200.0 |
| 2004-12-06 11:00:00 | CL | Stock | 23.11 | 23.19 | 23.09 | 23.17 | 427200.0 |
| 2004-12-06 12:00:00 | CL | Stock | 23.17 | 23.205 | 23.115 | 23.125 | 689800.0 |
| 2004-12-06 13:00:00 | CL | Stock | 23.125 | 23.125 | 23.08 | 23.0965 | 577400.0 |
| 2004-12-06 14:00:00 | CL | Stock | 23.1 | 23.125 | 23.075 | 23.1 | 578200.0 |
| 2004-12-06 15:00:00 | CL | Stock | 23.1 | 23.155 | 23.065 | 23.145 | 758600.0 |
> showing 50 of 25,558 rows — these rows as CSV