PREVIEW / stock_daily / 2002-09-20
file: by_date/stock_daily/2002/2002-09-20.parquet size: 108 KB rows: 3,164 symbols: 1,952
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-20 | AAPL | Stock | 0.2611 | 0.2668 | 0.2593 | 0.2655 | 352788800.0 |
| 2002-09-20 | MSFT | Stock | 23.855 | 24.0 | 23.65 | 23.73 | 130619200.0 |
| 2002-09-20 | NVDA | Stock | 0.0769 | 0.0785 | 0.0751 | 0.0767 | 687312000.0 |
| 2002-09-20 | AMZN | Stock | 0.8725 | 0.882 | 0.7725 | 0.793 | 252112000.0 |
| 2002-09-20 | CL | Stock | 26.655 | 26.775 | 26.385 | 26.65 | 5027600.0 |
| 2002-09-20 | A | Stock | 10.1001 | 10.2361 | 9.8355 | 9.9928 | 4106066.0 |
| 2002-09-20 | AABA-DELISTED | Stock | 4.84999990463257 | 4.88500022888184 | 4.69999980926514 | 4.875 | 12771200.0 |
| 2002-09-20 | AAI-DELISTED | Stock | 3.19 | 3.19 | 2.85 | 3.03 | 320000.0 |
| 2002-09-20 | AAIC-DELISTED | Stock | 185.2 | 185.2 | 176.2 | 179.8 | 70800.0 |
| 2002-09-20 | AAME | Stock | 1.79 | 2.0 | 1.78 | 2.0 | 2000.0 |
| 2002-09-20 | AAON | Stock | 2.0451 | 2.1215 | 2.028 | 2.1057 | 395634.0 |
| 2002-09-20 | AAP | Stock | 17.2167 | 17.4 | 17.0133 | 17.2667 | 772200.0 |
| 2002-09-20 | AAXN-DELISTED | Stock | 0.462500005960464 | 0.474999994039536 | 0.462500005960464 | 0.474999994039536 | 181200.0 |
| 2002-09-20 | ABAX-DELISTED | Stock | 3.2 | 3.24 | 3.07 | 3.18 | 6236.0 |
| 2002-09-20 | ABB-DELISTED | Stock | 4.0 | 4.08 | 3.8 | 3.8 | 28900.0 |
| 2002-09-20 | ABC-DELISTED | Stock | 17.01 | 17.26 | 16.89 | 17.18 | 4865200.0 |
| 2002-09-20 | ABCB | Stock | 10.7314 | 10.8126 | 10.3343 | 10.3505 | 42564.0 |
| 2002-09-20 | ABCO-DELISTED | Stock | 14.004 | 14.43 | 13.826 | 14.085 | 174017.0 |
| 2002-09-20 | ABCW-DELISTED | Stock | 20.29 | 20.47 | 20.09 | 20.36 | 96100.0 |
| 2002-09-20 | ABE-DELISTED | Stock | 5.8 | 5.8 | 5.62 | 5.69 | 25100.0 |
| 2002-09-20 | ABFS-DELISTED | Stock | 27.6 | 27.89 | 27.15 | 27.791 | 396200.0 |
| 2002-09-20 | ABG | Stock | 10.48 | 10.65 | 10.07 | 10.22 | 144700.0 |
| 2002-09-20 | ABK-DELISTED | Stock | 53.8 | 54.3 | 50.78 | 51.08 | 1255300.0 |
| 2002-09-20 | ABM | Stock | 13.6 | 14.74 | 13.5 | 13.7 | 325600.0 |
| 2002-09-20 | ABMD-DELISTED | Stock | 4.5 | 4.599 | 3.83 | 4.15 | 137005.0 |
| 2002-09-20 | ABP-DELISTED | Stock | 0.75 | 0.83 | 0.75 | 0.8 | 17300.0 |
| 2002-09-20 | ABT | Stock | 18.2927 | 18.975 | 18.0548 | 18.7641 | 19648658.0 |
| 2002-09-20 | ABTL-DELISTED | Stock | 10.25 | 11.75 | 10.25 | 11.5 | 51200.0 |
| 2002-09-20 | ABV-DELISTED | Stock | 11.85 | 12.46 | 11.85 | 12.45 | 246000.0 |
| 2002-09-20 | ABVA-DELISTED | Stock | 10.4 | 10.4 | 10.4 | 10.4 | 500.0 |
| 2002-09-20 | ABX-DELISTED | Stock | 17.44 | 17.89 | 17.36 | 17.83 | 5308200.0 |
| 2002-09-20 | ACAP-DELISTED | Stock | 17.2 | 17.49 | 16.92 | 17.08 | 42603.0 |
| 2002-09-20 | ACAS-DELISTED | Stock | 18.18 | 18.33 | 17.83 | 18.08 | 964537.0 |
| 2002-09-20 | ACAT-DELISTED | Stock | 14.35 | 14.4 | 13.85 | 13.95 | 114200.0 |
| 2002-09-20 | ACCL-DELISTED | Stock | 5.858069896698 | 6.36495018005371 | 5.858069896698 | 6.36495018005371 | 230600.0 |
| 2002-09-20 | ACE-DELISTED | Stock | 32.03 | 32.66 | 31.77 | 31.98 | 2258588.0 |
| 2002-09-20 | ACF-DELISTED | Stock | 7.1 | 7.2 | 6.04 | 6.6 | 3172200.0 |
| 2002-09-20 | ACG-DELISTED | Stock | 8.19 | 8.21 | 8.17 | 8.2 | 364300.0 |
| 2002-09-20 | ACGL | Stock | 3.0867 | 3.1444 | 3.0867 | 3.1444 | 640800.0 |
| 2002-09-20 | ACGN-DELISTED | Stock | 884.0 | 974.6712 | 884.0 | 974.6712 | 4700.0 |
| 2002-09-20 | ACH | Stock | 10.0067 | 10.02 | 9.8667 | 9.8733 | 321900.0 |
| 2002-09-20 | ACH-DELISTED | Stock | 2.8755 | 2.888 | 2.8755 | 2.888 | 14398.0 |
| 2002-09-20 | ACLS | Stock | 20.96 | 21.56 | 19.72 | 20.08 | 225275.0 |
| 2002-09-20 | ACO-DELISTED | Stock | 6.0 | 6.03 | 5.93 | 6.03 | 41000.0 |
| 2002-09-20 | ACPW-DELISTED | Stock | 6.8523 | 7.3636 | 6.1364 | 6.75 | 30771.0 |
| 2002-09-20 | ACS-DELISTED | Stock | 41.6 | 41.6 | 40.29 | 41.1 | 2367800.0 |
| 2002-09-20 | ACTA-DELISTED | Stock | 4.0 | 4.2 | 4.0 | 4.0 | 17700.0 |
| 2002-09-20 | ACTT-DELISTED | Stock | 1.85 | 1.85 | 1.7 | 1.7 | 26200.0 |
| 2002-09-20 | ACTU-DELISTED | Stock | 0.89 | 1.0 | 0.81 | 0.94 | 821370.0 |
| 2002-09-20 | ACXM-DELISTED | Stock | 17.51 | 17.51 | 16.36 | 16.57 | 962972.0 |
> showing 50 of 3,164 rows — these rows as CSV