PREVIEW / stock_daily / 2007-12-14
file: by_date/stock_daily/2007/2007-12-14.parquet size: 181 KB rows: 5,625 symbols: 3,414
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-14 | AAPL | Stock | 6.7989 | 6.9 | 6.7693 | 6.7996 | 674312800.0 |
| 2007-12-14 | MSFT | Stock | 35.05 | 35.84 | 35.01 | 35.31 | 71126200.0 |
| 2007-12-14 | NVDA | Stock | 0.8585 | 0.8863 | 0.8528 | 0.8768 | 354016000.0 |
| 2007-12-14 | AMZN | Stock | 4.5385 | 4.562 | 4.4465 | 4.454 | 120046000.0 |
| 2007-12-14 | TLT | Stock | 90.79 | 90.92 | 90.5 | 90.61 | 1354900.0 |
| 2007-12-14 | CL | Stock | 40.17 | 40.635 | 40.05 | 40.32 | 5126000.0 |
| 2007-12-14 | A | Stock | 26.1803 | 26.4378 | 25.9371 | 25.9728 | 2840317.0 |
| 2007-12-14 | AABA-DELISTED | Stock | 24.13 | 24.47 | 24.0 | 24.07 | 15127025.0 |
| 2007-12-14 | AACC-DELISTED | Stock | 11.03 | 11.06 | 10.4401 | 10.5 | 183184.0 |
| 2007-12-14 | AAI-DELISTED | Stock | 8.09 | 8.35 | 7.91 | 8.17 | 1998478.0 |
| 2007-12-14 | AAIC-DELISTED | Stock | 56.2 | 59.0 | 53.6 | 54.4 | 1882673.0 |
| 2007-12-14 | AAME | Stock | 1.6 | 1.6 | 1.56 | 1.56 | 2400.0 |
| 2007-12-14 | AAON | Stock | 3.8005 | 3.8005 | 3.7017 | 3.7037 | 347287.0 |
| 2007-12-14 | AAP | Stock | 38.37 | 38.37 | 37.84 | 38.08 | 1423300.0 |
| 2007-12-14 | AATI-DELISTED | Stock | 11.48 | 11.58 | 11.42 | 11.57 | 800247.0 |
| 2007-12-14 | AAU-DELISTED | Stock | 2.3 | 2.46 | 2.3 | 2.39 | 52200.0 |
| 2007-12-14 | AAUAF-DELISTED | Stock | 2.3 | 2.4577 | 2.3 | 2.392 | 66300.0 |
| 2007-12-14 | AAV-DELISTED | Stock | 10.03 | 10.06 | 10.02 | 10.03 | 555356.0 |
| 2007-12-14 | AAWW-DELISTED | Stock | 53.5 | 53.77 | 52.02 | 52.45 | 122184.0 |
| 2007-12-14 | AAXN-DELISTED | Stock | 14.3 | 14.74 | 14.3 | 14.42 | 817590.0 |
| 2007-12-14 | AB | Stock | 79.19 | 81.13 | 79.0 | 79.17 | 263200.0 |
| 2007-12-14 | ABAX-DELISTED | Stock | 36.5 | 37.26 | 36.14 | 36.92 | 220976.0 |
| 2007-12-14 | ABB-DELISTED | Stock | 27.45 | 28.07 | 27.41 | 27.61 | 3954069.0 |
| 2007-12-14 | ABBC-DELISTED | Stock | 8.83 | 9.25 | 8.83 | 9.04 | 45567.0 |
| 2007-12-14 | ABBNY-DELISTED | Stock | 27.45 | 28.07 | 27.41 | 27.68 | 3954069.0 |
| 2007-12-14 | ABC-DELISTED | Stock | 21.58 | 21.66 | 21.4 | 21.42 | 2565266.0 |
| 2007-12-14 | ABCB | Stock | 16.9921 | 17.4006 | 16.5252 | 16.5252 | 28582.0 |
| 2007-12-14 | ABCO-DELISTED | Stock | 31.95 | 32.22 | 31.47 | 31.47 | 344856.0 |
| 2007-12-14 | ABCW-DELISTED | Stock | 24.01 | 24.14 | 23.26 | 23.26 | 163990.0 |
| 2007-12-14 | ABD-DELISTED | Stock | 16.48 | 16.48 | 15.92 | 15.92 | 403700.0 |
| 2007-12-14 | ABE-DELISTED | Stock | 27.1 | 27.4171 | 26.65 | 26.65 | 26300.0 |
| 2007-12-14 | ABEO | Stock | 2875.0 | 3125.0 | 2625.0 | 3062.5 | 25.0 |
| 2007-12-14 | ABFS-DELISTED | Stock | 22.99 | 23.13 | 22.46 | 22.46 | 904951.0 |
| 2007-12-14 | ABG | Stock | 15.15 | 15.45 | 14.83 | 14.84 | 866000.0 |
| 2007-12-14 | ABII-DELISTED | Stock | 69.21 | 73.44 | 69.21 | 70.2 | 39211.0 |
| 2007-12-14 | ABK-DELISTED | Stock | 23.89 | 23.9 | 22.64 | 22.86 | 5843655.0 |
| 2007-12-14 | ABM | Stock | 19.31 | 19.92 | 19.17 | 19.81 | 607000.0 |
| 2007-12-14 | ABMD-DELISTED | Stock | 14.98 | 15.15 | 14.74 | 15.0 | 310715.0 |
| 2007-12-14 | ABP-DELISTED | Stock | 3.24 | 3.33 | 3.18 | 3.22 | 255360.0 |
| 2007-12-14 | ABR | Stock | 17.86 | 18.05 | 17.21 | 17.32 | 137300.0 |
| 2007-12-14 | ABT | Stock | 27.8332 | 28.0539 | 27.5789 | 27.5933 | 9516257.0 |
| 2007-12-14 | ABTL-DELISTED | Stock | 14.875 | 15.576 | 14.875 | 15.575 | 14417.0 |
| 2007-12-14 | ABV-DELISTED | Stock | 72.79 | 73.23 | 71.06 | 71.78 | 833305.0 |
| 2007-12-14 | ABVA-DELISTED | Stock | 6.79 | 6.79 | 6.25 | 6.79 | 5989.0 |
| 2007-12-14 | ABVT-DELISTED | Stock | 76.5 | 76.5 | 76.5 | 76.5 | 587.0 |
| 2007-12-14 | ABX-DELISTED | Stock | 37.93 | 38.67 | 37.24 | 37.97 | 5670354.0 |
| 2007-12-14 | ACAD | Stock | 11.89 | 12.3 | 11.75 | 12.03 | 258400.0 |
| 2007-12-14 | ACAP-DELISTED | Stock | 44.09 | 45.56 | 43.41 | 43.45 | 70673.0 |
| 2007-12-14 | ACAS-DELISTED | Stock | 36.13 | 37.21 | 35.43 | 35.46 | 3124432.0 |
| 2007-12-14 | ACAT-DELISTED | Stock | 11.98 | 12.24 | 11.67 | 11.75 | 154909.0 |
> showing 50 of 5,625 rows — these rows as CSV