PREVIEW / stock_daily / 2008-11-24
file: by_date/stock_daily/2008/2008-11-24.parquet size: 175 KB rows: 5,811 symbols: 3,497
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-11-24 | AAPL | Stock | 3.0432 | 3.3854 | 3.03 | 3.3196 | 1442257600.0 |
| 2008-11-24 | MSFT | Stock | 19.89 | 20.94 | 19.87 | 20.69 | 125289900.0 |
| 2008-11-24 | NVDA | Stock | 0.1693 | 0.172 | 0.16 | 0.17 | 600308000.0 |
| 2008-11-24 | AMZN | Stock | 1.9395 | 2.172 | 1.935 | 2.125 | 290994000.0 |
| 2008-11-24 | TLT | Stock | 102.15 | 102.2922 | 101.0 | 101.31 | 1587214.0 |
| 2008-11-24 | CL | Stock | 31.41 | 32.465 | 31.165 | 31.945 | 10444400.0 |
| 2008-11-24 | A | Stock | 12.5179 | 13.7411 | 12.289 | 13.3119 | 4996312.0 |
| 2008-11-24 | AABA-DELISTED | Stock | 9.56 | 10.27 | 9.42 | 10.21 | 22321415.0 |
| 2008-11-24 | AACC-DELISTED | Stock | 5.24 | 5.86 | 5.07 | 5.5 | 194874.0 |
| 2008-11-24 | AACG | Stock | 6.17 | 6.2 | 4.41 | 5.51 | 33300.0 |
| 2008-11-24 | AAI-DELISTED | Stock | 2.71 | 2.99 | 2.69 | 2.77 | 3023624.0 |
| 2008-11-24 | AAIC-DELISTED | Stock | 6.8 | 6.8 | 3.8 | 6.2 | 610889.0 |
| 2008-11-24 | AAME | Stock | 1.2 | 1.2 | 1.2 | 1.2 | 400.0 |
| 2008-11-24 | AAON | Stock | 3.196 | 3.4588 | 3.1644 | 3.4291 | 1031737.0 |
| 2008-11-24 | AAP | Stock | 27.0 | 28.74 | 26.23 | 28.17 | 1695700.0 |
| 2008-11-24 | AATI-DELISTED | Stock | 2.0 | 2.1201 | 1.9 | 1.98 | 1314364.0 |
| 2008-11-24 | AAU-DELISTED | Stock | 0.45 | 0.56 | 0.43 | 0.5 | 197108.0 |
| 2008-11-24 | AAUAF-DELISTED | Stock | 0.45 | 0.56 | 0.43 | 0.5 | 212148.0 |
| 2008-11-24 | AAV-DELISTED | Stock | 4.67 | 5.12 | 4.65 | 5.05 | 1249361.0 |
| 2008-11-24 | AAWW-DELISTED | Stock | 10.04 | 12.66 | 9.6 | 12.52 | 536574.0 |
| 2008-11-24 | AAXJ | Stock | 28.59 | 30.05 | 27.81 | 29.46 | 207524.0 |
| 2008-11-24 | AAXN-DELISTED | Stock | 3.18 | 3.72 | 3.0 | 3.68 | 1779697.0 |
| 2008-11-24 | AB | Stock | 13.5 | 15.25 | 13.39 | 14.95 | 715800.0 |
| 2008-11-24 | ABAX-DELISTED | Stock | 12.69 | 14.23 | 11.66 | 14.0 | 291287.0 |
| 2008-11-24 | ABB-DELISTED | Stock | 10.6 | 11.4 | 10.46 | 11.12 | 6373658.0 |
| 2008-11-24 | ABBC-DELISTED | Stock | 9.75 | 10.33 | 9.26 | 10.25 | 212087.0 |
| 2008-11-24 | ABBNY-DELISTED | Stock | 10.6 | 11.4 | 10.46 | 11.12 | 6373873.0 |
| 2008-11-24 | ABC-DELISTED | Stock | 14.8 | 15.19 | 14.64 | 14.86 | 5715274.0 |
| 2008-11-24 | ABCB | Stock | 8.7732 | 8.958 | 8.2675 | 8.8024 | 25806.0 |
| 2008-11-24 | ABCO-DELISTED | Stock | 10.12 | 11.25 | 10.01 | 11.185 | 264176.0 |
| 2008-11-24 | ABCW-DELISTED | Stock | 2.53 | 2.58 | 2.14 | 2.44 | 138450.0 |
| 2008-11-24 | ABD-DELISTED | Stock | 1.07 | 1.09 | 0.95 | 0.99 | 507220.0 |
| 2008-11-24 | ABE-DELISTED | Stock | 10.91 | 11.25 | 10.91 | 11.17 | 279398.0 |
| 2008-11-24 | ABEO | Stock | 1375.0 | 1375.0 | 1000.0 | 1250.0 | 14.0 |
| 2008-11-24 | ABFS-DELISTED | Stock | 22.54 | 25.5 | 22.32 | 25.0 | 642539.0 |
| 2008-11-24 | ABG | Stock | 3.71 | 3.71 | 3.27 | 3.39 | 499300.0 |
| 2008-11-24 | ABII-DELISTED | Stock | 50.45 | 52.72 | 48.84 | 51.4 | 15369.0 |
| 2008-11-24 | ABK-DELISTED | Stock | 1.32 | 1.42 | 1.17 | 1.36 | 15173304.0 |
| 2008-11-24 | ABM | Stock | 14.65 | 16.01 | 14.32 | 15.73 | 285300.0 |
| 2008-11-24 | ABMD-DELISTED | Stock | 12.08 | 13.09 | 12.0 | 13.0 | 375519.0 |
| 2008-11-24 | ABR | Stock | 1.9 | 2.04 | 1.81 | 1.94 | 227300.0 |
| 2008-11-24 | ABT | Stock | 24.9256 | 24.9256 | 24.1771 | 24.3642 | 30187578.0 |
| 2008-11-24 | ABTL-DELISTED | Stock | 2.5 | 2.625 | 2.5 | 2.6 | 106090.0 |
| 2008-11-24 | ABV-DELISTED | Stock | 44.92 | 45.82 | 43.75 | 45.08 | 1326968.0 |
| 2008-11-24 | ABVA-DELISTED | Stock | 2.33 | 2.88 | 2.32 | 2.38 | 10500.0 |
| 2008-11-24 | ABVT-DELISTED | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 300.0 |
| 2008-11-24 | ABX-DELISTED | Stock | 28.51 | 29.7 | 27.74 | 28.12 | 21061774.0 |
| 2008-11-24 | ACAD | Stock | 0.88 | 1.05 | 0.88 | 1.0 | 339800.0 |
| 2008-11-24 | ACAP-DELISTED | Stock | 33.08 | 34.85 | 32.18 | 33.97 | 128303.0 |
| 2008-11-24 | ACAS-DELISTED | Stock | 4.31 | 4.6502 | 4.3 | 4.63 | 6875956.0 |
> showing 50 of 5,811 rows — these rows as CSV