PREVIEW / stock_daily / 2006-04-03
file: by_date/stock_daily/2006/2006-04-03.parquet size: 148 KB rows: 4,413 symbols: 2,794
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-04-03 | AAPL | Stock | 2.2739 | 2.29 | 2.2361 | 2.2375 | 815791200.0 |
| 2006-04-03 | MSFT | Stock | 27.67 | 27.73 | 27.44 | 27.56 | 57605300.0 |
| 2006-04-03 | NVDA | Stock | 0.4797 | 0.4892 | 0.4737 | 0.4825 | 968916000.0 |
| 2006-04-03 | AMZN | Stock | 1.8335 | 1.8665 | 1.805 | 1.807 | 101080000.0 |
| 2006-04-03 | CL | Stock | 28.75 | 29.22 | 28.655 | 28.915 | 4444200.0 |
| 2006-04-03 | A | Stock | 27.0386 | 27.4392 | 26.9671 | 27.2532 | 4227412.0 |
| 2006-04-03 | AABA-DELISTED | Stock | 32.4099998474121 | 32.5299987792969 | 31.7900009155273 | 31.8899993896484 | 14887900.0 |
| 2006-04-03 | AACC-DELISTED | Stock | 19.42 | 20.01 | 19.42 | 19.55 | 265542.0 |
| 2006-04-03 | AACQ-DELISTED | Stock | 5.45 | 5.45 | 5.45 | 5.45 | 245.0 |
| 2006-04-03 | AACQW-DELISTED | Stock | 0.73 | 0.73 | 0.73 | 0.73 | 2900.0 |
| 2006-04-03 | AAI-DELISTED | Stock | 18.2 | 18.2 | 17.85 | 17.96 | 973600.0 |
| 2006-04-03 | AAIC-DELISTED | Stock | 187.4 | 188.8 | 183.0 | 183.2 | 678800.0 |
| 2006-04-03 | AAME | Stock | 2.88 | 2.95 | 2.76 | 2.83 | 24500.0 |
| 2006-04-03 | AAON | Stock | 3.1184 | 3.1868 | 3.1078 | 3.1605 | 92644.0 |
| 2006-04-03 | AAP | Stock | 41.5 | 41.78 | 41.34 | 41.57 | 954100.0 |
| 2006-04-03 | AATI-DELISTED | Stock | 11.48 | 11.48 | 11.0 | 11.17 | 140769.0 |
| 2006-04-03 | AAU-DELISTED | Stock | 2.9 | 2.9099 | 2.75 | 2.76 | 27300.0 |
| 2006-04-03 | AAUAF-DELISTED | Stock | 2.9 | 2.9099 | 2.75 | 2.76 | 27300.0 |
| 2006-04-03 | AAV-DELISTED | Stock | 19.2 | 19.29 | 19.03 | 19.05 | 233200.0 |
| 2006-04-03 | AAWW-DELISTED | Stock | 47.1 | 47.1 | 44.0 | 44.5 | 505200.0 |
| 2006-04-03 | AAXN-DELISTED | Stock | 10.6000003814697 | 10.6499996185303 | 10.3500003814697 | 10.4200000762939 | 1005900.0 |
| 2006-04-03 | AB | Stock | 66.48 | 66.88 | 66.31 | 66.86 | 229700.0 |
| 2006-04-03 | ABAX-DELISTED | Stock | 23.0 | 23.72 | 22.75 | 22.78 | 411309.0 |
| 2006-04-03 | ABB-DELISTED | Stock | 12.79 | 13.0 | 12.78 | 12.88 | 1860900.0 |
| 2006-04-03 | ABBC-DELISTED | Stock | 13.61 | 13.61 | 13.5 | 13.5 | 7806.0 |
| 2006-04-03 | ABC-DELISTED | Stock | 24.2 | 24.48 | 24.1 | 24.3 | 3123600.0 |
| 2006-04-03 | ABCB | Stock | 22.3708 | 22.6042 | 21.8844 | 22.0304 | 18095.0 |
| 2006-04-03 | ABCO-DELISTED | Stock | 27.88 | 28.0 | 27.36 | 27.51 | 228629.0 |
| 2006-04-03 | ABCW-DELISTED | Stock | 30.36 | 30.4 | 29.96 | 30.05 | 46020.0 |
| 2006-04-03 | ABD-DELISTED | Stock | 22.3 | 22.46 | 22.06 | 22.2 | 195900.0 |
| 2006-04-03 | ABE-DELISTED | Stock | 12.67 | 12.9 | 12.67 | 12.82 | 61600.0 |
| 2006-04-03 | ABFS-DELISTED | Stock | 39.4 | 40.44 | 39.11 | 39.67 | 567700.0 |
| 2006-04-03 | ABG | Stock | 19.67 | 19.78 | 19.19 | 19.25 | 127900.0 |
| 2006-04-03 | ABK-DELISTED | Stock | 80.0 | 80.1 | 79.33 | 79.68 | 850000.0 |
| 2006-04-03 | ABM | Stock | 19.15 | 19.16 | 18.7 | 18.75 | 217700.0 |
| 2006-04-03 | ABMD-DELISTED | Stock | 12.96 | 13.18 | 12.8 | 12.9 | 141640.0 |
| 2006-04-03 | ABP-DELISTED | Stock | 5.83 | 5.93 | 5.61 | 5.64 | 378000.0 |
| 2006-04-03 | ABR | Stock | 27.0 | 27.05 | 26.85 | 26.94 | 136700.0 |
| 2006-04-03 | ABT | Stock | 20.3051 | 20.6794 | 20.3051 | 20.5834 | 10139225.0 |
| 2006-04-03 | ABTL-DELISTED | Stock | 24.03 | 24.18 | 23.12 | 23.37 | 33875.0 |
| 2006-04-03 | ABV-DELISTED | Stock | 42.93 | 44.51 | 42.93 | 44.5 | 507600.0 |
| 2006-04-03 | ABVA-DELISTED | Stock | 18.768 | 18.768 | 18.717 | 18.73 | 11336.0 |
| 2006-04-03 | ABX-DELISTED | Stock | 27.61 | 28.02 | 27.46 | 27.73 | 5531800.0 |
| 2006-04-03 | ACAD | Stock | 16.0 | 16.23 | 15.51 | 15.57 | 344400.0 |
| 2006-04-03 | ACAP-DELISTED | Stock | 47.8 | 48.38 | 47.65 | 47.82 | 31785.0 |
| 2006-04-03 | ACAS-DELISTED | Stock | 35.26 | 35.26 | 35.1 | 35.12 | 1389046.0 |
| 2006-04-03 | ACAT-DELISTED | Stock | 23.95 | 24.15 | 23.68 | 23.96 | 48610.0 |
| 2006-04-03 | ACC-DELISTED | Stock | 25.91 | 25.97 | 25.37 | 25.4 | 57700.0 |
| 2006-04-03 | ACCL-DELISTED | Stock | 7.32 | 7.32 | 7.11 | 7.2 | 111433.0 |
| 2006-04-03 | ACCO | Stock | 22.3 | 22.46 | 22.06 | 22.2 | 197900.0 |
> showing 50 of 4,413 rows — these rows as CSV