PREVIEW / stock_daily / 2007-12-06
file: by_date/stock_daily/2007/2007-12-06.parquet size: 181 KB rows: 5,627 symbols: 3,415
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-06 | AAPL | Stock | 6.6496 | 6.7893 | 6.6471 | 6.7839 | 899810800.0 |
| 2007-12-06 | MSFT | Stock | 34.26 | 34.61 | 33.87 | 34.55 | 49209700.0 |
| 2007-12-06 | NVDA | Stock | 0.8388 | 0.8605 | 0.8312 | 0.8578 | 371152000.0 |
| 2007-12-06 | AMZN | Stock | 4.664 | 4.75 | 4.6415 | 4.7105 | 109454000.0 |
| 2007-12-06 | TLT | Stock | 93.32 | 93.34 | 92.54 | 92.79 | 2270166.0 |
| 2007-12-06 | CL | Stock | 39.595 | 39.855 | 39.495 | 39.74 | 4721200.0 |
| 2007-12-06 | A | Stock | 27.0601 | 27.3176 | 26.8169 | 27.1459 | 3259996.0 |
| 2007-12-06 | AABA-DELISTED | Stock | 25.86 | 26.02 | 25.39 | 25.95 | 19244065.0 |
| 2007-12-06 | AACC-DELISTED | Stock | 11.74 | 11.93 | 11.51 | 11.9 | 247208.0 |
| 2007-12-06 | AAI-DELISTED | Stock | 8.03 | 8.45 | 8.02 | 8.42 | 1122204.0 |
| 2007-12-06 | AAIC-DELISTED | Stock | 55.0 | 56.8 | 55.0 | 56.4 | 1804099.0 |
| 2007-12-06 | AAME | Stock | 1.81 | 1.94 | 1.7 | 1.81 | 7300.0 |
| 2007-12-06 | AAON | Stock | 3.7333 | 3.9012 | 3.7116 | 3.9012 | 606994.0 |
| 2007-12-06 | AAP | Stock | 38.0 | 38.63 | 37.48 | 38.51 | 1471600.0 |
| 2007-12-06 | AATI-DELISTED | Stock | 10.35 | 10.74 | 10.27 | 10.74 | 379032.0 |
| 2007-12-06 | AAU-DELISTED | Stock | 2.48 | 2.5 | 2.4 | 2.4 | 66300.0 |
| 2007-12-06 | AAUAF-DELISTED | Stock | 2.48 | 2.5 | 2.4 | 2.4 | 67100.0 |
| 2007-12-06 | AAV-DELISTED | Stock | 10.15 | 10.25 | 10.07 | 10.24 | 780570.0 |
| 2007-12-06 | AAWW-DELISTED | Stock | 53.07 | 54.06 | 53.05 | 54.06 | 97731.0 |
| 2007-12-06 | AAXN-DELISTED | Stock | 15.13 | 15.93 | 15.01 | 15.93 | 1784805.0 |
| 2007-12-06 | AB | Stock | 78.7 | 80.69 | 77.01 | 79.84 | 443500.0 |
| 2007-12-06 | ABAX-DELISTED | Stock | 33.06 | 34.68 | 32.8 | 34.64 | 299711.0 |
| 2007-12-06 | ABB-DELISTED | Stock | 29.11 | 29.53 | 29.0 | 29.46 | 4157285.0 |
| 2007-12-06 | ABBC-DELISTED | Stock | 8.78 | 9.05 | 8.76 | 9.02 | 209869.0 |
| 2007-12-06 | ABBNY-DELISTED | Stock | 29.11 | 29.53 | 29.0 | 29.52 | 3906385.0 |
| 2007-12-06 | ABC-DELISTED | Stock | 22.22 | 22.73 | 22.18 | 22.54 | 2037760.0 |
| 2007-12-06 | ABCB | Stock | 16.4571 | 17.0213 | 16.4182 | 16.7781 | 128516.0 |
| 2007-12-06 | ABCO-DELISTED | Stock | 31.96 | 33.31 | 31.9 | 33.25 | 187350.0 |
| 2007-12-06 | ABCW-DELISTED | Stock | 25.14 | 26.27 | 24.5 | 26.19 | 108760.0 |
| 2007-12-06 | ABD-DELISTED | Stock | 16.575 | 17.565 | 16.575 | 17.555 | 418190.0 |
| 2007-12-06 | ABE-DELISTED | Stock | 26.97 | 27.99 | 26.97 | 27.9 | 31060.0 |
| 2007-12-06 | ABEO | Stock | 3312.5 | 3562.5 | 3187.5 | 3375.0 | 8.0 |
| 2007-12-06 | ABFS-DELISTED | Stock | 22.52 | 24.06 | 22.45 | 23.97 | 801025.0 |
| 2007-12-06 | ABG | Stock | 16.32 | 16.88 | 16.18 | 16.87 | 263800.0 |
| 2007-12-06 | ABII-DELISTED | Stock | 63.0 | 67.7 | 63.0 | 66.5 | 77243.0 |
| 2007-12-06 | ABK-DELISTED | Stock | 24.1 | 26.64 | 23.33 | 26.23 | 9352982.0 |
| 2007-12-06 | ABM | Stock | 20.26 | 21.25 | 20.26 | 21.25 | 269400.0 |
| 2007-12-06 | ABMD-DELISTED | Stock | 12.9 | 13.63 | 12.85 | 13.56 | 193174.0 |
| 2007-12-06 | ABP-DELISTED | Stock | 3.63 | 3.7 | 3.6 | 3.6 | 162324.0 |
| 2007-12-06 | ABR | Stock | 17.34 | 18.04 | 17.11 | 17.78 | 335600.0 |
| 2007-12-06 | ABT | Stock | 27.8956 | 27.9723 | 27.6029 | 27.9004 | 9753856.0 |
| 2007-12-06 | ABTL-DELISTED | Stock | 15.0 | 15.5 | 14.75 | 15.0 | 31699.0 |
| 2007-12-06 | ABV-DELISTED | Stock | 75.73 | 76.77 | 74.82 | 76.72 | 1622746.0 |
| 2007-12-06 | ABVA-DELISTED | Stock | 7.29 | 7.37 | 6.25 | 6.76 | 8343.0 |
| 2007-12-06 | ABVT-DELISTED | Stock | 77.0 | 78.0 | 77.0 | 78.0 | 1100.0 |
| 2007-12-06 | ABX-DELISTED | Stock | 39.61 | 40.45 | 39.14 | 40.22 | 7416560.0 |
| 2007-12-06 | ACAD | Stock | 11.81 | 12.78 | 11.79 | 12.6 | 516000.0 |
| 2007-12-06 | ACAP-DELISTED | Stock | 42.74 | 44.02 | 42.74 | 43.94 | 68516.0 |
| 2007-12-06 | ACAS-DELISTED | Stock | 36.52 | 37.52 | 36.245 | 37.52 | 2153686.0 |
| 2007-12-06 | ACAT-DELISTED | Stock | 11.33 | 11.92 | 11.15 | 11.83 | 205509.0 |
> showing 50 of 5,627 rows — these rows as CSV