PREVIEW / stock_daily / 2005-11-03
file: by_date/stock_daily/2005/2005-11-03.parquet size: 142 KB rows: 4,219 symbols: 2,648
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-03 | AAPL | Stock | 2.1521 | 2.2257 | 2.1454 | 2.2089 | 884382800.0 |
| 2005-11-03 | MSFT | Stock | 26.6 | 26.64 | 26.25 | 26.44 | 73421600.0 |
| 2005-11-03 | NVDA | Stock | 0.2942 | 0.2958 | 0.2864 | 0.2887 | 465072000.0 |
| 2005-11-03 | AMZN | Stock | 2.0445 | 2.1 | 2.0425 | 2.078 | 140000000.0 |
| 2005-11-03 | CL | Stock | 26.15 | 26.3 | 25.875 | 26.0 | 6350200.0 |
| 2005-11-03 | A | Stock | 23.4549 | 23.6195 | 23.319 | 23.3906 | 2087214.0 |
| 2005-11-03 | AABA-DELISTED | Stock | 38.2599983215332 | 38.2799987792969 | 37.3300018310547 | 37.4500007629395 | 16880800.0 |
| 2005-11-03 | AACC-DELISTED | Stock | 18.69 | 19.0 | 18.14 | 18.32 | 467361.0 |
| 2005-11-03 | AACQ-DELISTED | Stock | 5.16 | 5.16 | 5.16 | 5.16 | 500.0 |
| 2005-11-03 | AACQW-DELISTED | Stock | 0.43 | 0.43 | 0.43 | 0.43 | 25000.0 |
| 2005-11-03 | AAI-DELISTED | Stock | 15.02 | 15.42 | 14.98 | 15.16 | 2096400.0 |
| 2005-11-03 | AAIC-DELISTED | Stock | 185.0 | 186.0 | 181.4 | 182.2 | 1652000.0 |
| 2005-11-03 | AAME | Stock | 2.63 | 2.63 | 2.63 | 2.63 | 400.0 |
| 2005-11-03 | AAON | Stock | 2.24 | 2.3309 | 2.24 | 2.3111 | 186806.0 |
| 2005-11-03 | AAP | Stock | 40.25 | 40.64 | 39.35 | 39.85 | 2751300.0 |
| 2005-11-03 | AATI-DELISTED | Stock | 9.85 | 10.44 | 9.81 | 10.19 | 140480.0 |
| 2005-11-03 | AAV-DELISTED | Stock | 16.7 | 16.75 | 16.39 | 16.7 | 18100.0 |
| 2005-11-03 | AAXN-DELISTED | Stock | 6.76000022888184 | 7.30999994277954 | 6.73000001907349 | 7.30000019073486 | 4984500.0 |
| 2005-11-03 | ABAX-DELISTED | Stock | 16.9 | 17.2 | 16.87 | 16.99 | 260357.0 |
| 2005-11-03 | ABB-DELISTED | Stock | 7.8 | 7.88 | 7.77 | 7.84 | 1938100.0 |
| 2005-11-03 | ABBC-DELISTED | Stock | 12.0 | 12.02 | 11.92 | 12.02 | 2555.0 |
| 2005-11-03 | ABC-DELISTED | Stock | 19.5 | 19.55 | 19.16 | 19.24 | 6740000.0 |
| 2005-11-03 | ABCB | Stock | 19.1903 | 19.3069 | 18.6164 | 18.8207 | 24881.0 |
| 2005-11-03 | ABCO-DELISTED | Stock | 24.89 | 24.99 | 24.46 | 24.5 | 161618.0 |
| 2005-11-03 | ABCW-DELISTED | Stock | 32.21 | 32.21 | 31.66 | 31.89 | 36030.0 |
| 2005-11-03 | ABD-DELISTED | Stock | 23.82 | 23.93 | 23.32 | 23.88 | 330350.0 |
| 2005-11-03 | ABE-DELISTED | Stock | 11.24 | 11.24 | 11.12 | 11.24 | 31100.0 |
| 2005-11-03 | ABFS-DELISTED | Stock | 40.2 | 41.09 | 39.847 | 40.25 | 403606.0 |
| 2005-11-03 | ABG | Stock | 17.11 | 17.47 | 17.0 | 17.24 | 60300.0 |
| 2005-11-03 | ABK-DELISTED | Stock | 74.97 | 75.2 | 73.34 | 73.56 | 638200.0 |
| 2005-11-03 | ABM | Stock | 20.2 | 20.27 | 20.0 | 20.21 | 102000.0 |
| 2005-11-03 | ABMD-DELISTED | Stock | 8.3 | 8.74 | 8.3 | 8.74 | 276337.0 |
| 2005-11-03 | ABP-DELISTED | Stock | 6.83 | 7.35 | 6.8 | 7.2 | 1115600.0 |
| 2005-11-03 | ABR | Stock | 27.44 | 27.63 | 27.2 | 27.49 | 55800.0 |
| 2005-11-03 | ABT | Stock | 20.4299 | 20.5882 | 20.4011 | 20.5306 | 10380575.0 |
| 2005-11-03 | ABTL-DELISTED | Stock | 22.45 | 22.7 | 21.84 | 22.45 | 26757.0 |
| 2005-11-03 | ABV-DELISTED | Stock | 36.5 | 36.89 | 36.38 | 36.49 | 906000.0 |
| 2005-11-03 | ABVA-DELISTED | Stock | 16.7 | 16.9125 | 16.55 | 16.55 | 2281.0 |
| 2005-11-03 | ABX-DELISTED | Stock | 25.37 | 25.52 | 24.94 | 25.02 | 3429500.0 |
| 2005-11-03 | ACAD | Stock | 10.34 | 10.34 | 10.18 | 10.22 | 50700.0 |
| 2005-11-03 | ACAP-DELISTED | Stock | 45.48 | 45.88 | 45.23 | 45.46 | 54944.0 |
| 2005-11-03 | ACAS-DELISTED | Stock | 38.18 | 38.33 | 37.91 | 37.98 | 722741.0 |
| 2005-11-03 | ACAT-DELISTED | Stock | 19.8 | 19.8 | 19.67 | 19.7 | 54512.0 |
| 2005-11-03 | ACC-DELISTED | Stock | 25.15 | 25.15 | 24.6 | 25.0 | 79200.0 |
| 2005-11-03 | ACCL-DELISTED | Stock | 6.81 | 6.95 | 6.75 | 6.92 | 106605.0 |
| 2005-11-03 | ACCO | Stock | 23.8 | 23.9 | 23.3 | 23.9 | 332100.0 |
| 2005-11-03 | ACE-DELISTED | Stock | 52.94 | 53.4 | 52.7 | 53.1 | 1766500.0 |
| 2005-11-03 | ACF-DELISTED | Stock | 22.64 | 22.84 | 22.56 | 22.61 | 1068300.0 |
| 2005-11-03 | ACFC-DELISTED | Stock | 73.63 | 73.63 | 72.85 | 73.06 | 196.0 |
| 2005-11-03 | ACG-DELISTED | Stock | 8.25 | 8.26 | 8.17 | 8.18 | 365600.0 |
> showing 50 of 4,219 rows — these rows as CSV