PREVIEW / stock_daily / 2002-03-20
file: by_date/stock_daily/2002/2002-03-20.parquet size: 106 KB rows: 3,103 symbols: 1,938
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-03-20 | AAPL | Stock | 0.4404 | 0.4489 | 0.4375 | 0.445 | 294319200.0 |
| 2002-03-20 | MSFT | Stock | 30.7 | 31.01 | 30.05 | 30.05 | 55235200.0 |
| 2002-03-20 | NVDA | Stock | 0.4233 | 0.4242 | 0.3862 | 0.3877 | 2292588000.0 |
| 2002-03-20 | AMZN | Stock | 0.724 | 0.7565 | 0.715 | 0.725 | 143586000.0 |
| 2002-03-20 | CL | Stock | 28.5 | 28.64 | 28.4 | 28.405 | 2413200.0 |
| 2002-03-20 | A | Stock | 25.7511 | 25.9657 | 24.5351 | 24.578 | 5468976.0 |
| 2002-03-20 | AABA-DELISTED | Stock | 9.33500003814697 | 9.54500007629395 | 9.07999992370605 | 9.10000038146973 | 10253600.0 |
| 2002-03-20 | AAI-DELISTED | Stock | 6.4 | 6.45 | 5.65 | 5.77 | 2178300.0 |
| 2002-03-20 | AAIC-DELISTED | Stock | 140.2 | 144.0 | 138.6 | 143.0 | 54300.0 |
| 2002-03-20 | AAME | Stock | 2.1 | 2.41 | 2.1 | 2.41 | 400.0 |
| 2002-03-20 | AAON | Stock | 2.1676 | 2.1684 | 2.1377 | 2.1684 | 183389.0 |
| 2002-03-20 | AAP | Stock | 15.0 | 15.0 | 14.8267 | 14.8533 | 565200.0 |
| 2002-03-20 | AAXN-DELISTED | Stock | 1.50499999523163 | 1.52166664600372 | 1.46416664123535 | 1.49833333492279 | 678000.0 |
| 2002-03-20 | ABAX-DELISTED | Stock | 6.43 | 6.5 | 6.32 | 6.36 | 24700.0 |
| 2002-03-20 | ABB-DELISTED | Stock | 8.3 | 8.5 | 8.3 | 8.41 | 17400.0 |
| 2002-03-20 | ABC-DELISTED | Stock | 17.31 | 17.36 | 17.0 | 17.1 | 2806800.0 |
| 2002-03-20 | ABCB | Stock | 10.8693 | 10.8693 | 10.7639 | 10.8207 | 12954.0 |
| 2002-03-20 | ABCO-DELISTED | Stock | 14.7 | 15.1 | 14.7 | 14.915 | 91600.0 |
| 2002-03-20 | ABCW-DELISTED | Stock | 21.03 | 21.06 | 20.81 | 20.86 | 62770.0 |
| 2002-03-20 | ABE-DELISTED | Stock | 7.35 | 7.42 | 7.33 | 7.4 | 26800.0 |
| 2002-03-20 | ABFS-DELISTED | Stock | 26.49 | 27.15 | 25.81 | 26.98 | 506200.0 |
| 2002-03-20 | ABK-DELISTED | Stock | 58.0 | 58.41 | 56.85 | 56.99 | 757000.0 |
| 2002-03-20 | ABM | Stock | 17.325 | 17.375 | 17.23 | 17.25 | 122000.0 |
| 2002-03-20 | ABMD-DELISTED | Stock | 11.25 | 11.49 | 10.85 | 10.85 | 117500.0 |
| 2002-03-20 | ABP-DELISTED | Stock | 1.68 | 1.8 | 1.49 | 1.6 | 654000.0 |
| 2002-03-20 | ABT | Stock | 23.702 | 23.7962 | 23.0735 | 23.2531 | 18962538.0 |
| 2002-03-20 | ABTL-DELISTED | Stock | 16.3 | 16.4 | 15.25 | 16.25 | 34200.0 |
| 2002-03-20 | ABV-DELISTED | Stock | 19.95 | 20.05 | 19.6 | 19.87 | 259800.0 |
| 2002-03-20 | ABVA-DELISTED | Stock | 8.0 | 8.25 | 8.0 | 8.25 | 3000.0 |
| 2002-03-20 | ABX-DELISTED | Stock | 17.99 | 18.19 | 17.85 | 18.05 | 2119100.0 |
| 2002-03-20 | ACAP-DELISTED | Stock | 18.1 | 19.08 | 18.0 | 18.48 | 311200.0 |
| 2002-03-20 | ACAS-DELISTED | Stock | 31.0 | 31.25 | 30.68 | 30.8 | 276400.0 |
| 2002-03-20 | ACAT-DELISTED | Stock | 17.31 | 17.95 | 17.31 | 17.85 | 34100.0 |
| 2002-03-20 | ACCL-DELISTED | Stock | 9.59000015258789 | 9.77600002288818 | 9.35599994659424 | 9.35599994659424 | 65200.0 |
| 2002-03-20 | ACE-DELISTED | Stock | 41.15 | 41.16 | 40.2 | 40.25 | 2671800.0 |
| 2002-03-20 | ACF-DELISTED | Stock | 38.91 | 40.3 | 38.65 | 40.3 | 2601100.0 |
| 2002-03-20 | ACG-DELISTED | Stock | 7.75 | 7.75 | 7.68 | 7.68 | 833700.0 |
| 2002-03-20 | ACGL | Stock | 2.9544 | 2.9544 | 2.9333 | 2.9389 | 118800.0 |
| 2002-03-20 | ACGN-DELISTED | Stock | 1621.8 | 1666.0 | 1609.3288 | 1609.3288 | 22500.0 |
| 2002-03-20 | ACH | Stock | 13.3333 | 13.4667 | 13.2 | 13.2267 | 200400.0 |
| 2002-03-20 | ACH-DELISTED | Stock | 5.375 | 5.375 | 5.325 | 5.325 | 21200.0 |
| 2002-03-20 | ACLS | Stock | 52.52 | 53.16 | 51.4 | 51.44 | 135250.0 |
| 2002-03-20 | ACO-DELISTED | Stock | 6.15 | 6.15 | 6.0 | 6.07 | 67800.0 |
| 2002-03-20 | ACPW-DELISTED | Stock | 23.31 | 23.69 | 22.44 | 22.99 | 15321.0 |
| 2002-03-20 | ACS-DELISTED | Stock | 55.73 | 56.95 | 55.39 | 56.35 | 1500100.0 |
| 2002-03-20 | ACTA-DELISTED | Stock | 16.4 | 16.6 | 15.6 | 15.8 | 44300.0 |
| 2002-03-20 | ACTT-DELISTED | Stock | 5.15 | 5.18 | 5.01 | 5.02 | 17300.0 |
| 2002-03-20 | ACTU-DELISTED | Stock | 6.65 | 6.8 | 6.4 | 6.45 | 166000.0 |
| 2002-03-20 | ACXM-DELISTED | Stock | 17.1 | 17.13 | 16.62 | 16.7 | 328200.0 |
| 2002-03-20 | ACY-DELISTED | Stock | 4.65 | 4.65 | 4.65 | 4.65 | 100.0 |
> showing 50 of 3,103 rows — these rows as CSV