PREVIEW / stock_daily / 2005-09-30
file: by_date/stock_daily/2005/2005-09-30.parquet size: 141 KB rows: 4,199 symbols: 2,642
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-30 | AAPL | Stock | 1.8689 | 1.9161 | 1.8529 | 1.9146 | 531633200.0 |
| 2005-09-30 | MSFT | Stock | 25.91 | 25.95 | 25.61 | 25.73 | 57644500.0 |
| 2005-09-30 | NVDA | Stock | 0.2833 | 0.2882 | 0.2827 | 0.2857 | 458832000.0 |
| 2005-09-30 | AMZN | Stock | 2.2325 | 2.292 | 2.23 | 2.265 | 121120000.0 |
| 2005-09-30 | CL | Stock | 26.215 | 26.405 | 25.91 | 26.395 | 3272200.0 |
| 2005-09-30 | A | Stock | 23.3834 | 23.598 | 23.3405 | 23.4263 | 6801130.0 |
| 2005-09-30 | AABA-DELISTED | Stock | 33.5900001525879 | 34.0999984741211 | 33.560001373291 | 33.8400001525879 | 15697000.0 |
| 2005-09-30 | AACC-DELISTED | Stock | 29.81 | 30.6 | 29.81 | 29.95 | 128430.0 |
| 2005-09-30 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 2000.0 |
| 2005-09-30 | AACQU-DELISTED | Stock | 6.27 | 6.28 | 6.27 | 6.28 | 2500.0 |
| 2005-09-30 | AACQW-DELISTED | Stock | 0.59 | 0.59 | 0.59 | 0.59 | 52500.0 |
| 2005-09-30 | AAI-DELISTED | Stock | 12.08 | 12.7 | 11.99 | 12.66 | 2256700.0 |
| 2005-09-30 | AAIC-DELISTED | Stock | 204.8 | 209.0 | 201.6 | 203.8 | 1603400.0 |
| 2005-09-30 | AAME | Stock | 2.91 | 2.94 | 2.61 | 2.94 | 1500.0 |
| 2005-09-30 | AAON | Stock | 2.3941 | 2.4362 | 2.3888 | 2.4204 | 80494.0 |
| 2005-09-30 | AAP | Stock | 38.3 | 39.02 | 38.28 | 38.68 | 759200.0 |
| 2005-09-30 | AATI-DELISTED | Stock | 12.0 | 12.04 | 11.05 | 11.23 | 552446.0 |
| 2005-09-30 | AAV-DELISTED | Stock | 18.23 | 18.5 | 18.21 | 18.23 | 60200.0 |
| 2005-09-30 | AAXN-DELISTED | Stock | 6.25 | 6.26000022888184 | 6.03999996185303 | 6.17000007629395 | 1775700.0 |
| 2005-09-30 | ABAX-DELISTED | Stock | 12.9 | 13.05 | 12.83 | 13.05 | 57408.0 |
| 2005-09-30 | ABB-DELISTED | Stock | 7.31 | 7.39 | 7.31 | 7.36 | 1327900.0 |
| 2005-09-30 | ABBC-DELISTED | Stock | 12.5 | 12.54 | 12.5 | 12.53 | 3600.0 |
| 2005-09-30 | ABC-DELISTED | Stock | 19.26 | 19.45 | 19.25 | 19.33 | 3203600.0 |
| 2005-09-30 | ABCB | Stock | 18.5094 | 18.7428 | 18.4024 | 18.665 | 19123.0 |
| 2005-09-30 | ABCO-DELISTED | Stock | 25.73 | 26.19 | 25.46 | 26.01 | 193052.0 |
| 2005-09-30 | ABCW-DELISTED | Stock | 29.44 | 29.52 | 29.26 | 29.47 | 15390.0 |
| 2005-09-30 | ABD-DELISTED | Stock | 27.8 | 28.51 | 27.8 | 28.22 | 269500.0 |
| 2005-09-30 | ABE-DELISTED | Stock | 11.25 | 11.262 | 11.14 | 11.262 | 24100.0 |
| 2005-09-30 | ABFS-DELISTED | Stock | 34.43 | 34.94 | 34.23 | 34.85 | 144440.0 |
| 2005-09-30 | ABG | Stock | 17.07 | 17.07 | 16.72 | 17.03 | 63300.0 |
| 2005-09-30 | ABK-DELISTED | Stock | 72.23 | 72.47 | 71.7 | 72.11 | 580900.0 |
| 2005-09-30 | ABM | Stock | 20.88 | 20.88 | 20.5 | 20.81 | 118000.0 |
| 2005-09-30 | ABMD-DELISTED | Stock | 9.96 | 10.23 | 9.84 | 10.04 | 141624.0 |
| 2005-09-30 | ABP-DELISTED | Stock | 8.91 | 8.95 | 7.5 | 7.97 | 7468100.0 |
| 2005-09-30 | ABR | Stock | 28.6 | 28.65 | 28.0 | 28.1 | 86000.0 |
| 2005-09-30 | ABT | Stock | 20.1276 | 20.4107 | 19.9597 | 20.3435 | 12685702.0 |
| 2005-09-30 | ABTL-DELISTED | Stock | 24.85 | 25.1 | 24.7 | 25.0 | 50404.0 |
| 2005-09-30 | ABV-DELISTED | Stock | 37.29 | 37.35 | 36.82 | 37.17 | 409500.0 |
| 2005-09-30 | ABVA-DELISTED | Stock | 16.46 | 16.6 | 16.46 | 16.6 | 1170.0 |
| 2005-09-30 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2005-09-30 | ABX-DELISTED | Stock | 29.3 | 29.47 | 28.92 | 29.0 | 1680000.0 |
| 2005-09-30 | ACAD | Stock | 11.28 | 11.69 | 11.2 | 11.37 | 119100.0 |
| 2005-09-30 | ACAP-DELISTED | Stock | 46.45 | 50.55 | 45.8 | 49.01 | 257745.0 |
| 2005-09-30 | ACAS-DELISTED | Stock | 36.18 | 36.86 | 36.1797 | 36.63 | 471990.0 |
| 2005-09-30 | ACAT-DELISTED | Stock | 20.5 | 20.57 | 20.4 | 20.54 | 148208.0 |
| 2005-09-30 | ACC-DELISTED | Stock | 23.25 | 24.07 | 23.25 | 24.0 | 98400.0 |
| 2005-09-30 | ACCL-DELISTED | Stock | 6.69 | 6.84 | 6.56 | 6.75 | 90720.0 |
| 2005-09-30 | ACCO | Stock | 27.8 | 28.51 | 27.8 | 28.22 | 269500.0 |
| 2005-09-30 | ACE-DELISTED | Stock | 46.63 | 47.09 | 46.32 | 47.09 | 1146170.0 |
| 2005-09-30 | ACF-DELISTED | Stock | 23.84 | 24.0 | 23.63 | 23.86 | 1375100.0 |
> showing 50 of 4,199 rows — these rows as CSV