PREVIEW / stock_daily / 2001-04-18
file: by_date/stock_daily/2001/2001-04-18.parquet size: 101 KB rows: 2,954 symbols: 1,847
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-04-18 | AAPL | Stock | 0.3852 | 0.43 | 0.3764 | 0.407 | 1100842400.0 |
| 2001-04-18 | MSFT | Stock | 31.695 | 33.155 | 31.5 | 32.715 | 156696400.0 |
| 2001-04-18 | NVDA | Stock | 0.3122 | 0.3517 | 0.3122 | 0.3219 | 2301864000.0 |
| 2001-04-18 | AMZN | Stock | 0.783 | 0.908 | 0.7775 | 0.827 | 391100000.0 |
| 2001-04-18 | CL | Stock | 26.55 | 26.655 | 25.75 | 25.875 | 6061600.0 |
| 2001-04-18 | A | Stock | 24.6781 | 27.8112 | 24.4635 | 27.1745 | 4993376.0 |
| 2001-04-18 | AABA-DELISTED | Stock | 9.20499992370605 | 10.0450000762939 | 8.99499988555908 | 9.3100004196167 | 37386800.0 |
| 2001-04-18 | AAI-DELISTED | Stock | 9.49 | 9.87 | 9.13 | 9.84 | 767000.0 |
| 2001-04-18 | AAIC-DELISTED | Stock | 110.0 | 118.0 | 108.0 | 116.0 | 32000.0 |
| 2001-04-18 | AAME | Stock | 2.02 | 2.02 | 1.9 | 1.91 | 2300.0 |
| 2001-04-18 | AAON | Stock | 1.0652 | 1.1237 | 1.0535 | 1.0828 | 611677.0 |
| 2001-04-18 | ABAX-DELISTED | Stock | 4.24 | 4.7 | 4.24 | 4.7 | 20800.0 |
| 2001-04-18 | ABB-DELISTED | Stock | 17.0 | 17.25 | 16.96 | 17.2 | 23000.0 |
| 2001-04-18 | ABC-DELISTED | Stock | 13.2124996185303 | 13.5 | 12.5699996948242 | 12.8625001907349 | 4279600.0 |
| 2001-04-18 | ABCB | Stock | 9.5238 | 9.5238 | 9.5238 | 9.5238 | 123.0 |
| 2001-04-18 | ABCW-DELISTED | Stock | 13.9 | 14.15 | 13.3 | 13.43 | 51600.0 |
| 2001-04-18 | ABE-DELISTED | Stock | 7.91 | 8.36 | 7.91 | 8.36 | 56200.0 |
| 2001-04-18 | ABFS-DELISTED | Stock | 17.0 | 17.38 | 16.96 | 17.35 | 215100.0 |
| 2001-04-18 | ABK-DELISTED | Stock | 55.25 | 60.0 | 55.25 | 57.35 | 3071500.0 |
| 2001-04-18 | ABM | Stock | 15.065 | 15.27 | 14.905 | 15.01 | 215800.0 |
| 2001-04-18 | ABMD-DELISTED | Stock | 19.55 | 22.6 | 18.85 | 19.1 | 532700.0 |
| 2001-04-18 | ABP-DELISTED | Stock | 4.56 | 4.62 | 4.51 | 4.59 | 98200.0 |
| 2001-04-18 | ABT | Stock | 20.9322 | 21.049 | 20.5148 | 21.049 | 8478264.0 |
| 2001-04-18 | ABTL-DELISTED | Stock | 6.25 | 6.5 | 6.15 | 6.15 | 79100.0 |
| 2001-04-18 | ABV-DELISTED | Stock | 22.3 | 23.55 | 22.3 | 23.5 | 354500.0 |
| 2001-04-18 | ABX-DELISTED | Stock | 15.15 | 15.84 | 15.02 | 15.83 | 2549814.0 |
| 2001-04-18 | ACAP-DELISTED | Stock | 18.14 | 18.15 | 17.8 | 18.04 | 332200.0 |
| 2001-04-18 | ACAS-DELISTED | Stock | 25.92 | 26.4 | 25.91 | 26.22 | 162800.0 |
| 2001-04-18 | ACAT-DELISTED | Stock | 13.08 | 13.14 | 13.0 | 13.11 | 22300.0 |
| 2001-04-18 | ACCL-DELISTED | Stock | 15.3802003860474 | 15.6704998016357 | 15.1854000091553 | 15.6704998016357 | 390500.0 |
| 2001-04-18 | ACE-DELISTED | Stock | 34.2 | 35.95 | 34.2 | 35.5 | 4071381.0 |
| 2001-04-18 | ACF-DELISTED | Stock | 41.75 | 44.45 | 41.74 | 43.18 | 1881900.0 |
| 2001-04-18 | ACG-DELISTED | Stock | 8.0 | 8.0 | 7.85 | 7.93 | 358700.0 |
| 2001-04-18 | ACGL | Stock | 1.6889 | 1.7778 | 1.6889 | 1.7778 | 149400.0 |
| 2001-04-18 | ACGN-DELISTED | Stock | 521.3288 | 595.0 | 521.3288 | 566.6712 | 22500.0 |
| 2001-04-18 | ACH | Stock | 11.2267 | 11.4933 | 11.0 | 11.18 | 475350.0 |
| 2001-04-18 | ACLS | Stock | 53.72 | 60.16 | 52.0 | 53.6 | 1002875.0 |
| 2001-04-18 | ACO-DELISTED | Stock | 4.72 | 4.87 | 4.55 | 4.66 | 49700.0 |
| 2001-04-18 | ACPW-DELISTED | Stock | 112.98 | 119.97 | 112.98 | 115.27 | 273736.0 |
| 2001-04-18 | ACS-DELISTED | Stock | 33.95 | 34.875 | 33.25 | 33.255 | 807400.0 |
| 2001-04-18 | ACTA-DELISTED | Stock | 37.4 | 41.6 | 36.0 | 39.0 | 137500.0 |
| 2001-04-18 | ACTT-DELISTED | Stock | 5.1 | 6.0 | 5.0 | 5.95 | 12400.0 |
| 2001-04-18 | ACTU-DELISTED | Stock | 8.37 | 10.1 | 8.37 | 10.03 | 1072200.0 |
| 2001-04-18 | ACXM-DELISTED | Stock | 14.06 | 15.4 | 14.0 | 14.75 | 1506500.0 |
| 2001-04-18 | ACY-DELISTED | Stock | 4.62 | 4.62 | 4.55 | 4.55 | 4100.0 |
| 2001-04-18 | AD | Stock | 43.3333 | 44.2 | 43.0 | 44.2 | 286200.0 |
| 2001-04-18 | ADAT-DELISTED | Stock | 108.36 | 113.22 | 103.5 | 107.64 | 2325.0 |
| 2001-04-18 | ADBE | Stock | 21.075 | 24.4 | 20.925 | 22.97 | 17754200.0 |
| 2001-04-18 | ADC | Stock | 16.65 | 16.95 | 16.65 | 16.75 | 4500.0 |
| 2001-04-18 | ADEP-DELISTED | Stock | 52.55 | 60.0 | 51.5 | 51.5 | 37000.0 |
> showing 50 of 2,954 rows — these rows as CSV