PREVIEW / stock_daily / 2008-09-24
file: by_date/stock_daily/2008/2008-09-24.parquet size: 182 KB rows: 5,751 symbols: 3,467
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-09-24 | AAPL | Stock | 4.5454 | 4.6768 | 4.4696 | 4.5968 | 1047015200.0 |
| 2008-09-24 | MSFT | Stock | 25.58 | 26.09 | 25.46 | 25.72 | 80250300.0 |
| 2008-09-24 | NVDA | Stock | 0.2678 | 0.2868 | 0.2663 | 0.2812 | 866036000.0 |
| 2008-09-24 | AMZN | Stock | 3.615 | 3.6825 | 3.447 | 3.498 | 187448000.0 |
| 2008-09-24 | TLT | Stock | 93.97 | 94.75 | 93.6 | 94.01 | 1014891.0 |
| 2008-09-24 | CL | Stock | 37.015 | 37.505 | 36.44 | 37.405 | 4945600.0 |
| 2008-09-24 | A | Stock | 22.01 | 22.2175 | 21.6881 | 21.9886 | 4206442.0 |
| 2008-09-24 | AABA-DELISTED | Stock | 18.9 | 19.19 | 18.82 | 19.12 | 12279758.0 |
| 2008-09-24 | AACC-DELISTED | Stock | 11.67 | 12.1 | 10.95 | 11.68 | 72124.0 |
| 2008-09-24 | AACG | Stock | 9.33 | 9.55 | 9.21 | 9.48 | 16800.0 |
| 2008-09-24 | AAI-DELISTED | Stock | 2.48 | 2.6 | 2.48 | 2.54 | 1686258.0 |
| 2008-09-24 | AAIC-DELISTED | Stock | 33.4 | 36.2 | 32.4 | 32.8 | 257436.0 |
| 2008-09-24 | AAME | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 12000.0 |
| 2008-09-24 | AAON | Stock | 3.844 | 4.2015 | 3.7116 | 3.7452 | 581175.0 |
| 2008-09-24 | AAP | Stock | 39.06 | 40.26 | 38.71 | 39.54 | 1388500.0 |
| 2008-09-24 | AATI-DELISTED | Stock | 4.59 | 4.74 | 4.59 | 4.65 | 141204.0 |
| 2008-09-24 | AAU-DELISTED | Stock | 1.32 | 1.4 | 1.32 | 1.38 | 95887.0 |
| 2008-09-24 | AAUAF-DELISTED | Stock | 1.32 | 1.4 | 1.32 | 1.38 | 96887.0 |
| 2008-09-24 | AAV-DELISTED | Stock | 9.95 | 10.18 | 9.93 | 9.95 | 458965.0 |
| 2008-09-24 | AAWW-DELISTED | Stock | 48.78 | 48.78 | 45.52 | 45.68 | 212401.0 |
| 2008-09-24 | AAXJ | Stock | 43.23 | 43.4 | 43.22 | 43.24 | 11500.0 |
| 2008-09-24 | AAXN-DELISTED | Stock | 7.12 | 7.21 | 6.99 | 7.03 | 1029067.0 |
| 2008-09-24 | AB | Stock | 41.92 | 41.92 | 40.25 | 41.0 | 419700.0 |
| 2008-09-24 | ABAX-DELISTED | Stock | 19.66 | 20.14 | 19.07 | 19.2 | 228500.0 |
| 2008-09-24 | ABB-DELISTED | Stock | 21.0 | 21.01 | 20.0 | 20.42 | 5590545.0 |
| 2008-09-24 | ABBC-DELISTED | Stock | 10.15 | 10.15 | 9.75 | 9.86 | 23786.0 |
| 2008-09-24 | ABBNY-DELISTED | Stock | 21.0 | 21.01 | 20.0 | 20.39 | 7090941.0 |
| 2008-09-24 | ABC-DELISTED | Stock | 19.5 | 20.1 | 19.13 | 19.3 | 3117982.0 |
| 2008-09-24 | ABCB | Stock | 14.006 | 14.0935 | 13.1695 | 13.6462 | 13880.0 |
| 2008-09-24 | ABCO-DELISTED | Stock | 15.847 | 16.542 | 15.573 | 15.708 | 260030.0 |
| 2008-09-24 | ABCW-DELISTED | Stock | 8.715 | 8.715 | 8.372 | 8.47 | 159300.0 |
| 2008-09-24 | ABD-DELISTED | Stock | 8.61 | 8.62 | 7.87 | 7.93 | 457120.0 |
| 2008-09-24 | ABE-DELISTED | Stock | 15.7 | 16.0 | 15.39 | 15.46 | 23999.0 |
| 2008-09-24 | ABEO | Stock | 3875.0 | 3875.0 | 3650.0 | 3650.0 | 15.0 |
| 2008-09-24 | ABFS-DELISTED | Stock | 36.63 | 37.13 | 35.71 | 35.75 | 738509.0 |
| 2008-09-24 | ABG | Stock | 12.4 | 12.78 | 12.25 | 12.54 | 202600.0 |
| 2008-09-24 | ABII-DELISTED | Stock | 67.2 | 67.2 | 62.26 | 63.57 | 38258.0 |
| 2008-09-24 | ABK-DELISTED | Stock | 3.7 | 3.71 | 3.0 | 3.08 | 19770432.0 |
| 2008-09-24 | ABM | Stock | 22.07 | 22.25 | 21.16 | 21.19 | 252800.0 |
| 2008-09-24 | ABMD-DELISTED | Stock | 18.47 | 18.9 | 18.31 | 18.46 | 193886.0 |
| 2008-09-24 | ABR | Stock | 9.4 | 9.79 | 9.4 | 9.47 | 104800.0 |
| 2008-09-24 | ABT | Stock | 28.0923 | 28.409 | 27.9867 | 28.2362 | 15004377.0 |
| 2008-09-24 | ABTL-DELISTED | Stock | 5.25 | 5.25 | 4.85 | 5.1 | 8020.0 |
| 2008-09-24 | ABV-DELISTED | Stock | 55.82 | 55.96 | 54.71 | 55.13 | 368142.0 |
| 2008-09-24 | ABVA-DELISTED | Stock | 3.99 | 3.99 | 3.967 | 3.99 | 1700.0 |
| 2008-09-24 | ABX-DELISTED | Stock | 38.24 | 38.95 | 37.13 | 38.5 | 15242273.0 |
| 2008-09-24 | ACAD | Stock | 2.64 | 3.03 | 2.6 | 2.86 | 158000.0 |
| 2008-09-24 | ACAP-DELISTED | Stock | 42.97 | 43.64 | 41.5 | 41.76 | 60812.0 |
| 2008-09-24 | ACAS-DELISTED | Stock | 27.5 | 27.5 | 25.75 | 26.16 | 3340270.0 |
| 2008-09-24 | ACAT-DELISTED | Stock | 9.4 | 9.87 | 9.11 | 9.82 | 71177.0 |
> showing 50 of 5,751 rows — these rows as CSV