PREVIEW / stock_daily / 2009-02-03
file: by_date/stock_daily/2009/2009-02-03.parquet size: 174 KB rows: 5,669 symbols: 3,383
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-03 | AAPL | Stock | 3.2829 | 3.335 | 3.2243 | 3.3207 | 599309200.0 |
| 2009-02-03 | MSFT | Stock | 17.85 | 18.61 | 17.6 | 18.5 | 86865100.0 |
| 2009-02-03 | NVDA | Stock | 0.21 | 0.2138 | 0.2043 | 0.212 | 396948000.0 |
| 2009-02-03 | AMZN | Stock | 3.0435 | 3.21 | 3.0 | 3.1795 | 293892000.0 |
| 2009-02-03 | TLT | Stock | 104.3 | 104.83 | 102.75 | 102.88 | 2846354.0 |
| 2009-02-03 | CL | Stock | 32.32 | 33.125 | 32.15 | 32.88 | 7202600.0 |
| 2009-02-03 | A | Stock | 12.897 | 13.0901 | 12.6967 | 13.0258 | 4807163.0 |
| 2009-02-03 | AABA-DELISTED | Stock | 12.27 | 12.71 | 12.01 | 12.65 | 18543693.0 |
| 2009-02-03 | AACC-DELISTED | Stock | 4.49 | 4.6884 | 4.4 | 4.55 | 68186.0 |
| 2009-02-03 | AACG | Stock | 3.62 | 3.9 | 3.58 | 3.75 | 16000.0 |
| 2009-02-03 | AAI-DELISTED | Stock | 4.1 | 4.29 | 4.08 | 4.21 | 1989618.0 |
| 2009-02-03 | AAIC-DELISTED | Stock | 4.2 | 4.6 | 3.8 | 4.4 | 559896.0 |
| 2009-02-03 | AAME | Stock | 0.71 | 0.71 | 0.71 | 0.71 | 800.0 |
| 2009-02-03 | AAON | Stock | 3.5714 | 3.6879 | 3.5477 | 3.6306 | 510300.0 |
| 2009-02-03 | AAP | Stock | 33.07 | 34.12 | 32.38 | 33.93 | 1190100.0 |
| 2009-02-03 | AATI-DELISTED | Stock | 3.15 | 3.35 | 3.03 | 3.31 | 170244.0 |
| 2009-02-03 | AAU-DELISTED | Stock | 0.75 | 0.79 | 0.7 | 0.77 | 80912.0 |
| 2009-02-03 | AAUAF-DELISTED | Stock | 0.75 | 0.79 | 0.7 | 0.77 | 82912.0 |
| 2009-02-03 | AAV-DELISTED | Stock | 3.95 | 4.01 | 3.93 | 3.94 | 578426.0 |
| 2009-02-03 | AAWW-DELISTED | Stock | 13.04 | 13.52 | 11.28 | 11.78 | 372126.0 |
| 2009-02-03 | AAXJ | Stock | 30.86 | 31.11 | 30.31 | 30.9 | 47883.0 |
| 2009-02-03 | AAXN-DELISTED | Stock | 5.25 | 5.45 | 5.21 | 5.4 | 542946.0 |
| 2009-02-03 | AB | Stock | 16.7 | 17.37 | 16.13 | 17.12 | 450500.0 |
| 2009-02-03 | ABAX-DELISTED | Stock | 17.7 | 17.87 | 16.78 | 17.19 | 432403.0 |
| 2009-02-03 | ABB-DELISTED | Stock | 12.63 | 13.1 | 12.52 | 13.05 | 4791740.0 |
| 2009-02-03 | ABBC-DELISTED | Stock | 7.2 | 7.2 | 7.0 | 7.03 | 289350.0 |
| 2009-02-03 | ABBNY-DELISTED | Stock | 12.63 | 13.1 | 12.52 | 13.05 | 4799240.0 |
| 2009-02-03 | ABC-DELISTED | Stock | 18.52 | 18.86 | 18.19 | 18.76 | 6482940.0 |
| 2009-02-03 | ABCB | Stock | 7.8492 | 8.0243 | 7.6256 | 7.8492 | 27965.0 |
| 2009-02-03 | ABCO-DELISTED | Stock | 8.883 | 9.008 | 8.632 | 8.772 | 230252.0 |
| 2009-02-03 | ABCW-DELISTED | Stock | 2.0552 | 2.1554 | 1.9148 | 1.9148 | 87880.0 |
| 2009-02-03 | ABD-DELISTED | Stock | 1.92 | 2.1712 | 1.73 | 2.1 | 323640.0 |
| 2009-02-03 | ABE-DELISTED | Stock | 11.85 | 12.36 | 11.85 | 12.35 | 27633.0 |
| 2009-02-03 | ABEO | Stock | 1025.0 | 1062.5 | 1025.0 | 1062.5 | 2.0 |
| 2009-02-03 | ABFS-DELISTED | Stock | 22.86 | 25.15 | 22.86 | 24.75 | 860750.0 |
| 2009-02-03 | ABG | Stock | 3.61 | 3.69 | 3.33 | 3.5 | 212400.0 |
| 2009-02-03 | ABII-DELISTED | Stock | 70.29 | 70.44 | 68.9 | 69.74 | 14594.0 |
| 2009-02-03 | ABK-DELISTED | Stock | 1.08 | 1.1 | 1.03 | 1.05 | 9184479.0 |
| 2009-02-03 | ABM | Stock | 15.03 | 15.03 | 14.38 | 14.64 | 368100.0 |
| 2009-02-03 | ABMD-DELISTED | Stock | 13.73 | 13.73 | 12.89 | 13.08 | 271701.0 |
| 2009-02-03 | ABR | Stock | 1.75 | 1.85 | 1.61 | 1.85 | 153400.0 |
| 2009-02-03 | ABT | Stock | 26.816 | 27.5357 | 26.5617 | 27.339 | 31642768.0 |
| 2009-02-03 | ABTL-DELISTED | Stock | 2.0971 | 2.2032 | 1.5648 | 2.0029 | 5613.0 |
| 2009-02-03 | ABV-DELISTED | Stock | 40.67 | 42.92 | 40.3 | 42.62 | 757828.0 |
| 2009-02-03 | ABVT-DELISTED | Stock | 30.5 | 34.75 | 30.5 | 34.75 | 15200.0 |
| 2009-02-03 | ABX-DELISTED | Stock | 36.34 | 36.88 | 35.29 | 35.85 | 10604216.0 |
| 2009-02-03 | ACAD | Stock | 1.02 | 1.03 | 0.99 | 1.0 | 137000.0 |
| 2009-02-03 | ACAP-DELISTED | Stock | 44.95 | 45.56 | 44.37 | 44.84 | 37425.0 |
| 2009-02-03 | ACAS-DELISTED | Stock | 2.6 | 2.67 | 2.45 | 2.47 | 4150113.0 |
| 2009-02-03 | ACAT-DELISTED | Stock | 4.37 | 4.4 | 4.04 | 4.04 | 55518.0 |
> showing 50 of 5,669 rows — these rows as CSV