PREVIEW / stock_daily / 2005-11-29
file: by_date/stock_daily/2005/2005-11-29.parquet size: 143 KB rows: 4,267 symbols: 2,693
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-29 | AAPL | Stock | 2.4996 | 2.5107 | 2.4054 | 2.4321 | 891433200.0 |
| 2005-11-29 | MSFT | Stock | 27.79 | 27.79 | 27.6 | 27.68 | 62220400.0 |
| 2005-11-29 | NVDA | Stock | 0.297 | 0.3054 | 0.2943 | 0.2957 | 1043136000.0 |
| 2005-11-29 | AMZN | Stock | 2.4155 | 2.4715 | 2.406 | 2.4275 | 207688000.0 |
| 2005-11-29 | CL | Stock | 27.15 | 27.27 | 27.04 | 27.145 | 3429800.0 |
| 2005-11-29 | A | Stock | 25.4649 | 25.6152 | 25.3433 | 25.3863 | 4499743.0 |
| 2005-11-29 | AABA-DELISTED | Stock | 41.0099983215332 | 41.5900001525879 | 39.8199996948242 | 40.189998626709 | 28698200.0 |
| 2005-11-29 | AACC-DELISTED | Stock | 20.93 | 20.93 | 20.59 | 20.76 | 114810.0 |
| 2005-11-29 | AAI-DELISTED | Stock | 15.33 | 15.58 | 15.24 | 15.25 | 1204100.0 |
| 2005-11-29 | AAIC-DELISTED | Stock | 214.8 | 218.0 | 214.2 | 216.0 | 1317900.0 |
| 2005-11-29 | AAME | Stock | 2.69 | 2.73 | 2.55 | 2.55 | 4200.0 |
| 2005-11-29 | AAON | Stock | 2.2242 | 2.2334 | 2.2044 | 2.2334 | 32653.0 |
| 2005-11-29 | AAP | Stock | 42.37 | 42.83 | 42.22 | 42.37 | 361700.0 |
| 2005-11-29 | AATI-DELISTED | Stock | 12.38 | 13.67 | 12.07 | 12.82 | 255762.0 |
| 2005-11-29 | AAV-DELISTED | Stock | 18.21 | 18.27 | 17.92 | 18.21 | 69300.0 |
| 2005-11-29 | AAWW-DELISTED | Stock | 32.9 | 33.2 | 32.9 | 33.0 | 66000.0 |
| 2005-11-29 | AAXN-DELISTED | Stock | 6.23999977111816 | 6.38000011444092 | 6.07000017166138 | 6.19000005722046 | 2394400.0 |
| 2005-11-29 | ABAX-DELISTED | Stock | 17.04 | 17.32 | 16.54 | 16.7 | 216022.0 |
| 2005-11-29 | ABB-DELISTED | Stock | 8.65 | 8.73 | 8.62 | 8.7 | 1022200.0 |
| 2005-11-29 | ABBC-DELISTED | Stock | 12.7475 | 12.75 | 12.7475 | 12.75 | 1200.0 |
| 2005-11-29 | ABC-DELISTED | Stock | 19.89 | 20.15 | 19.85 | 20.12 | 2534400.0 |
| 2005-11-29 | ABCB | Stock | 19.2778 | 19.3069 | 18.9082 | 19.2 | 15216.0 |
| 2005-11-29 | ABCO-DELISTED | Stock | 24.03 | 24.1 | 23.85 | 23.97 | 107738.0 |
| 2005-11-29 | ABCW-DELISTED | Stock | 30.97 | 31.19 | 30.78 | 30.89 | 69700.0 |
| 2005-11-29 | ABD-DELISTED | Stock | 23.35 | 23.35 | 22.75 | 22.9 | 205000.0 |
| 2005-11-29 | ABE-DELISTED | Stock | 11.51 | 11.6 | 11.48 | 11.48 | 12200.0 |
| 2005-11-29 | ABFS-DELISTED | Stock | 40.77 | 41.19 | 40.73 | 41.14 | 328201.0 |
| 2005-11-29 | ABG | Stock | 16.2 | 16.52 | 16.1 | 16.4 | 37000.0 |
| 2005-11-29 | ABK-DELISTED | Stock | 76.23 | 77.28 | 76.23 | 77.02 | 402500.0 |
| 2005-11-29 | ABM | Stock | 20.95 | 21.25 | 20.82 | 21.05 | 102600.0 |
| 2005-11-29 | ABMD-DELISTED | Stock | 8.93 | 8.97 | 8.73 | 8.75 | 57879.0 |
| 2005-11-29 | ABP-DELISTED | Stock | 6.76 | 6.85 | 6.53 | 6.6 | 488400.0 |
| 2005-11-29 | ABR | Stock | 27.23 | 27.29 | 27.07 | 27.13 | 38000.0 |
| 2005-11-29 | ABT | Stock | 18.6786 | 18.6882 | 18.3092 | 18.3092 | 14557107.0 |
| 2005-11-29 | ABTL-DELISTED | Stock | 26.35 | 26.65 | 25.95 | 26.25 | 69949.0 |
| 2005-11-29 | ABV-DELISTED | Stock | 38.95 | 39.35 | 38.95 | 39.11 | 635800.0 |
| 2005-11-29 | ABVA-DELISTED | Stock | 16.74 | 16.74 | 16.38 | 16.38 | 2311.0 |
| 2005-11-29 | ABX-DELISTED | Stock | 27.15 | 27.32 | 26.6307 | 27.05 | 2754800.0 |
| 2005-11-29 | ACAD | Stock | 9.36 | 9.63 | 9.11 | 9.25 | 77300.0 |
| 2005-11-29 | ACAP-DELISTED | Stock | 45.08 | 46.22 | 44.93 | 45.66 | 73762.0 |
| 2005-11-29 | ACAS-DELISTED | Stock | 38.52 | 38.64 | 38.3 | 38.4 | 1088162.0 |
| 2005-11-29 | ACAT-DELISTED | Stock | 21.14 | 21.62 | 20.9 | 21.58 | 42704.0 |
| 2005-11-29 | ACC-DELISTED | Stock | 24.95 | 25.34 | 24.85 | 25.21 | 71100.0 |
| 2005-11-29 | ACCL-DELISTED | Stock | 7.5 | 7.84 | 7.5 | 7.77 | 183938.0 |
| 2005-11-29 | ACCO | Stock | 23.35 | 23.35 | 22.75 | 22.9 | 205000.0 |
| 2005-11-29 | ACE-DELISTED | Stock | 55.6 | 56.07 | 55.4 | 55.87 | 1253200.0 |
| 2005-11-29 | ACF-DELISTED | Stock | 24.76 | 24.99 | 24.56 | 24.8 | 945000.0 |
| 2005-11-29 | ACFC-DELISTED | Stock | 74.29 | 75.15 | 74.29 | 74.49 | 5665.0 |
| 2005-11-29 | ACG-DELISTED | Stock | 8.23 | 8.26 | 8.22 | 8.26 | 239100.0 |
| 2005-11-29 | ACGL | Stock | 6.0033 | 6.0033 | 5.8589 | 5.8811 | 5244300.0 |
> showing 50 of 4,267 rows — these rows as CSV