PREVIEW / stock_daily / 2006-09-14
file: by_date/stock_daily/2006/2006-09-14.parquet size: 150 KB rows: 4,499 symbols: 2,840
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-09-14 | AAPL | Stock | 2.6329 | 2.6668 | 2.6236 | 2.6489 | 801729600.0 |
| 2006-09-14 | MSFT | Stock | 25.99 | 26.5 | 25.98 | 26.33 | 74324500.0 |
| 2006-09-14 | NVDA | Stock | 0.4827 | 0.4917 | 0.4768 | 0.4832 | 428814000.0 |
| 2006-09-14 | AMZN | Stock | 1.577 | 1.5935 | 1.559 | 1.5825 | 74114000.0 |
| 2006-09-14 | CL | Stock | 30.4 | 30.93 | 30.29 | 30.89 | 4013800.0 |
| 2006-09-14 | A | Stock | 22.2461 | 22.3462 | 21.9957 | 22.1745 | 3120616.0 |
| 2006-09-14 | AABA-DELISTED | Stock | 29.1000003814697 | 29.2399997711182 | 28.8899993896484 | 29.0300006866455 | 9565500.0 |
| 2006-09-14 | AACC-DELISTED | Stock | 14.69 | 14.9 | 14.69 | 14.89 | 37298.0 |
| 2006-09-14 | AACQU-DELISTED | Stock | 6.08 | 6.08 | 6.08 | 6.08 | 1000.0 |
| 2006-09-14 | AACQW-DELISTED | Stock | 0.38 | 0.39 | 0.38 | 0.39 | 20000.0 |
| 2006-09-14 | AAI-DELISTED | Stock | 9.69 | 10.11 | 9.65 | 10.0 | 1720200.0 |
| 2006-09-14 | AAIC-DELISTED | Stock | 176.0 | 176.0 | 170.0 | 171.4 | 1403800.0 |
| 2006-09-14 | AAME | Stock | 2.7 | 2.77 | 2.7 | 2.75 | 700.0 |
| 2006-09-14 | AAON | Stock | 3.1368 | 3.1368 | 3.1118 | 3.1236 | 87328.0 |
| 2006-09-14 | AAP | Stock | 32.8 | 32.85 | 32.36 | 32.62 | 1110300.0 |
| 2006-09-14 | AATI-DELISTED | Stock | 8.34 | 8.63 | 8.34 | 8.52 | 248829.0 |
| 2006-09-14 | AAU-DELISTED | Stock | 2.37 | 2.4 | 2.29 | 2.32 | 53700.0 |
| 2006-09-14 | AAUAF-DELISTED | Stock | 2.37 | 2.4 | 2.29 | 2.32 | 53700.0 |
| 2006-09-14 | AAV-DELISTED | Stock | 14.58 | 14.73 | 14.04 | 14.16 | 489200.0 |
| 2006-09-14 | AAWW-DELISTED | Stock | 43.86 | 43.99 | 43.08 | 43.81 | 68457.0 |
| 2006-09-14 | AAXN-DELISTED | Stock | 7.6100001335144 | 7.67000007629395 | 7.51000022888184 | 7.6100001335144 | 534600.0 |
| 2006-09-14 | AB | Stock | 69.89 | 70.42 | 69.25 | 69.72 | 265800.0 |
| 2006-09-14 | ABAX-DELISTED | Stock | 22.88 | 22.93 | 22.49 | 22.78 | 51469.0 |
| 2006-09-14 | ABB-DELISTED | Stock | 13.36 | 13.37 | 13.22 | 13.27 | 2895900.0 |
| 2006-09-14 | ABBC-DELISTED | Stock | 15.35 | 15.35 | 15.2 | 15.25 | 9681.0 |
| 2006-09-14 | ABC-DELISTED | Stock | 23.07 | 23.07 | 22.67 | 22.74 | 1305400.0 |
| 2006-09-14 | ABCB | Stock | 25.6778 | 25.9403 | 25.454 | 25.7167 | 23133.0 |
| 2006-09-14 | ABCO-DELISTED | Stock | 25.46 | 25.65 | 24.87 | 25.31 | 114327.0 |
| 2006-09-14 | ABCW-DELISTED | Stock | 28.6 | 29.03 | 28.45 | 28.54 | 69300.0 |
| 2006-09-14 | ABD-DELISTED | Stock | 20.8 | 20.8 | 20.32 | 20.5 | 113600.0 |
| 2006-09-14 | ABE-DELISTED | Stock | 13.85 | 13.85 | 13.64 | 13.64 | 6100.0 |
| 2006-09-14 | ABFS-DELISTED | Stock | 46.56 | 46.71 | 45.51 | 45.83 | 286094.0 |
| 2006-09-14 | ABG | Stock | 20.81 | 20.81 | 20.34 | 20.46 | 145800.0 |
| 2006-09-14 | ABK-DELISTED | Stock | 85.07 | 85.4 | 84.59 | 84.9 | 544800.0 |
| 2006-09-14 | ABM | Stock | 18.75 | 18.75 | 18.44 | 18.57 | 128500.0 |
| 2006-09-14 | ABMD-DELISTED | Stock | 14.7 | 15.15 | 14.66 | 15.05 | 105959.0 |
| 2006-09-14 | ABP-DELISTED | Stock | 3.8 | 3.83 | 3.55 | 3.7 | 420600.0 |
| 2006-09-14 | ABR | Stock | 25.73 | 25.75 | 25.36 | 25.7 | 51300.0 |
| 2006-09-14 | ABT | Stock | 23.491 | 23.6637 | 23.3903 | 23.5822 | 8059608.0 |
| 2006-09-14 | ABTL-DELISTED | Stock | 15.9 | 16.4 | 15.6 | 16.35 | 46009.0 |
| 2006-09-14 | ABV-DELISTED | Stock | 44.85 | 45.06 | 44.63 | 44.93 | 253200.0 |
| 2006-09-14 | ABVA-DELISTED | Stock | 16.5 | 17.1 | 16.41 | 16.93 | 1307.0 |
| 2006-09-14 | ABVT-DELISTED | Stock | 48.0 | 48.0 | 48.0 | 48.0 | 400.0 |
| 2006-09-14 | ABX-DELISTED | Stock | 29.82 | 29.94 | 28.37 | 28.49 | 6031000.0 |
| 2006-09-14 | ACAD | Stock | 8.32 | 8.55 | 8.21 | 8.52 | 210900.0 |
| 2006-09-14 | ACAP-DELISTED | Stock | 47.92 | 48.56 | 47.43 | 48.56 | 36304.0 |
| 2006-09-14 | ACAS-DELISTED | Stock | 38.19 | 38.49 | 38.18 | 38.49 | 710324.0 |
| 2006-09-14 | ACAT-DELISTED | Stock | 16.56 | 16.56 | 16.3 | 16.48 | 64828.0 |
| 2006-09-14 | ACC-DELISTED | Stock | 25.15 | 25.38 | 25.08 | 25.26 | 328300.0 |
| 2006-09-14 | ACCL-DELISTED | Stock | 5.53 | 5.55 | 5.48 | 5.54 | 50433.0 |
> showing 50 of 4,499 rows — these rows as CSV