PREVIEW / stock_daily / 2009-07-31
file: by_date/stock_daily/2009/2009-07-31.parquet size: 184 KB rows: 5,802 symbols: 3,455
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-07-31 | AAPL | Stock | 5.8211 | 5.8929 | 5.8182 | 5.8354 | 422536800.0 |
| 2009-07-31 | MSFT | Stock | 23.77 | 24.07 | 23.5 | 23.52 | 54258200.0 |
| 2009-07-31 | NVDA | Stock | 0.322 | 0.3278 | 0.3145 | 0.3233 | 541560000.0 |
| 2009-07-31 | AMZN | Stock | 4.288 | 4.3375 | 4.231 | 4.288 | 117738000.0 |
| 2009-07-31 | TLT | Stock | 93.85 | 94.86 | 93.28 | 94.81 | 5697633.0 |
| 2009-07-31 | ES | Stock | 23.09 | 23.26 | 22.91 | 23.01 | 1984900.0 |
| 2009-07-31 | CL | Stock | 36.115 | 36.525 | 35.565 | 36.22 | 9985400.0 |
| 2009-07-31 | A | Stock | 16.5951 | 16.8312 | 16.4235 | 16.6094 | 3542113.0 |
| 2009-07-31 | AABA-DELISTED | Stock | 14.72 | 14.89 | 14.29 | 14.33 | 62113081.0 |
| 2009-07-31 | AACC-DELISTED | Stock | 7.8 | 8.1 | 7.65 | 7.73 | 68831.0 |
| 2009-07-31 | AACG | Stock | 8.26 | 8.68 | 8.11 | 8.55 | 5900.0 |
| 2009-07-31 | AAI-DELISTED | Stock | 7.27 | 7.37 | 7.19 | 7.25 | 1889962.0 |
| 2009-07-31 | AAIC-DELISTED | Stock | 7.4 | 8.4 | 7.4 | 8.3 | 670731.0 |
| 2009-07-31 | AAON | Stock | 3.9111 | 3.9862 | 3.8736 | 3.8736 | 321469.0 |
| 2009-07-31 | AAP | Stock | 47.01 | 47.17 | 46.12 | 46.23 | 1071600.0 |
| 2009-07-31 | AATI-DELISTED | Stock | 4.86 | 5.04 | 4.72 | 4.82 | 545509.0 |
| 2009-07-31 | AAU-DELISTED | Stock | 0.64 | 0.68 | 0.63 | 0.68 | 87771.0 |
| 2009-07-31 | AAUAF-DELISTED | Stock | 0.64 | 0.68 | 0.63 | 0.68 | 89031.0 |
| 2009-07-31 | AAV-DELISTED | Stock | 5.04 | 5.25 | 5.0 | 5.19 | 639967.0 |
| 2009-07-31 | AAWW-DELISTED | Stock | 24.94 | 25.37 | 24.84 | 24.96 | 204654.0 |
| 2009-07-31 | AAXJ | Stock | 50.08 | 50.44 | 49.81 | 50.21 | 150973.0 |
| 2009-07-31 | AAXN-DELISTED | Stock | 5.39 | 5.46 | 5.22 | 5.25 | 364597.0 |
| 2009-07-31 | AB | Stock | 21.29 | 21.36 | 19.91 | 20.64 | 1722600.0 |
| 2009-07-31 | ABAX-DELISTED | Stock | 24.38 | 27.46 | 24.26 | 26.76 | 1700317.0 |
| 2009-07-31 | ABB-DELISTED | Stock | 17.9 | 18.4 | 17.75 | 18.3001 | 4363880.0 |
| 2009-07-31 | ABBC-DELISTED | Stock | 8.45 | 8.5 | 8.17 | 8.18 | 48861.0 |
| 2009-07-31 | ABBNY-DELISTED | Stock | 17.9 | 18.4 | 17.75 | 18.28 | 4374478.0 |
| 2009-07-31 | ABC-DELISTED | Stock | 19.82 | 19.97 | 19.35 | 19.69 | 4484478.0 |
| 2009-07-31 | ABCB | Stock | 6.4195 | 6.6042 | 5.8456 | 6.3027 | 24675.0 |
| 2009-07-31 | ABCO-DELISTED | Stock | 12.645 | 12.99 | 12.135 | 12.79 | 128874.0 |
| 2009-07-31 | ABCW-DELISTED | Stock | 1.29 | 1.36 | 1.25 | 1.36 | 83450.0 |
| 2009-07-31 | ABD-DELISTED | Stock | 4.6146 | 4.804 | 4.3654 | 4.3854 | 644210.0 |
| 2009-07-31 | ABE-DELISTED | Stock | 16.45 | 16.58 | 16.2597 | 16.48 | 8502.0 |
| 2009-07-31 | ABEO | Stock | 5662.5 | 5875.0 | 5225.0 | 5625.0 | 68.0 |
| 2009-07-31 | ABFS-DELISTED | Stock | 26.08 | 28.63 | 25.91 | 28.48 | 812477.0 |
| 2009-07-31 | ABG | Stock | 13.14 | 14.15 | 13.14 | 13.99 | 649600.0 |
| 2009-07-31 | ABII-DELISTED | Stock | 31.68 | 31.68 | 30.72 | 30.77 | 11271.0 |
| 2009-07-31 | ABK-DELISTED | Stock | 0.775 | 0.775 | 0.75 | 0.7514 | 3553914.0 |
| 2009-07-31 | ABM | Stock | 20.97 | 21.26 | 20.85 | 21.07 | 209800.0 |
| 2009-07-31 | ABMD-DELISTED | Stock | 7.6 | 7.77 | 7.5 | 7.55 | 304163.0 |
| 2009-07-31 | ABR | Stock | 1.9 | 1.93 | 1.8 | 1.81 | 104400.0 |
| 2009-07-31 | ABT | Stock | 21.9461 | 22.0756 | 21.5526 | 21.5862 | 20092747.0 |
| 2009-07-31 | ABTL-DELISTED | Stock | 2.5 | 2.5065 | 2.45 | 2.45 | 38544.0 |
| 2009-07-31 | ABV-DELISTED | Stock | 70.85 | 71.2496 | 70.1 | 70.4 | 576364.0 |
| 2009-07-31 | ABVA-DELISTED | Stock | 2.74 | 2.74 | 2.74 | 2.74 | 250.0 |
| 2009-07-31 | ABVT-DELISTED | Stock | 82.49 | 82.7 | 81.12 | 82.0 | 69662.0 |
| 2009-07-31 | ABX-DELISTED | Stock | 33.77 | 35.2 | 33.61 | 34.9 | 10207478.0 |
| 2009-07-31 | ACAD | Stock | 4.51 | 4.51 | 3.83 | 4.07 | 1475600.0 |
| 2009-07-31 | ACAP-DELISTED | Stock | 43.05 | 45.57 | 42.28 | 44.56 | 91198.0 |
| 2009-07-31 | ACAS-DELISTED | Stock | 3.31 | 3.63 | 3.28 | 3.6039 | 4579322.0 |
> showing 50 of 5,802 rows — these rows as CSV