PREVIEW / stock_daily / 2006-08-25
file: by_date/stock_daily/2006/2006-08-25.parquet size: 148 KB rows: 4,456 symbols: 2,802
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-25 | AAPL | Stock | 2.405 | 2.4661 | 2.4039 | 2.4554 | 543958800.0 |
| 2006-08-25 | MSFT | Stock | 25.71 | 26.0 | 25.69 | 25.85 | 33115900.0 |
| 2006-08-25 | NVDA | Stock | 0.4393 | 0.4492 | 0.435 | 0.4413 | 238314000.0 |
| 2006-08-25 | AMZN | Stock | 1.3895 | 1.4115 | 1.381 | 1.4015 | 70852000.0 |
| 2006-08-25 | CL | Stock | 29.455 | 29.5 | 29.225 | 29.395 | 2106000.0 |
| 2006-08-25 | A | Stock | 21.7954 | 21.9385 | 21.7096 | 21.7954 | 2741618.0 |
| 2006-08-25 | AABA-DELISTED | Stock | 28.9500007629395 | 29.2800006866455 | 28.7399997711182 | 28.7700004577637 | 6203800.0 |
| 2006-08-25 | AACC-DELISTED | Stock | 15.19 | 15.27 | 14.76 | 14.76 | 194500.0 |
| 2006-08-25 | AACQ-DELISTED | Stock | 5.3 | 5.3 | 5.3 | 5.3 | 45500.0 |
| 2006-08-25 | AACQW-DELISTED | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 10000.0 |
| 2006-08-25 | AAI-DELISTED | Stock | 11.1 | 11.33 | 10.85 | 10.98 | 814100.0 |
| 2006-08-25 | AAIC-DELISTED | Stock | 170.0 | 171.0 | 165.2 | 166.4 | 1065000.0 |
| 2006-08-25 | AAME | Stock | 2.52 | 2.65 | 2.52 | 2.65 | 1300.0 |
| 2006-08-25 | AAON | Stock | 2.8537 | 2.9274 | 2.8444 | 2.8919 | 74419.0 |
| 2006-08-25 | AAP | Stock | 29.35 | 29.5 | 29.05 | 29.1 | 456700.0 |
| 2006-08-25 | AATI-DELISTED | Stock | 9.41 | 9.44 | 9.23 | 9.27 | 84848.0 |
| 2006-08-25 | AAU-DELISTED | Stock | 2.7 | 2.71 | 2.64 | 2.7 | 24500.0 |
| 2006-08-25 | AAUAF-DELISTED | Stock | 2.7 | 2.71 | 2.64 | 2.7 | 24500.0 |
| 2006-08-25 | AAV-DELISTED | Stock | 16.31 | 16.39 | 16.22 | 16.31 | 429000.0 |
| 2006-08-25 | AAWW-DELISTED | Stock | 42.02 | 42.73 | 41.81 | 42.47 | 52155.0 |
| 2006-08-25 | AAXN-DELISTED | Stock | 7.51000022888184 | 7.84999990463257 | 7.46999979019165 | 7.71000003814697 | 739000.0 |
| 2006-08-25 | AB | Stock | 65.05 | 66.06 | 64.84 | 65.6 | 110800.0 |
| 2006-08-25 | ABAX-DELISTED | Stock | 22.5 | 23.18 | 22.37 | 23.13 | 88359.0 |
| 2006-08-25 | ABB-DELISTED | Stock | 13.19 | 13.3 | 13.18 | 13.2399 | 1501900.0 |
| 2006-08-25 | ABBC-DELISTED | Stock | 14.28 | 14.5 | 14.28 | 14.35 | 4456.0 |
| 2006-08-25 | ABC-DELISTED | Stock | 21.85 | 22.0 | 21.82 | 21.88 | 945600.0 |
| 2006-08-25 | ABCB | Stock | 24.5106 | 25.2011 | 24.5106 | 25.1234 | 23441.0 |
| 2006-08-25 | ABCO-DELISTED | Stock | 24.29 | 24.66 | 24.15 | 24.55 | 92558.0 |
| 2006-08-25 | ABCW-DELISTED | Stock | 29.14 | 29.24 | 28.56 | 28.66 | 24370.0 |
| 2006-08-25 | ABD-DELISTED | Stock | 20.73 | 21.36 | 20.66 | 21.23 | 184100.0 |
| 2006-08-25 | ABE-DELISTED | Stock | 13.4 | 13.57 | 12.9 | 13.33 | 24400.0 |
| 2006-08-25 | ABFS-DELISTED | Stock | 41.66 | 42.35 | 41.5 | 42.15 | 219792.0 |
| 2006-08-25 | ABG | Stock | 19.49 | 19.53 | 19.35 | 19.41 | 41900.0 |
| 2006-08-25 | ABK-DELISTED | Stock | 85.0 | 85.54 | 84.91 | 85.29 | 506600.0 |
| 2006-08-25 | ABM | Stock | 17.53 | 17.77 | 17.53 | 17.54 | 58000.0 |
| 2006-08-25 | ABMD-DELISTED | Stock | 13.05 | 13.51 | 13.05 | 13.37 | 144381.0 |
| 2006-08-25 | ABP-DELISTED | Stock | 4.23 | 4.24 | 4.15 | 4.18 | 142600.0 |
| 2006-08-25 | ABR | Stock | 25.02 | 25.17 | 24.79 | 25.0 | 37400.0 |
| 2006-08-25 | ABT | Stock | 23.2895 | 23.491 | 23.2799 | 23.4094 | 4616924.0 |
| 2006-08-25 | ABTL-DELISTED | Stock | 14.5 | 14.75 | 14.2 | 14.6 | 28822.0 |
| 2006-08-25 | ABV-DELISTED | Stock | 43.1 | 43.58 | 42.83 | 43.19 | 318100.0 |
| 2006-08-25 | ABVA-DELISTED | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 200.0 |
| 2006-08-25 | ABVT-DELISTED | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 200.0 |
| 2006-08-25 | ABX-DELISTED | Stock | 33.1 | 33.45 | 32.77 | 33.1 | 1878468.0 |
| 2006-08-25 | ACAD | Stock | 8.25 | 8.55 | 8.01 | 8.55 | 242600.0 |
| 2006-08-25 | ACAP-DELISTED | Stock | 47.91 | 48.1 | 47.12 | 47.24 | 33269.0 |
| 2006-08-25 | ACAS-DELISTED | Stock | 37.85 | 37.9 | 37.66 | 37.83 | 528842.0 |
| 2006-08-25 | ACAT-DELISTED | Stock | 17.14 | 17.26 | 16.62 | 16.91 | 71012.0 |
| 2006-08-25 | ACC-DELISTED | Stock | 25.18 | 25.53 | 25.0 | 25.23 | 45600.0 |
| 2006-08-25 | ACCL-DELISTED | Stock | 6.07 | 6.07 | 5.65 | 5.65 | 104169.0 |
> showing 50 of 4,456 rows — these rows as CSV