PREVIEW / stock_daily / 2003-06-20
file: by_date/stock_daily/2003/2003-06-20.parquet size: 115 KB rows: 3,360 symbols: 2,069
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-20 | AAPL | Stock | 0.3455 | 0.3496 | 0.3375 | 0.3429 | 356546400.0 |
| 2003-06-20 | MSFT | Stock | 26.34 | 26.38 | 26.01 | 26.33 | 86048900.0 |
| 2003-06-20 | NVDA | Stock | 0.2016 | 0.2017 | 0.1942 | 0.1973 | 937848000.0 |
| 2003-06-20 | AMZN | Stock | 1.79 | 1.794 | 1.742 | 1.752 | 140250000.0 |
| 2003-06-20 | CL | Stock | 30.0 | 30.1 | 29.525 | 29.955 | 3824000.0 |
| 2003-06-20 | A | Stock | 13.9485 | 13.9843 | 13.5908 | 13.6338 | 3144382.0 |
| 2003-06-20 | AABA-DELISTED | Stock | 16.1499996185303 | 16.2450008392334 | 15.8149995803833 | 16.0699996948242 | 25535800.0 |
| 2003-06-20 | AAI-DELISTED | Stock | 9.15 | 9.3 | 9.11 | 9.2 | 370100.0 |
| 2003-06-20 | AAIC-DELISTED | Stock | 277.4 | 281.0 | 274.0 | 277.0 | 675000.0 |
| 2003-06-20 | AAME | Stock | 2.62 | 2.73 | 2.53 | 2.69 | 4500.0 |
| 2003-06-20 | AAON | Stock | 2.4033 | 2.4349 | 2.3058 | 2.3677 | 33412.0 |
| 2003-06-20 | AAP | Stock | 19.7833 | 19.86 | 19.41 | 19.5733 | 2967000.0 |
| 2003-06-20 | AAXN-DELISTED | Stock | 0.920833349227905 | 0.920833349227905 | 0.879166662693024 | 0.917500019073486 | 849600.0 |
| 2003-06-20 | ABAX-DELISTED | Stock | 6.0 | 6.02 | 5.92 | 6.0 | 47023.0 |
| 2003-06-20 | ABB-DELISTED | Stock | 3.7 | 3.75 | 3.66 | 3.69 | 203100.0 |
| 2003-06-20 | ABC-DELISTED | Stock | 17.0 | 17.73 | 16.99 | 17.53 | 6954000.0 |
| 2003-06-20 | ABCB | Stock | 11.9635 | 12.0851 | 11.4447 | 11.6798 | 10240.0 |
| 2003-06-20 | ABCO-DELISTED | Stock | 19.69 | 19.885 | 19.105 | 19.695 | 84200.0 |
| 2003-06-20 | ABCW-DELISTED | Stock | 24.11 | 24.5 | 24.11 | 24.46 | 38600.0 |
| 2003-06-20 | ABE-DELISTED | Stock | 6.11 | 6.11 | 6.09 | 6.09 | 2300.0 |
| 2003-06-20 | ABFS-DELISTED | Stock | 24.53 | 25.04 | 24.5 | 24.58 | 317700.0 |
| 2003-06-20 | ABG | Stock | 12.7 | 12.95 | 12.65 | 12.65 | 78800.0 |
| 2003-06-20 | ABK-DELISTED | Stock | 68.0 | 68.01 | 66.66 | 66.99 | 769600.0 |
| 2003-06-20 | ABM | Stock | 15.61 | 16.0 | 15.61 | 15.95 | 134400.0 |
| 2003-06-20 | ABMD-DELISTED | Stock | 5.599 | 5.7 | 5.19 | 5.4 | 87801.0 |
| 2003-06-20 | ABP-DELISTED | Stock | 1.14 | 1.15 | 1.08 | 1.09 | 29800.0 |
| 2003-06-20 | ABT | Stock | 20.6046 | 20.7572 | 20.3801 | 20.4744 | 11536845.0 |
| 2003-06-20 | ABTL-DELISTED | Stock | 33.75 | 34.15 | 31.1 | 33.25 | 41300.0 |
| 2003-06-20 | ABV-DELISTED | Stock | 20.55 | 20.8 | 20.33 | 20.52 | 321900.0 |
| 2003-06-20 | ABVA-DELISTED | Stock | 16.55 | 16.55 | 16.55 | 16.55 | 1200.0 |
| 2003-06-20 | ABX-DELISTED | Stock | 18.46 | 18.6 | 18.37 | 18.51 | 1944739.0 |
| 2003-06-20 | ACAP-DELISTED | Stock | 24.9 | 24.92 | 24.5 | 24.5 | 7300.0 |
| 2003-06-20 | ACAS-DELISTED | Stock | 26.83 | 27.01 | 26.28 | 26.55 | 495727.0 |
| 2003-06-20 | ACAT-DELISTED | Stock | 17.509 | 17.52 | 15.87 | 16.72 | 207700.0 |
| 2003-06-20 | ACCL-DELISTED | Stock | 6.77046012878418 | 7.03113985061646 | 6.77046012878418 | 7.03113985061646 | 123900.0 |
| 2003-06-20 | ACE-DELISTED | Stock | 34.92 | 35.14 | 34.62 | 34.72 | 1426419.0 |
| 2003-06-20 | ACF-DELISTED | Stock | 9.36 | 9.45 | 9.1 | 9.21 | 1447000.0 |
| 2003-06-20 | ACG-DELISTED | Stock | 9.42 | 9.44 | 9.38 | 9.41 | 350500.0 |
| 2003-06-20 | ACGL | Stock | 3.84 | 3.8611 | 3.8056 | 3.8344 | 1004400.0 |
| 2003-06-20 | ACGN-DELISTED | Stock | 997.3288 | 997.3288 | 997.3288 | 997.3288 | 5000.0 |
| 2003-06-20 | ACH | Stock | 14.8667 | 14.9733 | 14.8667 | 14.8667 | 184650.0 |
| 2003-06-20 | ACH-DELISTED | Stock | 5.8737 | 6.0263 | 5.8737 | 6.0263 | 5599.0 |
| 2003-06-20 | ACLS | Stock | 25.76 | 26.0 | 24.8 | 25.24 | 164600.0 |
| 2003-06-20 | ACO-DELISTED | Stock | 7.65 | 7.9 | 7.55 | 7.69 | 51900.0 |
| 2003-06-20 | ACPW-DELISTED | Stock | 7.25 | 7.8 | 7.25 | 7.5 | 22080.0 |
| 2003-06-20 | ACS-DELISTED | Stock | 48.9 | 48.91 | 47.8 | 48.21 | 693800.0 |
| 2003-06-20 | ACTA-DELISTED | Stock | 13.0 | 13.2 | 11.8 | 12.0 | 314000.0 |
| 2003-06-20 | ACTG | Stock | 1.35 | 1.45 | 1.31 | 1.41 | 80100.0 |
| 2003-06-20 | ACTI-DELISTED | Stock | 9.51 | 10.0 | 9.51 | 9.95 | 505320.0 |
| 2003-06-20 | ACTT-DELISTED | Stock | 1.55 | 1.55 | 1.51 | 1.54 | 17600.0 |
> showing 50 of 3,360 rows — these rows as CSV