PREVIEW / stock_daily / 2005-11-08
file: by_date/stock_daily/2005/2005-11-08.parquet size: 142 KB rows: 4,241 symbols: 2,673
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-08 | AAPL | Stock | 2.1411 | 2.1564 | 2.1107 | 2.1393 | 473765600.0 |
| 2005-11-08 | MSFT | Stock | 26.94 | 27.18 | 26.77 | 27.05 | 60091700.0 |
| 2005-11-08 | NVDA | Stock | 0.2837 | 0.2839 | 0.2761 | 0.2773 | 538968000.0 |
| 2005-11-08 | AMZN | Stock | 2.0665 | 2.1055 | 2.0515 | 2.0975 | 99016000.0 |
| 2005-11-08 | CL | Stock | 25.83 | 26.435 | 25.83 | 26.33 | 5274000.0 |
| 2005-11-08 | A | Stock | 23.4049 | 23.6767 | 23.4049 | 23.5837 | 6345662.0 |
| 2005-11-08 | AABA-DELISTED | Stock | 37.75 | 38.5 | 37.5999984741211 | 37.9700012207031 | 14434400.0 |
| 2005-11-08 | AACC-DELISTED | Stock | 18.21 | 18.49 | 18.03 | 18.39 | 217783.0 |
| 2005-11-08 | AACQU-DELISTED | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 100.0 |
| 2005-11-08 | AAI-DELISTED | Stock | 15.1 | 15.1 | 14.68 | 14.85 | 1311100.0 |
| 2005-11-08 | AAIC-DELISTED | Stock | 176.8 | 177.0 | 174.4 | 174.8 | 775600.0 |
| 2005-11-08 | AAME | Stock | 2.7 | 2.7 | 2.63 | 2.63 | 11000.0 |
| 2005-11-08 | AAON | Stock | 2.2927 | 2.3098 | 2.2598 | 2.2598 | 64547.0 |
| 2005-11-08 | AAP | Stock | 39.95 | 39.96 | 39.0 | 39.46 | 631300.0 |
| 2005-11-08 | AATI-DELISTED | Stock | 10.97 | 11.59 | 10.89 | 11.4 | 145511.0 |
| 2005-11-08 | AAV-DELISTED | Stock | 16.22 | 16.28 | 16.01 | 16.22 | 43500.0 |
| 2005-11-08 | AAXN-DELISTED | Stock | 8.10000038146973 | 8.1899995803833 | 7.61999988555908 | 7.73000001907349 | 3775400.0 |
| 2005-11-08 | ABAX-DELISTED | Stock | 16.4 | 17.45 | 16.16 | 17.44 | 408074.0 |
| 2005-11-08 | ABB-DELISTED | Stock | 7.89 | 7.92 | 7.86 | 7.88 | 3742400.0 |
| 2005-11-08 | ABBC-DELISTED | Stock | 12.01 | 12.09 | 12.0 | 12.09 | 450.0 |
| 2005-11-08 | ABC-DELISTED | Stock | 19.14 | 19.35 | 19.14 | 19.24 | 2752000.0 |
| 2005-11-08 | ABCB | Stock | 18.8887 | 19.0249 | 18.6358 | 18.7622 | 17067.0 |
| 2005-11-08 | ABCO-DELISTED | Stock | 23.98 | 24.15 | 23.72 | 23.93 | 116382.0 |
| 2005-11-08 | ABCW-DELISTED | Stock | 32.03 | 32.13 | 31.52 | 32.0 | 59350.0 |
| 2005-11-08 | ABD-DELISTED | Stock | 24.16 | 24.19 | 23.57 | 23.57 | 253270.0 |
| 2005-11-08 | ABE-DELISTED | Stock | 11.15 | 11.36 | 11.13 | 11.33 | 61400.0 |
| 2005-11-08 | ABFS-DELISTED | Stock | 40.57 | 41.56 | 40.5 | 41.19 | 360544.0 |
| 2005-11-08 | ABG | Stock | 16.9 | 17.2 | 16.8 | 17.05 | 41500.0 |
| 2005-11-08 | ABK-DELISTED | Stock | 74.2 | 74.44 | 73.73 | 74.35 | 290600.0 |
| 2005-11-08 | ABM | Stock | 20.23 | 20.36 | 19.97 | 20.26 | 73500.0 |
| 2005-11-08 | ABMD-DELISTED | Stock | 8.94 | 9.59 | 8.93 | 9.15 | 87772.0 |
| 2005-11-08 | ABP-DELISTED | Stock | 6.35 | 6.44 | 6.21 | 6.32 | 361900.0 |
| 2005-11-08 | ABR | Stock | 25.15 | 26.75 | 25.15 | 26.51 | 209100.0 |
| 2005-11-08 | ABT | Stock | 20.2955 | 20.4683 | 20.2716 | 20.4011 | 6898291.0 |
| 2005-11-08 | ABTL-DELISTED | Stock | 22.23 | 22.62 | 22.08 | 22.27 | 63158.0 |
| 2005-11-08 | ABV-DELISTED | Stock | 36.51 | 37.22 | 36.51 | 37.09 | 958800.0 |
| 2005-11-08 | ABVA-DELISTED | Stock | 16.8 | 16.8 | 16.6 | 16.6 | 1700.0 |
| 2005-11-08 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 500.0 |
| 2005-11-08 | ABX-DELISTED | Stock | 25.15 | 25.36 | 24.95 | 25.23 | 3753900.0 |
| 2005-11-08 | ACAD | Stock | 9.94 | 10.42 | 9.7 | 10.29 | 45800.0 |
| 2005-11-08 | ACAP-DELISTED | Stock | 45.93 | 45.99 | 44.66 | 44.73 | 33779.0 |
| 2005-11-08 | ACAS-DELISTED | Stock | 38.37 | 38.72 | 38.1 | 38.6 | 402091.0 |
| 2005-11-08 | ACAT-DELISTED | Stock | 19.43 | 19.59 | 19.05 | 19.23 | 78745.0 |
| 2005-11-08 | ACC-DELISTED | Stock | 25.08 | 25.08 | 24.62 | 24.91 | 44800.0 |
| 2005-11-08 | ACCL-DELISTED | Stock | 6.9 | 7.03 | 6.82 | 6.87 | 52586.0 |
| 2005-11-08 | ACCO | Stock | 24.15 | 24.18 | 23.53 | 23.58 | 254400.0 |
| 2005-11-08 | ACE-DELISTED | Stock | 53.9 | 54.04 | 53.02 | 53.62 | 1297800.0 |
| 2005-11-08 | ACF-DELISTED | Stock | 22.9 | 22.9 | 22.3 | 22.41 | 1716200.0 |
| 2005-11-08 | ACFC-DELISTED | Stock | 74.39 | 74.44 | 73.57 | 73.88 | 2261.0 |
| 2005-11-08 | ACG-DELISTED | Stock | 8.19 | 8.25 | 8.19 | 8.25 | 309100.0 |
> showing 50 of 4,241 rows — these rows as CSV