PREVIEW / stock_daily / 2008-07-01
file: by_date/stock_daily/2008/2008-07-01.parquet size: 185 KB rows: 5,751 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-07-01 | AAPL | Stock | 5.8654 | 6.24 | 5.8571 | 6.2386 | 1111280800.0 |
| 2008-07-01 | MSFT | Stock | 27.27 | 27.38 | 26.44 | 26.87 | 100327800.0 |
| 2008-07-01 | NVDA | Stock | 0.4625 | 0.4692 | 0.454 | 0.4688 | 881464000.0 |
| 2008-07-01 | AMZN | Stock | 3.612 | 3.7115 | 3.526 | 3.681 | 205850000.0 |
| 2008-07-01 | TLT | Stock | 92.69 | 92.7701 | 91.68 | 91.79 | 3805099.0 |
| 2008-07-01 | CL | Stock | 34.215 | 34.705 | 34.01 | 34.7 | 6148200.0 |
| 2008-07-01 | A | Stock | 25.0644 | 25.5866 | 24.9857 | 25.4435 | 4520713.0 |
| 2008-07-01 | AABA-DELISTED | Stock | 20.48 | 20.49 | 19.59 | 20.19 | 35811172.0 |
| 2008-07-01 | AACC-DELISTED | Stock | 12.23 | 12.44 | 11.82 | 12.25 | 244979.0 |
| 2008-07-01 | AACG | Stock | 12.93 | 13.06 | 12.29 | 12.42 | 76800.0 |
| 2008-07-01 | AAI-DELISTED | Stock | 2.01 | 2.08 | 1.93 | 2.01 | 4366929.0 |
| 2008-07-01 | AAIC-DELISTED | Stock | 30.0 | 31.0 | 29.0 | 30.4 | 628566.0 |
| 2008-07-01 | AAME | Stock | 1.62 | 1.62 | 1.6 | 1.6 | 7100.0 |
| 2008-07-01 | AAON | Stock | 3.7373 | 3.7985 | 3.6425 | 3.7886 | 584719.0 |
| 2008-07-01 | AAP | Stock | 38.32 | 39.07 | 37.4 | 39.07 | 2323700.0 |
| 2008-07-01 | AATI-DELISTED | Stock | 4.02 | 4.22 | 4.0 | 4.11 | 1001866.0 |
| 2008-07-01 | AAU-DELISTED | Stock | 1.55 | 1.78 | 1.42 | 1.71 | 65488.0 |
| 2008-07-01 | AAUAF-DELISTED | Stock | 1.62 | 1.88 | 1.5 | 1.71 | 63775.0 |
| 2008-07-01 | AAV-DELISTED | Stock | 12.8 | 12.89 | 12.63 | 12.78 | 389986.0 |
| 2008-07-01 | AAWW-DELISTED | Stock | 47.89 | 49.12 | 46.7 | 46.96 | 599655.0 |
| 2008-07-01 | AAXN-DELISTED | Stock | 4.91 | 5.14 | 4.8909 | 5.14 | 1302695.0 |
| 2008-07-01 | AB | Stock | 54.28 | 54.94 | 52.46 | 54.88 | 828200.0 |
| 2008-07-01 | ABAX-DELISTED | Stock | 24.0 | 24.41 | 23.11 | 24.25 | 567700.0 |
| 2008-07-01 | ABB-DELISTED | Stock | 27.54 | 27.99 | 27.22 | 27.95 | 5693863.0 |
| 2008-07-01 | ABBC-DELISTED | Stock | 9.15 | 9.55 | 9.06 | 9.4 | 95883.0 |
| 2008-07-01 | ABBNY-DELISTED | Stock | 27.54 | 27.99 | 27.22 | 27.97 | 5714763.0 |
| 2008-07-01 | ABC-DELISTED | Stock | 19.78 | 19.97 | 19.56 | 19.71 | 2118694.0 |
| 2008-07-01 | ABCB | Stock | 8.3842 | 8.958 | 8.3842 | 8.7246 | 75567.0 |
| 2008-07-01 | ABCO-DELISTED | Stock | 19.535 | 20.19 | 19.53 | 20.04 | 336078.0 |
| 2008-07-01 | ABCW-DELISTED | Stock | 6.9 | 7.3 | 6.12 | 6.65 | 504210.0 |
| 2008-07-01 | ABD-DELISTED | Stock | 11.09 | 11.19 | 10.63 | 11.05 | 425020.0 |
| 2008-07-01 | ABE-DELISTED | Stock | 20.26 | 20.26 | 19.75 | 19.9 | 19571.0 |
| 2008-07-01 | ABEO | Stock | 3625.0 | 4000.0 | 3625.0 | 3750.0 | 18.0 |
| 2008-07-01 | ABFS-DELISTED | Stock | 35.34 | 36.95 | 35.14 | 36.82 | 869487.0 |
| 2008-07-01 | ABG | Stock | 12.7 | 13.12 | 12.48 | 12.91 | 392100.0 |
| 2008-07-01 | ABII-DELISTED | Stock | 62.15 | 63.47 | 62.0 | 62.31 | 12901.0 |
| 2008-07-01 | ABK-DELISTED | Stock | 1.31 | 1.39 | 1.13 | 1.18 | 18849254.0 |
| 2008-07-01 | ABM | Stock | 21.93 | 22.39 | 21.72 | 22.26 | 198200.0 |
| 2008-07-01 | ABMD-DELISTED | Stock | 17.51 | 17.6 | 17.26 | 17.5 | 362273.0 |
| 2008-07-01 | ABP-DELISTED | Stock | 5.4 | 5.45 | 5.15 | 5.3 | 630287.0 |
| 2008-07-01 | ABR | Stock | 9.0 | 9.28 | 8.73 | 9.02 | 287100.0 |
| 2008-07-01 | ABT | Stock | 25.2855 | 26.0435 | 25.2519 | 26.01 | 16509587.0 |
| 2008-07-01 | ABTL-DELISTED | Stock | 6.8248 | 6.9754 | 6.5237 | 6.9252 | 13973.0 |
| 2008-07-01 | ABV-DELISTED | Stock | 61.9 | 62.63 | 60.71 | 61.5 | 885288.0 |
| 2008-07-01 | ABVA-DELISTED | Stock | 3.68 | 3.68 | 3.68 | 3.68 | 500.0 |
| 2008-07-01 | ABX-DELISTED | Stock | 46.4 | 46.98 | 45.99 | 46.38 | 11119273.0 |
| 2008-07-01 | ACAD | Stock | 3.64 | 3.66 | 3.4 | 3.46 | 372400.0 |
| 2008-07-01 | ACAP-DELISTED | Stock | 47.89 | 48.44 | 47.61 | 47.83 | 52312.0 |
| 2008-07-01 | ACAS-DELISTED | Stock | 22.94 | 23.88 | 22.57 | 23.59 | 6266507.0 |
| 2008-07-01 | ACAT-DELISTED | Stock | 7.84 | 8.05 | 7.69 | 8.01 | 201167.0 |
> showing 50 of 5,751 rows — these rows as CSV