PREVIEW / stock_daily / 2007-08-02
file: by_date/stock_daily/2007/2007-08-02.parquet size: 177 KB rows: 5,437 symbols: 3,276
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-02 | AAPL | Stock | 4.8804 | 4.8914 | 4.7911 | 4.8746 | 852644800.0 |
| 2007-08-02 | MSFT | Stock | 29.19 | 29.79 | 29.02 | 29.52 | 47938300.0 |
| 2007-08-02 | NVDA | Stock | 0.7657 | 0.7663 | 0.7435 | 0.7537 | 468606000.0 |
| 2007-08-02 | AMZN | Stock | 3.893 | 3.988 | 3.806 | 3.9855 | 207232000.0 |
| 2007-08-02 | TLT | Stock | 87.21 | 87.45 | 86.99 | 87.35 | 2079459.0 |
| 2007-08-02 | CL | Stock | 34.005 | 34.045 | 33.315 | 33.625 | 6789800.0 |
| 2007-08-02 | A | Stock | 27.8827 | 27.897 | 27.2103 | 27.6252 | 3915239.0 |
| 2007-08-02 | AABA-DELISTED | Stock | 22.65 | 23.7 | 22.65 | 23.36 | 19781784.0 |
| 2007-08-02 | AACC-DELISTED | Stock | 13.43 | 13.43 | 11.56 | 11.72 | 704590.0 |
| 2007-08-02 | AAI-DELISTED | Stock | 9.73 | 9.95 | 9.54 | 9.67 | 2702500.0 |
| 2007-08-02 | AAIC-DELISTED | Stock | 92.0 | 99.8 | 91.2 | 95.2 | 3655907.0 |
| 2007-08-02 | AAME | Stock | 3.12 | 3.24 | 3.04 | 3.21 | 5700.0 |
| 2007-08-02 | AAON | Stock | 4.239 | 4.3549 | 4.0823 | 4.3549 | 803419.0 |
| 2007-08-02 | AAP | Stock | 34.6 | 35.22 | 34.35 | 35.1 | 1349200.0 |
| 2007-08-02 | AATI-DELISTED | Stock | 8.59 | 8.75 | 8.45 | 8.65 | 436752.0 |
| 2007-08-02 | AAU-DELISTED | Stock | 2.5 | 2.58 | 2.49 | 2.58 | 45900.0 |
| 2007-08-02 | AAUAF-DELISTED | Stock | 2.5 | 2.58 | 2.49 | 2.58 | 45900.0 |
| 2007-08-02 | AAV-DELISTED | Stock | 12.55 | 12.59 | 12.25 | 12.4 | 476700.0 |
| 2007-08-02 | AAWW-DELISTED | Stock | 54.83 | 55.41 | 53.76 | 55.06 | 155554.0 |
| 2007-08-02 | AAXN-DELISTED | Stock | 13.9 | 15.25 | 13.07 | 14.93 | 7962002.0 |
| 2007-08-02 | AB | Stock | 83.28 | 84.62 | 83.28 | 84.53 | 283000.0 |
| 2007-08-02 | ABAX-DELISTED | Stock | 18.41 | 18.77 | 18.18 | 18.69 | 230307.0 |
| 2007-08-02 | ABB-DELISTED | Stock | 23.86 | 24.82 | 23.62 | 23.99 | 2802300.0 |
| 2007-08-02 | ABBC-DELISTED | Stock | 8.99 | 9.32 | 8.81 | 9.0 | 330706.0 |
| 2007-08-02 | ABBNY-DELISTED | Stock | 23.86 | 24.19 | 23.62 | 23.97 | 2805800.0 |
| 2007-08-02 | ABC-DELISTED | Stock | 23.37 | 23.37 | 22.86 | 22.94 | 13068800.0 |
| 2007-08-02 | ABCB | Stock | 17.8772 | 18.1787 | 17.634 | 18.1008 | 63127.0 |
| 2007-08-02 | ABCO-DELISTED | Stock | 26.39 | 27.4 | 26.29 | 27.02 | 349342.0 |
| 2007-08-02 | ABCW-DELISTED | Stock | 22.46 | 22.94 | 22.36 | 22.41 | 76190.0 |
| 2007-08-02 | ABD-DELISTED | Stock | 21.15 | 21.44 | 20.68 | 21.09 | 504510.0 |
| 2007-08-02 | ABE-DELISTED | Stock | 20.9 | 21.8 | 20.9 | 21.56 | 19700.0 |
| 2007-08-02 | ABEO | Stock | 5312.5 | 5437.5 | 5312.5 | 5437.5 | 1.0 |
| 2007-08-02 | ABFS-DELISTED | Stock | 36.96 | 38.39 | 36.77 | 37.32 | 800549.0 |
| 2007-08-02 | ABG | Stock | 21.85 | 21.97 | 21.35 | 21.84 | 802300.0 |
| 2007-08-02 | ABK-DELISTED | Stock | 63.75 | 70.35 | 53.6 | 66.65 | 5034700.0 |
| 2007-08-02 | ABM | Stock | 25.22 | 25.41 | 24.42 | 24.99 | 304800.0 |
| 2007-08-02 | ABMD-DELISTED | Stock | 10.36 | 10.99 | 10.03 | 10.96 | 315107.0 |
| 2007-08-02 | ABP-DELISTED | Stock | 3.99 | 4.09 | 3.96 | 4.04 | 133400.0 |
| 2007-08-02 | ABR | Stock | 18.52 | 19.92 | 18.52 | 19.82 | 618200.0 |
| 2007-08-02 | ABT | Stock | 24.5562 | 24.7337 | 24.3882 | 24.5706 | 13657774.0 |
| 2007-08-02 | ABTL-DELISTED | Stock | 16.275 | 16.275 | 15.624 | 15.775 | 26170.0 |
| 2007-08-02 | ABV-DELISTED | Stock | 68.5 | 69.03 | 67.18 | 67.8 | 740800.0 |
| 2007-08-02 | ABVA-DELISTED | Stock | 11.55 | 11.55 | 9.8 | 9.93 | 68456.0 |
| 2007-08-02 | ABX-DELISTED | Stock | 32.81 | 33.55 | 32.81 | 33.08 | 8047200.0 |
| 2007-08-02 | ACAD | Stock | 14.3 | 14.74 | 14.05 | 14.6 | 353500.0 |
| 2007-08-02 | ACAP-DELISTED | Stock | 38.33 | 38.36 | 37.68 | 38.0 | 93443.0 |
| 2007-08-02 | ACAS-DELISTED | Stock | 37.85 | 38.35 | 37.1 | 37.9 | 4402005.0 |
| 2007-08-02 | ACAT-DELISTED | Stock | 18.06 | 18.52 | 17.92 | 18.15 | 117205.0 |
| 2007-08-02 | ACC-DELISTED | Stock | 25.55 | 26.24 | 25.44 | 25.78 | 276900.0 |
| 2007-08-02 | ACCL-DELISTED | Stock | 6.94 | 7.07 | 6.43 | 6.85 | 307985.0 |
> showing 50 of 5,437 rows — these rows as CSV