PREVIEW / stock_daily / 2005-09-26
file: by_date/stock_daily/2005/2005-09-26.parquet size: 140 KB rows: 4,201 symbols: 2,643
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-26 | AAPL | Stock | 1.9296 | 1.9486 | 1.9043 | 1.9229 | 546562800.0 |
| 2005-09-26 | MSFT | Stock | 25.4 | 25.49 | 25.21 | 25.27 | 56203700.0 |
| 2005-09-26 | NVDA | Stock | 0.2747 | 0.2767 | 0.2697 | 0.2748 | 406776000.0 |
| 2005-09-26 | AMZN | Stock | 2.1225 | 2.171 | 2.12 | 2.167 | 112328000.0 |
| 2005-09-26 | CL | Stock | 26.15 | 26.22 | 25.595 | 25.675 | 3897200.0 |
| 2005-09-26 | A | Stock | 24.1774 | 24.3062 | 23.9342 | 24.0343 | 3827025.0 |
| 2005-09-26 | AABA-DELISTED | Stock | 32.4799995422363 | 32.5499992370605 | 31.9899997711182 | 32.1800003051758 | 13548200.0 |
| 2005-09-26 | AACC-DELISTED | Stock | 29.14 | 29.56 | 28.84 | 29.24 | 123118.0 |
| 2005-09-26 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 14000.0 |
| 2005-09-26 | AACQU-DELISTED | Stock | 6.28 | 6.28 | 6.27 | 6.275 | 6500.0 |
| 2005-09-26 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 37000.0 |
| 2005-09-26 | AAI-DELISTED | Stock | 11.15 | 11.91 | 11.11 | 11.69 | 2959900.0 |
| 2005-09-26 | AAIC-DELISTED | Stock | 207.4 | 216.8 | 207.0 | 210.4 | 1945000.0 |
| 2005-09-26 | AAME | Stock | 2.9 | 2.91 | 2.84 | 2.91 | 800.0 |
| 2005-09-26 | AAON | Stock | 2.373 | 2.373 | 2.344 | 2.3717 | 25819.0 |
| 2005-09-26 | AAP | Stock | 40.5 | 40.8 | 38.67 | 39.0 | 1087200.0 |
| 2005-09-26 | AATI-DELISTED | Stock | 11.75 | 12.5 | 11.75 | 12.36 | 87011.0 |
| 2005-09-26 | AAV-DELISTED | Stock | 17.61 | 17.69 | 16.87 | 17.61 | 88600.0 |
| 2005-09-26 | AAXN-DELISTED | Stock | 7.42999982833862 | 7.53000020980835 | 7.21000003814697 | 7.30999994277954 | 1337700.0 |
| 2005-09-26 | ABAX-DELISTED | Stock | 13.16 | 13.17 | 12.71 | 12.84 | 120320.0 |
| 2005-09-26 | ABB-DELISTED | Stock | 7.22 | 7.24 | 7.15 | 7.2 | 922000.0 |
| 2005-09-26 | ABBC-DELISTED | Stock | 12.6 | 12.72 | 12.6 | 12.68 | 2763.0 |
| 2005-09-26 | ABC-DELISTED | Stock | 19.25 | 19.4 | 19.2 | 19.29 | 2525200.0 |
| 2005-09-26 | ABCB | Stock | 18.2857 | 18.6261 | 18.0231 | 18.2565 | 17478.0 |
| 2005-09-26 | ABCO-DELISTED | Stock | 24.72 | 24.88 | 24.26 | 24.47 | 164503.0 |
| 2005-09-26 | ABCW-DELISTED | Stock | 29.45 | 29.78 | 29.09 | 29.34 | 51350.0 |
| 2005-09-26 | ABD-DELISTED | Stock | 27.76 | 28.4 | 27.76 | 27.9 | 302020.0 |
| 2005-09-26 | ABE-DELISTED | Stock | 10.94 | 10.96 | 10.89 | 10.93 | 97100.0 |
| 2005-09-26 | ABFS-DELISTED | Stock | 33.25 | 33.9 | 33.11 | 33.58 | 281575.0 |
| 2005-09-26 | ABG | Stock | 17.1 | 17.99 | 16.96 | 17.37 | 96000.0 |
| 2005-09-26 | ABK-DELISTED | Stock | 70.0 | 70.88 | 69.57 | 69.89 | 680900.0 |
| 2005-09-26 | ABM | Stock | 20.65 | 20.71 | 20.37 | 20.56 | 131500.0 |
| 2005-09-26 | ABMD-DELISTED | Stock | 10.11 | 10.14 | 10.0 | 10.08 | 28883.0 |
| 2005-09-26 | ABP-DELISTED | Stock | 5.75 | 5.97 | 5.65 | 5.92 | 657300.0 |
| 2005-09-26 | ABR | Stock | 28.3 | 28.51 | 28.2 | 28.2 | 59300.0 |
| 2005-09-26 | ABT | Stock | 20.8569 | 21.0152 | 20.3339 | 20.4683 | 19637557.0 |
| 2005-09-26 | ABTL-DELISTED | Stock | 25.15 | 25.2 | 24.75 | 25.0 | 15141.0 |
| 2005-09-26 | ABV-DELISTED | Stock | 36.01 | 36.43 | 35.99 | 36.13 | 550600.0 |
| 2005-09-26 | ABVA-DELISTED | Stock | 16.23 | 16.23 | 16.2 | 16.2 | 500.0 |
| 2005-09-26 | ABX-DELISTED | Stock | 28.28 | 29.47 | 28.12 | 28.89 | 3837300.0 |
| 2005-09-26 | ACAD | Stock | 11.0 | 11.01 | 10.63 | 10.99 | 90300.0 |
| 2005-09-26 | ACAP-DELISTED | Stock | 48.01 | 49.51 | 48.0 | 48.73 | 101301.0 |
| 2005-09-26 | ACAS-DELISTED | Stock | 37.4 | 37.41 | 36.62 | 36.8 | 407287.0 |
| 2005-09-26 | ACAT-DELISTED | Stock | 20.38 | 20.64 | 20.0 | 20.13 | 165733.0 |
| 2005-09-26 | ACC-DELISTED | Stock | 22.65 | 22.96 | 22.62 | 22.95 | 62900.0 |
| 2005-09-26 | ACCL-DELISTED | Stock | 6.0 | 6.19 | 6.0 | 6.17 | 50524.0 |
| 2005-09-26 | ACCO | Stock | 27.76 | 28.4 | 27.76 | 27.9 | 302500.0 |
| 2005-09-26 | ACE-DELISTED | Stock | 46.5 | 46.96 | 45.25 | 45.85 | 1746400.0 |
| 2005-09-26 | ACF-DELISTED | Stock | 24.11 | 24.34 | 23.96 | 24.1 | 899400.0 |
| 2005-09-26 | ACFC-DELISTED | Stock | 71.53 | 71.53 | 70.92 | 70.92 | 848.0 |
> showing 50 of 4,201 rows — these rows as CSV