PREVIEW / stock_daily / 2010-01-26
file: by_date/stock_daily/2010/2010-01-26.parquet size: 188 KB rows: 5,903 symbols: 3,496
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-26 | AAPL | Stock | 7.3554 | 7.6325 | 7.235 | 7.355 | 1867110000.0 |
| 2010-01-26 | MSFT | Stock | 29.2 | 29.85 | 29.09 | 29.5 | 66639900.0 |
| 2010-01-26 | NVDA | Stock | 0.4165 | 0.4192 | 0.405 | 0.4053 | 714636000.0 |
| 2010-01-26 | AMZN | Stock | 6.028 | 6.149 | 5.953 | 5.974 | 191180000.0 |
| 2010-01-26 | TLT | Stock | 92.02 | 92.11 | 91.31 | 91.61 | 3138034.0 |
| 2010-01-26 | ES | Stock | 25.36 | 25.6 | 25.35 | 25.46 | 887200.0 |
| 2010-01-26 | CL | Stock | 39.93 | 40.38 | 39.75 | 40.19 | 5581400.0 |
| 2010-01-26 | A | Stock | 21.0086 | 21.1016 | 20.7296 | 20.9514 | 2696882.0 |
| 2010-01-26 | AABA-DELISTED | Stock | 15.82 | 16.17 | 15.7 | 15.98 | 43594294.0 |
| 2010-01-26 | AACC-DELISTED | Stock | 5.94 | 6.09 | 5.64 | 5.64 | 20703.0 |
| 2010-01-26 | AACG | Stock | 4.0 | 4.02 | 3.86 | 3.95 | 16300.0 |
| 2010-01-26 | AAI-DELISTED | Stock | 5.34 | 5.36 | 5.182 | 5.24 | 3952124.0 |
| 2010-01-26 | AAIC-DELISTED | Stock | 14.95 | 14.96 | 14.64 | 14.64 | 11925.0 |
| 2010-01-26 | AAME | Stock | 1.44 | 1.45 | 1.44 | 1.45 | 3600.0 |
| 2010-01-26 | AAON | Stock | 3.8953 | 3.921 | 3.838 | 3.8815 | 349312.0 |
| 2010-01-26 | AAP | Stock | 40.48 | 41.0 | 40.26 | 40.55 | 1084100.0 |
| 2010-01-26 | AATI-DELISTED | Stock | 3.62 | 3.71 | 3.5 | 3.53 | 206897.0 |
| 2010-01-26 | AAU-DELISTED | Stock | 0.97 | 0.98 | 0.92 | 0.96 | 174541.0 |
| 2010-01-26 | AAUAF-DELISTED | Stock | 0.97 | 0.98 | 0.92 | 0.96 | 175341.0 |
| 2010-01-26 | AAV-DELISTED | Stock | 6.51 | 6.62 | 6.4 | 6.5399 | 443569.0 |
| 2010-01-26 | AAWW-DELISTED | Stock | 36.85 | 37.375 | 36.07 | 36.47 | 217229.0 |
| 2010-01-26 | AAXJ | Stock | 53.28 | 53.3799 | 52.7 | 52.7 | 673391.0 |
| 2010-01-26 | AAXN-DELISTED | Stock | 5.76 | 5.87 | 5.65 | 5.82 | 1070716.0 |
| 2010-01-26 | AB | Stock | 27.75 | 27.91 | 26.84 | 27.0 | 443000.0 |
| 2010-01-26 | ABAX-DELISTED | Stock | 23.51 | 23.72 | 23.4 | 23.51 | 114837.0 |
| 2010-01-26 | ABB-DELISTED | Stock | 18.42 | 18.76 | 18.31 | 18.52 | 5594560.0 |
| 2010-01-26 | ABBC-DELISTED | Stock | 7.03 | 7.0998 | 7.02 | 7.03 | 33601.0 |
| 2010-01-26 | ABBNY-DELISTED | Stock | 18.42 | 18.76 | 18.31 | 18.51 | 5595060.0 |
| 2010-01-26 | ABC-DELISTED | Stock | 27.86 | 28.0 | 27.34 | 27.42 | 5560571.0 |
| 2010-01-26 | ABCB | Stock | 9.0865 | 9.1754 | 9.0766 | 9.0865 | 43436.0 |
| 2010-01-26 | ABCD-DELISTED | Stock | 3.99 | 4.0 | 3.92 | 3.92 | 22563.0 |
| 2010-01-26 | ABCO-DELISTED | Stock | 15.78 | 15.925 | 15.63 | 15.84 | 431528.0 |
| 2010-01-26 | ABCW-DELISTED | Stock | 1.24 | 1.2425 | 1.05 | 1.12 | 305820.0 |
| 2010-01-26 | ABD-DELISTED | Stock | 8.12 | 8.13 | 7.963 | 8.0 | 382290.0 |
| 2010-01-26 | ABE-DELISTED | Stock | 16.25 | 16.25 | 15.97 | 16.06 | 11158.0 |
| 2010-01-26 | ABEO | Stock | 3375.0 | 3437.5 | 3325.0 | 3437.5 | 46.0 |
| 2010-01-26 | ABFS-DELISTED | Stock | 26.14 | 26.81 | 26.14 | 26.15 | 158325.0 |
| 2010-01-26 | ABG | Stock | 11.9 | 12.4 | 11.68 | 11.94 | 274300.0 |
| 2010-01-26 | ABII-DELISTED | Stock | 41.8 | 42.11 | 40.87 | 41.52 | 35181.0 |
| 2010-01-26 | ABK-DELISTED | Stock | 0.7056 | 0.75 | 0.7 | 0.71 | 6179968.0 |
| 2010-01-26 | ABM | Stock | 19.41 | 19.68 | 19.38 | 19.41 | 128100.0 |
| 2010-01-26 | ABMD-DELISTED | Stock | 8.25 | 8.49 | 8.06 | 8.15 | 217940.0 |
| 2010-01-26 | ABR | Stock | 2.25 | 2.27 | 2.16 | 2.17 | 48600.0 |
| 2010-01-26 | ABT | Stock | 26.1827 | 26.2307 | 26.0339 | 26.1395 | 13814506.0 |
| 2010-01-26 | ABTL-DELISTED | Stock | 5.15 | 5.2 | 4.9005 | 5.15 | 13919.0 |
| 2010-01-26 | ABV-DELISTED | Stock | 97.36 | 98.25 | 96.31 | 96.87 | 466247.0 |
| 2010-01-26 | ABVA-DELISTED | Stock | 2.62 | 2.62 | 2.62 | 2.62 | 389.0 |
| 2010-01-26 | ABVT-DELISTED | Stock | 62.75 | 62.75 | 61.86 | 62.2 | 79060.0 |
| 2010-01-26 | ABX-DELISTED | Stock | 35.75 | 36.78 | 35.62 | 36.07 | 12928312.0 |
| 2010-01-26 | ACAD | Stock | 1.27 | 1.32 | 1.25 | 1.25 | 287800.0 |
> showing 50 of 5,903 rows — these rows as CSV