PREVIEW / stock_daily / 2004-11-03
file: by_date/stock_daily/2004/2004-11-03.parquet size: 130 KB rows: 3,874 symbols: 2,421
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-03 | AAPL | Stock | 0.9709 | 1.002 | 0.9641 | 0.9877 | 1204173600.0 |
| 2004-11-03 | MSFT | Stock | 28.65 | 28.65 | 28.31 | 28.47 | 79666700.0 |
| 2004-11-03 | NVDA | Stock | 0.13 | 0.1304 | 0.1254 | 0.1261 | 910356000.0 |
| 2004-11-03 | AMZN | Stock | 1.859 | 1.881 | 1.778 | 1.796 | 204164000.0 |
| 2004-11-03 | CL | Stock | 22.775 | 22.805 | 22.56 | 22.74 | 4795600.0 |
| 2004-11-03 | A | Stock | 18.4979 | 18.4979 | 17.568 | 17.7682 | 5250049.0 |
| 2004-11-03 | AABA-DELISTED | Stock | 39.2000007629395 | 39.25 | 37.5400009155273 | 37.9700012207031 | 25377500.0 |
| 2004-11-03 | AACC-DELISTED | Stock | 17.75 | 18.04 | 17.7 | 17.78 | 26420.0 |
| 2004-11-03 | AAI-DELISTED | Stock | 12.36 | 12.86 | 12.15 | 12.33 | 2161600.0 |
| 2004-11-03 | AAIC-DELISTED | Stock | 354.0 | 355.2 | 349.8 | 354.2 | 1736700.0 |
| 2004-11-03 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 800.0 |
| 2004-11-03 | AAON | Stock | 1.9753 | 1.9753 | 1.9332 | 1.9687 | 91884.0 |
| 2004-11-03 | AAP | Stock | 26.2333 | 26.4667 | 26.0667 | 26.2867 | 930900.0 |
| 2004-11-03 | AAV-DELISTED | Stock | 17.26 | 17.4 | 16.8 | 17.26 | 18700.0 |
| 2004-11-03 | AAXN-DELISTED | Stock | 21.4300003051758 | 21.4300003051758 | 20.3799991607666 | 20.6700000762939 | 7566200.0 |
| 2004-11-03 | ABAX-DELISTED | Stock | 12.96 | 13.0 | 12.62 | 12.88 | 88670.0 |
| 2004-11-03 | ABB-DELISTED | Stock | 5.74 | 5.76 | 5.62 | 5.66 | 238900.0 |
| 2004-11-03 | ABC-DELISTED | Stock | 14.09 | 14.44 | 14.0 | 14.07 | 11922800.0 |
| 2004-11-03 | ABCB | Stock | 17.0537 | 17.4022 | 16.8591 | 17.2644 | 20604.0 |
| 2004-11-03 | ABCO-DELISTED | Stock | 17.275 | 17.675 | 17.275 | 17.54 | 493785.0 |
| 2004-11-03 | ABCW-DELISTED | Stock | 25.81 | 26.5 | 25.8 | 26.2 | 57350.0 |
| 2004-11-03 | ABE-DELISTED | Stock | 8.72 | 8.79 | 8.56 | 8.64 | 14100.0 |
| 2004-11-03 | ABFS-DELISTED | Stock | 39.72 | 40.09 | 39.66 | 39.97 | 227774.0 |
| 2004-11-03 | ABG | Stock | 14.0 | 14.0 | 13.85 | 13.97 | 16000.0 |
| 2004-11-03 | ABK-DELISTED | Stock | 80.0 | 80.2 | 77.17 | 77.7 | 835400.0 |
| 2004-11-03 | ABM | Stock | 20.77 | 21.22 | 20.77 | 21.18 | 158800.0 |
| 2004-11-03 | ABMD-DELISTED | Stock | 13.4 | 14.37 | 13.26 | 13.91 | 396242.0 |
| 2004-11-03 | ABP-DELISTED | Stock | 2.69 | 2.78 | 2.65 | 2.75 | 233500.0 |
| 2004-11-03 | ABR | Stock | 21.52 | 21.55 | 21.1 | 21.11 | 91800.0 |
| 2004-11-03 | ABT | Stock | 20.6218 | 21.0632 | 20.6026 | 20.9241 | 12707795.0 |
| 2004-11-03 | ABTL-DELISTED | Stock | 35.5 | 35.65 | 34.0 | 35.05 | 66900.0 |
| 2004-11-03 | ABV-DELISTED | Stock | 25.3 | 25.46 | 24.9 | 25.0 | 1019100.0 |
| 2004-11-03 | ABVA-DELISTED | Stock | 14.75 | 14.8 | 14.7 | 14.7 | 34452.0 |
| 2004-11-03 | ABVT-DELISTED | Stock | 24.5 | 24.52 | 24.5 | 24.52 | 40000.0 |
| 2004-11-03 | ABX-DELISTED | Stock | 21.82 | 21.89 | 21.51 | 21.88 | 2091635.0 |
| 2004-11-03 | ACAD | Stock | 7.31 | 7.41 | 7.16 | 7.23 | 13100.0 |
| 2004-11-03 | ACAP-DELISTED | Stock | 32.7 | 34.08 | 32.57 | 34.05 | 263169.0 |
| 2004-11-03 | ACAS-DELISTED | Stock | 30.82 | 31.47 | 30.56 | 31.1 | 807054.0 |
| 2004-11-03 | ACAT-DELISTED | Stock | 25.15 | 25.23 | 24.94 | 25.18 | 179233.0 |
| 2004-11-03 | ACC-DELISTED | Stock | 19.0 | 19.25 | 18.9 | 19.0 | 60700.0 |
| 2004-11-03 | ACCL-DELISTED | Stock | 6.22 | 6.24 | 6.01 | 6.09 | 91075.0 |
| 2004-11-03 | ACE-DELISTED | Stock | 38.91 | 39.35 | 38.32 | 38.55 | 1126714.0 |
| 2004-11-03 | ACF-DELISTED | Stock | 19.95 | 19.96 | 19.4 | 19.55 | 1138500.0 |
| 2004-11-03 | ACFC-DELISTED | Stock | 66.07 | 66.07 | 65.41 | 65.97 | 8857.0 |
| 2004-11-03 | ACG-DELISTED | Stock | 8.18 | 8.18 | 8.12 | 8.16 | 374700.0 |
| 2004-11-03 | ACGL | Stock | 4.1422 | 4.2589 | 4.1322 | 4.2489 | 2145600.0 |
| 2004-11-03 | ACGN-DELISTED | Stock | 612.0 | 612.0 | 566.6712 | 600.6712 | 68500.0 |
| 2004-11-03 | ACH | Stock | 17.6667 | 18.16 | 17.6667 | 17.9867 | 374700.0 |
| 2004-11-03 | ACH-DELISTED | Stock | 15.216 | 15.254 | 15.041 | 15.159 | 361626.0 |
| 2004-11-03 | ACLS | Stock | 34.52 | 35.56 | 33.44 | 34.32 | 213525.0 |
> showing 50 of 3,874 rows — these rows as CSV