PREVIEW / stock_daily / 2004-09-21
file: by_date/stock_daily/2004/2004-09-21.parquet size: 128 KB rows: 3,832 symbols: 2,389
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-09-21 | AAPL | Stock | 0.6741 | 0.6941 | 0.6689 | 0.6788 | 386652000.0 |
| 2004-09-21 | MSFT | Stock | 27.45 | 27.53 | 27.25 | 27.26 | 73874400.0 |
| 2004-09-21 | NVDA | Stock | 0.125 | 0.1265 | 0.1235 | 0.1255 | 503904000.0 |
| 2004-09-21 | AMZN | Stock | 2.1785 | 2.1885 | 2.1385 | 2.1645 | 133910000.0 |
| 2004-09-21 | CL | Stock | 24.15 | 24.15 | 22.88 | 23.035 | 38854400.0 |
| 2004-09-21 | A | Stock | 16.6237 | 16.7668 | 16.4092 | 16.681 | 3552877.0 |
| 2004-09-21 | AABA-DELISTED | Stock | 33.3499984741211 | 33.4799995422363 | 32.7999992370605 | 33.2599983215332 | 17063500.0 |
| 2004-09-21 | AACC-DELISTED | Stock | 17.3 | 17.47 | 17.0 | 17.0 | 21310.0 |
| 2004-09-21 | AAI-DELISTED | Stock | 11.31 | 11.38 | 11.06 | 11.13 | 740700.0 |
| 2004-09-21 | AAIC-DELISTED | Stock | 401.2 | 417.8 | 399.8 | 416.6 | 2392100.0 |
| 2004-09-21 | AAME | Stock | 2.96 | 3.0 | 2.96 | 3.0 | 700.0 |
| 2004-09-21 | AAON | Stock | 2.4428 | 2.4744 | 2.3704 | 2.4744 | 160987.0 |
| 2004-09-21 | AAP | Stock | 23.6133 | 23.7333 | 23.3933 | 23.5333 | 1102350.0 |
| 2004-09-21 | AAV-DELISTED | Stock | 15.98 | 16.04 | 15.76 | 15.98 | 36300.0 |
| 2004-09-21 | AAXN-DELISTED | Stock | 19.6049995422363 | 19.9950008392334 | 19.1149997711182 | 19.5249996185303 | 20998400.0 |
| 2004-09-21 | ABAX-DELISTED | Stock | 14.5 | 14.98 | 14.5 | 14.93 | 45394.0 |
| 2004-09-21 | ABB-DELISTED | Stock | 6.15 | 6.22 | 6.12 | 6.21 | 188500.0 |
| 2004-09-21 | ABC-DELISTED | Stock | 13.64 | 13.73 | 13.6 | 13.72 | 1880400.0 |
| 2004-09-21 | ABCB | Stock | 15.311 | 15.927 | 15.3029 | 15.8865 | 21837.0 |
| 2004-09-21 | ABCO-DELISTED | Stock | 16.798 | 17.252 | 16.553 | 17.112 | 443594.0 |
| 2004-09-21 | ABCW-DELISTED | Stock | 25.72 | 26.02 | 25.72 | 25.94 | 17290.0 |
| 2004-09-21 | ABE-DELISTED | Stock | 8.0 | 8.15 | 7.99 | 8.14 | 17200.0 |
| 2004-09-21 | ABFS-DELISTED | Stock | 35.98 | 36.69 | 35.68 | 36.53 | 115581.0 |
| 2004-09-21 | ABG | Stock | 14.12 | 14.19 | 14.01 | 14.15 | 10400.0 |
| 2004-09-21 | ABK-DELISTED | Stock | 78.7 | 79.69 | 78.7 | 79.69 | 257800.0 |
| 2004-09-21 | ABM | Stock | 20.06 | 20.5 | 20.06 | 20.5 | 157100.0 |
| 2004-09-21 | ABMD-DELISTED | Stock | 10.45 | 10.62 | 10.26 | 10.29 | 77531.0 |
| 2004-09-21 | ABP-DELISTED | Stock | 1.83 | 1.86 | 1.81 | 1.85 | 58800.0 |
| 2004-09-21 | ABR | Stock | 21.0 | 21.12 | 20.93 | 20.96 | 29000.0 |
| 2004-09-21 | ABT | Stock | 20.3915 | 20.7274 | 20.2907 | 20.6506 | 6496665.0 |
| 2004-09-21 | ABTL-DELISTED | Stock | 42.8 | 44.0 | 42.8 | 44.0 | 94900.0 |
| 2004-09-21 | ABV-DELISTED | Stock | 22.2 | 22.31 | 22.05 | 22.17 | 247100.0 |
| 2004-09-21 | ABVA-DELISTED | Stock | 14.81 | 14.95 | 14.7 | 14.8 | 3000.0 |
| 2004-09-21 | ABVT-DELISTED | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 3000.0 |
| 2004-09-21 | ABX-DELISTED | Stock | 19.565 | 19.895 | 19.545 | 19.875 | 1809057.0 |
| 2004-09-21 | ACAD | Stock | 7.41 | 7.58 | 7.25 | 7.25 | 3300.0 |
| 2004-09-21 | ACAP-DELISTED | Stock | 30.15 | 30.49 | 29.89 | 30.32 | 45952.0 |
| 2004-09-21 | ACAS-DELISTED | Stock | 31.74 | 31.97 | 31.575 | 31.59 | 4137161.0 |
| 2004-09-21 | ACAT-DELISTED | Stock | 26.3 | 26.5 | 26.27 | 26.34 | 74006.0 |
| 2004-09-21 | ACC-DELISTED | Stock | 18.75 | 18.8 | 18.5 | 18.8 | 136800.0 |
| 2004-09-21 | ACCL-DELISTED | Stock | 6.37 | 6.4 | 6.19 | 6.23 | 53447.0 |
| 2004-09-21 | ACE-DELISTED | Stock | 39.85 | 39.89 | 39.5 | 39.82 | 982700.0 |
| 2004-09-21 | ACF-DELISTED | Stock | 21.45 | 21.88 | 21.4 | 21.84 | 768800.0 |
| 2004-09-21 | ACG-DELISTED | Stock | 8.14 | 8.15 | 8.08 | 8.13 | 682000.0 |
| 2004-09-21 | ACGL | Stock | 4.4244 | 4.4344 | 4.3867 | 4.4156 | 1379700.0 |
| 2004-09-21 | ACGN-DELISTED | Stock | 589.3288 | 600.6712 | 566.6712 | 600.6712 | 38000.0 |
| 2004-09-21 | ACH | Stock | 16.6667 | 17.3267 | 16.6333 | 17.0867 | 99000.0 |
| 2004-09-21 | ACH-DELISTED | Stock | 15.593 | 15.693 | 15.27 | 15.398 | 1124829.0 |
| 2004-09-21 | ACLS | Stock | 33.92 | 35.2 | 33.68 | 35.12 | 371275.0 |
| 2004-09-21 | ACO-DELISTED | Stock | 18.0 | 18.48 | 17.93 | 18.47 | 108300.0 |
> showing 50 of 3,832 rows — these rows as CSV