PREVIEW / stock_daily / 2003-06-27
file: by_date/stock_daily/2003/2003-06-27.parquet size: 114 KB rows: 3,369 symbols: 2,074
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-27 | AAPL | Stock | 0.3446 | 0.3448 | 0.33 | 0.3345 | 365792000.0 |
| 2003-06-27 | MSFT | Stock | 25.95 | 26.34 | 25.53 | 25.63 | 76040300.0 |
| 2003-06-27 | NVDA | Stock | 0.1937 | 0.1954 | 0.1871 | 0.188 | 709104000.0 |
| 2003-06-27 | AMZN | Stock | 1.8345 | 1.8545 | 1.809 | 1.815 | 135130000.0 |
| 2003-06-27 | CL | Stock | 29.0 | 29.27 | 28.75 | 28.84 | 3557600.0 |
| 2003-06-27 | A | Stock | 13.6981 | 14.2632 | 13.6266 | 13.9843 | 3501431.0 |
| 2003-06-27 | AABA-DELISTED | Stock | 16.5499992370605 | 16.7450008392334 | 16.0900001525879 | 16.1100006103516 | 25943200.0 |
| 2003-06-27 | AAI-DELISTED | Stock | 10.5 | 10.95 | 10.22 | 10.41 | 1679100.0 |
| 2003-06-27 | AAIC-DELISTED | Stock | 277.8 | 278.8 | 274.2 | 275.2 | 719300.0 |
| 2003-06-27 | AAME | Stock | 2.28 | 2.4 | 2.24 | 2.4 | 12900.0 |
| 2003-06-27 | AAON | Stock | 2.4336 | 2.5021 | 2.4336 | 2.4454 | 88087.0 |
| 2003-06-27 | AAP | Stock | 20.0 | 20.3267 | 19.8367 | 20.08 | 753300.0 |
| 2003-06-27 | AAXN-DELISTED | Stock | 1.02499997615814 | 1.07749998569489 | 1.01916670799255 | 1.0716667175293 | 1082400.0 |
| 2003-06-27 | ABAX-DELISTED | Stock | 6.75 | 6.75 | 6.451 | 6.55 | 67700.0 |
| 2003-06-27 | ABB-DELISTED | Stock | 3.39 | 3.4 | 3.25 | 3.29 | 840100.0 |
| 2003-06-27 | ABC-DELISTED | Stock | 17.38 | 17.55 | 17.27 | 17.4 | 4234000.0 |
| 2003-06-27 | ABCB | Stock | 11.3151 | 11.8987 | 11.3151 | 11.5258 | 8760.0 |
| 2003-06-27 | ABCO-DELISTED | Stock | 20.34 | 20.73 | 20.12 | 20.32 | 189013.0 |
| 2003-06-27 | ABCW-DELISTED | Stock | 24.04 | 24.63 | 24.04 | 24.16 | 60380.0 |
| 2003-06-27 | ABE-DELISTED | Stock | 6.15 | 6.2 | 6.14 | 6.14 | 23300.0 |
| 2003-06-27 | ABFS-DELISTED | Stock | 23.7 | 25.0 | 23.62 | 24.4 | 259755.0 |
| 2003-06-27 | ABG | Stock | 13.65 | 13.89 | 13.4 | 13.45 | 14300.0 |
| 2003-06-27 | ABK-DELISTED | Stock | 67.3 | 67.3 | 66.3 | 66.86 | 404000.0 |
| 2003-06-27 | ABM | Stock | 15.5 | 15.91 | 15.5 | 15.85 | 104200.0 |
| 2003-06-27 | ABMD-DELISTED | Stock | 5.53 | 5.65 | 5.21 | 5.51 | 40695.0 |
| 2003-06-27 | ABP-DELISTED | Stock | 1.06 | 1.07 | 1.04 | 1.07 | 46700.0 |
| 2003-06-27 | ABT | Stock | 20.1197 | 20.1197 | 19.4374 | 19.5721 | 8261735.0 |
| 2003-06-27 | ABTL-DELISTED | Stock | 30.3 | 31.0 | 29.75 | 30.5 | 90500.0 |
| 2003-06-27 | ABV-DELISTED | Stock | 20.21 | 20.41 | 20.15 | 20.33 | 456900.0 |
| 2003-06-27 | ABVA-DELISTED | Stock | 16.7 | 16.7 | 16.7 | 16.7 | 1000.0 |
| 2003-06-27 | ABX-DELISTED | Stock | 17.5 | 17.75 | 17.46 | 17.6 | 1132100.0 |
| 2003-06-27 | ACAP-DELISTED | Stock | 23.96 | 24.86 | 23.96 | 24.69 | 12997.0 |
| 2003-06-27 | ACAS-DELISTED | Stock | 25.4 | 25.88 | 25.13 | 25.26 | 600659.0 |
| 2003-06-27 | ACAT-DELISTED | Stock | 18.4 | 19.45 | 18.4 | 19.0 | 20800.0 |
| 2003-06-27 | ACCL-DELISTED | Stock | 6.29977989196777 | 6.9514799118042 | 6.29254007339478 | 6.40115976333618 | 182700.0 |
| 2003-06-27 | ACE-DELISTED | Stock | 36.1 | 36.1 | 34.7 | 34.84 | 1391900.0 |
| 2003-06-27 | ACF-DELISTED | Stock | 8.84 | 8.88 | 8.52 | 8.56 | 861600.0 |
| 2003-06-27 | ACG-DELISTED | Stock | 9.48 | 9.48 | 9.45 | 9.45 | 351500.0 |
| 2003-06-27 | ACGL | Stock | 3.8056 | 3.8756 | 3.7956 | 3.8611 | 2969100.0 |
| 2003-06-27 | ACGN-DELISTED | Stock | 940.6712 | 986.0 | 940.6712 | 986.0 | 14900.0 |
| 2003-06-27 | ACH | Stock | 14.7867 | 15.0 | 14.6133 | 14.6933 | 174150.0 |
| 2003-06-27 | ACH-DELISTED | Stock | 5.62 | 5.675 | 5.595 | 5.615 | 35200.0 |
| 2003-06-27 | ACLS | Stock | 23.76 | 25.52 | 23.72 | 24.32 | 209575.0 |
| 2003-06-27 | ACO-DELISTED | Stock | 7.7 | 7.91 | 7.6 | 7.74 | 16300.0 |
| 2003-06-27 | ACPW-DELISTED | Stock | 8.45 | 8.51 | 7.8 | 7.9 | 29196.0 |
| 2003-06-27 | ACS-DELISTED | Stock | 45.9 | 45.95 | 44.74 | 44.84 | 1333100.0 |
| 2003-06-27 | ACTA-DELISTED | Stock | 10.6 | 10.6 | 9.2 | 9.2 | 563300.0 |
| 2003-06-27 | ACTG | Stock | 1.33 | 1.37 | 1.3 | 1.3 | 158900.0 |
| 2003-06-27 | ACTI-DELISTED | Stock | 9.18 | 9.42 | 8.9 | 9.39 | 126023.0 |
| 2003-06-27 | ACTT-DELISTED | Stock | 1.6 | 1.8 | 1.6 | 1.78 | 82200.0 |
> showing 50 of 3,369 rows — these rows as CSV