PREVIEW / stock_daily / 2010-04-14
file: by_date/stock_daily/2010/2010-04-14.parquet size: 193 KB rows: 5,964 symbols: 3,519
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-14 | AAPL | Stock | 8.76 | 8.7789 | 8.7168 | 8.7746 | 404076400.0 |
| 2010-04-14 | MSFT | Stock | 30.79 | 31.0 | 30.66 | 30.82 | 68941200.0 |
| 2010-04-14 | NVDA | Stock | 0.451 | 0.4532 | 0.44 | 0.447 | 900720000.0 |
| 2010-04-14 | AMZN | Stock | 7.017 | 7.225 | 6.96 | 7.214 | 158006000.0 |
| 2010-04-14 | TLT | Stock | 89.76 | 89.87 | 89.11 | 89.11 | 3570297.0 |
| 2010-04-14 | ES | Stock | 27.75 | 27.88 | 27.59 | 27.87 | 574200.0 |
| 2010-04-14 | CL | Stock | 42.195 | 42.365 | 41.965 | 42.32 | 2644800.0 |
| 2010-04-14 | A | Stock | 24.2775 | 24.7496 | 24.2775 | 24.6137 | 11638210.0 |
| 2010-04-14 | AABA-DELISTED | Stock | 18.17 | 18.47 | 18.06 | 18.3775 | 39634684.0 |
| 2010-04-14 | AACC-DELISTED | Stock | 6.56 | 6.79 | 6.55 | 6.78 | 21639.0 |
| 2010-04-14 | AACG | Stock | 3.6 | 3.61 | 3.5 | 3.58 | 6600.0 |
| 2010-04-14 | AAI-DELISTED | Stock | 5.56 | 5.92 | 5.56 | 5.9 | 6017144.0 |
| 2010-04-14 | AAIC-DELISTED | Stock | 19.75 | 20.46 | 19.75 | 20.28 | 63003.0 |
| 2010-04-14 | AAME | Stock | 1.45 | 1.49 | 1.45 | 1.49 | 200.0 |
| 2010-04-14 | AAON | Stock | 4.5432 | 4.6499 | 4.5195 | 4.636 | 1280306.0 |
| 2010-04-14 | AAP | Stock | 43.23 | 45.33 | 43.19 | 45.28 | 3119800.0 |
| 2010-04-14 | AATI-DELISTED | Stock | 3.81 | 4.04 | 3.81 | 4.03 | 363851.0 |
| 2010-04-14 | AAU-DELISTED | Stock | 1.15 | 1.15 | 1.1 | 1.1201 | 111790.0 |
| 2010-04-14 | AAUAF-DELISTED | Stock | 1.15 | 1.15 | 1.1 | 1.1201 | 113090.0 |
| 2010-04-14 | AAV-DELISTED | Stock | 7.0 | 7.28 | 6.97 | 7.23 | 747595.0 |
| 2010-04-14 | AAWW-DELISTED | Stock | 57.74 | 58.38 | 56.68 | 58.2 | 301134.0 |
| 2010-04-14 | AAXJ | Stock | 58.99 | 59.46 | 58.94 | 59.36 | 159516.0 |
| 2010-04-14 | AAXN-DELISTED | Stock | 5.39 | 5.43 | 5.33 | 5.42 | 605011.0 |
| 2010-04-14 | AB | Stock | 33.93 | 35.0 | 33.1 | 33.76 | 656600.0 |
| 2010-04-14 | ABAX-DELISTED | Stock | 26.75 | 27.46 | 26.74 | 27.05 | 178015.0 |
| 2010-04-14 | ABB-DELISTED | Stock | 22.42 | 22.6 | 22.322 | 22.57 | 1915585.0 |
| 2010-04-14 | ABBC-DELISTED | Stock | 8.2 | 8.37 | 8.1 | 8.36 | 29326.0 |
| 2010-04-14 | ABBNY-DELISTED | Stock | 22.42 | 22.6 | 22.322 | 22.56 | 1940588.0 |
| 2010-04-14 | ABC-DELISTED | Stock | 29.38 | 29.5 | 28.9122 | 29.111 | 2761162.0 |
| 2010-04-14 | ABCB | Stock | 9.5943 | 10.1417 | 9.2559 | 10.0621 | 64707.0 |
| 2010-04-14 | ABCD-DELISTED | Stock | 5.1 | 5.1 | 4.94 | 4.97 | 50923.0 |
| 2010-04-14 | ABCO-DELISTED | Stock | 16.315 | 16.705 | 16.315 | 16.705 | 42457.0 |
| 2010-04-14 | ABCW-DELISTED | Stock | 1.09 | 1.11 | 1.04 | 1.06 | 206390.0 |
| 2010-04-14 | ABD-DELISTED | Stock | 7.57 | 7.96 | 7.51 | 7.88 | 257090.0 |
| 2010-04-14 | ABE-DELISTED | Stock | 17.37 | 17.45 | 17.25 | 17.4338 | 7956.0 |
| 2010-04-14 | ABEO | Stock | 3137.5 | 3187.5 | 3137.5 | 3187.5 | 56.0 |
| 2010-04-14 | ABFS-DELISTED | Stock | 30.0 | 30.95 | 30.0 | 30.62 | 763918.0 |
| 2010-04-14 | ABG | Stock | 13.54 | 13.92 | 13.54 | 13.86 | 142600.0 |
| 2010-04-14 | ABII-DELISTED | Stock | 51.54 | 51.9499 | 51.21 | 51.38 | 126663.0 |
| 2010-04-14 | ABK-DELISTED | Stock | 1.88 | 2.06 | 1.71 | 1.85 | 227522150.0 |
| 2010-04-14 | ABM | Stock | 21.34 | 21.43 | 21.08 | 21.39 | 109900.0 |
| 2010-04-14 | ABMD-DELISTED | Stock | 9.49 | 9.72 | 9.49 | 9.63 | 135690.0 |
| 2010-04-14 | ABR | Stock | 4.2 | 4.26 | 4.03 | 4.2 | 207000.0 |
| 2010-04-14 | ABT | Stock | 25.1511 | 25.1703 | 24.916 | 25.0983 | 19029179.0 |
| 2010-04-14 | ABTL-DELISTED | Stock | 4.85 | 4.95 | 4.8 | 4.95 | 10641.0 |
| 2010-04-14 | ABV-DELISTED | Stock | 97.0 | 98.59 | 96.85 | 98.52 | 689152.0 |
| 2010-04-14 | ABVT-DELISTED | Stock | 51.32 | 53.32 | 50.82 | 53.17 | 367480.0 |
| 2010-04-14 | ABX-DELISTED | Stock | 41.2 | 41.36 | 40.36 | 40.7 | 7902470.0 |
| 2010-04-14 | ACAD | Stock | 1.94 | 2.0 | 1.72 | 1.77 | 3955500.0 |
| 2010-04-14 | ACAP-DELISTED | Stock | 33.05 | 33.05 | 32.18 | 32.57 | 32359.0 |
> showing 50 of 5,964 rows — these rows as CSV