PREVIEW / stock_daily / 2004-08-24
file: by_date/stock_daily/2004/2004-08-24.parquet size: 127 KB rows: 3,820 symbols: 2,388
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-08-24 | AAPL | Stock | 0.5582 | 0.5705 | 0.557 | 0.5705 | 374136000.0 |
| 2004-08-24 | MSFT | Stock | 27.4 | 27.46 | 27.09 | 27.24 | 40835300.0 |
| 2004-08-24 | NVDA | Stock | 0.1067 | 0.1072 | 0.0992 | 0.1012 | 939420000.0 |
| 2004-08-24 | AMZN | Stock | 1.986 | 1.9965 | 1.916 | 1.9525 | 152808000.0 |
| 2004-08-24 | CL | Stock | 26.775 | 26.825 | 26.58 | 26.68 | 1645400.0 |
| 2004-08-24 | A | Stock | 15.8798 | 15.9084 | 15.3505 | 15.4578 | 2774611.0 |
| 2004-08-24 | AABA-DELISTED | Stock | 28.9899997711182 | 29.0799999237061 | 28.0499992370605 | 28.4099998474121 | 16537400.0 |
| 2004-08-24 | AACC-DELISTED | Stock | 18.1 | 18.1 | 17.46 | 17.99 | 108042.0 |
| 2004-08-24 | AAI-DELISTED | Stock | 11.55 | 12.04 | 11.55 | 12.0 | 2188100.0 |
| 2004-08-24 | AAIC-DELISTED | Stock | 360.8 | 369.4 | 360.8 | 366.6 | 1127800.0 |
| 2004-08-24 | AAON | Stock | 2.211 | 2.211 | 2.1057 | 2.1834 | 233128.0 |
| 2004-08-24 | AAP | Stock | 23.9 | 24.0333 | 23.82 | 23.8667 | 2588700.0 |
| 2004-08-24 | AAV-DELISTED | Stock | 14.75 | 14.96 | 14.7 | 14.75 | 34200.0 |
| 2004-08-24 | AAXN-DELISTED | Stock | 13.7150001525879 | 13.7250003814697 | 13.0950002670288 | 13.3100004196167 | 4192200.0 |
| 2004-08-24 | ABAX-DELISTED | Stock | 14.6 | 14.6 | 14.0 | 14.25 | 71313.0 |
| 2004-08-24 | ABB-DELISTED | Stock | 5.61 | 5.65 | 5.57 | 5.58 | 107800.0 |
| 2004-08-24 | ABC-DELISTED | Stock | 13.34 | 13.35 | 13.25 | 13.26 | 4666400.0 |
| 2004-08-24 | ABCB | Stock | 14.5896 | 14.6139 | 14.4924 | 14.5491 | 9623.0 |
| 2004-08-24 | ABCO-DELISTED | Stock | 15.52 | 15.52 | 15.245 | 15.415 | 100912.0 |
| 2004-08-24 | ABCW-DELISTED | Stock | 25.75 | 25.75 | 25.28 | 25.74 | 31750.0 |
| 2004-08-24 | ABE-DELISTED | Stock | 7.55 | 7.68 | 7.47 | 7.68 | 35100.0 |
| 2004-08-24 | ABFS-DELISTED | Stock | 35.5 | 35.56 | 34.59 | 35.2 | 408536.0 |
| 2004-08-24 | ABG | Stock | 14.1 | 14.16 | 13.69 | 13.78 | 15100.0 |
| 2004-08-24 | ABK-DELISTED | Stock | 74.38 | 74.91 | 74.32 | 74.54 | 323500.0 |
| 2004-08-24 | ABM | Stock | 17.7 | 18.12 | 17.7 | 18.12 | 48700.0 |
| 2004-08-24 | ABMD-DELISTED | Stock | 10.12 | 10.12 | 9.77 | 9.95 | 43931.0 |
| 2004-08-24 | ABP-DELISTED | Stock | 1.61 | 1.61 | 1.5 | 1.52 | 98300.0 |
| 2004-08-24 | ABR | Stock | 20.25 | 20.6 | 20.25 | 20.46 | 187600.0 |
| 2004-08-24 | ABT | Stock | 19.7438 | 19.8349 | 19.643 | 19.6718 | 3562734.0 |
| 2004-08-24 | ABTL-DELISTED | Stock | 35.05 | 35.05 | 32.55 | 33.6 | 47800.0 |
| 2004-08-24 | ABV-DELISTED | Stock | 21.9 | 22.1 | 21.46 | 21.62 | 734600.0 |
| 2004-08-24 | ABVA-DELISTED | Stock | 15.0 | 15.0 | 14.84 | 14.84 | 7241.0 |
| 2004-08-24 | ABX-DELISTED | Stock | 19.64 | 19.7949 | 19.39 | 19.5 | 1068948.0 |
| 2004-08-24 | ACAD | Stock | 5.7 | 5.7 | 5.4 | 5.6 | 2300.0 |
| 2004-08-24 | ACAP-DELISTED | Stock | 27.28 | 27.55 | 27.12 | 27.25 | 53799.0 |
| 2004-08-24 | ACAS-DELISTED | Stock | 30.84 | 31.23 | 30.55 | 31.19 | 953165.0 |
| 2004-08-24 | ACAT-DELISTED | Stock | 26.55 | 26.55 | 26.03 | 26.09 | 22848.0 |
| 2004-08-24 | ACC-DELISTED | Stock | 17.49 | 17.8 | 17.49 | 17.65 | 99800.0 |
| 2004-08-24 | ACCL-DELISTED | Stock | 6.62 | 6.7 | 6.43 | 6.6 | 50967.0 |
| 2004-08-24 | ACE-DELISTED | Stock | 39.15 | 39.2 | 39.0 | 39.18 | 1730200.0 |
| 2004-08-24 | ACF-DELISTED | Stock | 20.88 | 21.0 | 20.48 | 20.78 | 1259400.0 |
| 2004-08-24 | ACG-DELISTED | Stock | 8.35 | 8.36 | 8.17 | 8.21 | 1171700.0 |
| 2004-08-24 | ACGL | Stock | 4.1711 | 4.1744 | 4.0956 | 4.1178 | 1789200.0 |
| 2004-08-24 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 600.6712 | 612.0 | 11000.0 |
| 2004-08-24 | ACH | Stock | 16.1733 | 16.4667 | 16.1333 | 16.3333 | 471300.0 |
| 2004-08-24 | ACH-DELISTED | Stock | 11.751 | 11.923 | 11.638 | 11.658 | 234799.0 |
| 2004-08-24 | ACLS | Stock | 36.08 | 36.28 | 34.32 | 35.04 | 181675.0 |
| 2004-08-24 | ACO-DELISTED | Stock | 17.2 | 17.45 | 17.04 | 17.21 | 150400.0 |
| 2004-08-24 | ACPW-DELISTED | Stock | 14.15 | 14.25 | 12.8 | 12.8 | 16663.0 |
| 2004-08-24 | ACS-DELISTED | Stock | 53.35 | 53.79 | 53.3 | 53.74 | 932700.0 |
> showing 50 of 3,820 rows — these rows as CSV