PREVIEW / stock_daily / 2009-10-05
file: by_date/stock_daily/2009/2009-10-05.parquet size: 186 KB rows: 5,826 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-05 | AAPL | Stock | 6.65 | 6.6736 | 6.5811 | 6.6436 | 423133200.0 |
| 2009-10-05 | MSFT | Stock | 24.98 | 25.06 | 24.52 | 24.64 | 60804900.0 |
| 2009-10-05 | NVDA | Stock | 0.35 | 0.3513 | 0.3385 | 0.3445 | 754276000.0 |
| 2009-10-05 | AMZN | Stock | 4.5125 | 4.5465 | 4.4135 | 4.4335 | 140570000.0 |
| 2009-10-05 | TLT | Stock | 99.47 | 99.66 | 98.77 | 99.02 | 2910061.0 |
| 2009-10-05 | ES | Stock | 23.06 | 23.26 | 22.76 | 23.26 | 4149100.0 |
| 2009-10-05 | CL | Stock | 38.415 | 38.53 | 37.83 | 38.43 | 6034800.0 |
| 2009-10-05 | A | Stock | 18.8054 | 19.299 | 18.7482 | 19.1845 | 4461298.0 |
| 2009-10-05 | AABA-DELISTED | Stock | 16.85 | 17.125 | 16.66 | 16.79 | 22059943.0 |
| 2009-10-05 | AACC-DELISTED | Stock | 7.13 | 7.4 | 7.11 | 7.29 | 36212.0 |
| 2009-10-05 | AACG | Stock | 5.94 | 6.0 | 5.75 | 5.98 | 12000.0 |
| 2009-10-05 | AAI-DELISTED | Stock | 6.25 | 6.36 | 6.05 | 6.07 | 3312714.0 |
| 2009-10-05 | AAIC-DELISTED | Stock | 9.2 | 9.2 | 8.4 | 8.8 | 766830.0 |
| 2009-10-05 | AAME | Stock | 1.0 | 1.1 | 1.0 | 1.1 | 28600.0 |
| 2009-10-05 | AAON | Stock | 3.761 | 4.079 | 3.6919 | 3.7215 | 478406.0 |
| 2009-10-05 | AAP | Stock | 37.35 | 38.46 | 37.35 | 37.65 | 1678600.0 |
| 2009-10-05 | AATI-DELISTED | Stock | 3.35 | 3.47 | 3.25 | 3.28 | 391257.0 |
| 2009-10-05 | AAU-DELISTED | Stock | 0.68 | 0.72 | 0.67 | 0.7099 | 142049.0 |
| 2009-10-05 | AAUAF-DELISTED | Stock | 0.68 | 0.72 | 0.67 | 0.7099 | 143149.0 |
| 2009-10-05 | AAV-DELISTED | Stock | 6.35 | 6.48 | 6.29 | 6.41 | 814838.0 |
| 2009-10-05 | AAWW-DELISTED | Stock | 29.15 | 30.34 | 29.15 | 30.16 | 187480.0 |
| 2009-10-05 | AAXJ | Stock | 51.74 | 52.25 | 51.43 | 52.06 | 326906.0 |
| 2009-10-05 | AAXN-DELISTED | Stock | 4.51 | 4.6129 | 4.45 | 4.54 | 250472.0 |
| 2009-10-05 | AB | Stock | 24.81 | 25.88 | 24.77 | 25.55 | 580600.0 |
| 2009-10-05 | ABAX-DELISTED | Stock | 25.86 | 26.5 | 25.79 | 26.42 | 136517.0 |
| 2009-10-05 | ABB-DELISTED | Stock | 19.45 | 19.68 | 19.37 | 19.64 | 1784027.0 |
| 2009-10-05 | ABBC-DELISTED | Stock | 7.76 | 7.83 | 7.7075 | 7.77 | 19827.0 |
| 2009-10-05 | ABBNY-DELISTED | Stock | 19.45 | 19.68 | 19.37 | 19.64 | 1786257.0 |
| 2009-10-05 | ABC-DELISTED | Stock | 21.71 | 21.91 | 21.44 | 21.87 | 2617652.0 |
| 2009-10-05 | ABCB | Stock | 6.9687 | 7.1255 | 6.7727 | 7.1059 | 18263.0 |
| 2009-10-05 | ABCO-DELISTED | Stock | 12.963 | 12.963 | 12.597 | 12.727 | 114167.0 |
| 2009-10-05 | ABCW-DELISTED | Stock | 1.3447 | 1.3551 | 1.1987 | 1.23 | 111420.0 |
| 2009-10-05 | ABD-DELISTED | Stock | 6.54 | 7.01 | 6.52 | 6.99 | 387330.0 |
| 2009-10-05 | ABE-DELISTED | Stock | 16.9 | 17.5 | 16.9 | 17.3 | 38588.0 |
| 2009-10-05 | ABEO | Stock | 3875.0 | 4125.0 | 3775.0 | 4100.0 | 170.0 |
| 2009-10-05 | ABFS-DELISTED | Stock | 27.32 | 27.83 | 26.72 | 27.35 | 476127.0 |
| 2009-10-05 | ABG | Stock | 12.51 | 12.84 | 12.22 | 12.66 | 148500.0 |
| 2009-10-05 | ABII-DELISTED | Stock | 36.71 | 37.29 | 36.39 | 37.24 | 56525.0 |
| 2009-10-05 | ABK-DELISTED | Stock | 1.56 | 1.57 | 1.52 | 1.54 | 11346964.0 |
| 2009-10-05 | ABM | Stock | 20.19 | 20.19 | 19.65 | 19.68 | 196500.0 |
| 2009-10-05 | ABMD-DELISTED | Stock | 9.94 | 10.06 | 9.68 | 10.06 | 405901.0 |
| 2009-10-05 | ABR | Stock | 2.67 | 2.73 | 2.63 | 2.68 | 138300.0 |
| 2009-10-05 | ABT | Stock | 23.9564 | 24.1963 | 23.8077 | 24.1483 | 23621509.0 |
| 2009-10-05 | ABTL-DELISTED | Stock | 3.24 | 3.26 | 3.1096 | 3.26 | 6236.0 |
| 2009-10-05 | ABV-DELISTED | Stock | 84.55 | 87.05 | 84.21 | 86.8 | 654252.0 |
| 2009-10-05 | ABVA-DELISTED | Stock | 2.34 | 2.58 | 2.3306 | 2.58 | 1075.0 |
| 2009-10-05 | ABVT-DELISTED | Stock | 47.86 | 48.5 | 47.75 | 48.16 | 66162.0 |
| 2009-10-05 | ABX-DELISTED | Stock | 36.36 | 37.2 | 35.98 | 36.98 | 11865804.0 |
| 2009-10-05 | ACAD | Stock | 1.62 | 1.65 | 1.59 | 1.65 | 589500.0 |
| 2009-10-05 | ACAP-DELISTED | Stock | 29.36 | 30.24 | 29.36 | 29.97 | 55243.0 |
> showing 50 of 5,826 rows — these rows as CSV