PREVIEW / stock_daily / 2009-02-06
file: by_date/stock_daily/2009/2009-02-06.parquet size: 176 KB rows: 5,727 symbols: 3,429
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-02-06 | AAPL | Stock | 3.465 | 3.5714 | 3.4643 | 3.5614 | 687209600.0 |
| 2009-02-06 | MSFT | Stock | 19.16 | 19.93 | 19.06 | 19.66 | 86746000.0 |
| 2009-02-06 | NVDA | Stock | 0.2348 | 0.2482 | 0.2308 | 0.2468 | 1157880000.0 |
| 2009-02-06 | AMZN | Stock | 3.159 | 3.35 | 3.159 | 3.3275 | 240898000.0 |
| 2009-02-06 | TLT | Stock | 102.25 | 102.86 | 101.9 | 102.29 | 1667494.0 |
| 2009-02-06 | CL | Stock | 32.295 | 32.955 | 32.21 | 32.83 | 5313600.0 |
| 2009-02-06 | A | Stock | 13.6552 | 14.0844 | 13.6552 | 13.8054 | 4277321.0 |
| 2009-02-06 | AABA-DELISTED | Stock | 13.41 | 13.84 | 13.2 | 13.61 | 17201064.0 |
| 2009-02-06 | AACC-DELISTED | Stock | 4.73 | 4.99 | 4.7104 | 4.89 | 46400.0 |
| 2009-02-06 | AACG | Stock | 4.06 | 4.49 | 4.03 | 4.49 | 38300.0 |
| 2009-02-06 | AAI-DELISTED | Stock | 4.49 | 4.6001 | 4.44 | 4.48 | 2709188.0 |
| 2009-02-06 | AAIC-DELISTED | Stock | 4.2 | 4.8 | 4.2 | 4.6 | 178366.0 |
| 2009-02-06 | AAON | Stock | 3.6504 | 3.8183 | 3.6464 | 3.7827 | 315394.0 |
| 2009-02-06 | AAP | Stock | 33.03 | 34.21 | 32.86 | 33.63 | 1773700.0 |
| 2009-02-06 | AATI-DELISTED | Stock | 3.35 | 3.49 | 2.83 | 2.9 | 358686.0 |
| 2009-02-06 | AAU-DELISTED | Stock | 0.74 | 0.75 | 0.69 | 0.69 | 74519.0 |
| 2009-02-06 | AAUAF-DELISTED | Stock | 0.74 | 0.75 | 0.69 | 0.69 | 74619.0 |
| 2009-02-06 | AAV-DELISTED | Stock | 3.72 | 3.79 | 3.5 | 3.65 | 1932149.0 |
| 2009-02-06 | AAWW-DELISTED | Stock | 13.28 | 17.5499 | 13.22 | 16.94 | 443896.0 |
| 2009-02-06 | AAXJ | Stock | 32.78 | 33.29 | 32.74 | 33.29 | 100228.0 |
| 2009-02-06 | AAXN-DELISTED | Stock | 5.52 | 5.78 | 5.52 | 5.72 | 690677.0 |
| 2009-02-06 | AB | Stock | 16.91 | 17.97 | 16.91 | 17.36 | 503000.0 |
| 2009-02-06 | ABAX-DELISTED | Stock | 18.13 | 19.4875 | 17.99 | 18.84 | 263250.0 |
| 2009-02-06 | ABB-DELISTED | Stock | 13.73 | 14.31 | 13.73 | 14.25 | 3814767.0 |
| 2009-02-06 | ABBC-DELISTED | Stock | 6.8 | 7.15 | 6.77 | 7.04 | 107530.0 |
| 2009-02-06 | ABBNY-DELISTED | Stock | 13.73 | 14.31 | 13.73 | 14.24 | 3816017.0 |
| 2009-02-06 | ABC-DELISTED | Stock | 19.18 | 19.55 | 19.1 | 19.37 | 3157244.0 |
| 2009-02-06 | ABCB | Stock | 8.4036 | 8.4133 | 7.3824 | 8.4133 | 38966.0 |
| 2009-02-06 | ABCO-DELISTED | Stock | 8.298 | 8.418 | 7.952 | 8.177 | 626915.0 |
| 2009-02-06 | ABCW-DELISTED | Stock | 1.8379 | 2.1005 | 1.8379 | 2.05 | 87320.0 |
| 2009-02-06 | ABD-DELISTED | Stock | 1.8 | 2.0 | 1.8 | 1.98 | 215020.0 |
| 2009-02-06 | ABE-DELISTED | Stock | 12.77 | 13.1 | 12.77 | 13.04 | 17275.0 |
| 2009-02-06 | ABEO | Stock | 1050.0 | 1250.0 | 1050.0 | 1250.0 | 13.0 |
| 2009-02-06 | ABFS-DELISTED | Stock | 24.95 | 26.9 | 24.95 | 26.12 | 554927.0 |
| 2009-02-06 | ABG | Stock | 3.7 | 4.42 | 3.7 | 4.41 | 326900.0 |
| 2009-02-06 | ABII-DELISTED | Stock | 70.61 | 72.0 | 70.61 | 71.71 | 36982.0 |
| 2009-02-06 | ABK-DELISTED | Stock | 1.15 | 1.36 | 1.12 | 1.35 | 27093040.0 |
| 2009-02-06 | ABM | Stock | 14.18 | 15.09 | 14.18 | 15.05 | 365700.0 |
| 2009-02-06 | ABMD-DELISTED | Stock | 9.53 | 10.09 | 9.0 | 9.44 | 1130914.0 |
| 2009-02-06 | ABR | Stock | 1.5 | 1.7 | 1.48 | 1.58 | 146800.0 |
| 2009-02-06 | ABT | Stock | 27.0991 | 27.4638 | 27.0463 | 27.4206 | 21686536.0 |
| 2009-02-06 | ABTL-DELISTED | Stock | 2.05 | 2.15 | 1.9 | 2.15 | 4550.0 |
| 2009-02-06 | ABV-DELISTED | Stock | 43.53 | 45.21 | 43.3 | 44.87 | 784808.0 |
| 2009-02-06 | ABVA-DELISTED | Stock | 1.47 | 1.47 | 1.05 | 1.17 | 9300.0 |
| 2009-02-06 | ABVT-DELISTED | Stock | 36.0 | 39.9 | 36.0 | 39.9 | 601.0 |
| 2009-02-06 | ABX-DELISTED | Stock | 37.63 | 39.63 | 37.63 | 39.18 | 10509186.0 |
| 2009-02-06 | ACAD | Stock | 0.99 | 1.0 | 0.98 | 1.0 | 59400.0 |
| 2009-02-06 | ACAP-DELISTED | Stock | 42.35 | 43.19 | 41.53 | 42.93 | 39270.0 |
| 2009-02-06 | ACAS-DELISTED | Stock | 2.5 | 2.83 | 2.5 | 2.7 | 4622091.0 |
| 2009-02-06 | ACAT-DELISTED | Stock | 4.241 | 4.482 | 4.236 | 4.4 | 45723.0 |
> showing 50 of 5,727 rows — these rows as CSV