PREVIEW / stock_daily / 2002-05-23
file: by_date/stock_daily/2002/2002-05-23.parquet size: 107 KB rows: 3,114 symbols: 1,931
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-05-23 | AAPL | Stock | 0.4366 | 0.4507 | 0.4298 | 0.4496 | 369398400.0 |
| 2002-05-23 | MSFT | Stock | 26.85 | 27.42 | 26.505 | 27.41 | 51412800.0 |
| 2002-05-23 | NVDA | Stock | 0.318 | 0.3187 | 0.2883 | 0.2977 | 2556780000.0 |
| 2002-05-23 | AMZN | Stock | 0.942 | 0.9775 | 0.9305 | 0.9725 | 112964000.0 |
| 2002-05-23 | CL | Stock | 27.075 | 27.1 | 26.56 | 26.97 | 3982200.0 |
| 2002-05-23 | A | Stock | 20.1073 | 20.2432 | 19.578 | 19.907 | 2972707.0 |
| 2002-05-23 | AABA-DELISTED | Stock | 8.26500034332275 | 8.5649995803833 | 8.125 | 8.54500007629395 | 14567800.0 |
| 2002-05-23 | AAI-DELISTED | Stock | 6.05 | 6.09 | 5.95 | 6.06 | 229700.0 |
| 2002-05-23 | AAIC-DELISTED | Stock | 192.6 | 199.2 | 191.0 | 199.2 | 163200.0 |
| 2002-05-23 | AAME | Stock | 2.46 | 2.59 | 2.46 | 2.59 | 600.0 |
| 2002-05-23 | AAON | Stock | 2.625 | 2.625 | 2.546 | 2.5758 | 421453.0 |
| 2002-05-23 | AAP | Stock | 19.5333 | 19.7167 | 18.7533 | 19.68 | 6094200.0 |
| 2002-05-23 | AAXN-DELISTED | Stock | 1.54333329200745 | 1.54333329200745 | 1.45833337306976 | 1.5 | 1120800.0 |
| 2002-05-23 | ABAX-DELISTED | Stock | 5.449 | 5.449 | 5.06 | 5.2 | 6100.0 |
| 2002-05-23 | ABB-DELISTED | Stock | 9.22 | 9.28 | 9.2 | 9.21 | 5900.0 |
| 2002-05-23 | ABC-DELISTED | Stock | 19.46 | 19.62 | 19.26 | 19.62 | 2994400.0 |
| 2002-05-23 | ABCB | Stock | 11.7527 | 11.8581 | 11.7527 | 11.8581 | 87720.0 |
| 2002-05-23 | ABCO-DELISTED | Stock | 18.4 | 18.6 | 18.4 | 18.55 | 27600.0 |
| 2002-05-23 | ABCW-DELISTED | Stock | 22.07 | 22.7 | 22.0 | 22.69 | 62800.0 |
| 2002-05-23 | ABE-DELISTED | Stock | 7.38 | 7.6 | 7.38 | 7.57 | 14900.0 |
| 2002-05-23 | ABFS-DELISTED | Stock | 24.31 | 24.53 | 24.11 | 24.44 | 267900.0 |
| 2002-05-23 | ABG | Stock | 19.45 | 20.25 | 19.2 | 19.76 | 107400.0 |
| 2002-05-23 | ABK-DELISTED | Stock | 65.26 | 65.9 | 64.75 | 65.49 | 634400.0 |
| 2002-05-23 | ABM | Stock | 18.0 | 18.0 | 17.65 | 17.95 | 100600.0 |
| 2002-05-23 | ABMD-DELISTED | Stock | 7.01 | 7.7 | 6.94 | 7.7 | 174600.0 |
| 2002-05-23 | ABP-DELISTED | Stock | 0.88 | 0.89 | 0.84 | 0.87 | 55100.0 |
| 2002-05-23 | ABT | Stock | 21.3228 | 21.435 | 20.8066 | 21.435 | 8696129.0 |
| 2002-05-23 | ABTL-DELISTED | Stock | 19.0 | 19.15 | 18.25 | 18.8 | 28200.0 |
| 2002-05-23 | ABV-DELISTED | Stock | 18.86 | 18.98 | 18.73 | 18.92 | 225700.0 |
| 2002-05-23 | ABX-DELISTED | Stock | 22.25 | 23.45 | 22.05 | 23.17 | 4631200.0 |
| 2002-05-23 | ACAP-DELISTED | Stock | 16.65 | 17.03 | 16.57 | 16.75 | 81800.0 |
| 2002-05-23 | ACAS-DELISTED | Stock | 29.36 | 30.18 | 29.05 | 29.97 | 852700.0 |
| 2002-05-23 | ACAT-DELISTED | Stock | 20.01 | 20.25 | 19.7 | 20.22 | 75300.0 |
| 2002-05-23 | ACCL-DELISTED | Stock | 7.92999982833862 | 8.32699966430664 | 7.84899997711182 | 7.91499996185303 | 192100.0 |
| 2002-05-23 | ACE-DELISTED | Stock | 32.7 | 34.6 | 32.58 | 34.43 | 4396900.0 |
| 2002-05-23 | ACF-DELISTED | Stock | 37.35 | 37.56 | 35.86 | 37.44 | 1285600.0 |
| 2002-05-23 | ACG-DELISTED | Stock | 7.94 | 7.99 | 7.91 | 7.91 | 604900.0 |
| 2002-05-23 | ACGL | Stock | 3.2444 | 3.4156 | 3.2389 | 3.3444 | 577800.0 |
| 2002-05-23 | ACGN-DELISTED | Stock | 1337.3288 | 1337.3288 | 1280.6712 | 1314.6712 | 58900.0 |
| 2002-05-23 | ACH | Stock | 12.54 | 12.6667 | 12.48 | 12.4867 | 139500.0 |
| 2002-05-23 | ACH-DELISTED | Stock | 4.662 | 4.662 | 4.662 | 4.662 | 800.0 |
| 2002-05-23 | ACLS | Stock | 56.12 | 56.64 | 53.84 | 54.88 | 123450.0 |
| 2002-05-23 | ACO-DELISTED | Stock | 5.88 | 6.0 | 5.71 | 5.95 | 32800.0 |
| 2002-05-23 | ACPW-DELISTED | Stock | 23.05 | 23.35 | 21.7 | 22.75 | 23300.0 |
| 2002-05-23 | ACS-DELISTED | Stock | 55.9 | 56.28 | 54.81 | 56.0 | 905600.0 |
| 2002-05-23 | ACTA-DELISTED | Stock | 6.2 | 6.4 | 5.8 | 6.0 | 18800.0 |
| 2002-05-23 | ACTT-DELISTED | Stock | 3.85 | 3.85 | 3.48 | 3.499 | 146300.0 |
| 2002-05-23 | ACTU-DELISTED | Stock | 5.71 | 6.0 | 5.54 | 6.0 | 230900.0 |
| 2002-05-23 | ACXM-DELISTED | Stock | 16.84 | 17.09 | 16.74 | 16.95 | 699300.0 |
| 2002-05-23 | ACY-DELISTED | Stock | 4.5 | 4.6 | 4.1 | 4.1 | 5600.0 |
> showing 50 of 3,114 rows — these rows as CSV