PREVIEW / stock_daily / 2001-09-21
file: by_date/stock_daily/2001/2001-09-21.parquet size: 101 KB rows: 3,062 symbols: 1,923
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-21 | AAPL | Stock | 0.2643 | 0.2902 | 0.2621 | 0.2809 | 570516800.0 |
| 2001-09-21 | MSFT | Stock | 23.96 | 25.3 | 23.75 | 24.855 | 184976600.0 |
| 2001-09-21 | NVDA | Stock | 0.2221 | 0.2357 | 0.2167 | 0.2247 | 1226304000.0 |
| 2001-09-21 | AMZN | Stock | 0.3475 | 0.386 | 0.3345 | 0.374 | 257322000.0 |
| 2001-09-21 | CL | Stock | 26.45 | 26.75 | 25.765 | 26.32 | 7057800.0 |
| 2001-09-21 | A | Stock | 12.8755 | 14.628 | 12.8755 | 14.4134 | 4078106.0 |
| 2001-09-21 | AABA-DELISTED | Stock | 4.66499996185303 | 4.69999980926514 | 4.25 | 4.34000015258789 | 25924800.0 |
| 2001-09-21 | AAI-DELISTED | Stock | 2.68 | 3.23 | 2.63 | 3.1 | 947500.0 |
| 2001-09-21 | AAIC-DELISTED | Stock | 108.0 | 108.0 | 103.0 | 105.2 | 59600.0 |
| 2001-09-21 | AAME | Stock | 1.2 | 1.48 | 1.2 | 1.35 | 1500.0 |
| 2001-09-21 | AAON | Stock | 1.5802 | 1.6095 | 1.5721 | 1.5867 | 743238.0 |
| 2001-09-21 | AAXN-DELISTED | Stock | 0.583333313465118 | 0.625 | 0.554166674613953 | 0.566666662693024 | 530400.0 |
| 2001-09-21 | ABAX-DELISTED | Stock | 3.51 | 3.9 | 3.5 | 3.75 | 25500.0 |
| 2001-09-21 | ABB-DELISTED | Stock | 6.45 | 6.9 | 6.4 | 6.9 | 39100.0 |
| 2001-09-21 | ABC-DELISTED | Stock | 16.4 | 16.4 | 16.2 | 16.25 | 10690000.0 |
| 2001-09-21 | ABCB | Stock | 10.537 | 10.5856 | 10.537 | 10.5856 | 43058.0 |
| 2001-09-21 | ABCW-DELISTED | Stock | 15.0 | 16.2 | 14.99 | 16.19 | 35200.0 |
| 2001-09-21 | ABE-DELISTED | Stock | 5.9 | 5.9 | 5.79 | 5.84 | 27200.0 |
| 2001-09-21 | ABFS-DELISTED | Stock | 19.23 | 19.23 | 17.77 | 19.05 | 239400.0 |
| 2001-09-21 | ABK-DELISTED | Stock | 43.0 | 48.37 | 42.2 | 46.97 | 1193600.0 |
| 2001-09-21 | ABM | Stock | 13.6 | 13.6 | 12.775 | 12.795 | 254200.0 |
| 2001-09-21 | ABMD-DELISTED | Stock | 13.95 | 14.0 | 12.82 | 13.08 | 238500.0 |
| 2001-09-21 | ABP-DELISTED | Stock | 1.69 | 1.9 | 1.6 | 1.9 | 156700.0 |
| 2001-09-21 | ABT | Stock | 21.2285 | 21.5428 | 21.0265 | 21.1208 | 13951632.0 |
| 2001-09-21 | ABTL-DELISTED | Stock | 4.25 | 5.0 | 3.95 | 4.15 | 16000.0 |
| 2001-09-21 | ABV-DELISTED | Stock | 15.5 | 15.78 | 14.75 | 15.38 | 553400.0 |
| 2001-09-21 | ABX-DELISTED | Stock | 17.72 | 17.96 | 17.12 | 17.2 | 5231780.0 |
| 2001-09-21 | ACAP-DELISTED | Stock | 18.34 | 18.69 | 18.02 | 18.69 | 149700.0 |
| 2001-09-21 | ACAS-DELISTED | Stock | 24.35 | 26.11 | 24.14 | 26.05 | 332600.0 |
| 2001-09-21 | ACAT-DELISTED | Stock | 13.52 | 13.95 | 13.5 | 13.5 | 141100.0 |
| 2001-09-21 | ACCL-DELISTED | Stock | 8.39970970153809 | 8.50833034515381 | 8.26937007904053 | 8.50833034515381 | 427600.0 |
| 2001-09-21 | ACE-DELISTED | Stock | 19.0 | 20.99 | 18.1 | 20.7 | 6056800.0 |
| 2001-09-21 | ACF-DELISTED | Stock | 27.4 | 28.98 | 26.75 | 28.36 | 1741600.0 |
| 2001-09-21 | ACG-DELISTED | Stock | 7.68 | 8.15 | 7.68 | 8.1 | 445000.0 |
| 2001-09-21 | ACGL | Stock | 1.8556 | 1.8556 | 1.7778 | 1.7811 | 192600.0 |
| 2001-09-21 | ACGN-DELISTED | Stock | 929.3288 | 1156.0 | 918.0 | 1156.0 | 27400.0 |
| 2001-09-21 | ACH | Stock | 10.8267 | 11.6667 | 10.8267 | 11.5467 | 208500.0 |
| 2001-09-21 | ACLS | Stock | 37.44 | 39.08 | 34.8 | 36.0 | 281425.0 |
| 2001-09-21 | ACO-DELISTED | Stock | 5.64 | 5.74 | 5.3 | 5.69 | 67000.0 |
| 2001-09-21 | ACPW-DELISTED | Stock | 18.05 | 23.5 | 17.8 | 23.5 | 169400.0 |
| 2001-09-21 | ACS-DELISTED | Stock | 43.255 | 43.255 | 41.915 | 41.98 | 1294900.0 |
| 2001-09-21 | ACTA-DELISTED | Stock | 8.0 | 9.6 | 6.8 | 9.0 | 135900.0 |
| 2001-09-21 | ACTT-DELISTED | Stock | 6.95 | 7.1 | 6.35 | 6.9 | 88900.0 |
| 2001-09-21 | ACTU-DELISTED | Stock | 3.85 | 4.35 | 3.82 | 4.02 | 1297800.0 |
| 2001-09-21 | ACXM-DELISTED | Stock | 7.4 | 8.57 | 7.06 | 7.95 | 1573600.0 |
| 2001-09-21 | ACY-DELISTED | Stock | 5.95 | 5.95 | 5.8 | 5.8 | 4300.0 |
| 2001-09-21 | AD | Stock | 32.3333 | 32.3333 | 31.7333 | 32.1667 | 125400.0 |
| 2001-09-21 | ADAT-DELISTED | Stock | 54.9 | 62.1 | 42.3 | 62.1 | 4745.0 |
| 2001-09-21 | ADBE | Stock | 12.035 | 13.35 | 11.99 | 12.535 | 13191400.0 |
| 2001-09-21 | ADC | Stock | 18.2 | 18.2 | 17.15 | 17.3 | 29100.0 |
> showing 50 of 3,062 rows — these rows as CSV