PREVIEW / stock_daily / 2004-11-19
file: by_date/stock_daily/2004/2004-11-19.parquet size: 131 KB rows: 3,899 symbols: 2,437
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-11-19 | AAPL | Stock | 0.9909 | 1.0163 | 0.9732 | 0.9852 | 765279200.0 |
| 2004-11-19 | MSFT | Stock | 27.03 | 27.07 | 26.84 | 26.86 | 85808600.0 |
| 2004-11-19 | NVDA | Stock | 0.1692 | 0.1711 | 0.1567 | 0.158 | 2126052000.0 |
| 2004-11-19 | AMZN | Stock | 1.9575 | 1.972 | 1.9095 | 1.9275 | 228550000.0 |
| 2004-11-19 | CL | Stock | 23.45 | 23.45 | 23.025 | 23.11 | 6442400.0 |
| 2004-11-19 | A | Stock | 16.7668 | 16.7668 | 16.3948 | 16.5451 | 2884493.0 |
| 2004-11-19 | AABA-DELISTED | Stock | 37.2400016784668 | 37.4099998474121 | 35.9000015258789 | 36.1500015258789 | 15936600.0 |
| 2004-11-19 | AACC-DELISTED | Stock | 17.78 | 18.05 | 17.65 | 17.65 | 32679.0 |
| 2004-11-19 | AAI-DELISTED | Stock | 12.98 | 13.03 | 12.34 | 12.4 | 1213700.0 |
| 2004-11-19 | AAIC-DELISTED | Stock | 356.4 | 357.6 | 352.0 | 352.0 | 774400.0 |
| 2004-11-19 | AAME | Stock | 3.05 | 3.07 | 3.03 | 3.03 | 11200.0 |
| 2004-11-19 | AAON | Stock | 2.1254 | 2.1281 | 2.0596 | 2.0662 | 121500.0 |
| 2004-11-19 | AAP | Stock | 28.0333 | 28.1333 | 27.6533 | 27.6667 | 797250.0 |
| 2004-11-19 | AAV-DELISTED | Stock | 18.12 | 18.26 | 17.79 | 18.12 | 14900.0 |
| 2004-11-19 | AAXN-DELISTED | Stock | 27.6599998474121 | 28.375 | 25.6000003814697 | 26.0799999237061 | 35315600.0 |
| 2004-11-19 | ABAX-DELISTED | Stock | 12.43 | 12.78 | 12.43 | 12.56 | 40332.0 |
| 2004-11-19 | ABB-DELISTED | Stock | 6.1 | 6.12 | 6.02 | 6.03 | 259500.0 |
| 2004-11-19 | ABC-DELISTED | Stock | 14.55 | 14.6 | 14.29 | 14.34 | 3281200.0 |
| 2004-11-19 | ABCB | Stock | 17.0213 | 17.1752 | 16.8186 | 16.8591 | 15422.0 |
| 2004-11-19 | ABCO-DELISTED | Stock | 17.367 | 17.748 | 17.362 | 17.433 | 197961.0 |
| 2004-11-19 | ABCW-DELISTED | Stock | 28.38 | 28.69 | 28.15 | 28.15 | 58590.0 |
| 2004-11-19 | ABE-DELISTED | Stock | 9.15 | 9.15 | 9.06 | 9.07 | 25300.0 |
| 2004-11-19 | ABFS-DELISTED | Stock | 41.38 | 41.68 | 40.51 | 40.55 | 135042.0 |
| 2004-11-19 | ABG | Stock | 13.57 | 13.73 | 13.44 | 13.51 | 21900.0 |
| 2004-11-19 | ABK-DELISTED | Stock | 79.62 | 79.69 | 78.85 | 78.87 | 335400.0 |
| 2004-11-19 | ABM | Stock | 21.63 | 21.69 | 21.25 | 21.25 | 101700.0 |
| 2004-11-19 | ABMD-DELISTED | Stock | 16.3 | 16.5 | 15.62 | 15.85 | 210460.0 |
| 2004-11-19 | ABP-DELISTED | Stock | 2.45 | 2.55 | 2.45 | 2.53 | 116700.0 |
| 2004-11-19 | ABR | Stock | 21.7 | 21.85 | 21.6 | 21.75 | 71500.0 |
| 2004-11-19 | ABT | Stock | 20.6314 | 20.6506 | 20.4491 | 20.5114 | 9764902.0 |
| 2004-11-19 | ABTL-DELISTED | Stock | 34.3 | 37.05 | 34.3 | 35.7 | 81000.0 |
| 2004-11-19 | ABV-DELISTED | Stock | 24.6 | 24.7 | 24.42 | 24.51 | 356700.0 |
| 2004-11-19 | ABX-DELISTED | Stock | 24.37 | 25.0 | 24.36 | 24.82 | 5241600.0 |
| 2004-11-19 | ACAD | Stock | 7.0 | 7.05 | 6.52 | 6.68 | 14900.0 |
| 2004-11-19 | ACAP-DELISTED | Stock | 33.22 | 33.55 | 32.52 | 32.84 | 62351.0 |
| 2004-11-19 | ACAS-DELISTED | Stock | 31.59 | 31.6 | 31.15 | 31.3 | 622365.0 |
| 2004-11-19 | ACAT-DELISTED | Stock | 25.86 | 25.87 | 25.29 | 25.29 | 33560.0 |
| 2004-11-19 | ACC-DELISTED | Stock | 20.39 | 20.47 | 20.24 | 20.33 | 55855.0 |
| 2004-11-19 | ACCL-DELISTED | Stock | 6.24 | 6.52 | 6.22 | 6.25 | 98332.0 |
| 2004-11-19 | ACE-DELISTED | Stock | 38.94 | 39.05 | 38.83 | 38.99 | 1699000.0 |
| 2004-11-19 | ACF-DELISTED | Stock | 20.75 | 20.8 | 20.28 | 20.29 | 882300.0 |
| 2004-11-19 | ACFC-DELISTED | Stock | 69.85 | 70.1 | 68.06 | 68.52 | 6021.0 |
| 2004-11-19 | ACG-DELISTED | Stock | 8.17 | 8.18 | 8.12 | 8.14 | 426900.0 |
| 2004-11-19 | ACGL | Stock | 4.2622 | 4.3111 | 4.2622 | 4.3056 | 1044000.0 |
| 2004-11-19 | ACGN-DELISTED | Stock | 555.3288 | 566.6712 | 510.0 | 544.0 | 51200.0 |
| 2004-11-19 | ACH | Stock | 18.3333 | 18.3667 | 18.0467 | 18.0667 | 162900.0 |
| 2004-11-19 | ACH-DELISTED | Stock | 15.482 | 15.669 | 15.32 | 15.357 | 397731.0 |
| 2004-11-19 | ACLS | Stock | 28.52 | 28.76 | 27.76 | 28.0 | 261750.0 |
| 2004-11-19 | ACO-DELISTED | Stock | 19.65 | 19.84 | 19.39 | 19.39 | 123700.0 |
| 2004-11-19 | ACPW-DELISTED | Stock | 19.425 | 20.78 | 19.425 | 20.03 | 58553.0 |
> showing 50 of 3,899 rows — these rows as CSV