PREVIEW / stock_daily / 2004-08-26
file: by_date/stock_daily/2004/2004-08-26.parquet size: 127 KB rows: 3,813 symbols: 2,382
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-26 | AAPL | Stock | 0.59 | 0.6282 | 0.5846 | 0.6189 | 955858400.0 |
| 2004-08-26 | MSFT | Stock | 27.46 | 27.6 | 27.39 | 27.44 | 35465500.0 |
| 2004-08-26 | NVDA | Stock | 0.1054 | 0.1065 | 0.1046 | 0.1058 | 612720000.0 |
| 2004-08-26 | AMZN | Stock | 2.009 | 2.0415 | 1.985 | 2.0095 | 139434000.0 |
| 2004-08-26 | CL | Stock | 26.81 | 27.015 | 26.805 | 26.975 | 2040200.0 |
| 2004-08-26 | A | Stock | 15.701 | 15.8083 | 15.3219 | 15.4363 | 3939424.0 |
| 2004-08-26 | AABA-DELISTED | Stock | 29.0 | 29.4899997711182 | 28.9599990844727 | 29.1700000762939 | 9756000.0 |
| 2004-08-26 | AACC-DELISTED | Stock | 18.19 | 18.2 | 17.75 | 18.11 | 73512.0 |
| 2004-08-26 | AAI-DELISTED | Stock | 12.38 | 12.6 | 12.134 | 12.31 | 1689000.0 |
| 2004-08-26 | AAIC-DELISTED | Stock | 363.0 | 364.6 | 356.2 | 361.0 | 1089900.0 |
| 2004-08-26 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1400.0 |
| 2004-08-26 | AAON | Stock | 2.3282 | 2.3572 | 2.2808 | 2.2887 | 102516.0 |
| 2004-08-26 | AAP | Stock | 24.48 | 25.06 | 24.3667 | 25.0533 | 1077600.0 |
| 2004-08-26 | AAV-DELISTED | Stock | 15.02 | 15.03 | 14.87 | 15.02 | 42100.0 |
| 2004-08-26 | AAXN-DELISTED | Stock | 13.9849996566772 | 14.75 | 13.9849996566772 | 14.1300001144409 | 17683200.0 |
| 2004-08-26 | ABAX-DELISTED | Stock | 15.48 | 15.6 | 14.42 | 14.78 | 718904.0 |
| 2004-08-26 | ABB-DELISTED | Stock | 5.67 | 5.73 | 5.65 | 5.71 | 174300.0 |
| 2004-08-26 | ABC-DELISTED | Stock | 13.37 | 13.46 | 13.36 | 13.42 | 1752400.0 |
| 2004-08-26 | ABCB | Stock | 14.9382 | 14.9382 | 14.5977 | 14.9382 | 7773.0 |
| 2004-08-26 | ABCO-DELISTED | Stock | 15.625 | 15.625 | 15.46 | 15.505 | 183084.0 |
| 2004-08-26 | ABCW-DELISTED | Stock | 25.84 | 25.93 | 25.65 | 25.86 | 23400.0 |
| 2004-08-26 | ABE-DELISTED | Stock | 7.61 | 7.66 | 7.58 | 7.58 | 15800.0 |
| 2004-08-26 | ABFS-DELISTED | Stock | 35.0 | 35.6 | 34.94 | 35.15 | 188667.0 |
| 2004-08-26 | ABG | Stock | 13.78 | 13.8 | 13.4 | 13.45 | 43500.0 |
| 2004-08-26 | ABK-DELISTED | Stock | 75.01 | 75.31 | 74.64 | 74.99 | 243200.0 |
| 2004-08-26 | ABM | Stock | 18.14 | 18.3 | 17.99 | 18.05 | 50200.0 |
| 2004-08-26 | ABMD-DELISTED | Stock | 10.05 | 10.3 | 10.05 | 10.2 | 45388.0 |
| 2004-08-26 | ABP-DELISTED | Stock | 1.45 | 1.62 | 1.45 | 1.6 | 40200.0 |
| 2004-08-26 | ABR | Stock | 20.25 | 20.36 | 19.98 | 20.36 | 144800.0 |
| 2004-08-26 | ABT | Stock | 19.8397 | 19.9501 | 19.7534 | 19.7774 | 4014381.0 |
| 2004-08-26 | ABTL-DELISTED | Stock | 33.65 | 34.15 | 33.25 | 34.0 | 17500.0 |
| 2004-08-26 | ABV-DELISTED | Stock | 21.66 | 21.66 | 21.36 | 21.43 | 528700.0 |
| 2004-08-26 | ABVA-DELISTED | Stock | 15.06 | 15.15 | 14.55 | 14.55 | 2400.0 |
| 2004-08-26 | ABVT-DELISTED | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 39000.0 |
| 2004-08-26 | ABX-DELISTED | Stock | 19.82 | 19.9 | 19.6 | 19.6 | 1350300.0 |
| 2004-08-26 | ACAD | Stock | 5.7 | 6.0 | 5.15 | 5.94 | 36400.0 |
| 2004-08-26 | ACAP-DELISTED | Stock | 26.98 | 27.38 | 26.95 | 27.2 | 57770.0 |
| 2004-08-26 | ACAS-DELISTED | Stock | 31.27 | 31.81 | 31.15 | 31.63 | 673164.0 |
| 2004-08-26 | ACAT-DELISTED | Stock | 26.06 | 26.14 | 25.72 | 25.87 | 54974.0 |
| 2004-08-26 | ACC-DELISTED | Stock | 17.6 | 17.72 | 17.5 | 17.51 | 75700.0 |
| 2004-08-26 | ACCL-DELISTED | Stock | 6.84 | 6.93 | 6.28 | 6.28 | 87732.0 |
| 2004-08-26 | ACE-DELISTED | Stock | 39.21 | 39.36 | 38.95 | 39.0 | 843411.0 |
| 2004-08-26 | ACF-DELISTED | Stock | 21.28 | 21.54 | 21.0 | 21.26 | 1419000.0 |
| 2004-08-26 | ACG-DELISTED | Stock | 7.98 | 8.09 | 7.87 | 8.06 | 1112500.0 |
| 2004-08-26 | ACGL | Stock | 4.0667 | 4.1033 | 4.0278 | 4.0367 | 1562400.0 |
| 2004-08-26 | ACGN-DELISTED | Stock | 612.0 | 623.3288 | 578.0 | 623.3288 | 123600.0 |
| 2004-08-26 | ACH | Stock | 16.34 | 16.4933 | 16.2467 | 16.4667 | 176250.0 |
| 2004-08-26 | ACH-DELISTED | Stock | 12.413 | 12.5 | 12.313 | 12.5 | 566800.0 |
| 2004-08-26 | ACLS | Stock | 35.08 | 35.32 | 33.24 | 33.28 | 279150.0 |
| 2004-08-26 | ACO-DELISTED | Stock | 17.0 | 17.24 | 16.91 | 17.03 | 102900.0 |
> showing 50 of 3,813 rows — these rows as CSV