PREVIEW / stock_daily / 2005-11-07
file: by_date/stock_daily/2005/2005-11-07.parquet size: 141 KB rows: 4,247 symbols: 2,680
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-11-07 | AAPL | Stock | 2.1732 | 2.2025 | 2.1479 | 2.1511 | 638831200.0 |
| 2005-11-07 | MSFT | Stock | 26.72 | 27.08 | 26.7 | 27.01 | 77104800.0 |
| 2005-11-07 | NVDA | Stock | 0.2853 | 0.2863 | 0.2814 | 0.2826 | 370824000.0 |
| 2005-11-07 | AMZN | Stock | 2.054 | 2.0735 | 2.0275 | 2.0695 | 67722000.0 |
| 2005-11-07 | CL | Stock | 25.975 | 26.01 | 25.595 | 25.985 | 4898000.0 |
| 2005-11-07 | A | Stock | 23.319 | 23.5694 | 23.2403 | 23.5336 | 2348500.0 |
| 2005-11-07 | AABA-DELISTED | Stock | 37.689998626709 | 38.1800003051758 | 37.4099998474121 | 37.9000015258789 | 11652700.0 |
| 2005-11-07 | AACC-DELISTED | Stock | 18.36 | 18.53 | 18.15 | 18.21 | 245922.0 |
| 2005-11-07 | AACQ-DELISTED | Stock | 5.16 | 5.16 | 5.16 | 5.16 | 1000.0 |
| 2005-11-07 | AAI-DELISTED | Stock | 15.1 | 15.33 | 14.84 | 15.1 | 1392700.0 |
| 2005-11-07 | AAIC-DELISTED | Stock | 179.8 | 181.6 | 175.4 | 177.6 | 868400.0 |
| 2005-11-07 | AAON | Stock | 2.3453 | 2.3612 | 2.2914 | 2.2979 | 94922.0 |
| 2005-11-07 | AAP | Stock | 40.5 | 40.5 | 39.7 | 40.05 | 1243500.0 |
| 2005-11-07 | AATI-DELISTED | Stock | 10.4 | 11.2 | 10.4 | 11.07 | 111498.0 |
| 2005-11-07 | AAV-DELISTED | Stock | 16.18 | 16.49 | 16.07 | 16.18 | 23600.0 |
| 2005-11-07 | AAXN-DELISTED | Stock | 8.35000038146973 | 8.60999965667725 | 7.67999982833862 | 7.92000007629395 | 9342700.0 |
| 2005-11-07 | ABAX-DELISTED | Stock | 16.84 | 16.96 | 16.26 | 16.4 | 318869.0 |
| 2005-11-07 | ABB-DELISTED | Stock | 7.94 | 7.979 | 7.89 | 7.97 | 1974400.0 |
| 2005-11-07 | ABBC-DELISTED | Stock | 11.97 | 12.14 | 11.97 | 12.13 | 10718.0 |
| 2005-11-07 | ABC-DELISTED | Stock | 19.19 | 19.32 | 19.08 | 19.14 | 4624800.0 |
| 2005-11-07 | ABCB | Stock | 19.3458 | 19.3555 | 18.9568 | 19.1222 | 7608.0 |
| 2005-11-07 | ABCO-DELISTED | Stock | 24.26 | 24.41 | 23.92 | 24.07 | 165108.0 |
| 2005-11-07 | ABCW-DELISTED | Stock | 31.95 | 32.4 | 31.84 | 32.37 | 41090.0 |
| 2005-11-07 | ABD-DELISTED | Stock | 23.8 | 24.35 | 23.75 | 24.33 | 135200.0 |
| 2005-11-07 | ABE-DELISTED | Stock | 11.19 | 11.19 | 11.07 | 11.15 | 57600.0 |
| 2005-11-07 | ABFS-DELISTED | Stock | 40.4 | 41.13 | 40.19 | 41.03 | 302433.0 |
| 2005-11-07 | ABG | Stock | 17.08 | 17.15 | 16.75 | 16.91 | 100700.0 |
| 2005-11-07 | ABK-DELISTED | Stock | 75.0 | 75.09 | 74.2 | 74.82 | 467900.0 |
| 2005-11-07 | ABM | Stock | 20.0 | 20.47 | 19.89 | 20.39 | 81200.0 |
| 2005-11-07 | ABMD-DELISTED | Stock | 9.03 | 9.09 | 8.781 | 8.97 | 104426.0 |
| 2005-11-07 | ABP-DELISTED | Stock | 6.65 | 6.74 | 6.0 | 6.32 | 1570100.0 |
| 2005-11-07 | ABR | Stock | 26.0 | 26.0 | 24.55 | 25.3 | 622900.0 |
| 2005-11-07 | ABT | Stock | 20.4251 | 20.4875 | 20.2716 | 20.4155 | 7991872.0 |
| 2005-11-07 | ABTL-DELISTED | Stock | 22.47 | 22.98 | 22.07 | 22.83 | 153199.0 |
| 2005-11-07 | ABV-DELISTED | Stock | 36.0 | 37.0 | 36.0 | 36.4 | 950400.0 |
| 2005-11-07 | ABVA-DELISTED | Stock | 16.7 | 16.95 | 16.7 | 16.95 | 600.0 |
| 2005-11-07 | ABX-DELISTED | Stock | 24.93 | 25.32 | 24.84 | 25.2 | 3034600.0 |
| 2005-11-07 | ACAD | Stock | 9.8 | 10.25 | 9.8 | 10.06 | 73800.0 |
| 2005-11-07 | ACAP-DELISTED | Stock | 45.26 | 46.47 | 44.73 | 46.28 | 50813.0 |
| 2005-11-07 | ACAS-DELISTED | Stock | 38.45 | 38.68 | 38.22 | 38.28 | 472228.0 |
| 2005-11-07 | ACAT-DELISTED | Stock | 19.51 | 19.71 | 19.39 | 19.56 | 22769.0 |
| 2005-11-07 | ACC-DELISTED | Stock | 25.1 | 25.25 | 24.91 | 25.08 | 52200.0 |
| 2005-11-07 | ACCL-DELISTED | Stock | 6.74 | 7.05 | 6.67 | 6.98 | 138822.0 |
| 2005-11-07 | ACCO | Stock | 23.8 | 24.35 | 23.75 | 24.33 | 135300.0 |
| 2005-11-07 | ACE-DELISTED | Stock | 53.66 | 54.05 | 52.62 | 53.88 | 1409200.0 |
| 2005-11-07 | ACF-DELISTED | Stock | 22.84 | 23.05 | 22.84 | 22.89 | 1137800.0 |
| 2005-11-07 | ACFC-DELISTED | Stock | 73.21 | 74.64 | 73.21 | 73.52 | 31687.0 |
| 2005-11-07 | ACG-DELISTED | Stock | 8.17 | 8.22 | 8.17 | 8.21 | 236100.0 |
| 2005-11-07 | ACGL | Stock | 5.7911 | 5.7911 | 5.6878 | 5.7222 | 1475100.0 |
| 2005-11-07 | ACGN-DELISTED | Stock | 861.3288 | 895.22 | 793.3288 | 850.0 | 69900.0 |
> showing 50 of 4,247 rows — these rows as CSV