PREVIEW / stock_daily / 2009-02-10
file: by_date/stock_daily/2009/2009-02-10.parquet size: 176 KB rows: 5,717 symbols: 3,410
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-10 | AAPL | Stock | 3.6189 | 3.6611 | 3.4664 | 3.4939 | 849060800.0 |
| 2009-02-10 | MSFT | Stock | 19.25 | 19.8 | 18.7 | 18.8 | 83953200.0 |
| 2009-02-10 | NVDA | Stock | 0.2432 | 0.2465 | 0.2285 | 0.233 | 1129664000.0 |
| 2009-02-10 | AMZN | Stock | 3.3075 | 3.3615 | 3.1535 | 3.1655 | 214012000.0 |
| 2009-02-10 | TLT | Stock | 104.11 | 104.96 | 103.45 | 104.85 | 3783001.0 |
| 2009-02-10 | CL | Stock | 31.965 | 32.33 | 31.095 | 31.32 | 6832000.0 |
| 2009-02-10 | A | Stock | 13.5408 | 13.6481 | 12.9757 | 13.0615 | 5272277.0 |
| 2009-02-10 | AABA-DELISTED | Stock | 13.59 | 13.59 | 12.72 | 12.76 | 23646519.0 |
| 2009-02-10 | AACC-DELISTED | Stock | 4.91 | 4.99 | 4.69 | 4.69 | 49160.0 |
| 2009-02-10 | AACG | Stock | 3.71 | 4.18 | 3.7 | 3.7 | 16100.0 |
| 2009-02-10 | AAI-DELISTED | Stock | 4.38 | 4.41 | 4.11 | 4.2 | 2729493.0 |
| 2009-02-10 | AAIC-DELISTED | Stock | 4.6 | 5.0 | 4.4 | 4.4 | 247479.0 |
| 2009-02-10 | AAME | Stock | 0.88 | 0.96 | 0.66 | 0.94 | 10000.0 |
| 2009-02-10 | AAON | Stock | 3.7116 | 3.7669 | 3.4825 | 3.4825 | 433350.0 |
| 2009-02-10 | AAP | Stock | 33.95 | 34.71 | 32.84 | 32.95 | 2653400.0 |
| 2009-02-10 | AATI-DELISTED | Stock | 2.84 | 3.0 | 2.83 | 2.85 | 142836.0 |
| 2009-02-10 | AAU-DELISTED | Stock | 0.73 | 0.73 | 0.67 | 0.6898 | 68286.0 |
| 2009-02-10 | AAUAF-DELISTED | Stock | 0.73 | 0.73 | 0.67 | 0.6898 | 68386.0 |
| 2009-02-10 | AAV-DELISTED | Stock | 3.71 | 3.71 | 3.43 | 3.5 | 1284173.0 |
| 2009-02-10 | AAWW-DELISTED | Stock | 17.07 | 18.68 | 15.86 | 16.55 | 351878.0 |
| 2009-02-10 | AAXJ | Stock | 33.05 | 33.05 | 30.89 | 31.08 | 94038.0 |
| 2009-02-10 | AAXN-DELISTED | Stock | 5.61 | 5.79 | 5.28 | 5.32 | 478333.0 |
| 2009-02-10 | AB | Stock | 17.8 | 17.85 | 15.54 | 15.69 | 636000.0 |
| 2009-02-10 | ABAX-DELISTED | Stock | 18.39 | 18.81 | 17.29 | 17.33 | 362631.0 |
| 2009-02-10 | ABB-DELISTED | Stock | 14.08 | 14.15 | 13.402 | 13.52 | 5448533.0 |
| 2009-02-10 | ABBC-DELISTED | Stock | 7.16 | 7.2525 | 6.8 | 6.81 | 157886.0 |
| 2009-02-10 | ABBNY-DELISTED | Stock | 14.08 | 14.15 | 13.402 | 13.5 | 5453063.0 |
| 2009-02-10 | ABC-DELISTED | Stock | 19.16 | 19.36 | 18.74 | 18.82 | 4156050.0 |
| 2009-02-10 | ABCB | Stock | 8.1896 | 8.3453 | 6.896 | 6.896 | 26320.0 |
| 2009-02-10 | ABCO-DELISTED | Stock | 8.36 | 8.575 | 8.16 | 8.32 | 682015.0 |
| 2009-02-10 | ABCW-DELISTED | Stock | 2.0 | 2.19 | 1.67 | 1.67 | 147950.0 |
| 2009-02-10 | ABD-DELISTED | Stock | 1.9547 | 2.0145 | 1.7253 | 1.7353 | 162160.0 |
| 2009-02-10 | ABE-DELISTED | Stock | 12.7 | 12.9 | 12.28 | 12.28 | 9326.0 |
| 2009-02-10 | ABEO | Stock | 1250.0 | 1250.0 | 1062.5 | 1250.0 | 5.0 |
| 2009-02-10 | ABFS-DELISTED | Stock | 25.24 | 25.85 | 23.98 | 24.31 | 1144716.0 |
| 2009-02-10 | ABG | Stock | 4.38 | 4.48 | 4.0 | 4.07 | 127800.0 |
| 2009-02-10 | ABII-DELISTED | Stock | 71.58 | 71.82 | 70.6 | 71.0 | 6321.0 |
| 2009-02-10 | ABK-DELISTED | Stock | 1.44 | 1.44 | 1.1 | 1.16 | 16193558.0 |
| 2009-02-10 | ABM | Stock | 14.56 | 14.76 | 13.6 | 13.67 | 467600.0 |
| 2009-02-10 | ABMD-DELISTED | Stock | 8.95 | 9.06 | 8.47 | 8.76 | 811354.0 |
| 2009-02-10 | ABR | Stock | 1.75 | 1.8 | 1.51 | 1.54 | 157600.0 |
| 2009-02-10 | ABT | Stock | 27.3822 | 27.4686 | 26.5665 | 26.768 | 23895373.0 |
| 2009-02-10 | ABTL-DELISTED | Stock | 1.922 | 2.0 | 1.85 | 1.95 | 3195.0 |
| 2009-02-10 | ABV-DELISTED | Stock | 44.49 | 45.05 | 43.4 | 43.92 | 877903.0 |
| 2009-02-10 | ABVA-DELISTED | Stock | 1.3 | 2.58 | 1.3 | 1.72 | 11149.0 |
| 2009-02-10 | ABVT-DELISTED | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 1000.0 |
| 2009-02-10 | ABX-DELISTED | Stock | 38.75 | 38.88 | 36.84 | 37.05 | 12994997.0 |
| 2009-02-10 | ACAD | Stock | 0.95 | 1.05 | 0.94 | 0.95 | 69900.0 |
| 2009-02-10 | ACAP-DELISTED | Stock | 44.15 | 45.0 | 43.2 | 43.79 | 48204.0 |
| 2009-02-10 | ACAS-DELISTED | Stock | 3.16 | 3.3 | 2.59 | 2.63 | 5891527.0 |
> showing 50 of 5,717 rows — these rows as CSV