PREVIEW / stock_daily / 2004-07-14
file: by_date/stock_daily/2004/2004-07-14.parquet size: 126 KB rows: 3,773 symbols: 2,358
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-14 | AAPL | Stock | 0.5154 | 0.5352 | 0.5132 | 0.5282 | 835800000.0 |
| 2004-07-14 | MSFT | Stock | 27.4 | 28.36 | 27.34 | 28.13 | 87656300.0 |
| 2004-07-14 | NVDA | Stock | 0.1325 | 0.1362 | 0.1286 | 0.1312 | 901608000.0 |
| 2004-07-14 | AMZN | Stock | 2.4475 | 2.52 | 2.4445 | 2.475 | 101312000.0 |
| 2004-07-14 | CL | Stock | 28.65 | 28.755 | 28.345 | 28.445 | 2596000.0 |
| 2004-07-14 | A | Stock | 18.5622 | 18.9986 | 18.3476 | 18.4549 | 3624175.0 |
| 2004-07-14 | AABA-DELISTED | Stock | 29.7399997711182 | 31.1499996185303 | 29.2999992370605 | 30.6599998474121 | 18758700.0 |
| 2004-07-14 | AACC-DELISTED | Stock | 17.25 | 17.25 | 16.23 | 16.51 | 99182.0 |
| 2004-07-14 | AAI-DELISTED | Stock | 12.66 | 12.66 | 12.0 | 12.34 | 2667700.0 |
| 2004-07-14 | AAIC-DELISTED | Stock | 351.8 | 354.8 | 342.4 | 351.2 | 1083200.0 |
| 2004-07-14 | AAME | Stock | 2.98 | 2.98 | 2.64 | 2.69 | 7000.0 |
| 2004-07-14 | AAON | Stock | 2.4994 | 2.5758 | 2.4994 | 2.5139 | 132891.0 |
| 2004-07-14 | AAP | Stock | 26.8 | 26.8 | 25.4933 | 25.9733 | 2655750.0 |
| 2004-07-14 | AAV-DELISTED | Stock | 14.6 | 14.68 | 14.54 | 14.6 | 19900.0 |
| 2004-07-14 | AAXN-DELISTED | Stock | 19.6800003051758 | 20.3850002288818 | 19.3500003814697 | 19.875 | 9386800.0 |
| 2004-07-14 | ABAX-DELISTED | Stock | 15.73 | 16.1 | 15.51 | 16.0 | 250767.0 |
| 2004-07-14 | ABB-DELISTED | Stock | 5.35 | 5.48 | 5.32 | 5.38 | 255100.0 |
| 2004-07-14 | ABC-DELISTED | Stock | 13.32 | 13.6 | 13.17 | 13.2 | 4731600.0 |
| 2004-07-14 | ABCB | Stock | 15.8135 | 15.9919 | 15.4812 | 15.4893 | 19493.0 |
| 2004-07-14 | ABCO-DELISTED | Stock | 16.685 | 17.075 | 16.6 | 16.6 | 64802.0 |
| 2004-07-14 | ABCW-DELISTED | Stock | 25.85 | 26.42 | 25.85 | 25.97 | 90250.0 |
| 2004-07-14 | ABE-DELISTED | Stock | 7.71 | 7.83 | 7.71 | 7.79 | 10000.0 |
| 2004-07-14 | ABFS-DELISTED | Stock | 31.0 | 31.5 | 30.93 | 31.29 | 194009.0 |
| 2004-07-14 | ABG | Stock | 13.53 | 13.65 | 13.12 | 13.22 | 18700.0 |
| 2004-07-14 | ABK-DELISTED | Stock | 73.0 | 73.35 | 72.3 | 72.5 | 877400.0 |
| 2004-07-14 | ABM | Stock | 18.9 | 18.9 | 18.62 | 18.62 | 102200.0 |
| 2004-07-14 | ABMD-DELISTED | Stock | 10.39 | 11.23 | 10.35 | 10.83 | 106817.0 |
| 2004-07-14 | ABP-DELISTED | Stock | 1.48 | 1.49 | 1.35 | 1.39 | 50500.0 |
| 2004-07-14 | ABR | Stock | 20.0 | 20.14 | 19.95 | 19.95 | 39500.0 |
| 2004-07-14 | ABT | Stock | 19.168 | 19.3695 | 18.9617 | 19.0816 | 8547311.0 |
| 2004-07-14 | ABTL-DELISTED | Stock | 36.4 | 36.8 | 34.85 | 35.0 | 110800.0 |
| 2004-07-14 | ABV-DELISTED | Stock | 21.4 | 21.73 | 21.3 | 21.6 | 595400.0 |
| 2004-07-14 | ABX-DELISTED | Stock | 20.86 | 20.96 | 20.61 | 20.68 | 1458065.0 |
| 2004-07-14 | ACAD | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 100.0 |
| 2004-07-14 | ACAP-DELISTED | Stock | 23.94 | 24.32 | 23.7 | 23.94 | 48820.0 |
| 2004-07-14 | ACAS-DELISTED | Stock | 28.36 | 28.6 | 28.07 | 28.4 | 759776.0 |
| 2004-07-14 | ACAT-DELISTED | Stock | 25.59 | 26.75 | 25.35 | 26.26 | 74984.0 |
| 2004-07-14 | ACCL-DELISTED | Stock | 8.71 | 8.87 | 8.38 | 8.71 | 92055.0 |
| 2004-07-14 | ACE-DELISTED | Stock | 42.44 | 42.78 | 42.11 | 42.44 | 560962.0 |
| 2004-07-14 | ACF-DELISTED | Stock | 19.0 | 19.71 | 18.94 | 19.24 | 953300.0 |
| 2004-07-14 | ACG-DELISTED | Stock | 8.0 | 8.04 | 7.99 | 8.02 | 384600.0 |
| 2004-07-14 | ACGL | Stock | 4.49 | 4.5511 | 4.4389 | 4.5044 | 565200.0 |
| 2004-07-14 | ACGN-DELISTED | Stock | 634.6712 | 634.6712 | 612.0 | 634.6712 | 248000.0 |
| 2004-07-14 | ACH | Stock | 16.4533 | 16.6267 | 16.3333 | 16.5 | 151950.0 |
| 2004-07-14 | ACH-DELISTED | Stock | 12.498 | 12.808 | 12.473 | 12.625 | 562076.0 |
| 2004-07-14 | ACLS | Stock | 39.6 | 39.96 | 38.12 | 38.52 | 741275.0 |
| 2004-07-14 | ACO-DELISTED | Stock | 18.3 | 18.98 | 18.16 | 18.66 | 89000.0 |
| 2004-07-14 | ACPW-DELISTED | Stock | 14.75 | 15.3 | 14.5 | 15.15 | 10988.0 |
| 2004-07-14 | ACS-DELISTED | Stock | 52.95 | 53.36 | 52.8 | 53.09 | 1376100.0 |
| 2004-07-14 | ACTA-DELISTED | Stock | 6.58 | 6.9 | 6.45 | 6.73 | 239300.0 |
> showing 50 of 3,773 rows — these rows as CSV