PREVIEW / stock_daily / 2006-01-10
file: by_date/stock_daily/2006/2006-01-10.parquet size: 145 KB rows: 4,324 symbols: 2,733
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-01-10 | AAPL | Stock | 2.7232 | 2.9246 | 2.7082 | 2.8879 | 2279869200.0 |
| 2006-01-10 | MSFT | Stock | 26.65 | 27.02 | 26.59 | 27.0 | 64921900.0 |
| 2006-01-10 | NVDA | Stock | 0.3482 | 0.3499 | 0.3437 | 0.3499 | 339660000.0 |
| 2006-01-10 | AMZN | Stock | 2.3205 | 2.3375 | 2.268 | 2.2825 | 193722000.0 |
| 2006-01-10 | CL | Stock | 27.58 | 27.655 | 27.405 | 27.455 | 4161800.0 |
| 2006-01-10 | A | Stock | 24.4993 | 25.0358 | 24.392 | 25.0358 | 3010873.0 |
| 2006-01-10 | AABA-DELISTED | Stock | 42.9599990844727 | 43.3400001525879 | 42.3400001525879 | 42.9799995422363 | 16287200.0 |
| 2006-01-10 | AACC-DELISTED | Stock | 23.05 | 23.56 | 22.98 | 23.45 | 103738.0 |
| 2006-01-10 | AACQU-DELISTED | Stock | 6.18 | 6.18 | 6.18 | 6.18 | 500.0 |
| 2006-01-10 | AAI-DELISTED | Stock | 16.4 | 16.48 | 16.08 | 16.35 | 945800.0 |
| 2006-01-10 | AAIC-DELISTED | Stock | 214.6 | 215.8 | 211.2 | 215.6 | 1180700.0 |
| 2006-01-10 | AAME | Stock | 2.67 | 2.67 | 2.66 | 2.66 | 1300.0 |
| 2006-01-10 | AAON | Stock | 2.398 | 2.4362 | 2.3888 | 2.4362 | 69103.0 |
| 2006-01-10 | AAP | Stock | 44.51 | 44.79 | 44.37 | 44.61 | 394800.0 |
| 2006-01-10 | AATI-DELISTED | Stock | 13.41 | 13.82 | 13.21 | 13.7 | 57570.0 |
| 2006-01-10 | AAU-DELISTED | Stock | 2.65 | 2.7 | 2.5 | 2.61 | 144500.0 |
| 2006-01-10 | AAUAF-DELISTED | Stock | 2.65 | 2.7 | 2.5 | 2.61 | 144500.0 |
| 2006-01-10 | AAV-DELISTED | Stock | 18.3 | 18.5 | 18.05 | 18.5 | 254100.0 |
| 2006-01-10 | AAWW-DELISTED | Stock | 43.45 | 44.0 | 43.45 | 43.75 | 830400.0 |
| 2006-01-10 | AAXN-DELISTED | Stock | 8.25 | 8.94999980926514 | 8.0 | 8.78999996185303 | 5898300.0 |
| 2006-01-10 | ABAX-DELISTED | Stock | 17.54 | 17.89 | 17.43 | 17.79 | 107793.0 |
| 2006-01-10 | ABB-DELISTED | Stock | 10.73 | 10.92 | 10.71 | 10.86 | 1277000.0 |
| 2006-01-10 | ABBC-DELISTED | Stock | 13.32 | 13.48 | 13.3101 | 13.48 | 1863.0 |
| 2006-01-10 | ABC-DELISTED | Stock | 20.48 | 20.72 | 20.42 | 20.53 | 3349200.0 |
| 2006-01-10 | ABCB | Stock | 19.6571 | 20.2601 | 19.6571 | 20.2601 | 23133.0 |
| 2006-01-10 | ABCO-DELISTED | Stock | 23.34 | 24.08 | 23.34 | 23.91 | 163000.0 |
| 2006-01-10 | ABCW-DELISTED | Stock | 31.2 | 31.73 | 31.2 | 31.63 | 37020.0 |
| 2006-01-10 | ABD-DELISTED | Stock | 24.52 | 24.94 | 24.52 | 24.8 | 174500.0 |
| 2006-01-10 | ABE-DELISTED | Stock | 12.87 | 12.87 | 12.4 | 12.58 | 27200.0 |
| 2006-01-10 | ABFS-DELISTED | Stock | 45.22 | 45.4 | 44.64 | 44.75 | 459549.0 |
| 2006-01-10 | ABG | Stock | 16.48 | 16.9 | 16.25 | 16.83 | 33800.0 |
| 2006-01-10 | ABK-DELISTED | Stock | 79.1 | 79.14 | 77.98 | 78.85 | 536900.0 |
| 2006-01-10 | ABM | Stock | 20.05 | 20.49 | 19.92 | 20.33 | 109100.0 |
| 2006-01-10 | ABMD-DELISTED | Stock | 10.0 | 10.21 | 9.95 | 10.19 | 51702.0 |
| 2006-01-10 | ABP-DELISTED | Stock | 5.54 | 5.81 | 5.47 | 5.69 | 553100.0 |
| 2006-01-10 | ABR | Stock | 26.87 | 27.54 | 26.8 | 27.45 | 52500.0 |
| 2006-01-10 | ABT | Stock | 20.3435 | 20.4203 | 20.0796 | 20.1516 | 12033764.0 |
| 2006-01-10 | ABTL-DELISTED | Stock | 25.3 | 25.5 | 24.95 | 25.5 | 14881.0 |
| 2006-01-10 | ABV-DELISTED | Stock | 40.67 | 41.15 | 40.33 | 40.95 | 220100.0 |
| 2006-01-10 | ABVA-DELISTED | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 400.0 |
| 2006-01-10 | ABX-DELISTED | Stock | 29.35 | 29.79 | 29.32 | 29.57 | 6222300.0 |
| 2006-01-10 | ACAD | Stock | 10.7 | 10.99 | 10.49 | 10.99 | 19400.0 |
| 2006-01-10 | ACAP-DELISTED | Stock | 48.08 | 48.64 | 47.75 | 48.25 | 35582.0 |
| 2006-01-10 | ACAS-DELISTED | Stock | 36.0 | 36.06 | 35.75 | 35.96 | 878811.0 |
| 2006-01-10 | ACAT-DELISTED | Stock | 22.43 | 22.83 | 22.39 | 22.69 | 46206.0 |
| 2006-01-10 | ACC-DELISTED | Stock | 25.17 | 25.6 | 25.17 | 25.45 | 29400.0 |
| 2006-01-10 | ACCL-DELISTED | Stock | 7.7 | 7.85 | 7.7 | 7.75 | 136104.0 |
| 2006-01-10 | ACCO | Stock | 24.52 | 24.94 | 24.52 | 24.8 | 176600.0 |
| 2006-01-10 | ACE-DELISTED | Stock | 55.86 | 56.1 | 55.59 | 56.03 | 715125.0 |
| 2006-01-10 | ACF-DELISTED | Stock | 26.67 | 27.32 | 26.6 | 27.26 | 1499800.0 |
> showing 50 of 4,324 rows — these rows as CSV