PREVIEW / stock_daily / 2009-12-17
file: by_date/stock_daily/2009/2009-12-17.parquet size: 188 KB rows: 5,893 symbols: 3,489
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-17 | AAPL | Stock | 6.9379 | 6.9643 | 6.8214 | 6.8521 | 388838800.0 |
| 2009-12-17 | MSFT | Stock | 29.95 | 29.96 | 29.57 | 29.6 | 43691200.0 |
| 2009-12-17 | NVDA | Stock | 0.424 | 0.437 | 0.4145 | 0.4208 | 1016132000.0 |
| 2009-12-17 | AMZN | Stock | 6.468 | 6.504 | 6.345 | 6.3455 | 169530000.0 |
| 2009-12-17 | TLT | Stock | 92.5 | 93.23 | 92.1901 | 93.19 | 4428864.0 |
| 2009-12-17 | ES | Stock | 25.66 | 26.02 | 25.66 | 25.82 | 1738600.0 |
| 2009-12-17 | CL | Stock | 42.075 | 42.11 | 41.25 | 41.44 | 4363600.0 |
| 2009-12-17 | A | Stock | 21.0658 | 21.2876 | 20.9871 | 21.0587 | 2699119.0 |
| 2009-12-17 | AABA-DELISTED | Stock | 15.72 | 15.96 | 15.64 | 15.83 | 25847688.0 |
| 2009-12-17 | AACC-DELISTED | Stock | 5.96 | 6.15 | 5.96 | 6.02 | 22245.0 |
| 2009-12-17 | AACG | Stock | 4.95 | 4.95 | 4.83 | 4.84 | 1000.0 |
| 2009-12-17 | AAI-DELISTED | Stock | 5.23 | 5.27 | 5.06 | 5.16 | 1902358.0 |
| 2009-12-17 | AAIC-DELISTED | Stock | 15.5 | 15.83 | 15.28 | 15.54 | 44965.0 |
| 2009-12-17 | AAME | Stock | 1.12 | 1.12 | 1.12 | 1.12 | 600.0 |
| 2009-12-17 | AAON | Stock | 3.7827 | 3.8519 | 3.7531 | 3.8519 | 383231.0 |
| 2009-12-17 | AAP | Stock | 40.65 | 41.1 | 40.63 | 40.78 | 1306900.0 |
| 2009-12-17 | AATI-DELISTED | Stock | 3.64 | 3.73 | 3.48 | 3.52 | 395977.0 |
| 2009-12-17 | AAU-DELISTED | Stock | 1.06 | 1.09 | 1.04 | 1.04 | 270300.0 |
| 2009-12-17 | AAUAF-DELISTED | Stock | 1.06 | 1.09 | 1.04 | 1.04 | 271300.0 |
| 2009-12-17 | AAV-DELISTED | Stock | 6.37 | 6.51 | 6.25 | 6.48 | 853701.0 |
| 2009-12-17 | AAWW-DELISTED | Stock | 36.86 | 37.36 | 36.45 | 37.17 | 296004.0 |
| 2009-12-17 | AAXJ | Stock | 54.59 | 54.87 | 54.25 | 54.46 | 1393295.0 |
| 2009-12-17 | AAXN-DELISTED | Stock | 4.45 | 4.5 | 4.43 | 4.46 | 303492.0 |
| 2009-12-17 | AB | Stock | 26.8 | 26.8 | 25.75 | 26.06 | 460000.0 |
| 2009-12-17 | ABAX-DELISTED | Stock | 23.73 | 23.95 | 23.06 | 23.35 | 74490.0 |
| 2009-12-17 | ABB-DELISTED | Stock | 18.3 | 18.31 | 18.09 | 18.17 | 2878505.0 |
| 2009-12-17 | ABBC-DELISTED | Stock | 6.65 | 6.87 | 6.61 | 6.65 | 20529.0 |
| 2009-12-17 | ABBNY-DELISTED | Stock | 18.3 | 18.31 | 18.09 | 18.14 | 2879805.0 |
| 2009-12-17 | ABC-DELISTED | Stock | 26.11 | 26.25 | 25.86 | 25.87 | 4192416.0 |
| 2009-12-17 | ABCB | Stock | 6.6354 | 6.6648 | 6.4689 | 6.5374 | 22956.0 |
| 2009-12-17 | ABCD-DELISTED | Stock | 4.74 | 4.9 | 3.97 | 4.9 | 10273.0 |
| 2009-12-17 | ABCO-DELISTED | Stock | 13.612 | 13.637 | 13.388 | 13.498 | 78013.0 |
| 2009-12-17 | ABCW-DELISTED | Stock | 0.57 | 0.61 | 0.57 | 0.6 | 82150.0 |
| 2009-12-17 | ABD-DELISTED | Stock | 7.47 | 7.56 | 7.2 | 7.37 | 260740.0 |
| 2009-12-17 | ABE-DELISTED | Stock | 16.58 | 16.65 | 16.5301 | 16.57 | 4463.0 |
| 2009-12-17 | ABEO | Stock | 4025.0 | 4125.0 | 3562.5 | 3800.0 | 63.0 |
| 2009-12-17 | ABFS-DELISTED | Stock | 27.89 | 31.28 | 27.1 | 30.84 | 1496500.0 |
| 2009-12-17 | ABG | Stock | 11.56 | 11.69 | 11.26 | 11.27 | 258900.0 |
| 2009-12-17 | ABII-DELISTED | Stock | 37.79 | 37.86 | 35.66 | 35.97 | 24147.0 |
| 2009-12-17 | ABK-DELISTED | Stock | 0.81 | 0.82 | 0.78 | 0.79 | 8662419.0 |
| 2009-12-17 | ABM | Stock | 19.32 | 19.8 | 18.72 | 18.95 | 468900.0 |
| 2009-12-17 | ABMD-DELISTED | Stock | 8.02 | 8.26 | 8.01 | 8.12 | 319329.0 |
| 2009-12-17 | ABR | Stock | 1.74 | 1.74 | 1.7 | 1.72 | 92000.0 |
| 2009-12-17 | ABT | Stock | 25.794 | 25.8276 | 25.5062 | 25.7077 | 11269070.0 |
| 2009-12-17 | ABTL-DELISTED | Stock | 4.9 | 5.0 | 4.5 | 4.7 | 5392.0 |
| 2009-12-17 | ABV-DELISTED | Stock | 96.99 | 97.36 | 95.47 | 95.65 | 400138.0 |
| 2009-12-17 | ABVT-DELISTED | Stock | 61.76 | 62.31 | 61.3901 | 62.05 | 106382.0 |
| 2009-12-17 | ABX-DELISTED | Stock | 39.11 | 39.81 | 38.18 | 38.39 | 19495036.0 |
| 2009-12-17 | ACAD | Stock | 1.4 | 1.4 | 1.29 | 1.3 | 539400.0 |
| 2009-12-17 | ACAP-DELISTED | Stock | 28.92 | 29.11 | 28.67 | 28.68 | 84782.0 |
> showing 50 of 5,893 rows — these rows as CSV