PREVIEW / stock_daily / 2008-09-19
file: by_date/stock_daily/2008/2008-09-19.parquet size: 185 KB rows: 5,828 symbols: 3,515
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-19 | AAPL | Stock | 5.0929 | 5.15 | 4.8682 | 5.0325 | 1430875600.0 |
| 2008-09-19 | MSFT | Stock | 26.37 | 26.4 | 23.5 | 25.16 | 134926100.0 |
| 2008-09-19 | NVDA | Stock | 0.2852 | 0.2875 | 0.2725 | 0.2852 | 1107344000.0 |
| 2008-09-19 | AMZN | Stock | 4.006 | 4.3385 | 3.825 | 4.05 | 295444000.0 |
| 2008-09-19 | TLT | Stock | 93.86 | 95.02 | 93.7 | 93.7 | 7169172.0 |
| 2008-09-19 | CL | Stock | 38.53 | 39.07 | 37.44 | 37.855 | 11386200.0 |
| 2008-09-19 | A | Stock | 22.897 | 23.6052 | 22.7039 | 23.5408 | 4986247.0 |
| 2008-09-19 | AABA-DELISTED | Stock | 20.7 | 20.79 | 19.27 | 19.9 | 30695915.0 |
| 2008-09-19 | AACC-DELISTED | Stock | 12.5 | 13.38 | 12.13 | 13.1 | 460456.0 |
| 2008-09-19 | AACG | Stock | 10.03 | 10.5 | 10.0 | 10.48 | 18500.0 |
| 2008-09-19 | AAI-DELISTED | Stock | 2.83 | 2.94 | 2.68 | 2.75 | 4248567.0 |
| 2008-09-19 | AAIC-DELISTED | Stock | 42.2 | 45.0 | 32.4 | 39.6 | 2697686.0 |
| 2008-09-19 | AAME | Stock | 1.5 | 1.5 | 1.31 | 1.35 | 2800.0 |
| 2008-09-19 | AAON | Stock | 4.0928 | 4.4405 | 4.0928 | 4.2469 | 1588106.0 |
| 2008-09-19 | AAP | Stock | 40.02 | 42.06 | 38.69 | 39.07 | 2178900.0 |
| 2008-09-19 | AATI-DELISTED | Stock | 4.92 | 4.99 | 4.74 | 4.9 | 1283831.0 |
| 2008-09-19 | AAU-DELISTED | Stock | 1.2 | 1.4 | 1.15 | 1.25 | 83034.0 |
| 2008-09-19 | AAUAF-DELISTED | Stock | 1.2 | 1.4 | 1.15 | 1.25 | 83064.0 |
| 2008-09-19 | AAV-DELISTED | Stock | 9.55 | 9.85 | 9.45 | 9.7 | 784055.0 |
| 2008-09-19 | AAWW-DELISTED | Stock | 52.42 | 52.42 | 48.83 | 51.19 | 395797.0 |
| 2008-09-19 | AAXJ | Stock | 44.51 | 46.23 | 44.51 | 46.19 | 3662.0 |
| 2008-09-19 | AAXN-DELISTED | Stock | 7.4 | 7.63 | 6.71 | 7.23 | 2443250.0 |
| 2008-09-19 | AB | Stock | 40.75 | 40.75 | 39.2 | 40.75 | 15400.0 |
| 2008-09-19 | ABAX-DELISTED | Stock | 21.35 | 22.85 | 20.73 | 21.67 | 916895.0 |
| 2008-09-19 | ABB-DELISTED | Stock | 21.45 | 22.04 | 20.95 | 21.94 | 10127420.0 |
| 2008-09-19 | ABBC-DELISTED | Stock | 12.23 | 12.4 | 9.98 | 10.4 | 344734.0 |
| 2008-09-19 | ABBNY-DELISTED | Stock | 21.45 | 22.0391 | 20.95 | 21.97 | 10166292.0 |
| 2008-09-19 | ABC-DELISTED | Stock | 20.5 | 20.51 | 19.12 | 19.73 | 4902530.0 |
| 2008-09-19 | ABCB | Stock | 15.8346 | 15.8346 | 12.0899 | 14.6577 | 2365.0 |
| 2008-09-19 | ABCO-DELISTED | Stock | 16.07 | 17.445 | 15.805 | 16.49 | 942607.0 |
| 2008-09-19 | ABCW-DELISTED | Stock | 10.94 | 13.91 | 8.18 | 9.06 | 836300.0 |
| 2008-09-19 | ABD-DELISTED | Stock | 9.245 | 10.038 | 8.321 | 9.455 | 472890.0 |
| 2008-09-19 | ABE-DELISTED | Stock | 16.67 | 16.908 | 15.78 | 16.33 | 61627.0 |
| 2008-09-19 | ABEO | Stock | 3750.0 | 4125.0 | 3700.0 | 3812.5 | 52.0 |
| 2008-09-19 | ABFS-DELISTED | Stock | 41.66 | 43.28 | 38.88 | 39.97 | 1532393.0 |
| 2008-09-19 | ABG | Stock | 14.02 | 14.22 | 13.36 | 13.71 | 718500.0 |
| 2008-09-19 | ABII-DELISTED | Stock | 70.19 | 72.99 | 65.015 | 72.2 | 76080.0 |
| 2008-09-19 | ABK-DELISTED | Stock | 8.31 | 8.59 | 4.18 | 4.26 | 62792263.0 |
| 2008-09-19 | ABM | Stock | 23.01 | 24.36 | 22.15 | 22.35 | 989800.0 |
| 2008-09-19 | ABMD-DELISTED | Stock | 18.65 | 19.0 | 17.98 | 18.9 | 1299147.0 |
| 2008-09-19 | ABR | Stock | 10.21 | 11.73 | 9.72 | 10.41 | 671800.0 |
| 2008-09-19 | ABT | Stock | 28.3034 | 28.5913 | 27.7084 | 28.1691 | 22835140.0 |
| 2008-09-19 | ABTL-DELISTED | Stock | 4.951 | 5.1042 | 4.849 | 4.9 | 11569.0 |
| 2008-09-19 | ABV-DELISTED | Stock | 54.54 | 68.51 | 54.54 | 58.15 | 1385398.0 |
| 2008-09-19 | ABVA-DELISTED | Stock | 3.75 | 3.75 | 3.05 | 3.21 | 5505.0 |
| 2008-09-19 | ABVT-DELISTED | Stock | 51.0 | 54.03 | 51.0 | 54.03 | 656.0 |
| 2008-09-19 | ABX-DELISTED | Stock | 31.83 | 35.21 | 31.79 | 35.1 | 18411250.0 |
| 2008-09-19 | ACAD | Stock | 3.11 | 3.19 | 2.46 | 3.15 | 668000.0 |
| 2008-09-19 | ACAP-DELISTED | Stock | 48.0 | 48.0 | 44.72 | 45.65 | 195476.0 |
| 2008-09-19 | ACAS-DELISTED | Stock | 26.94 | 27.226 | 20.488 | 25.75 | 9686822.0 |
> showing 50 of 5,828 rows — these rows as CSV