PREVIEW / stock_daily / 2009-12-22
file: by_date/stock_daily/2009/2009-12-22.parquet size: 189 KB rows: 5,890 symbols: 3,498
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-12-22 | AAPL | Stock | 7.1229 | 7.1732 | 7.095 | 7.1557 | 349515600.0 |
| 2009-12-22 | MSFT | Stock | 30.6 | 30.93 | 30.54 | 30.82 | 36321000.0 |
| 2009-12-22 | NVDA | Stock | 0.4355 | 0.4515 | 0.435 | 0.447 | 793044000.0 |
| 2009-12-22 | AMZN | Stock | 6.688 | 6.7995 | 6.6325 | 6.6875 | 165150000.0 |
| 2009-12-22 | TLT | Stock | 90.8 | 90.87 | 90.421 | 90.63 | 3078813.0 |
| 2009-12-22 | ES | Stock | 26.2 | 26.38 | 25.93 | 25.97 | 1160900.0 |
| 2009-12-22 | CL | Stock | 41.605 | 41.86 | 41.42 | 41.62 | 3145400.0 |
| 2009-12-22 | A | Stock | 21.3948 | 21.6881 | 21.3305 | 21.588 | 3469696.0 |
| 2009-12-22 | AABA-DELISTED | Stock | 15.88 | 16.08 | 15.82 | 15.98 | 10545929.0 |
| 2009-12-22 | AACC-DELISTED | Stock | 6.07 | 6.12 | 5.98 | 5.98 | 31313.0 |
| 2009-12-22 | AACG | Stock | 4.43 | 4.48 | 4.34 | 4.38 | 2100.0 |
| 2009-12-22 | AAI-DELISTED | Stock | 5.26 | 5.5 | 5.26 | 5.39 | 4376227.0 |
| 2009-12-22 | AAIC-DELISTED | Stock | 15.32 | 16.2099 | 15.2 | 16.0001 | 19855.0 |
| 2009-12-22 | AAME | Stock | 1.24 | 1.26 | 1.24 | 1.25 | 5800.0 |
| 2009-12-22 | AAON | Stock | 3.9407 | 3.9467 | 3.8815 | 3.9131 | 193894.0 |
| 2009-12-22 | AAP | Stock | 41.51 | 41.75 | 41.31 | 41.47 | 1199800.0 |
| 2009-12-22 | AATI-DELISTED | Stock | 3.86 | 3.86 | 3.63 | 3.64 | 462746.0 |
| 2009-12-22 | AAU-DELISTED | Stock | 1.05 | 1.06 | 1.03 | 1.03 | 143342.0 |
| 2009-12-22 | AAUAF-DELISTED | Stock | 1.05 | 1.06 | 1.03 | 1.03 | 143542.0 |
| 2009-12-22 | AAV-DELISTED | Stock | 6.66 | 6.71 | 6.47 | 6.61 | 554919.0 |
| 2009-12-22 | AAWW-DELISTED | Stock | 37.25 | 37.97 | 36.6 | 37.35 | 246072.0 |
| 2009-12-22 | AAXJ | Stock | 54.35 | 54.42 | 54.0 | 54.18 | 129442.0 |
| 2009-12-22 | AAXN-DELISTED | Stock | 4.44 | 4.56 | 4.408 | 4.5 | 550678.0 |
| 2009-12-22 | AB | Stock | 26.58 | 26.89 | 26.3 | 26.48 | 378800.0 |
| 2009-12-22 | ABAX-DELISTED | Stock | 22.36 | 22.84 | 22.35 | 22.55 | 85488.0 |
| 2009-12-22 | ABB-DELISTED | Stock | 18.72 | 18.83 | 18.66 | 18.741 | 2447913.0 |
| 2009-12-22 | ABBC-DELISTED | Stock | 6.8 | 6.82 | 6.6 | 6.65 | 67422.0 |
| 2009-12-22 | ABBNY-DELISTED | Stock | 18.72 | 18.83 | 18.66 | 18.74 | 2597613.0 |
| 2009-12-22 | ABC-DELISTED | Stock | 26.25 | 26.42 | 26.14 | 26.29 | 2012442.0 |
| 2009-12-22 | ABCB | Stock | 6.5668 | 6.606 | 6.5178 | 6.5276 | 22956.0 |
| 2009-12-22 | ABCD-DELISTED | Stock | 5.56 | 5.87 | 5.5 | 5.5 | 18200.0 |
| 2009-12-22 | ABCO-DELISTED | Stock | 13.96 | 14.443 | 13.925 | 14.31 | 127614.0 |
| 2009-12-22 | ABCW-DELISTED | Stock | 0.69 | 0.7 | 0.62 | 0.69 | 264890.0 |
| 2009-12-22 | ABD-DELISTED | Stock | 7.41 | 7.46 | 7.23 | 7.42 | 174270.0 |
| 2009-12-22 | ABE-DELISTED | Stock | 16.47 | 16.57 | 16.4104 | 16.42 | 6969.0 |
| 2009-12-22 | ABEO | Stock | 3875.0 | 4000.0 | 3625.0 | 3775.0 | 39.0 |
| 2009-12-22 | ABFS-DELISTED | Stock | 31.66 | 31.78 | 30.375 | 30.84 | 383484.0 |
| 2009-12-22 | ABG | Stock | 11.47 | 11.74 | 11.41 | 11.64 | 129700.0 |
| 2009-12-22 | ABII-DELISTED | Stock | 38.45 | 40.16 | 37.53 | 40.16 | 29383.0 |
| 2009-12-22 | ABK-DELISTED | Stock | 0.7959 | 0.9 | 0.78 | 0.8502 | 24996764.0 |
| 2009-12-22 | ABM | Stock | 20.94 | 21.08 | 20.78 | 20.81 | 266100.0 |
| 2009-12-22 | ABMD-DELISTED | Stock | 8.54 | 8.61 | 8.36 | 8.55 | 134158.0 |
| 2009-12-22 | ABR | Stock | 1.67 | 1.74 | 1.65 | 1.68 | 100500.0 |
| 2009-12-22 | ABT | Stock | 25.9284 | 26.0483 | 25.9188 | 25.9668 | 10124844.0 |
| 2009-12-22 | ABTL-DELISTED | Stock | 4.85 | 4.9505 | 4.55 | 4.7 | 14706.0 |
| 2009-12-22 | ABV-DELISTED | Stock | 95.38 | 97.03 | 95.38 | 96.62 | 325247.0 |
| 2009-12-22 | ABVA-DELISTED | Stock | 3.83 | 3.83 | 3.5 | 3.501 | 4500.0 |
| 2009-12-22 | ABVT-DELISTED | Stock | 65.75 | 66.0 | 65.08 | 65.49 | 116311.0 |
| 2009-12-22 | ABX-DELISTED | Stock | 39.04 | 39.3 | 38.41 | 38.9 | 12690305.0 |
| 2009-12-22 | ACAD | Stock | 1.39 | 1.39 | 1.31 | 1.38 | 550800.0 |
> showing 50 of 5,890 rows — these rows as CSV