PREVIEW / stock_daily / 2006-06-02
file: by_date/stock_daily/2006/2006-06-02.parquet size: 147 KB rows: 4,412 symbols: 2,776
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-06-02 | AAPL | Stock | 2.2496 | 2.2536 | 2.1743 | 2.2021 | 685787200.0 |
| 2006-06-02 | MSFT | Stock | 22.87 | 22.99 | 22.67 | 22.76 | 73935600.0 |
| 2006-06-02 | NVDA | Stock | 0.4095 | 0.4115 | 0.3932 | 0.3972 | 673710000.0 |
| 2006-06-02 | AMZN | Stock | 1.7595 | 1.761 | 1.7025 | 1.738 | 108858000.0 |
| 2006-06-02 | CL | Stock | 30.5 | 30.5 | 29.855 | 30.11 | 3433600.0 |
| 2006-06-02 | A | Stock | 25.1001 | 25.4721 | 24.9499 | 25.4077 | 3670729.0 |
| 2006-06-02 | AABA-DELISTED | Stock | 32.1100006103516 | 32.189998626709 | 31.2999992370605 | 31.5200004577637 | 16470900.0 |
| 2006-06-02 | AACC-DELISTED | Stock | 17.95 | 18.0 | 17.3 | 17.55 | 240246.0 |
| 2006-06-02 | AACQU-DELISTED | Stock | 6.37 | 6.37 | 6.37 | 6.37 | 1800.0 |
| 2006-06-02 | AAI-DELISTED | Stock | 12.63 | 12.7 | 11.98 | 12.14 | 1448000.0 |
| 2006-06-02 | AAIC-DELISTED | Stock | 222.6 | 223.0 | 215.0 | 216.8 | 828000.0 |
| 2006-06-02 | AAME | Stock | 2.99 | 3.01 | 2.99 | 3.01 | 1300.0 |
| 2006-06-02 | AAON | Stock | 3.1763 | 3.2119 | 3.0696 | 3.2066 | 100237.0 |
| 2006-06-02 | AAP | Stock | 38.0 | 38.14 | 37.47 | 38.0 | 870500.0 |
| 2006-06-02 | AATI-DELISTED | Stock | 11.7 | 11.78 | 11.2 | 11.52 | 136483.0 |
| 2006-06-02 | AAU-DELISTED | Stock | 2.5 | 2.57 | 2.5 | 2.56 | 80100.0 |
| 2006-06-02 | AAUAF-DELISTED | Stock | 2.5 | 2.57 | 2.5 | 2.56 | 80100.0 |
| 2006-06-02 | AAV-DELISTED | Stock | 18.75 | 18.97 | 18.75 | 18.94 | 242200.0 |
| 2006-06-02 | AAWW-DELISTED | Stock | 51.22 | 51.24 | 50.96 | 51.04 | 70930.0 |
| 2006-06-02 | AAXN-DELISTED | Stock | 9.81999969482422 | 9.88000011444092 | 9.60000038146973 | 9.65999984741211 | 483500.0 |
| 2006-06-02 | AB | Stock | 65.41 | 66.09 | 64.69 | 65.33 | 106200.0 |
| 2006-06-02 | ABAX-DELISTED | Stock | 17.3 | 18.16 | 17.3 | 17.83 | 398231.0 |
| 2006-06-02 | ABB-DELISTED | Stock | 12.7 | 12.71 | 12.47 | 12.57 | 1486800.0 |
| 2006-06-02 | ABBC-DELISTED | Stock | 14.15 | 14.75 | 14.15 | 14.7 | 49284.0 |
| 2006-06-02 | ABC-DELISTED | Stock | 21.9 | 21.97 | 21.76 | 21.88 | 1593800.0 |
| 2006-06-02 | ABCB | Stock | 21.8261 | 22.0109 | 21.4176 | 21.9331 | 17067.0 |
| 2006-06-02 | ABCO-DELISTED | Stock | 27.04 | 27.3 | 26.18 | 26.25 | 201745.0 |
| 2006-06-02 | ABCW-DELISTED | Stock | 30.61 | 30.62 | 29.94 | 30.58 | 34000.0 |
| 2006-06-02 | ABD-DELISTED | Stock | 23.0 | 23.09 | 22.67 | 22.85 | 358030.0 |
| 2006-06-02 | ABE-DELISTED | Stock | 12.62 | 13.0 | 12.5001 | 12.83 | 40000.0 |
| 2006-06-02 | ABFS-DELISTED | Stock | 42.34 | 43.84 | 42.15 | 43.8 | 487928.0 |
| 2006-06-02 | ABG | Stock | 21.45 | 21.6 | 21.26 | 21.59 | 165800.0 |
| 2006-06-02 | ABK-DELISTED | Stock | 80.99 | 81.0 | 79.5 | 80.15 | 596800.0 |
| 2006-06-02 | ABM | Stock | 17.74 | 17.89 | 17.48 | 17.79 | 167300.0 |
| 2006-06-02 | ABMD-DELISTED | Stock | 13.43 | 13.75 | 13.06 | 13.74 | 92807.0 |
| 2006-06-02 | ABP-DELISTED | Stock | 4.78 | 4.85 | 4.77 | 4.84 | 198100.0 |
| 2006-06-02 | ABR | Stock | 24.55 | 24.7 | 24.3 | 24.6 | 130500.0 |
| 2006-06-02 | ABT | Stock | 20.6794 | 20.7993 | 20.5786 | 20.6938 | 7084619.0 |
| 2006-06-02 | ABTL-DELISTED | Stock | 16.026 | 16.176 | 15.174 | 15.174 | 32598.0 |
| 2006-06-02 | ABV-DELISTED | Stock | 44.25 | 44.25 | 42.91 | 43.43 | 626300.0 |
| 2006-06-02 | ABVA-DELISTED | Stock | 19.06 | 19.2 | 18.86 | 18.86 | 4319.0 |
| 2006-06-02 | ABX-DELISTED | Stock | 31.09 | 31.1 | 30.55 | 30.66 | 4574900.0 |
| 2006-06-02 | ACAD | Stock | 10.51 | 10.51 | 10.26 | 10.35 | 96800.0 |
| 2006-06-02 | ACAP-DELISTED | Stock | 47.03 | 47.52 | 45.83 | 46.53 | 33704.0 |
| 2006-06-02 | ACAS-DELISTED | Stock | 34.26 | 34.48 | 34.24 | 34.39 | 749120.0 |
| 2006-06-02 | ACAT-DELISTED | Stock | 18.73 | 18.92 | 18.5 | 18.68 | 40642.0 |
| 2006-06-02 | ACC-DELISTED | Stock | 24.43 | 25.0 | 24.28 | 24.5 | 73700.0 |
| 2006-06-02 | ACCL-DELISTED | Stock | 7.43 | 7.61 | 7.28 | 7.49 | 141888.0 |
| 2006-06-02 | ACCO | Stock | 23.0 | 23.09 | 22.67 | 22.85 | 358600.0 |
| 2006-06-02 | ACCP-DELISTED | Stock | 0.95 | 1.05 | 0.95 | 1.0 | 32150.0 |
> showing 50 of 4,412 rows — these rows as CSV