PREVIEW / stock_daily / 2004-08-18
file: by_date/stock_daily/2004/2004-08-18.parquet size: 128 KB rows: 3,816 symbols: 2,386
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-18 | AAPL | Stock | 0.5448 | 0.5688 | 0.5445 | 0.5668 | 364655200.0 |
| 2004-08-18 | MSFT | Stock | 26.93 | 27.5 | 26.89 | 27.46 | 58844000.0 |
| 2004-08-18 | NVDA | Stock | 0.0918 | 0.0975 | 0.0911 | 0.0975 | 872424000.0 |
| 2004-08-18 | AMZN | Stock | 1.896 | 1.977 | 1.871 | 1.968 | 190996000.0 |
| 2004-08-18 | CL | Stock | 25.815 | 26.07 | 25.775 | 26.065 | 2940400.0 |
| 2004-08-18 | A | Stock | 15.1931 | 15.5794 | 15.1359 | 15.5722 | 3756566.0 |
| 2004-08-18 | AABA-DELISTED | Stock | 27.4599990844727 | 28.5400009155273 | 27.4200000762939 | 28.4799995422363 | 22358300.0 |
| 2004-08-18 | AACC-DELISTED | Stock | 17.84 | 18.19 | 17.64 | 18.04 | 34555.0 |
| 2004-08-18 | AAI-DELISTED | Stock | 10.72 | 11.66 | 10.52 | 11.55 | 1839900.0 |
| 2004-08-18 | AAIC-DELISTED | Stock | 339.0 | 352.0 | 336.0 | 346.2 | 1251000.0 |
| 2004-08-18 | AAME | Stock | 3.04 | 3.09 | 2.95 | 3.05 | 3000.0 |
| 2004-08-18 | AAON | Stock | 2.2229 | 2.2993 | 2.2137 | 2.2993 | 230091.0 |
| 2004-08-18 | AAP | Stock | 23.7267 | 24.0933 | 23.5733 | 23.8333 | 1317600.0 |
| 2004-08-18 | AAV-DELISTED | Stock | 14.29 | 14.31 | 14.17 | 14.29 | 17400.0 |
| 2004-08-18 | AAXN-DELISTED | Stock | 13.7799997329712 | 13.875 | 13.375 | 13.7349996566772 | 11258400.0 |
| 2004-08-18 | ABAX-DELISTED | Stock | 13.43 | 14.56 | 13.3 | 14.56 | 154303.0 |
| 2004-08-18 | ABB-DELISTED | Stock | 5.35 | 5.48 | 5.35 | 5.48 | 68900.0 |
| 2004-08-18 | ABC-DELISTED | Stock | 12.97 | 13.2 | 12.96 | 13.09 | 5181200.0 |
| 2004-08-18 | ABCB | Stock | 14.0303 | 14.1844 | 13.925 | 14.1844 | 13695.0 |
| 2004-08-18 | ABCO-DELISTED | Stock | 15.08 | 15.495 | 15.015 | 15.325 | 81132.0 |
| 2004-08-18 | ABCW-DELISTED | Stock | 25.15 | 25.7 | 25.02 | 25.68 | 52530.0 |
| 2004-08-18 | ABE-DELISTED | Stock | 7.47 | 7.54 | 7.46 | 7.54 | 13300.0 |
| 2004-08-18 | ABFS-DELISTED | Stock | 35.97 | 36.94 | 35.97 | 36.68 | 249204.0 |
| 2004-08-18 | ABG | Stock | 13.42 | 13.42 | 12.8 | 12.98 | 98700.0 |
| 2004-08-18 | ABK-DELISTED | Stock | 70.75 | 72.0 | 70.52 | 72.0 | 296100.0 |
| 2004-08-18 | ABM | Stock | 17.62 | 17.99 | 17.5 | 17.93 | 51700.0 |
| 2004-08-18 | ABMD-DELISTED | Stock | 9.52 | 10.05 | 9.51 | 9.89 | 28610.0 |
| 2004-08-18 | ABP-DELISTED | Stock | 1.6 | 1.8 | 1.58 | 1.8 | 118500.0 |
| 2004-08-18 | ABR | Stock | 20.15 | 20.15 | 19.7 | 19.95 | 82700.0 |
| 2004-08-18 | ABT | Stock | 19.192 | 19.4799 | 19.0768 | 19.4751 | 5195498.0 |
| 2004-08-18 | ABTL-DELISTED | Stock | 32.75 | 33.05 | 31.9 | 32.5 | 64700.0 |
| 2004-08-18 | ABV-DELISTED | Stock | 21.77 | 22.1 | 21.51 | 22.01 | 299100.0 |
| 2004-08-18 | ABVA-DELISTED | Stock | 14.65 | 14.66 | 14.65 | 14.65 | 678.0 |
| 2004-08-18 | ABVT-DELISTED | Stock | 24.5 | 25.0 | 24.0 | 25.0 | 202000.0 |
| 2004-08-18 | ABX-DELISTED | Stock | 19.1 | 19.44 | 19.01 | 19.26 | 1223400.0 |
| 2004-08-18 | ACAD | Stock | 5.7 | 5.7 | 5.7 | 5.7 | 900.0 |
| 2004-08-18 | ACAP-DELISTED | Stock | 27.5 | 27.56 | 26.91 | 27.35 | 107304.0 |
| 2004-08-18 | ACAS-DELISTED | Stock | 31.4 | 31.55 | 31.01 | 31.52 | 746968.0 |
| 2004-08-18 | ACAT-DELISTED | Stock | 25.92 | 26.22 | 25.63 | 25.99 | 118780.0 |
| 2004-08-18 | ACC-DELISTED | Stock | 17.25 | 17.29 | 17.0 | 17.11 | 121000.0 |
| 2004-08-18 | ACCL-DELISTED | Stock | 5.97 | 6.7 | 5.75 | 6.57 | 124493.0 |
| 2004-08-18 | ACE-DELISTED | Stock | 38.78 | 39.33 | 38.53 | 39.3 | 1669961.0 |
| 2004-08-18 | ACF-DELISTED | Stock | 20.27 | 20.81 | 19.92 | 20.75 | 982600.0 |
| 2004-08-18 | ACG-DELISTED | Stock | 8.32 | 8.35 | 8.31 | 8.35 | 344100.0 |
| 2004-08-18 | ACGL | Stock | 4.1756 | 4.19 | 4.1478 | 4.19 | 958500.0 |
| 2004-08-18 | ACGN-DELISTED | Stock | 657.3288 | 668.6712 | 623.3288 | 634.6712 | 53800.0 |
| 2004-08-18 | ACH | Stock | 16.3733 | 16.7933 | 16.2667 | 16.7533 | 102450.0 |
| 2004-08-18 | ACH-DELISTED | Stock | 11.126 | 11.571 | 11.126 | 11.564 | 611952.0 |
| 2004-08-18 | ACLS | Stock | 33.0 | 35.36 | 32.56 | 34.48 | 263150.0 |
| 2004-08-18 | ACO-DELISTED | Stock | 17.85 | 18.06 | 17.43 | 17.68 | 163300.0 |
> showing 50 of 3,816 rows — these rows as CSV