PREVIEW / stock_daily / 2010-06-22
file: by_date/stock_daily/2010/2010-06-22.parquet size: 189 KB rows: 5,930 symbols: 3,490
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-06-22 | AAPL | Stock | 9.72 | 9.8561 | 9.6964 | 9.7804 | 717262000.0 |
| 2010-06-22 | MSFT | Stock | 26.16 | 26.45 | 25.76 | 25.77 | 55985400.0 |
| 2010-06-22 | NVDA | Stock | 0.304 | 0.3078 | 0.2875 | 0.289 | 818164000.0 |
| 2010-06-22 | AMZN | Stock | 6.1325 | 6.2615 | 6.0775 | 6.1155 | 124144000.0 |
| 2010-06-22 | TLT | Stock | 97.68 | 98.6 | 97.42 | 98.57 | 5661562.0 |
| 2010-06-22 | ES | Stock | 26.7 | 26.74 | 26.02 | 26.06 | 1264200.0 |
| 2010-06-22 | CL | Stock | 40.585 | 40.975 | 40.42 | 40.47 | 5446200.0 |
| 2010-06-22 | A | Stock | 23.1831 | 23.5479 | 22.8827 | 22.9041 | 2854856.0 |
| 2010-06-22 | AABA-DELISTED | Stock | 15.23 | 15.51 | 15.07 | 15.09 | 21647285.0 |
| 2010-06-22 | AACC-DELISTED | Stock | 4.67 | 4.85 | 4.63 | 4.68 | 123508.0 |
| 2010-06-22 | AACG | Stock | 3.16 | 3.3 | 3.16 | 3.3 | 200.0 |
| 2010-06-22 | AAI-DELISTED | Stock | 5.26 | 5.31 | 5.05 | 5.08 | 4137485.0 |
| 2010-06-22 | AAIC-DELISTED | Stock | 20.25 | 20.45 | 20.13 | 20.28 | 34958.0 |
| 2010-06-22 | AAME | Stock | 1.5 | 1.5 | 1.47 | 1.48 | 2400.0 |
| 2010-06-22 | AAON | Stock | 4.8751 | 4.9225 | 4.7743 | 4.7901 | 312356.0 |
| 2010-06-22 | AAP | Stock | 51.35 | 51.95 | 50.05 | 50.32 | 1137100.0 |
| 2010-06-22 | AATI-DELISTED | Stock | 3.66 | 3.71 | 3.37 | 3.37 | 140089.0 |
| 2010-06-22 | AAU-DELISTED | Stock | 0.95 | 1.01 | 0.9301 | 0.9301 | 58320.0 |
| 2010-06-22 | AAUAF-DELISTED | Stock | 0.95 | 1.01 | 0.9301 | 0.9301 | 59220.0 |
| 2010-06-22 | AAV-DELISTED | Stock | 6.74 | 6.8 | 6.57 | 6.59 | 353747.0 |
| 2010-06-22 | AAWW-DELISTED | Stock | 52.59 | 52.75 | 50.9 | 51.19 | 188466.0 |
| 2010-06-22 | AAXJ | Stock | 55.57 | 55.79 | 54.73 | 54.75 | 674261.0 |
| 2010-06-22 | AAXN-DELISTED | Stock | 4.02 | 4.08 | 3.81 | 3.85 | 1824089.0 |
| 2010-06-22 | AB | Stock | 29.46 | 29.67 | 28.61 | 28.84 | 209200.0 |
| 2010-06-22 | ABAX-DELISTED | Stock | 22.2 | 22.63 | 21.9 | 21.94 | 52955.0 |
| 2010-06-22 | ABB-DELISTED | Stock | 18.88 | 18.94 | 18.5 | 18.54 | 2950409.0 |
| 2010-06-22 | ABBC-DELISTED | Stock | 8.89 | 9.14 | 8.89 | 8.98 | 104119.0 |
| 2010-06-22 | ABBNY-DELISTED | Stock | 18.88 | 18.94 | 18.5 | 18.55 | 3049241.0 |
| 2010-06-22 | ABC-DELISTED | Stock | 32.5 | 32.65 | 31.9 | 31.96 | 3374659.0 |
| 2010-06-22 | ABCB | Stock | 10.1716 | 10.2512 | 9.9128 | 9.9128 | 85103.0 |
| 2010-06-22 | ABCD-DELISTED | Stock | 4.52 | 4.68 | 4.41 | 4.61 | 59033.0 |
| 2010-06-22 | ABCO-DELISTED | Stock | 21.58 | 21.67 | 20.91 | 20.97 | 57906.0 |
| 2010-06-22 | ABCW-DELISTED | Stock | 0.6894 | 0.6895 | 0.6506 | 0.67 | 60340.0 |
| 2010-06-22 | ABD-DELISTED | Stock | 5.3 | 5.7 | 5.27 | 5.46 | 905470.0 |
| 2010-06-22 | ABE-DELISTED | Stock | 16.3 | 16.3 | 15.96 | 15.96 | 10127.0 |
| 2010-06-22 | ABEO | Stock | 3000.0 | 3000.0 | 2675.0 | 2800.0 | 40.0 |
| 2010-06-22 | ABFS-DELISTED | Stock | 21.2 | 21.259 | 19.78 | 19.85 | 512494.0 |
| 2010-06-22 | ABG | Stock | 11.83 | 12.07 | 11.28 | 11.36 | 386200.0 |
| 2010-06-22 | ABII-DELISTED | Stock | 60.88 | 61.69 | 59.855 | 60.69 | 50210.0 |
| 2010-06-22 | ABK-DELISTED | Stock | 0.78 | 0.7899 | 0.7516 | 0.7714 | 4945334.0 |
| 2010-06-22 | ABM | Stock | 22.68 | 22.9 | 22.04 | 22.09 | 148800.0 |
| 2010-06-22 | ABMD-DELISTED | Stock | 9.52 | 9.87 | 9.425 | 9.54 | 131007.0 |
| 2010-06-22 | ABR | Stock | 5.43 | 5.57 | 5.1 | 5.26 | 261900.0 |
| 2010-06-22 | ABT | Stock | 23.1839 | 23.3711 | 23.0064 | 23.0256 | 12384327.0 |
| 2010-06-22 | ABTL-DELISTED | Stock | 6.3639 | 6.3639 | 5.8465 | 5.95 | 43632.0 |
| 2010-06-22 | ABV-DELISTED | Stock | 108.05 | 109.33 | 106.71 | 106.81 | 828990.0 |
| 2010-06-22 | ABVT-DELISTED | Stock | 48.44 | 49.4 | 48.33 | 48.44 | 138387.0 |
| 2010-06-22 | ABX-DELISTED | Stock | 44.93 | 45.53 | 44.62 | 44.74 | 6230952.0 |
| 2010-06-22 | ACAD | Stock | 1.27 | 1.28 | 1.22 | 1.22 | 348900.0 |
| 2010-06-22 | ACAP-DELISTED | Stock | 31.56 | 32.01 | 31.31 | 31.5 | 31091.0 |
> showing 50 of 5,930 rows — these rows as CSV