PREVIEW / stock_daily / 2010-02-17
file: by_date/stock_daily/2010/2010-02-17.parquet size: 188 KB rows: 5,910 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 |
|---|---|---|---|---|---|---|---|
| 2010-02-17 | AAPL | Stock | 7.2925 | 7.2968 | 7.1736 | 7.2339 | 436396800.0 |
| 2010-02-17 | MSFT | Stock | 28.53 | 28.65 | 28.36 | 28.59 | 45882900.0 |
| 2010-02-17 | NVDA | Stock | 0.4472 | 0.4475 | 0.4332 | 0.446 | 876560000.0 |
| 2010-02-17 | AMZN | Stock | 5.8535 | 5.8565 | 5.7775 | 5.8155 | 178896000.0 |
| 2010-02-17 | TLT | Stock | 89.92 | 90.09 | 89.08 | 89.33 | 4368839.0 |
| 2010-02-17 | ES | Stock | 25.92 | 26.03 | 25.78 | 25.85 | 1177000.0 |
| 2010-02-17 | CL | Stock | 40.41 | 40.69 | 40.275 | 40.6 | 3467800.0 |
| 2010-02-17 | A | Stock | 21.7167 | 21.9886 | 21.5522 | 21.9099 | 4891183.0 |
| 2010-02-17 | AABA-DELISTED | Stock | 15.5 | 15.52 | 15.32 | 15.44 | 12546046.0 |
| 2010-02-17 | AACC-DELISTED | Stock | 5.6 | 5.67 | 5.6 | 5.61 | 37165.0 |
| 2010-02-17 | AACG | Stock | 3.55 | 3.6 | 3.31 | 3.37 | 25300.0 |
| 2010-02-17 | AAI-DELISTED | Stock | 5.05 | 5.05 | 4.91 | 4.94 | 2381797.0 |
| 2010-02-17 | AAIC-DELISTED | Stock | 17.79 | 17.79 | 16.92 | 17.27 | 112824.0 |
| 2010-02-17 | AAON | Stock | 4.1975 | 4.2133 | 4.162 | 4.2114 | 271856.0 |
| 2010-02-17 | AAP | Stock | 42.68 | 43.08 | 42.16 | 42.88 | 2253400.0 |
| 2010-02-17 | AATI-DELISTED | Stock | 3.51 | 3.58 | 3.45 | 3.49 | 119622.0 |
| 2010-02-17 | AAU-DELISTED | Stock | 0.99 | 0.99 | 0.952 | 0.97 | 73618.0 |
| 2010-02-17 | AAUAF-DELISTED | Stock | 0.99 | 0.99 | 0.952 | 0.97 | 79618.0 |
| 2010-02-17 | AAV-DELISTED | Stock | 7.08 | 7.17 | 7.04 | 7.09 | 680865.0 |
| 2010-02-17 | AAWW-DELISTED | Stock | 40.6 | 40.9599 | 39.91 | 40.2 | 188551.0 |
| 2010-02-17 | AAXJ | Stock | 53.41 | 53.63 | 53.2903 | 53.39 | 57785.0 |
| 2010-02-17 | AAXN-DELISTED | Stock | 6.0 | 6.5 | 5.9895 | 6.4 | 1666465.0 |
| 2010-02-17 | AB | Stock | 27.44 | 27.63 | 27.08 | 27.28 | 433400.0 |
| 2010-02-17 | ABAX-DELISTED | Stock | 25.37 | 25.37 | 25.01 | 25.12 | 66472.0 |
| 2010-02-17 | ABB-DELISTED | Stock | 18.36 | 18.58 | 18.3 | 18.5 | 2457740.0 |
| 2010-02-17 | ABBC-DELISTED | Stock | 7.58 | 7.58 | 7.46 | 7.53 | 21487.0 |
| 2010-02-17 | ABBNY-DELISTED | Stock | 18.36 | 18.58 | 18.3 | 18.51 | 2459635.0 |
| 2010-02-17 | ABC-DELISTED | Stock | 27.73 | 27.78 | 27.06 | 27.6 | 5818010.0 |
| 2010-02-17 | ABCB | Stock | 9.5013 | 9.5309 | 9.3828 | 9.5309 | 49815.0 |
| 2010-02-17 | ABCD-DELISTED | Stock | 3.73 | 3.8 | 3.7208 | 3.8 | 72313.0 |
| 2010-02-17 | ABCO-DELISTED | Stock | 16.375 | 16.495 | 16.235 | 16.415 | 50156.0 |
| 2010-02-17 | ABCW-DELISTED | Stock | 1.17 | 1.24 | 1.17 | 1.22 | 87800.0 |
| 2010-02-17 | ABD-DELISTED | Stock | 7.53 | 7.61 | 7.45 | 7.48 | 341970.0 |
| 2010-02-17 | ABE-DELISTED | Stock | 16.22 | 16.3 | 16.19 | 16.21 | 21515.0 |
| 2010-02-17 | ABEO | Stock | 3337.5 | 3437.5 | 3312.5 | 3437.5 | 8.0 |
| 2010-02-17 | ABFS-DELISTED | Stock | 24.93 | 25.34 | 24.38 | 25.28 | 1059967.0 |
| 2010-02-17 | ABG | Stock | 11.51 | 11.76 | 11.47 | 11.58 | 149700.0 |
| 2010-02-17 | ABII-DELISTED | Stock | 33.92 | 35.19 | 33.75 | 33.97 | 118438.0 |
| 2010-02-17 | ABK-DELISTED | Stock | 0.61 | 0.71 | 0.6 | 0.7 | 21101522.0 |
| 2010-02-17 | ABM | Stock | 19.9 | 19.93 | 19.63 | 19.92 | 90600.0 |
| 2010-02-17 | ABMD-DELISTED | Stock | 9.85 | 9.94 | 9.59 | 9.85 | 183237.0 |
| 2010-02-17 | ABR | Stock | 2.33 | 2.43 | 2.3 | 2.42 | 155700.0 |
| 2010-02-17 | ABT | Stock | 26.2882 | 26.3794 | 26.1827 | 26.269 | 13285744.0 |
| 2010-02-17 | ABTL-DELISTED | Stock | 5.5 | 5.55 | 5.45 | 5.45 | 15465.0 |
| 2010-02-17 | ABV-DELISTED | Stock | 95.35 | 99.3799 | 95.35 | 99.19 | 997808.0 |
| 2010-02-17 | ABVA-DELISTED | Stock | 2.65 | 2.67 | 2.4 | 2.46 | 11526.0 |
| 2010-02-17 | ABVT-DELISTED | Stock | 60.36 | 62.0 | 59.5 | 61.94 | 97735.0 |
| 2010-02-17 | ABX-DELISTED | Stock | 37.44 | 38.24 | 37.36 | 37.93 | 15738004.0 |
| 2010-02-17 | ACAD | Stock | 1.35 | 1.35 | 1.28 | 1.33 | 328600.0 |
| 2010-02-17 | ACAP-DELISTED | Stock | 27.5 | 27.61 | 27.12 | 27.38 | 57596.0 |
> showing 50 of 5,910 rows — these rows as CSV