PREVIEW / stock_daily / 2007-12-10
file: by_date/stock_daily/2007/2007-12-10.parquet size: 182 KB rows: 5,643 symbols: 3,428
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-10 | AAPL | Stock | 6.9139 | 6.9879 | 6.8818 | 6.9361 | 722377600.0 |
| 2007-12-10 | MSFT | Stock | 34.64 | 34.95 | 34.47 | 34.76 | 36083500.0 |
| 2007-12-10 | NVDA | Stock | 0.8498 | 0.8662 | 0.8472 | 0.8562 | 336360000.0 |
| 2007-12-10 | AMZN | Stock | 4.7155 | 4.7175 | 4.615 | 4.651 | 103612000.0 |
| 2007-12-10 | TLT | Stock | 91.64 | 91.69 | 90.75 | 91.2 | 2242470.0 |
| 2007-12-10 | CL | Stock | 39.935 | 40.055 | 39.43 | 39.43 | 4604600.0 |
| 2007-12-10 | A | Stock | 27.2103 | 27.3033 | 27.0386 | 27.103 | 2036886.0 |
| 2007-12-10 | AABA-DELISTED | Stock | 25.51 | 25.58 | 24.92 | 25.21 | 26135656.0 |
| 2007-12-10 | AACC-DELISTED | Stock | 11.79 | 11.91 | 11.59 | 11.74 | 135935.0 |
| 2007-12-10 | AAI-DELISTED | Stock | 8.52 | 8.64 | 8.41 | 8.6 | 827580.0 |
| 2007-12-10 | AAIC-DELISTED | Stock | 59.2 | 60.0 | 57.6 | 59.0 | 1474050.0 |
| 2007-12-10 | AAME | Stock | 1.62 | 1.87 | 1.59 | 1.79 | 21900.0 |
| 2007-12-10 | AAON | Stock | 3.7906 | 3.842 | 3.676 | 3.7689 | 660150.0 |
| 2007-12-10 | AAP | Stock | 39.5 | 39.9 | 39.14 | 39.55 | 985400.0 |
| 2007-12-10 | AATI-DELISTED | Stock | 11.37 | 11.83 | 11.25 | 11.72 | 1017627.0 |
| 2007-12-10 | AAU-DELISTED | Stock | 2.52 | 2.63 | 2.5 | 2.53 | 96600.0 |
| 2007-12-10 | AAUAF-DELISTED | Stock | 2.52 | 2.63 | 2.5 | 2.53 | 96800.0 |
| 2007-12-10 | AAV-DELISTED | Stock | 10.08 | 10.21 | 10.06 | 10.11 | 780795.0 |
| 2007-12-10 | AAWW-DELISTED | Stock | 54.14 | 54.32 | 53.79 | 53.94 | 400886.0 |
| 2007-12-10 | AAXN-DELISTED | Stock | 15.67 | 15.91 | 15.27 | 15.46 | 1001278.0 |
| 2007-12-10 | AB | Stock | 80.5 | 82.55 | 80.09 | 81.63 | 465700.0 |
| 2007-12-10 | ABAX-DELISTED | Stock | 35.14 | 37.05 | 34.75 | 35.55 | 486894.0 |
| 2007-12-10 | ABB-DELISTED | Stock | 29.46 | 29.94 | 29.38 | 29.8 | 2473406.0 |
| 2007-12-10 | ABBC-DELISTED | Stock | 8.97 | 8.97 | 8.92 | 8.93 | 46783.0 |
| 2007-12-10 | ABBNY-DELISTED | Stock | 29.46 | 29.94 | 29.38 | 29.77 | 2473406.0 |
| 2007-12-10 | ABC-DELISTED | Stock | 22.94 | 23.0 | 22.72 | 22.88 | 1588400.0 |
| 2007-12-10 | ABCB | Stock | 17.1963 | 17.4978 | 17.1088 | 17.3617 | 28890.0 |
| 2007-12-10 | ABCO-DELISTED | Stock | 33.19 | 33.37 | 32.51 | 32.67 | 92708.0 |
| 2007-12-10 | ABCW-DELISTED | Stock | 25.43 | 26.04 | 25.22 | 25.75 | 55880.0 |
| 2007-12-10 | ABD-DELISTED | Stock | 17.74 | 18.17 | 17.65 | 17.87 | 185180.0 |
| 2007-12-10 | ABE-DELISTED | Stock | 28.1 | 28.5 | 27.95 | 28.05 | 43700.0 |
| 2007-12-10 | ABEO | Stock | 3212.5 | 3262.5 | 2937.5 | 3125.0 | 11.0 |
| 2007-12-10 | ABFS-DELISTED | Stock | 25.22 | 26.23 | 24.8 | 26.16 | 594500.0 |
| 2007-12-10 | ABG | Stock | 17.19 | 17.44 | 16.7 | 17.28 | 248500.0 |
| 2007-12-10 | ABII-DELISTED | Stock | 68.2 | 71.44 | 68.2 | 68.4 | 40962.0 |
| 2007-12-10 | ABK-DELISTED | Stock | 27.23 | 32.28 | 26.54 | 29.4 | 19815108.0 |
| 2007-12-10 | ABM | Stock | 21.11 | 21.44 | 20.65 | 20.84 | 301400.0 |
| 2007-12-10 | ABMD-DELISTED | Stock | 13.87 | 14.73 | 13.79 | 14.53 | 371890.0 |
| 2007-12-10 | ABP-DELISTED | Stock | 3.53 | 3.55 | 3.41 | 3.48 | 135801.0 |
| 2007-12-10 | ABR | Stock | 18.09 | 19.2 | 17.85 | 18.74 | 291700.0 |
| 2007-12-10 | ABT | Stock | 27.9579 | 28.3802 | 27.9004 | 28.2602 | 11388912.0 |
| 2007-12-10 | ABTL-DELISTED | Stock | 15.2 | 15.5 | 14.85 | 15.0 | 19022.0 |
| 2007-12-10 | ABV-DELISTED | Stock | 76.16 | 77.02 | 75.96 | 76.29 | 529800.0 |
| 2007-12-10 | ABVA-DELISTED | Stock | 7.12 | 7.24 | 6.976 | 7.2 | 3019.0 |
| 2007-12-10 | ABX-DELISTED | Stock | 40.17 | 41.04 | 40.13 | 40.6 | 4168386.0 |
| 2007-12-10 | ACAD | Stock | 12.41 | 12.5 | 12.15 | 12.24 | 281000.0 |
| 2007-12-10 | ACAP-DELISTED | Stock | 44.84 | 46.68 | 44.75 | 45.75 | 75658.0 |
| 2007-12-10 | ACAS-DELISTED | Stock | 37.01 | 38.38 | 36.73 | 38.35 | 2074234.0 |
| 2007-12-10 | ACAT-DELISTED | Stock | 12.21 | 12.41 | 12.0 | 12.37 | 80985.0 |
| 2007-12-10 | ACC-DELISTED | Stock | 26.74 | 27.08 | 26.23 | 27.08 | 156083.0 |
> showing 50 of 5,643 rows — these rows as CSV