PREVIEW / stock_daily / 2007-12-11
file: by_date/stock_daily/2007/2007-12-11.parquet size: 182 KB rows: 5,632 symbols: 3,413
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-11 | AAPL | Stock | 6.9554 | 7.0296 | 6.6925 | 6.7336 | 1110925200.0 |
| 2007-12-11 | MSFT | Stock | 34.73 | 34.99 | 33.93 | 34.1 | 55070700.0 |
| 2007-12-11 | NVDA | Stock | 0.8745 | 0.8905 | 0.8552 | 0.8572 | 582436000.0 |
| 2007-12-11 | AMZN | Stock | 4.655 | 4.797 | 4.5375 | 4.5375 | 205392000.0 |
| 2007-12-11 | TLT | Stock | 91.73 | 93.23 | 91.58 | 92.99 | 2892713.0 |
| 2007-12-11 | CL | Stock | 39.41 | 39.8 | 39.225 | 39.525 | 5874400.0 |
| 2007-12-11 | A | Stock | 27.0887 | 27.103 | 26.0658 | 26.0873 | 3479063.0 |
| 2007-12-11 | AABA-DELISTED | Stock | 25.16 | 25.65 | 24.36 | 24.49 | 28579063.0 |
| 2007-12-11 | AACC-DELISTED | Stock | 11.8 | 11.85 | 11.26 | 11.26 | 165762.0 |
| 2007-12-11 | AAI-DELISTED | Stock | 8.6 | 8.77 | 8.16 | 8.16 | 1380635.0 |
| 2007-12-11 | AAIC-DELISTED | Stock | 59.2 | 60.0 | 54.8 | 55.0 | 1704498.0 |
| 2007-12-11 | AAME | Stock | 1.77 | 1.78 | 1.5 | 1.5 | 6900.0 |
| 2007-12-11 | AAON | Stock | 3.7827 | 3.8301 | 3.7136 | 3.7136 | 516375.0 |
| 2007-12-11 | AAP | Stock | 40.73 | 40.73 | 38.53 | 38.63 | 2054100.0 |
| 2007-12-11 | AATI-DELISTED | Stock | 11.79 | 11.84 | 11.5 | 11.55 | 847283.0 |
| 2007-12-11 | AAU-DELISTED | Stock | 2.59 | 2.62 | 2.38 | 2.45 | 56100.0 |
| 2007-12-11 | AAUAF-DELISTED | Stock | 2.59 | 2.62 | 2.38 | 2.45 | 56600.0 |
| 2007-12-11 | AAV-DELISTED | Stock | 10.06 | 10.13 | 10.02 | 10.05 | 774016.0 |
| 2007-12-11 | AAWW-DELISTED | Stock | 54.18 | 54.96 | 53.36 | 53.67 | 384174.0 |
| 2007-12-11 | AAXN-DELISTED | Stock | 15.5 | 15.6 | 14.7501 | 14.78 | 1315688.0 |
| 2007-12-11 | AB | Stock | 80.79 | 83.37 | 80.08 | 80.22 | 413500.0 |
| 2007-12-11 | ABAX-DELISTED | Stock | 35.76 | 37.3 | 35.39 | 35.45 | 352251.0 |
| 2007-12-11 | ABB-DELISTED | Stock | 29.48 | 30.2 | 28.97 | 29.07 | 5692397.0 |
| 2007-12-11 | ABBC-DELISTED | Stock | 8.97 | 9.0 | 8.88 | 8.98 | 184486.0 |
| 2007-12-11 | ABBNY-DELISTED | Stock | 29.48 | 30.2 | 28.97 | 29.08 | 5237397.0 |
| 2007-12-11 | ABC-DELISTED | Stock | 22.9 | 22.9 | 22.02 | 22.06 | 3396012.0 |
| 2007-12-11 | ABCB | Stock | 17.4881 | 17.741 | 16.5446 | 16.5738 | 38246.0 |
| 2007-12-11 | ABCO-DELISTED | Stock | 32.83 | 33.29 | 32.03 | 32.03 | 141910.0 |
| 2007-12-11 | ABCW-DELISTED | Stock | 25.95 | 26.22 | 24.26 | 24.26 | 155470.0 |
| 2007-12-11 | ABD-DELISTED | Stock | 17.92 | 17.93 | 16.46 | 16.83 | 569040.0 |
| 2007-12-11 | ABE-DELISTED | Stock | 28.4 | 28.4 | 26.8901 | 27.25 | 29800.0 |
| 2007-12-11 | ABEO | Stock | 2937.5 | 3150.0 | 2937.5 | 3125.0 | 8.0 |
| 2007-12-11 | ABFS-DELISTED | Stock | 26.05 | 26.22 | 24.05 | 24.12 | 893771.0 |
| 2007-12-11 | ABG | Stock | 17.39 | 17.41 | 16.37 | 16.44 | 268400.0 |
| 2007-12-11 | ABII-DELISTED | Stock | 68.33 | 70.22 | 68.07 | 70.22 | 41777.0 |
| 2007-12-11 | ABK-DELISTED | Stock | 29.44 | 29.98 | 26.83 | 27.03 | 9420657.0 |
| 2007-12-11 | ABM | Stock | 20.9 | 21.18 | 20.17 | 20.35 | 254100.0 |
| 2007-12-11 | ABMD-DELISTED | Stock | 14.6 | 15.0 | 14.35 | 14.47 | 297818.0 |
| 2007-12-11 | ABP-DELISTED | Stock | 3.5 | 3.52 | 3.33 | 3.38 | 135900.0 |
| 2007-12-11 | ABR | Stock | 19.06 | 19.06 | 17.94 | 18.09 | 275600.0 |
| 2007-12-11 | ABT | Stock | 28.2458 | 28.3514 | 27.79 | 27.8716 | 13496040.0 |
| 2007-12-11 | ABTL-DELISTED | Stock | 14.9 | 15.057 | 14.599 | 14.95 | 19515.0 |
| 2007-12-11 | ABV-DELISTED | Stock | 76.05 | 77.52 | 72.2 | 72.92 | 689100.0 |
| 2007-12-11 | ABVA-DELISTED | Stock | 7.18 | 7.18 | 7.0 | 7.06 | 2800.0 |
| 2007-12-11 | ABVT-DELISTED | Stock | 70.0 | 78.0 | 70.0 | 76.75 | 41514.0 |
| 2007-12-11 | ABX-DELISTED | Stock | 40.82 | 41.3 | 38.67 | 38.85 | 7364540.0 |
| 2007-12-11 | ACAD | Stock | 12.28 | 12.28 | 11.19 | 11.2 | 413500.0 |
| 2007-12-11 | ACAP-DELISTED | Stock | 45.97 | 45.99 | 43.66 | 44.01 | 108924.0 |
| 2007-12-11 | ACAS-DELISTED | Stock | 38.48 | 38.63 | 36.17 | 36.31 | 2578695.0 |
| 2007-12-11 | ACAT-DELISTED | Stock | 12.43 | 12.61 | 12.15 | 12.16 | 239862.0 |
> showing 50 of 5,632 rows — these rows as CSV