PREVIEW / stock_daily / 2004-09-03
file: by_date/stock_daily/2004/2004-09-03.parquet size: 125 KB rows: 3,757 symbols: 2,328
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-09-03 | AAPL | Stock | 0.6252 | 0.6414 | 0.6252 | 0.6291 | 293468000.0 |
| 2004-09-03 | MSFT | Stock | 27.46 | 27.62 | 27.1 | 27.11 | 46174400.0 |
| 2004-09-03 | NVDA | Stock | 0.1068 | 0.109 | 0.1059 | 0.1068 | 715056000.0 |
| 2004-09-03 | AMZN | Stock | 1.9505 | 2.0005 | 1.932 | 1.937 | 104578000.0 |
| 2004-09-03 | CL | Stock | 27.44 | 27.625 | 27.39 | 27.425 | 1896400.0 |
| 2004-09-03 | A | Stock | 15.1288 | 15.1359 | 14.485 | 14.5708 | 2775869.0 |
| 2004-09-03 | AABA-DELISTED | Stock | 29.75 | 30.3099994659424 | 29.2700004577637 | 29.4599990844727 | 12782700.0 |
| 2004-09-03 | AACC-DELISTED | Stock | 17.74 | 18.05 | 17.22 | 17.25 | 9633.0 |
| 2004-09-03 | AAI-DELISTED | Stock | 12.22 | 12.3 | 11.91 | 11.96 | 1674000.0 |
| 2004-09-03 | AAIC-DELISTED | Stock | 378.8 | 380.4 | 375.8 | 376.4 | 1478100.0 |
| 2004-09-03 | AAME | Stock | 3.0 | 3.0 | 2.97 | 3.0 | 15800.0 |
| 2004-09-03 | AAON | Stock | 2.3625 | 2.3691 | 2.2387 | 2.2387 | 50119.0 |
| 2004-09-03 | AAP | Stock | 24.74 | 25.0267 | 24.66 | 24.9667 | 814800.0 |
| 2004-09-03 | AAV-DELISTED | Stock | 15.18 | 15.35 | 15.0 | 15.18 | 21800.0 |
| 2004-09-03 | AAXN-DELISTED | Stock | 16.2800006866455 | 16.9899997711182 | 15.7799997329712 | 15.875 | 29326200.0 |
| 2004-09-03 | ABAX-DELISTED | Stock | 15.29 | 15.32 | 14.98 | 15.01 | 50433.0 |
| 2004-09-03 | ABB-DELISTED | Stock | 5.75 | 5.77 | 5.7 | 5.74 | 93800.0 |
| 2004-09-03 | ABC-DELISTED | Stock | 14.14 | 14.2 | 14.0 | 14.07 | 1752400.0 |
| 2004-09-03 | ABCB | Stock | 14.6788 | 14.9382 | 14.387 | 14.5815 | 7032.0 |
| 2004-09-03 | ABCO-DELISTED | Stock | 16.185 | 16.405 | 16.0 | 16.03 | 270230.0 |
| 2004-09-03 | ABCW-DELISTED | Stock | 25.99 | 26.0 | 25.53 | 25.74 | 15650.0 |
| 2004-09-03 | ABE-DELISTED | Stock | 7.65 | 7.89 | 7.65 | 7.88 | 32900.0 |
| 2004-09-03 | ABFS-DELISTED | Stock | 35.34 | 36.16 | 35.01 | 35.97 | 317162.0 |
| 2004-09-03 | ABG | Stock | 13.81 | 14.09 | 13.56 | 13.94 | 15300.0 |
| 2004-09-03 | ABK-DELISTED | Stock | 76.35 | 76.89 | 75.86 | 76.5 | 324500.0 |
| 2004-09-03 | ABM | Stock | 18.6 | 18.94 | 18.51 | 18.68 | 70000.0 |
| 2004-09-03 | ABMD-DELISTED | Stock | 10.59 | 10.6 | 10.08 | 10.21 | 29693.0 |
| 2004-09-03 | ABP-DELISTED | Stock | 1.6 | 1.75 | 1.6 | 1.75 | 66000.0 |
| 2004-09-03 | ABR | Stock | 20.75 | 21.0 | 20.54 | 20.8 | 78900.0 |
| 2004-09-03 | ABT | Stock | 20.4731 | 20.6506 | 20.4491 | 20.4731 | 5971446.0 |
| 2004-09-03 | ABTL-DELISTED | Stock | 34.85 | 35.8 | 34.45 | 35.1 | 19400.0 |
| 2004-09-03 | ABV-DELISTED | Stock | 21.48 | 21.5 | 21.32 | 21.4 | 211300.0 |
| 2004-09-03 | ABVA-DELISTED | Stock | 14.64 | 14.85 | 14.57 | 14.61 | 3170.0 |
| 2004-09-03 | ABX-DELISTED | Stock | 19.79 | 19.94 | 19.62 | 19.76 | 1013300.0 |
| 2004-09-03 | ACAD | Stock | 7.11 | 7.45 | 7.11 | 7.45 | 24300.0 |
| 2004-09-03 | ACAP-DELISTED | Stock | 27.82 | 28.92 | 27.6 | 28.54 | 104487.0 |
| 2004-09-03 | ACAS-DELISTED | Stock | 31.57 | 31.97 | 31.48 | 31.78 | 419991.0 |
| 2004-09-03 | ACAT-DELISTED | Stock | 26.81 | 26.9 | 26.34 | 26.55 | 28819.0 |
| 2004-09-03 | ACC-DELISTED | Stock | 17.94 | 18.1 | 17.88 | 18.02 | 29935.0 |
| 2004-09-03 | ACCL-DELISTED | Stock | 6.31 | 6.72 | 6.16 | 6.35 | 120105.0 |
| 2004-09-03 | ACE-DELISTED | Stock | 38.4 | 39.37 | 38.38 | 39.04 | 1189000.0 |
| 2004-09-03 | ACF-DELISTED | Stock | 20.71 | 21.1 | 20.43 | 20.51 | 723000.0 |
| 2004-09-03 | ACG-DELISTED | Stock | 8.1 | 8.11 | 8.04 | 8.07 | 372700.0 |
| 2004-09-03 | ACGL | Stock | 4.2744 | 4.3122 | 4.2444 | 4.2989 | 1597500.0 |
| 2004-09-03 | ACGN-DELISTED | Stock | 646.0 | 646.0 | 578.0 | 600.6712 | 76800.0 |
| 2004-09-03 | ACH | Stock | 17.0 | 17.06 | 16.5133 | 16.6067 | 151950.0 |
| 2004-09-03 | ACH-DELISTED | Stock | 12.25 | 12.3 | 12.14 | 12.185 | 204000.0 |
| 2004-09-03 | ACLS | Stock | 30.84 | 30.96 | 29.2 | 29.6 | 300175.0 |
| 2004-09-03 | ACO-DELISTED | Stock | 17.2 | 17.35 | 16.96 | 17.14 | 69900.0 |
| 2004-09-03 | ACPW-DELISTED | Stock | 14.7 | 14.95 | 13.5 | 13.95 | 10981.0 |
> showing 50 of 3,757 rows — these rows as CSV