PREVIEW / stock_daily / 2004-07-09
file: by_date/stock_daily/2004/2004-07-09.parquet size: 126 KB rows: 3,755 symbols: 2,339
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-07-09 | AAPL | Stock | 0.5405 | 0.5446 | 0.5363 | 0.5363 | 208863200.0 |
| 2004-07-09 | MSFT | Stock | 27.78 | 28.0 | 27.64 | 27.86 | 50249300.0 |
| 2004-07-09 | NVDA | Stock | 0.147 | 0.1472 | 0.1381 | 0.1408 | 1114500000.0 |
| 2004-07-09 | AMZN | Stock | 2.4935 | 2.5 | 2.391 | 2.416 | 160670000.0 |
| 2004-07-09 | CL | Stock | 29.015 | 29.11 | 28.82 | 28.88 | 1890000.0 |
| 2004-07-09 | A | Stock | 19.3133 | 19.628 | 19.1631 | 19.1989 | 2661373.0 |
| 2004-07-09 | AABA-DELISTED | Stock | 30.8799991607666 | 30.9799995422363 | 29.6299991607666 | 30.1100006103516 | 26462600.0 |
| 2004-07-09 | AACC-DELISTED | Stock | 17.51 | 18.0 | 17.37 | 17.5 | 120920.0 |
| 2004-07-09 | AAI-DELISTED | Stock | 13.11 | 13.3 | 13.1 | 13.2 | 559500.0 |
| 2004-07-09 | AAIC-DELISTED | Stock | 370.0 | 373.4 | 361.0 | 363.2 | 1108300.0 |
| 2004-07-09 | AAME | Stock | 2.99 | 2.99 | 2.79 | 2.84 | 1700.0 |
| 2004-07-09 | AAON | Stock | 2.5297 | 2.5297 | 2.4955 | 2.5205 | 53156.0 |
| 2004-07-09 | AAP | Stock | 27.2667 | 27.3933 | 27.2467 | 27.28 | 930150.0 |
| 2004-07-09 | AAV-DELISTED | Stock | 14.67 | 14.68 | 14.5 | 14.67 | 25600.0 |
| 2004-07-09 | AAXN-DELISTED | Stock | 20.3850002288818 | 20.9249992370605 | 20.0049991607666 | 20.3050003051758 | 16183800.0 |
| 2004-07-09 | ABAX-DELISTED | Stock | 18.0 | 18.07 | 17.7 | 18.0 | 310912.0 |
| 2004-07-09 | ABB-DELISTED | Stock | 5.54 | 5.59 | 5.5 | 5.56 | 288400.0 |
| 2004-07-09 | ABC-DELISTED | Stock | 13.43 | 13.57 | 13.15 | 13.27 | 7476400.0 |
| 2004-07-09 | ABCB | Stock | 15.8784 | 15.8784 | 15.5136 | 15.6109 | 4318.0 |
| 2004-07-09 | ABCO-DELISTED | Stock | 16.954 | 17.301 | 16.781 | 16.781 | 197623.0 |
| 2004-07-09 | ABCW-DELISTED | Stock | 25.6 | 25.69 | 25.41 | 25.41 | 24210.0 |
| 2004-07-09 | ABE-DELISTED | Stock | 7.66 | 7.85 | 7.61 | 7.61 | 35900.0 |
| 2004-07-09 | ABFS-DELISTED | Stock | 31.07 | 31.85 | 30.5 | 30.62 | 441993.0 |
| 2004-07-09 | ABG | Stock | 14.06 | 14.06 | 13.26 | 13.4 | 50900.0 |
| 2004-07-09 | ABK-DELISTED | Stock | 72.71 | 72.98 | 72.43 | 72.77 | 514900.0 |
| 2004-07-09 | ABM | Stock | 18.78 | 18.9 | 18.68 | 18.73 | 61900.0 |
| 2004-07-09 | ABMD-DELISTED | Stock | 11.22 | 11.79 | 11.19 | 11.53 | 59372.0 |
| 2004-07-09 | ABP-DELISTED | Stock | 1.27 | 1.29 | 1.09 | 1.26 | 320200.0 |
| 2004-07-09 | ABR | Stock | 19.96 | 20.08 | 19.85 | 20.01 | 52600.0 |
| 2004-07-09 | ABT | Stock | 19.5998 | 19.6238 | 19.096 | 19.144 | 10993122.0 |
| 2004-07-09 | ABTL-DELISTED | Stock | 37.55 | 39.4 | 36.15 | 39.35 | 71700.0 |
| 2004-07-09 | ABV-DELISTED | Stock | 21.02 | 21.04 | 20.9 | 20.94 | 941800.0 |
| 2004-07-09 | ABVA-DELISTED | Stock | 15.25 | 15.48 | 15.25 | 15.48 | 8650.0 |
| 2004-07-09 | ABX-DELISTED | Stock | 20.74 | 21.03 | 20.37 | 20.97 | 1696575.0 |
| 2004-07-09 | ACAD | Stock | 6.01 | 6.01 | 6.0 | 6.0 | 2600.0 |
| 2004-07-09 | ACAP-DELISTED | Stock | 23.11 | 23.44 | 22.94 | 23.06 | 3202.0 |
| 2004-07-09 | ACAS-DELISTED | Stock | 27.834 | 28.1 | 27.815 | 28.04 | 2007698.0 |
| 2004-07-09 | ACAT-DELISTED | Stock | 26.61 | 26.81 | 26.06 | 26.41 | 25121.0 |
| 2004-07-09 | ACCL-DELISTED | Stock | 8.75 | 9.07 | 8.69 | 9.02 | 75718.0 |
| 2004-07-09 | ACE-DELISTED | Stock | 41.65 | 42.12 | 41.65 | 41.93 | 766400.0 |
| 2004-07-09 | ACF-DELISTED | Stock | 19.41 | 19.65 | 18.76 | 19.02 | 1563900.0 |
| 2004-07-09 | ACG-DELISTED | Stock | 8.0 | 8.02 | 7.98 | 8.01 | 361700.0 |
| 2004-07-09 | ACGL | Stock | 4.44 | 4.4889 | 4.4156 | 4.4789 | 997200.0 |
| 2004-07-09 | ACGN-DELISTED | Stock | 668.6712 | 668.6712 | 634.6712 | 657.3288 | 69800.0 |
| 2004-07-09 | ACH | Stock | 16.3067 | 16.3933 | 16.0133 | 16.0333 | 131550.0 |
| 2004-07-09 | ACH-DELISTED | Stock | 13.75 | 13.864 | 13.715 | 13.837 | 218800.0 |
| 2004-07-09 | ACLS | Stock | 44.28 | 45.0 | 43.76 | 44.28 | 198775.0 |
| 2004-07-09 | ACO-DELISTED | Stock | 18.48 | 18.57 | 17.55 | 18.18 | 123300.0 |
| 2004-07-09 | ACPW-DELISTED | Stock | 14.55 | 15.55 | 14.5 | 14.7 | 23295.0 |
| 2004-07-09 | ACS-DELISTED | Stock | 51.15 | 51.59 | 50.61 | 51.55 | 904900.0 |
> showing 50 of 3,755 rows — these rows as CSV