PREVIEW / stock_daily / 2009-09-02
file: by_date/stock_daily/2009/2009-09-02.parquet size: 182 KB rows: 5,781 symbols: 3,439
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-09-02 | AAPL | Stock | 5.8793 | 5.9861 | 5.8611 | 5.8993 | 364249200.0 |
| 2009-09-02 | MSFT | Stock | 23.82 | 24.14 | 23.78 | 23.86 | 40771300.0 |
| 2009-09-02 | NVDA | Stock | 0.3513 | 0.3592 | 0.3493 | 0.3558 | 404656000.0 |
| 2009-09-02 | AMZN | Stock | 3.952 | 4.0075 | 3.89 | 3.907 | 130254000.0 |
| 2009-09-02 | TLT | Stock | 96.48 | 97.66 | 96.24 | 97.46 | 4344949.0 |
| 2009-09-02 | ES | Stock | 23.79 | 23.91 | 23.51 | 23.64 | 736000.0 |
| 2009-09-02 | CL | Stock | 35.855 | 36.12 | 35.635 | 36.0 | 3995800.0 |
| 2009-09-02 | A | Stock | 18.5765 | 18.5765 | 17.8541 | 18.0401 | 9033177.0 |
| 2009-09-02 | AABA-DELISTED | Stock | 14.08 | 14.33 | 13.97 | 14.23 | 22947849.0 |
| 2009-09-02 | AACC-DELISTED | Stock | 7.08 | 7.278 | 6.99 | 7.0 | 39881.0 |
| 2009-09-02 | AACG | Stock | 6.89 | 7.02 | 6.87 | 6.87 | 1800.0 |
| 2009-09-02 | AAI-DELISTED | Stock | 6.26 | 6.39 | 6.12 | 6.25 | 1650367.0 |
| 2009-09-02 | AAIC-DELISTED | Stock | 9.4 | 9.6 | 9.126 | 9.4 | 552260.0 |
| 2009-09-02 | AAON | Stock | 4.0889 | 4.1244 | 4.0178 | 4.0336 | 380194.0 |
| 2009-09-02 | AAP | Stock | 41.55 | 41.87 | 41.49 | 41.5 | 1223000.0 |
| 2009-09-02 | AATI-DELISTED | Stock | 4.35 | 4.401 | 4.32 | 4.35 | 293695.0 |
| 2009-09-02 | AAU-DELISTED | Stock | 0.63 | 0.8 | 0.62 | 0.75 | 720193.0 |
| 2009-09-02 | AAUAF-DELISTED | Stock | 0.63 | 0.8 | 0.62 | 0.75 | 722293.0 |
| 2009-09-02 | AAV-DELISTED | Stock | 5.29 | 5.4 | 5.2 | 5.36 | 1979228.0 |
| 2009-09-02 | AAWW-DELISTED | Stock | 23.71 | 24.32 | 23.4 | 23.45 | 334028.0 |
| 2009-09-02 | AAXJ | Stock | 47.58 | 48.33 | 47.58 | 48.03 | 117283.0 |
| 2009-09-02 | AAXN-DELISTED | Stock | 4.45 | 4.49 | 4.38 | 4.44 | 348283.0 |
| 2009-09-02 | AB | Stock | 22.05 | 22.22 | 21.4 | 21.51 | 636000.0 |
| 2009-09-02 | ABAX-DELISTED | Stock | 25.65 | 26.19 | 25.56 | 25.81 | 96534.0 |
| 2009-09-02 | ABB-DELISTED | Stock | 18.26 | 18.59 | 18.22 | 18.49 | 3880635.0 |
| 2009-09-02 | ABBC-DELISTED | Stock | 8.0 | 8.14 | 7.67 | 7.74 | 94951.0 |
| 2009-09-02 | ABBNY-DELISTED | Stock | 18.26 | 18.59 | 18.22 | 18.53 | 3882212.0 |
| 2009-09-02 | ABC-DELISTED | Stock | 21.22 | 21.25 | 20.99 | 21.0 | 1813873.0 |
| 2009-09-02 | ABCB | Stock | 6.0401 | 6.2541 | 6.0401 | 6.2541 | 20871.0 |
| 2009-09-02 | ABCO-DELISTED | Stock | 13.34 | 13.585 | 13.275 | 13.425 | 337270.0 |
| 2009-09-02 | ABCW-DELISTED | Stock | 1.28 | 1.28 | 1.15 | 1.23 | 100050.0 |
| 2009-09-02 | ABD-DELISTED | Stock | 5.6 | 5.62 | 5.33 | 5.58 | 192080.0 |
| 2009-09-02 | ABE-DELISTED | Stock | 16.17 | 16.2093 | 15.98 | 16.13 | 6375.0 |
| 2009-09-02 | ABEO | Stock | 4700.0 | 4875.0 | 4225.0 | 4500.0 | 47.0 |
| 2009-09-02 | ABFS-DELISTED | Stock | 31.6 | 32.02 | 31.42 | 31.63 | 381477.0 |
| 2009-09-02 | ABG | Stock | 12.37 | 12.74 | 12.0 | 12.45 | 510000.0 |
| 2009-09-02 | ABII-DELISTED | Stock | 26.52 | 26.72 | 24.52 | 25.38 | 124836.0 |
| 2009-09-02 | ABK-DELISTED | Stock | 1.5 | 1.6 | 1.42 | 1.47 | 24127167.0 |
| 2009-09-02 | ABM | Stock | 22.2 | 22.35 | 21.8 | 21.97 | 180000.0 |
| 2009-09-02 | ABMD-DELISTED | Stock | 7.93 | 8.01 | 7.83 | 7.94 | 154203.0 |
| 2009-09-02 | ABR | Stock | 1.86 | 1.87 | 1.8 | 1.83 | 239100.0 |
| 2009-09-02 | ABT | Stock | 21.639 | 21.7781 | 21.4567 | 21.591 | 14121509.0 |
| 2009-09-02 | ABTL-DELISTED | Stock | 3.25 | 3.3 | 3.25 | 3.3 | 4209.0 |
| 2009-09-02 | ABV-DELISTED | Stock | 71.18 | 73.44 | 70.52 | 72.51 | 411997.0 |
| 2009-09-02 | ABVA-DELISTED | Stock | 2.35 | 2.85 | 2.35 | 2.85 | 558.0 |
| 2009-09-02 | ABVT-DELISTED | Stock | 87.5 | 90.0 | 85.985 | 90.0 | 19896.0 |
| 2009-09-02 | ABX-DELISTED | Stock | 35.62 | 38.14 | 35.5 | 37.97 | 18108956.0 |
| 2009-09-02 | ACAD | Stock | 2.15 | 2.34 | 2.0 | 2.15 | 18749800.0 |
| 2009-09-02 | ACAP-DELISTED | Stock | 32.07 | 32.69 | 30.03 | 31.96 | 63670.0 |
| 2009-09-02 | ACAS-DELISTED | Stock | 2.23 | 2.24 | 2.125 | 2.14 | 4156523.0 |
> showing 50 of 5,781 rows — these rows as CSV