PREVIEW / stock_daily / 2005-11-22
file: by_date/stock_daily/2005/2005-11-22.parquet size: 144 KB rows: 4,284 symbols: 2,702
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-22 | AAPL | Stock | 2.3157 | 2.3843 | 2.3043 | 2.3757 | 540282400.0 |
| 2005-11-22 | MSFT | Stock | 28.06 | 28.08 | 27.86 | 27.91 | 104253300.0 |
| 2005-11-22 | NVDA | Stock | 0.3085 | 0.3181 | 0.3061 | 0.3151 | 731700000.0 |
| 2005-11-22 | AMZN | Stock | 2.375 | 2.4505 | 2.367 | 2.4425 | 259814000.0 |
| 2005-11-22 | CL | Stock | 27.14 | 27.2 | 26.82 | 26.935 | 3237000.0 |
| 2005-11-22 | A | Stock | 24.9285 | 25.608 | 24.9285 | 25.4435 | 5379364.0 |
| 2005-11-22 | AABA-DELISTED | Stock | 41.7299995422363 | 42.6500015258789 | 41.6500015258789 | 42.3600006103516 | 26389500.0 |
| 2005-11-22 | AACC-DELISTED | Stock | 20.55 | 20.7 | 20.23 | 20.3572 | 220706.0 |
| 2005-11-22 | AACQ-DELISTED | Stock | 5.11 | 5.12 | 5.09 | 5.09 | 52000.0 |
| 2005-11-22 | AACQU-DELISTED | Stock | 5.9 | 5.92 | 5.9 | 5.92 | 40000.0 |
| 2005-11-22 | AACQW-DELISTED | Stock | 0.42 | 0.42 | 0.415 | 0.42 | 115000.0 |
| 2005-11-22 | AAI-DELISTED | Stock | 15.71 | 15.72 | 15.16 | 15.18 | 1981200.0 |
| 2005-11-22 | AAIC-DELISTED | Stock | 200.4 | 212.4 | 196.8 | 212.2 | 2271600.0 |
| 2005-11-22 | AAME | Stock | 2.56 | 2.68 | 2.5 | 2.68 | 16900.0 |
| 2005-11-22 | AAON | Stock | 2.2229 | 2.2426 | 2.1873 | 2.2005 | 71381.0 |
| 2005-11-22 | AAP | Stock | 41.86 | 42.97 | 41.75 | 42.88 | 1082600.0 |
| 2005-11-22 | AATI-DELISTED | Stock | 12.53 | 13.01 | 12.47 | 12.96 | 210169.0 |
| 2005-11-22 | AAV-DELISTED | Stock | 17.83 | 17.87 | 17.5 | 17.83 | 43600.0 |
| 2005-11-22 | AAWW-DELISTED | Stock | 33.25 | 33.25 | 32.0 | 33.0 | 159700.0 |
| 2005-11-22 | AAXN-DELISTED | Stock | 7.09999990463257 | 7.3600001335144 | 7.07000017166138 | 7.11999988555908 | 1328100.0 |
| 2005-11-22 | ABAX-DELISTED | Stock | 17.92 | 18.0 | 17.7 | 17.96 | 204659.0 |
| 2005-11-22 | ABB-DELISTED | Stock | 8.63 | 8.79 | 8.58 | 8.77 | 2723800.0 |
| 2005-11-22 | ABBC-DELISTED | Stock | 12.56 | 12.61 | 12.54 | 12.61 | 1500.0 |
| 2005-11-22 | ABC-DELISTED | Stock | 19.77 | 19.9 | 19.75 | 19.81 | 3815200.0 |
| 2005-11-22 | ABCB | Stock | 19.696 | 19.9391 | 19.6085 | 19.9391 | 9870.0 |
| 2005-11-22 | ABCO-DELISTED | Stock | 24.14 | 24.28 | 23.97 | 24.01 | 161066.0 |
| 2005-11-22 | ABCW-DELISTED | Stock | 30.76 | 30.99 | 30.47 | 30.88 | 54560.0 |
| 2005-11-22 | ABD-DELISTED | Stock | 23.5 | 23.61 | 23.27 | 23.38 | 880270.0 |
| 2005-11-22 | ABE-DELISTED | Stock | 11.41 | 11.49 | 11.35 | 11.47 | 12900.0 |
| 2005-11-22 | ABFS-DELISTED | Stock | 41.75 | 42.17 | 41.44 | 41.91 | 309492.0 |
| 2005-11-22 | ABG | Stock | 16.3 | 16.59 | 16.3 | 16.53 | 55900.0 |
| 2005-11-22 | ABK-DELISTED | Stock | 76.05 | 76.42 | 75.83 | 76.35 | 496300.0 |
| 2005-11-22 | ABM | Stock | 21.34 | 21.34 | 21.03 | 21.09 | 134800.0 |
| 2005-11-22 | ABMD-DELISTED | Stock | 8.99 | 9.07 | 8.86 | 8.96 | 64299.0 |
| 2005-11-22 | ABP-DELISTED | Stock | 6.5 | 7.0 | 6.49 | 6.99 | 785200.0 |
| 2005-11-22 | ABR | Stock | 27.25 | 27.4 | 27.03 | 27.29 | 76900.0 |
| 2005-11-22 | ABT | Stock | 19.168 | 19.2544 | 18.2804 | 18.8657 | 27727178.0 |
| 2005-11-22 | ABTL-DELISTED | Stock | 26.1 | 26.9 | 26.1 | 26.8 | 31257.0 |
| 2005-11-22 | ABV-DELISTED | Stock | 37.18 | 37.65 | 36.65 | 37.54 | 377600.0 |
| 2005-11-22 | ABVA-DELISTED | Stock | 16.752 | 16.752 | 16.53 | 16.53 | 700.0 |
| 2005-11-22 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 400.0 |
| 2005-11-22 | ABX-DELISTED | Stock | 27.51 | 27.96 | 27.3 | 27.81 | 4771600.0 |
| 2005-11-22 | ACAD | Stock | 9.43 | 9.5 | 9.37 | 9.49 | 30700.0 |
| 2005-11-22 | ACAP-DELISTED | Stock | 43.0 | 44.85 | 42.93 | 44.7 | 30999.0 |
| 2005-11-22 | ACAS-DELISTED | Stock | 38.44 | 38.73 | 38.25 | 38.69 | 1331465.0 |
| 2005-11-22 | ACAT-DELISTED | Stock | 19.32 | 20.5 | 19.32 | 20.46 | 69072.0 |
| 2005-11-22 | ACC-DELISTED | Stock | 25.45 | 25.75 | 25.27 | 25.64 | 64600.0 |
| 2005-11-22 | ACCL-DELISTED | Stock | 8.49 | 8.74 | 8.33 | 8.61 | 265538.0 |
| 2005-11-22 | ACCO | Stock | 23.5 | 23.61 | 23.27 | 23.38 | 880400.0 |
| 2005-11-22 | ACE-DELISTED | Stock | 55.44 | 55.65 | 54.93 | 55.1 | 1235800.0 |
> showing 50 of 4,284 rows — these rows as CSV