PREVIEW / stock_daily / 2004-05-20
file: by_date/stock_daily/2004/2004-05-20.parquet size: 125 KB rows: 3,710 symbols: 2,308
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-05-20 | AAPL | Stock | 0.4755 | 0.4821 | 0.4727 | 0.477 | 196296800.0 |
| 2004-05-20 | MSFT | Stock | 25.75 | 25.87 | 25.59 | 25.73 | 52089900.0 |
| 2004-05-20 | NVDA | Stock | 0.1785 | 0.1815 | 0.1753 | 0.1762 | 421488000.0 |
| 2004-05-20 | AMZN | Stock | 2.0825 | 2.0985 | 2.04 | 2.049 | 118526000.0 |
| 2004-05-20 | CL | Stock | 27.875 | 28.1 | 27.755 | 27.985 | 2502800.0 |
| 2004-05-20 | A | Stock | 17.9542 | 17.9542 | 17.382 | 17.382 | 5571030.0 |
| 2004-05-20 | AABA-DELISTED | Stock | 28.1200008392334 | 28.2999992370605 | 27.5100002288818 | 28.0300006866455 | 16537200.0 |
| 2004-05-20 | AACC-DELISTED | Stock | 19.11 | 19.5 | 19.11 | 19.5 | 50177.0 |
| 2004-05-20 | AAI-DELISTED | Stock | 12.71 | 13.05 | 12.7 | 13.01 | 773800.0 |
| 2004-05-20 | AAIC-DELISTED | Stock | 356.8 | 360.8 | 351.0 | 354.2 | 880300.0 |
| 2004-05-20 | AAME | Stock | 2.65 | 3.05 | 2.65 | 2.98 | 10300.0 |
| 2004-05-20 | AAON | Stock | 2.5942 | 2.5942 | 2.5455 | 2.5679 | 255909.0 |
| 2004-05-20 | AAP | Stock | 27.5 | 27.7867 | 27.0 | 27.7867 | 2530200.0 |
| 2004-05-20 | AAV-DELISTED | Stock | 14.4 | 14.45 | 14.31 | 14.4 | 14600.0 |
| 2004-05-20 | AAXN-DELISTED | Stock | 14.7950000762939 | 14.8050003051758 | 14.0500001907349 | 14.2550001144409 | 11398600.0 |
| 2004-05-20 | ABAX-DELISTED | Stock | 18.3 | 18.3 | 17.6 | 17.88 | 115685.0 |
| 2004-05-20 | ABB-DELISTED | Stock | 5.55 | 5.57 | 5.4 | 5.4 | 97400.0 |
| 2004-05-20 | ABC-DELISTED | Stock | 14.56 | 14.62 | 14.36 | 14.44 | 4500400.0 |
| 2004-05-20 | ABCB | Stock | 15.2543 | 15.3191 | 15.003 | 15.1164 | 47376.0 |
| 2004-05-20 | ABCO-DELISTED | Stock | 16.43 | 16.715 | 16.325 | 16.69 | 124858.0 |
| 2004-05-20 | ABCW-DELISTED | Stock | 25.97 | 26.29 | 25.92 | 25.97 | 53710.0 |
| 2004-05-20 | ABE-DELISTED | Stock | 7.42 | 7.46 | 7.27 | 7.44 | 11700.0 |
| 2004-05-20 | ABFS-DELISTED | Stock | 28.75 | 29.01 | 28.37 | 28.6 | 213168.0 |
| 2004-05-20 | ABG | Stock | 13.38 | 14.5 | 13.38 | 14.17 | 85000.0 |
| 2004-05-20 | ABK-DELISTED | Stock | 65.65 | 65.9 | 65.25 | 65.61 | 547700.0 |
| 2004-05-20 | ABM | Stock | 18.5 | 19.03 | 18.4 | 19.01 | 162000.0 |
| 2004-05-20 | ABMD-DELISTED | Stock | 10.57 | 11.0 | 10.33 | 10.75 | 50303.0 |
| 2004-05-20 | ABP-DELISTED | Stock | 1.92 | 1.95 | 1.83 | 1.85 | 85200.0 |
| 2004-05-20 | ABR | Stock | 19.03 | 19.18 | 18.9 | 18.97 | 30900.0 |
| 2004-05-20 | ABT | Stock | 19.4943 | 19.5423 | 19.2832 | 19.3167 | 6330971.0 |
| 2004-05-20 | ABTL-DELISTED | Stock | 48.0 | 49.65 | 45.15 | 45.35 | 61600.0 |
| 2004-05-20 | ABV-DELISTED | Stock | 16.8 | 16.8 | 16.26 | 16.31 | 700800.0 |
| 2004-05-20 | ABVA-DELISTED | Stock | 14.81 | 14.81 | 14.7 | 14.75 | 19500.0 |
| 2004-05-20 | ABVT-DELISTED | Stock | 30.0 | 33.0 | 29.25 | 29.5 | 2700.0 |
| 2004-05-20 | ABX-DELISTED | Stock | 19.67 | 19.8 | 19.5 | 19.64 | 1421281.0 |
| 2004-05-20 | ACAP-DELISTED | Stock | 23.43 | 23.43 | 22.92 | 23.21 | 32099.0 |
| 2004-05-20 | ACAS-DELISTED | Stock | 26.33 | 26.45 | 25.95 | 26.17 | 412377.0 |
| 2004-05-20 | ACAT-DELISTED | Stock | 22.4 | 22.63 | 22.06 | 22.25 | 39511.0 |
| 2004-05-20 | ACCL-DELISTED | Stock | 9.57 | 9.81 | 9.27 | 9.4 | 111215.0 |
| 2004-05-20 | ACE-DELISTED | Stock | 40.43 | 40.5 | 39.64 | 39.68 | 2284142.0 |
| 2004-05-20 | ACF-DELISTED | Stock | 17.04 | 17.43 | 17.01 | 17.28 | 932900.0 |
| 2004-05-20 | ACG-DELISTED | Stock | 7.8 | 7.83 | 7.78 | 7.82 | 414100.0 |
| 2004-05-20 | ACGL | Stock | 4.2622 | 4.2622 | 4.1489 | 4.1567 | 1013400.0 |
| 2004-05-20 | ACGN-DELISTED | Stock | 725.3288 | 725.3288 | 702.6712 | 714.0 | 67700.0 |
| 2004-05-20 | ACH | Stock | 15.6333 | 15.9 | 15.6067 | 15.8133 | 157800.0 |
| 2004-05-20 | ACH-DELISTED | Stock | 12.847 | 13.1 | 12.593 | 12.628 | 746125.0 |
| 2004-05-20 | ACLS | Stock | 44.84 | 45.44 | 43.6 | 44.12 | 181625.0 |
| 2004-05-20 | ACO-DELISTED | Stock | 16.15 | 16.25 | 15.76 | 15.8 | 206400.0 |
| 2004-05-20 | ACPW-DELISTED | Stock | 16.25 | 17.2 | 15.85 | 16.9 | 17084.0 |
| 2004-05-20 | ACS-DELISTED | Stock | 48.1 | 48.92 | 48.0 | 48.9 | 1670600.0 |
> showing 50 of 3,710 rows — these rows as CSV