PREVIEW / stock_daily / 2007-05-11
file: by_date/stock_daily/2007/2007-05-11.parquet size: 168 KB rows: 5,095 symbols: 3,129
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-11 | AAPL | Stock | 3.8479 | 3.8975 | 3.8136 | 3.8836 | 653696400.0 |
| 2007-05-11 | MSFT | Stock | 30.57 | 30.98 | 30.55 | 30.89 | 43425300.0 |
| 2007-05-11 | NVDA | Stock | 0.5765 | 0.5913 | 0.5677 | 0.5857 | 1530630000.0 |
| 2007-05-11 | AMZN | Stock | 3.048 | 3.08 | 3.028 | 3.078 | 158382000.0 |
| 2007-05-11 | TLT | Stock | 88.64 | 88.7 | 88.1325 | 88.19 | 1238400.0 |
| 2007-05-11 | CL | Stock | 33.655 | 33.71 | 33.325 | 33.48 | 3814200.0 |
| 2007-05-11 | A | Stock | 25.6938 | 25.98 | 25.3791 | 25.9013 | 5716142.0 |
| 2007-05-11 | AABA-DELISTED | Stock | 29.62 | 30.08 | 29.53 | 30.06 | 12202707.0 |
| 2007-05-11 | AACC-DELISTED | Stock | 18.95 | 18.97 | 18.86 | 18.91 | 106386.0 |
| 2007-05-11 | AAI-DELISTED | Stock | 11.6 | 11.75 | 11.53 | 11.63 | 1020300.0 |
| 2007-05-11 | AAIC-DELISTED | Stock | 113.0 | 116.0 | 113.0 | 115.8 | 988300.0 |
| 2007-05-11 | AAME | Stock | 5.0 | 5.2 | 5.0 | 5.2 | 5800.0 |
| 2007-05-11 | AAON | Stock | 3.8163 | 3.9032 | 3.7939 | 3.8927 | 674325.0 |
| 2007-05-11 | AAP | Stock | 41.55 | 41.56 | 40.87 | 41.48 | 565500.0 |
| 2007-05-11 | AATI-DELISTED | Stock | 7.6 | 7.7094 | 7.53 | 7.6 | 304165.0 |
| 2007-05-11 | AAU-DELISTED | Stock | 2.32 | 2.37 | 2.25 | 2.28 | 186700.0 |
| 2007-05-11 | AAUAF-DELISTED | Stock | 2.32 | 2.37 | 2.25 | 2.28 | 186700.0 |
| 2007-05-11 | AAV-DELISTED | Stock | 11.6 | 11.7 | 11.53 | 11.56 | 390900.0 |
| 2007-05-11 | AAWW-DELISTED | Stock | 59.48 | 59.55 | 58.85 | 59.15 | 50920.0 |
| 2007-05-11 | AAXN-DELISTED | Stock | 9.48 | 9.51 | 9.3 | 9.41 | 1023574.0 |
| 2007-05-11 | AB | Stock | 88.45 | 89.82 | 88.41 | 89.56 | 211500.0 |
| 2007-05-11 | ABAX-DELISTED | Stock | 21.58 | 22.0 | 21.323 | 21.9 | 168750.0 |
| 2007-05-11 | ABB-DELISTED | Stock | 19.58 | 19.89 | 19.57 | 19.89 | 1031400.0 |
| 2007-05-11 | ABBC-DELISTED | Stock | 18.49 | 18.95 | 18.49 | 18.624 | 13740.0 |
| 2007-05-11 | ABBNY-DELISTED | Stock | 19.58 | 19.89 | 19.57 | 19.89 | 1041900.0 |
| 2007-05-11 | ABC-DELISTED | Stock | 25.29 | 25.38 | 24.86 | 25.0 | 5856600.0 |
| 2007-05-11 | ABCB | Stock | 21.6899 | 22.5362 | 21.4954 | 22.1859 | 55827.0 |
| 2007-05-11 | ABCO-DELISTED | Stock | 24.66 | 24.9 | 24.39 | 24.76 | 192604.0 |
| 2007-05-11 | ABCW-DELISTED | Stock | 28.56 | 28.85 | 28.56 | 28.74 | 36110.0 |
| 2007-05-11 | ABD-DELISTED | Stock | 22.41 | 22.66 | 22.38 | 22.65 | 317900.0 |
| 2007-05-11 | ABE-DELISTED | Stock | 20.2 | 20.85 | 20.1 | 20.75 | 32800.0 |
| 2007-05-11 | ABFS-DELISTED | Stock | 38.34 | 38.86 | 38.1 | 38.57 | 277593.0 |
| 2007-05-11 | ABG | Stock | 27.08 | 27.08 | 26.85 | 26.9 | 295000.0 |
| 2007-05-11 | ABK-DELISTED | Stock | 94.53 | 94.92 | 93.97 | 94.62 | 579700.0 |
| 2007-05-11 | ABM | Stock | 28.41 | 28.75 | 28.41 | 28.67 | 191900.0 |
| 2007-05-11 | ABMD-DELISTED | Stock | 12.41 | 12.42 | 12.2 | 12.25 | 91471.0 |
| 2007-05-11 | ABP-DELISTED | Stock | 3.88 | 4.0 | 3.75 | 3.97 | 199900.0 |
| 2007-05-11 | ABR | Stock | 29.73 | 30.0 | 29.55 | 29.91 | 133200.0 |
| 2007-05-11 | ABT | Stock | 27.5165 | 27.7612 | 27.387 | 27.7516 | 8658191.0 |
| 2007-05-11 | ABTL-DELISTED | Stock | 18.825 | 19.674 | 18.376 | 19.275 | 108607.0 |
| 2007-05-11 | ABV-DELISTED | Stock | 61.6 | 61.65 | 60.09 | 60.81 | 586740.0 |
| 2007-05-11 | ABVA-DELISTED | Stock | 12.86 | 13.08 | 12.86 | 13.08 | 18000.0 |
| 2007-05-11 | ABVT-DELISTED | Stock | 63.0 | 63.0 | 63.0 | 63.0 | 2305.0 |
| 2007-05-11 | ABX-DELISTED | Stock | 30.14 | 30.35 | 30.05 | 30.08 | 3508322.0 |
| 2007-05-11 | ACAD | Stock | 14.09 | 14.33 | 13.43 | 13.61 | 458000.0 |
| 2007-05-11 | ACAP-DELISTED | Stock | 38.71 | 39.76 | 38.71 | 39.69 | 73511.0 |
| 2007-05-11 | ACAS-DELISTED | Stock | 46.2 | 46.57 | 46.02 | 46.24 | 1069550.0 |
| 2007-05-11 | ACAT-DELISTED | Stock | 18.45 | 18.45 | 17.989 | 18.33 | 74573.0 |
| 2007-05-11 | ACC-DELISTED | Stock | 28.92 | 29.25 | 28.92 | 29.18 | 87800.0 |
| 2007-05-11 | ACCL-DELISTED | Stock | 6.31 | 6.34 | 6.25 | 6.29 | 36247.0 |
> showing 50 of 5,095 rows — these rows as CSV