PREVIEW / stock_daily / 2005-09-06
file: by_date/stock_daily/2005/2005-09-06.parquet size: 141 KB rows: 4,192 symbols: 2,636
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-06 | AAPL | Stock | 1.6679 | 1.7457 | 1.6625 | 1.7429 | 818619200.0 |
| 2005-09-06 | MSFT | Stock | 27.06 | 27.29 | 26.98 | 27.0 | 46089000.0 |
| 2005-09-06 | NVDA | Stock | 0.2525 | 0.255 | 0.2487 | 0.2537 | 423096000.0 |
| 2005-09-06 | AMZN | Stock | 2.0775 | 2.1825 | 2.0755 | 2.181 | 158796000.0 |
| 2005-09-06 | CL | Stock | 26.59 | 26.82 | 26.5 | 26.755 | 4504400.0 |
| 2005-09-06 | A | Stock | 22.8183 | 23.2618 | 22.8183 | 23.2332 | 3795011.0 |
| 2005-09-06 | AABA-DELISTED | Stock | 33.1800003051758 | 33.7799987792969 | 33.1800003051758 | 33.6800003051758 | 12513300.0 |
| 2005-09-06 | AACC-DELISTED | Stock | 28.55 | 30.31 | 28.44 | 29.76 | 367014.0 |
| 2005-09-06 | AACQ-DELISTED | Stock | 5.09 | 5.13 | 5.09 | 5.09 | 10500.0 |
| 2005-09-06 | AACQU-DELISTED | Stock | 6.15 | 6.3 | 6.1 | 6.17 | 10000.0 |
| 2005-09-06 | AACQW-DELISTED | Stock | 0.54 | 0.57 | 0.53 | 0.55 | 64894.0 |
| 2005-09-06 | AAI-DELISTED | Stock | 9.95 | 10.46 | 9.95 | 10.37 | 1417400.0 |
| 2005-09-06 | AAIC-DELISTED | Stock | 237.0 | 241.8 | 236.0 | 241.2 | 1644300.0 |
| 2005-09-06 | AAME | Stock | 2.8 | 2.94 | 2.8 | 2.85 | 5600.0 |
| 2005-09-06 | AAON | Stock | 2.3506 | 2.3862 | 2.344 | 2.3704 | 180731.0 |
| 2005-09-06 | AAP | Stock | 38.9667 | 39.4733 | 38.9667 | 39.26 | 1257150.0 |
| 2005-09-06 | AATI-DELISTED | Stock | 12.92 | 13.21 | 12.92 | 13.2 | 62047.0 |
| 2005-09-06 | AAV-DELISTED | Stock | 16.63 | 16.83 | 16.49 | 16.63 | 54100.0 |
| 2005-09-06 | AAXN-DELISTED | Stock | 8.35999965667725 | 8.47000026702881 | 8.34000015258789 | 8.36999988555908 | 1085400.0 |
| 2005-09-06 | ABAX-DELISTED | Stock | 11.69 | 12.17 | 11.67 | 12.13 | 71826.0 |
| 2005-09-06 | ABB-DELISTED | Stock | 7.72 | 7.73 | 7.67 | 7.71 | 1338700.0 |
| 2005-09-06 | ABBC-DELISTED | Stock | 12.6 | 12.84 | 12.6 | 12.6 | 2750.0 |
| 2005-09-06 | ABC-DELISTED | Stock | 18.51 | 18.7 | 18.38 | 18.52 | 2833200.0 |
| 2005-09-06 | ABCB | Stock | 18.2371 | 19.2 | 18.2371 | 19.1514 | 22824.0 |
| 2005-09-06 | ABCO-DELISTED | Stock | 25.95 | 26.5 | 25.85 | 26.23 | 181018.0 |
| 2005-09-06 | ABCW-DELISTED | Stock | 30.63 | 31.3 | 30.63 | 31.27 | 59860.0 |
| 2005-09-06 | ABD-DELISTED | Stock | 26.3 | 26.79 | 25.4 | 25.75 | 474910.0 |
| 2005-09-06 | ABE-DELISTED | Stock | 10.73 | 10.79 | 10.7 | 10.73 | 16000.0 |
| 2005-09-06 | ABFS-DELISTED | Stock | 34.25 | 35.1 | 34.25 | 34.85 | 222597.0 |
| 2005-09-06 | ABG | Stock | 16.66 | 16.77 | 16.54 | 16.68 | 55000.0 |
| 2005-09-06 | ABK-DELISTED | Stock | 67.07 | 67.64 | 66.71 | 67.29 | 671300.0 |
| 2005-09-06 | ABM | Stock | 19.73 | 20.18 | 19.73 | 20.18 | 136900.0 |
| 2005-09-06 | ABMD-DELISTED | Stock | 9.88 | 10.29 | 9.88 | 10.18 | 64383.0 |
| 2005-09-06 | ABP-DELISTED | Stock | 4.5 | 4.58 | 4.3 | 4.39 | 291800.0 |
| 2005-09-06 | ABR | Stock | 28.25 | 28.97 | 28.16 | 28.84 | 132200.0 |
| 2005-09-06 | ABT | Stock | 21.5334 | 21.7829 | 21.5334 | 21.7349 | 8454148.0 |
| 2005-09-06 | ABTL-DELISTED | Stock | 25.0 | 26.0 | 24.85 | 26.0 | 39468.0 |
| 2005-09-06 | ABV-DELISTED | Stock | 34.0 | 34.7 | 33.89 | 34.55 | 709200.0 |
| 2005-09-06 | ABVA-DELISTED | Stock | 16.25 | 16.25 | 16.0 | 16.2 | 28505.0 |
| 2005-09-06 | ABX-DELISTED | Stock | 27.49 | 27.57 | 27.13 | 27.2 | 1903800.0 |
| 2005-09-06 | ACAD | Stock | 10.2 | 10.25 | 9.9 | 10.13 | 54400.0 |
| 2005-09-06 | ACAP-DELISTED | Stock | 44.64 | 44.64 | 44.17 | 44.53 | 53014.0 |
| 2005-09-06 | ACAS-DELISTED | Stock | 37.97 | 38.04 | 37.24 | 37.82 | 688479.0 |
| 2005-09-06 | ACAT-DELISTED | Stock | 21.97 | 22.01 | 21.39 | 21.95 | 79831.0 |
| 2005-09-06 | ACC-DELISTED | Stock | 23.6 | 24.1 | 23.6 | 24.0 | 83200.0 |
| 2005-09-06 | ACCL-DELISTED | Stock | 5.65 | 5.65 | 5.43 | 5.57 | 55514.0 |
| 2005-09-06 | ACCO | Stock | 26.3 | 26.79 | 25.4 | 25.75 | 475300.0 |
| 2005-09-06 | ACE-DELISTED | Stock | 44.68 | 45.29 | 44.61 | 45.0 | 946300.0 |
| 2005-09-06 | ACF-DELISTED | Stock | 24.99 | 25.05 | 24.7 | 24.85 | 1179200.0 |
| 2005-09-06 | ACFC-DELISTED | Stock | 73.47 | 73.47 | 72.55 | 72.55 | 1326.0 |
> showing 50 of 4,192 rows — these rows as CSV