PREVIEW / stock_daily / 2005-09-08
file: by_date/stock_daily/2005/2005-09-08.parquet size: 139 KB rows: 4,165 symbols: 2,619
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-08 | AAPL | Stock | 1.7625 | 1.79 | 1.755 | 1.7779 | 702640400.0 |
| 2005-09-08 | MSFT | Stock | 26.8 | 26.88 | 26.52 | 26.61 | 52552300.0 |
| 2005-09-08 | NVDA | Stock | 0.2602 | 0.2681 | 0.2602 | 0.2648 | 646116000.0 |
| 2005-09-08 | AMZN | Stock | 2.1725 | 2.1745 | 2.1415 | 2.148 | 77684000.0 |
| 2005-09-08 | CL | Stock | 26.6 | 26.885 | 26.57 | 26.7 | 4409000.0 |
| 2005-09-08 | A | Stock | 23.2046 | 23.2833 | 22.8541 | 23.0329 | 5094452.0 |
| 2005-09-08 | AABA-DELISTED | Stock | 33.7400016784668 | 33.9300003051758 | 33.2000007629395 | 33.3400001525879 | 17464400.0 |
| 2005-09-08 | AACC-DELISTED | Stock | 29.83 | 30.22 | 29.5 | 29.68 | 90667.0 |
| 2005-09-08 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 9000.0 |
| 2005-09-08 | AACQU-DELISTED | Stock | 6.21 | 6.21 | 6.21 | 6.21 | 4500.0 |
| 2005-09-08 | AACQW-DELISTED | Stock | 0.56 | 0.62 | 0.56 | 0.6 | 134500.0 |
| 2005-09-08 | AAI-DELISTED | Stock | 10.35 | 10.47 | 10.2 | 10.26 | 409500.0 |
| 2005-09-08 | AAIC-DELISTED | Stock | 235.2 | 238.4 | 233.0 | 234.4 | 1150600.0 |
| 2005-09-08 | AAME | Stock | 2.79 | 2.92 | 2.68 | 2.71 | 17800.0 |
| 2005-09-08 | AAON | Stock | 2.3282 | 2.3664 | 2.3216 | 2.348 | 82012.0 |
| 2005-09-08 | AAP | Stock | 40.72 | 40.72 | 39.7333 | 40.16 | 1426650.0 |
| 2005-09-08 | AATI-DELISTED | Stock | 13.21 | 13.21 | 12.75 | 13.0 | 167317.0 |
| 2005-09-08 | AAV-DELISTED | Stock | 17.0 | 17.08 | 16.87 | 17.0 | 19000.0 |
| 2005-09-08 | AAXN-DELISTED | Stock | 8.36999988555908 | 8.40999984741211 | 8.26000022888184 | 8.30000019073486 | 1077700.0 |
| 2005-09-08 | ABAX-DELISTED | Stock | 12.21 | 12.36 | 11.99 | 12.35 | 78998.0 |
| 2005-09-08 | ABB-DELISTED | Stock | 7.5 | 7.53 | 7.46 | 7.49 | 536500.0 |
| 2005-09-08 | ABBC-DELISTED | Stock | 12.95 | 12.95 | 12.8 | 12.8 | 55734.0 |
| 2005-09-08 | ABC-DELISTED | Stock | 18.75 | 18.82 | 18.58 | 18.64 | 3114800.0 |
| 2005-09-08 | ABCB | Stock | 19.3944 | 19.3944 | 18.8693 | 19.1708 | 13777.0 |
| 2005-09-08 | ABCO-DELISTED | Stock | 26.31 | 26.5 | 25.77 | 26.11 | 95313.0 |
| 2005-09-08 | ABCW-DELISTED | Stock | 30.91 | 31.22 | 30.68 | 30.93 | 20500.0 |
| 2005-09-08 | ABD-DELISTED | Stock | 25.42 | 25.65 | 25.14 | 25.4 | 600400.0 |
| 2005-09-08 | ABE-DELISTED | Stock | 10.79 | 10.85 | 10.71 | 10.71 | 6300.0 |
| 2005-09-08 | ABFS-DELISTED | Stock | 34.78 | 34.87 | 34.3 | 34.61 | 251955.0 |
| 2005-09-08 | ABG | Stock | 16.79 | 16.94 | 16.71 | 16.91 | 54100.0 |
| 2005-09-08 | ABK-DELISTED | Stock | 67.09 | 67.15 | 66.12 | 66.24 | 756300.0 |
| 2005-09-08 | ABM | Stock | 20.9 | 20.97 | 19.82 | 19.95 | 221600.0 |
| 2005-09-08 | ABMD-DELISTED | Stock | 10.33 | 10.45 | 10.18 | 10.3 | 51217.0 |
| 2005-09-08 | ABP-DELISTED | Stock | 4.34 | 4.45 | 4.28 | 4.4 | 143800.0 |
| 2005-09-08 | ABR | Stock | 28.61 | 29.1 | 28.6 | 28.85 | 192900.0 |
| 2005-09-08 | ABT | Stock | 21.9748 | 21.9748 | 21.6678 | 21.7781 | 5040017.0 |
| 2005-09-08 | ABTL-DELISTED | Stock | 25.18 | 25.52 | 25.08 | 25.37 | 29526.0 |
| 2005-09-08 | ABV-DELISTED | Stock | 34.74 | 35.55 | 34.73 | 35.23 | 710500.0 |
| 2005-09-08 | ABVA-DELISTED | Stock | 16.3 | 16.3 | 16.2 | 16.2 | 8600.0 |
| 2005-09-08 | ABVT-DELISTED | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 3000.0 |
| 2005-09-08 | ABX-DELISTED | Stock | 27.46 | 27.87 | 27.46 | 27.67 | 2742100.0 |
| 2005-09-08 | ACAD | Stock | 10.5 | 11.29 | 10.4 | 11.0 | 97300.0 |
| 2005-09-08 | ACAP-DELISTED | Stock | 44.85 | 45.1 | 44.61 | 45.1 | 25467.0 |
| 2005-09-08 | ACAS-DELISTED | Stock | 37.65 | 37.74 | 37.4 | 37.65 | 531057.0 |
| 2005-09-08 | ACAT-DELISTED | Stock | 21.25 | 21.25 | 20.7 | 20.85 | 82866.0 |
| 2005-09-08 | ACC-DELISTED | Stock | 23.49 | 23.5 | 23.05 | 23.36 | 65600.0 |
| 2005-09-08 | ACCL-DELISTED | Stock | 5.37 | 5.55 | 5.35 | 5.54 | 66468.0 |
| 2005-09-08 | ACCO | Stock | 25.42 | 25.65 | 25.14 | 25.4 | 606200.0 |
| 2005-09-08 | ACE-DELISTED | Stock | 44.89 | 44.89 | 43.83 | 43.83 | 1544407.0 |
| 2005-09-08 | ACF-DELISTED | Stock | 25.17 | 25.3 | 24.89 | 24.97 | 842900.0 |
> showing 50 of 4,165 rows — these rows as CSV