PREVIEW / stock_daily / 2004-08-31
file: by_date/stock_daily/2004/2004-08-31.parquet size: 127 KB rows: 3,799 symbols: 2,366
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-31 | AAPL | Stock | 0.6084 | 0.6241 | 0.6071 | 0.6159 | 376560800.0 |
| 2004-08-31 | MSFT | Stock | 27.29 | 27.32 | 27.05 | 27.3 | 52106700.0 |
| 2004-08-31 | NVDA | Stock | 0.1047 | 0.1052 | 0.1006 | 0.1038 | 587064000.0 |
| 2004-08-31 | AMZN | Stock | 1.919 | 1.9425 | 1.893 | 1.907 | 122864000.0 |
| 2004-08-31 | CL | Stock | 26.83 | 27.05 | 26.76 | 27.0 | 2786800.0 |
| 2004-08-31 | A | Stock | 15.0 | 15.0215 | 14.3205 | 14.6638 | 8376956.0 |
| 2004-08-31 | AABA-DELISTED | Stock | 28.4799995422363 | 28.7000007629395 | 28.0799999237061 | 28.5100002288818 | 11381700.0 |
| 2004-08-31 | AACC-DELISTED | Stock | 18.0 | 18.23 | 17.35 | 17.53 | 49133.0 |
| 2004-08-31 | AAI-DELISTED | Stock | 12.1 | 12.25 | 11.99 | 12.17 | 902400.0 |
| 2004-08-31 | AAIC-DELISTED | Stock | 369.2 | 378.2 | 367.4 | 377.0 | 1549500.0 |
| 2004-08-31 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1300.0 |
| 2004-08-31 | AAON | Stock | 2.2953 | 2.2953 | 2.215 | 2.236 | 31894.0 |
| 2004-08-31 | AAP | Stock | 24.98 | 24.98 | 24.62 | 24.7067 | 1654800.0 |
| 2004-08-31 | AAV-DELISTED | Stock | 14.98 | 14.98 | 14.74 | 14.98 | 33600.0 |
| 2004-08-31 | AAXN-DELISTED | Stock | 13.8950004577637 | 13.9449996948242 | 13.5500001907349 | 13.7950000762939 | 3271000.0 |
| 2004-08-31 | ABAX-DELISTED | Stock | 15.01 | 15.15 | 14.78 | 15.15 | 60777.0 |
| 2004-08-31 | ABB-DELISTED | Stock | 5.63 | 5.75 | 5.63 | 5.74 | 368800.0 |
| 2004-08-31 | ABC-DELISTED | Stock | 13.51 | 13.6 | 13.46 | 13.53 | 2468000.0 |
| 2004-08-31 | ABCB | Stock | 14.8652 | 14.8733 | 14.6301 | 14.7112 | 4318.0 |
| 2004-08-31 | ABCO-DELISTED | Stock | 15.795 | 16.04 | 15.795 | 16.03 | 135038.0 |
| 2004-08-31 | ABCW-DELISTED | Stock | 25.43 | 25.53 | 25.04 | 25.15 | 81110.0 |
| 2004-08-31 | ABE-DELISTED | Stock | 7.6 | 7.65 | 7.57 | 7.64 | 13700.0 |
| 2004-08-31 | ABFS-DELISTED | Stock | 34.27 | 34.859 | 33.9 | 34.43 | 304735.0 |
| 2004-08-31 | ABG | Stock | 13.8 | 13.95 | 13.25 | 13.78 | 25700.0 |
| 2004-08-31 | ABK-DELISTED | Stock | 74.86 | 75.49 | 74.66 | 75.49 | 258200.0 |
| 2004-08-31 | ABM | Stock | 17.83 | 18.07 | 17.69 | 17.96 | 64800.0 |
| 2004-08-31 | ABMD-DELISTED | Stock | 9.86 | 9.86 | 9.43 | 9.74 | 38204.0 |
| 2004-08-31 | ABP-DELISTED | Stock | 1.58 | 1.71 | 1.57 | 1.62 | 70700.0 |
| 2004-08-31 | ABR | Stock | 20.61 | 21.0 | 20.58 | 20.87 | 106500.0 |
| 2004-08-31 | ABT | Stock | 19.8397 | 20.0029 | 19.7294 | 20.0029 | 5533764.0 |
| 2004-08-31 | ABTL-DELISTED | Stock | 34.75 | 35.35 | 34.75 | 35.2 | 123000.0 |
| 2004-08-31 | ABV-DELISTED | Stock | 21.9 | 22.37 | 21.7 | 21.75 | 337500.0 |
| 2004-08-31 | ABVA-DELISTED | Stock | 14.58 | 14.58 | 14.58 | 14.58 | 300.0 |
| 2004-08-31 | ABX-DELISTED | Stock | 19.48 | 20.04 | 19.46 | 20.0 | 1307700.0 |
| 2004-08-31 | ACAD | Stock | 6.25 | 6.45 | 6.25 | 6.45 | 10900.0 |
| 2004-08-31 | ACAP-DELISTED | Stock | 27.13 | 27.5 | 27.13 | 27.46 | 87526.0 |
| 2004-08-31 | ACAS-DELISTED | Stock | 31.74 | 31.81 | 30.75 | 31.2 | 980073.0 |
| 2004-08-31 | ACAT-DELISTED | Stock | 26.0 | 26.17 | 25.75 | 26.14 | 24644.0 |
| 2004-08-31 | ACC-DELISTED | Stock | 17.45 | 17.8 | 17.42 | 17.7 | 77500.0 |
| 2004-08-31 | ACCL-DELISTED | Stock | 5.9 | 5.95 | 5.61 | 5.84 | 89423.0 |
| 2004-08-31 | ACE-DELISTED | Stock | 38.95 | 39.01 | 38.29 | 38.55 | 1021900.0 |
| 2004-08-31 | ACF-DELISTED | Stock | 20.65 | 20.91 | 20.43 | 20.89 | 1226400.0 |
| 2004-08-31 | ACG-DELISTED | Stock | 8.15 | 8.19 | 8.14 | 8.17 | 553600.0 |
| 2004-08-31 | ACGL | Stock | 4.0089 | 4.0667 | 4.0 | 4.0667 | 1115100.0 |
| 2004-08-31 | ACGN-DELISTED | Stock | 589.3288 | 612.0 | 566.6712 | 612.0 | 187600.0 |
| 2004-08-31 | ACH | Stock | 16.3267 | 16.4067 | 16.2133 | 16.3333 | 79650.0 |
| 2004-08-31 | ACH-DELISTED | Stock | 12.416 | 12.416 | 12.071 | 12.289 | 326491.0 |
| 2004-08-31 | ACLS | Stock | 32.16 | 32.24 | 31.04 | 31.2 | 213275.0 |
| 2004-08-31 | ACO-DELISTED | Stock | 16.87 | 17.28 | 16.77 | 17.13 | 61400.0 |
| 2004-08-31 | ACPW-DELISTED | Stock | 14.5 | 14.6 | 14.25 | 14.55 | 13558.0 |
> showing 50 of 3,799 rows — these rows as CSV