PREVIEW / stock_daily / 2008-10-14
file: by_date/stock_daily/2008/2008-10-14.parquet size: 180 KB rows: 5,831 symbols: 3,514
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-10-14 | AAPL | Stock | 4.1521 | 4.1571 | 3.6836 | 3.7171 | 1980994400.0 |
| 2008-10-14 | MSFT | Stock | 25.64 | 25.73 | 23.6 | 24.1 | 165674900.0 |
| 2008-10-14 | NVDA | Stock | 0.2088 | 0.21 | 0.1913 | 0.1968 | 1209012000.0 |
| 2008-10-14 | AMZN | Stock | 3.175 | 3.2 | 2.74 | 2.793 | 346132000.0 |
| 2008-10-14 | TLT | Stock | 94.25 | 95.26 | 93.9 | 94.11 | 2099972.0 |
| 2008-10-14 | CL | Stock | 34.375 | 34.5 | 31.32 | 32.0 | 13569000.0 |
| 2008-10-14 | A | Stock | 18.9628 | 19.6638 | 17.1531 | 17.6037 | 5027068.0 |
| 2008-10-14 | AABA-DELISTED | Stock | 13.77 | 13.93 | 12.37 | 12.65 | 26510966.0 |
| 2008-10-14 | AACC-DELISTED | Stock | 9.8 | 9.94 | 8.61 | 8.78 | 77347.0 |
| 2008-10-14 | AACG | Stock | 8.75 | 8.8 | 8.22 | 8.6 | 32600.0 |
| 2008-10-14 | AAI-DELISTED | Stock | 2.56 | 2.58 | 2.4 | 2.54 | 2993001.0 |
| 2008-10-14 | AAIC-DELISTED | Stock | 12.22 | 14.8 | 12.2 | 13.4 | 641446.0 |
| 2008-10-14 | AAME | Stock | 1.17 | 1.25 | 0.73 | 1.25 | 8400.0 |
| 2008-10-14 | AAON | Stock | 3.4509 | 3.4509 | 3.0321 | 3.119 | 509794.0 |
| 2008-10-14 | AAP | Stock | 29.28 | 29.76 | 27.27 | 27.83 | 2355600.0 |
| 2008-10-14 | AATI-DELISTED | Stock | 4.0 | 4.04 | 3.5 | 3.75 | 216036.0 |
| 2008-10-14 | AAU-DELISTED | Stock | 0.85 | 0.97 | 0.85 | 0.97 | 45700.0 |
| 2008-10-14 | AAUAF-DELISTED | Stock | 0.85 | 0.97 | 0.85 | 0.97 | 47500.0 |
| 2008-10-14 | AAV-DELISTED | Stock | 6.92 | 6.99 | 6.15 | 6.35 | 2101317.0 |
| 2008-10-14 | AAWW-DELISTED | Stock | 28.21 | 30.49 | 25.97 | 30.07 | 428759.0 |
| 2008-10-14 | AAXJ | Stock | 39.68 | 39.68 | 35.74 | 37.43 | 9816.0 |
| 2008-10-14 | AAXN-DELISTED | Stock | 5.46 | 5.63 | 5.1 | 5.26 | 814623.0 |
| 2008-10-14 | AB | Stock | 29.61 | 30.75 | 27.51 | 28.43 | 742900.0 |
| 2008-10-14 | ABAX-DELISTED | Stock | 15.99 | 16.18 | 15.05 | 15.206 | 254563.0 |
| 2008-10-14 | ABB-DELISTED | Stock | 17.62 | 17.72 | 16.34 | 16.89 | 11541368.0 |
| 2008-10-14 | ABBC-DELISTED | Stock | 10.47 | 10.5 | 9.75 | 10.02 | 41855.0 |
| 2008-10-14 | ABBNY-DELISTED | Stock | 17.62 | 17.72 | 16.34 | 16.73 | 11598168.0 |
| 2008-10-14 | ABC-DELISTED | Stock | 16.6 | 16.62 | 15.5 | 15.84 | 4568434.0 |
| 2008-10-14 | ABCB | Stock | 14.3367 | 14.3562 | 12.4304 | 13.1015 | 40405.0 |
| 2008-10-14 | ABCO-DELISTED | Stock | 14.915 | 14.965 | 13.79 | 14.11 | 191002.0 |
| 2008-10-14 | ABCW-DELISTED | Stock | 5.95 | 6.25 | 5.15 | 5.49 | 180830.0 |
| 2008-10-14 | ABD-DELISTED | Stock | 5.36 | 5.38 | 4.78 | 4.9 | 315960.0 |
| 2008-10-14 | ABE-DELISTED | Stock | 15.91 | 16.2016 | 14.0 | 14.27 | 53336.0 |
| 2008-10-14 | ABEO | Stock | 2812.5 | 2850.0 | 2687.5 | 2812.5 | 10.0 |
| 2008-10-14 | ABFS-DELISTED | Stock | 32.0 | 33.0 | 28.8 | 29.77 | 1069422.0 |
| 2008-10-14 | ABG | Stock | 5.04 | 5.1 | 4.65 | 4.85 | 692500.0 |
| 2008-10-14 | ABII-DELISTED | Stock | 69.09 | 69.42 | 59.0 | 65.92 | 36063.0 |
| 2008-10-14 | ABK-DELISTED | Stock | 2.24 | 2.24 | 1.76 | 1.91 | 20410236.0 |
| 2008-10-14 | ABM | Stock | 15.31 | 15.93 | 14.37 | 15.33 | 734200.0 |
| 2008-10-14 | ABMD-DELISTED | Stock | 13.92 | 14.75 | 13.46 | 13.85 | 740837.0 |
| 2008-10-14 | ABR | Stock | 6.38 | 6.9 | 5.05 | 5.54 | 373400.0 |
| 2008-10-14 | ABT | Stock | 27.1423 | 27.4254 | 25.3047 | 26.2834 | 29475823.0 |
| 2008-10-14 | ABTL-DELISTED | Stock | 2.756 | 3.016 | 2.548 | 2.6 | 20205.0 |
| 2008-10-14 | ABV-DELISTED | Stock | 49.23 | 49.76 | 45.9 | 47.68 | 1555139.0 |
| 2008-10-14 | ABVA-DELISTED | Stock | 3.79 | 3.9 | 3.79 | 3.89 | 5300.0 |
| 2008-10-14 | ABX-DELISTED | Stock | 29.0 | 30.57 | 28.5 | 29.95 | 23439341.0 |
| 2008-10-14 | ACAD | Stock | 2.49 | 2.5 | 2.16 | 2.24 | 171800.0 |
| 2008-10-14 | ACAP-DELISTED | Stock | 43.01 | 43.01 | 37.19 | 39.94 | 81576.0 |
| 2008-10-14 | ACAS-DELISTED | Stock | 17.0 | 17.38 | 15.25 | 15.64 | 4678707.0 |
| 2008-10-14 | ACAT-DELISTED | Stock | 7.78 | 7.82 | 6.92 | 6.95 | 134843.0 |
> showing 50 of 5,831 rows — these rows as CSV