PREVIEW / stock_daily / 2008-07-28
file: by_date/stock_daily/2008/2008-07-28.parquet size: 182 KB rows: 5,711 symbols: 3,438
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-28 | AAPL | Stock | 5.7979 | 5.8025 | 5.5007 | 5.5143 | 780712800.0 |
| 2008-07-28 | MSFT | Stock | 26.06 | 26.11 | 25.34 | 25.5 | 59707800.0 |
| 2008-07-28 | NVDA | Stock | 0.2852 | 0.2978 | 0.284 | 0.2882 | 734808000.0 |
| 2008-07-28 | AMZN | Stock | 3.8545 | 3.9155 | 3.743 | 3.799 | 209604000.0 |
| 2008-07-28 | TLT | Stock | 90.95 | 91.47 | 90.7 | 91.05 | 1275867.0 |
| 2008-07-28 | CL | Stock | 34.655 | 34.835 | 34.28 | 34.28 | 4475200.0 |
| 2008-07-28 | A | Stock | 25.8798 | 26.0443 | 25.6223 | 25.6295 | 3265868.0 |
| 2008-07-28 | AABA-DELISTED | Stock | 21.02 | 21.17 | 20.06 | 20.13 | 13696863.0 |
| 2008-07-28 | AACC-DELISTED | Stock | 11.48 | 11.69 | 11.13 | 11.22 | 83872.0 |
| 2008-07-28 | AACG | Stock | 14.78 | 15.0 | 14.0 | 15.0 | 86200.0 |
| 2008-07-28 | AAI-DELISTED | Stock | 2.69 | 2.96 | 2.64 | 2.71 | 2621270.0 |
| 2008-07-28 | AAIC-DELISTED | Stock | 36.8 | 38.0 | 33.4 | 35.2 | 743712.0 |
| 2008-07-28 | AAME | Stock | 1.45 | 1.48 | 1.45 | 1.48 | 1500.0 |
| 2008-07-28 | AAON | Stock | 3.7235 | 3.7511 | 3.5062 | 3.5812 | 438412.0 |
| 2008-07-28 | AAP | Stock | 40.14 | 40.5 | 39.4 | 39.93 | 870000.0 |
| 2008-07-28 | AATI-DELISTED | Stock | 4.54 | 4.6 | 4.2 | 4.28 | 373388.0 |
| 2008-07-28 | AAU-DELISTED | Stock | 1.95 | 1.95 | 1.82 | 1.84 | 62792.0 |
| 2008-07-28 | AAUAF-DELISTED | Stock | 1.95 | 1.95 | 1.82 | 1.8399 | 62992.0 |
| 2008-07-28 | AAV-DELISTED | Stock | 11.07 | 11.32 | 11.0 | 11.09 | 514447.0 |
| 2008-07-28 | AAWW-DELISTED | Stock | 49.46 | 49.46 | 47.29 | 47.72 | 140002.0 |
| 2008-07-28 | AAXN-DELISTED | Stock | 5.15 | 5.16 | 4.98 | 5.04 | 1269053.0 |
| 2008-07-28 | AB | Stock | 49.8 | 50.72 | 48.36 | 48.77 | 311600.0 |
| 2008-07-28 | ABAX-DELISTED | Stock | 19.87 | 20.36 | 19.06 | 19.4 | 693819.0 |
| 2008-07-28 | ABB-DELISTED | Stock | 26.8 | 26.82 | 25.95 | 26.03 | 4829667.0 |
| 2008-07-28 | ABBC-DELISTED | Stock | 9.9 | 10.04 | 9.56 | 9.74 | 30086.0 |
| 2008-07-28 | ABBNY-DELISTED | Stock | 26.8 | 26.82 | 25.95 | 26.06 | 4857563.0 |
| 2008-07-28 | ABC-DELISTED | Stock | 21.08 | 21.22 | 20.75 | 20.75 | 2096070.0 |
| 2008-07-28 | ABCB | Stock | 10.5921 | 10.5921 | 9.8821 | 10.0085 | 28479.0 |
| 2008-07-28 | ABCO-DELISTED | Stock | 18.387 | 18.507 | 17.868 | 18.043 | 472669.0 |
| 2008-07-28 | ABCW-DELISTED | Stock | 7.41 | 7.49 | 6.86 | 6.94 | 197630.0 |
| 2008-07-28 | ABD-DELISTED | Stock | 8.4 | 8.45 | 8.258 | 8.35 | 354390.0 |
| 2008-07-28 | ABE-DELISTED | Stock | 19.3 | 19.743 | 19.3 | 19.556 | 26365.0 |
| 2008-07-28 | ABEO | Stock | 3812.5 | 3812.5 | 3625.0 | 3625.0 | 13.0 |
| 2008-07-28 | ABFS-DELISTED | Stock | 33.38 | 33.98 | 33.2 | 33.66 | 665485.0 |
| 2008-07-28 | ABG | Stock | 12.2 | 12.27 | 11.52 | 11.61 | 300200.0 |
| 2008-07-28 | ABII-DELISTED | Stock | 73.12 | 73.12 | 70.686 | 73.01 | 22178.0 |
| 2008-07-28 | ABK-DELISTED | Stock | 2.27 | 2.27 | 1.75 | 1.75 | 12008177.0 |
| 2008-07-28 | ABM | Stock | 23.49 | 23.75 | 23.18 | 23.5 | 259300.0 |
| 2008-07-28 | ABMD-DELISTED | Stock | 20.04 | 20.04 | 19.15 | 19.34 | 245406.0 |
| 2008-07-28 | ABR | Stock | 10.69 | 11.86 | 10.69 | 11.34 | 246100.0 |
| 2008-07-28 | ABT | Stock | 27.435 | 27.435 | 26.9024 | 26.9696 | 12824719.0 |
| 2008-07-28 | ABTL-DELISTED | Stock | 5.9 | 6.05 | 5.7 | 5.75 | 4478.0 |
| 2008-07-28 | ABV-DELISTED | Stock | 58.42 | 58.53 | 57.04 | 57.24 | 409174.0 |
| 2008-07-28 | ABVA-DELISTED | Stock | 3.25 | 3.25 | 3.0 | 3.0 | 32675.0 |
| 2008-07-28 | ABX-DELISTED | Stock | 43.87 | 45.26 | 43.1 | 44.26 | 6175196.0 |
| 2008-07-28 | ACAD | Stock | 3.47 | 3.5 | 3.3 | 3.31 | 172700.0 |
| 2008-07-28 | ACAP-DELISTED | Stock | 47.7 | 48.0425 | 47.42 | 47.59 | 37389.0 |
| 2008-07-28 | ACAS-DELISTED | Stock | 21.99 | 21.99 | 19.81 | 19.82 | 3348080.0 |
| 2008-07-28 | ACAT-DELISTED | Stock | 9.14 | 9.3654 | 8.9 | 9.14 | 228417.0 |
| 2008-07-28 | ACC-DELISTED | Stock | 29.25 | 29.84 | 28.9 | 29.1 | 158933.0 |
> showing 50 of 5,711 rows — these rows as CSV