PREVIEW / stock_daily / 2001-09-25
file: by_date/stock_daily/2001/2001-09-25.parquet size: 100 KB rows: 3,008 symbols: 1,871
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-25 | AAPL | Stock | 0.2882 | 0.2896 | 0.2741 | 0.2775 | 374404800.0 |
| 2001-09-25 | MSFT | Stock | 26.135 | 26.5 | 25.08 | 25.65 | 84940600.0 |
| 2001-09-25 | NVDA | Stock | 0.2507 | 0.2616 | 0.2395 | 0.2402 | 941724000.0 |
| 2001-09-25 | AMZN | Stock | 0.3745 | 0.3785 | 0.351 | 0.3545 | 97262000.0 |
| 2001-09-25 | CL | Stock | 27.75 | 27.875 | 27.5 | 27.8 | 4801800.0 |
| 2001-09-25 | A | Stock | 15.1645 | 15.1645 | 13.2332 | 14.1488 | 3446210.0 |
| 2001-09-25 | AABA-DELISTED | Stock | 4.57999992370605 | 5.01999998092651 | 4.5 | 4.6399998664856 | 23675000.0 |
| 2001-09-25 | AAI-DELISTED | Stock | 3.11 | 3.3 | 3.0 | 3.21 | 1372200.0 |
| 2001-09-25 | AAIC-DELISTED | Stock | 96.0 | 106.0 | 96.0 | 102.0 | 482300.0 |
| 2001-09-25 | AAME | Stock | 1.27 | 1.33 | 1.25 | 1.26 | 40300.0 |
| 2001-09-25 | AAON | Stock | 1.7412 | 1.7593 | 1.6282 | 1.7506 | 321216.0 |
| 2001-09-25 | AAXN-DELISTED | Stock | 0.616666674613953 | 0.666666686534882 | 0.615000009536743 | 0.649999976158142 | 447600.0 |
| 2001-09-25 | ABAX-DELISTED | Stock | 3.9 | 4.08 | 3.75 | 4.08 | 24000.0 |
| 2001-09-25 | ABB-DELISTED | Stock | 7.3 | 7.4 | 7.18 | 7.36 | 17500.0 |
| 2001-09-25 | ABC-DELISTED | Stock | 16.775 | 17.05 | 16.7 | 17.04 | 3974952.0 |
| 2001-09-25 | ABCB | Stock | 10.537 | 10.6585 | 10.537 | 10.6585 | 2468.0 |
| 2001-09-25 | ABCW-DELISTED | Stock | 16.65 | 16.75 | 16.57 | 16.64 | 68000.0 |
| 2001-09-25 | ABE-DELISTED | Stock | 6.15 | 6.24 | 6.13 | 6.13 | 17100.0 |
| 2001-09-25 | ABFS-DELISTED | Stock | 20.0 | 20.7 | 19.84 | 20.5 | 86500.0 |
| 2001-09-25 | ABK-DELISTED | Stock | 49.24 | 51.7 | 49.2 | 51.29 | 668600.0 |
| 2001-09-25 | ABM | Stock | 13.05 | 13.31 | 12.825 | 12.995 | 195600.0 |
| 2001-09-25 | ABMD-DELISTED | Stock | 13.3 | 14.35 | 13.01 | 14.1 | 173700.0 |
| 2001-09-25 | ABP-DELISTED | Stock | 1.9 | 1.9 | 1.7 | 1.8 | 638900.0 |
| 2001-09-25 | ABT | Stock | 21.0759 | 21.9737 | 21.0714 | 21.7492 | 9214952.0 |
| 2001-09-25 | ABTL-DELISTED | Stock | 4.05 | 4.25 | 3.6 | 3.7 | 17400.0 |
| 2001-09-25 | ABV-DELISTED | Stock | 15.0 | 15.74 | 15.0 | 15.35 | 217300.0 |
| 2001-09-25 | ABX-DELISTED | Stock | 16.55 | 16.68 | 16.4 | 16.4 | 1715200.0 |
| 2001-09-25 | ACAP-DELISTED | Stock | 19.82 | 20.24 | 19.8 | 19.88 | 81200.0 |
| 2001-09-25 | ACAS-DELISTED | Stock | 26.4 | 26.5 | 25.8 | 26.23 | 379500.0 |
| 2001-09-25 | ACAT-DELISTED | Stock | 13.3 | 13.67 | 13.0 | 13.06 | 70100.0 |
| 2001-09-25 | ACCL-DELISTED | Stock | 8.39970970153809 | 8.87038040161133 | 8.39970970153809 | 8.87038040161133 | 335900.0 |
| 2001-09-25 | ACE-DELISTED | Stock | 23.4 | 25.6 | 23.4 | 25.0 | 3942300.0 |
| 2001-09-25 | ACF-DELISTED | Stock | 29.77 | 30.85 | 29.4 | 30.0 | 2139700.0 |
| 2001-09-25 | ACG-DELISTED | Stock | 8.43 | 8.45 | 8.35 | 8.44 | 253600.0 |
| 2001-09-25 | ACGL | Stock | 1.8889 | 1.9167 | 1.8889 | 1.9 | 17100.0 |
| 2001-09-25 | ACGN-DELISTED | Stock | 1020.0 | 1144.6712 | 906.6712 | 1144.6712 | 12800.0 |
| 2001-09-25 | ACH | Stock | 12.0 | 12.2267 | 11.6667 | 12.2267 | 202800.0 |
| 2001-09-25 | ACLS | Stock | 39.52 | 42.92 | 38.44 | 40.84 | 312025.0 |
| 2001-09-25 | ACO-DELISTED | Stock | 5.74 | 5.74 | 5.6 | 5.6 | 6100.0 |
| 2001-09-25 | ACPW-DELISTED | Stock | 27.4 | 27.4 | 25.0 | 26.25 | 94940.0 |
| 2001-09-25 | ACS-DELISTED | Stock | 39.25 | 40.055 | 39.0 | 39.4 | 2399800.0 |
| 2001-09-25 | ACTA-DELISTED | Stock | 10.6 | 11.0 | 10.0 | 10.2 | 55500.0 |
| 2001-09-25 | ACTT-DELISTED | Stock | 8.445 | 8.8 | 7.64 | 7.9 | 332100.0 |
| 2001-09-25 | ACTU-DELISTED | Stock | 4.3 | 4.35 | 4.05 | 4.1 | 608000.0 |
| 2001-09-25 | ACXM-DELISTED | Stock | 8.89 | 9.49 | 8.65 | 9.4 | 1113800.0 |
| 2001-09-25 | ACY-DELISTED | Stock | 5.6 | 5.75 | 5.55 | 5.69 | 5400.0 |
| 2001-09-25 | AD | Stock | 32.8333 | 33.1667 | 32.8333 | 33.1667 | 143400.0 |
| 2001-09-25 | ADAT-DELISTED | Stock | 71.82 | 72.0 | 64.44 | 72.0 | 2284.0 |
| 2001-09-25 | ADBE | Stock | 12.655 | 12.8 | 12.225 | 12.53 | 6509000.0 |
| 2001-09-25 | ADC | Stock | 17.85 | 18.6 | 17.85 | 18.34 | 11000.0 |
> showing 50 of 3,008 rows — these rows as CSV