PREVIEW / stock_daily / 2004-08-23
file: by_date/stock_daily/2004/2004-08-23.parquet size: 127 KB rows: 3,807 symbols: 2,371
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-23 | AAPL | Stock | 0.5511 | 0.5584 | 0.5464 | 0.555 | 254660000.0 |
| 2004-08-23 | MSFT | Stock | 27.27 | 27.33 | 27.12 | 27.24 | 39572200.0 |
| 2004-08-23 | NVDA | Stock | 0.1046 | 0.1062 | 0.104 | 0.1052 | 800028000.0 |
| 2004-08-23 | AMZN | Stock | 1.9945 | 2.0 | 1.9555 | 1.9725 | 110652000.0 |
| 2004-08-23 | CL | Stock | 26.455 | 26.775 | 26.325 | 26.67 | 4202000.0 |
| 2004-08-23 | A | Stock | 15.98 | 16.0944 | 15.701 | 15.8441 | 2579729.0 |
| 2004-08-23 | AABA-DELISTED | Stock | 29.1000003814697 | 29.1900005340576 | 28.5599994659424 | 28.6299991607666 | 13024400.0 |
| 2004-08-23 | AACC-DELISTED | Stock | 18.19 | 18.19 | 17.86 | 17.92 | 98660.0 |
| 2004-08-23 | AAI-DELISTED | Stock | 11.38 | 11.52 | 11.25 | 11.37 | 838900.0 |
| 2004-08-23 | AAIC-DELISTED | Stock | 358.4 | 365.0 | 357.0 | 360.0 | 1518800.0 |
| 2004-08-23 | AAME | Stock | 3.08 | 3.12 | 3.0 | 3.0 | 8000.0 |
| 2004-08-23 | AAON | Stock | 2.215 | 2.2453 | 2.1491 | 2.1531 | 138206.0 |
| 2004-08-23 | AAP | Stock | 24.0667 | 24.12 | 23.8067 | 23.8133 | 995400.0 |
| 2004-08-23 | AAV-DELISTED | Stock | 14.75 | 14.9 | 14.63 | 14.75 | 26600.0 |
| 2004-08-23 | AAXN-DELISTED | Stock | 13.7849998474121 | 13.8699998855591 | 13.5 | 13.6300001144409 | 3426600.0 |
| 2004-08-23 | ABAX-DELISTED | Stock | 14.6 | 14.94 | 14.33 | 14.42 | 79358.0 |
| 2004-08-23 | ABB-DELISTED | Stock | 5.61 | 5.64 | 5.56 | 5.56 | 243900.0 |
| 2004-08-23 | ABC-DELISTED | Stock | 13.24 | 13.32 | 13.2 | 13.28 | 2738800.0 |
| 2004-08-23 | ABCB | Stock | 14.3626 | 14.5896 | 14.1925 | 14.4924 | 27266.0 |
| 2004-08-23 | ABCO-DELISTED | Stock | 15.317 | 15.407 | 15.003 | 15.203 | 141344.0 |
| 2004-08-23 | ABCW-DELISTED | Stock | 25.74 | 25.75 | 25.26 | 25.41 | 36360.0 |
| 2004-08-23 | ABE-DELISTED | Stock | 7.59 | 7.64 | 7.47 | 7.54 | 18100.0 |
| 2004-08-23 | ABFS-DELISTED | Stock | 36.24 | 36.25 | 34.95 | 35.09 | 485890.0 |
| 2004-08-23 | ABG | Stock | 13.35 | 14.09 | 12.9 | 14.05 | 52100.0 |
| 2004-08-23 | ABK-DELISTED | Stock | 74.25 | 75.07 | 74.06 | 74.56 | 464300.0 |
| 2004-08-23 | ABM | Stock | 17.79 | 17.9 | 17.55 | 17.55 | 149500.0 |
| 2004-08-23 | ABMD-DELISTED | Stock | 9.68 | 10.08 | 9.68 | 9.8 | 74361.0 |
| 2004-08-23 | ABP-DELISTED | Stock | 1.72 | 1.77 | 1.61 | 1.61 | 73800.0 |
| 2004-08-23 | ABR | Stock | 20.15 | 20.3 | 20.03 | 20.16 | 95100.0 |
| 2004-08-23 | ABT | Stock | 19.715 | 19.8877 | 19.5998 | 19.6142 | 4666111.0 |
| 2004-08-23 | ABTL-DELISTED | Stock | 33.6 | 35.45 | 33.1 | 34.3 | 62700.0 |
| 2004-08-23 | ABV-DELISTED | Stock | 22.36 | 22.39 | 22.19 | 22.3 | 251300.0 |
| 2004-08-23 | ABVA-DELISTED | Stock | 14.76 | 14.82 | 14.61 | 14.82 | 8314.0 |
| 2004-08-23 | ABVT-DELISTED | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 1500.0 |
| 2004-08-23 | ABX-DELISTED | Stock | 20.05 | 20.12 | 19.58 | 19.75 | 1141100.0 |
| 2004-08-23 | ACAD | Stock | 5.7 | 5.7 | 5.3 | 5.7 | 3400.0 |
| 2004-08-23 | ACAP-DELISTED | Stock | 27.64 | 27.64 | 27.2 | 27.4 | 75752.0 |
| 2004-08-23 | ACAS-DELISTED | Stock | 30.97 | 31.37 | 30.33 | 30.68 | 1111357.0 |
| 2004-08-23 | ACAT-DELISTED | Stock | 26.77 | 26.77 | 26.19 | 26.19 | 31689.0 |
| 2004-08-23 | ACC-DELISTED | Stock | 17.44 | 17.5 | 17.24 | 17.43 | 30714.0 |
| 2004-08-23 | ACCL-DELISTED | Stock | 6.73 | 6.73 | 6.38 | 6.55 | 133522.0 |
| 2004-08-23 | ACE-DELISTED | Stock | 39.13 | 39.33 | 38.85 | 39.0 | 1015500.0 |
| 2004-08-23 | ACF-DELISTED | Stock | 20.9 | 21.02 | 20.61 | 20.8 | 1480100.0 |
| 2004-08-23 | ACG-DELISTED | Stock | 8.35 | 8.39 | 8.34 | 8.35 | 520900.0 |
| 2004-08-23 | ACGL | Stock | 4.1689 | 4.2011 | 4.1667 | 4.1756 | 892800.0 |
| 2004-08-23 | ACGN-DELISTED | Stock | 600.6712 | 623.3288 | 600.6712 | 623.3288 | 15300.0 |
| 2004-08-23 | ACH | Stock | 16.6067 | 16.64 | 16.1667 | 16.1733 | 197550.0 |
| 2004-08-23 | ACH-DELISTED | Stock | 11.987 | 12.012 | 11.688 | 11.763 | 478090.0 |
| 2004-08-23 | ACLS | Stock | 35.24 | 36.32 | 34.56 | 35.76 | 173325.0 |
| 2004-08-23 | ACO-DELISTED | Stock | 16.55 | 17.19 | 16.55 | 17.04 | 246000.0 |
> showing 50 of 3,807 rows — these rows as CSV