PREVIEW / stock_daily / 2006-08-08
file: by_date/stock_daily/2006/2006-08-08.parquet size: 148 KB rows: 4,484 symbols: 2,836
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-08 | AAPL | Stock | 2.3961 | 2.3968 | 2.3039 | 2.3136 | 997864000.0 |
| 2006-08-08 | MSFT | Stock | 24.39 | 24.52 | 24.2 | 24.34 | 58171300.0 |
| 2006-08-08 | NVDA | Stock | 0.3983 | 0.4142 | 0.3973 | 0.4057 | 619806000.0 |
| 2006-08-08 | AMZN | Stock | 1.34 | 1.351 | 1.3095 | 1.318 | 145204000.0 |
| 2006-08-08 | CL | Stock | 29.56 | 29.68 | 29.325 | 29.455 | 4502400.0 |
| 2006-08-08 | A | Stock | 19.8498 | 19.8927 | 19.2847 | 19.3705 | 2914131.0 |
| 2006-08-08 | AABA-DELISTED | Stock | 26.9500007629395 | 27.7000007629395 | 26.6299991607666 | 27.4400005340576 | 19332800.0 |
| 2006-08-08 | AACC-DELISTED | Stock | 17.62 | 17.81 | 15.55 | 15.62 | 398790.0 |
| 2006-08-08 | AACQ-DELISTED | Stock | 5.34 | 5.35 | 5.34 | 5.35 | 2900.0 |
| 2006-08-08 | AACQU-DELISTED | Stock | 6.05 | 6.08 | 6.05 | 6.08 | 1900.0 |
| 2006-08-08 | AACQW-DELISTED | Stock | 0.36 | 0.4 | 0.36 | 0.4 | 42300.0 |
| 2006-08-08 | AAI-DELISTED | Stock | 12.84 | 12.89 | 12.4 | 12.45 | 773400.0 |
| 2006-08-08 | AAIC-DELISTED | Stock | 181.8 | 182.8 | 178.8 | 179.0 | 1537300.0 |
| 2006-08-08 | AAME | Stock | 2.8 | 2.8 | 2.75 | 2.75 | 3300.0 |
| 2006-08-08 | AAON | Stock | 3.2277 | 3.2435 | 3.0301 | 3.0696 | 246037.0 |
| 2006-08-08 | AAP | Stock | 30.21 | 30.4 | 29.52 | 29.61 | 770800.0 |
| 2006-08-08 | AATI-DELISTED | Stock | 8.82 | 9.17 | 8.7 | 8.91 | 253572.0 |
| 2006-08-08 | AAU-DELISTED | Stock | 2.64 | 2.6499 | 2.56 | 2.56 | 21300.0 |
| 2006-08-08 | AAUAF-DELISTED | Stock | 2.64 | 2.6499 | 2.56 | 2.56 | 21300.0 |
| 2006-08-08 | AAV-DELISTED | Stock | 16.47 | 16.5458 | 16.2201 | 16.27 | 415900.0 |
| 2006-08-08 | AAWW-DELISTED | Stock | 39.75 | 39.75 | 38.48 | 38.6 | 114661.0 |
| 2006-08-08 | AAXN-DELISTED | Stock | 7.03999996185303 | 7.17999982833862 | 7.01000022888184 | 7.07000017166138 | 683000.0 |
| 2006-08-08 | AB | Stock | 66.18 | 66.95 | 64.99 | 65.04 | 144400.0 |
| 2006-08-08 | ABAX-DELISTED | Stock | 22.88 | 22.92 | 21.9 | 21.95 | 165457.0 |
| 2006-08-08 | ABB-DELISTED | Stock | 12.84 | 13.0 | 12.7808 | 12.82 | 2675100.0 |
| 2006-08-08 | ABBC-DELISTED | Stock | 14.73 | 14.85 | 14.65 | 14.65 | 5396.0 |
| 2006-08-08 | ABC-DELISTED | Stock | 21.59 | 21.69 | 21.11 | 21.21 | 2023200.0 |
| 2006-08-08 | ABCB | Stock | 25.775 | 26.699 | 25.1817 | 25.2109 | 79474.0 |
| 2006-08-08 | ABCO-DELISTED | Stock | 25.1 | 25.23 | 24.6 | 24.76 | 181596.0 |
| 2006-08-08 | ABCW-DELISTED | Stock | 30.1 | 30.32 | 29.48 | 29.48 | 53670.0 |
| 2006-08-08 | ABD-DELISTED | Stock | 19.36 | 19.36 | 18.26 | 18.36 | 292320.0 |
| 2006-08-08 | ABE-DELISTED | Stock | 12.84 | 12.84 | 12.56 | 12.69 | 8300.0 |
| 2006-08-08 | ABFS-DELISTED | Stock | 45.1 | 46.14 | 44.38 | 44.5 | 394793.0 |
| 2006-08-08 | ABG | Stock | 20.6 | 20.8 | 20.38 | 20.4 | 91400.0 |
| 2006-08-08 | ABK-DELISTED | Stock | 82.8 | 83.07 | 82.21 | 82.52 | 694000.0 |
| 2006-08-08 | ABM | Stock | 16.45 | 16.64 | 16.2 | 16.22 | 112600.0 |
| 2006-08-08 | ABMD-DELISTED | Stock | 13.25 | 13.5 | 12.87 | 12.91 | 120020.0 |
| 2006-08-08 | ABP-DELISTED | Stock | 4.35 | 4.4 | 4.05 | 4.1 | 437700.0 |
| 2006-08-08 | ABR | Stock | 25.57 | 25.57 | 25.05 | 25.07 | 135700.0 |
| 2006-08-08 | ABT | Stock | 22.7761 | 22.8721 | 22.637 | 22.8721 | 7813256.0 |
| 2006-08-08 | ABTL-DELISTED | Stock | 16.05 | 16.201 | 15.699 | 16.0 | 11378.0 |
| 2006-08-08 | ABV-DELISTED | Stock | 40.47 | 41.4 | 40.47 | 41.06 | 228100.0 |
| 2006-08-08 | ABVA-DELISTED | Stock | 16.2 | 16.24 | 16.15 | 16.23 | 2800.0 |
| 2006-08-08 | ABX-DELISTED | Stock | 31.89 | 32.86 | 31.89 | 32.15 | 3181400.0 |
| 2006-08-08 | ACAD | Stock | 6.0 | 6.28 | 5.91 | 6.03 | 293500.0 |
| 2006-08-08 | ACAP-DELISTED | Stock | 47.0 | 47.6 | 46.65 | 46.81 | 40724.0 |
| 2006-08-08 | ACAS-DELISTED | Stock | 36.64 | 36.67 | 36.25 | 36.34 | 1108437.0 |
| 2006-08-08 | ACAT-DELISTED | Stock | 17.67 | 18.3 | 17.43 | 17.5 | 42730.0 |
| 2006-08-08 | ACC-DELISTED | Stock | 25.77 | 25.77 | 25.25 | 25.26 | 45700.0 |
| 2006-08-08 | ACCL-DELISTED | Stock | 6.08 | 6.34 | 6.08 | 6.33 | 38761.0 |
> showing 50 of 4,484 rows — these rows as CSV