PREVIEW / stock_daily / 2004-05-18
file: by_date/stock_daily/2004/2004-05-18.parquet size: 125 KB rows: 3,721 symbols: 2,318
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-05-18 | AAPL | Stock | 0.4816 | 0.4873 | 0.4786 | 0.4832 | 206063200.0 |
| 2004-05-18 | MSFT | Stock | 25.7 | 25.97 | 25.64 | 25.83 | 58158600.0 |
| 2004-05-18 | NVDA | Stock | 0.178 | 0.1813 | 0.1773 | 0.1792 | 204420000.0 |
| 2004-05-18 | AMZN | Stock | 2.11 | 2.12 | 2.0915 | 2.0995 | 112040000.0 |
| 2004-05-18 | CL | Stock | 28.175 | 28.325 | 27.995 | 28.075 | 2152000.0 |
| 2004-05-18 | A | Stock | 18.7411 | 18.9342 | 17.525 | 18.1688 | 12886065.0 |
| 2004-05-18 | AABA-DELISTED | Stock | 27.4899997711182 | 27.9799995422363 | 27.3099994659424 | 27.7700004577637 | 19084700.0 |
| 2004-05-18 | AACC-DELISTED | Stock | 19.139 | 19.14 | 18.75 | 19.0 | 47794.0 |
| 2004-05-18 | AAI-DELISTED | Stock | 12.7 | 12.95 | 12.55 | 12.89 | 1145300.0 |
| 2004-05-18 | AAIC-DELISTED | Stock | 356.0 | 359.6 | 350.4 | 357.4 | 1256300.0 |
| 2004-05-18 | AAME | Stock | 2.7 | 2.79 | 2.61 | 2.79 | 3400.0 |
| 2004-05-18 | AAON | Stock | 2.5811 | 2.6298 | 2.5811 | 2.6298 | 94162.0 |
| 2004-05-18 | AAP | Stock | 27.5 | 28.04 | 27.4667 | 28.0067 | 1058250.0 |
| 2004-05-18 | AAV-DELISTED | Stock | 14.19 | 14.4 | 14.14 | 14.19 | 25000.0 |
| 2004-05-18 | AAXN-DELISTED | Stock | 15.3500003814697 | 15.625 | 14.7399997711182 | 14.8999996185303 | 18250600.0 |
| 2004-05-18 | ABAX-DELISTED | Stock | 18.75 | 18.83 | 18.27 | 18.44 | 133134.0 |
| 2004-05-18 | ABB-DELISTED | Stock | 5.304 | 5.39 | 5.3 | 5.35 | 207700.0 |
| 2004-05-18 | ABC-DELISTED | Stock | 14.63 | 14.7 | 14.54 | 14.59 | 2878800.0 |
| 2004-05-18 | ABCB | Stock | 14.922 | 15.2948 | 14.922 | 15.2948 | 10735.0 |
| 2004-05-18 | ABCO-DELISTED | Stock | 16.525 | 16.69 | 16.44 | 16.57 | 252092.0 |
| 2004-05-18 | ABCW-DELISTED | Stock | 24.74 | 26.54 | 24.74 | 26.5 | 39130.0 |
| 2004-05-18 | ABE-DELISTED | Stock | 7.5 | 7.5 | 7.04 | 7.08 | 17700.0 |
| 2004-05-18 | ABFS-DELISTED | Stock | 27.62 | 28.7 | 27.62 | 28.63 | 406557.0 |
| 2004-05-18 | ABG | Stock | 13.4 | 13.92 | 13.4 | 13.92 | 10100.0 |
| 2004-05-18 | ABK-DELISTED | Stock | 64.5 | 64.9 | 64.22 | 64.71 | 432200.0 |
| 2004-05-18 | ABM | Stock | 18.55 | 18.6 | 18.26 | 18.4 | 68100.0 |
| 2004-05-18 | ABMD-DELISTED | Stock | 10.98 | 11.29 | 10.56 | 11.04 | 34420.0 |
| 2004-05-18 | ABP-DELISTED | Stock | 1.88 | 1.88 | 1.62 | 1.71 | 290600.0 |
| 2004-05-18 | ABR | Stock | 19.08 | 19.18 | 18.95 | 19.08 | 25900.0 |
| 2004-05-18 | ABT | Stock | 19.9021 | 19.9069 | 19.6286 | 19.667 | 5501876.0 |
| 2004-05-18 | ABTL-DELISTED | Stock | 46.5 | 46.9 | 45.15 | 46.75 | 55800.0 |
| 2004-05-18 | ABV-DELISTED | Stock | 17.2 | 17.32 | 16.53 | 16.9 | 1031000.0 |
| 2004-05-18 | ABVA-DELISTED | Stock | 14.92 | 14.92 | 14.8 | 14.8 | 13700.0 |
| 2004-05-18 | ABX-DELISTED | Stock | 19.02 | 19.49 | 18.87 | 19.43 | 1787600.0 |
| 2004-05-18 | ACAP-DELISTED | Stock | 23.0 | 23.44 | 23.0 | 23.3 | 27507.0 |
| 2004-05-18 | ACAS-DELISTED | Stock | 25.49 | 25.88 | 25.28 | 25.65 | 713879.0 |
| 2004-05-18 | ACAT-DELISTED | Stock | 21.29 | 22.22 | 21.29 | 21.97 | 41974.0 |
| 2004-05-18 | ACCL-DELISTED | Stock | 9.2 | 9.93 | 9.2 | 9.62 | 81504.0 |
| 2004-05-18 | ACE-DELISTED | Stock | 40.92 | 41.15 | 40.6 | 40.63 | 517400.0 |
| 2004-05-18 | ACF-DELISTED | Stock | 16.3 | 16.95 | 16.3 | 16.89 | 1637800.0 |
| 2004-05-18 | ACG-DELISTED | Stock | 7.52 | 7.71 | 7.5 | 7.71 | 601300.0 |
| 2004-05-18 | ACGL | Stock | 4.17 | 4.2333 | 4.1678 | 4.2189 | 585900.0 |
| 2004-05-18 | ACGN-DELISTED | Stock | 725.3288 | 748.0 | 691.3288 | 714.0 | 130100.0 |
| 2004-05-18 | ACH | Stock | 15.7333 | 15.7467 | 15.4667 | 15.7 | 236550.0 |
| 2004-05-18 | ACH-DELISTED | Stock | 11.84 | 12.255 | 11.62 | 12.23 | 1801523.0 |
| 2004-05-18 | ACLS | Stock | 42.04 | 44.0 | 42.04 | 43.72 | 321850.0 |
| 2004-05-18 | ACO-DELISTED | Stock | 15.46 | 15.85 | 15.46 | 15.68 | 103900.0 |
| 2004-05-18 | ACPW-DELISTED | Stock | 15.0 | 15.85 | 14.6 | 15.85 | 35596.0 |
| 2004-05-18 | ACS-DELISTED | Stock | 46.94 | 47.2 | 46.52 | 46.84 | 1136400.0 |
| 2004-05-18 | ACTA-DELISTED | Stock | 4.8 | 4.86 | 4.4 | 4.55 | 745600.0 |
> showing 50 of 3,721 rows — these rows as CSV