PREVIEW / stock_daily / 2005-11-16
file: by_date/stock_daily/2005/2005-11-16.parquet size: 142 KB rows: 4,252 symbols: 2,684
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-16 | AAPL | Stock | 2.2554 | 2.3236 | 2.2532 | 2.3196 | 784515200.0 |
| 2005-11-16 | MSFT | Stock | 27.48 | 27.88 | 27.44 | 27.74 | 86277000.0 |
| 2005-11-16 | NVDA | Stock | 0.2907 | 0.2922 | 0.2837 | 0.2893 | 455280000.0 |
| 2005-11-16 | AMZN | Stock | 2.2135 | 2.27 | 2.212 | 2.265 | 159340000.0 |
| 2005-11-16 | CL | Stock | 26.9 | 26.9 | 26.7 | 26.8 | 2622600.0 |
| 2005-11-16 | A | Stock | 24.4993 | 24.7496 | 24.4421 | 24.4993 | 5939543.0 |
| 2005-11-16 | AABA-DELISTED | Stock | 37.9000015258789 | 40.0699996948242 | 37.8600006103516 | 40.0400009155273 | 39464600.0 |
| 2005-11-16 | AACC-DELISTED | Stock | 19.76 | 19.78 | 19.4101 | 19.62 | 149575.0 |
| 2005-11-16 | AACQW-DELISTED | Stock | 0.42 | 0.42 | 0.42 | 0.42 | 20000.0 |
| 2005-11-16 | AAI-DELISTED | Stock | 15.77 | 15.89 | 15.1 | 15.69 | 1859400.0 |
| 2005-11-16 | AAIC-DELISTED | Stock | 179.0 | 179.6 | 174.0 | 175.6 | 1154300.0 |
| 2005-11-16 | AAME | Stock | 2.64 | 2.66 | 2.64 | 2.66 | 2500.0 |
| 2005-11-16 | AAON | Stock | 2.2018 | 2.2018 | 2.1347 | 2.136 | 179212.0 |
| 2005-11-16 | AAP | Stock | 39.17 | 39.39 | 38.94 | 39.27 | 724400.0 |
| 2005-11-16 | AATI-DELISTED | Stock | 12.03 | 12.27 | 11.87 | 12.15 | 133204.0 |
| 2005-11-16 | AAV-DELISTED | Stock | 16.91 | 16.91 | 16.43 | 16.91 | 57100.0 |
| 2005-11-16 | AAWW-DELISTED | Stock | 30.4 | 30.4 | 30.25 | 30.25 | 47800.0 |
| 2005-11-16 | AAXN-DELISTED | Stock | 7.05000019073486 | 7.38000011444092 | 7.03000020980835 | 7.34999990463257 | 1753000.0 |
| 2005-11-16 | ABAX-DELISTED | Stock | 18.01 | 18.07 | 17.43 | 17.86 | 139390.0 |
| 2005-11-16 | ABB-DELISTED | Stock | 8.2 | 8.29 | 8.17 | 8.27 | 1557800.0 |
| 2005-11-16 | ABBC-DELISTED | Stock | 12.06 | 12.15 | 12.05 | 12.08 | 33200.0 |
| 2005-11-16 | ABC-DELISTED | Stock | 19.36 | 19.38 | 19.2 | 19.32 | 3519200.0 |
| 2005-11-16 | ABCB | Stock | 19.7154 | 19.8127 | 19.3264 | 19.482 | 11823.0 |
| 2005-11-16 | ABCO-DELISTED | Stock | 24.1 | 24.22 | 23.44 | 23.82 | 254400.0 |
| 2005-11-16 | ABCW-DELISTED | Stock | 30.75 | 30.98 | 30.18 | 30.21 | 123310.0 |
| 2005-11-16 | ABD-DELISTED | Stock | 23.15 | 23.52 | 23.1 | 23.4 | 149300.0 |
| 2005-11-16 | ABE-DELISTED | Stock | 11.24 | 11.27 | 11.18 | 11.21 | 10100.0 |
| 2005-11-16 | ABFS-DELISTED | Stock | 40.94 | 41.78 | 40.77 | 41.3 | 235754.0 |
| 2005-11-16 | ABG | Stock | 15.94 | 16.02 | 15.72 | 15.84 | 63200.0 |
| 2005-11-16 | ABK-DELISTED | Stock | 75.5 | 75.68 | 75.04 | 75.68 | 295800.0 |
| 2005-11-16 | ABM | Stock | 19.69 | 19.94 | 19.54 | 19.94 | 105600.0 |
| 2005-11-16 | ABMD-DELISTED | Stock | 9.05 | 9.05 | 8.72 | 8.77 | 79329.0 |
| 2005-11-16 | ABP-DELISTED | Stock | 6.02 | 6.22 | 6.02 | 6.15 | 323900.0 |
| 2005-11-16 | ABR | Stock | 28.1 | 28.1 | 26.85 | 27.36 | 109300.0 |
| 2005-11-16 | ABT | Stock | 19.7198 | 19.7438 | 19.1008 | 19.4703 | 19479366.0 |
| 2005-11-16 | ABTL-DELISTED | Stock | 24.55 | 24.65 | 23.7 | 24.2 | 37735.0 |
| 2005-11-16 | ABV-DELISTED | Stock | 37.01 | 37.46 | 36.68 | 37.45 | 253500.0 |
| 2005-11-16 | ABVA-DELISTED | Stock | 17.0 | 17.0 | 16.5 | 16.5 | 5103.0 |
| 2005-11-16 | ABX-DELISTED | Stock | 25.66 | 26.57 | 25.66 | 26.48 | 4353300.0 |
| 2005-11-16 | ACAD | Stock | 9.7 | 9.79 | 9.1 | 9.47 | 149800.0 |
| 2005-11-16 | ACAP-DELISTED | Stock | 43.14 | 43.68 | 43.14 | 43.41 | 33403.0 |
| 2005-11-16 | ACAS-DELISTED | Stock | 38.44 | 38.44 | 37.95 | 38.14 | 687257.0 |
| 2005-11-16 | ACAT-DELISTED | Stock | 18.99 | 19.33 | 18.95 | 19.33 | 59541.0 |
| 2005-11-16 | ACC-DELISTED | Stock | 25.65 | 25.7 | 24.9 | 25.59 | 59600.0 |
| 2005-11-16 | ACCL-DELISTED | Stock | 7.5 | 7.52 | 7.3 | 7.46 | 94021.0 |
| 2005-11-16 | ACCO | Stock | 23.15 | 23.52 | 23.1 | 23.4 | 151000.0 |
| 2005-11-16 | ACE-DELISTED | Stock | 55.12 | 55.4 | 54.24 | 54.83 | 1767000.0 |
| 2005-11-16 | ACF-DELISTED | Stock | 23.27 | 23.39 | 22.95 | 23.17 | 716800.0 |
| 2005-11-16 | ACFC-DELISTED | Stock | 74.03 | 74.85 | 71.63 | 71.94 | 13984.0 |
| 2005-11-16 | ACG-DELISTED | Stock | 8.16 | 8.18 | 8.14 | 8.17 | 350900.0 |
> showing 50 of 4,252 rows — these rows as CSV