PREVIEW / stock_daily / 2002-11-20
file: by_date/stock_daily/2002/2002-11-20.parquet size: 110 KB rows: 3,240 symbols: 1,996
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-11-20 | AAPL | Stock | 0.2732 | 0.2804 | 0.2723 | 0.2773 | 208740000.0 |
| 2002-11-20 | MSFT | Stock | 27.505 | 28.45 | 27.465 | 28.31 | 76435400.0 |
| 2002-11-20 | NVDA | Stock | 0.1217 | 0.125 | 0.1201 | 0.124 | 1292796000.0 |
| 2002-11-20 | AMZN | Stock | 1.0675 | 1.15 | 1.061 | 1.145 | 265888000.0 |
| 2002-11-20 | CL | Stock | 26.575 | 26.7 | 25.975 | 26.565 | 3301200.0 |
| 2002-11-20 | A | Stock | 11.867 | 12.3033 | 11.4521 | 12.1674 | 6616874.0 |
| 2002-11-20 | AABA-DELISTED | Stock | 8.58500003814697 | 9.00500011444092 | 8.42500019073486 | 9.0 | 21584600.0 |
| 2002-11-20 | AAI-DELISTED | Stock | 3.74 | 3.74 | 3.51 | 3.58 | 166000.0 |
| 2002-11-20 | AAIC-DELISTED | Stock | 171.4 | 180.0 | 171.4 | 180.0 | 368700.0 |
| 2002-11-20 | AAME | Stock | 1.84 | 1.84 | 1.25 | 1.75 | 4400.0 |
| 2002-11-20 | AAON | Stock | 2.51 | 2.5745 | 2.5021 | 2.5745 | 135169.0 |
| 2002-11-20 | AAP | Stock | 17.65 | 17.9233 | 17.3333 | 17.7667 | 3022200.0 |
| 2002-11-20 | AAXN-DELISTED | Stock | 0.364166676998138 | 0.364166676998138 | 0.339166671037674 | 0.339166671037674 | 589200.0 |
| 2002-11-20 | ABAX-DELISTED | Stock | 3.95 | 4.28 | 3.9 | 4.042 | 33800.0 |
| 2002-11-20 | ABB-DELISTED | Stock | 2.54 | 2.65 | 2.5 | 2.62 | 178400.0 |
| 2002-11-20 | ABC-DELISTED | Stock | 14.9 | 15.48 | 14.88 | 15.06 | 11612800.0 |
| 2002-11-20 | ABCB | Stock | 10.4802 | 11.0233 | 10.464 | 11.0233 | 5552.0 |
| 2002-11-20 | ABCO-DELISTED | Stock | 15.285 | 15.29 | 14.78 | 15.24 | 176964.0 |
| 2002-11-20 | ABCW-DELISTED | Stock | 20.25 | 20.65 | 20.01 | 20.65 | 32900.0 |
| 2002-11-20 | ABE-DELISTED | Stock | 5.88 | 5.92 | 5.85 | 5.9 | 11100.0 |
| 2002-11-20 | ABFS-DELISTED | Stock | 27.75 | 28.94 | 27.75 | 28.89 | 89051.0 |
| 2002-11-20 | ABG | Stock | 8.21 | 8.29 | 8.21 | 8.27 | 20200.0 |
| 2002-11-20 | ABK-DELISTED | Stock | 57.75 | 58.98 | 57.15 | 58.82 | 605600.0 |
| 2002-11-20 | ABM | Stock | 14.14 | 14.64 | 14.12 | 14.5 | 69400.0 |
| 2002-11-20 | ABMD-DELISTED | Stock | 4.75 | 4.95 | 4.75 | 4.91 | 14298.0 |
| 2002-11-20 | ABP-DELISTED | Stock | 0.6 | 0.61 | 0.54 | 0.6 | 31700.0 |
| 2002-11-20 | ABT | Stock | 19.9761 | 20.3891 | 19.81 | 20.2903 | 10002654.0 |
| 2002-11-20 | ABTL-DELISTED | Stock | 13.45 | 13.95 | 12.6 | 13.95 | 17600.0 |
| 2002-11-20 | ABV-DELISTED | Stock | 14.5 | 14.6 | 14.15 | 14.5 | 561700.0 |
| 2002-11-20 | ABVA-DELISTED | Stock | 10.4 | 10.5 | 10.3 | 10.5 | 1400.0 |
| 2002-11-20 | ABX-DELISTED | Stock | 15.43 | 15.71 | 15.38 | 15.65 | 1473000.0 |
| 2002-11-20 | ACAP-DELISTED | Stock | 17.0 | 17.14 | 16.93 | 17.14 | 19043.0 |
| 2002-11-20 | ACAS-DELISTED | Stock | 19.2 | 19.48 | 18.95 | 19.34 | 542210.0 |
| 2002-11-20 | ACAT-DELISTED | Stock | 16.53 | 16.57 | 16.43 | 16.57 | 14086.0 |
| 2002-11-20 | ACCL-DELISTED | Stock | 7.27733993530273 | 7.60318994522095 | 7.27733993530273 | 7.60318994522095 | 39300.0 |
| 2002-11-20 | ACE-DELISTED | Stock | 32.02 | 33.01 | 31.62 | 32.98 | 1743556.0 |
| 2002-11-20 | ACF-DELISTED | Stock | 7.5 | 7.6 | 7.37 | 7.48 | 1535400.0 |
| 2002-11-20 | ACG-DELISTED | Stock | 8.17 | 8.19 | 8.14 | 8.16 | 369500.0 |
| 2002-11-20 | ACGL | Stock | 3.4011 | 3.4411 | 3.3889 | 3.41 | 408600.0 |
| 2002-11-20 | ACGN-DELISTED | Stock | 1167.3288 | 1201.3288 | 1156.0 | 1190.0 | 54200.0 |
| 2002-11-20 | ACH | Stock | 10.4267 | 10.6533 | 10.1667 | 10.5067 | 354300.0 |
| 2002-11-20 | ACH-DELISTED | Stock | 2.88 | 2.88 | 2.88 | 2.88 | 4000.0 |
| 2002-11-20 | ACLS | Stock | 25.0 | 27.0 | 24.92 | 26.88 | 100150.0 |
| 2002-11-20 | ACO-DELISTED | Stock | 5.38 | 5.85 | 5.38 | 5.85 | 7500.0 |
| 2002-11-20 | ACPW-DELISTED | Stock | 9.45 | 9.5 | 8.65 | 9.15 | 48237.0 |
| 2002-11-20 | ACS-DELISTED | Stock | 44.28 | 47.04 | 44.11 | 46.63 | 1983700.0 |
| 2002-11-20 | ACTA-DELISTED | Stock | 9.2 | 10.4 | 9.0 | 9.6 | 107200.0 |
| 2002-11-20 | ACTT-DELISTED | Stock | 1.405 | 1.43 | 1.3 | 1.36 | 15600.0 |
| 2002-11-20 | ACTU-DELISTED | Stock | 1.84 | 1.97 | 1.8 | 1.9 | 180067.0 |
| 2002-11-20 | ACXM-DELISTED | Stock | 12.95 | 13.72 | 12.9 | 13.51 | 654779.0 |
> showing 50 of 3,240 rows — these rows as CSV