PREVIEW / stock_daily / 2006-10-25
file: by_date/stock_daily/2006/2006-10-25.parquet size: 152 KB rows: 4,545 symbols: 2,864
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-10-25 | AAPL | Stock | 2.9054 | 2.9286 | 2.8932 | 2.9171 | 485214800.0 |
| 2006-10-25 | MSFT | Stock | 28.28 | 28.46 | 28.14 | 28.31 | 40717100.0 |
| 2006-10-25 | NVDA | Stock | 0.5468 | 0.555 | 0.5377 | 0.5467 | 389436000.0 |
| 2006-10-25 | AMZN | Stock | 1.865 | 1.899 | 1.802 | 1.884 | 930450000.0 |
| 2006-10-25 | CL | Stock | 30.875 | 31.36 | 30.765 | 31.085 | 8936600.0 |
| 2006-10-25 | A | Stock | 24.9642 | 25.0715 | 24.814 | 25.0572 | 2243790.0 |
| 2006-10-25 | AABA-DELISTED | Stock | 23.7299995422363 | 24.6399993896484 | 23.6900005340576 | 24.4899997711182 | 40110600.0 |
| 2006-10-25 | AACC-DELISTED | Stock | 16.96 | 17.21 | 16.68 | 17.08 | 208167.0 |
| 2006-10-25 | AACQU-DELISTED | Stock | 6.06 | 6.16 | 6.06 | 6.14 | 16600.0 |
| 2006-10-25 | AACQW-DELISTED | Stock | 0.405 | 0.44 | 0.405 | 0.43 | 175866.0 |
| 2006-10-25 | AAI-DELISTED | Stock | 11.11 | 11.29 | 10.75 | 10.97 | 1862700.0 |
| 2006-10-25 | AAIC-DELISTED | Stock | 152.2 | 159.2 | 152.2 | 158.0 | 1236400.0 |
| 2006-10-25 | AAON | Stock | 3.1539 | 3.1605 | 3.0867 | 3.1592 | 73659.0 |
| 2006-10-25 | AAP | Stock | 35.79 | 35.8 | 34.44 | 35.19 | 2206800.0 |
| 2006-10-25 | AATI-DELISTED | Stock | 5.59 | 5.63 | 5.45 | 5.55 | 134551.0 |
| 2006-10-25 | AAU-DELISTED | Stock | 2.4 | 2.46 | 2.4 | 2.43 | 32700.0 |
| 2006-10-25 | AAUAF-DELISTED | Stock | 2.4 | 2.46 | 2.4 | 2.43 | 32700.0 |
| 2006-10-25 | AAV-DELISTED | Stock | 14.0 | 14.4 | 13.95 | 14.25 | 809300.0 |
| 2006-10-25 | AAWW-DELISTED | Stock | 46.61 | 47.05 | 46.37 | 46.83 | 55403.0 |
| 2006-10-25 | AAXN-DELISTED | Stock | 9.89999961853027 | 10.1999998092651 | 9.44999980926514 | 9.44999980926514 | 6501600.0 |
| 2006-10-25 | AB | Stock | 76.29 | 76.5 | 74.75 | 74.88 | 304400.0 |
| 2006-10-25 | ABAX-DELISTED | Stock | 20.63 | 21.33 | 20.09 | 21.0 | 410273.0 |
| 2006-10-25 | ABB-DELISTED | Stock | 14.48 | 14.6 | 14.4 | 14.59 | 1133500.0 |
| 2006-10-25 | ABBC-DELISTED | Stock | 16.0 | 16.0 | 15.92 | 15.92 | 1630.0 |
| 2006-10-25 | ABC-DELISTED | Stock | 23.63 | 23.82 | 23.22 | 23.27 | 3269224.0 |
| 2006-10-25 | ABCB | Stock | 27.2048 | 27.234 | 26.9422 | 27.0978 | 16244.0 |
| 2006-10-25 | ABCO-DELISTED | Stock | 27.87 | 28.07 | 27.57 | 27.89 | 141308.0 |
| 2006-10-25 | ABCW-DELISTED | Stock | 29.09 | 29.3 | 28.89 | 29.22 | 16130.0 |
| 2006-10-25 | ABD-DELISTED | Stock | 24.18 | 24.37 | 24.15 | 24.25 | 252900.0 |
| 2006-10-25 | ABE-DELISTED | Stock | 15.4 | 15.57 | 15.38 | 15.57 | 24500.0 |
| 2006-10-25 | ABFS-DELISTED | Stock | 41.39 | 41.7399 | 40.17 | 40.63 | 549402.0 |
| 2006-10-25 | ABG | Stock | 23.9 | 24.26 | 23.82 | 24.18 | 421000.0 |
| 2006-10-25 | ABK-DELISTED | Stock | 84.66 | 84.73 | 81.56 | 83.22 | 1183300.0 |
| 2006-10-25 | ABM | Stock | 19.68 | 19.82 | 19.52 | 19.79 | 134200.0 |
| 2006-10-25 | ABMD-DELISTED | Stock | 14.1 | 14.32 | 13.7 | 13.94 | 83928.0 |
| 2006-10-25 | ABP-DELISTED | Stock | 3.55 | 3.84 | 3.54 | 3.79 | 334500.0 |
| 2006-10-25 | ABR | Stock | 27.39 | 27.92 | 27.39 | 27.9 | 53900.0 |
| 2006-10-25 | ABT | Stock | 23.016 | 23.1983 | 22.8817 | 23.1647 | 8839100.0 |
| 2006-10-25 | ABTL-DELISTED | Stock | 16.447 | 16.85 | 16.447 | 16.8 | 6677.0 |
| 2006-10-25 | ABV-DELISTED | Stock | 44.08 | 44.22 | 43.0 | 43.54 | 980500.0 |
| 2006-10-25 | ABVA-DELISTED | Stock | 17.1 | 17.1 | 16.99 | 16.99 | 900.0 |
| 2006-10-25 | ABX-DELISTED | Stock | 30.01 | 30.72 | 29.79 | 30.66 | 5024028.0 |
| 2006-10-25 | ACAD | Stock | 9.54 | 9.58 | 9.24 | 9.35 | 146800.0 |
| 2006-10-25 | ACAP-DELISTED | Stock | 51.35 | 52.48 | 51.35 | 52.48 | 16022.0 |
| 2006-10-25 | ACAS-DELISTED | Stock | 42.22 | 42.27 | 42.04 | 42.18 | 534627.0 |
| 2006-10-25 | ACAT-DELISTED | Stock | 17.67 | 18.87 | 17.1 | 17.26 | 636078.0 |
| 2006-10-25 | ACC-DELISTED | Stock | 26.51 | 26.85 | 26.28 | 26.61 | 78800.0 |
| 2006-10-25 | ACCL-DELISTED | Stock | 6.09 | 6.22 | 6.05 | 6.12 | 45979.0 |
| 2006-10-25 | ACCO | Stock | 24.18 | 24.37 | 24.15 | 24.25 | 270700.0 |
| 2006-10-25 | ACCP-DELISTED | Stock | 1.05 | 1.1 | 0.91 | 1.1 | 14363.0 |
> showing 50 of 4,545 rows — these rows as CSV