PREVIEW / stock_daily / 2008-07-31
file: by_date/stock_daily/2008/2008-07-31.parquet size: 184 KB rows: 5,761 symbols: 3,483
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-31 | AAPL | Stock | 5.6264 | 5.7929 | 5.6064 | 5.6768 | 637498400.0 |
| 2008-07-31 | MSFT | Stock | 25.85 | 26.28 | 25.71 | 25.72 | 60461000.0 |
| 2008-07-31 | NVDA | Stock | 0.2862 | 0.2922 | 0.283 | 0.286 | 487236000.0 |
| 2008-07-31 | AMZN | Stock | 3.8375 | 3.9085 | 3.805 | 3.817 | 106014000.0 |
| 2008-07-31 | TLT | Stock | 91.72 | 92.05 | 91.27 | 91.67 | 3898642.0 |
| 2008-07-31 | CL | Stock | 37.345 | 37.585 | 36.895 | 37.135 | 6710200.0 |
| 2008-07-31 | A | Stock | 26.1159 | 26.2232 | 25.7654 | 25.794 | 2710023.0 |
| 2008-07-31 | AABA-DELISTED | Stock | 19.9 | 20.15 | 19.85 | 19.89 | 16077844.0 |
| 2008-07-31 | AACC-DELISTED | Stock | 11.69 | 11.99 | 11.35 | 11.75 | 51370.0 |
| 2008-07-31 | AACG | Stock | 14.98 | 15.0 | 14.87 | 14.97 | 16800.0 |
| 2008-07-31 | AAI-DELISTED | Stock | 2.99 | 3.19 | 2.76 | 2.91 | 3962785.0 |
| 2008-07-31 | AAIC-DELISTED | Stock | 35.6 | 37.0 | 34.6 | 34.6 | 330569.0 |
| 2008-07-31 | AAME | Stock | 1.5 | 1.5 | 1.5 | 1.5 | 600.0 |
| 2008-07-31 | AAON | Stock | 3.7057 | 3.84 | 3.7057 | 3.7551 | 653569.0 |
| 2008-07-31 | AAP | Stock | 41.59 | 41.94 | 40.78 | 41.09 | 1062800.0 |
| 2008-07-31 | AATI-DELISTED | Stock | 4.16 | 4.24 | 3.95 | 4.13 | 624389.0 |
| 2008-07-31 | AAU-DELISTED | Stock | 1.82 | 1.94 | 1.81 | 1.93 | 19442.0 |
| 2008-07-31 | AAUAF-DELISTED | Stock | 1.82 | 1.94 | 1.81 | 1.93 | 19742.0 |
| 2008-07-31 | AAV-DELISTED | Stock | 11.29 | 11.29 | 10.67 | 10.78 | 579337.0 |
| 2008-07-31 | AAWW-DELISTED | Stock | 46.55 | 48.59 | 45.86 | 48.1 | 197334.0 |
| 2008-07-31 | AAXN-DELISTED | Stock | 5.02 | 5.13 | 5.01 | 5.03 | 826362.0 |
| 2008-07-31 | AB | Stock | 52.0 | 52.92 | 50.62 | 51.95 | 326700.0 |
| 2008-07-31 | ABAX-DELISTED | Stock | 19.18 | 19.98 | 18.91 | 19.89 | 281956.0 |
| 2008-07-31 | ABB-DELISTED | Stock | 26.6 | 26.75 | 26.19 | 26.24 | 5085070.0 |
| 2008-07-31 | ABBC-DELISTED | Stock | 9.11 | 10.07 | 9.11 | 9.99 | 106218.0 |
| 2008-07-31 | ABBNY-DELISTED | Stock | 26.6 | 26.75 | 26.19 | 26.22 | 5087759.0 |
| 2008-07-31 | ABC-DELISTED | Stock | 20.76 | 21.36 | 20.76 | 20.9 | 3704846.0 |
| 2008-07-31 | ABCB | Stock | 11.0784 | 11.1076 | 10.4365 | 10.4365 | 53874.0 |
| 2008-07-31 | ABCO-DELISTED | Stock | 18.765 | 19.26 | 18.765 | 19.165 | 211098.0 |
| 2008-07-31 | ABCW-DELISTED | Stock | 7.17 | 7.5 | 7.03 | 7.2 | 186960.0 |
| 2008-07-31 | ABD-DELISTED | Stock | 8.655 | 8.865 | 8.565 | 8.565 | 289450.0 |
| 2008-07-31 | ABE-DELISTED | Stock | 20.15 | 20.4 | 20.15 | 20.31 | 36450.0 |
| 2008-07-31 | ABEO | Stock | 3250.0 | 3750.0 | 3125.0 | 3750.0 | 11.0 |
| 2008-07-31 | ABFS-DELISTED | Stock | 35.98 | 38.0 | 35.98 | 37.14 | 431686.0 |
| 2008-07-31 | ABG | Stock | 10.15 | 10.32 | 9.7 | 9.91 | 568700.0 |
| 2008-07-31 | ABII-DELISTED | Stock | 73.13 | 75.6999 | 73.13 | 75.3 | 24370.0 |
| 2008-07-31 | ABK-DELISTED | Stock | 2.19 | 2.6 | 2.1 | 2.48 | 18804928.0 |
| 2008-07-31 | ABM | Stock | 23.82 | 24.38 | 23.75 | 23.93 | 199800.0 |
| 2008-07-31 | ABMD-DELISTED | Stock | 17.49 | 18.0 | 17.18 | 17.73 | 518113.0 |
| 2008-07-31 | ABR | Stock | 11.06 | 11.39 | 10.78 | 10.96 | 209700.0 |
| 2008-07-31 | ABT | Stock | 27.1519 | 27.6701 | 26.9264 | 27.0319 | 16797416.0 |
| 2008-07-31 | ABTL-DELISTED | Stock | 5.65 | 5.95 | 5.5 | 5.95 | 6711.0 |
| 2008-07-31 | ABV-DELISTED | Stock | 57.82 | 59.78 | 57.82 | 59.18 | 529143.0 |
| 2008-07-31 | ABVA-DELISTED | Stock | 2.62 | 2.62 | 2.46 | 2.46 | 62004.0 |
| 2008-07-31 | ABVT-DELISTED | Stock | 60.5 | 62.25 | 60.5 | 62.25 | 7000.0 |
| 2008-07-31 | ABX-DELISTED | Stock | 43.69 | 43.92 | 41.98 | 42.35 | 8815463.0 |
| 2008-07-31 | ACAD | Stock | 3.09 | 3.2 | 2.82 | 2.98 | 469400.0 |
| 2008-07-31 | ACAP-DELISTED | Stock | 48.11 | 50.49 | 47.33 | 49.77 | 100494.0 |
| 2008-07-31 | ACAS-DELISTED | Stock | 20.45 | 20.82 | 20.04 | 20.32 | 3389175.0 |
| 2008-07-31 | ACAT-DELISTED | Stock | 8.75 | 9.11 | 8.75 | 8.89 | 167394.0 |
> showing 50 of 5,761 rows — these rows as CSV