PREVIEW / stock_daily / 2005-09-14
file: by_date/stock_daily/2005/2005-09-14.parquet size: 140 KB rows: 4,173 symbols: 2,624
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-09-14 | AAPL | Stock | 1.8236 | 1.8282 | 1.7664 | 1.7718 | 474426400.0 |
| 2005-09-14 | MSFT | Stock | 26.52 | 26.64 | 26.3 | 26.31 | 54969600.0 |
| 2005-09-14 | NVDA | Stock | 0.2733 | 0.277 | 0.2708 | 0.2721 | 503448000.0 |
| 2005-09-14 | AMZN | Stock | 2.194 | 2.2365 | 2.141 | 2.155 | 126360000.0 |
| 2005-09-14 | CL | Stock | 26.285 | 26.435 | 26.16 | 26.275 | 2829400.0 |
| 2005-09-14 | A | Stock | 23.4979 | 23.5479 | 23.2976 | 23.3405 | 3368761.0 |
| 2005-09-14 | AABA-DELISTED | Stock | 34.2999992370605 | 34.5 | 33.6399993896484 | 33.7999992370605 | 15017400.0 |
| 2005-09-14 | AACC-DELISTED | Stock | 30.83 | 31.03 | 30.4 | 30.52 | 243793.0 |
| 2005-09-14 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 7000.0 |
| 2005-09-14 | AACQU-DELISTED | Stock | 6.28 | 6.28 | 6.28 | 6.28 | 1130.0 |
| 2005-09-14 | AACQW-DELISTED | Stock | 0.61 | 0.63 | 0.61 | 0.63 | 62000.0 |
| 2005-09-14 | AAI-DELISTED | Stock | 10.76 | 11.08 | 10.66 | 10.93 | 1479000.0 |
| 2005-09-14 | AAIC-DELISTED | Stock | 231.8 | 232.6 | 230.0 | 230.2 | 1353800.0 |
| 2005-09-14 | AAON | Stock | 2.3704 | 2.3704 | 2.3427 | 2.344 | 134409.0 |
| 2005-09-14 | AAP | Stock | 40.9467 | 41.28 | 40.4867 | 40.5267 | 482700.0 |
| 2005-09-14 | AATI-DELISTED | Stock | 13.08 | 13.28 | 12.9 | 13.18 | 202816.0 |
| 2005-09-14 | AAV-DELISTED | Stock | 17.18 | 17.18 | 17.03 | 17.18 | 46600.0 |
| 2005-09-14 | AAXN-DELISTED | Stock | 8.05000019073486 | 8.18000030517578 | 7.90000009536743 | 7.90000009536743 | 1496800.0 |
| 2005-09-14 | ABAX-DELISTED | Stock | 12.97 | 13.14 | 12.69 | 12.9 | 72616.0 |
| 2005-09-14 | ABB-DELISTED | Stock | 7.39 | 7.42 | 7.35 | 7.37 | 878600.0 |
| 2005-09-14 | ABBC-DELISTED | Stock | 12.65 | 12.68 | 12.65 | 12.65 | 2010.0 |
| 2005-09-14 | ABC-DELISTED | Stock | 19.02 | 19.24 | 18.93 | 18.98 | 7610400.0 |
| 2005-09-14 | ABCB | Stock | 18.8498 | 18.9665 | 17.8967 | 18.0036 | 60351.0 |
| 2005-09-14 | ABCO-DELISTED | Stock | 26.13 | 26.28 | 25.57 | 25.57 | 164097.0 |
| 2005-09-14 | ABCW-DELISTED | Stock | 30.62 | 30.9 | 30.07 | 30.13 | 37010.0 |
| 2005-09-14 | ABD-DELISTED | Stock | 26.96 | 27.99 | 26.96 | 27.69 | 582350.0 |
| 2005-09-14 | ABE-DELISTED | Stock | 10.74 | 10.79 | 10.74 | 10.76 | 7700.0 |
| 2005-09-14 | ABFS-DELISTED | Stock | 33.0 | 33.18 | 32.36 | 32.84 | 334997.0 |
| 2005-09-14 | ABG | Stock | 17.19 | 17.32 | 16.84 | 17.2 | 66100.0 |
| 2005-09-14 | ABK-DELISTED | Stock | 68.88 | 69.21 | 68.54 | 68.86 | 1012100.0 |
| 2005-09-14 | ABM | Stock | 20.98 | 21.06 | 20.84 | 20.9 | 203400.0 |
| 2005-09-14 | ABMD-DELISTED | Stock | 10.56 | 10.78 | 10.48 | 10.58 | 89809.0 |
| 2005-09-14 | ABP-DELISTED | Stock | 4.6 | 5.1 | 4.56 | 5.03 | 1350300.0 |
| 2005-09-14 | ABR | Stock | 28.9 | 28.9 | 28.75 | 28.85 | 160000.0 |
| 2005-09-14 | ABT | Stock | 21.4279 | 21.4567 | 21.0104 | 21.0392 | 10557316.0 |
| 2005-09-14 | ABTL-DELISTED | Stock | 25.5 | 25.5 | 24.85 | 25.1 | 22883.0 |
| 2005-09-14 | ABV-DELISTED | Stock | 35.32 | 35.58 | 34.98 | 35.24 | 170600.0 |
| 2005-09-14 | ABX-DELISTED | Stock | 27.39 | 27.71 | 27.38 | 27.59 | 2953300.0 |
| 2005-09-14 | ACAD | Stock | 10.92 | 11.0 | 10.74 | 10.75 | 38400.0 |
| 2005-09-14 | ACAP-DELISTED | Stock | 45.23 | 45.23 | 43.17 | 43.48 | 47460.0 |
| 2005-09-14 | ACAS-DELISTED | Stock | 37.44 | 37.53 | 37.05 | 37.08 | 635696.0 |
| 2005-09-14 | ACAT-DELISTED | Stock | 20.88 | 21.1201 | 20.4 | 20.41 | 38010.0 |
| 2005-09-14 | ACC-DELISTED | Stock | 23.0 | 23.16 | 22.95 | 22.98 | 37500.0 |
| 2005-09-14 | ACCL-DELISTED | Stock | 6.49 | 6.77 | 6.45 | 6.62 | 412461.0 |
| 2005-09-14 | ACCO | Stock | 26.9 | 27.93 | 26.9 | 27.75 | 583400.0 |
| 2005-09-14 | ACE-DELISTED | Stock | 46.2 | 46.2 | 45.22 | 45.24 | 1370200.0 |
| 2005-09-14 | ACF-DELISTED | Stock | 25.32 | 25.4 | 24.94 | 25.02 | 759800.0 |
| 2005-09-14 | ACFC-DELISTED | Stock | 73.01 | 73.01 | 71.28 | 72.45 | 18081.0 |
| 2005-09-14 | ACG-DELISTED | Stock | 8.31 | 8.32 | 8.28 | 8.3 | 337000.0 |
| 2005-09-14 | ACGL | Stock | 5.04 | 5.04 | 4.9722 | 4.9911 | 2154600.0 |
> showing 50 of 4,173 rows — these rows as CSV