PREVIEW / stock_daily / 2009-02-24
file: by_date/stock_daily/2009/2009-02-24.parquet size: 176 KB rows: 5,786 symbols: 3,462
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-24 | AAPL | Stock | 3.1232 | 3.2461 | 3.1071 | 3.2232 | 807105600.0 |
| 2009-02-24 | MSFT | Stock | 17.03 | 17.35 | 16.36 | 17.17 | 122674500.0 |
| 2009-02-24 | NVDA | Stock | 0.1825 | 0.198 | 0.1823 | 0.1978 | 659524000.0 |
| 2009-02-24 | AMZN | Stock | 3.0985 | 3.305 | 3.0945 | 3.28 | 205428000.0 |
| 2009-02-24 | TLT | Stock | 105.7 | 106.68 | 104.77 | 104.77 | 4197010.0 |
| 2009-02-24 | CL | Stock | 29.38 | 29.89 | 29.165 | 29.76 | 6594200.0 |
| 2009-02-24 | A | Stock | 10.329 | 10.7582 | 10.2361 | 10.6652 | 5293108.0 |
| 2009-02-24 | AABA-DELISTED | Stock | 12.55 | 12.86 | 12.27 | 12.72 | 22236340.0 |
| 2009-02-24 | AACC-DELISTED | Stock | 3.49 | 3.87 | 3.49 | 3.58 | 106461.0 |
| 2009-02-24 | AACG | Stock | 4.9 | 5.62 | 4.9 | 5.45 | 9500.0 |
| 2009-02-24 | AAI-DELISTED | Stock | 3.49 | 3.66 | 3.41 | 3.6 | 2473240.0 |
| 2009-02-24 | AAIC-DELISTED | Stock | 2.6 | 4.8 | 2.6 | 4.2 | 723433.0 |
| 2009-02-24 | AAME | Stock | 0.8 | 0.8 | 0.61 | 0.61 | 14500.0 |
| 2009-02-24 | AAON | Stock | 3.0617 | 3.3304 | 3.0617 | 3.3007 | 356906.0 |
| 2009-02-24 | AAP | Stock | 36.89 | 37.97 | 36.58 | 37.58 | 3089700.0 |
| 2009-02-24 | AATI-DELISTED | Stock | 2.78 | 3.22 | 2.78 | 3.11 | 225984.0 |
| 2009-02-24 | AAU-DELISTED | Stock | 0.87 | 0.87 | 0.78 | 0.78 | 111900.0 |
| 2009-02-24 | AAUAF-DELISTED | Stock | 0.87 | 0.87 | 0.78 | 0.78 | 107650.0 |
| 2009-02-24 | AAV-DELISTED | Stock | 2.21 | 2.4 | 2.1 | 2.31 | 1517943.0 |
| 2009-02-24 | AAWW-DELISTED | Stock | 13.27 | 15.34 | 12.76 | 14.86 | 274817.0 |
| 2009-02-24 | AAXJ | Stock | 28.89 | 29.94 | 28.6 | 29.85 | 420178.0 |
| 2009-02-24 | AAXN-DELISTED | Stock | 4.36 | 4.84 | 4.2354 | 4.65 | 1375953.0 |
| 2009-02-24 | AB | Stock | 12.0 | 13.39 | 11.75 | 13.25 | 911800.0 |
| 2009-02-24 | ABAX-DELISTED | Stock | 16.65 | 17.72 | 16.33 | 17.28 | 356248.0 |
| 2009-02-24 | ABB-DELISTED | Stock | 11.38 | 11.8 | 11.12 | 11.69 | 5453887.0 |
| 2009-02-24 | ABBC-DELISTED | Stock | 6.9 | 7.4 | 6.8107 | 7.22 | 169181.0 |
| 2009-02-24 | ABBNY-DELISTED | Stock | 11.38 | 11.8 | 11.12 | 11.68 | 5456087.0 |
| 2009-02-24 | ABC-DELISTED | Stock | 17.4 | 17.6 | 17.18 | 17.52 | 4869710.0 |
| 2009-02-24 | ABCB | Stock | 5.0772 | 6.0206 | 4.7367 | 5.865 | 56753.0 |
| 2009-02-24 | ABCO-DELISTED | Stock | 8.007 | 8.158 | 7.842 | 8.043 | 222177.0 |
| 2009-02-24 | ABCW-DELISTED | Stock | 0.8489 | 0.9214 | 0.8282 | 0.88 | 271130.0 |
| 2009-02-24 | ABD-DELISTED | Stock | 1.02 | 1.15 | 1.0 | 1.09 | 220750.0 |
| 2009-02-24 | ABE-DELISTED | Stock | 11.11 | 11.61 | 11.0 | 11.61 | 16954.0 |
| 2009-02-24 | ABEO | Stock | 1750.0 | 1750.0 | 1375.0 | 1650.0 | 7.0 |
| 2009-02-24 | ABFS-DELISTED | Stock | 19.74 | 20.5 | 19.58 | 20.33 | 446609.0 |
| 2009-02-24 | ABG | Stock | 3.94 | 4.05 | 3.81 | 3.91 | 222300.0 |
| 2009-02-24 | ABII-DELISTED | Stock | 72.77 | 72.87 | 70.26 | 72.8577 | 19138.0 |
| 2009-02-24 | ABK-DELISTED | Stock | 0.98 | 1.03 | 0.9 | 1.01 | 8782851.0 |
| 2009-02-24 | ABM | Stock | 12.45 | 12.63 | 12.17 | 12.52 | 362500.0 |
| 2009-02-24 | ABMD-DELISTED | Stock | 7.35 | 7.52 | 7.03 | 7.36 | 328075.0 |
| 2009-02-24 | ABR | Stock | 0.86 | 0.87 | 0.82 | 0.87 | 298200.0 |
| 2009-02-24 | ABT | Stock | 25.818 | 26.3554 | 25.7269 | 26.2643 | 18518758.0 |
| 2009-02-24 | ABTL-DELISTED | Stock | 1.9 | 2.1 | 1.8 | 1.9 | 2992.0 |
| 2009-02-24 | ABV-DELISTED | Stock | 40.62 | 41.46 | 39.58 | 41.23 | 373407.0 |
| 2009-02-24 | ABVA-DELISTED | Stock | 2.2499 | 2.2499 | 2.05 | 2.05 | 1470.0 |
| 2009-02-24 | ABVT-DELISTED | Stock | 38.0 | 39.0 | 38.0 | 39.0 | 300.0 |
| 2009-02-24 | ABX-DELISTED | Stock | 35.59 | 35.59 | 31.38 | 31.63 | 20916132.0 |
| 2009-02-24 | ACAD | Stock | 0.83 | 1.0 | 0.8 | 0.9 | 77300.0 |
| 2009-02-24 | ACAP-DELISTED | Stock | 43.3 | 45.61 | 43.08 | 45.29 | 71690.0 |
| 2009-02-24 | ACAS-DELISTED | Stock | 1.38 | 1.52 | 1.29 | 1.48 | 4771821.0 |
> showing 50 of 5,786 rows — these rows as CSV