PREVIEW / stock_daily / 2002-12-27
file: by_date/stock_daily/2002/2002-12-27.parquet size: 110 KB rows: 3,289 symbols: 2,036
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-12-27 | AAPL | Stock | 0.2555 | 0.2568 | 0.2502 | 0.2511 | 80035200.0 |
| 2002-12-27 | MSFT | Stock | 26.64 | 27.0 | 26.45 | 26.485 | 40891600.0 |
| 2002-12-27 | NVDA | Stock | 0.1063 | 0.1066 | 0.0987 | 0.0996 | 702528000.0 |
| 2002-12-27 | AMZN | Stock | 0.9985 | 1.005 | 0.9215 | 0.943 | 439456000.0 |
| 2002-12-27 | CL | Stock | 26.21 | 26.27 | 26.005 | 26.075 | 1432600.0 |
| 2002-12-27 | A | Stock | 12.9828 | 13.226 | 12.9542 | 13.0186 | 1558351.0 |
| 2002-12-27 | AABA-DELISTED | Stock | 8.43000030517578 | 8.6899995803833 | 8.21500015258789 | 8.28999996185303 | 9223400.0 |
| 2002-12-27 | AAI-DELISTED | Stock | 4.0 | 4.01 | 3.85 | 3.88 | 312000.0 |
| 2002-12-27 | AAIC-DELISTED | Stock | 190.0 | 190.6 | 188.8 | 189.0 | 162000.0 |
| 2002-12-27 | AAME | Stock | 1.5 | 1.59 | 1.41 | 1.59 | 2200.0 |
| 2002-12-27 | AAON | Stock | 2.5258 | 2.5258 | 2.3045 | 2.3862 | 636356.0 |
| 2002-12-27 | AAP | Stock | 16.3333 | 16.4967 | 16.2833 | 16.38 | 556500.0 |
| 2002-12-27 | AAXN-DELISTED | Stock | 0.33500000834465 | 0.340833336114883 | 0.333333343267441 | 0.340000003576279 | 156000.0 |
| 2002-12-27 | ABAX-DELISTED | Stock | 4.0 | 4.049 | 3.83 | 4.049 | 3300.0 |
| 2002-12-27 | ABB-DELISTED | Stock | 2.9 | 2.93 | 2.82 | 2.85 | 140800.0 |
| 2002-12-27 | ABC-DELISTED | Stock | 13.64 | 13.64 | 13.53 | 13.54 | 3098400.0 |
| 2002-12-27 | ABCB | Stock | 11.2016 | 11.3475 | 10.9422 | 11.1692 | 8143.0 |
| 2002-12-27 | ABCO-DELISTED | Stock | 14.44 | 14.665 | 14.44 | 14.515 | 152200.0 |
| 2002-12-27 | ABCW-DELISTED | Stock | 20.97 | 21.15 | 20.95 | 21.05 | 20600.0 |
| 2002-12-27 | ABE-DELISTED | Stock | 5.82 | 5.98 | 5.76 | 5.81 | 17900.0 |
| 2002-12-27 | ABFS-DELISTED | Stock | 26.75 | 26.75 | 26.16 | 26.16 | 59600.0 |
| 2002-12-27 | ABG | Stock | 8.65 | 8.66 | 8.56 | 8.6 | 25000.0 |
| 2002-12-27 | ABK-DELISTED | Stock | 56.93 | 56.93 | 55.25 | 55.37 | 541500.0 |
| 2002-12-27 | ABM | Stock | 15.5 | 15.76 | 15.2 | 15.51 | 97500.0 |
| 2002-12-27 | ABMD-DELISTED | Stock | 3.8 | 3.9 | 3.55 | 3.56 | 122149.0 |
| 2002-12-27 | ABP-DELISTED | Stock | 0.59 | 0.59 | 0.52 | 0.53 | 114100.0 |
| 2002-12-27 | ABT | Stock | 16.5689 | 16.6542 | 16.2771 | 16.5106 | 5398742.0 |
| 2002-12-27 | ABTL-DELISTED | Stock | 12.75 | 12.85 | 12.5 | 12.6 | 24000.0 |
| 2002-12-27 | ABV-DELISTED | Stock | 15.05 | 15.24 | 15.0 | 15.13 | 60800.0 |
| 2002-12-27 | ABVA-DELISTED | Stock | 10.63 | 10.63 | 10.63 | 10.63 | 100.0 |
| 2002-12-27 | ABX-DELISTED | Stock | 15.75 | 15.99 | 15.68 | 15.75 | 2097100.0 |
| 2002-12-27 | ACAP-DELISTED | Stock | 18.36 | 18.57 | 18.09 | 18.44 | 11137.0 |
| 2002-12-27 | ACAS-DELISTED | Stock | 23.6 | 23.7 | 22.29 | 22.74 | 656537.0 |
| 2002-12-27 | ACAT-DELISTED | Stock | 16.51 | 16.78 | 16.3 | 16.5 | 16000.0 |
| 2002-12-27 | ACCL-DELISTED | Stock | 6.58942985534668 | 6.65460014343262 | 6.49528980255127 | 6.65460014343262 | 70200.0 |
| 2002-12-27 | ACE-DELISTED | Stock | 29.4 | 29.66 | 28.71 | 29.0 | 655800.0 |
| 2002-12-27 | ACF-DELISTED | Stock | 7.77 | 7.8 | 7.35 | 7.38 | 781300.0 |
| 2002-12-27 | ACG-DELISTED | Stock | 8.3 | 8.38 | 8.29 | 8.38 | 386800.0 |
| 2002-12-27 | ACGL | Stock | 3.4278 | 3.4278 | 3.3867 | 3.3878 | 410400.0 |
| 2002-12-27 | ACGN-DELISTED | Stock | 816.0 | 816.0 | 770.6712 | 816.0 | 86800.0 |
| 2002-12-27 | ACH | Stock | 10.8267 | 11.24 | 10.7867 | 11.0867 | 138150.0 |
| 2002-12-27 | ACH-DELISTED | Stock | 3.6138 | 3.6138 | 3.6012 | 3.6012 | 3994.0 |
| 2002-12-27 | ACLS | Stock | 23.04 | 23.4 | 22.44 | 22.92 | 111300.0 |
| 2002-12-27 | ACO-DELISTED | Stock | 6.0 | 6.06 | 5.93 | 5.97 | 9300.0 |
| 2002-12-27 | ACPW-DELISTED | Stock | 8.65 | 9.0 | 8.5 | 8.5 | 15900.0 |
| 2002-12-27 | ACS-DELISTED | Stock | 53.1 | 53.11 | 51.73 | 51.73 | 742600.0 |
| 2002-12-27 | ACTA-DELISTED | Stock | 7.4 | 8.0 | 7.2 | 7.4 | 193700.0 |
| 2002-12-27 | ACTG | Stock | 1.8 | 1.99 | 1.8 | 1.96 | 46700.0 |
| 2002-12-27 | ACTT-DELISTED | Stock | 1.33 | 1.36 | 1.31 | 1.33 | 36100.0 |
| 2002-12-27 | ACTU-DELISTED | Stock | 1.87 | 1.92 | 1.69 | 1.73 | 70422.0 |
> showing 50 of 3,289 rows — these rows as CSV