PREVIEW / stock_daily / 2009-03-03
file: by_date/stock_daily/2009/2009-03-03.parquet size: 174 KB rows: 5,796 symbols: 3,465
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-03-03 | AAPL | Stock | 3.1761 | 3.2407 | 3.1386 | 3.1561 | 724340400.0 |
| 2009-03-03 | MSFT | Stock | 16.03 | 16.24 | 15.64 | 15.88 | 80476600.0 |
| 2009-03-03 | NVDA | Stock | 0.193 | 0.2045 | 0.1868 | 0.197 | 1041372000.0 |
| 2009-03-03 | AMZN | Stock | 3.1375 | 3.1645 | 3.065 | 3.085 | 193832000.0 |
| 2009-03-03 | TLT | Stock | 102.23 | 103.57 | 101.81 | 102.59 | 3084808.0 |
| 2009-03-03 | ES | Stock | 21.27 | 21.35 | 20.04 | 20.07 | 1996000.0 |
| 2009-03-03 | CL | Stock | 29.205 | 29.4 | 28.5 | 28.66 | 7474400.0 |
| 2009-03-03 | A | Stock | 9.2203 | 9.3419 | 8.8841 | 9.0701 | 7055147.0 |
| 2009-03-03 | AABA-DELISTED | Stock | 12.79 | 12.87 | 12.31 | 12.5 | 16465355.0 |
| 2009-03-03 | AACC-DELISTED | Stock | 3.35 | 3.36 | 3.3 | 3.31 | 72994.0 |
| 2009-03-03 | AACG | Stock | 5.05 | 5.32 | 5.05 | 5.32 | 7700.0 |
| 2009-03-03 | AAI-DELISTED | Stock | 2.6 | 2.64 | 2.441 | 2.46 | 3038965.0 |
| 2009-03-03 | AAIC-DELISTED | Stock | 2.4 | 2.8 | 2.4 | 2.6 | 399146.0 |
| 2009-03-03 | AAME | Stock | 0.62 | 0.62 | 0.61 | 0.61 | 6700.0 |
| 2009-03-03 | AAON | Stock | 2.9807 | 3.0321 | 2.8721 | 2.957 | 454612.0 |
| 2009-03-03 | AAP | Stock | 38.31 | 39.5 | 37.62 | 38.32 | 4830600.0 |
| 2009-03-03 | AATI-DELISTED | Stock | 2.99 | 3.08 | 2.94 | 2.95 | 124041.0 |
| 2009-03-03 | AAU-DELISTED | Stock | 0.7 | 0.75 | 0.69 | 0.71 | 92353.0 |
| 2009-03-03 | AAUAF-DELISTED | Stock | 0.7 | 0.75 | 0.69 | 0.71 | 93353.0 |
| 2009-03-03 | AAV-DELISTED | Stock | 2.02 | 2.06 | 1.87 | 1.9 | 1326346.0 |
| 2009-03-03 | AAWW-DELISTED | Stock | 12.78 | 13.34 | 11.94 | 11.99 | 187898.0 |
| 2009-03-03 | AAXJ | Stock | 27.34 | 27.614 | 26.86 | 27.18 | 61434.0 |
| 2009-03-03 | AAXN-DELISTED | Stock | 3.65 | 3.6799 | 3.11 | 3.12 | 933163.0 |
| 2009-03-03 | AB | Stock | 11.26 | 11.99 | 10.53 | 10.89 | 850800.0 |
| 2009-03-03 | ABAX-DELISTED | Stock | 14.88 | 16.26 | 14.47 | 15.71 | 393536.0 |
| 2009-03-03 | ABB-DELISTED | Stock | 11.31 | 11.43 | 10.97 | 11.19 | 6539721.0 |
| 2009-03-03 | ABBC-DELISTED | Stock | 7.06 | 7.06 | 6.75 | 6.75 | 82336.0 |
| 2009-03-03 | ABBNY-DELISTED | Stock | 11.31 | 11.43 | 10.97 | 11.19 | 6541959.0 |
| 2009-03-03 | ABC-DELISTED | Stock | 15.42 | 15.67 | 15.0138 | 15.18 | 5185574.0 |
| 2009-03-03 | ABCB | Stock | 4.6201 | 4.6201 | 3.6572 | 3.7738 | 37321.0 |
| 2009-03-03 | ABCO-DELISTED | Stock | 7.327 | 7.327 | 6.8926 | 7.028 | 233295.0 |
| 2009-03-03 | ABCW-DELISTED | Stock | 0.5881 | 0.6424 | 0.371 | 0.38 | 2201620.0 |
| 2009-03-03 | ABD-DELISTED | Stock | 1.7 | 1.71 | 1.1799 | 1.2 | 348660.0 |
| 2009-03-03 | ABE-DELISTED | Stock | 10.36 | 10.5 | 10.33 | 10.45 | 44434.0 |
| 2009-03-03 | ABEO | Stock | 1312.5 | 1437.5 | 1312.5 | 1437.5 | 4.0 |
| 2009-03-03 | ABFS-DELISTED | Stock | 16.53 | 16.57 | 15.87 | 16.1 | 463979.0 |
| 2009-03-03 | ABG | Stock | 2.77 | 2.84 | 2.56 | 2.57 | 167500.0 |
| 2009-03-03 | ABII-DELISTED | Stock | 57.52 | 60.28 | 55.51 | 59.56 | 91734.0 |
| 2009-03-03 | ABK-DELISTED | Stock | 0.611 | 0.66 | 0.46 | 0.48 | 14688901.0 |
| 2009-03-03 | ABM | Stock | 12.19 | 14.98 | 11.97 | 14.59 | 2040200.0 |
| 2009-03-03 | ABMD-DELISTED | Stock | 6.15 | 6.3 | 5.95 | 5.97 | 300378.0 |
| 2009-03-03 | ABR | Stock | 0.58 | 0.68 | 0.58 | 0.64 | 151500.0 |
| 2009-03-03 | ABT | Stock | 22.7185 | 22.8289 | 21.9796 | 21.9844 | 27979783.0 |
| 2009-03-03 | ABTL-DELISTED | Stock | 1.85 | 1.85 | 1.75 | 1.75 | 4025.0 |
| 2009-03-03 | ABV-DELISTED | Stock | 37.83 | 37.86 | 36.63 | 37.42 | 1211131.0 |
| 2009-03-03 | ABVA-DELISTED | Stock | 1.5001 | 1.693 | 1.5 | 1.52 | 3600.0 |
| 2009-03-03 | ABX-DELISTED | Stock | 27.76 | 28.97 | 26.83 | 28.43 | 20354390.0 |
| 2009-03-03 | ACAD | Stock | 0.8 | 0.85 | 0.76 | 0.82 | 67500.0 |
| 2009-03-03 | ACAP-DELISTED | Stock | 41.54 | 42.61 | 38.89 | 38.9 | 92653.0 |
| 2009-03-03 | ACAS-DELISTED | Stock | 1.08 | 1.08 | 0.74 | 0.75 | 50615711.0 |
> showing 50 of 5,796 rows — these rows as CSV