PREVIEW / stock_daily / 2004-10-20
file: by_date/stock_daily/2004/2004-10-20.parquet size: 130 KB rows: 3,842 symbols: 2,399
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-10-20 | AAPL | Stock | 0.8425 | 0.85 | 0.833 | 0.8477 | 605108000.0 |
| 2004-10-20 | MSFT | Stock | 28.22 | 28.75 | 28.12 | 28.7 | 69078100.0 |
| 2004-10-20 | NVDA | Stock | 0.1127 | 0.1149 | 0.1121 | 0.1144 | 540204000.0 |
| 2004-10-20 | AMZN | Stock | 1.9055 | 1.9295 | 1.8895 | 1.9175 | 135970000.0 |
| 2004-10-20 | CL | Stock | 22.0 | 22.715 | 21.975 | 22.675 | 18407200.0 |
| 2004-10-20 | A | Stock | 16.1087 | 16.9957 | 16.1016 | 16.9742 | 5017142.0 |
| 2004-10-20 | AABA-DELISTED | Stock | 34.3800010681152 | 34.5699996948242 | 34.0 | 34.4900016784668 | 15943900.0 |
| 2004-10-20 | AACC-DELISTED | Stock | 18.25 | 19.25 | 18.1 | 18.92 | 33469.0 |
| 2004-10-20 | AAI-DELISTED | Stock | 9.75 | 9.79 | 9.4 | 9.78 | 1282700.0 |
| 2004-10-20 | AAIC-DELISTED | Stock | 382.0 | 382.0 | 362.0 | 373.4 | 2165900.0 |
| 2004-10-20 | AAME | Stock | 3.01 | 3.15 | 3.01 | 3.14 | 2400.0 |
| 2004-10-20 | AAON | Stock | 2.1518 | 2.186 | 2.1162 | 2.1399 | 126816.0 |
| 2004-10-20 | AAP | Stock | 25.5333 | 25.9133 | 24.0667 | 25.8067 | 5062200.0 |
| 2004-10-20 | AAV-DELISTED | Stock | 17.01 | 17.12 | 16.8 | 17.01 | 22900.0 |
| 2004-10-20 | AAXN-DELISTED | Stock | 20.0249996185303 | 20.625 | 19.9300003051758 | 20.1700000762939 | 12033800.0 |
| 2004-10-20 | ABAX-DELISTED | Stock | 12.56 | 12.94 | 12.38 | 12.87 | 184614.0 |
| 2004-10-20 | ABB-DELISTED | Stock | 6.41 | 6.46 | 6.38 | 6.42 | 114200.0 |
| 2004-10-20 | ABC-DELISTED | Stock | 13.0 | 13.06 | 12.65 | 12.73 | 12262400.0 |
| 2004-10-20 | ABCB | Stock | 15.9919 | 16.3242 | 15.5704 | 16.3161 | 18753.0 |
| 2004-10-20 | ABCO-DELISTED | Stock | 15.355 | 15.381 | 15.015 | 15.35 | 106745.0 |
| 2004-10-20 | ABCW-DELISTED | Stock | 25.73 | 25.87 | 25.51 | 25.58 | 36570.0 |
| 2004-10-20 | ABE-DELISTED | Stock | 8.41 | 8.41 | 8.0 | 8.24 | 24500.0 |
| 2004-10-20 | ABFS-DELISTED | Stock | 39.44 | 40.16 | 39.06 | 40.13 | 528258.0 |
| 2004-10-20 | ABG | Stock | 12.95 | 13.4 | 12.75 | 13.28 | 20600.0 |
| 2004-10-20 | ABK-DELISTED | Stock | 74.57 | 74.61 | 72.66 | 73.47 | 1373900.0 |
| 2004-10-20 | ABM | Stock | 19.76 | 20.14 | 19.61 | 20.13 | 86100.0 |
| 2004-10-20 | ABMD-DELISTED | Stock | 9.0 | 9.07 | 8.89 | 9.02 | 85474.0 |
| 2004-10-20 | ABP-DELISTED | Stock | 2.13 | 2.38 | 2.12 | 2.31 | 363200.0 |
| 2004-10-20 | ABR | Stock | 21.2 | 21.25 | 21.12 | 21.15 | 38000.0 |
| 2004-10-20 | ABT | Stock | 19.8877 | 19.9021 | 19.6718 | 19.8637 | 5713005.0 |
| 2004-10-20 | ABTL-DELISTED | Stock | 43.75 | 44.25 | 42.1 | 43.75 | 65900.0 |
| 2004-10-20 | ABV-DELISTED | Stock | 23.32 | 23.62 | 23.2 | 23.54 | 165100.0 |
| 2004-10-20 | ABVA-DELISTED | Stock | 15.0 | 15.0 | 14.98 | 14.98 | 200.0 |
| 2004-10-20 | ABVT-DELISTED | Stock | 24.5 | 24.5 | 24.2 | 24.2 | 200.0 |
| 2004-10-20 | ABX-DELISTED | Stock | 21.1 | 21.67 | 21.1 | 21.53 | 2396200.0 |
| 2004-10-20 | ACAD | Stock | 7.22 | 7.54 | 7.22 | 7.54 | 1100.0 |
| 2004-10-20 | ACAP-DELISTED | Stock | 31.39 | 31.85 | 31.27 | 31.65 | 44065.0 |
| 2004-10-20 | ACAS-DELISTED | Stock | 29.92 | 30.42 | 29.65 | 30.42 | 613755.0 |
| 2004-10-20 | ACAT-DELISTED | Stock | 24.96 | 24.99 | 24.14 | 24.46 | 31941.0 |
| 2004-10-20 | ACC-DELISTED | Stock | 19.68 | 19.85 | 19.5 | 19.85 | 36600.0 |
| 2004-10-20 | ACCL-DELISTED | Stock | 5.95 | 6.03 | 5.9 | 6.01 | 77283.0 |
| 2004-10-20 | ACE-DELISTED | Stock | 32.5 | 34.35 | 32.15 | 34.01 | 4152600.0 |
| 2004-10-20 | ACF-DELISTED | Stock | 18.8 | 19.18 | 18.15 | 18.99 | 1507700.0 |
| 2004-10-20 | ACFC-DELISTED | Stock | 63.27 | 63.27 | 62.55 | 62.76 | 3159.0 |
| 2004-10-20 | ACG-DELISTED | Stock | 8.12 | 8.16 | 8.12 | 8.14 | 346100.0 |
| 2004-10-20 | ACGL | Stock | 3.9722 | 3.9889 | 3.94 | 3.9767 | 1665900.0 |
| 2004-10-20 | ACGN-DELISTED | Stock | 646.0 | 646.0 | 589.3288 | 600.6712 | 133400.0 |
| 2004-10-20 | ACH | Stock | 16.7733 | 16.9667 | 16.5 | 16.5867 | 153600.0 |
| 2004-10-20 | ACH-DELISTED | Stock | 14.092 | 14.492 | 13.929 | 14.217 | 902505.0 |
| 2004-10-20 | ACLS | Stock | 31.8 | 32.72 | 31.2 | 32.28 | 288900.0 |
> showing 50 of 3,842 rows — these rows as CSV