PREVIEW / stock_daily / 2005-09-19
file: by_date/stock_daily/2005/2005-09-19.parquet size: 140 KB rows: 4,174 symbols: 2,622
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-09-19 | AAPL | Stock | 1.8232 | 1.8889 | 1.8232 | 1.88 | 783731200.0 |
| 2005-09-19 | MSFT | Stock | 26.09 | 26.27 | 25.86 | 26.0 | 61832300.0 |
| 2005-09-19 | NVDA | Stock | 0.2767 | 0.2777 | 0.2717 | 0.2732 | 428316000.0 |
| 2005-09-19 | AMZN | Stock | 2.1315 | 2.1715 | 2.1085 | 2.1375 | 68806000.0 |
| 2005-09-19 | CL | Stock | 26.715 | 26.775 | 26.255 | 26.41 | 2328800.0 |
| 2005-09-19 | A | Stock | 24.1416 | 24.1917 | 23.8984 | 24.0701 | 3950049.0 |
| 2005-09-19 | AABA-DELISTED | Stock | 33.2700004577637 | 33.4700012207031 | 32.25 | 32.75 | 15429900.0 |
| 2005-09-19 | AACC-DELISTED | Stock | 29.9 | 30.39 | 29.669 | 29.97 | 172811.0 |
| 2005-09-19 | AACQ-DELISTED | Stock | 5.09 | 5.11 | 5.09 | 5.09 | 14200.0 |
| 2005-09-19 | AACQU-DELISTED | Stock | 6.3 | 6.3 | 6.27 | 6.27 | 3200.0 |
| 2005-09-19 | AACQW-DELISTED | Stock | 0.63 | 0.63 | 0.61 | 0.61 | 15900.0 |
| 2005-09-19 | AAI-DELISTED | Stock | 10.9 | 11.02 | 10.38 | 10.43 | 1030900.0 |
| 2005-09-19 | AAIC-DELISTED | Stock | 222.8 | 223.8 | 216.8 | 221.6 | 2339300.0 |
| 2005-09-19 | AAME | Stock | 2.77 | 2.9 | 2.65 | 2.9 | 10500.0 |
| 2005-09-19 | AAON | Stock | 2.3743 | 2.3743 | 2.344 | 2.3612 | 137447.0 |
| 2005-09-19 | AAP | Stock | 40.38 | 40.6067 | 39.2 | 39.3 | 962250.0 |
| 2005-09-19 | AATI-DELISTED | Stock | 12.8 | 13.03 | 12.53 | 12.73 | 171836.0 |
| 2005-09-19 | AAV-DELISTED | Stock | 17.93 | 21.58 | 17.41 | 17.93 | 102100.0 |
| 2005-09-19 | AAXN-DELISTED | Stock | 7.73000001907349 | 7.73999977111816 | 7.51000022888184 | 7.51999998092651 | 1309800.0 |
| 2005-09-19 | ABAX-DELISTED | Stock | 13.01 | 13.02 | 12.92 | 12.96 | 30452.0 |
| 2005-09-19 | ABB-DELISTED | Stock | 7.35 | 7.36 | 7.29 | 7.31 | 437500.0 |
| 2005-09-19 | ABBC-DELISTED | Stock | 12.76 | 12.76 | 12.53 | 12.53 | 6223.0 |
| 2005-09-19 | ABC-DELISTED | Stock | 19.35 | 19.43 | 19.28 | 19.39 | 3631600.0 |
| 2005-09-19 | ABCB | Stock | 18.2079 | 18.2079 | 17.6632 | 17.7993 | 19329.0 |
| 2005-09-19 | ABCO-DELISTED | Stock | 26.66 | 26.73 | 26.01 | 26.23 | 217904.0 |
| 2005-09-19 | ABCW-DELISTED | Stock | 29.95 | 30.22 | 29.87 | 29.89 | 30810.0 |
| 2005-09-19 | ABD-DELISTED | Stock | 28.23 | 28.34 | 27.64 | 28.09 | 354890.0 |
| 2005-09-19 | ABE-DELISTED | Stock | 10.88 | 10.91 | 10.87 | 10.88 | 17500.0 |
| 2005-09-19 | ABFS-DELISTED | Stock | 33.55 | 33.75 | 32.56 | 32.85 | 246442.0 |
| 2005-09-19 | ABG | Stock | 17.02 | 17.37 | 17.0 | 17.24 | 54900.0 |
| 2005-09-19 | ABK-DELISTED | Stock | 69.79 | 70.38 | 69.59 | 69.91 | 818600.0 |
| 2005-09-19 | ABM | Stock | 20.84 | 20.84 | 20.57 | 20.65 | 130700.0 |
| 2005-09-19 | ABMD-DELISTED | Stock | 10.64 | 10.8 | 10.31 | 10.39 | 74344.0 |
| 2005-09-19 | ABP-DELISTED | Stock | 5.09 | 5.65 | 5.09 | 5.49 | 958700.0 |
| 2005-09-19 | ABR | Stock | 28.75 | 28.88 | 28.65 | 28.84 | 154800.0 |
| 2005-09-19 | ABT | Stock | 20.8713 | 20.8809 | 20.4875 | 20.7801 | 9672989.0 |
| 2005-09-19 | ABTL-DELISTED | Stock | 25.75 | 25.75 | 24.4 | 24.8 | 43644.0 |
| 2005-09-19 | ABV-DELISTED | Stock | 35.62 | 35.65 | 35.2 | 35.33 | 104300.0 |
| 2005-09-19 | ABVA-DELISTED | Stock | 16.2 | 16.2 | 16.2 | 16.2 | 1100.0 |
| 2005-09-19 | ABVT-DELISTED | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 1000.0 |
| 2005-09-19 | ABX-DELISTED | Stock | 29.58 | 29.96 | 28.7512 | 28.8 | 5637200.0 |
| 2005-09-19 | ACAD | Stock | 10.94 | 11.06 | 10.76 | 11.06 | 34200.0 |
| 2005-09-19 | ACAP-DELISTED | Stock | 45.5 | 46.75 | 45.37 | 46.52 | 81172.0 |
| 2005-09-19 | ACAS-DELISTED | Stock | 37.12 | 37.21 | 37.1 | 37.17 | 526768.0 |
| 2005-09-19 | ACAT-DELISTED | Stock | 20.58 | 21.01 | 20.43 | 20.88 | 85229.0 |
| 2005-09-19 | ACC-DELISTED | Stock | 23.05 | 23.25 | 22.91 | 23.0 | 208800.0 |
| 2005-09-19 | ACCL-DELISTED | Stock | 6.3 | 6.39 | 6.25 | 6.25 | 88104.0 |
| 2005-09-19 | ACCO | Stock | 28.18 | 28.29 | 27.6 | 28.14 | 356500.0 |
| 2005-09-19 | ACE-DELISTED | Stock | 47.31 | 47.31 | 45.99 | 46.15 | 2261900.0 |
| 2005-09-19 | ACF-DELISTED | Stock | 24.85 | 25.0 | 24.67 | 24.9 | 1144600.0 |
> showing 50 of 4,174 rows — these rows as CSV