PREVIEW / stock_daily / 2004-03-09
file: by_date/stock_daily/2004/2004-03-09.parquet size: 125 KB rows: 3,664 symbols: 2,284
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-09 | AAPL | Stock | 0.4625 | 0.4863 | 0.4598 | 0.4839 | 618363200.0 |
| 2004-03-09 | MSFT | Stock | 25.8 | 25.97 | 25.54 | 25.72 | 81111700.0 |
| 2004-03-09 | NVDA | Stock | 0.18 | 0.1802 | 0.1742 | 0.1772 | 371232000.0 |
| 2004-03-09 | AMZN | Stock | 2.171 | 2.1945 | 2.1135 | 2.1355 | 131862000.0 |
| 2004-03-09 | CL | Stock | 28.15 | 28.32 | 28.01 | 28.13 | 3379000.0 |
| 2004-03-09 | A | Stock | 24.578 | 24.578 | 23.4263 | 23.4835 | 5951566.0 |
| 2004-03-09 | AABA-DELISTED | Stock | 21.9349994659424 | 22.1399993896484 | 21.4549999237061 | 21.6749992370605 | 20994200.0 |
| 2004-03-09 | AACC-DELISTED | Stock | 17.5 | 17.65 | 17.45 | 17.6 | 278857.0 |
| 2004-03-09 | AAI-DELISTED | Stock | 12.31 | 12.31 | 11.11 | 11.61 | 2013600.0 |
| 2004-03-09 | AAIC-DELISTED | Stock | 556.0 | 556.6 | 541.0 | 545.8 | 843900.0 |
| 2004-03-09 | AAME | Stock | 3.6 | 3.6 | 2.8 | 3.12 | 62200.0 |
| 2004-03-09 | AAON | Stock | 2.6733 | 2.693 | 2.6443 | 2.668 | 115425.0 |
| 2004-03-09 | AAP | Stock | 27.66 | 27.7267 | 27.3933 | 27.4867 | 813000.0 |
| 2004-03-09 | AAXN-DELISTED | Stock | 14.2775001525879 | 15.0275001525879 | 13.6499996185303 | 13.7375001907349 | 39364000.0 |
| 2004-03-09 | ABAX-DELISTED | Stock | 18.22 | 18.97 | 18.19 | 18.7 | 103232.0 |
| 2004-03-09 | ABB-DELISTED | Stock | 6.05 | 6.05 | 5.92 | 5.94 | 248600.0 |
| 2004-03-09 | ABC-DELISTED | Stock | 14.33 | 14.4 | 14.16 | 14.22 | 1941918.0 |
| 2004-03-09 | ABCB | Stock | 15.5218 | 15.619 | 15.4001 | 15.5055 | 19863.0 |
| 2004-03-09 | ABCO-DELISTED | Stock | 17.55 | 17.64 | 16.975 | 17.505 | 324108.0 |
| 2004-03-09 | ABCW-DELISTED | Stock | 25.6 | 25.78 | 25.38 | 25.65 | 20300.0 |
| 2004-03-09 | ABE-DELISTED | Stock | 8.3 | 8.39 | 8.17 | 8.2 | 19400.0 |
| 2004-03-09 | ABFS-DELISTED | Stock | 27.25 | 27.63 | 27.25 | 27.34 | 177937.0 |
| 2004-03-09 | ABG | Stock | 16.9 | 17.25 | 16.89 | 17.25 | 83300.0 |
| 2004-03-09 | ABK-DELISTED | Stock | 77.97 | 77.97 | 76.6 | 76.77 | 330400.0 |
| 2004-03-09 | ABM | Stock | 17.75 | 18.36 | 17.73 | 18.02 | 108300.0 |
| 2004-03-09 | ABMD-DELISTED | Stock | 7.48 | 7.58 | 7.17 | 7.48 | 32472.0 |
| 2004-03-09 | ABP-DELISTED | Stock | 3.14 | 3.37 | 3.11 | 3.18 | 837800.0 |
| 2004-03-09 | ABT | Stock | 19.3027 | 19.4509 | 18.9481 | 19.0334 | 9388932.0 |
| 2004-03-09 | ABTL-DELISTED | Stock | 64.75 | 66.6 | 64.15 | 65.4 | 75200.0 |
| 2004-03-09 | ABV-DELISTED | Stock | 20.79 | 20.79 | 19.2 | 19.53 | 1374100.0 |
| 2004-03-09 | ABVA-DELISTED | Stock | 19.98 | 19.98 | 19.49 | 19.68 | 5800.0 |
| 2004-03-09 | ABVT-DELISTED | Stock | 41.0 | 45.0 | 41.0 | 45.0 | 2300.0 |
| 2004-03-09 | ABX-DELISTED | Stock | 21.56 | 21.74 | 21.34 | 21.58 | 1657100.0 |
| 2004-03-09 | ACAP-DELISTED | Stock | 22.0 | 22.2 | 21.14 | 21.25 | 89097.0 |
| 2004-03-09 | ACAS-DELISTED | Stock | 34.56 | 34.59 | 33.25 | 33.58 | 455815.0 |
| 2004-03-09 | ACAT-DELISTED | Stock | 26.17 | 26.78 | 25.91 | 25.91 | 19302.0 |
| 2004-03-09 | ACCL-DELISTED | Stock | 20.99 | 21.36 | 19.85 | 19.9 | 133288.0 |
| 2004-03-09 | ACE-DELISTED | Stock | 44.87 | 45.05 | 44.14 | 44.5 | 614600.0 |
| 2004-03-09 | ACF-DELISTED | Stock | 18.9 | 18.9 | 18.06 | 18.27 | 1089600.0 |
| 2004-03-09 | ACG-DELISTED | Stock | 8.64 | 8.69 | 8.63 | 8.69 | 361800.0 |
| 2004-03-09 | ACGL | Stock | 4.7778 | 4.7933 | 4.7389 | 4.7744 | 1494000.0 |
| 2004-03-09 | ACGN-DELISTED | Stock | 1337.3288 | 1337.3288 | 1280.6712 | 1314.6712 | 32000.0 |
| 2004-03-09 | ACH | Stock | 16.8333 | 16.8333 | 16.5 | 16.5333 | 135000.0 |
| 2004-03-09 | ACH-DELISTED | Stock | 19.889 | 19.889 | 19.051 | 19.261 | 954523.0 |
| 2004-03-09 | ACLS | Stock | 40.88 | 41.64 | 39.72 | 40.36 | 289775.0 |
| 2004-03-09 | ACO-DELISTED | Stock | 18.85 | 19.01 | 18.61 | 18.63 | 188900.0 |
| 2004-03-09 | ACPW-DELISTED | Stock | 16.0 | 17.2 | 15.85 | 16.0 | 49355.0 |
| 2004-03-09 | ACS-DELISTED | Stock | 51.7 | 51.75 | 50.68 | 50.99 | 1294700.0 |
| 2004-03-09 | ACTA-DELISTED | Stock | 8.4 | 8.8 | 8.2 | 8.2 | 1265600.0 |
| 2004-03-09 | ACTG | Stock | 6.59 | 6.59 | 6.27 | 6.49 | 54000.0 |
> showing 50 of 3,664 rows — these rows as CSV