PREVIEW / stock_daily / 2002-08-14
file: by_date/stock_daily/2002/2002-08-14.parquet size: 106 KB rows: 3,138 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-08-14 | AAPL | Stock | 0.262 | 0.2741 | 0.2596 | 0.2709 | 399084000.0 |
| 2002-08-14 | MSFT | Stock | 23.625 | 24.865 | 23.605 | 24.855 | 96706000.0 |
| 2002-08-14 | NVDA | Stock | 0.0765 | 0.0808 | 0.0758 | 0.0802 | 632688000.0 |
| 2002-08-14 | AMZN | Stock | 0.6965 | 0.703 | 0.666 | 0.6955 | 138704000.0 |
| 2002-08-14 | CL | Stock | 26.74 | 27.21 | 26.3 | 27.21 | 2828800.0 |
| 2002-08-14 | A | Stock | 11.2804 | 11.4735 | 10.7725 | 11.4735 | 3490806.0 |
| 2002-08-14 | AABA-DELISTED | Stock | 5.56500005722046 | 5.9850001335144 | 5.46500015258789 | 5.85500001907349 | 19843800.0 |
| 2002-08-14 | AAI-DELISTED | Stock | 3.58 | 3.65 | 3.45 | 3.56 | 207200.0 |
| 2002-08-14 | AAIC-DELISTED | Stock | 195.0 | 208.6 | 195.0 | 208.6 | 84000.0 |
| 2002-08-14 | AAME | Stock | 1.95 | 2.15 | 1.85 | 2.15 | 3400.0 |
| 2002-08-14 | AAON | Stock | 2.1465 | 2.2387 | 2.0675 | 2.2071 | 304509.0 |
| 2002-08-14 | AAP | Stock | 16.67 | 16.9 | 16.0833 | 16.7 | 1270800.0 |
| 2002-08-14 | AAXN-DELISTED | Stock | 0.616666674613953 | 0.620833337306976 | 0.600833356380463 | 0.616666674613953 | 164400.0 |
| 2002-08-14 | ABAX-DELISTED | Stock | 3.2804 | 3.2804 | 3.1 | 3.1 | 34400.0 |
| 2002-08-14 | ABB-DELISTED | Stock | 4.41 | 4.55 | 4.39 | 4.52 | 12000.0 |
| 2002-08-14 | ABC-DELISTED | Stock | 16.9 | 17.45 | 16.88 | 17.42 | 3948400.0 |
| 2002-08-14 | ABCB | Stock | 10.8612 | 11.3232 | 10.7882 | 11.2259 | 11967.0 |
| 2002-08-14 | ABCO-DELISTED | Stock | 16.988 | 17.044 | 16.486 | 16.755 | 31605.0 |
| 2002-08-14 | ABCW-DELISTED | Stock | 20.8 | 21.65 | 20.21 | 21.5 | 28450.0 |
| 2002-08-14 | ABE-DELISTED | Stock | 6.1 | 6.16 | 6.05 | 6.16 | 11900.0 |
| 2002-08-14 | ABFS-DELISTED | Stock | 20.57 | 21.36 | 20.011 | 21.19 | 110003.0 |
| 2002-08-14 | ABG | Stock | 10.0 | 10.5 | 9.75 | 10.2 | 133800.0 |
| 2002-08-14 | ABK-DELISTED | Stock | 58.85 | 59.75 | 57.5 | 59.62 | 1075900.0 |
| 2002-08-14 | ABM | Stock | 16.05 | 16.8 | 16.05 | 16.8 | 69900.0 |
| 2002-08-14 | ABMD-DELISTED | Stock | 5.6 | 5.93 | 5.5 | 5.92 | 35900.0 |
| 2002-08-14 | ABP-DELISTED | Stock | 0.55 | 0.55 | 0.46 | 0.5 | 144300.0 |
| 2002-08-14 | ABT | Stock | 17.7675 | 18.0683 | 17.552 | 17.9605 | 12449296.0 |
| 2002-08-14 | ABTL-DELISTED | Stock | 11.7 | 12.0 | 11.25 | 11.95 | 10500.0 |
| 2002-08-14 | ABV-DELISTED | Stock | 14.3 | 14.7 | 14.14 | 14.43 | 1527300.0 |
| 2002-08-14 | ABVA-DELISTED | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 2300.0 |
| 2002-08-14 | ABX-DELISTED | Stock | 16.05 | 16.09 | 15.16 | 15.33 | 2402300.0 |
| 2002-08-14 | ACAP-DELISTED | Stock | 18.2 | 18.75 | 17.91 | 18.72 | 320200.0 |
| 2002-08-14 | ACAS-DELISTED | Stock | 21.81 | 22.63 | 21.09 | 21.63 | 2728657.0 |
| 2002-08-14 | ACAT-DELISTED | Stock | 15.04 | 15.234 | 15.0 | 15.14 | 20361.0 |
| 2002-08-14 | ACCL-DELISTED | Stock | 4.57999992370605 | 5.13399982452393 | 4.56199979782104 | 5.06899976730347 | 98900.0 |
| 2002-08-14 | ACE-DELISTED | Stock | 31.76 | 32.65 | 31.27 | 32.59 | 1108200.0 |
| 2002-08-14 | ACF-DELISTED | Stock | 11.85 | 12.63 | 10.92 | 12.52 | 4197200.0 |
| 2002-08-14 | ACG-DELISTED | Stock | 8.01 | 8.05 | 7.9 | 7.95 | 650200.0 |
| 2002-08-14 | ACGL | Stock | 3.0333 | 3.11 | 2.9444 | 3.11 | 316800.0 |
| 2002-08-14 | ACH | Stock | 9.7333 | 9.8 | 9.5333 | 9.6667 | 598800.0 |
| 2002-08-14 | ACH-DELISTED | Stock | 3.7505 | 3.7505 | 3.663 | 3.688 | 72390.0 |
| 2002-08-14 | ACLS | Stock | 28.12 | 30.16 | 26.88 | 29.88 | 166775.0 |
| 2002-08-14 | ACO-DELISTED | Stock | 5.25 | 5.99 | 5.25 | 5.94 | 24400.0 |
| 2002-08-14 | ACPW-DELISTED | Stock | 11.25 | 11.25 | 9.8 | 11.0 | 21231.0 |
| 2002-08-14 | ACS-DELISTED | Stock | 46.8 | 47.16 | 45.87 | 46.84 | 1437800.0 |
| 2002-08-14 | ACTA-DELISTED | Stock | 4.8 | 4.8 | 4.4 | 4.6 | 44700.0 |
| 2002-08-14 | ACTT-DELISTED | Stock | 1.4 | 1.4 | 1.11 | 1.2 | 199700.0 |
| 2002-08-14 | ACTU-DELISTED | Stock | 1.99 | 2.03 | 1.9 | 2.03 | 591120.0 |
| 2002-08-14 | ACXM-DELISTED | Stock | 16.5 | 17.11 | 16.44 | 17.09 | 410218.0 |
| 2002-08-14 | ACY-DELISTED | Stock | 4.05 | 4.05 | 4.0 | 4.0 | 1000.0 |
> showing 50 of 3,138 rows — these rows as CSV