PREVIEW / stock_daily / 2004-11-18
file: by_date/stock_daily/2004/2004-11-18.parquet size: 131 KB rows: 3,913 symbols: 2,451
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-18 | AAPL | Stock | 0.9696 | 0.9902 | 0.9695 | 0.9891 | 459149600.0 |
| 2004-11-18 | MSFT | Stock | 27.13 | 27.17 | 27.0 | 27.07 | 63249900.0 |
| 2004-11-18 | NVDA | Stock | 0.1565 | 0.1585 | 0.1532 | 0.1572 | 532524000.0 |
| 2004-11-18 | AMZN | Stock | 1.9865 | 2.048 | 1.9795 | 2.0185 | 136136000.0 |
| 2004-11-18 | CL | Stock | 23.875 | 23.9 | 23.33 | 23.46 | 11301600.0 |
| 2004-11-18 | A | Stock | 16.5379 | 16.774 | 16.4592 | 16.731 | 3528971.0 |
| 2004-11-18 | AABA-DELISTED | Stock | 37.4300003051758 | 37.7799987792969 | 37.0999984741211 | 37.189998626709 | 15401000.0 |
| 2004-11-18 | AACC-DELISTED | Stock | 18.26 | 18.26 | 17.73 | 17.99 | 38373.0 |
| 2004-11-18 | AAI-DELISTED | Stock | 13.0 | 13.15 | 12.9 | 13.08 | 1266100.0 |
| 2004-11-18 | AAIC-DELISTED | Stock | 359.0 | 361.0 | 355.4 | 357.0 | 1085500.0 |
| 2004-11-18 | AAON | Stock | 2.1109 | 2.1491 | 2.1109 | 2.1254 | 113147.0 |
| 2004-11-18 | AAP | Stock | 27.8667 | 28.0667 | 27.7933 | 28.0667 | 981000.0 |
| 2004-11-18 | AAV-DELISTED | Stock | 17.73 | 17.78 | 17.56 | 17.73 | 15000.0 |
| 2004-11-18 | AAXN-DELISTED | Stock | 28.7749996185303 | 29.5450000762939 | 28.6299991607666 | 29.0499992370605 | 17171400.0 |
| 2004-11-18 | ABAX-DELISTED | Stock | 12.74 | 12.78 | 12.51 | 12.71 | 84713.0 |
| 2004-11-18 | ABB-DELISTED | Stock | 6.11 | 6.12 | 6.04 | 6.05 | 310700.0 |
| 2004-11-18 | ABC-DELISTED | Stock | 14.54 | 14.61 | 14.48 | 14.54 | 4540800.0 |
| 2004-11-18 | ABCB | Stock | 17.1914 | 17.4103 | 17.0699 | 17.0699 | 6045.0 |
| 2004-11-18 | ABCO-DELISTED | Stock | 17.603 | 17.603 | 17.362 | 17.562 | 472999.0 |
| 2004-11-18 | ABCW-DELISTED | Stock | 28.99 | 28.99 | 28.55 | 28.7 | 55220.0 |
| 2004-11-18 | ABE-DELISTED | Stock | 9.05 | 9.18 | 9.05 | 9.14 | 16200.0 |
| 2004-11-18 | ABFS-DELISTED | Stock | 41.48 | 42.28 | 41.48 | 41.75 | 145923.0 |
| 2004-11-18 | ABG | Stock | 13.66 | 13.83 | 13.33 | 13.74 | 23500.0 |
| 2004-11-18 | ABK-DELISTED | Stock | 79.9 | 80.3 | 79.5 | 79.67 | 326000.0 |
| 2004-11-18 | ABM | Stock | 21.66 | 21.92 | 21.4 | 21.66 | 122100.0 |
| 2004-11-18 | ABMD-DELISTED | Stock | 17.1 | 17.7 | 16.36 | 16.64 | 263525.0 |
| 2004-11-18 | ABP-DELISTED | Stock | 2.4 | 2.45 | 2.3 | 2.38 | 240200.0 |
| 2004-11-18 | ABR | Stock | 21.65 | 21.7 | 21.4 | 21.5 | 35400.0 |
| 2004-11-18 | ABT | Stock | 20.8473 | 21.0008 | 20.7657 | 20.8089 | 7361609.0 |
| 2004-11-18 | ABTL-DELISTED | Stock | 33.75 | 35.45 | 33.75 | 34.75 | 51900.0 |
| 2004-11-18 | ABV-DELISTED | Stock | 24.79 | 24.79 | 24.36 | 24.61 | 366700.0 |
| 2004-11-18 | ABVA-DELISTED | Stock | 14.7 | 14.84 | 14.7 | 14.84 | 5001.0 |
| 2004-11-18 | ABVT-DELISTED | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 2900.0 |
| 2004-11-18 | ABX-DELISTED | Stock | 24.09 | 24.24 | 23.92 | 24.11 | 3527800.0 |
| 2004-11-18 | ACAD | Stock | 7.08 | 7.1 | 7.0 | 7.07 | 5900.0 |
| 2004-11-18 | ACAP-DELISTED | Stock | 33.7 | 33.9 | 33.3 | 33.39 | 36584.0 |
| 2004-11-18 | ACAS-DELISTED | Stock | 31.6 | 31.7 | 31.23 | 31.48 | 407845.0 |
| 2004-11-18 | ACAT-DELISTED | Stock | 26.08 | 26.08 | 25.94 | 25.99 | 48956.0 |
| 2004-11-18 | ACC-DELISTED | Stock | 20.2 | 20.41 | 20.1 | 20.4 | 38300.0 |
| 2004-11-18 | ACCL-DELISTED | Stock | 6.54 | 6.61 | 6.3 | 6.42 | 55830.0 |
| 2004-11-18 | ACE-DELISTED | Stock | 38.62 | 38.94 | 38.56 | 38.92 | 1231571.0 |
| 2004-11-18 | ACF-DELISTED | Stock | 21.1 | 21.19 | 20.7 | 20.79 | 832900.0 |
| 2004-11-18 | ACFC-DELISTED | Stock | 68.37 | 69.8 | 68.27 | 69.8 | 4003.0 |
| 2004-11-18 | ACG-DELISTED | Stock | 8.16 | 8.17 | 8.14 | 8.17 | 377800.0 |
| 2004-11-18 | ACGL | Stock | 4.2889 | 4.2889 | 4.25 | 4.2722 | 948600.0 |
| 2004-11-18 | ACGN-DELISTED | Stock | 566.6712 | 566.6712 | 521.3288 | 544.0 | 341200.0 |
| 2004-11-18 | ACH | Stock | 18.4333 | 18.5667 | 18.3 | 18.46 | 156750.0 |
| 2004-11-18 | ACH-DELISTED | Stock | 15.435 | 15.558 | 15.435 | 15.47 | 144400.0 |
| 2004-11-18 | ACLS | Stock | 28.68 | 29.16 | 28.24 | 28.92 | 476925.0 |
| 2004-11-18 | ACO-DELISTED | Stock | 19.37 | 19.74 | 19.36 | 19.73 | 143500.0 |
> showing 50 of 3,913 rows — these rows as CSV