PREVIEW / stock_daily / 2009-12-03
file: by_date/stock_daily/2009/2009-12-03.parquet size: 187 KB rows: 5,873 symbols: 3,476
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-12-03 | AAPL | Stock | 7.0507 | 7.1064 | 7.0096 | 7.0171 | 448719600.0 |
| 2009-12-03 | MSFT | Stock | 29.84 | 30.2 | 29.76 | 29.83 | 43095200.0 |
| 2009-12-03 | NVDA | Stock | 0.347 | 0.3533 | 0.3453 | 0.3458 | 660036000.0 |
| 2009-12-03 | AMZN | Stock | 7.181 | 7.2955 | 7.0385 | 7.0585 | 330470000.0 |
| 2009-12-03 | TLT | Stock | 94.43 | 94.84 | 94.24 | 94.34 | 3947274.0 |
| 2009-12-03 | ES | Stock | 24.58 | 24.81 | 24.52 | 24.54 | 791300.0 |
| 2009-12-03 | CL | Stock | 43.235 | 43.385 | 42.745 | 42.825 | 4573800.0 |
| 2009-12-03 | A | Stock | 21.1016 | 21.5021 | 21.1016 | 21.2446 | 5010013.0 |
| 2009-12-03 | AABA-DELISTED | Stock | 15.36 | 15.38 | 15.1 | 15.1 | 16235618.0 |
| 2009-12-03 | AACC-DELISTED | Stock | 5.92 | 5.94 | 5.75 | 5.75 | 63690.0 |
| 2009-12-03 | AACG | Stock | 5.05 | 5.06 | 4.83 | 5.05 | 10000.0 |
| 2009-12-03 | AAI-DELISTED | Stock | 5.01 | 5.12 | 4.88 | 4.8819 | 4164591.0 |
| 2009-12-03 | AAIC-DELISTED | Stock | 13.42 | 13.73 | 13.33 | 13.5 | 47167.0 |
| 2009-12-03 | AAME | Stock | 1.26 | 1.26 | 1.26 | 1.26 | 400.0 |
| 2009-12-03 | AAON | Stock | 3.9012 | 3.9012 | 3.8143 | 3.8183 | 381206.0 |
| 2009-12-03 | AAP | Stock | 40.64 | 40.72 | 40.17 | 40.35 | 1278000.0 |
| 2009-12-03 | AATI-DELISTED | Stock | 3.4 | 3.48 | 3.32 | 3.32 | 164920.0 |
| 2009-12-03 | AAU-DELISTED | Stock | 0.97 | 1.34 | 0.97 | 1.1408 | 3143242.0 |
| 2009-12-03 | AAUAF-DELISTED | Stock | 0.97 | 1.34 | 0.97 | 1.1408 | 3149002.0 |
| 2009-12-03 | AAV-DELISTED | Stock | 5.88 | 5.92 | 5.65 | 5.68 | 546270.0 |
| 2009-12-03 | AAWW-DELISTED | Stock | 31.75 | 32.66 | 31.75 | 31.98 | 426352.0 |
| 2009-12-03 | AAXJ | Stock | 56.14 | 57.0 | 55.76 | 55.93 | 146666.0 |
| 2009-12-03 | AAXN-DELISTED | Stock | 4.25 | 4.28 | 4.18 | 4.18 | 219301.0 |
| 2009-12-03 | AB | Stock | 26.32 | 26.66 | 26.12 | 26.2 | 252200.0 |
| 2009-12-03 | ABAX-DELISTED | Stock | 23.48 | 23.6 | 22.8 | 22.85 | 61106.0 |
| 2009-12-03 | ABB-DELISTED | Stock | 18.98 | 19.08 | 18.63 | 18.65 | 3393155.0 |
| 2009-12-03 | ABBC-DELISTED | Stock | 6.91 | 6.99 | 6.72 | 6.74 | 34865.0 |
| 2009-12-03 | ABBNY-DELISTED | Stock | 18.98 | 19.08 | 18.63 | 18.65 | 3563422.0 |
| 2009-12-03 | ABC-DELISTED | Stock | 24.83 | 24.87 | 24.57 | 24.59 | 2576171.0 |
| 2009-12-03 | ABCB | Stock | 6.8413 | 6.8413 | 6.5766 | 6.5962 | 17345.0 |
| 2009-12-03 | ABCO-DELISTED | Stock | 13.278 | 13.333 | 12.987 | 12.992 | 79682.0 |
| 2009-12-03 | ABCW-DELISTED | Stock | 0.6322 | 0.6987 | 0.6143 | 0.65 | 320910.0 |
| 2009-12-03 | ABD-DELISTED | Stock | 6.81 | 6.94 | 6.58 | 6.7 | 208940.0 |
| 2009-12-03 | ABE-DELISTED | Stock | 16.87 | 16.9 | 16.76 | 16.76 | 8963.0 |
| 2009-12-03 | ABEO | Stock | 3700.0 | 3750.0 | 3625.0 | 3750.0 | 12.0 |
| 2009-12-03 | ABFS-DELISTED | Stock | 26.73 | 27.01 | 26.47 | 26.53 | 290474.0 |
| 2009-12-03 | ABG | Stock | 11.13 | 11.38 | 10.99 | 11.16 | 244300.0 |
| 2009-12-03 | ABII-DELISTED | Stock | 36.29 | 37.49 | 36.095 | 36.87 | 22247.0 |
| 2009-12-03 | ABK-DELISTED | Stock | 0.95 | 1.02 | 0.87 | 0.8859 | 30829601.0 |
| 2009-12-03 | ABM | Stock | 19.22 | 19.55 | 19.01 | 19.06 | 115800.0 |
| 2009-12-03 | ABMD-DELISTED | Stock | 8.97 | 8.97 | 8.75 | 8.79 | 148071.0 |
| 2009-12-03 | ABR | Stock | 1.75 | 1.8 | 1.7 | 1.74 | 114600.0 |
| 2009-12-03 | ABT | Stock | 26.1059 | 26.2403 | 25.9716 | 26.0244 | 11145060.0 |
| 2009-12-03 | ABTL-DELISTED | Stock | 4.5111 | 4.7606 | 4.51 | 4.6889 | 1550.0 |
| 2009-12-03 | ABV-DELISTED | Stock | 99.0 | 100.04 | 98.14 | 98.31 | 556710.0 |
| 2009-12-03 | ABVA-DELISTED | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 999.0 |
| 2009-12-03 | ABVT-DELISTED | Stock | 54.18 | 54.78 | 53.5435 | 53.91 | 146071.0 |
| 2009-12-03 | ABX-DELISTED | Stock | 47.36 | 47.95 | 46.43 | 46.86 | 15440330.0 |
| 2009-12-03 | ACAD | Stock | 1.2 | 1.21 | 1.18 | 1.18 | 404300.0 |
| 2009-12-03 | ACAP-DELISTED | Stock | 28.28 | 28.79 | 27.85 | 28.0 | 81539.0 |
> showing 50 of 5,873 rows — these rows as CSV