PREVIEW / stock_daily / 2006-10-06
file: by_date/stock_daily/2006/2006-10-06.parquet size: 151 KB rows: 4,518 symbols: 2,849
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-06 | AAPL | Stock | 2.6579 | 2.68 | 2.6361 | 2.6507 | 466958800.0 |
| 2006-10-06 | MSFT | Stock | 27.76 | 28.0 | 27.65 | 27.87 | 36452200.0 |
| 2006-10-06 | NVDA | Stock | 0.5042 | 0.5208 | 0.5027 | 0.5155 | 593610000.0 |
| 2006-10-06 | AMZN | Stock | 1.6575 | 1.661 | 1.625 | 1.6295 | 84384000.0 |
| 2006-10-06 | CL | Stock | 31.35 | 31.5 | 31.205 | 31.325 | 2935400.0 |
| 2006-10-06 | A | Stock | 23.3548 | 23.8913 | 23.1903 | 23.8126 | 2933983.0 |
| 2006-10-06 | AABA-DELISTED | Stock | 25.0900001525879 | 25.5 | 25.0100002288818 | 25.4699993133545 | 20847000.0 |
| 2006-10-06 | AACC-DELISTED | Stock | 16.81 | 17.04 | 16.8 | 16.97 | 53107.0 |
| 2006-10-06 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.35 | 5.35 | 20000.0 |
| 2006-10-06 | AACQW-DELISTED | Stock | 0.38 | 0.4 | 0.38 | 0.4 | 15000.0 |
| 2006-10-06 | AAI-DELISTED | Stock | 10.35 | 10.44 | 10.21 | 10.24 | 1264900.0 |
| 2006-10-06 | AAIC-DELISTED | Stock | 164.0 | 168.2 | 162.0 | 167.4 | 856000.0 |
| 2006-10-06 | AAME | Stock | 2.44 | 2.45 | 2.44 | 2.45 | 1700.0 |
| 2006-10-06 | AAON | Stock | 3.2435 | 3.2435 | 3.1526 | 3.1565 | 301472.0 |
| 2006-10-06 | AAP | Stock | 35.17 | 35.18 | 34.43 | 34.56 | 749200.0 |
| 2006-10-06 | AATI-DELISTED | Stock | 4.96 | 5.18 | 4.95 | 5.08 | 391889.0 |
| 2006-10-06 | AAU-DELISTED | Stock | 2.4 | 2.59 | 2.4 | 2.53 | 55400.0 |
| 2006-10-06 | AAUAF-DELISTED | Stock | 2.4 | 2.59 | 2.4 | 2.53 | 55400.0 |
| 2006-10-06 | AAV-DELISTED | Stock | 11.42 | 11.48 | 11.05 | 11.28 | 1352800.0 |
| 2006-10-06 | AAWW-DELISTED | Stock | 44.9 | 45.57 | 44.9 | 45.39 | 131298.0 |
| 2006-10-06 | AAXN-DELISTED | Stock | 8.72999954223633 | 8.85000038146973 | 8.55000019073486 | 8.76000022888184 | 1991300.0 |
| 2006-10-06 | AB | Stock | 70.32 | 70.32 | 69.65 | 69.65 | 111100.0 |
| 2006-10-06 | ABAX-DELISTED | Stock | 25.37 | 25.37 | 22.25 | 22.65 | 1073477.0 |
| 2006-10-06 | ABB-DELISTED | Stock | 13.54 | 13.69 | 13.45 | 13.65 | 1764900.0 |
| 2006-10-06 | ABBC-DELISTED | Stock | 14.93 | 15.05 | 14.93 | 15.02 | 5960.0 |
| 2006-10-06 | ABC-DELISTED | Stock | 23.26 | 23.28 | 22.49 | 23.0 | 4816600.0 |
| 2006-10-06 | ABCB | Stock | 27.5841 | 27.7008 | 27.1172 | 27.409 | 13057.0 |
| 2006-10-06 | ABCO-DELISTED | Stock | 26.72 | 27.02 | 26.44 | 26.83 | 205281.0 |
| 2006-10-06 | ABCW-DELISTED | Stock | 28.69 | 28.92 | 28.49 | 28.82 | 24130.0 |
| 2006-10-06 | ABD-DELISTED | Stock | 22.51 | 22.85 | 22.5 | 22.73 | 96800.0 |
| 2006-10-06 | ABE-DELISTED | Stock | 14.65 | 14.65 | 14.37 | 14.6 | 19800.0 |
| 2006-10-06 | ABFS-DELISTED | Stock | 46.78 | 46.94 | 45.86 | 46.53 | 228207.0 |
| 2006-10-06 | ABG | Stock | 21.52 | 21.63 | 21.13 | 21.58 | 293200.0 |
| 2006-10-06 | ABK-DELISTED | Stock | 84.75 | 85.0 | 84.22 | 84.65 | 331400.0 |
| 2006-10-06 | ABM | Stock | 19.04 | 19.15 | 18.92 | 19.07 | 189100.0 |
| 2006-10-06 | ABMD-DELISTED | Stock | 14.98 | 15.07 | 14.61 | 14.73 | 47848.0 |
| 2006-10-06 | ABP-DELISTED | Stock | 3.29 | 3.48 | 3.28 | 3.35 | 201400.0 |
| 2006-10-06 | ABR | Stock | 26.04 | 26.17 | 25.73 | 26.0 | 51500.0 |
| 2006-10-06 | ABT | Stock | 22.2147 | 22.3107 | 22.1044 | 22.162 | 15576699.0 |
| 2006-10-06 | ABTL-DELISTED | Stock | 14.775 | 15.426 | 14.524 | 15.375 | 17291.0 |
| 2006-10-06 | ABV-DELISTED | Stock | 45.5 | 46.09 | 45.37 | 45.98 | 183000.0 |
| 2006-10-06 | ABVA-DELISTED | Stock | 16.8999 | 16.8999 | 16.8999 | 16.8999 | 1000.0 |
| 2006-10-06 | ABX-DELISTED | Stock | 29.09 | 29.75 | 28.84 | 29.14 | 3480514.0 |
| 2006-10-06 | ACAD | Stock | 8.91 | 9.0 | 8.81 | 8.85 | 88700.0 |
| 2006-10-06 | ACAP-DELISTED | Stock | 51.05 | 51.72 | 51.05 | 51.49 | 19311.0 |
| 2006-10-06 | ACAS-DELISTED | Stock | 41.0 | 41.63 | 40.64 | 41.4 | 1270498.0 |
| 2006-10-06 | ACAT-DELISTED | Stock | 17.02 | 17.67 | 17.02 | 17.61 | 104818.0 |
| 2006-10-06 | ACC-DELISTED | Stock | 25.85 | 25.87 | 25.57 | 25.8 | 98500.0 |
| 2006-10-06 | ACCL-DELISTED | Stock | 6.13 | 6.32 | 6.13 | 6.25 | 14631.0 |
| 2006-10-06 | ACCO | Stock | 22.5 | 22.86 | 22.5 | 22.74 | 107300.0 |
> showing 50 of 4,518 rows — these rows as CSV