PREVIEW / stock_daily / 2005-11-14
file: by_date/stock_daily/2005/2005-11-14.parquet size: 142 KB rows: 4,245 symbols: 2,677
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-14 | AAPL | Stock | 2.1979 | 2.2136 | 2.1754 | 2.1946 | 369933200.0 |
| 2005-11-14 | MSFT | Stock | 27.36 | 27.44 | 27.2 | 27.37 | 67152200.0 |
| 2005-11-14 | NVDA | Stock | 0.2837 | 0.2917 | 0.2794 | 0.2897 | 493668000.0 |
| 2005-11-14 | AMZN | Stock | 2.126 | 2.15 | 2.117 | 2.1265 | 62062000.0 |
| 2005-11-14 | CL | Stock | 26.765 | 26.94 | 26.52 | 26.585 | 3162400.0 |
| 2005-11-14 | A | Stock | 23.4621 | 23.8126 | 23.4478 | 23.5336 | 4946264.0 |
| 2005-11-14 | AABA-DELISTED | Stock | 38.4300003051758 | 38.7200012207031 | 37.9599990844727 | 38.4500007629395 | 10112500.0 |
| 2005-11-14 | AACC-DELISTED | Stock | 19.58 | 19.9 | 19.58 | 19.84 | 425661.0 |
| 2005-11-14 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 2000.0 |
| 2005-11-14 | AACQU-DELISTED | Stock | 5.91 | 5.91 | 5.91 | 5.91 | 1000.0 |
| 2005-11-14 | AACQW-DELISTED | Stock | 0.42 | 0.42 | 0.42 | 0.42 | 9000.0 |
| 2005-11-14 | AAI-DELISTED | Stock | 16.15 | 16.54 | 16.14 | 16.43 | 2192500.0 |
| 2005-11-14 | AAIC-DELISTED | Stock | 186.2 | 189.8 | 182.402 | 184.2 | 1158500.0 |
| 2005-11-14 | AAME | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 600.0 |
| 2005-11-14 | AAON | Stock | 2.2795 | 2.294 | 2.2532 | 2.2729 | 158709.0 |
| 2005-11-14 | AAP | Stock | 40.5 | 40.92 | 40.3 | 40.69 | 1245300.0 |
| 2005-11-14 | AATI-DELISTED | Stock | 11.53 | 11.65 | 11.41 | 11.46 | 99647.0 |
| 2005-11-14 | AAV-DELISTED | Stock | 16.4 | 16.45 | 16.16 | 16.4 | 103600.0 |
| 2005-11-14 | AAWW-DELISTED | Stock | 30.2 | 31.5 | 30.2 | 31.0 | 5400.0 |
| 2005-11-14 | AAXN-DELISTED | Stock | 7.51000022888184 | 7.57000017166138 | 7.21000003814697 | 7.26000022888184 | 2196000.0 |
| 2005-11-14 | ABAX-DELISTED | Stock | 18.19 | 18.88 | 18.19 | 18.77 | 218834.0 |
| 2005-11-14 | ABB-DELISTED | Stock | 8.29 | 8.34 | 8.25 | 8.26 | 1682200.0 |
| 2005-11-14 | ABBC-DELISTED | Stock | 12.13 | 12.13 | 12.02 | 12.05 | 13045.0 |
| 2005-11-14 | ABC-DELISTED | Stock | 19.25 | 19.27 | 19.08 | 19.16 | 2535200.0 |
| 2005-11-14 | ABCB | Stock | 19.8225 | 19.8225 | 19.2194 | 19.6279 | 10384.0 |
| 2005-11-14 | ABCO-DELISTED | Stock | 24.55 | 24.66 | 24.54 | 24.58 | 207707.0 |
| 2005-11-14 | ABCW-DELISTED | Stock | 31.81 | 31.81 | 31.27 | 31.43 | 48510.0 |
| 2005-11-14 | ABD-DELISTED | Stock | 22.56 | 23.16 | 22.56 | 23.08 | 152790.0 |
| 2005-11-14 | ABE-DELISTED | Stock | 11.37 | 11.37 | 11.3 | 11.32 | 4000.0 |
| 2005-11-14 | ABFS-DELISTED | Stock | 42.45 | 43.07 | 41.55 | 41.7 | 298627.0 |
| 2005-11-14 | ABG | Stock | 16.4 | 16.67 | 16.26 | 16.36 | 47400.0 |
| 2005-11-14 | ABK-DELISTED | Stock | 75.4 | 76.09 | 75.2 | 76.04 | 303800.0 |
| 2005-11-14 | ABM | Stock | 20.52 | 20.52 | 20.0 | 20.3 | 54400.0 |
| 2005-11-14 | ABMD-DELISTED | Stock | 9.6 | 9.6 | 9.01 | 9.06 | 97417.0 |
| 2005-11-14 | ABP-DELISTED | Stock | 6.31 | 6.45 | 6.3 | 6.34 | 309000.0 |
| 2005-11-14 | ABR | Stock | 27.9 | 27.9 | 27.0 | 27.2 | 63800.0 |
| 2005-11-14 | ABT | Stock | 20.9001 | 20.9097 | 19.3503 | 19.4415 | 29038141.0 |
| 2005-11-14 | ABTL-DELISTED | Stock | 22.58 | 23.62 | 22.58 | 23.52 | 156022.0 |
| 2005-11-14 | ABV-DELISTED | Stock | 36.5 | 37.18 | 36.441 | 36.87 | 261000.0 |
| 2005-11-14 | ABVA-DELISTED | Stock | 16.54 | 16.54 | 16.5 | 16.5 | 902.0 |
| 2005-11-14 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 400.0 |
| 2005-11-14 | ABX-DELISTED | Stock | 25.97 | 26.23 | 25.6 | 25.66 | 1780000.0 |
| 2005-11-14 | ACAD | Stock | 10.43 | 10.44 | 10.25 | 10.37 | 39100.0 |
| 2005-11-14 | ACAP-DELISTED | Stock | 47.1 | 47.29 | 45.54 | 45.73 | 35423.0 |
| 2005-11-14 | ACAS-DELISTED | Stock | 38.83 | 38.9 | 38.5 | 38.61 | 478577.0 |
| 2005-11-14 | ACAT-DELISTED | Stock | 20.5 | 20.56 | 19.95 | 19.97 | 48928.0 |
| 2005-11-14 | ACC-DELISTED | Stock | 26.21 | 26.38 | 26.071 | 26.25 | 47800.0 |
| 2005-11-14 | ACCL-DELISTED | Stock | 7.25 | 7.25 | 6.91 | 7.25 | 88393.0 |
| 2005-11-14 | ACCO | Stock | 22.56 | 23.15 | 22.56 | 23.08 | 152800.0 |
| 2005-11-14 | ACE-DELISTED | Stock | 56.85 | 56.85 | 56.12 | 56.57 | 1788100.0 |
> showing 50 of 4,245 rows — these rows as CSV