PREVIEW / stock_daily / 2007-11-01
file: by_date/stock_daily/2007/2007-11-01.parquet size: 180 KB rows: 5,585 symbols: 3,381
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-11-01 | AAPL | Stock | 6.7357 | 6.7893 | 6.4286 | 6.6943 | 805036400.0 |
| 2007-11-01 | MSFT | Stock | 36.53 | 37.49 | 36.36 | 37.06 | 152078800.0 |
| 2007-11-01 | NVDA | Stock | 0.8708 | 0.9023 | 0.8588 | 0.8845 | 587236000.0 |
| 2007-11-01 | AMZN | Stock | 4.3875 | 4.479 | 4.325 | 4.3825 | 165314000.0 |
| 2007-11-01 | TLT | Stock | 89.96 | 91.01 | 89.96 | 90.97 | 2563400.0 |
| 2007-11-01 | CL | Stock | 37.815 | 37.99 | 37.21 | 37.26 | 5966200.0 |
| 2007-11-01 | A | Stock | 26.2303 | 26.5093 | 25.9156 | 25.9371 | 2688494.0 |
| 2007-11-01 | AABA-DELISTED | Stock | 30.84 | 31.1 | 30.04 | 30.21 | 26927182.0 |
| 2007-11-01 | AACC-DELISTED | Stock | 10.56 | 10.71 | 10.3499 | 10.49 | 284372.0 |
| 2007-11-01 | AAI-DELISTED | Stock | 10.11 | 10.27 | 9.8 | 10.14 | 2217400.0 |
| 2007-11-01 | AAIC-DELISTED | Stock | 84.8 | 84.8 | 79.4 | 79.4 | 2011600.0 |
| 2007-11-01 | AAME | Stock | 2.27 | 2.27 | 2.13 | 2.24 | 3700.0 |
| 2007-11-01 | AAON | Stock | 3.5575 | 3.5812 | 3.358 | 3.362 | 617625.0 |
| 2007-11-01 | AAP | Stock | 35.0 | 36.04 | 34.0 | 35.06 | 6996400.0 |
| 2007-11-01 | AATI-DELISTED | Stock | 11.52 | 11.75 | 11.32 | 11.34 | 769225.0 |
| 2007-11-01 | AAU-DELISTED | Stock | 3.1 | 3.13 | 3.01 | 3.04 | 87200.0 |
| 2007-11-01 | AAUAF-DELISTED | Stock | 3.1 | 3.13 | 3.01 | 3.03 | 87200.0 |
| 2007-11-01 | AAV-DELISTED | Stock | 12.6 | 12.66 | 12.5 | 12.56 | 597700.0 |
| 2007-11-01 | AAWW-DELISTED | Stock | 57.84 | 58.54 | 56.7 | 57.15 | 103625.0 |
| 2007-11-01 | AAXN-DELISTED | Stock | 16.32 | 16.41 | 15.77 | 15.94 | 1932184.0 |
| 2007-11-01 | AB | Stock | 82.71 | 83.5 | 80.24 | 81.63 | 351900.0 |
| 2007-11-01 | ABAX-DELISTED | Stock | 29.6 | 29.84 | 28.73 | 28.9 | 321170.0 |
| 2007-11-01 | ABB-DELISTED | Stock | 30.11 | 30.24 | 29.53 | 29.79 | 4302500.0 |
| 2007-11-01 | ABBC-DELISTED | Stock | 9.23 | 9.26 | 9.0 | 9.01 | 96017.0 |
| 2007-11-01 | ABBNY-DELISTED | Stock | 30.11 | 30.24 | 29.53 | 29.78 | 4304500.0 |
| 2007-11-01 | ABC-DELISTED | Stock | 23.4 | 24.24 | 22.25 | 22.62 | 4797200.0 |
| 2007-11-01 | ABCB | Stock | 16.0875 | 16.0875 | 14.7648 | 14.9787 | 107748.0 |
| 2007-11-01 | ABCO-DELISTED | Stock | 31.4 | 32.22 | 30.82 | 31.01 | 555578.0 |
| 2007-11-01 | ABCW-DELISTED | Stock | 24.24 | 24.38 | 22.82 | 23.17 | 136120.0 |
| 2007-11-01 | ABD-DELISTED | Stock | 20.99 | 21.38 | 19.92 | 20.1 | 376800.0 |
| 2007-11-01 | ABE-DELISTED | Stock | 27.33 | 28.14 | 27.01 | 27.062 | 38900.0 |
| 2007-11-01 | ABEO | Stock | 3812.5 | 3875.0 | 3775.0 | 3775.0 | 31.0 |
| 2007-11-01 | ABFS-DELISTED | Stock | 27.11 | 27.11 | 25.48 | 25.71 | 1526555.0 |
| 2007-11-01 | ABG | Stock | 17.9 | 18.02 | 17.18 | 17.67 | 1140300.0 |
| 2007-11-01 | ABK-DELISTED | Stock | 33.81 | 33.81 | 26.96 | 29.4 | 23729846.0 |
| 2007-11-01 | ABM | Stock | 23.25 | 23.37 | 22.77 | 22.92 | 537600.0 |
| 2007-11-01 | ABMD-DELISTED | Stock | 13.33 | 13.82 | 12.88 | 12.9 | 333040.0 |
| 2007-11-01 | ABP-DELISTED | Stock | 4.48 | 4.55 | 4.35 | 4.45 | 137600.0 |
| 2007-11-01 | ABR | Stock | 18.62 | 18.73 | 18.0 | 18.11 | 342100.0 |
| 2007-11-01 | ABT | Stock | 26.1779 | 26.4226 | 25.8948 | 25.9668 | 11938933.0 |
| 2007-11-01 | ABTL-DELISTED | Stock | 12.383 | 12.481 | 11.355 | 11.6 | 25266.0 |
| 2007-11-01 | ABV-DELISTED | Stock | 80.8 | 82.59 | 80.25 | 80.84 | 704295.0 |
| 2007-11-01 | ABVA-DELISTED | Stock | 9.2 | 9.2 | 8.98 | 8.98 | 2100.0 |
| 2007-11-01 | ABVT-DELISTED | Stock | 85.5 | 87.25 | 85.5 | 87.25 | 11900.0 |
| 2007-11-01 | ABX-DELISTED | Stock | 43.03 | 43.87 | 42.22 | 42.61 | 7578500.0 |
| 2007-11-01 | ACAD | Stock | 15.13 | 15.5 | 15.0 | 15.0 | 271500.0 |
| 2007-11-01 | ACAP-DELISTED | Stock | 43.11 | 43.88 | 42.43 | 43.14 | 74406.0 |
| 2007-11-01 | ACAS-DELISTED | Stock | 43.12 | 43.39 | 41.64 | 41.65 | 2773559.0 |
| 2007-11-01 | ACAT-DELISTED | Stock | 14.32 | 14.41 | 13.63 | 13.87 | 292491.0 |
| 2007-11-01 | ACC-DELISTED | Stock | 28.19 | 28.19 | 27.12 | 27.27 | 323000.0 |
> showing 50 of 5,585 rows — these rows as CSV