PREVIEW / stock_daily / 2004-04-27
file: by_date/stock_daily/2004/2004-04-27.parquet size: 126 KB rows: 3,716 symbols: 2,320
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-04-27 | AAPL | Stock | 0.4864 | 0.49 | 0.4766 | 0.4811 | 283864000.0 |
| 2004-04-27 | MSFT | Stock | 27.16 | 27.37 | 27.13 | 27.22 | 80716800.0 |
| 2004-04-27 | NVDA | Stock | 0.1882 | 0.1932 | 0.1838 | 0.1845 | 494568000.0 |
| 2004-04-27 | AMZN | Stock | 2.3795 | 2.44 | 2.3395 | 2.4 | 179674000.0 |
| 2004-04-27 | CL | Stock | 28.5 | 28.565 | 28.45 | 28.51 | 3562400.0 |
| 2004-04-27 | A | Stock | 20.8155 | 21.1588 | 20.5293 | 20.608 | 2374503.0 |
| 2004-04-27 | AABA-DELISTED | Stock | 28.4899997711182 | 29.125 | 28.2849998474121 | 28.7700004577637 | 20146600.0 |
| 2004-04-27 | AACC-DELISTED | Stock | 18.0 | 18.81 | 18.0 | 18.51 | 20998.0 |
| 2004-04-27 | AAI-DELISTED | Stock | 12.85 | 13.0 | 12.59 | 12.65 | 1734600.0 |
| 2004-04-27 | AAIC-DELISTED | Stock | 419.4 | 436.0 | 416.4 | 434.0 | 2189900.0 |
| 2004-04-27 | AAME | Stock | 2.9 | 2.9 | 2.89 | 2.89 | 500.0 |
| 2004-04-27 | AAON | Stock | 2.6535 | 2.6864 | 2.6535 | 2.664 | 114666.0 |
| 2004-04-27 | AAP | Stock | 28.7933 | 29.44 | 28.7667 | 29.4333 | 546750.0 |
| 2004-04-27 | AAV-DELISTED | Stock | 14.53 | 14.6 | 14.4 | 14.53 | 47100.0 |
| 2004-04-27 | AAXN-DELISTED | Stock | 20.6275005340576 | 20.7075004577637 | 19.1175003051758 | 19.5125007629395 | 20965200.0 |
| 2004-04-27 | ABAX-DELISTED | Stock | 21.74 | 22.25 | 21.675 | 21.96 | 151022.0 |
| 2004-04-27 | ABB-DELISTED | Stock | 6.19 | 6.39 | 6.19 | 6.34 | 648700.0 |
| 2004-04-27 | ABC-DELISTED | Stock | 14.66 | 14.74 | 14.55 | 14.58 | 4286400.0 |
| 2004-04-27 | ABCB | Stock | 15.4001 | 15.8297 | 15.4001 | 15.8297 | 60825.0 |
| 2004-04-27 | ABCO-DELISTED | Stock | 17.482 | 17.632 | 17.238 | 17.448 | 220195.0 |
| 2004-04-27 | ABCW-DELISTED | Stock | 24.3 | 25.19 | 24.25 | 24.65 | 57200.0 |
| 2004-04-27 | ABE-DELISTED | Stock | 8.11 | 8.36 | 8.11 | 8.36 | 16700.0 |
| 2004-04-27 | ABFS-DELISTED | Stock | 28.04 | 28.07 | 27.59 | 27.87 | 193685.0 |
| 2004-04-27 | ABG | Stock | 16.69 | 16.84 | 16.6 | 16.79 | 21200.0 |
| 2004-04-27 | ABK-DELISTED | Stock | 71.38 | 72.13 | 71.03 | 71.7 | 418300.0 |
| 2004-04-27 | ABM | Stock | 18.38 | 18.76 | 18.38 | 18.58 | 103800.0 |
| 2004-04-27 | ABMD-DELISTED | Stock | 13.69 | 13.7 | 13.25 | 13.39 | 207300.0 |
| 2004-04-27 | ABP-DELISTED | Stock | 2.65 | 2.69 | 2.58 | 2.6 | 107400.0 |
| 2004-04-27 | ABT | Stock | 19.7516 | 20.0389 | 19.6619 | 19.9402 | 9817758.0 |
| 2004-04-27 | ABTL-DELISTED | Stock | 50.75 | 52.5 | 47.6 | 49.5 | 257800.0 |
| 2004-04-27 | ABV-DELISTED | Stock | 18.15 | 19.06 | 18.15 | 19.0 | 1115800.0 |
| 2004-04-27 | ABVA-DELISTED | Stock | 16.0 | 16.0 | 15.5 | 15.5 | 8700.0 |
| 2004-04-27 | ABVT-DELISTED | Stock | 38.0 | 38.0 | 35.0 | 37.0 | 1400.0 |
| 2004-04-27 | ABX-DELISTED | Stock | 20.83 | 20.84 | 20.18 | 20.27 | 2355000.0 |
| 2004-04-27 | ACAP-DELISTED | Stock | 21.28 | 21.54 | 20.9 | 21.49 | 54521.0 |
| 2004-04-27 | ACAS-DELISTED | Stock | 28.34 | 28.49 | 27.48 | 27.49 | 1183877.0 |
| 2004-04-27 | ACAT-DELISTED | Stock | 26.64 | 26.96 | 25.96 | 26.42 | 34241.0 |
| 2004-04-27 | ACCL-DELISTED | Stock | 18.69 | 18.95 | 18.2 | 18.32 | 251847.0 |
| 2004-04-27 | ACE-DELISTED | Stock | 42.65 | 43.35 | 42.33 | 43.25 | 1271600.0 |
| 2004-04-27 | ACF-DELISTED | Stock | 17.45 | 18.12 | 17.06 | 17.15 | 1948000.0 |
| 2004-04-27 | ACG-DELISTED | Stock | 7.89 | 7.9 | 7.8 | 7.82 | 893600.0 |
| 2004-04-27 | ACGL | Stock | 4.5456 | 4.5656 | 4.5089 | 4.5656 | 720000.0 |
| 2004-04-27 | ACGN-DELISTED | Stock | 827.3288 | 929.3288 | 816.0 | 918.0 | 646100.0 |
| 2004-04-27 | ACH | Stock | 17.0 | 17.1533 | 16.9 | 17.0267 | 215550.0 |
| 2004-04-27 | ACH-DELISTED | Stock | 15.775 | 16.188 | 15.587 | 15.762 | 872509.0 |
| 2004-04-27 | ACLS | Stock | 41.4 | 41.72 | 39.52 | 39.88 | 311375.0 |
| 2004-04-27 | ACO-DELISTED | Stock | 19.18 | 19.6 | 18.49 | 18.56 | 200800.0 |
| 2004-04-27 | ACPW-DELISTED | Stock | 18.3 | 18.65 | 17.5 | 18.1 | 21707.0 |
| 2004-04-27 | ACS-DELISTED | Stock | 47.93 | 48.42 | 47.5 | 48.39 | 2115800.0 |
| 2004-04-27 | ACTA-DELISTED | Stock | 6.4 | 6.6 | 6.0 | 6.0 | 1206100.0 |
> showing 50 of 3,716 rows — these rows as CSV