PREVIEW / stock_daily / 2007-02-15
file: by_date/stock_daily/2007/2007-02-15.parquet size: 162 KB rows: 4,857 symbols: 3,052
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-02-15 | AAPL | Stock | 3.0514 | 3.0579 | 3.0279 | 3.0432 | 363661200.0 |
| 2007-02-15 | MSFT | Stock | 29.58 | 29.65 | 29.22 | 29.46 | 63858100.0 |
| 2007-02-15 | NVDA | Stock | 0.5588 | 0.5653 | 0.5535 | 0.5625 | 488682000.0 |
| 2007-02-15 | AMZN | Stock | 2.007 | 2.016 | 1.993 | 2.003 | 101764000.0 |
| 2007-02-15 | TLT | Stock | 88.53 | 88.58 | 88.33 | 88.33 | 893800.0 |
| 2007-02-15 | CL | Stock | 34.045 | 34.065 | 33.795 | 33.955 | 3063600.0 |
| 2007-02-15 | A | Stock | 23.598 | 24.4278 | 23.5765 | 24.1989 | 5713486.0 |
| 2007-02-15 | AABA-DELISTED | Stock | 30.8199996948242 | 31.6499996185303 | 30.6900005340576 | 31.25 | 28160300.0 |
| 2007-02-15 | AACC-DELISTED | Stock | 15.35 | 15.9 | 15.35 | 15.52 | 63449.0 |
| 2007-02-15 | AACQ-DELISTED | Stock | 5.59 | 5.59 | 5.55 | 5.59 | 58844.0 |
| 2007-02-15 | AACQU-DELISTED | Stock | 6.94 | 6.94 | 6.94 | 6.94 | 1000.0 |
| 2007-02-15 | AACQW-DELISTED | Stock | 0.75 | 0.75 | 0.72 | 0.72 | 17615.0 |
| 2007-02-15 | AAI-DELISTED | Stock | 11.65 | 11.88 | 11.61 | 11.66 | 1374150.0 |
| 2007-02-15 | AAIC-DELISTED | Stock | 144.2 | 147.0 | 143.6 | 144.8 | 1669900.0 |
| 2007-02-15 | AAME | Stock | 3.8 | 3.94 | 3.8 | 3.81 | 4700.0 |
| 2007-02-15 | AAON | Stock | 3.7478 | 3.7491 | 3.7004 | 3.7373 | 178453.0 |
| 2007-02-15 | AAP | Stock | 37.0 | 39.32 | 36.75 | 38.75 | 3884400.0 |
| 2007-02-15 | AATI-DELISTED | Stock | 5.99 | 6.0 | 5.81 | 5.9 | 478651.0 |
| 2007-02-15 | AAU-DELISTED | Stock | 2.31 | 2.39 | 2.3 | 2.33 | 30500.0 |
| 2007-02-15 | AAUAF-DELISTED | Stock | 2.31 | 2.39 | 2.3 | 2.33 | 30500.0 |
| 2007-02-15 | AAV-DELISTED | Stock | 10.8 | 10.8 | 10.61 | 10.66 | 505400.0 |
| 2007-02-15 | AAWW-DELISTED | Stock | 50.37 | 50.5 | 50.03 | 50.07 | 170361.0 |
| 2007-02-15 | AAXN-DELISTED | Stock | 8.03999996185303 | 8.14999961853027 | 8.02999973297119 | 8.11999988555908 | 677700.0 |
| 2007-02-15 | AB | Stock | 92.9 | 93.48 | 91.37 | 92.14 | 227900.0 |
| 2007-02-15 | ABAX-DELISTED | Stock | 22.81 | 22.85 | 22.3 | 22.82 | 279228.0 |
| 2007-02-15 | ABB-DELISTED | Stock | 18.35 | 18.57 | 18.29 | 18.47 | 9088900.0 |
| 2007-02-15 | ABBC-DELISTED | Stock | 19.41 | 19.54 | 19.3 | 19.42 | 5783.0 |
| 2007-02-15 | ABC-DELISTED | Stock | 27.09 | 27.76 | 27.06 | 27.66 | 3181800.0 |
| 2007-02-15 | ABCB | Stock | 23.3726 | 23.3726 | 22.6431 | 22.9641 | 99009.0 |
| 2007-02-15 | ABCO-DELISTED | Stock | 26.84 | 26.92 | 26.44 | 26.55 | 668030.0 |
| 2007-02-15 | ABCW-DELISTED | Stock | 28.91 | 29.14 | 28.65 | 29.07 | 58510.0 |
| 2007-02-15 | ABD-DELISTED | Stock | 22.92 | 23.05 | 22.78 | 22.86 | 569900.0 |
| 2007-02-15 | ABE-DELISTED | Stock | 18.98 | 19.0 | 18.77 | 18.8 | 17000.0 |
| 2007-02-15 | ABFS-DELISTED | Stock | 41.41 | 41.41 | 40.66 | 41.13 | 340614.0 |
| 2007-02-15 | ABG | Stock | 25.75 | 26.25 | 25.48 | 25.84 | 449000.0 |
| 2007-02-15 | ABK-DELISTED | Stock | 90.99 | 91.73 | 90.86 | 91.59 | 560200.0 |
| 2007-02-15 | ABM | Stock | 26.62 | 27.05 | 26.62 | 26.86 | 183600.0 |
| 2007-02-15 | ABMD-DELISTED | Stock | 15.02 | 15.02 | 14.61 | 14.61 | 68977.0 |
| 2007-02-15 | ABP-DELISTED | Stock | 3.1 | 3.14 | 3.03 | 3.07 | 156500.0 |
| 2007-02-15 | ABR | Stock | 32.5 | 33.56 | 32.42 | 33.11 | 223900.0 |
| 2007-02-15 | ABT | Stock | 25.2279 | 25.3766 | 24.988 | 25.3334 | 8645894.0 |
| 2007-02-15 | ABTL-DELISTED | Stock | 18.75 | 19.05 | 18.65 | 19.05 | 12155.0 |
| 2007-02-15 | ABV-DELISTED | Stock | 53.66 | 54.17 | 53.52 | 54.13 | 402700.0 |
| 2007-02-15 | ABVA-DELISTED | Stock | 15.89 | 16.15 | 15.89 | 16.1358 | 800.0 |
| 2007-02-15 | ABVT-DELISTED | Stock | 57.5 | 57.5 | 55.0 | 55.0 | 10293.0 |
| 2007-02-15 | ABX-DELISTED | Stock | 31.31 | 31.53 | 30.99 | 31.53 | 4440430.0 |
| 2007-02-15 | ACAD | Stock | 7.05 | 7.12 | 6.9 | 7.01 | 110700.0 |
| 2007-02-15 | ACAP-DELISTED | Stock | 37.94 | 38.09 | 37.18 | 37.47 | 44346.0 |
| 2007-02-15 | ACAS-DELISTED | Stock | 47.8 | 48.14 | 47.45 | 47.6 | 1131163.0 |
| 2007-02-15 | ACAT-DELISTED | Stock | 17.83 | 18.14 | 17.71 | 18.03 | 47506.0 |
> showing 50 of 4,857 rows — these rows as CSV