PREVIEW / stock_daily / 2004-04-20
file: by_date/stock_daily/2004/2004-04-20.parquet size: 125 KB rows: 3,698 symbols: 2,306
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-04-20 | AAPL | Stock | 0.5038 | 0.5073 | 0.4921 | 0.4952 | 354519200.0 |
| 2004-04-20 | MSFT | Stock | 25.65 | 25.88 | 25.28 | 25.33 | 59902600.0 |
| 2004-04-20 | NVDA | Stock | 0.197 | 0.1992 | 0.1881 | 0.1882 | 513804000.0 |
| 2004-04-20 | AMZN | Stock | 2.383 | 2.3905 | 2.259 | 2.26 | 187522000.0 |
| 2004-04-20 | CL | Stock | 28.225 | 28.495 | 28.175 | 28.305 | 4839200.0 |
| 2004-04-20 | A | Stock | 21.8526 | 21.8741 | 20.5579 | 20.5579 | 4013239.0 |
| 2004-04-20 | AABA-DELISTED | Stock | 27.9349994659424 | 27.9750003814697 | 26.75 | 26.7749996185303 | 20080800.0 |
| 2004-04-20 | AACC-DELISTED | Stock | 19.25 | 19.25 | 18.55 | 18.99 | 63285.0 |
| 2004-04-20 | AAI-DELISTED | Stock | 11.73 | 12.08 | 11.65 | 11.75 | 1198700.0 |
| 2004-04-20 | AAIC-DELISTED | Stock | 424.4 | 428.6 | 400.8 | 401.6 | 2524900.0 |
| 2004-04-20 | AAME | Stock | 2.87 | 2.92 | 2.86 | 2.92 | 2400.0 |
| 2004-04-20 | AAON | Stock | 2.5297 | 2.5534 | 2.5021 | 2.51 | 186047.0 |
| 2004-04-20 | AAP | Stock | 27.4333 | 28.7667 | 27.4333 | 28.1467 | 1414050.0 |
| 2004-04-20 | AAV-DELISTED | Stock | 14.55 | 14.7 | 14.53 | 14.55 | 93000.0 |
| 2004-04-20 | AAXN-DELISTED | Stock | 26.5375003814697 | 27.8575000762939 | 21.0200004577637 | 21.0974998474121 | 129608000.0 |
| 2004-04-20 | ABAX-DELISTED | Stock | 22.1 | 22.9 | 21.66 | 21.66 | 328990.0 |
| 2004-04-20 | ABB-DELISTED | Stock | 6.05 | 6.11 | 5.97 | 5.97 | 230500.0 |
| 2004-04-20 | ABC-DELISTED | Stock | 14.04 | 14.06 | 13.84 | 13.89 | 1965600.0 |
| 2004-04-20 | ABCB | Stock | 14.776 | 15.1976 | 14.5653 | 14.7436 | 13941.0 |
| 2004-04-20 | ABCO-DELISTED | Stock | 18.22 | 18.41 | 17.9 | 18.0 | 98014.0 |
| 2004-04-20 | ABCW-DELISTED | Stock | 24.43 | 24.94 | 24.32 | 24.47 | 44260.0 |
| 2004-04-20 | ABE-DELISTED | Stock | 8.3 | 8.42 | 8.3 | 8.3 | 6100.0 |
| 2004-04-20 | ABFS-DELISTED | Stock | 28.32 | 29.5 | 27.8 | 27.8 | 290655.0 |
| 2004-04-20 | ABG | Stock | 17.0 | 17.0 | 16.4 | 16.48 | 41300.0 |
| 2004-04-20 | ABK-DELISTED | Stock | 72.77 | 73.38 | 72.0 | 72.06 | 511100.0 |
| 2004-04-20 | ABM | Stock | 18.26 | 18.6 | 18.1 | 18.1 | 130400.0 |
| 2004-04-20 | ABMD-DELISTED | Stock | 11.52 | 12.45 | 11.35 | 12.19 | 551724.0 |
| 2004-04-20 | ABP-DELISTED | Stock | 2.77 | 2.78 | 2.56 | 2.69 | 139900.0 |
| 2004-04-20 | ABT | Stock | 19.8639 | 19.8863 | 19.406 | 19.406 | 9128296.0 |
| 2004-04-20 | ABTL-DELISTED | Stock | 67.75 | 68.75 | 62.15 | 63.1 | 157600.0 |
| 2004-04-20 | ABV-DELISTED | Stock | 18.25 | 18.36 | 17.72 | 17.81 | 547000.0 |
| 2004-04-20 | ABVA-DELISTED | Stock | 16.1 | 16.1 | 15.3 | 15.58 | 15153.0 |
| 2004-04-20 | ABVT-DELISTED | Stock | 36.0 | 38.5 | 36.0 | 38.5 | 3700.0 |
| 2004-04-20 | ABX-DELISTED | Stock | 21.22 | 21.23 | 20.7 | 20.73 | 2666621.0 |
| 2004-04-20 | ACAP-DELISTED | Stock | 21.43 | 21.59 | 21.05 | 21.1 | 28644.0 |
| 2004-04-20 | ACAS-DELISTED | Stock | 28.7 | 28.75 | 28.02 | 28.19 | 560604.0 |
| 2004-04-20 | ACAT-DELISTED | Stock | 26.61 | 27.5 | 25.54 | 25.54 | 38414.0 |
| 2004-04-20 | ACCL-DELISTED | Stock | 17.19 | 17.93 | 16.35 | 16.75 | 180215.0 |
| 2004-04-20 | ACE-DELISTED | Stock | 43.25 | 43.26 | 42.4 | 42.4 | 1247600.0 |
| 2004-04-20 | ACF-DELISTED | Stock | 17.55 | 17.7 | 17.1 | 17.1 | 1223400.0 |
| 2004-04-20 | ACG-DELISTED | Stock | 8.23 | 8.27 | 8.12 | 8.15 | 461700.0 |
| 2004-04-20 | ACGL | Stock | 4.7 | 4.7167 | 4.6444 | 4.6678 | 1012500.0 |
| 2004-04-20 | ACGN-DELISTED | Stock | 861.3288 | 861.3288 | 782.0 | 782.0 | 539800.0 |
| 2004-04-20 | ACH | Stock | 16.96 | 17.1867 | 16.5 | 16.5 | 166500.0 |
| 2004-04-20 | ACH-DELISTED | Stock | 17.619 | 17.957 | 17.307 | 17.367 | 2073456.0 |
| 2004-04-20 | ACLS | Stock | 43.08 | 44.12 | 41.68 | 41.96 | 305300.0 |
| 2004-04-20 | ACO-DELISTED | Stock | 20.36 | 21.25 | 19.15 | 19.18 | 748400.0 |
| 2004-04-20 | ACPW-DELISTED | Stock | 19.08 | 19.813 | 17.808 | 18.15 | 41399.0 |
| 2004-04-20 | ACS-DELISTED | Stock | 53.3 | 55.16 | 53.21 | 53.8 | 2094500.0 |
| 2004-04-20 | ACTA-DELISTED | Stock | 5.8 | 6.2 | 5.6 | 5.6 | 608300.0 |
> showing 50 of 3,698 rows — these rows as CSV