PREVIEW / stock_daily / 2005-09-23
file: by_date/stock_daily/2005/2005-09-23.parquet size: 140 KB rows: 4,190 symbols: 2,640
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-09-23 | AAPL | Stock | 1.8607 | 1.9107 | 1.8514 | 1.9 | 558457200.0 |
| 2005-09-23 | MSFT | Stock | 25.31 | 25.54 | 25.12 | 25.27 | 66396800.0 |
| 2005-09-23 | NVDA | Stock | 0.2681 | 0.2749 | 0.2658 | 0.2726 | 314640000.0 |
| 2005-09-23 | AMZN | Stock | 2.0985 | 2.131 | 2.0775 | 2.1095 | 62908000.0 |
| 2005-09-23 | CL | Stock | 26.07 | 26.175 | 25.83 | 26.04 | 2368000.0 |
| 2005-09-23 | A | Stock | 23.9628 | 24.2632 | 23.8412 | 24.0987 | 4984289.0 |
| 2005-09-23 | AABA-DELISTED | Stock | 32.1199989318848 | 32.25 | 31.75 | 32.1300010681152 | 14903700.0 |
| 2005-09-23 | AACC-DELISTED | Stock | 27.95 | 29.35 | 27.92 | 28.92 | 152326.0 |
| 2005-09-23 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 12500.0 |
| 2005-09-23 | AACQU-DELISTED | Stock | 6.3 | 6.3 | 6.3 | 6.3 | 11000.0 |
| 2005-09-23 | AACQW-DELISTED | Stock | 0.61 | 0.61 | 0.61 | 0.61 | 22500.0 |
| 2005-09-23 | AAI-DELISTED | Stock | 10.65 | 11.2 | 10.54 | 10.95 | 1932500.0 |
| 2005-09-23 | AAIC-DELISTED | Stock | 218.4 | 218.4 | 192.8 | 207.0 | 4113400.0 |
| 2005-09-23 | AAME | Stock | 2.86 | 2.9 | 2.86 | 2.9 | 400.0 |
| 2005-09-23 | AAON | Stock | 2.2848 | 2.3677 | 2.2611 | 2.3559 | 217941.0 |
| 2005-09-23 | AAP | Stock | 39.0867 | 40.04 | 38.7667 | 39.5667 | 608550.0 |
| 2005-09-23 | AATI-DELISTED | Stock | 11.51 | 11.94 | 11.35 | 11.81 | 145075.0 |
| 2005-09-23 | AAV-DELISTED | Stock | 17.7 | 18.11 | 17.6 | 17.7 | 63000.0 |
| 2005-09-23 | AAXN-DELISTED | Stock | 7.21000003814697 | 7.26999998092651 | 7.1100001335144 | 7.23999977111816 | 1078900.0 |
| 2005-09-23 | ABAX-DELISTED | Stock | 12.89 | 13.23 | 12.84 | 13.1 | 70692.0 |
| 2005-09-23 | ABB-DELISTED | Stock | 7.17 | 7.21 | 7.14 | 7.19 | 719300.0 |
| 2005-09-23 | ABBC-DELISTED | Stock | 12.64 | 12.74 | 12.64 | 12.66 | 1400.0 |
| 2005-09-23 | ABC-DELISTED | Stock | 19.31 | 19.35 | 19.25 | 19.3 | 4116800.0 |
| 2005-09-23 | ABCB | Stock | 18.1689 | 18.1689 | 17.6437 | 18.0619 | 7814.0 |
| 2005-09-23 | ABCO-DELISTED | Stock | 23.93 | 24.83 | 23.85 | 24.58 | 164035.0 |
| 2005-09-23 | ABCW-DELISTED | Stock | 29.04 | 29.28 | 29.01 | 29.1 | 32220.0 |
| 2005-09-23 | ABD-DELISTED | Stock | 27.45 | 28.25 | 27.4 | 27.76 | 372150.0 |
| 2005-09-23 | ABE-DELISTED | Stock | 10.93 | 10.99 | 10.86 | 10.86 | 45300.0 |
| 2005-09-23 | ABFS-DELISTED | Stock | 32.51 | 33.28 | 32.35 | 33.04 | 233641.0 |
| 2005-09-23 | ABG | Stock | 16.51 | 17.04 | 16.51 | 16.91 | 67300.0 |
| 2005-09-23 | ABK-DELISTED | Stock | 68.88 | 69.95 | 68.84 | 69.75 | 557000.0 |
| 2005-09-23 | ABM | Stock | 20.52 | 20.68 | 20.29 | 20.51 | 102800.0 |
| 2005-09-23 | ABMD-DELISTED | Stock | 9.98 | 10.14 | 9.92 | 10.09 | 36046.0 |
| 2005-09-23 | ABP-DELISTED | Stock | 5.6 | 5.75 | 5.53 | 5.72 | 586600.0 |
| 2005-09-23 | ABR | Stock | 28.25 | 28.51 | 28.05 | 28.27 | 64800.0 |
| 2005-09-23 | ABT | Stock | 21.1016 | 21.3655 | 21.0728 | 21.2168 | 9817424.0 |
| 2005-09-23 | ABTL-DELISTED | Stock | 24.45 | 25.5 | 24.25 | 25.05 | 30489.0 |
| 2005-09-23 | ABV-DELISTED | Stock | 35.78 | 36.05 | 35.75 | 36.01 | 845200.0 |
| 2005-09-23 | ABVA-DELISTED | Stock | 16.23 | 16.23 | 16.23 | 16.23 | 250.0 |
| 2005-09-23 | ABX-DELISTED | Stock | 28.17 | 28.75 | 27.88 | 28.67 | 2700900.0 |
| 2005-09-23 | ACAD | Stock | 10.97 | 11.04 | 10.85 | 10.87 | 163500.0 |
| 2005-09-23 | ACAP-DELISTED | Stock | 47.52 | 48.29 | 46.3 | 47.92 | 70174.0 |
| 2005-09-23 | ACAS-DELISTED | Stock | 36.71 | 37.31 | 36.46 | 37.18 | 652373.0 |
| 2005-09-23 | ACAT-DELISTED | Stock | 20.17 | 20.5 | 19.64 | 20.21 | 250029.0 |
| 2005-09-23 | ACC-DELISTED | Stock | 22.6 | 22.6 | 22.28 | 22.51 | 118000.0 |
| 2005-09-23 | ACCL-DELISTED | Stock | 5.8 | 6.17 | 5.8 | 6.09 | 102477.0 |
| 2005-09-23 | ACCO | Stock | 27.45 | 28.25 | 27.4 | 27.76 | 371700.0 |
| 2005-09-23 | ACE-DELISTED | Stock | 43.64 | 46.49 | 43.53 | 45.83 | 3066549.0 |
| 2005-09-23 | ACF-DELISTED | Stock | 24.03 | 24.1 | 23.83 | 23.99 | 1005900.0 |
| 2005-09-23 | ACFC-DELISTED | Stock | 70.66 | 71.53 | 70.66 | 71.22 | 2730.0 |
> showing 50 of 4,190 rows — these rows as CSV