PREVIEW / stock_daily / 2006-10-30
file: by_date/stock_daily/2006/2006-10-30.parquet size: 153 KB rows: 4,590 symbols: 2,905
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-30 | AAPL | Stock | 2.8568 | 2.8893 | 2.8393 | 2.8721 | 499917600.0 |
| 2006-10-30 | MSFT | Stock | 28.35 | 28.84 | 28.32 | 28.53 | 47296800.0 |
| 2006-10-30 | NVDA | Stock | 0.5433 | 0.5558 | 0.5375 | 0.5462 | 479592000.0 |
| 2006-10-30 | AMZN | Stock | 1.9025 | 1.917 | 1.884 | 1.9075 | 137648000.0 |
| 2006-10-30 | CL | Stock | 31.61 | 31.94 | 31.585 | 31.9 | 3681800.0 |
| 2006-10-30 | A | Stock | 24.8927 | 25.093 | 24.7854 | 24.9642 | 1594978.0 |
| 2006-10-30 | AABA-DELISTED | Stock | 25.8700008392334 | 26.3999996185303 | 25.6599998474121 | 25.9500007629395 | 35295800.0 |
| 2006-10-30 | AACC-DELISTED | Stock | 17.51 | 17.9 | 17.41 | 17.89 | 81828.0 |
| 2006-10-30 | AACQ-DELISTED | Stock | 5.38 | 5.4 | 5.37 | 5.4 | 23550.0 |
| 2006-10-30 | AACQU-DELISTED | Stock | 6.22 | 6.4 | 6.22 | 6.4 | 10000.0 |
| 2006-10-30 | AACQW-DELISTED | Stock | 0.46 | 0.55 | 0.46 | 0.53 | 670440.0 |
| 2006-10-30 | AAI-DELISTED | Stock | 10.16 | 10.18 | 9.96 | 10.02 | 4460200.0 |
| 2006-10-30 | AAIC-DELISTED | Stock | 151.2 | 155.0 | 150.4 | 154.8 | 922300.0 |
| 2006-10-30 | AAME | Stock | 2.62 | 2.69 | 2.5 | 2.5 | 4700.0 |
| 2006-10-30 | AAON | Stock | 3.0367 | 3.1592 | 3.0288 | 3.1592 | 63787.0 |
| 2006-10-30 | AAP | Stock | 35.7 | 36.15 | 35.28 | 35.97 | 1093700.0 |
| 2006-10-30 | AATI-DELISTED | Stock | 6.19 | 6.23 | 6.0 | 6.05 | 448941.0 |
| 2006-10-30 | AAU-DELISTED | Stock | 2.43 | 2.45 | 2.4 | 2.44 | 62400.0 |
| 2006-10-30 | AAUAF-DELISTED | Stock | 2.43 | 2.45 | 2.4 | 2.44 | 62400.0 |
| 2006-10-30 | AAV-DELISTED | Stock | 14.25 | 14.25 | 13.67 | 13.7 | 715400.0 |
| 2006-10-30 | AAWW-DELISTED | Stock | 45.83 | 45.91 | 45.59 | 45.88 | 54163.0 |
| 2006-10-30 | AAXN-DELISTED | Stock | 9.60000038146973 | 9.82999992370605 | 9.55000019073486 | 9.67000007629395 | 772600.0 |
| 2006-10-30 | AB | Stock | 75.8 | 77.29 | 75.61 | 76.92 | 355500.0 |
| 2006-10-30 | ABAX-DELISTED | Stock | 20.01 | 20.35 | 19.93 | 20.08 | 249883.0 |
| 2006-10-30 | ABB-DELISTED | Stock | 14.87 | 15.0606 | 14.87 | 14.98 | 2302900.0 |
| 2006-10-30 | ABBC-DELISTED | Stock | 15.97 | 16.2 | 15.92 | 16.16 | 9195.0 |
| 2006-10-30 | ABC-DELISTED | Stock | 23.36 | 23.54 | 23.2 | 23.44 | 1440000.0 |
| 2006-10-30 | ABCB | Stock | 27.0006 | 27.3312 | 27.0006 | 27.1951 | 20357.0 |
| 2006-10-30 | ABCO-DELISTED | Stock | 27.01 | 27.01 | 26.22 | 26.36 | 562833.0 |
| 2006-10-30 | ABCW-DELISTED | Stock | 29.04 | 29.42 | 28.8 | 29.33 | 20440.0 |
| 2006-10-30 | ABD-DELISTED | Stock | 24.01 | 24.27 | 23.69 | 24.21 | 212260.0 |
| 2006-10-30 | ABE-DELISTED | Stock | 16.0 | 16.0 | 15.82 | 15.93 | 35600.0 |
| 2006-10-30 | ABFS-DELISTED | Stock | 40.95 | 41.99 | 40.75 | 41.67 | 622766.0 |
| 2006-10-30 | ABG | Stock | 23.8 | 24.28 | 23.7 | 24.28 | 396800.0 |
| 2006-10-30 | ABK-DELISTED | Stock | 83.97 | 84.27 | 83.56 | 83.94 | 579400.0 |
| 2006-10-30 | ABM | Stock | 19.7 | 20.0 | 19.65 | 20.0 | 169400.0 |
| 2006-10-30 | ABMD-DELISTED | Stock | 14.43 | 14.5 | 14.11 | 14.41 | 48659.0 |
| 2006-10-30 | ABP-DELISTED | Stock | 3.7 | 3.7 | 3.4 | 3.51 | 201200.0 |
| 2006-10-30 | ABR | Stock | 27.8 | 28.03 | 27.8 | 27.9 | 38900.0 |
| 2006-10-30 | ABT | Stock | 22.8145 | 22.8721 | 22.5266 | 22.5938 | 8939767.0 |
| 2006-10-30 | ABTL-DELISTED | Stock | 16.8 | 17.0 | 16.55 | 16.8 | 16600.0 |
| 2006-10-30 | ABV-DELISTED | Stock | 42.73 | 42.9 | 42.18 | 42.54 | 539900.0 |
| 2006-10-30 | ABVA-DELISTED | Stock | 16.35 | 16.83 | 16.35 | 16.83 | 1700.0 |
| 2006-10-30 | ABVT-DELISTED | Stock | 51.75 | 63.0 | 51.5 | 63.0 | 297.0 |
| 2006-10-30 | ABX-DELISTED | Stock | 30.14 | 30.65 | 30.04 | 30.2 | 4214400.0 |
| 2006-10-30 | ACAD | Stock | 9.57 | 9.58 | 9.29 | 9.45 | 113700.0 |
| 2006-10-30 | ACAP-DELISTED | Stock | 53.54 | 54.08 | 52.78 | 54.07 | 25280.0 |
| 2006-10-30 | ACAS-DELISTED | Stock | 42.75 | 43.02 | 42.71 | 42.81 | 643518.0 |
| 2006-10-30 | ACAT-DELISTED | Stock | 17.46 | 17.93 | 17.056 | 17.74 | 106185.0 |
| 2006-10-30 | ACC-DELISTED | Stock | 26.42 | 26.7 | 26.15 | 26.7 | 104903.0 |
> showing 50 of 4,590 rows — these rows as CSV