PREVIEW / stock_daily / 2009-05-28
file: by_date/stock_daily/2009/2009-05-28.parquet size: 181 KB rows: 5,796 symbols: 3,469
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-05-28 | AAPL | Stock | 4.7661 | 4.8354 | 4.7154 | 4.8239 | 487552800.0 |
| 2009-05-28 | MSFT | Stock | 20.32 | 20.63 | 20.05 | 20.45 | 45480800.0 |
| 2009-05-28 | NVDA | Stock | 0.2632 | 0.265 | 0.2515 | 0.2628 | 995288000.0 |
| 2009-05-28 | AMZN | Stock | 3.885 | 3.955 | 3.794 | 3.8825 | 98862000.0 |
| 2009-05-28 | TLT | Stock | 91.77 | 91.98 | 90.23 | 91.8 | 9826336.0 |
| 2009-05-28 | ES | Stock | 20.43 | 20.77 | 20.43 | 20.65 | 2012300.0 |
| 2009-05-28 | CL | Stock | 31.84 | 32.05 | 31.45 | 31.985 | 7615000.0 |
| 2009-05-28 | A | Stock | 12.9471 | 13.0186 | 12.5179 | 12.8612 | 3126627.0 |
| 2009-05-28 | AABA-DELISTED | Stock | 15.09 | 15.24 | 14.69 | 15.09 | 18830533.0 |
| 2009-05-28 | AACC-DELISTED | Stock | 7.66 | 8.57 | 7.35 | 8.55 | 48090.0 |
| 2009-05-28 | AACG | Stock | 5.88 | 5.99 | 5.68 | 5.7 | 23800.0 |
| 2009-05-28 | AAI-DELISTED | Stock | 5.39 | 5.41 | 4.95 | 5.07 | 7893114.0 |
| 2009-05-28 | AAIC-DELISTED | Stock | 8.0 | 8.2 | 7.8 | 8.0 | 1094454.0 |
| 2009-05-28 | AAON | Stock | 4.1067 | 4.1284 | 3.9704 | 4.0889 | 240469.0 |
| 2009-05-28 | AAP | Stock | 44.52 | 44.76 | 42.25 | 43.42 | 2876000.0 |
| 2009-05-28 | AATI-DELISTED | Stock | 4.53 | 4.58 | 4.29 | 4.51 | 144949.0 |
| 2009-05-28 | AAU-DELISTED | Stock | 0.8 | 0.82 | 0.767 | 0.814 | 74557.0 |
| 2009-05-28 | AAUAF-DELISTED | Stock | 0.8 | 0.82 | 0.767 | 0.814 | 74657.0 |
| 2009-05-28 | AAV-DELISTED | Stock | 4.01 | 4.11 | 3.98 | 4.1 | 751488.0 |
| 2009-05-28 | AAWW-DELISTED | Stock | 25.0 | 25.8 | 24.25 | 24.97 | 262880.0 |
| 2009-05-28 | AAXJ | Stock | 43.63 | 44.18 | 43.11 | 44.17 | 91021.0 |
| 2009-05-28 | AAXN-DELISTED | Stock | 4.29 | 4.34 | 4.06 | 4.19 | 431976.0 |
| 2009-05-28 | AB | Stock | 18.38 | 18.74 | 18.22 | 18.65 | 551400.0 |
| 2009-05-28 | ABAX-DELISTED | Stock | 17.61 | 17.677 | 17.16 | 17.29 | 117888.0 |
| 2009-05-28 | ABB-DELISTED | Stock | 16.1 | 16.29 | 15.77 | 16.23 | 3448142.0 |
| 2009-05-28 | ABBC-DELISTED | Stock | 8.33 | 8.42 | 7.97 | 7.98 | 40279.0 |
| 2009-05-28 | ABBNY-DELISTED | Stock | 16.09 | 16.29 | 15.77 | 16.23 | 3508504.0 |
| 2009-05-28 | ABC-DELISTED | Stock | 18.5 | 18.64 | 18.26 | 18.42 | 2464554.0 |
| 2009-05-28 | ABCB | Stock | 5.9137 | 6.2055 | 5.865 | 5.9039 | 25806.0 |
| 2009-05-28 | ABCO-DELISTED | Stock | 11.628 | 11.723 | 11.147 | 11.517 | 266552.0 |
| 2009-05-28 | ABCW-DELISTED | Stock | 1.53 | 1.62 | 1.48 | 1.55 | 242400.0 |
| 2009-05-28 | ABD-DELISTED | Stock | 3.0006 | 3.1926 | 2.7904 | 2.94 | 509780.0 |
| 2009-05-28 | ABE-DELISTED | Stock | 15.39 | 15.55 | 14.9 | 15.17 | 22423.0 |
| 2009-05-28 | ABEO | Stock | 1875.0 | 2125.0 | 1875.0 | 2000.0 | 98.0 |
| 2009-05-28 | ABFS-DELISTED | Stock | 27.95 | 28.36 | 26.67 | 27.7 | 391752.0 |
| 2009-05-28 | ABG | Stock | 9.3 | 9.72 | 8.73 | 9.35 | 406200.0 |
| 2009-05-28 | ABII-DELISTED | Stock | 50.25 | 51.19 | 49.01 | 51.19 | 18227.0 |
| 2009-05-28 | ABK-DELISTED | Stock | 1.29 | 1.31 | 1.2 | 1.24 | 6605567.0 |
| 2009-05-28 | ABM | Stock | 16.39 | 16.62 | 15.9 | 16.06 | 197800.0 |
| 2009-05-28 | ABMD-DELISTED | Stock | 6.09 | 6.14 | 5.79 | 5.86 | 191248.0 |
| 2009-05-28 | ABR | Stock | 1.88 | 1.88 | 1.75 | 1.82 | 196300.0 |
| 2009-05-28 | ABT | Stock | 21.2168 | 21.5382 | 21.1928 | 21.3991 | 12396207.0 |
| 2009-05-28 | ABTL-DELISTED | Stock | 2.05 | 2.15 | 2.05 | 2.1 | 6563.0 |
| 2009-05-28 | ABV-DELISTED | Stock | 63.79 | 64.74 | 63.05 | 64.69 | 476982.0 |
| 2009-05-28 | ABVA-DELISTED | Stock | 3.1901 | 3.46 | 3.1901 | 3.45 | 800.0 |
| 2009-05-28 | ABVT-DELISTED | Stock | 69.13 | 72.0 | 69.13 | 71.55 | 97168.0 |
| 2009-05-28 | ABX-DELISTED | Stock | 36.64 | 37.54 | 36.51 | 37.15 | 8444325.0 |
| 2009-05-28 | ACAD | Stock | 1.91 | 1.95 | 1.85 | 1.86 | 133700.0 |
| 2009-05-28 | ACAP-DELISTED | Stock | 37.95 | 38.05 | 37.5 | 37.79 | 41333.0 |
| 2009-05-28 | ACAS-DELISTED | Stock | 3.06 | 3.11 | 2.85 | 2.92 | 5812067.0 |
> showing 50 of 5,796 rows — these rows as CSV