PREVIEW / stock_daily / 2009-12-14
file: by_date/stock_daily/2009/2009-12-14.parquet size: 189 KB rows: 5,907 symbols: 3,503
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-14 | AAPL | Stock | 6.9775 | 7.0511 | 6.8771 | 7.035 | 495790400.0 |
| 2009-12-14 | MSFT | Stock | 29.91 | 30.16 | 29.9 | 30.11 | 34651200.0 |
| 2009-12-14 | NVDA | Stock | 0.3858 | 0.393 | 0.3815 | 0.3918 | 405488000.0 |
| 2009-12-14 | AMZN | Stock | 6.625 | 6.6305 | 6.4675 | 6.569 | 200458000.0 |
| 2009-12-14 | TLT | Stock | 92.35 | 92.5 | 92.05 | 92.2 | 2380313.0 |
| 2009-12-14 | ES | Stock | 25.62 | 25.9 | 25.53 | 25.8 | 1342900.0 |
| 2009-12-14 | CL | Stock | 42.17 | 42.435 | 42.02 | 42.245 | 3478800.0 |
| 2009-12-14 | A | Stock | 21.309 | 21.4592 | 21.2589 | 21.4378 | 1865212.0 |
| 2009-12-14 | AABA-DELISTED | Stock | 15.89 | 15.97 | 15.64 | 15.8 | 16867203.0 |
| 2009-12-14 | AACC-DELISTED | Stock | 6.04 | 6.39 | 5.95 | 6.36 | 104715.0 |
| 2009-12-14 | AAI-DELISTED | Stock | 5.36 | 5.41 | 5.2 | 5.37 | 5425809.0 |
| 2009-12-14 | AAIC-DELISTED | Stock | 14.64 | 14.88 | 14.55 | 14.76 | 33420.0 |
| 2009-12-14 | AAME | Stock | 1.21 | 1.23 | 1.13 | 1.13 | 2900.0 |
| 2009-12-14 | AAON | Stock | 3.7847 | 3.8123 | 3.7472 | 3.7926 | 333619.0 |
| 2009-12-14 | AAP | Stock | 40.57 | 41.21 | 40.38 | 41.05 | 1522400.0 |
| 2009-12-14 | AATI-DELISTED | Stock | 3.64 | 3.8 | 3.56 | 3.78 | 609475.0 |
| 2009-12-14 | AAU-DELISTED | Stock | 1.1 | 1.1 | 1.05 | 1.06 | 97145.0 |
| 2009-12-14 | AAUAF-DELISTED | Stock | 1.1 | 1.1 | 1.05 | 1.06 | 98145.0 |
| 2009-12-14 | AAV-DELISTED | Stock | 5.99 | 6.17 | 5.99 | 6.1301 | 988802.0 |
| 2009-12-14 | AAWW-DELISTED | Stock | 34.87 | 35.69 | 34.87 | 35.52 | 265250.0 |
| 2009-12-14 | AAXJ | Stock | 55.83 | 55.9 | 55.55 | 55.89 | 59036.0 |
| 2009-12-14 | AAXN-DELISTED | Stock | 4.34 | 4.4 | 4.22 | 4.39 | 378806.0 |
| 2009-12-14 | AB | Stock | 26.03 | 26.09 | 25.8 | 26.0 | 691800.0 |
| 2009-12-14 | ABAX-DELISTED | Stock | 23.28 | 23.43 | 23.12 | 23.3 | 200624.0 |
| 2009-12-14 | ABB-DELISTED | Stock | 18.28 | 18.45 | 18.16 | 18.4 | 3013276.0 |
| 2009-12-14 | ABBC-DELISTED | Stock | 6.6801 | 6.84 | 6.65 | 6.71 | 42992.0 |
| 2009-12-14 | ABBNY-DELISTED | Stock | 18.28 | 18.45 | 18.16 | 18.39 | 3015956.0 |
| 2009-12-14 | ABC-DELISTED | Stock | 24.87 | 25.19 | 24.87 | 25.02 | 2711233.0 |
| 2009-12-14 | ABCB | Stock | 6.4689 | 6.6746 | 6.4297 | 6.6648 | 17549.0 |
| 2009-12-14 | ABCD-DELISTED | Stock | 4.75 | 4.76 | 4.74 | 4.76 | 3331.0 |
| 2009-12-14 | ABCO-DELISTED | Stock | 13.31 | 13.365 | 12.99 | 13.295 | 54612.0 |
| 2009-12-14 | ABCW-DELISTED | Stock | 0.62 | 0.66 | 0.5794 | 0.6 | 288430.0 |
| 2009-12-14 | ABD-DELISTED | Stock | 7.12 | 7.33 | 7.07 | 7.28 | 283390.0 |
| 2009-12-14 | ABE-DELISTED | Stock | 16.82 | 16.88 | 16.68 | 16.88 | 13375.0 |
| 2009-12-14 | ABEO | Stock | 3625.0 | 3687.5 | 3437.5 | 3650.0 | 13.0 |
| 2009-12-14 | ABFS-DELISTED | Stock | 27.99 | 28.55 | 27.77 | 28.47 | 193618.0 |
| 2009-12-14 | ABG | Stock | 11.58 | 11.72 | 11.38 | 11.65 | 336200.0 |
| 2009-12-14 | ABII-DELISTED | Stock | 37.87 | 39.477 | 37.87 | 39.3682 | 31902.0 |
| 2009-12-14 | ABK-DELISTED | Stock | 0.86 | 0.86 | 0.82 | 0.83 | 6829763.0 |
| 2009-12-14 | ABM | Stock | 19.97 | 20.23 | 19.78 | 20.2 | 97400.0 |
| 2009-12-14 | ABMD-DELISTED | Stock | 8.51 | 8.6 | 8.36 | 8.48 | 78724.0 |
| 2009-12-14 | ABR | Stock | 1.77 | 1.82 | 1.73 | 1.8 | 62400.0 |
| 2009-12-14 | ABT | Stock | 25.8036 | 26.0579 | 25.7892 | 25.8036 | 9362026.0 |
| 2009-12-14 | ABTL-DELISTED | Stock | 5.4399 | 5.5101 | 5.1594 | 5.5101 | 11268.0 |
| 2009-12-14 | ABV-DELISTED | Stock | 97.76 | 98.69 | 97.5 | 98.57 | 458347.0 |
| 2009-12-14 | ABVA-DELISTED | Stock | 2.43 | 2.43 | 2.32 | 2.32 | 12500.0 |
| 2009-12-14 | ABVT-DELISTED | Stock | 60.63 | 61.44 | 60.02 | 61.18 | 130935.0 |
| 2009-12-14 | ABX-DELISTED | Stock | 40.14 | 40.25 | 39.38 | 39.85 | 12280477.0 |
| 2009-12-14 | ACAD | Stock | 1.18 | 1.2 | 1.17 | 1.18 | 555500.0 |
| 2009-12-14 | ACAP-DELISTED | Stock | 28.2 | 29.22 | 28.2 | 29.19 | 66228.0 |
> showing 50 of 5,907 rows — these rows as CSV