PREVIEW / stock_daily / 2003-07-18
file: by_date/stock_daily/2003/2003-07-18.parquet size: 115 KB rows: 3,394 symbols: 2,090
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-18 | AAPL | Stock | 0.3732 | 0.3782 | 0.3643 | 0.3725 | 298838400.0 |
| 2003-07-18 | MSFT | Stock | 27.11 | 27.23 | 26.75 | 26.89 | 63388400.0 |
| 2003-07-18 | NVDA | Stock | 0.1797 | 0.1803 | 0.1706 | 0.1772 | 1280832000.0 |
| 2003-07-18 | AMZN | Stock | 1.816 | 1.8425 | 1.7395 | 1.749 | 268058000.0 |
| 2003-07-18 | CL | Stock | 28.0 | 28.225 | 27.88 | 28.15 | 4187600.0 |
| 2003-07-18 | A | Stock | 15.1645 | 15.3219 | 14.9428 | 15.1931 | 2049188.0 |
| 2003-07-18 | AABA-DELISTED | Stock | 15.4949998855591 | 15.5249996185303 | 14.7799997329712 | 14.9499998092651 | 26502200.0 |
| 2003-07-18 | AAI-DELISTED | Stock | 10.7 | 11.11 | 10.66 | 10.96 | 540100.0 |
| 2003-07-18 | AAIC-DELISTED | Stock | 282.2 | 295.6 | 281.6 | 291.6 | 571200.0 |
| 2003-07-18 | AAME | Stock | 2.34 | 2.36 | 2.34 | 2.36 | 1900.0 |
| 2003-07-18 | AAON | Stock | 2.5863 | 2.5863 | 2.3098 | 2.3862 | 520172.0 |
| 2003-07-18 | AAP | Stock | 21.6 | 21.8 | 21.5167 | 21.7333 | 440100.0 |
| 2003-07-18 | AAXN-DELISTED | Stock | 1.01666665077209 | 1.0625 | 1.01666665077209 | 1.05750000476837 | 369600.0 |
| 2003-07-18 | ABAX-DELISTED | Stock | 6.7 | 6.7 | 6.55 | 6.55 | 24070.0 |
| 2003-07-18 | ABB-DELISTED | Stock | 3.1 | 3.24 | 3.06 | 3.23 | 554900.0 |
| 2003-07-18 | ABC-DELISTED | Stock | 17.25 | 17.3 | 17.08 | 17.19 | 2585600.0 |
| 2003-07-18 | ABCB | Stock | 12.3688 | 12.5308 | 12.2634 | 12.4012 | 12461.0 |
| 2003-07-18 | ABCO-DELISTED | Stock | 20.44 | 21.04 | 20.44 | 20.95 | 82988.0 |
| 2003-07-18 | ABCW-DELISTED | Stock | 25.55 | 25.7 | 25.45 | 25.61 | 101640.0 |
| 2003-07-18 | ABE-DELISTED | Stock | 6.09 | 6.11 | 6.05 | 6.11 | 24500.0 |
| 2003-07-18 | ABFS-DELISTED | Stock | 25.8 | 29.079 | 25.48 | 28.31 | 780436.0 |
| 2003-07-18 | ABG | Stock | 14.6 | 14.73 | 14.4 | 14.52 | 25100.0 |
| 2003-07-18 | ABK-DELISTED | Stock | 66.9 | 67.5 | 66.58 | 67.02 | 760500.0 |
| 2003-07-18 | ABM | Stock | 15.9 | 16.19 | 15.9 | 16.15 | 46200.0 |
| 2003-07-18 | ABMD-DELISTED | Stock | 5.599 | 5.65 | 5.33 | 5.5 | 57800.0 |
| 2003-07-18 | ABP-DELISTED | Stock | 1.04 | 1.05 | 1.0 | 1.04 | 43800.0 |
| 2003-07-18 | ABT | Stock | 18.3286 | 18.7102 | 18.3286 | 18.5845 | 9441282.0 |
| 2003-07-18 | ABTL-DELISTED | Stock | 32.45 | 34.0 | 31.75 | 31.85 | 61200.0 |
| 2003-07-18 | ABV-DELISTED | Stock | 20.39 | 20.58 | 20.38 | 20.4 | 147000.0 |
| 2003-07-18 | ABVA-DELISTED | Stock | 17.5 | 17.87 | 17.5 | 17.51 | 700.0 |
| 2003-07-18 | ABX-DELISTED | Stock | 16.92 | 16.97 | 16.68 | 16.88 | 1485527.0 |
| 2003-07-18 | ACAP-DELISTED | Stock | 25.55 | 25.55 | 25.05 | 25.07 | 47600.0 |
| 2003-07-18 | ACAS-DELISTED | Stock | 27.44 | 27.9 | 27.4 | 27.69 | 293496.0 |
| 2003-07-18 | ACAT-DELISTED | Stock | 19.52 | 19.84 | 19.3 | 19.84 | 27500.0 |
| 2003-07-18 | ACCL-DELISTED | Stock | 7.01000022888184 | 7.05999994277954 | 6.6399998664856 | 6.79899978637695 | 84000.0 |
| 2003-07-18 | ACE-DELISTED | Stock | 33.45 | 33.5 | 32.98 | 33.34 | 1227600.0 |
| 2003-07-18 | ACF-DELISTED | Stock | 8.85 | 8.85 | 8.24 | 8.68 | 1700100.0 |
| 2003-07-18 | ACG-DELISTED | Stock | 8.55 | 8.73 | 8.53 | 8.73 | 1077000.0 |
| 2003-07-18 | ACGL | Stock | 3.8178 | 3.8878 | 3.8178 | 3.8689 | 1024200.0 |
| 2003-07-18 | ACGN-DELISTED | Stock | 1020.0 | 1076.6712 | 1020.0 | 1054.0 | 23000.0 |
| 2003-07-18 | ACH | Stock | 15.8667 | 16.36 | 15.8667 | 16.28 | 793200.0 |
| 2003-07-18 | ACH-DELISTED | Stock | 7.18 | 7.238 | 7.163 | 7.188 | 9999.0 |
| 2003-07-18 | ACLS | Stock | 31.44 | 32.16 | 30.6 | 32.0 | 197775.0 |
| 2003-07-18 | ACO-DELISTED | Stock | 9.48 | 9.7 | 9.48 | 9.6 | 20400.0 |
| 2003-07-18 | ACPW-DELISTED | Stock | 8.25 | 8.4 | 7.9 | 7.95 | 14365.0 |
| 2003-07-18 | ACS-DELISTED | Stock | 44.45 | 44.8 | 43.75 | 43.9 | 1125000.0 |
| 2003-07-18 | ACTA-DELISTED | Stock | 11.8 | 12.6 | 11.6 | 11.6 | 504200.0 |
| 2003-07-18 | ACTG | Stock | 1.53 | 1.74 | 1.5 | 1.56 | 52000.0 |
| 2003-07-18 | ACTI-DELISTED | Stock | 9.21 | 9.31 | 9.16 | 9.18 | 90516.0 |
| 2003-07-18 | ACTT-DELISTED | Stock | 2.0 | 2.06 | 1.75 | 2.04 | 60305.0 |
> showing 50 of 3,394 rows — these rows as CSV