PREVIEW / stock_daily / 2008-10-02
file: by_date/stock_daily/2008/2008-10-02.parquet size: 181 KB rows: 5,775 symbols: 3,481
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-02 | AAPL | Stock | 3.8575 | 3.8854 | 3.5714 | 3.575 | 1609364400.0 |
| 2008-10-02 | MSFT | Stock | 26.18 | 26.53 | 25.7 | 26.25 | 93819800.0 |
| 2008-10-02 | NVDA | Stock | 0.262 | 0.262 | 0.232 | 0.2332 | 787728000.0 |
| 2008-10-02 | AMZN | Stock | 3.3815 | 3.448 | 3.2705 | 3.368 | 174522000.0 |
| 2008-10-02 | TLT | Stock | 96.57 | 96.845 | 96.068 | 96.55 | 931832.0 |
| 2008-10-02 | CL | Stock | 38.0 | 38.735 | 37.34 | 38.38 | 10684600.0 |
| 2008-10-02 | A | Stock | 20.9728 | 21.03 | 20.0572 | 20.1288 | 4544199.0 |
| 2008-10-02 | AABA-DELISTED | Stock | 16.77 | 16.85 | 15.54 | 15.54 | 23227063.0 |
| 2008-10-02 | AACC-DELISTED | Stock | 11.0 | 11.6 | 10.55 | 10.98 | 52355.0 |
| 2008-10-02 | AACG | Stock | 8.65 | 8.75 | 8.5 | 8.7 | 33200.0 |
| 2008-10-02 | AAI-DELISTED | Stock | 2.74 | 2.81 | 2.43 | 2.46 | 2186328.0 |
| 2008-10-02 | AAIC-DELISTED | Stock | 33.0 | 33.4 | 29.4 | 29.4 | 515191.0 |
| 2008-10-02 | AAME | Stock | 1.35 | 1.35 | 1.34 | 1.34 | 4400.0 |
| 2008-10-02 | AAON | Stock | 3.684 | 3.7531 | 3.5101 | 3.5121 | 628256.0 |
| 2008-10-02 | AAP | Stock | 39.77 | 40.53 | 38.11 | 38.89 | 2071400.0 |
| 2008-10-02 | AATI-DELISTED | Stock | 4.4 | 4.44 | 4.14 | 4.14 | 193975.0 |
| 2008-10-02 | AAU-DELISTED | Stock | 1.35 | 1.35 | 0.99 | 0.99 | 69003.0 |
| 2008-10-02 | AAUAF-DELISTED | Stock | 1.35 | 1.35 | 0.99 | 0.99 | 69503.0 |
| 2008-10-02 | AAV-DELISTED | Stock | 8.82 | 8.94 | 8.23 | 8.23 | 1082576.0 |
| 2008-10-02 | AAWW-DELISTED | Stock | 37.89 | 38.56 | 34.5 | 34.66 | 303814.0 |
| 2008-10-02 | AAXJ | Stock | 41.06 | 41.09 | 40.701 | 40.701 | 19500.0 |
| 2008-10-02 | AAXN-DELISTED | Stock | 6.87 | 7.0 | 6.65 | 6.95 | 1123662.0 |
| 2008-10-02 | AB | Stock | 36.5 | 38.9 | 34.63 | 34.7 | 435100.0 |
| 2008-10-02 | ABAX-DELISTED | Stock | 19.5 | 20.43 | 18.75 | 18.93 | 201481.0 |
| 2008-10-02 | ABB-DELISTED | Stock | 18.57 | 18.59 | 17.69 | 17.84 | 6510782.0 |
| 2008-10-02 | ABBC-DELISTED | Stock | 9.92 | 10.03 | 9.65 | 9.98 | 35415.0 |
| 2008-10-02 | ABBNY-DELISTED | Stock | 18.57 | 18.59 | 17.69 | 17.82 | 6575924.0 |
| 2008-10-02 | ABC-DELISTED | Stock | 18.42 | 18.72 | 18.1 | 18.12 | 2908656.0 |
| 2008-10-02 | ABCB | Stock | 13.4516 | 13.617 | 13.0042 | 13.5002 | 8842.0 |
| 2008-10-02 | ABCO-DELISTED | Stock | 14.918 | 15.452 | 14.783 | 15.077 | 188280.0 |
| 2008-10-02 | ABCW-DELISTED | Stock | 7.61 | 8.45 | 7.61 | 7.62 | 156700.0 |
| 2008-10-02 | ABD-DELISTED | Stock | 7.22 | 7.26 | 6.79 | 6.88 | 329910.0 |
| 2008-10-02 | ABE-DELISTED | Stock | 15.36 | 15.548 | 15.01 | 15.01 | 20441.0 |
| 2008-10-02 | ABEO | Stock | 3375.0 | 3437.5 | 3375.0 | 3437.5 | 7.0 |
| 2008-10-02 | ABFS-DELISTED | Stock | 32.74 | 33.0 | 29.1 | 29.22 | 1591416.0 |
| 2008-10-02 | ABG | Stock | 10.85 | 11.05 | 8.97 | 9.24 | 598800.0 |
| 2008-10-02 | ABII-DELISTED | Stock | 66.21 | 68.75 | 66.21 | 67.62 | 9548.0 |
| 2008-10-02 | ABK-DELISTED | Stock | 3.66 | 4.15 | 3.19 | 3.19 | 23528844.0 |
| 2008-10-02 | ABM | Stock | 21.15 | 21.59 | 20.65 | 20.76 | 226900.0 |
| 2008-10-02 | ABMD-DELISTED | Stock | 17.81 | 18.02 | 17.35 | 17.54 | 236994.0 |
| 2008-10-02 | ABR | Stock | 9.87 | 10.1 | 9.25 | 9.4 | 128700.0 |
| 2008-10-02 | ABT | Stock | 27.7708 | 28.7544 | 27.7564 | 28.2602 | 25022718.0 |
| 2008-10-02 | ABTL-DELISTED | Stock | 4.6529 | 5.3106 | 4.6468 | 4.8 | 10138.0 |
| 2008-10-02 | ABV-DELISTED | Stock | 54.52 | 57.09 | 50.0 | 50.44 | 752697.0 |
| 2008-10-02 | ABVA-DELISTED | Stock | 3.95 | 3.95 | 3.38 | 3.38 | 3950.0 |
| 2008-10-02 | ABVT-DELISTED | Stock | 54.0 | 54.0 | 51.0 | 51.0 | 5959.0 |
| 2008-10-02 | ABX-DELISTED | Stock | 36.15 | 36.32 | 31.83 | 31.93 | 25835270.0 |
| 2008-10-02 | ACAD | Stock | 2.67 | 2.89 | 2.5 | 2.5 | 206200.0 |
| 2008-10-02 | ACAP-DELISTED | Stock | 42.14 | 43.85 | 41.05 | 42.17 | 87482.0 |
| 2008-10-02 | ACAS-DELISTED | Stock | 24.85 | 24.85 | 22.62 | 23.12 | 3141428.0 |
> showing 50 of 5,775 rows — these rows as CSV