PREVIEW / stock_daily / 2004-07-06
file: by_date/stock_daily/2004/2004-07-06.parquet size: 127 KB rows: 3,761 symbols: 2,345
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-07-06 | AAPL | Stock | 0.5584 | 0.5611 | 0.55 | 0.5527 | 348980800.0 |
| 2004-07-06 | MSFT | Stock | 28.32 | 28.33 | 27.94 | 28.02 | 69158900.0 |
| 2004-07-06 | NVDA | Stock | 0.1586 | 0.1602 | 0.1493 | 0.1511 | 575388000.0 |
| 2004-07-06 | AMZN | Stock | 2.6275 | 2.63 | 2.5245 | 2.562 | 123138000.0 |
| 2004-07-06 | CL | Stock | 29.085 | 29.2 | 28.925 | 29.145 | 2727600.0 |
| 2004-07-06 | A | Stock | 20.0858 | 20.7368 | 19.6137 | 19.6137 | 3629488.0 |
| 2004-07-06 | AABA-DELISTED | Stock | 34.0 | 34.0 | 32.2999992370605 | 33.2200012207031 | 27496900.0 |
| 2004-07-06 | AACC-DELISTED | Stock | 17.53 | 17.53 | 16.88 | 17.02 | 55591.0 |
| 2004-07-06 | AAI-DELISTED | Stock | 14.22 | 14.22 | 13.77 | 13.82 | 1279200.0 |
| 2004-07-06 | AAIC-DELISTED | Stock | 398.0 | 398.0 | 370.8 | 378.0 | 1543800.0 |
| 2004-07-06 | AAME | Stock | 2.75 | 3.08 | 2.74 | 3.02 | 15100.0 |
| 2004-07-06 | AAON | Stock | 2.481 | 2.585 | 2.481 | 2.5455 | 116184.0 |
| 2004-07-06 | AAP | Stock | 28.9 | 29.1333 | 28.6667 | 28.7733 | 619050.0 |
| 2004-07-06 | AAV-DELISTED | Stock | 14.46 | 14.46 | 14.25 | 14.46 | 44000.0 |
| 2004-07-06 | AAXN-DELISTED | Stock | 22.3600006103516 | 22.8349990844727 | 21.8649997711182 | 22.25 | 20879400.0 |
| 2004-07-06 | ABAX-DELISTED | Stock | 17.9 | 18.02 | 17.51 | 17.92 | 709423.0 |
| 2004-07-06 | ABB-DELISTED | Stock | 5.5 | 5.5 | 5.42 | 5.47 | 798400.0 |
| 2004-07-06 | ABC-DELISTED | Stock | 13.88 | 13.88 | 13.5 | 13.5 | 9693600.0 |
| 2004-07-06 | ABCB | Stock | 16.0486 | 16.0486 | 15.7082 | 15.7568 | 10610.0 |
| 2004-07-06 | ABCO-DELISTED | Stock | 17.737 | 17.787 | 17.078 | 17.338 | 165601.0 |
| 2004-07-06 | ABCW-DELISTED | Stock | 26.01 | 26.14 | 25.75 | 25.81 | 109430.0 |
| 2004-07-06 | ABE-DELISTED | Stock | 7.76 | 7.76 | 7.57 | 7.57 | 28300.0 |
| 2004-07-06 | ABFS-DELISTED | Stock | 32.45 | 32.49 | 31.45 | 31.6 | 208000.0 |
| 2004-07-06 | ABG | Stock | 14.23 | 14.45 | 14.23 | 14.38 | 25500.0 |
| 2004-07-06 | ABK-DELISTED | Stock | 72.82 | 73.2 | 72.39 | 72.89 | 671700.0 |
| 2004-07-06 | ABM | Stock | 19.32 | 19.32 | 18.85 | 18.85 | 79800.0 |
| 2004-07-06 | ABMD-DELISTED | Stock | 11.91 | 12.22 | 11.42 | 12.07 | 103419.0 |
| 2004-07-06 | ABP-DELISTED | Stock | 1.5 | 1.55 | 1.45 | 1.46 | 141600.0 |
| 2004-07-06 | ABR | Stock | 19.97 | 20.05 | 19.9 | 20.0 | 34600.0 |
| 2004-07-06 | ABT | Stock | 19.312 | 19.3935 | 19.0912 | 19.0912 | 8833681.0 |
| 2004-07-06 | ABTL-DELISTED | Stock | 43.0 | 43.25 | 41.8 | 41.8 | 116000.0 |
| 2004-07-06 | ABV-DELISTED | Stock | 20.01 | 20.02 | 19.79 | 19.81 | 244800.0 |
| 2004-07-06 | ABX-DELISTED | Stock | 20.0 | 20.02 | 19.48 | 19.64 | 1484800.0 |
| 2004-07-06 | ACAD | Stock | 6.15 | 6.25 | 6.15 | 6.15 | 2500.0 |
| 2004-07-06 | ACAP-DELISTED | Stock | 23.44 | 23.44 | 22.74 | 23.1 | 20684.0 |
| 2004-07-06 | ACAS-DELISTED | Stock | 28.44 | 28.7 | 28.19 | 28.35 | 662609.0 |
| 2004-07-06 | ACAT-DELISTED | Stock | 26.59 | 27.59 | 26.35 | 26.75 | 75191.0 |
| 2004-07-06 | ACCL-DELISTED | Stock | 9.36 | 9.64 | 8.84 | 9.05 | 125462.0 |
| 2004-07-06 | ACE-DELISTED | Stock | 41.5 | 41.61 | 41.08 | 41.35 | 1078300.0 |
| 2004-07-06 | ACF-DELISTED | Stock | 20.1 | 20.15 | 19.36 | 19.43 | 1094100.0 |
| 2004-07-06 | ACG-DELISTED | Stock | 7.95 | 8.0 | 7.95 | 7.98 | 338200.0 |
| 2004-07-06 | ACGL | Stock | 4.3911 | 4.4711 | 4.3811 | 4.4444 | 765000.0 |
| 2004-07-06 | ACGN-DELISTED | Stock | 702.6712 | 725.3288 | 691.3288 | 691.3288 | 37200.0 |
| 2004-07-06 | ACH | Stock | 16.6667 | 16.84 | 16.6 | 16.6667 | 197400.0 |
| 2004-07-06 | ACH-DELISTED | Stock | 14.092 | 14.129 | 13.907 | 13.984 | 1064901.0 |
| 2004-07-06 | ACLS | Stock | 45.08 | 45.12 | 42.8 | 43.72 | 330075.0 |
| 2004-07-06 | ACO-DELISTED | Stock | 18.6 | 18.66 | 18.37 | 18.65 | 109200.0 |
| 2004-07-06 | ACPW-DELISTED | Stock | 15.75 | 16.65 | 15.05 | 15.05 | 42283.0 |
| 2004-07-06 | ACS-DELISTED | Stock | 53.36 | 53.37 | 52.17 | 52.8 | 1342900.0 |
| 2004-07-06 | ACTA-DELISTED | Stock | 7.5 | 7.52 | 6.85 | 6.98 | 875900.0 |
> showing 50 of 3,761 rows — these rows as CSV