PREVIEW / stock_daily / 2008-08-27
file: by_date/stock_daily/2008/2008-08-27.parquet size: 181 KB rows: 5,700 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-08-27 | AAPL | Stock | 6.1896 | 6.2771 | 6.1496 | 6.2382 | 477780800.0 |
| 2008-08-27 | MSFT | Stock | 27.34 | 27.79 | 27.13 | 27.56 | 33975300.0 |
| 2008-08-27 | NVDA | Stock | 0.3198 | 0.3338 | 0.3168 | 0.3298 | 454620000.0 |
| 2008-08-27 | AMZN | Stock | 4.072 | 4.137 | 4.05 | 4.0865 | 112546000.0 |
| 2008-08-27 | TLT | Stock | 93.49 | 94.29 | 93.44 | 94.25 | 1555299.0 |
| 2008-08-27 | CL | Stock | 37.84 | 38.17 | 37.63 | 38.115 | 2379400.0 |
| 2008-08-27 | A | Stock | 24.8069 | 25.1574 | 24.2704 | 24.8498 | 2197796.0 |
| 2008-08-27 | AABA-DELISTED | Stock | 19.08 | 19.45 | 18.93 | 19.36 | 9229551.0 |
| 2008-08-27 | AACC-DELISTED | Stock | 10.27 | 10.62 | 10.23 | 10.58 | 73079.0 |
| 2008-08-27 | AACG | Stock | 11.5 | 13.1 | 11.35 | 12.13 | 73500.0 |
| 2008-08-27 | AAI-DELISTED | Stock | 2.18 | 2.24 | 2.1 | 2.2 | 3380396.0 |
| 2008-08-27 | AAIC-DELISTED | Stock | 36.0 | 37.0 | 35.4 | 36.8 | 488381.0 |
| 2008-08-27 | AAME | Stock | 1.46 | 1.46 | 1.39 | 1.39 | 5600.0 |
| 2008-08-27 | AAON | Stock | 3.9881 | 4.1067 | 3.8756 | 4.0849 | 284006.0 |
| 2008-08-27 | AAP | Stock | 41.72 | 42.57 | 41.12 | 42.32 | 1008300.0 |
| 2008-08-27 | AATI-DELISTED | Stock | 4.66 | 4.7 | 4.58 | 4.69 | 181100.0 |
| 2008-08-27 | AAU-DELISTED | Stock | 1.39 | 1.41 | 1.36 | 1.37 | 53600.0 |
| 2008-08-27 | AAUAF-DELISTED | Stock | 1.39 | 1.4099 | 1.36 | 1.37 | 55400.0 |
| 2008-08-27 | AAV-DELISTED | Stock | 11.05 | 11.25 | 11.05 | 11.2 | 352478.0 |
| 2008-08-27 | AAWW-DELISTED | Stock | 55.32 | 55.32 | 54.581 | 55.04 | 554672.0 |
| 2008-08-27 | AAXJ | Stock | 49.77 | 49.77 | 49.65 | 49.65 | 1500.0 |
| 2008-08-27 | AAXN-DELISTED | Stock | 6.15 | 6.26 | 6.11 | 6.22 | 461054.0 |
| 2008-08-27 | AB | Stock | 52.1 | 53.68 | 51.8 | 53.2 | 179100.0 |
| 2008-08-27 | ABAX-DELISTED | Stock | 19.83 | 20.15 | 19.26 | 19.88 | 249003.0 |
| 2008-08-27 | ABB-DELISTED | Stock | 24.0 | 24.1 | 23.71 | 23.86 | 5816997.0 |
| 2008-08-27 | ABBC-DELISTED | Stock | 9.95 | 10.05 | 9.92 | 9.99 | 36913.0 |
| 2008-08-27 | ABBNY-DELISTED | Stock | 23.99 | 24.1 | 23.705 | 23.86 | 5831793.0 |
| 2008-08-27 | ABC-DELISTED | Stock | 20.78 | 20.82 | 20.56 | 20.78 | 1752446.0 |
| 2008-08-27 | ABCB | Stock | 11.5841 | 12.1094 | 11.5841 | 11.9148 | 27759.0 |
| 2008-08-27 | ABCO-DELISTED | Stock | 15.152 | 15.533 | 15.072 | 15.388 | 221346.0 |
| 2008-08-27 | ABCW-DELISTED | Stock | 7.51 | 8.04 | 7.38 | 7.57 | 217170.0 |
| 2008-08-27 | ABD-DELISTED | Stock | 8.43 | 8.77 | 8.36 | 8.48 | 271640.0 |
| 2008-08-27 | ABE-DELISTED | Stock | 19.12 | 19.24 | 18.76 | 19.1 | 25200.0 |
| 2008-08-27 | ABEO | Stock | 3687.5 | 3812.5 | 3687.5 | 3812.5 | 20.0 |
| 2008-08-27 | ABFS-DELISTED | Stock | 31.86 | 33.55 | 31.5801 | 32.91 | 655772.0 |
| 2008-08-27 | ABG | Stock | 11.87 | 12.34 | 11.77 | 12.16 | 182300.0 |
| 2008-08-27 | ABII-DELISTED | Stock | 73.84 | 74.8 | 72.9 | 74.0 | 26788.0 |
| 2008-08-27 | ABK-DELISTED | Stock | 5.39 | 5.53 | 5.16 | 5.22 | 19599124.0 |
| 2008-08-27 | ABM | Stock | 25.75 | 26.43 | 25.75 | 26.0 | 246800.0 |
| 2008-08-27 | ABMD-DELISTED | Stock | 17.77 | 18.1 | 17.74 | 17.89 | 289579.0 |
| 2008-08-27 | ABR | Stock | 8.75 | 9.28 | 8.5 | 8.66 | 230800.0 |
| 2008-08-27 | ABT | Stock | 27.6173 | 27.8332 | 27.4925 | 27.6941 | 6652980.0 |
| 2008-08-27 | ABTL-DELISTED | Stock | 5.85 | 5.9 | 5.25 | 5.6 | 21574.0 |
| 2008-08-27 | ABV-DELISTED | Stock | 61.61 | 61.66 | 60.78 | 61.51 | 512755.0 |
| 2008-08-27 | ABVA-DELISTED | Stock | 2.58 | 2.72 | 2.58 | 2.69 | 5600.0 |
| 2008-08-27 | ABVT-DELISTED | Stock | 58.0 | 60.0 | 58.0 | 60.0 | 5871.0 |
| 2008-08-27 | ABX-DELISTED | Stock | 35.23 | 35.53 | 34.78 | 35.48 | 7380298.0 |
| 2008-08-27 | ACAD | Stock | 2.43 | 2.53 | 2.43 | 2.51 | 87300.0 |
| 2008-08-27 | ACAP-DELISTED | Stock | 41.36 | 42.47 | 41.36 | 42.0 | 73838.0 |
| 2008-08-27 | ACAS-DELISTED | Stock | 21.01 | 21.25 | 20.52 | 21.18 | 2816909.0 |
> showing 50 of 5,700 rows — these rows as CSV