PREVIEW / stock_daily / 2001-12-18
file: by_date/stock_daily/2001/2001-12-18.parquet size: 105 KB rows: 3,076 symbols: 1,920
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-12-18 | AAPL | Stock | 0.373 | 0.3809 | 0.3611 | 0.3752 | 235239200.0 |
| 2001-12-18 | MSFT | Stock | 34.46 | 34.7 | 34.3 | 34.635 | 47255200.0 |
| 2001-12-18 | NVDA | Stock | 0.5542 | 0.5621 | 0.5474 | 0.5521 | 886968000.0 |
| 2001-12-18 | AMZN | Stock | 0.5525 | 0.568 | 0.531 | 0.543 | 147084000.0 |
| 2001-12-18 | CL | Stock | 28.275 | 28.795 | 28.21 | 28.775 | 3061000.0 |
| 2001-12-18 | A | Stock | 20.7225 | 21.0443 | 20.3147 | 20.6152 | 3012690.0 |
| 2001-12-18 | AABA-DELISTED | Stock | 9.17000007629395 | 9.22500038146973 | 8.97999954223633 | 9.1899995803833 | 15585200.0 |
| 2001-12-18 | AAI-DELISTED | Stock | 6.6 | 6.7 | 6.36 | 6.39 | 190900.0 |
| 2001-12-18 | AAIC-DELISTED | Stock | 116.0 | 120.0 | 107.4 | 118.0 | 97600.0 |
| 2001-12-18 | AAME | Stock | 2.04 | 2.07 | 2.04 | 2.07 | 9000.0 |
| 2001-12-18 | AAON | Stock | 1.7892 | 1.8331 | 1.7892 | 1.8331 | 264262.0 |
| 2001-12-18 | AAP | Stock | 13.6833 | 13.8667 | 13.6667 | 13.6667 | 101400.0 |
| 2001-12-18 | AAXN-DELISTED | Stock | 1.02166664600372 | 1.05999994277954 | 1.00999999046326 | 1.05083334445953 | 397200.0 |
| 2001-12-18 | ABAX-DELISTED | Stock | 5.6 | 5.91 | 5.5 | 5.8 | 149700.0 |
| 2001-12-18 | ABB-DELISTED | Stock | 10.0 | 10.1 | 9.85 | 10.05 | 8600.0 |
| 2001-12-18 | ABC-DELISTED | Stock | 14.78 | 15.08 | 14.77 | 15.04 | 4655200.0 |
| 2001-12-18 | ABCB | Stock | 10.618 | 10.6585 | 10.618 | 10.6585 | 740.0 |
| 2001-12-18 | ABCO-DELISTED | Stock | 13.76 | 13.975 | 13.65 | 13.77 | 121200.0 |
| 2001-12-18 | ABCW-DELISTED | Stock | 17.72 | 18.0 | 17.72 | 17.9 | 49000.0 |
| 2001-12-18 | ABE-DELISTED | Stock | 7.0 | 7.02 | 6.9 | 6.95 | 38000.0 |
| 2001-12-18 | ABFS-DELISTED | Stock | 27.195 | 28.13 | 27.195 | 27.5 | 72700.0 |
| 2001-12-18 | ABK-DELISTED | Stock | 56.05 | 56.59 | 55.84 | 56.4 | 368900.0 |
| 2001-12-18 | ABM | Stock | 15.775 | 15.78 | 15.055 | 15.655 | 341200.0 |
| 2001-12-18 | ABMD-DELISTED | Stock | 16.75 | 16.8 | 16.09 | 16.75 | 137900.0 |
| 2001-12-18 | ABP-DELISTED | Stock | 1.02 | 1.2 | 1.0 | 1.2 | 142700.0 |
| 2001-12-18 | ABT | Stock | 24.1374 | 24.2406 | 23.9713 | 24.1733 | 9137652.0 |
| 2001-12-18 | ABTL-DELISTED | Stock | 8.1 | 8.8 | 7.8 | 8.25 | 12100.0 |
| 2001-12-18 | ABV-DELISTED | Stock | 20.08 | 20.6 | 20.0 | 20.29 | 542000.0 |
| 2001-12-18 | ABVA-DELISTED | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 800.0 |
| 2001-12-18 | ABX-DELISTED | Stock | 16.33 | 16.64 | 16.29 | 16.62 | 2635584.0 |
| 2001-12-18 | ACAP-DELISTED | Stock | 21.4 | 21.55 | 21.25 | 21.25 | 59900.0 |
| 2001-12-18 | ACAS-DELISTED | Stock | 27.52 | 28.39 | 27.5 | 28.39 | 149000.0 |
| 2001-12-18 | ACAT-DELISTED | Stock | 17.24 | 17.25 | 16.7 | 16.95 | 40700.0 |
| 2001-12-18 | ACCL-DELISTED | Stock | 10.6099996566772 | 10.6879997253418 | 10.1230001449585 | 10.3190002441406 | 295000.0 |
| 2001-12-18 | ACE-DELISTED | Stock | 38.0 | 38.67 | 37.8 | 38.3 | 1164100.0 |
| 2001-12-18 | ACF-DELISTED | Stock | 27.15 | 28.6 | 27.15 | 27.82 | 928200.0 |
| 2001-12-18 | ACG-DELISTED | Stock | 7.36 | 7.45 | 7.36 | 7.39 | 1198500.0 |
| 2001-12-18 | ACGL | Stock | 2.6389 | 2.6444 | 2.6333 | 2.6444 | 66600.0 |
| 2001-12-18 | ACGN-DELISTED | Stock | 1949.3288 | 2119.3288 | 1813.3288 | 1926.6712 | 7100.0 |
| 2001-12-18 | ACH | Stock | 12.2667 | 12.4333 | 12.2267 | 12.2667 | 139650.0 |
| 2001-12-18 | ACH-DELISTED | Stock | 4.425 | 4.495 | 4.425 | 4.49 | 344800.0 |
| 2001-12-18 | ACLS | Stock | 57.4 | 58.2 | 57.08 | 57.6 | 135525.0 |
| 2001-12-18 | ACO-DELISTED | Stock | 6.65 | 6.65 | 6.4 | 6.47 | 20000.0 |
| 2001-12-18 | ACPW-DELISTED | Stock | 27.75 | 28.1 | 26.5 | 27.3 | 104020.0 |
| 2001-12-18 | ACS-DELISTED | Stock | 50.5 | 51.69 | 50.01 | 51.69 | 616600.0 |
| 2001-12-18 | ACTA-DELISTED | Stock | 23.8 | 24.0 | 22.4 | 24.0 | 105200.0 |
| 2001-12-18 | ACTT-DELISTED | Stock | 8.7 | 9.0 | 8.7 | 9.0 | 39600.0 |
| 2001-12-18 | ACTU-DELISTED | Stock | 4.92 | 5.05 | 4.72 | 4.8 | 992000.0 |
| 2001-12-18 | ACXM-DELISTED | Stock | 17.25 | 18.25 | 17.21 | 18.0 | 2815200.0 |
| 2001-12-18 | ACY-DELISTED | Stock | 4.98 | 4.98 | 4.98 | 4.98 | 100.0 |
> showing 50 of 3,076 rows — these rows as CSV