PREVIEW / stock_daily / 2005-08-02
file: by_date/stock_daily/2005/2005-08-02.parquet size: 141 KB rows: 4,174 symbols: 2,624
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-02 | AAPL | Stock | 1.5318 | 1.5536 | 1.5218 | 1.5425 | 296875600.0 |
| 2005-08-02 | MSFT | Stock | 25.9 | 26.9 | 25.87 | 26.81 | 137510100.0 |
| 2005-08-02 | NVDA | Stock | 0.2292 | 0.2327 | 0.2288 | 0.232 | 422652000.0 |
| 2005-08-02 | AMZN | Stock | 2.245 | 2.3485 | 2.244 | 2.3255 | 216728000.0 |
| 2005-08-02 | CL | Stock | 26.515 | 26.575 | 26.285 | 26.47 | 3945800.0 |
| 2005-08-02 | A | Stock | 19.0415 | 19.1559 | 18.97 | 19.0486 | 1791677.0 |
| 2005-08-02 | AABA-DELISTED | Stock | 33.4599990844727 | 34.2000007629395 | 33.3899993896484 | 33.8800010681152 | 17581900.0 |
| 2005-08-02 | AACC-DELISTED | Stock | 28.1 | 28.1 | 26.8501 | 27.09 | 470701.0 |
| 2005-08-02 | AACQ-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 25070.0 |
| 2005-08-02 | AACQU-DELISTED | Stock | 5.9 | 5.9 | 5.87 | 5.87 | 3400.0 |
| 2005-08-02 | AAI-DELISTED | Stock | 11.8 | 11.98 | 11.75 | 11.95 | 1249600.0 |
| 2005-08-02 | AAIC-DELISTED | Stock | 276.6 | 281.52 | 274.8 | 281.4 | 1718200.0 |
| 2005-08-02 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 11400.0 |
| 2005-08-02 | AAON | Stock | 2.236 | 2.2874 | 2.0543 | 2.2387 | 2671481.0 |
| 2005-08-02 | AAP | Stock | 46.3333 | 47.7267 | 46.1067 | 47.2733 | 1411500.0 |
| 2005-08-02 | AAV-DELISTED | Stock | 15.0 | 15.95 | 14.36 | 15.0 | 106800.0 |
| 2005-08-02 | AAXN-DELISTED | Stock | 9.64999961853027 | 9.72000026702881 | 9.5 | 9.52999973297119 | 1727000.0 |
| 2005-08-02 | ABAX-DELISTED | Stock | 13.23 | 13.23 | 12.91 | 13.16 | 112889.0 |
| 2005-08-02 | ABB-DELISTED | Stock | 7.03 | 7.06 | 7.0 | 7.02 | 594200.0 |
| 2005-08-02 | ABBC-DELISTED | Stock | 12.55 | 12.81 | 12.55 | 12.81 | 15676.0 |
| 2005-08-02 | ABC-DELISTED | Stock | 17.88 | 18.06 | 17.87 | 18.0 | 2858800.0 |
| 2005-08-02 | ABCB | Stock | 19.4139 | 19.4529 | 19.2194 | 19.3653 | 5963.0 |
| 2005-08-02 | ABCO-DELISTED | Stock | 26.42 | 26.84 | 26.4 | 26.66 | 275310.0 |
| 2005-08-02 | ABCW-DELISTED | Stock | 32.83 | 33.01 | 31.84 | 32.65 | 30534.0 |
| 2005-08-02 | ABE-DELISTED | Stock | 10.78 | 10.81 | 10.66 | 10.69 | 20000.0 |
| 2005-08-02 | ABFS-DELISTED | Stock | 34.63 | 34.98 | 34.48 | 34.8 | 370904.0 |
| 2005-08-02 | ABG | Stock | 17.21 | 17.7 | 17.17 | 17.7 | 157700.0 |
| 2005-08-02 | ABK-DELISTED | Stock | 70.65 | 71.34 | 70.31 | 71.27 | 754200.0 |
| 2005-08-02 | ABM | Stock | 19.89 | 20.42 | 19.85 | 20.42 | 215400.0 |
| 2005-08-02 | ABMD-DELISTED | Stock | 9.9 | 10.44 | 9.73 | 10.2 | 265613.0 |
| 2005-08-02 | ABP-DELISTED | Stock | 4.55 | 4.65 | 4.45 | 4.55 | 425600.0 |
| 2005-08-02 | ABR | Stock | 30.83 | 31.1 | 30.83 | 31.04 | 86200.0 |
| 2005-08-02 | ABT | Stock | 22.6466 | 22.6993 | 22.589 | 22.6849 | 6762609.0 |
| 2005-08-02 | ABTL-DELISTED | Stock | 25.35 | 28.6 | 25.35 | 28.15 | 75069.0 |
| 2005-08-02 | ABV-DELISTED | Stock | 31.56 | 32.04 | 31.56 | 31.81 | 267000.0 |
| 2005-08-02 | ABVA-DELISTED | Stock | 16.43 | 16.44 | 16.4 | 16.4 | 600.0 |
| 2005-08-02 | ABX-DELISTED | Stock | 24.7 | 25.38 | 24.7 | 25.2 | 2210600.0 |
| 2005-08-02 | ACAD | Stock | 9.8 | 9.8 | 9.57 | 9.67 | 39000.0 |
| 2005-08-02 | ACAP-DELISTED | Stock | 39.79 | 40.08 | 39.38 | 39.41 | 89757.0 |
| 2005-08-02 | ACAS-DELISTED | Stock | 37.45 | 38.17 | 37.45 | 38.17 | 660414.0 |
| 2005-08-02 | ACAT-DELISTED | Stock | 22.17 | 22.45 | 21.7 | 21.91 | 74520.0 |
| 2005-08-02 | ACC-DELISTED | Stock | 25.14 | 25.2 | 24.73 | 24.95 | 84300.0 |
| 2005-08-02 | ACCL-DELISTED | Stock | 5.7 | 5.72 | 5.33 | 5.4 | 155010.0 |
| 2005-08-02 | ACE-DELISTED | Stock | 46.44 | 46.93 | 46.3 | 46.87 | 489485.0 |
| 2005-08-02 | ACF-DELISTED | Stock | 26.87 | 27.3 | 26.87 | 27.14 | 513100.0 |
| 2005-08-02 | ACFC-DELISTED | Stock | 71.43 | 71.43 | 70.05 | 70.31 | 1550.0 |
| 2005-08-02 | ACG-DELISTED | Stock | 8.38 | 8.38 | 8.36 | 8.362 | 347700.0 |
| 2005-08-02 | ACGL | Stock | 4.9967 | 5.0689 | 4.9333 | 5.0578 | 1269000.0 |
| 2005-08-02 | ACGN-DELISTED | Stock | 578.0 | 589.3288 | 566.6712 | 589.3288 | 46600.0 |
| 2005-08-02 | ACH | Stock | 19.86 | 20.3133 | 19.8 | 20.2067 | 364050.0 |
> showing 50 of 4,174 rows — these rows as CSV