PREVIEW / stock_daily / 2009-02-17
file: by_date/stock_daily/2009/2009-02-17.parquet size: 174 KB rows: 5,726 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-17 | AAPL | Stock | 3.4596 | 3.4657 | 3.3671 | 3.3761 | 678238400.0 |
| 2009-02-17 | MSFT | Stock | 18.49 | 18.5 | 17.89 | 18.09 | 75853300.0 |
| 2009-02-17 | NVDA | Stock | 0.2 | 0.2047 | 0.195 | 0.1958 | 779576000.0 |
| 2009-02-17 | AMZN | Stock | 3.0835 | 3.1325 | 3.059 | 3.0835 | 142522000.0 |
| 2009-02-17 | TLT | Stock | 104.55 | 105.66 | 104.35 | 105.6 | 2813822.0 |
| 2009-02-17 | CL | Stock | 31.2 | 31.24 | 30.3 | 30.55 | 6260400.0 |
| 2009-02-17 | A | Stock | 12.6395 | 12.8612 | 12.3391 | 12.6252 | 7469794.0 |
| 2009-02-17 | AABA-DELISTED | Stock | 12.45 | 12.5799 | 12.01 | 12.02 | 15682908.0 |
| 2009-02-17 | AACC-DELISTED | Stock | 4.15 | 4.36 | 4.15 | 4.22 | 30663.0 |
| 2009-02-17 | AACG | Stock | 3.8 | 4.25 | 3.78 | 4.25 | 24000.0 |
| 2009-02-17 | AAI-DELISTED | Stock | 4.2 | 4.39 | 4.12 | 4.33 | 1784755.0 |
| 2009-02-17 | AAIC-DELISTED | Stock | 4.4 | 4.8 | 4.4 | 4.4 | 184124.0 |
| 2009-02-17 | AAME | Stock | 0.67 | 0.8 | 0.65 | 0.8 | 13800.0 |
| 2009-02-17 | AAON | Stock | 3.4647 | 3.4805 | 3.2119 | 3.2119 | 606994.0 |
| 2009-02-17 | AAP | Stock | 31.96 | 32.8 | 31.82 | 32.14 | 2782900.0 |
| 2009-02-17 | AATI-DELISTED | Stock | 3.17 | 3.24 | 2.98 | 3.04 | 141140.0 |
| 2009-02-17 | AAU-DELISTED | Stock | 0.86 | 0.92 | 0.86 | 0.86 | 148914.0 |
| 2009-02-17 | AAUAF-DELISTED | Stock | 0.86 | 0.92 | 0.86 | 0.86 | 149814.0 |
| 2009-02-17 | AAV-DELISTED | Stock | 2.99 | 2.99 | 2.73 | 2.75 | 1571025.0 |
| 2009-02-17 | AAWW-DELISTED | Stock | 15.11 | 15.14 | 14.46 | 14.66 | 158586.0 |
| 2009-02-17 | AAXJ | Stock | 30.82 | 30.82 | 29.15 | 29.24 | 35733.0 |
| 2009-02-17 | AAXN-DELISTED | Stock | 5.05 | 5.118 | 4.9 | 4.92 | 449156.0 |
| 2009-02-17 | AB | Stock | 15.0 | 15.0 | 14.05 | 14.15 | 635600.0 |
| 2009-02-17 | ABAX-DELISTED | Stock | 16.72 | 17.52 | 16.3701 | 17.26 | 356440.0 |
| 2009-02-17 | ABB-DELISTED | Stock | 12.62 | 12.63 | 12.26 | 12.28 | 7742982.0 |
| 2009-02-17 | ABBC-DELISTED | Stock | 6.67 | 6.78 | 6.31 | 6.7 | 120111.0 |
| 2009-02-17 | ABBNY-DELISTED | Stock | 12.62 | 12.63 | 12.25 | 12.25 | 7744384.0 |
| 2009-02-17 | ABC-DELISTED | Stock | 18.38 | 18.38 | 17.98 | 18.1 | 3113028.0 |
| 2009-02-17 | ABCB | Stock | 5.8942 | 6.0888 | 5.5538 | 5.5538 | 32078.0 |
| 2009-02-17 | ABCO-DELISTED | Stock | 7.96 | 8.075 | 7.875 | 7.92 | 437908.0 |
| 2009-02-17 | ABCW-DELISTED | Stock | 1.65 | 1.65 | 1.26 | 1.26 | 196790.0 |
| 2009-02-17 | ABD-DELISTED | Stock | 1.7944 | 1.8239 | 1.3803 | 1.4 | 328360.0 |
| 2009-02-17 | ABE-DELISTED | Stock | 11.9 | 11.9 | 11.5 | 11.6 | 7320.0 |
| 2009-02-17 | ABFS-DELISTED | Stock | 22.14 | 22.47 | 21.4 | 21.6 | 514099.0 |
| 2009-02-17 | ABG | Stock | 3.67 | 3.81 | 3.4 | 3.6 | 205400.0 |
| 2009-02-17 | ABII-DELISTED | Stock | 69.99 | 70.95 | 66.7 | 70.69 | 11506.0 |
| 2009-02-17 | ABK-DELISTED | Stock | 1.15 | 1.17 | 1.11 | 1.13 | 6700016.0 |
| 2009-02-17 | ABM | Stock | 12.76 | 12.8 | 12.37 | 12.46 | 536000.0 |
| 2009-02-17 | ABMD-DELISTED | Stock | 8.41 | 8.56 | 8.3 | 8.3 | 251132.0 |
| 2009-02-17 | ABR | Stock | 1.5 | 1.5 | 1.42 | 1.42 | 118000.0 |
| 2009-02-17 | ABT | Stock | 26.1875 | 26.2786 | 25.5925 | 25.8756 | 16305127.0 |
| 2009-02-17 | ABTL-DELISTED | Stock | 1.7003 | 1.9997 | 1.6998 | 1.9997 | 1160.0 |
| 2009-02-17 | ABV-DELISTED | Stock | 43.26 | 43.26 | 41.64 | 41.71 | 939340.0 |
| 2009-02-17 | ABVA-DELISTED | Stock | 2.9 | 3.05 | 2.5 | 2.9 | 4169.0 |
| 2009-02-17 | ABX-DELISTED | Stock | 38.86 | 39.29 | 36.97 | 37.27 | 20869612.0 |
| 2009-02-17 | ACAD | Stock | 0.94 | 0.98 | 0.93 | 0.94 | 34600.0 |
| 2009-02-17 | ACAP-DELISTED | Stock | 46.6 | 48.0 | 46.3 | 46.55 | 49382.0 |
| 2009-02-17 | ACAS-DELISTED | Stock | 2.15 | 2.15 | 1.86 | 1.88 | 5917886.0 |
| 2009-02-17 | ACAT-DELISTED | Stock | 3.88 | 3.96 | 3.64 | 3.64 | 66383.0 |
| 2009-02-17 | ACC-DELISTED | Stock | 17.18 | 18.199 | 16.82 | 17.14 | 1440072.0 |
> showing 50 of 5,726 rows — these rows as CSV