PREVIEW / stock_daily / 2007-08-03
file: by_date/stock_daily/2007/2007-08-03.parquet size: 178 KB rows: 5,476 symbols: 3,313
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-08-03 | AAPL | Stock | 4.8307 | 4.8554 | 4.6964 | 4.7089 | 679187600.0 |
| 2007-08-03 | MSFT | Stock | 29.45 | 29.78 | 28.9 | 28.96 | 61535500.0 |
| 2007-08-03 | NVDA | Stock | 0.7512 | 0.7567 | 0.7087 | 0.709 | 623412000.0 |
| 2007-08-03 | AMZN | Stock | 3.977 | 4.0375 | 3.8355 | 3.84 | 159750000.0 |
| 2007-08-03 | TLT | Stock | 87.28 | 87.93 | 87.28 | 87.93 | 1577597.0 |
| 2007-08-03 | CL | Stock | 33.95 | 33.95 | 33.065 | 33.1 | 7974200.0 |
| 2007-08-03 | A | Stock | 27.6824 | 27.804 | 27.1674 | 27.1674 | 5330993.0 |
| 2007-08-03 | AABA-DELISTED | Stock | 23.2 | 23.39 | 22.9 | 22.9 | 18616060.0 |
| 2007-08-03 | AACC-DELISTED | Stock | 11.54 | 11.63 | 9.9 | 10.13 | 860821.0 |
| 2007-08-03 | AAI-DELISTED | Stock | 9.7 | 9.73 | 9.37 | 9.37 | 1796400.0 |
| 2007-08-03 | AAIC-DELISTED | Stock | 94.8 | 96.2 | 85.8 | 88.4 | 3912300.0 |
| 2007-08-03 | AAME | Stock | 3.17 | 3.21 | 3.04 | 3.18 | 4200.0 |
| 2007-08-03 | AAON | Stock | 4.3654 | 4.4444 | 4.1837 | 4.243 | 604462.0 |
| 2007-08-03 | AAP | Stock | 35.14 | 35.14 | 33.56 | 33.67 | 2371800.0 |
| 2007-08-03 | AATI-DELISTED | Stock | 8.66 | 8.73 | 8.07 | 8.14 | 553273.0 |
| 2007-08-03 | AAU-DELISTED | Stock | 2.61 | 2.68 | 2.52 | 2.65 | 31800.0 |
| 2007-08-03 | AAUAF-DELISTED | Stock | 2.61 | 2.68 | 2.52 | 2.646 | 31700.0 |
| 2007-08-03 | AAV-DELISTED | Stock | 12.36 | 12.45 | 11.99 | 12.15 | 468400.0 |
| 2007-08-03 | AAWW-DELISTED | Stock | 55.1 | 56.27 | 54.17 | 54.334 | 152558.0 |
| 2007-08-03 | AAXN-DELISTED | Stock | 14.8 | 14.97 | 14.25 | 14.25 | 2715418.0 |
| 2007-08-03 | AB | Stock | 84.0 | 85.0 | 82.16 | 82.5 | 326200.0 |
| 2007-08-03 | ABAX-DELISTED | Stock | 18.67 | 18.8 | 18.06 | 18.1 | 220638.0 |
| 2007-08-03 | ABB-DELISTED | Stock | 23.82 | 23.88 | 23.23 | 23.3 | 2991300.0 |
| 2007-08-03 | ABBC-DELISTED | Stock | 8.99 | 9.02 | 8.5 | 8.88 | 104706.0 |
| 2007-08-03 | ABBNY-DELISTED | Stock | 23.82 | 23.88 | 23.23 | 23.32 | 3185800.0 |
| 2007-08-03 | ABC-DELISTED | Stock | 23.15 | 23.63 | 23.01 | 23.06 | 3958400.0 |
| 2007-08-03 | ABCB | Stock | 18.0231 | 18.1106 | 17.2644 | 17.5172 | 72791.0 |
| 2007-08-03 | ABCO-DELISTED | Stock | 26.28 | 26.81 | 25.49 | 25.92 | 561876.0 |
| 2007-08-03 | ABCW-DELISTED | Stock | 22.5 | 22.67 | 21.24 | 21.25 | 107860.0 |
| 2007-08-03 | ABD-DELISTED | Stock | 21.17 | 21.22 | 20.36 | 20.75 | 690860.0 |
| 2007-08-03 | ABE-DELISTED | Stock | 21.56 | 21.8 | 20.671 | 20.78 | 21900.0 |
| 2007-08-03 | ABEO | Stock | 5375.0 | 5375.0 | 5350.0 | 5375.0 | 1.0 |
| 2007-08-03 | ABFS-DELISTED | Stock | 37.46 | 37.46 | 35.16 | 35.24 | 631413.0 |
| 2007-08-03 | ABG | Stock | 21.72 | 21.77 | 20.95 | 20.99 | 739300.0 |
| 2007-08-03 | ABK-DELISTED | Stock | 68.61 | 68.61 | 60.21 | 62.49 | 7921900.0 |
| 2007-08-03 | ABM | Stock | 24.89 | 24.89 | 22.41 | 22.56 | 464500.0 |
| 2007-08-03 | ABMD-DELISTED | Stock | 11.0 | 11.0 | 10.34 | 10.44 | 401712.0 |
| 2007-08-03 | ABP-DELISTED | Stock | 4.08 | 4.09 | 3.94 | 3.94 | 130600.0 |
| 2007-08-03 | ABR | Stock | 20.34 | 21.0 | 18.36 | 19.19 | 827400.0 |
| 2007-08-03 | ABT | Stock | 24.5418 | 25.012 | 24.4698 | 24.513 | 17713839.0 |
| 2007-08-03 | ABTL-DELISTED | Stock | 15.955 | 16.816 | 15.397 | 15.6 | 26064.0 |
| 2007-08-03 | ABV-DELISTED | Stock | 68.51 | 68.85 | 64.9 | 65.05 | 861200.0 |
| 2007-08-03 | ABVA-DELISTED | Stock | 10.05 | 10.15 | 9.5 | 9.6 | 145248.0 |
| 2007-08-03 | ABVT-DELISTED | Stock | 80.0 | 81.0 | 79.0 | 81.0 | 60752.0 |
| 2007-08-03 | ABX-DELISTED | Stock | 33.07 | 33.55 | 32.87 | 33.27 | 7038900.0 |
| 2007-08-03 | ACAD | Stock | 14.56 | 15.38 | 14.45 | 14.87 | 497800.0 |
| 2007-08-03 | ACAP-DELISTED | Stock | 37.81 | 38.1 | 35.67 | 35.68 | 99951.0 |
| 2007-08-03 | ACAS-DELISTED | Stock | 38.44 | 39.19 | 37.98 | 38.0 | 4736807.0 |
| 2007-08-03 | ACAT-DELISTED | Stock | 18.08 | 18.4 | 17.75 | 17.83 | 169802.0 |
| 2007-08-03 | ACC-DELISTED | Stock | 25.81 | 26.28 | 25.38 | 25.6 | 481554.0 |
> showing 50 of 5,476 rows — these rows as CSV