PREVIEW / stock_daily / 2006-08-03
file: by_date/stock_daily/2006/2006-08-03.parquet size: 148 KB rows: 4,440 symbols: 2,787
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-08-03 | AAPL | Stock | 2.4254 | 2.5 | 2.4218 | 2.4854 | 841044400.0 |
| 2006-08-03 | MSFT | Stock | 24.19 | 24.48 | 24.15 | 24.21 | 43155300.0 |
| 2006-08-03 | NVDA | Stock | 0.38 | 0.4157 | 0.3747 | 0.4053 | 890568000.0 |
| 2006-08-03 | AMZN | Stock | 1.3045 | 1.345 | 1.295 | 1.3345 | 138822000.0 |
| 2006-08-03 | CL | Stock | 29.425 | 29.62 | 29.1 | 29.11 | 5359000.0 |
| 2006-08-03 | A | Stock | 19.9213 | 20.2718 | 19.8426 | 20.1717 | 2223379.0 |
| 2006-08-03 | AABA-DELISTED | Stock | 26.5 | 27.0499992370605 | 26.3999996185303 | 26.8999996185303 | 15468500.0 |
| 2006-08-03 | AACC-DELISTED | Stock | 18.0 | 18.92 | 17.86 | 18.74 | 145998.0 |
| 2006-08-03 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.35 | 5.35 | 700.0 |
| 2006-08-03 | AACQU-DELISTED | Stock | 6.06 | 6.06 | 6.0 | 6.0 | 3500.0 |
| 2006-08-03 | AACQW-DELISTED | Stock | 0.37 | 0.37 | 0.37 | 0.37 | 5000.0 |
| 2006-08-03 | AAI-DELISTED | Stock | 12.76 | 13.22 | 12.49 | 13.16 | 1421400.0 |
| 2006-08-03 | AAIC-DELISTED | Stock | 180.2 | 185.6 | 178.4 | 185.0 | 1297600.0 |
| 2006-08-03 | AAME | Stock | 2.7 | 2.87 | 2.7 | 2.72 | 3200.0 |
| 2006-08-03 | AAON | Stock | 3.0077 | 3.2119 | 3.0077 | 3.2119 | 153394.0 |
| 2006-08-03 | AAP | Stock | 30.09 | 30.7 | 29.9 | 30.57 | 996500.0 |
| 2006-08-03 | AATI-DELISTED | Stock | 8.52 | 8.67 | 8.37 | 8.55 | 443619.0 |
| 2006-08-03 | AAU-DELISTED | Stock | 2.68 | 2.68 | 2.55 | 2.55 | 54800.0 |
| 2006-08-03 | AAUAF-DELISTED | Stock | 2.68 | 2.68 | 2.55 | 2.55 | 54800.0 |
| 2006-08-03 | AAV-DELISTED | Stock | 16.57 | 16.57 | 16.35 | 16.5 | 281500.0 |
| 2006-08-03 | AAWW-DELISTED | Stock | 40.75 | 41.14 | 40.42 | 40.52 | 62490.0 |
| 2006-08-03 | AAXN-DELISTED | Stock | 7.23000001907349 | 7.30999994277954 | 7.03000020980835 | 7.23000001907349 | 740200.0 |
| 2006-08-03 | AB | Stock | 65.02 | 66.35 | 64.92 | 66.04 | 135000.0 |
| 2006-08-03 | ABAX-DELISTED | Stock | 22.07 | 23.9 | 22.07 | 23.75 | 314958.0 |
| 2006-08-03 | ABB-DELISTED | Stock | 12.63 | 12.82 | 12.6 | 12.76 | 1906300.0 |
| 2006-08-03 | ABBC-DELISTED | Stock | 14.68 | 14.95 | 14.65 | 14.94 | 21272.0 |
| 2006-08-03 | ABC-DELISTED | Stock | 21.55 | 21.7225 | 21.49 | 21.66 | 6131000.0 |
| 2006-08-03 | ABCB | Stock | 24.8802 | 25.8917 | 24.7052 | 25.775 | 49864.0 |
| 2006-08-03 | ABCO-DELISTED | Stock | 25.46 | 25.75 | 25.2 | 25.63 | 180764.0 |
| 2006-08-03 | ABCW-DELISTED | Stock | 29.73 | 30.67 | 29.59 | 30.6 | 33840.0 |
| 2006-08-03 | ABD-DELISTED | Stock | 19.5 | 19.5 | 18.94 | 19.09 | 246000.0 |
| 2006-08-03 | ABE-DELISTED | Stock | 12.3 | 13.0 | 12.27 | 12.89 | 35900.0 |
| 2006-08-03 | ABFS-DELISTED | Stock | 43.34 | 46.75 | 43.11 | 46.39 | 743658.0 |
| 2006-08-03 | ABG | Stock | 19.75 | 20.73 | 19.6 | 20.46 | 159600.0 |
| 2006-08-03 | ABK-DELISTED | Stock | 81.65 | 82.41 | 81.65 | 82.0 | 674700.0 |
| 2006-08-03 | ABM | Stock | 16.31 | 16.97 | 16.23 | 16.79 | 126300.0 |
| 2006-08-03 | ABMD-DELISTED | Stock | 13.57 | 13.76 | 13.29 | 13.51 | 77293.0 |
| 2006-08-03 | ABP-DELISTED | Stock | 4.34 | 4.35 | 4.24 | 4.32 | 133000.0 |
| 2006-08-03 | ABR | Stock | 25.2 | 25.39 | 24.89 | 25.07 | 52600.0 |
| 2006-08-03 | ABT | Stock | 22.6226 | 22.8625 | 22.613 | 22.6562 | 10057316.0 |
| 2006-08-03 | ABTL-DELISTED | Stock | 15.751 | 16.947 | 15.551 | 16.149 | 81495.0 |
| 2006-08-03 | ABV-DELISTED | Stock | 40.71 | 41.3 | 40.53 | 41.04 | 360400.0 |
| 2006-08-03 | ABVA-DELISTED | Stock | 16.72 | 16.72 | 16.6977 | 16.7 | 2300.0 |
| 2006-08-03 | ABVT-DELISTED | Stock | 47.25 | 47.25 | 47.25 | 47.25 | 800.0 |
| 2006-08-03 | ABX-DELISTED | Stock | 32.27 | 32.85 | 31.786 | 31.86 | 4631704.0 |
| 2006-08-03 | ACAD | Stock | 6.29 | 6.36 | 6.16 | 6.19 | 176400.0 |
| 2006-08-03 | ACAP-DELISTED | Stock | 44.96 | 45.52 | 44.93 | 45.03 | 104389.0 |
| 2006-08-03 | ACAS-DELISTED | Stock | 35.46 | 35.99 | 35.4 | 35.84 | 1255986.0 |
| 2006-08-03 | ACAT-DELISTED | Stock | 17.67 | 17.82 | 17.5 | 17.66 | 98207.0 |
| 2006-08-03 | ACC-DELISTED | Stock | 25.25 | 25.63 | 25.11 | 25.46 | 60800.0 |
> showing 50 of 4,440 rows — these rows as CSV