PREVIEW / stock_daily / 2005-08-03
file: by_date/stock_daily/2005/2005-08-03.parquet size: 140 KB rows: 4,173 symbols: 2,626
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-03 | AAPL | Stock | 1.5425 | 1.5468 | 1.5275 | 1.5436 | 258322400.0 |
| 2005-08-03 | MSFT | Stock | 26.76 | 27.43 | 26.73 | 27.25 | 139422400.0 |
| 2005-08-03 | NVDA | Stock | 0.232 | 0.2342 | 0.2299 | 0.232 | 518256000.0 |
| 2005-08-03 | AMZN | Stock | 2.3005 | 2.309 | 2.292 | 2.3055 | 96650000.0 |
| 2005-08-03 | CL | Stock | 26.895 | 26.895 | 26.425 | 26.56 | 4168800.0 |
| 2005-08-03 | A | Stock | 18.8913 | 19.1488 | 18.6838 | 19.1488 | 1961114.0 |
| 2005-08-03 | AABA-DELISTED | Stock | 33.75 | 34.6800003051758 | 33.7299995422363 | 34.5099983215332 | 18240600.0 |
| 2005-08-03 | AACC-DELISTED | Stock | 26.79 | 27.0 | 26.4 | 26.65 | 141171.0 |
| 2005-08-03 | AACQ-DELISTED | Stock | 5.09 | 5.09 | 5.05 | 5.05 | 7300.0 |
| 2005-08-03 | AACQW-DELISTED | Stock | 0.48 | 0.48 | 0.48 | 0.48 | 4600.0 |
| 2005-08-03 | AAI-DELISTED | Stock | 11.95 | 11.95 | 11.64 | 11.87 | 1002200.0 |
| 2005-08-03 | AAIC-DELISTED | Stock | 281.4 | 281.4 | 268.4 | 273.0 | 2554500.0 |
| 2005-08-03 | AAME | Stock | 3.0 | 3.02 | 3.0 | 3.0 | 1200.0 |
| 2005-08-03 | AAON | Stock | 2.2782 | 2.29 | 2.2123 | 2.2861 | 1116281.0 |
| 2005-08-03 | AAP | Stock | 47.2733 | 47.5733 | 47.1533 | 47.2933 | 799950.0 |
| 2005-08-03 | AAV-DELISTED | Stock | 14.96 | 15.09 | 14.19 | 14.96 | 58200.0 |
| 2005-08-03 | AAXN-DELISTED | Stock | 9.52000045776367 | 9.60000038146973 | 9.47000026702881 | 9.5 | 879700.0 |
| 2005-08-03 | ABAX-DELISTED | Stock | 13.14 | 13.25 | 12.96 | 13.16 | 111067.0 |
| 2005-08-03 | ABB-DELISTED | Stock | 7.17 | 7.26 | 7.13 | 7.22 | 1313200.0 |
| 2005-08-03 | ABBC-DELISTED | Stock | 12.84 | 12.98 | 12.82 | 12.98 | 14307.0 |
| 2005-08-03 | ABC-DELISTED | Stock | 17.95 | 18.04 | 17.87 | 18.02 | 1782800.0 |
| 2005-08-03 | ABCB | Stock | 19.2875 | 19.4334 | 19.2875 | 19.2875 | 5243.0 |
| 2005-08-03 | ABCO-DELISTED | Stock | 26.81 | 26.81 | 26.08 | 26.08 | 149285.0 |
| 2005-08-03 | ABCW-DELISTED | Stock | 32.28 | 32.31 | 31.75 | 31.88 | 41646.0 |
| 2005-08-03 | ABE-DELISTED | Stock | 10.79 | 10.87 | 10.63 | 10.76 | 13700.0 |
| 2005-08-03 | ABFS-DELISTED | Stock | 34.78 | 34.97 | 34.51 | 34.81 | 207866.0 |
| 2005-08-03 | ABG | Stock | 17.4 | 17.88 | 17.25 | 17.64 | 176300.0 |
| 2005-08-03 | ABK-DELISTED | Stock | 71.15 | 71.15 | 70.57 | 70.84 | 532900.0 |
| 2005-08-03 | ABM | Stock | 20.3 | 20.3 | 19.98 | 20.06 | 97200.0 |
| 2005-08-03 | ABMD-DELISTED | Stock | 10.29 | 10.93 | 10.2 | 10.85 | 181005.0 |
| 2005-08-03 | ABP-DELISTED | Stock | 4.59 | 4.77 | 4.58 | 4.67 | 509300.0 |
| 2005-08-03 | ABR | Stock | 31.06 | 31.2 | 30.85 | 31.2 | 114600.0 |
| 2005-08-03 | ABT | Stock | 22.5506 | 22.7281 | 22.5026 | 22.7089 | 4783243.0 |
| 2005-08-03 | ABTL-DELISTED | Stock | 28.03 | 29.27 | 27.38 | 29.07 | 35575.0 |
| 2005-08-03 | ABV-DELISTED | Stock | 31.96 | 32.74 | 31.96 | 32.51 | 295600.0 |
| 2005-08-03 | ABVA-DELISTED | Stock | 16.39 | 16.5 | 16.25 | 16.5 | 2900.0 |
| 2005-08-03 | ABX-DELISTED | Stock | 25.5 | 26.07 | 25.4 | 25.98 | 3832600.0 |
| 2005-08-03 | ACAD | Stock | 9.69 | 9.69 | 9.24 | 9.25 | 9100.0 |
| 2005-08-03 | ACAP-DELISTED | Stock | 39.44 | 39.86 | 39.07 | 39.75 | 92386.0 |
| 2005-08-03 | ACAS-DELISTED | Stock | 38.24 | 39.4 | 38.2 | 39.01 | 1484083.0 |
| 2005-08-03 | ACAT-DELISTED | Stock | 21.92 | 22.21 | 21.68 | 21.97 | 47081.0 |
| 2005-08-03 | ACC-DELISTED | Stock | 25.01 | 25.01 | 24.59 | 24.76 | 449600.0 |
| 2005-08-03 | ACCL-DELISTED | Stock | 5.4 | 5.5 | 5.2 | 5.26 | 127760.0 |
| 2005-08-03 | ACE-DELISTED | Stock | 46.88 | 47.29 | 46.65 | 46.96 | 774700.0 |
| 2005-08-03 | ACF-DELISTED | Stock | 27.08 | 27.19 | 26.77 | 26.78 | 568600.0 |
| 2005-08-03 | ACFC-DELISTED | Stock | 70.15 | 71.79 | 70.15 | 71.17 | 4279.0 |
| 2005-08-03 | ACG-DELISTED | Stock | 8.34 | 8.35 | 8.31 | 8.33 | 290000.0 |
| 2005-08-03 | ACGL | Stock | 5.0722 | 5.1178 | 5.0278 | 5.0644 | 1107900.0 |
| 2005-08-03 | ACGN-DELISTED | Stock | 589.3288 | 589.3288 | 566.6712 | 589.3288 | 55400.0 |
| 2005-08-03 | ACH | Stock | 20.1733 | 20.1733 | 19.7467 | 20.0333 | 216450.0 |
> showing 50 of 4,173 rows — these rows as CSV