PREVIEW / stock_daily / 2005-11-21
file: by_date/stock_daily/2005/2005-11-21.parquet size: 143 KB rows: 4,285 symbols: 2,704
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-21 | AAPL | Stock | 2.315 | 2.3282 | 2.2757 | 2.32 | 511711200.0 |
| 2005-11-21 | MSFT | Stock | 28.07 | 28.24 | 27.84 | 28.16 | 65794400.0 |
| 2005-11-21 | NVDA | Stock | 0.3019 | 0.3074 | 0.2999 | 0.3069 | 454704000.0 |
| 2005-11-21 | AMZN | Stock | 2.3785 | 2.4155 | 2.364 | 2.3995 | 357398000.0 |
| 2005-11-21 | CL | Stock | 26.975 | 27.315 | 26.9 | 27.195 | 3057000.0 |
| 2005-11-21 | A | Stock | 24.7496 | 25.1001 | 24.7425 | 25.0215 | 5693355.0 |
| 2005-11-21 | AABA-DELISTED | Stock | 41.2599983215332 | 42.9799995422363 | 41.2099990844727 | 42.2700004577637 | 27915500.0 |
| 2005-11-21 | AACC-DELISTED | Stock | 20.59 | 20.77 | 20.22 | 20.6 | 132811.0 |
| 2005-11-21 | AACQ-DELISTED | Stock | 5.09 | 5.11 | 5.09 | 5.09 | 127000.0 |
| 2005-11-21 | AACQU-DELISTED | Stock | 5.9 | 5.9 | 5.9 | 5.9 | 4500.0 |
| 2005-11-21 | AAI-DELISTED | Stock | 15.95 | 15.9799 | 15.38 | 15.72 | 1340800.0 |
| 2005-11-21 | AAIC-DELISTED | Stock | 185.4 | 208.0 | 185.0 | 201.0 | 3421400.0 |
| 2005-11-21 | AAME | Stock | 2.64 | 2.7 | 2.53 | 2.7 | 3800.0 |
| 2005-11-21 | AAON | Stock | 2.2255 | 2.2426 | 2.2097 | 2.2347 | 51637.0 |
| 2005-11-21 | AAP | Stock | 41.03 | 41.88 | 41.03 | 41.86 | 1041200.0 |
| 2005-11-21 | AATI-DELISTED | Stock | 12.75 | 12.8 | 12.6 | 12.7 | 24244.0 |
| 2005-11-21 | AAV-DELISTED | Stock | 17.36 | 17.4 | 12.29 | 17.36 | 56300.0 |
| 2005-11-21 | AAWW-DELISTED | Stock | 31.1 | 32.5 | 31.1 | 32.5 | 417900.0 |
| 2005-11-21 | AAXN-DELISTED | Stock | 7.13000011444092 | 7.21000003814697 | 7.01000022888184 | 7.1399998664856 | 1458600.0 |
| 2005-11-21 | ABAX-DELISTED | Stock | 17.74 | 17.94 | 17.32 | 17.8 | 164269.0 |
| 2005-11-21 | ABB-DELISTED | Stock | 8.59 | 8.6 | 8.46 | 8.51 | 1259700.0 |
| 2005-11-21 | ABBC-DELISTED | Stock | 12.16 | 12.59 | 12.16 | 12.59 | 7535.0 |
| 2005-11-21 | ABC-DELISTED | Stock | 19.55 | 19.75 | 19.54 | 19.75 | 2744400.0 |
| 2005-11-21 | ABCB | Stock | 19.5501 | 19.803 | 19.5015 | 19.7738 | 9150.0 |
| 2005-11-21 | ABCO-DELISTED | Stock | 24.17 | 24.3 | 23.84 | 24.3 | 184776.0 |
| 2005-11-21 | ABCW-DELISTED | Stock | 30.27 | 30.85 | 30.03 | 30.8 | 35270.0 |
| 2005-11-21 | ABD-DELISTED | Stock | 23.7 | 23.9 | 23.35 | 23.5 | 181800.0 |
| 2005-11-21 | ABE-DELISTED | Stock | 11.4 | 11.48 | 11.33 | 11.45 | 15200.0 |
| 2005-11-21 | ABFS-DELISTED | Stock | 42.0 | 42.05 | 41.55 | 41.93 | 201943.0 |
| 2005-11-21 | ABG | Stock | 16.37 | 16.49 | 16.09 | 16.3 | 39400.0 |
| 2005-11-21 | ABK-DELISTED | Stock | 76.79 | 76.81 | 76.1 | 76.7 | 320900.0 |
| 2005-11-21 | ABM | Stock | 20.91 | 21.38 | 20.7 | 21.33 | 113100.0 |
| 2005-11-21 | ABMD-DELISTED | Stock | 8.94 | 9.09 | 8.89 | 9.05 | 47014.0 |
| 2005-11-21 | ABP-DELISTED | Stock | 6.35 | 6.5 | 6.34 | 6.49 | 252700.0 |
| 2005-11-21 | ABR | Stock | 27.15 | 27.49 | 27.05 | 27.25 | 49900.0 |
| 2005-11-21 | ABT | Stock | 19.5854 | 19.5998 | 19.3695 | 19.3695 | 8946019.0 |
| 2005-11-21 | ABTL-DELISTED | Stock | 25.6 | 26.5 | 24.9 | 26.25 | 61578.0 |
| 2005-11-21 | ABV-DELISTED | Stock | 37.45 | 37.94 | 37.27 | 37.45 | 404400.0 |
| 2005-11-21 | ABVA-DELISTED | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 1800.0 |
| 2005-11-21 | ABVT-DELISTED | Stock | 27.0 | 27.0 | 26.0 | 26.0 | 700.0 |
| 2005-11-21 | ABX-DELISTED | Stock | 27.18 | 27.33 | 26.6 | 27.33 | 2349000.0 |
| 2005-11-21 | ACAD | Stock | 9.42 | 9.5 | 9.3 | 9.5 | 29800.0 |
| 2005-11-21 | ACAP-DELISTED | Stock | 43.75 | 43.75 | 42.09 | 43.29 | 60400.0 |
| 2005-11-21 | ACAS-DELISTED | Stock | 38.31 | 38.5 | 38.16 | 38.4 | 1725816.0 |
| 2005-11-21 | ACAT-DELISTED | Stock | 19.3 | 19.42 | 19.15 | 19.42 | 32584.0 |
| 2005-11-21 | ACC-DELISTED | Stock | 25.42 | 25.42 | 25.29 | 25.42 | 46530.0 |
| 2005-11-21 | ACCL-DELISTED | Stock | 8.0 | 8.4 | 8.0 | 8.3601 | 354668.0 |
| 2005-11-21 | ACCO | Stock | 23.7 | 23.9 | 23.35 | 23.5 | 183400.0 |
| 2005-11-21 | ACE-DELISTED | Stock | 55.74 | 55.92 | 55.44 | 55.77 | 685275.0 |
| 2005-11-21 | ACF-DELISTED | Stock | 24.0 | 24.68 | 24.0 | 24.46 | 2047400.0 |
> showing 50 of 4,285 rows — these rows as CSV