PREVIEW / stock_daily / 2006-02-21
file: by_date/stock_daily/2006/2006-02-21.parquet size: 146 KB rows: 4,378 symbols: 2,778
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-21 | AAPL | Stock | 2.5211 | 2.5286 | 2.4529 | 2.4671 | 779606800.0 |
| 2006-02-21 | MSFT | Stock | 26.72 | 26.72 | 26.34 | 26.54 | 50216100.0 |
| 2006-02-21 | NVDA | Stock | 0.3947 | 0.3954 | 0.3837 | 0.3872 | 684060000.0 |
| 2006-02-21 | AMZN | Stock | 1.9505 | 1.9555 | 1.913 | 1.9145 | 101122000.0 |
| 2006-02-21 | CL | Stock | 27.25 | 27.295 | 27.115 | 27.16 | 2740000.0 |
| 2006-02-21 | A | Stock | 24.9857 | 25.2933 | 24.9785 | 25.1359 | 4502119.0 |
| 2006-02-21 | AABA-DELISTED | Stock | 32.9000015258789 | 33.0699996948242 | 32.3800010681152 | 32.3899993896484 | 14328100.0 |
| 2006-02-21 | AACC-DELISTED | Stock | 17.45 | 17.85 | 17.36 | 17.5 | 262583.0 |
| 2006-02-21 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.33 | 5.33 | 3000.0 |
| 2006-02-21 | AACQU-DELISTED | Stock | 6.7 | 6.7 | 6.63 | 6.65 | 10500.0 |
| 2006-02-21 | AACQW-DELISTED | Stock | 0.68 | 0.68 | 0.68 | 0.68 | 5000.0 |
| 2006-02-21 | AAI-DELISTED | Stock | 17.73 | 17.88 | 17.22 | 17.52 | 1272900.0 |
| 2006-02-21 | AAIC-DELISTED | Stock | 214.8 | 217.0 | 212.0 | 212.2 | 474200.0 |
| 2006-02-21 | AAON | Stock | 2.7509 | 2.7747 | 2.7338 | 2.7681 | 1339537.0 |
| 2006-02-21 | AAP | Stock | 41.75 | 41.85 | 40.42 | 40.45 | 1595400.0 |
| 2006-02-21 | AATI-DELISTED | Stock | 13.6 | 13.9 | 12.08 | 12.8 | 1603619.0 |
| 2006-02-21 | AAU-DELISTED | Stock | 2.85 | 3.0 | 2.85 | 2.9 | 75500.0 |
| 2006-02-21 | AAUAF-DELISTED | Stock | 2.85 | 3.0 | 2.85 | 2.9 | 75500.0 |
| 2006-02-21 | AAV-DELISTED | Stock | 20.4 | 20.51 | 20.0 | 20.5 | 780700.0 |
| 2006-02-21 | AAWW-DELISTED | Stock | 48.0 | 49.0 | 47.5 | 47.63 | 46300.0 |
| 2006-02-21 | AAXN-DELISTED | Stock | 10.3500003814697 | 10.6899995803833 | 10.3000001907349 | 10.3999996185303 | 2687800.0 |
| 2006-02-21 | ABAX-DELISTED | Stock | 21.46 | 21.74 | 20.81 | 21.07 | 203309.0 |
| 2006-02-21 | ABB-DELISTED | Stock | 11.48 | 11.55 | 11.45 | 11.52 | 2084600.0 |
| 2006-02-21 | ABBC-DELISTED | Stock | 13.3 | 13.35 | 13.3 | 13.34 | 17000.0 |
| 2006-02-21 | ABC-DELISTED | Stock | 21.96 | 22.3 | 21.94 | 22.2 | 2207800.0 |
| 2006-02-21 | ABCB | Stock | 21.0188 | 21.155 | 20.6394 | 20.6881 | 17273.0 |
| 2006-02-21 | ABCO-DELISTED | Stock | 26.74 | 26.92 | 26.36 | 26.89 | 390200.0 |
| 2006-02-21 | ABCW-DELISTED | Stock | 31.61 | 31.68 | 30.8 | 31.23 | 49720.0 |
| 2006-02-21 | ABD-DELISTED | Stock | 23.68 | 23.76 | 23.34 | 23.37 | 107600.0 |
| 2006-02-21 | ABE-DELISTED | Stock | 13.0 | 13.25 | 13.0 | 13.16 | 57700.0 |
| 2006-02-21 | ABFS-DELISTED | Stock | 42.56 | 42.74 | 41.6 | 42.6 | 416162.0 |
| 2006-02-21 | ABG | Stock | 19.6 | 19.8 | 19.25 | 19.8 | 133100.0 |
| 2006-02-21 | ABK-DELISTED | Stock | 75.79 | 75.84 | 74.96 | 75.1 | 411400.0 |
| 2006-02-21 | ABM | Stock | 18.87 | 18.97 | 18.65 | 18.71 | 160400.0 |
| 2006-02-21 | ABMD-DELISTED | Stock | 11.09 | 11.09 | 10.51 | 10.53 | 111035.0 |
| 2006-02-21 | ABP-DELISTED | Stock | 6.3 | 6.45 | 6.24 | 6.29 | 349500.0 |
| 2006-02-21 | ABR | Stock | 27.04 | 27.24 | 26.77 | 26.95 | 82700.0 |
| 2006-02-21 | ABT | Stock | 21.2312 | 21.2599 | 20.8857 | 21.1064 | 8231138.0 |
| 2006-02-21 | ABTL-DELISTED | Stock | 23.82 | 24.17 | 23.28 | 23.33 | 78411.0 |
| 2006-02-21 | ABV-DELISTED | Stock | 44.05 | 44.34 | 42.81 | 43.09 | 592200.0 |
| 2006-02-21 | ABVA-DELISTED | Stock | 18.346 | 18.38 | 18.176 | 18.21 | 865.0 |
| 2006-02-21 | ABX-DELISTED | Stock | 28.82 | 29.17 | 28.5 | 28.7 | 3299400.0 |
| 2006-02-21 | ACAD | Stock | 15.09 | 15.15 | 14.45 | 14.83 | 246100.0 |
| 2006-02-21 | ACAP-DELISTED | Stock | 48.8 | 49.08 | 48.3 | 48.86 | 59534.0 |
| 2006-02-21 | ACAS-DELISTED | Stock | 36.99 | 37.23 | 36.75 | 36.94 | 835632.0 |
| 2006-02-21 | ACAT-DELISTED | Stock | 24.34 | 24.5 | 24.0 | 24.05 | 42717.0 |
| 2006-02-21 | ACC-DELISTED | Stock | 24.94 | 24.99 | 24.24 | 24.69 | 91700.0 |
| 2006-02-21 | ACCL-DELISTED | Stock | 6.11 | 6.26 | 6.0 | 6.02 | 184872.0 |
| 2006-02-21 | ACCO | Stock | 23.7 | 23.78 | 23.35 | 23.35 | 107600.0 |
| 2006-02-21 | ACCP-DELISTED | Stock | 0.975 | 1.2 | 0.975 | 1.15 | 82300.0 |
> showing 50 of 4,378 rows — these rows as CSV