PREVIEW / stock_daily / 2007-11-30
file: by_date/stock_daily/2007/2007-11-30.parquet size: 182 KB rows: 5,623 symbols: 3,413
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-30 | AAPL | Stock | 6.6907 | 6.7036 | 6.4179 | 6.5079 | 1187802000.0 |
| 2007-11-30 | MSFT | Stock | 33.92 | 34.12 | 33.19 | 33.6 | 71027800.0 |
| 2007-11-30 | NVDA | Stock | 0.855 | 0.855 | 0.786 | 0.7885 | 652656000.0 |
| 2007-11-30 | AMZN | Stock | 4.528 | 4.554 | 4.4155 | 4.528 | 137632000.0 |
| 2007-11-30 | TLT | Stock | 93.88 | 94.391 | 93.7401 | 94.38 | 1952069.0 |
| 2007-11-30 | CL | Stock | 40.5 | 40.5 | 39.67 | 40.04 | 12290200.0 |
| 2007-11-30 | A | Stock | 27.1745 | 27.1817 | 26.8813 | 27.0601 | 2632015.0 |
| 2007-11-30 | AABA-DELISTED | Stock | 27.02 | 27.33 | 26.51 | 26.81 | 24022340.0 |
| 2007-11-30 | AACC-DELISTED | Stock | 11.66 | 11.99 | 11.3 | 11.3 | 155417.0 |
| 2007-11-30 | AAI-DELISTED | Stock | 8.34 | 8.58 | 8.32 | 8.49 | 1533700.0 |
| 2007-11-30 | AAIC-DELISTED | Stock | 56.2 | 59.8 | 55.4 | 59.8 | 3226448.0 |
| 2007-11-30 | AAME | Stock | 1.74 | 1.75 | 1.74 | 1.75 | 6800.0 |
| 2007-11-30 | AAON | Stock | 3.7531 | 3.8321 | 3.7432 | 3.759 | 501187.0 |
| 2007-11-30 | AAP | Stock | 36.02 | 36.67 | 35.63 | 35.96 | 1339300.0 |
| 2007-11-30 | AATI-DELISTED | Stock | 11.04 | 11.09 | 10.73 | 10.76 | 551616.0 |
| 2007-11-30 | AAU-DELISTED | Stock | 2.41 | 2.59 | 2.41 | 2.49 | 80948.0 |
| 2007-11-30 | AAUAF-DELISTED | Stock | 2.41 | 2.59 | 2.41 | 2.4899 | 81496.0 |
| 2007-11-30 | AAV-DELISTED | Stock | 10.35 | 10.5 | 10.35 | 10.49 | 602402.0 |
| 2007-11-30 | AAWW-DELISTED | Stock | 53.0 | 53.0 | 51.92 | 52.65 | 159705.0 |
| 2007-11-30 | AAXN-DELISTED | Stock | 14.38 | 14.94 | 13.85 | 14.0 | 1478893.0 |
| 2007-11-30 | AB | Stock | 81.26 | 82.84 | 81.16 | 81.95 | 242500.0 |
| 2007-11-30 | ABAX-DELISTED | Stock | 33.5 | 33.9 | 32.87 | 33.17 | 274398.0 |
| 2007-11-30 | ABB-DELISTED | Stock | 29.12 | 29.66 | 29.01 | 29.41 | 4190718.0 |
| 2007-11-30 | ABBC-DELISTED | Stock | 9.04 | 9.1 | 8.85 | 8.86 | 33909.0 |
| 2007-11-30 | ABBNY-DELISTED | Stock | 29.12 | 29.66 | 29.01 | 29.38 | 4190718.0 |
| 2007-11-30 | ABC-DELISTED | Stock | 22.62 | 22.96 | 22.34 | 22.68 | 4220670.0 |
| 2007-11-30 | ABCB | Stock | 16.5543 | 16.7197 | 16.2334 | 16.3696 | 51920.0 |
| 2007-11-30 | ABCO-DELISTED | Stock | 32.4 | 32.73 | 32.04 | 32.51 | 211186.0 |
| 2007-11-30 | ABCW-DELISTED | Stock | 25.03 | 25.59 | 24.98 | 25.42 | 164630.0 |
| 2007-11-30 | ABD-DELISTED | Stock | 17.005 | 17.116 | 16.655 | 16.665 | 457800.0 |
| 2007-11-30 | ABE-DELISTED | Stock | 25.5 | 26.14 | 25.5 | 25.8628 | 38400.0 |
| 2007-11-30 | ABEO | Stock | 3337.5 | 3775.0 | 3337.5 | 3775.0 | 10.0 |
| 2007-11-30 | ABFS-DELISTED | Stock | 22.88 | 23.56 | 22.44 | 22.78 | 610696.0 |
| 2007-11-30 | ABG | Stock | 16.92 | 17.23 | 16.56 | 16.74 | 604800.0 |
| 2007-11-30 | ABII-DELISTED | Stock | 57.15 | 60.4 | 57.13 | 58.99 | 57617.0 |
| 2007-11-30 | ABK-DELISTED | Stock | 27.11 | 30.25 | 26.18 | 27.19 | 14664000.0 |
| 2007-11-30 | ABM | Stock | 20.95 | 21.09 | 20.09 | 20.4 | 362000.0 |
| 2007-11-30 | ABMD-DELISTED | Stock | 12.44 | 13.02 | 12.38 | 12.84 | 294733.0 |
| 2007-11-30 | ABP-DELISTED | Stock | 3.48 | 3.48 | 3.32 | 3.36 | 138100.0 |
| 2007-11-30 | ABR | Stock | 17.61 | 17.67 | 17.01 | 17.1 | 220400.0 |
| 2007-11-30 | ABT | Stock | 27.8332 | 27.91 | 27.3726 | 27.5933 | 25209879.0 |
| 2007-11-30 | ABTL-DELISTED | Stock | 15.299 | 16.302 | 14.998 | 16.051 | 38683.0 |
| 2007-11-30 | ABV-DELISTED | Stock | 74.75 | 75.83 | 73.98 | 74.99 | 884299.0 |
| 2007-11-30 | ABVA-DELISTED | Stock | 7.51 | 7.77 | 7.47 | 7.51 | 3900.0 |
| 2007-11-30 | ABVT-DELISTED | Stock | 75.0 | 81.5 | 74.0 | 81.5 | 38303.0 |
| 2007-11-30 | ABX-DELISTED | Stock | 40.85 | 41.44 | 39.99 | 40.59 | 7936813.0 |
| 2007-11-30 | ACAD | Stock | 11.23 | 11.64 | 11.15 | 11.34 | 667000.0 |
| 2007-11-30 | ACAP-DELISTED | Stock | 42.23 | 42.75 | 40.72 | 41.95 | 146702.0 |
| 2007-11-30 | ACAS-DELISTED | Stock | 38.11 | 38.2 | 37.08 | 37.56 | 2540977.0 |
| 2007-11-30 | ACAT-DELISTED | Stock | 11.15 | 11.28 | 10.59 | 10.63 | 218229.0 |
> showing 50 of 5,623 rows — these rows as CSV