PREVIEW / stock_daily / 2002-11-04
file: by_date/stock_daily/2002/2002-11-04.parquet size: 109 KB rows: 3,243 symbols: 2,003
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-04 | AAPL | Stock | 0.2946 | 0.3104 | 0.292 | 0.3016 | 376818400.0 |
| 2002-11-04 | MSFT | Stock | 28.375 | 28.625 | 27.76 | 28.05 | 139964200.0 |
| 2002-11-04 | NVDA | Stock | 0.1246 | 0.1376 | 0.1242 | 0.1303 | 2688132000.0 |
| 2002-11-04 | AMZN | Stock | 0.9695 | 0.9905 | 0.9295 | 0.939 | 259270000.0 |
| 2002-11-04 | CL | Stock | 27.45 | 27.505 | 26.55 | 26.645 | 5181800.0 |
| 2002-11-04 | A | Stock | 10.5508 | 11.1946 | 10.515 | 10.7511 | 4131649.0 |
| 2002-11-04 | AABA-DELISTED | Stock | 7.75500011444092 | 8.74499988555908 | 7.75 | 8.38500022888184 | 45498600.0 |
| 2002-11-04 | AAI-DELISTED | Stock | 4.05 | 4.19 | 4.04 | 4.12 | 387900.0 |
| 2002-11-04 | AAIC-DELISTED | Stock | 194.0 | 197.0 | 193.8 | 196.2 | 26100.0 |
| 2002-11-04 | AAME | Stock | 1.75 | 1.75 | 1.73 | 1.73 | 3300.0 |
| 2002-11-04 | AAON | Stock | 2.6074 | 2.6179 | 2.5679 | 2.6008 | 85050.0 |
| 2002-11-04 | AAP | Stock | 17.6333 | 17.9133 | 17.4067 | 17.5167 | 1080900.0 |
| 2002-11-04 | AAXN-DELISTED | Stock | 0.291666656732559 | 0.302500009536743 | 0.290833324193954 | 0.299166679382324 | 169200.0 |
| 2002-11-04 | ABAX-DELISTED | Stock | 3.91 | 4.3 | 3.91 | 4.25 | 20500.0 |
| 2002-11-04 | ABB-DELISTED | Stock | 1.62 | 1.74 | 1.59 | 1.66 | 1368900.0 |
| 2002-11-04 | ABC-DELISTED | Stock | 18.36 | 18.4 | 18.0 | 18.05 | 3462400.0 |
| 2002-11-04 | ABCB | Stock | 10.9017 | 11.0233 | 10.9017 | 10.9827 | 4812.0 |
| 2002-11-04 | ABCO-DELISTED | Stock | 16.398 | 16.647 | 16.073 | 16.597 | 128272.0 |
| 2002-11-04 | ABCW-DELISTED | Stock | 21.25 | 21.42 | 21.01 | 21.4 | 21810.0 |
| 2002-11-04 | ABE-DELISTED | Stock | 5.92 | 5.98 | 5.92 | 5.98 | 12000.0 |
| 2002-11-04 | ABFS-DELISTED | Stock | 30.07 | 31.0 | 29.85 | 30.35 | 302900.0 |
| 2002-11-04 | ABG | Stock | 9.25 | 9.28 | 8.75 | 8.76 | 66600.0 |
| 2002-11-04 | ABK-DELISTED | Stock | 62.0 | 62.96 | 61.4 | 61.5 | 713800.0 |
| 2002-11-04 | ABM | Stock | 15.05 | 15.4 | 14.77 | 15.03 | 98000.0 |
| 2002-11-04 | ABMD-DELISTED | Stock | 4.0 | 4.05 | 3.7 | 3.839 | 116976.0 |
| 2002-11-04 | ABP-DELISTED | Stock | 0.73 | 0.73 | 0.62 | 0.69 | 60300.0 |
| 2002-11-04 | ABT | Stock | 18.8089 | 19.2264 | 18.6653 | 18.8853 | 6273100.0 |
| 2002-11-04 | ABTL-DELISTED | Stock | 11.95 | 12.5 | 11.6 | 11.9 | 21200.0 |
| 2002-11-04 | ABV-DELISTED | Stock | 14.95 | 15.15 | 14.19 | 14.33 | 340900.0 |
| 2002-11-04 | ABVA-DELISTED | Stock | 10.89 | 10.9 | 10.65 | 10.65 | 2200.0 |
| 2002-11-04 | ABX-DELISTED | Stock | 15.27 | 15.79 | 15.27 | 15.77 | 1583752.0 |
| 2002-11-04 | ACAP-DELISTED | Stock | 15.76 | 15.77 | 15.5 | 15.7 | 9500.0 |
| 2002-11-04 | ACAS-DELISTED | Stock | 19.99 | 20.5 | 19.93 | 20.07 | 444588.0 |
| 2002-11-04 | ACAT-DELISTED | Stock | 14.84 | 15.25 | 14.61 | 15.24 | 44079.0 |
| 2002-11-04 | ACCL-DELISTED | Stock | 7.38595008850098 | 7.45836019515991 | 7.29905986785889 | 7.45836019515991 | 172300.0 |
| 2002-11-04 | ACE-DELISTED | Stock | 32.05 | 32.3 | 31.6 | 31.8 | 1612900.0 |
| 2002-11-04 | ACF-DELISTED | Stock | 8.15 | 8.95 | 8.15 | 8.52 | 2671800.0 |
| 2002-11-04 | ACG-DELISTED | Stock | 7.99 | 8.06 | 7.97 | 8.0 | 362300.0 |
| 2002-11-04 | ACGL | Stock | 3.1111 | 3.1333 | 3.0833 | 3.0933 | 1141200.0 |
| 2002-11-04 | ACGN-DELISTED | Stock | 1054.0 | 1144.6712 | 974.6712 | 1110.6712 | 45500.0 |
| 2002-11-04 | ACH | Stock | 10.6333 | 10.88 | 10.3333 | 10.3533 | 541350.0 |
| 2002-11-04 | ACH-DELISTED | Stock | 2.95 | 2.9575 | 2.95 | 2.95 | 16000.0 |
| 2002-11-04 | ACLS | Stock | 24.84 | 27.2 | 24.56 | 25.84 | 357075.0 |
| 2002-11-04 | ACO-DELISTED | Stock | 5.6 | 5.95 | 5.58 | 5.85 | 17300.0 |
| 2002-11-04 | ACPW-DELISTED | Stock | 11.226 | 11.527 | 9.623 | 10.024 | 30875.0 |
| 2002-11-04 | ACS-DELISTED | Stock | 47.95 | 49.4 | 47.01 | 48.7 | 1383600.0 |
| 2002-11-04 | ACTA-DELISTED | Stock | 7.2 | 8.0 | 7.2 | 7.4 | 119500.0 |
| 2002-11-04 | ACTT-DELISTED | Stock | 1.32 | 1.44 | 1.21 | 1.37 | 210540.0 |
| 2002-11-04 | ACTU-DELISTED | Stock | 2.32 | 2.66 | 2.31 | 2.63 | 590521.0 |
| 2002-11-04 | ACXM-DELISTED | Stock | 13.81 | 13.83 | 13.08 | 13.14 | 814207.0 |
> showing 50 of 3,243 rows — these rows as CSV