PREVIEW / stock_daily / 2009-01-05
file: by_date/stock_daily/2009/2009-01-05.parquet size: 179 KB rows: 5,757 symbols: 3,453
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-01-05 | AAPL | Stock | 3.3275 | 3.435 | 3.3111 | 3.3779 | 1181608400.0 |
| 2009-01-05 | MSFT | Stock | 20.2 | 20.67 | 20.06 | 20.52 | 61475200.0 |
| 2009-01-05 | NVDA | Stock | 0.2152 | 0.2268 | 0.2138 | 0.2218 | 705736000.0 |
| 2009-01-05 | AMZN | Stock | 2.7865 | 2.787 | 2.6515 | 2.703 | 190196000.0 |
| 2009-01-05 | TLT | Stock | 115.6 | 116.16 | 112.6 | 113.35 | 5395492.0 |
| 2009-01-05 | CL | Stock | 34.545 | 34.62 | 33.77 | 34.015 | 7160800.0 |
| 2009-01-05 | A | Stock | 11.5308 | 12.2246 | 11.4449 | 12.01 | 7171321.0 |
| 2009-01-05 | AABA-DELISTED | Stock | 12.71 | 13.01 | 12.39 | 12.84 | 11949369.0 |
| 2009-01-05 | AACC-DELISTED | Stock | 5.47 | 5.49 | 5.18 | 5.35 | 50536.0 |
| 2009-01-05 | AACG | Stock | 5.15 | 5.2 | 4.9 | 5.04 | 10800.0 |
| 2009-01-05 | AAI-DELISTED | Stock | 4.49 | 4.54 | 4.41 | 4.54 | 1751129.0 |
| 2009-01-05 | AAIC-DELISTED | Stock | 4.6 | 5.2 | 4.4 | 4.8 | 539359.0 |
| 2009-01-05 | AAON | Stock | 4.1126 | 4.1738 | 3.9506 | 4.1343 | 1887806.0 |
| 2009-01-05 | AAP | Stock | 33.89 | 34.13 | 33.37 | 33.68 | 969700.0 |
| 2009-01-05 | AATI-DELISTED | Stock | 2.93 | 3.0394 | 2.87 | 2.94 | 156450.0 |
| 2009-01-05 | AAU-DELISTED | Stock | 0.73 | 0.75 | 0.68 | 0.7208 | 132013.0 |
| 2009-01-05 | AAUAF-DELISTED | Stock | 0.73 | 0.75 | 0.68 | 0.7208 | 133613.0 |
| 2009-01-05 | AAV-DELISTED | Stock | 4.62 | 4.96 | 4.58 | 4.85 | 1106240.0 |
| 2009-01-05 | AAWW-DELISTED | Stock | 20.08 | 20.72 | 19.73 | 20.41 | 167644.0 |
| 2009-01-05 | AAXJ | Stock | 35.68 | 35.93 | 35.06 | 35.78 | 189136.0 |
| 2009-01-05 | AAXN-DELISTED | Stock | 5.69 | 5.75 | 5.45 | 5.57 | 1233940.0 |
| 2009-01-05 | AB | Stock | 21.25 | 22.18 | 21.19 | 22.03 | 654700.0 |
| 2009-01-05 | ABAX-DELISTED | Stock | 16.89 | 17.19 | 16.05 | 16.25 | 185461.0 |
| 2009-01-05 | ABB-DELISTED | Stock | 14.91 | 15.17 | 14.8 | 14.94 | 3591065.0 |
| 2009-01-05 | ABBC-DELISTED | Stock | 9.24 | 9.27 | 9.15 | 9.19 | 76800.0 |
| 2009-01-05 | ABBNY-DELISTED | Stock | 14.91 | 15.17 | 14.8 | 14.94 | 3685565.0 |
| 2009-01-05 | ABC-DELISTED | Stock | 17.77 | 18.2 | 17.6 | 18.15 | 3784360.0 |
| 2009-01-05 | ABCB | Stock | 11.1951 | 11.5064 | 10.699 | 11.4091 | 32078.0 |
| 2009-01-05 | ABCO-DELISTED | Stock | 11.27 | 11.435 | 10.93 | 11.21 | 262624.0 |
| 2009-01-05 | ABCW-DELISTED | Stock | 2.57 | 2.78 | 2.31 | 2.35 | 154810.0 |
| 2009-01-05 | ABD-DELISTED | Stock | 3.7999 | 3.9603 | 3.4088 | 3.9101 | 558850.0 |
| 2009-01-05 | ABE-DELISTED | Stock | 14.13 | 14.56 | 13.74 | 14.05 | 54596.0 |
| 2009-01-05 | ABEO | Stock | 1125.0 | 1125.0 | 1000.0 | 1000.0 | 3.0 |
| 2009-01-05 | ABFS-DELISTED | Stock | 31.13 | 31.24 | 29.01 | 29.65 | 535251.0 |
| 2009-01-05 | ABG | Stock | 4.72 | 4.8 | 4.29 | 4.49 | 521300.0 |
| 2009-01-05 | ABII-DELISTED | Stock | 69.8 | 69.95 | 67.81 | 69.47 | 11763.0 |
| 2009-01-05 | ABK-DELISTED | Stock | 1.44 | 1.63 | 1.44 | 1.5 | 13142604.0 |
| 2009-01-05 | ABM | Stock | 18.85 | 19.0 | 18.45 | 18.88 | 287300.0 |
| 2009-01-05 | ABMD-DELISTED | Stock | 16.4 | 16.53 | 15.75 | 16.0 | 250213.0 |
| 2009-01-05 | ABR | Stock | 3.11 | 3.48 | 3.11 | 3.42 | 262800.0 |
| 2009-01-05 | ABT | Stock | 25.5254 | 25.6597 | 24.9832 | 25.2567 | 13093372.0 |
| 2009-01-05 | ABTL-DELISTED | Stock | 2.6308 | 2.85 | 2.576 | 2.85 | 4378.0 |
| 2009-01-05 | ABV-DELISTED | Stock | 45.37 | 47.21 | 45.11 | 45.43 | 774894.0 |
| 2009-01-05 | ABVA-DELISTED | Stock | 2.28 | 2.28 | 1.38 | 1.38 | 352.0 |
| 2009-01-05 | ABVT-DELISTED | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 366.0 |
| 2009-01-05 | ABX-DELISTED | Stock | 34.38 | 35.25 | 33.87 | 34.35 | 16671662.0 |
| 2009-01-05 | ACAD | Stock | 1.15 | 1.2 | 1.02 | 1.2 | 97700.0 |
| 2009-01-05 | ACAP-DELISTED | Stock | 46.57 | 46.72 | 45.6 | 45.97 | 116267.0 |
| 2009-01-05 | ACAS-DELISTED | Stock | 3.94 | 5.39 | 3.68 | 5.18 | 12317934.0 |
| 2009-01-05 | ACAT-DELISTED | Stock | 5.21 | 5.27 | 4.94 | 5.24 | 58134.0 |
> showing 50 of 5,757 rows — these rows as CSV