PREVIEW / stock_daily / 2009-02-02
file: by_date/stock_daily/2009/2009-02-02.parquet size: 174 KB rows: 5,693 symbols: 3,395
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-02 | AAPL | Stock | 3.1821 | 3.2857 | 3.175 | 3.2682 | 558247200.0 |
| 2009-02-02 | MSFT | Stock | 17.03 | 18.13 | 17.0 | 17.83 | 88871700.0 |
| 2009-02-02 | NVDA | Stock | 0.1958 | 0.2118 | 0.1948 | 0.2095 | 577992000.0 |
| 2009-02-02 | AMZN | Stock | 2.9285 | 3.1 | 2.9065 | 3.0575 | 386486000.0 |
| 2009-02-02 | TLT | Stock | 104.02 | 105.68 | 103.39 | 105.39 | 2700122.0 |
| 2009-02-02 | CL | Stock | 32.26 | 32.6 | 31.705 | 32.17 | 6558400.0 |
| 2009-02-02 | A | Stock | 12.7253 | 13.0401 | 12.711 | 12.897 | 5330714.0 |
| 2009-02-02 | AABA-DELISTED | Stock | 11.5 | 12.32 | 11.49 | 12.16 | 21176593.0 |
| 2009-02-02 | AACC-DELISTED | Stock | 4.14 | 4.49 | 4.13 | 4.46 | 59615.0 |
| 2009-02-02 | AACG | Stock | 3.28 | 3.62 | 3.28 | 3.62 | 13400.0 |
| 2009-02-02 | AAI-DELISTED | Stock | 4.14 | 4.2399 | 3.93 | 4.11 | 1339376.0 |
| 2009-02-02 | AAIC-DELISTED | Stock | 3.8 | 4.0 | 3.6 | 4.0 | 244659.0 |
| 2009-02-02 | AAON | Stock | 3.5417 | 3.5793 | 3.4667 | 3.5496 | 657112.0 |
| 2009-02-02 | AAP | Stock | 32.18 | 33.18 | 32.18 | 33.04 | 910500.0 |
| 2009-02-02 | AATI-DELISTED | Stock | 2.98 | 3.15 | 2.81 | 3.14 | 94172.0 |
| 2009-02-02 | AAU-DELISTED | Stock | 0.77 | 0.77 | 0.73 | 0.75 | 52900.0 |
| 2009-02-02 | AAUAF-DELISTED | Stock | 0.77 | 0.77 | 0.73 | 0.75 | 53900.0 |
| 2009-02-02 | AAV-DELISTED | Stock | 4.17 | 4.19 | 3.96 | 3.96 | 962627.0 |
| 2009-02-02 | AAWW-DELISTED | Stock | 14.22 | 14.22 | 12.73 | 13.04 | 323729.0 |
| 2009-02-02 | AAXJ | Stock | 30.96 | 31.2099 | 30.19 | 30.38 | 45027.0 |
| 2009-02-02 | AAXN-DELISTED | Stock | 5.05 | 5.29 | 4.99 | 5.25 | 589347.0 |
| 2009-02-02 | AB | Stock | 16.26 | 16.9 | 15.91 | 16.68 | 495100.0 |
| 2009-02-02 | ABAX-DELISTED | Stock | 15.75 | 17.9 | 15.54 | 17.71 | 611726.0 |
| 2009-02-02 | ABB-DELISTED | Stock | 12.14 | 12.48 | 12.11 | 12.38 | 4970843.0 |
| 2009-02-02 | ABBC-DELISTED | Stock | 7.13 | 7.2 | 7.05 | 7.13 | 170253.0 |
| 2009-02-02 | ABBNY-DELISTED | Stock | 12.14 | 12.48 | 12.11 | 12.34 | 4971343.0 |
| 2009-02-02 | ABC-DELISTED | Stock | 17.86 | 18.65 | 17.86 | 18.44 | 3575792.0 |
| 2009-02-02 | ABCB | Stock | 7.9563 | 8.2383 | 7.5477 | 7.7714 | 22105.0 |
| 2009-02-02 | ABCO-DELISTED | Stock | 8.697 | 8.928 | 8.677 | 8.813 | 260014.0 |
| 2009-02-02 | ABCW-DELISTED | Stock | 2.03 | 2.0909 | 2.0097 | 2.03 | 156910.0 |
| 2009-02-02 | ABD-DELISTED | Stock | 1.87 | 1.95 | 1.86 | 1.91 | 201620.0 |
| 2009-02-02 | ABE-DELISTED | Stock | 12.46 | 13.26 | 11.788 | 11.8514 | 2662.0 |
| 2009-02-02 | ABEO | Stock | 1025.0 | 1025.0 | 1025.0 | 1025.0 | 3.0 |
| 2009-02-02 | ABFS-DELISTED | Stock | 23.0 | 23.64 | 22.65 | 23.1 | 599444.0 |
| 2009-02-02 | ABG | Stock | 3.5 | 3.65 | 3.33 | 3.58 | 162800.0 |
| 2009-02-02 | ABII-DELISTED | Stock | 69.9 | 70.12 | 65.35 | 70.11 | 15769.0 |
| 2009-02-02 | ABK-DELISTED | Stock | 1.1 | 1.18 | 1.04 | 1.04 | 9821628.0 |
| 2009-02-02 | ABM | Stock | 14.82 | 15.02 | 14.41 | 14.94 | 492300.0 |
| 2009-02-02 | ABMD-DELISTED | Stock | 13.33 | 13.81 | 13.12 | 13.68 | 149776.0 |
| 2009-02-02 | ABR | Stock | 1.86 | 1.87 | 1.7 | 1.74 | 115700.0 |
| 2009-02-02 | ABT | Stock | 25.8324 | 26.792 | 25.4822 | 26.6625 | 20108170.0 |
| 2009-02-02 | ABTL-DELISTED | Stock | 1.9 | 1.9 | 1.85 | 1.85 | 1600.0 |
| 2009-02-02 | ABV-DELISTED | Stock | 39.85 | 40.92 | 39.57 | 40.59 | 662546.0 |
| 2009-02-02 | ABVA-DELISTED | Stock | 1.15 | 1.15 | 1.05 | 1.05 | 1156.0 |
| 2009-02-02 | ABX-DELISTED | Stock | 36.41 | 37.25 | 35.47 | 35.91 | 11302945.0 |
| 2009-02-02 | ACAD | Stock | 0.98 | 1.07 | 0.98 | 1.01 | 148400.0 |
| 2009-02-02 | ACAP-DELISTED | Stock | 42.14 | 44.94 | 41.94 | 44.67 | 40745.0 |
| 2009-02-02 | ACAS-DELISTED | Stock | 2.8 | 2.85 | 2.5 | 2.66 | 4193840.0 |
| 2009-02-02 | ACAT-DELISTED | Stock | 4.46 | 4.6 | 4.3 | 4.3 | 41964.0 |
| 2009-02-02 | ACC-DELISTED | Stock | 21.14 | 21.57 | 20.48 | 21.49 | 708982.0 |
> showing 50 of 5,693 rows — these rows as CSV