PREVIEW / stock_daily / 2011-05-10
file: by_date/stock_daily/2011/2011-05-10.parquet size: 199 KB rows: 6,100 symbols: 3,559
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-10 | AAPL | Stock | 12.4604 | 12.4889 | 12.3807 | 12.4804 | 282091600.0 |
| 2011-05-10 | MSFT | Stock | 25.38 | 25.85 | 25.25 | 25.67 | 120798700.0 |
| 2011-05-10 | NVDA | Stock | 0.4978 | 0.4982 | 0.4895 | 0.4945 | 690976000.0 |
| 2011-05-10 | AMZN | Stock | 10.097 | 10.2645 | 10.078 | 10.197 | 117718000.0 |
| 2011-05-10 | TSLA | Stock | 1.8827 | 1.93 | 1.8607 | 1.8887 | 23029500.0 |
| 2011-05-10 | TLT | Stock | 94.7 | 94.89 | 94.29 | 94.29 | 5458553.0 |
| 2011-05-10 | ES | Stock | 35.53 | 36.02 | 35.52 | 35.75 | 2005700.0 |
| 2011-05-10 | CL | Stock | 42.515 | 42.815 | 42.515 | 42.73 | 3917200.0 |
| 2011-05-10 | A | Stock | 35.8369 | 36.2947 | 35.4649 | 36.2446 | 5826584.0 |
| 2011-05-10 | AABA-DELISTED | Stock | 18.68 | 18.7 | 18.42 | 18.55 | 13279985.0 |
| 2011-05-10 | AACC-DELISTED | Stock | 5.09 | 5.09 | 4.85 | 4.85 | 42042.0 |
| 2011-05-10 | AACG | Stock | 8.64 | 8.65 | 8.31 | 8.5 | 5700.0 |
| 2011-05-10 | AAIC-DELISTED | Stock | 29.21 | 29.77 | 29.2 | 29.77 | 94525.0 |
| 2011-05-10 | AAME | Stock | 2.06 | 2.07 | 1.94 | 2.07 | 4800.0 |
| 2011-05-10 | AAON | Stock | 6.3802 | 6.4968 | 6.3546 | 6.4948 | 180731.0 |
| 2011-05-10 | AAP | Stock | 65.6 | 66.44 | 65.6 | 66.28 | 830600.0 |
| 2011-05-10 | AAT | Stock | 21.76 | 22.13 | 21.76 | 22.07 | 56200.0 |
| 2011-05-10 | AATI-DELISTED | Stock | 3.99 | 4.12 | 3.97 | 4.12 | 128790.0 |
| 2011-05-10 | AAU-DELISTED | Stock | 4.12 | 4.32 | 4.11 | 4.22 | 443213.0 |
| 2011-05-10 | AAUAF-DELISTED | Stock | 4.12 | 4.32 | 4.11 | 4.22 | 443513.0 |
| 2011-05-10 | AAV-DELISTED | Stock | 8.05 | 8.18 | 7.97 | 8.09 | 161527.0 |
| 2011-05-10 | AAWW-DELISTED | Stock | 63.75 | 65.24 | 63.61 | 65.2 | 248855.0 |
| 2011-05-10 | AAXJ | Stock | 63.75 | 64.3 | 63.63 | 64.23 | 858606.0 |
| 2011-05-10 | AAXN-DELISTED | Stock | 4.47 | 4.68 | 4.39 | 4.595 | 580205.0 |
| 2011-05-10 | AB | Stock | 22.5 | 22.7 | 22.41 | 22.62 | 311600.0 |
| 2011-05-10 | ABAC-DELISTED | Stock | 2.86 | 3.28 | 2.75 | 3.28 | 174093.0 |
| 2011-05-10 | ABAX-DELISTED | Stock | 27.96 | 28.16 | 27.71 | 28.09 | 77964.0 |
| 2011-05-10 | ABB-DELISTED | Stock | 26.55 | 26.85 | 26.44 | 26.67 | 2307297.0 |
| 2011-05-10 | ABBC-DELISTED | Stock | 11.79 | 12.06 | 11.76 | 11.87 | 203488.0 |
| 2011-05-10 | ABBNY-DELISTED | Stock | 26.55 | 26.85 | 26.44 | 26.68 | 2307887.0 |
| 2011-05-10 | ABC-DELISTED | Stock | 42.26 | 42.42 | 41.96 | 42.32 | 2049727.0 |
| 2011-05-10 | ABCB | Stock | 9.28 | 9.48 | 9.25 | 9.45 | 39100.0 |
| 2011-05-10 | ABCD-DELISTED | Stock | 3.38 | 3.38 | 3.2 | 3.24 | 16364.0 |
| 2011-05-10 | ABCO-DELISTED | Stock | 25.39 | 25.89 | 25.39 | 25.71 | 170143.0 |
| 2011-05-10 | ABCW-DELISTED | Stock | 0.74 | 0.76 | 0.74 | 0.75 | 84260.0 |
| 2011-05-10 | ABD-DELISTED | Stock | 9.46 | 9.55 | 9.34 | 9.49 | 127960.0 |
| 2011-05-10 | ABE-DELISTED | Stock | 18.8 | 18.93 | 18.49 | 18.93 | 12114.0 |
| 2011-05-10 | ABEO | Stock | 2675.0 | 2687.5 | 2600.0 | 2675.0 | 8.0 |
| 2011-05-10 | ABFS-DELISTED | Stock | 24.01 | 24.44 | 23.96 | 24.26 | 262996.0 |
| 2011-05-10 | ABG | Stock | 16.85 | 17.41 | 16.85 | 17.0 | 382100.0 |
| 2011-05-10 | ABH-DELISTED | Stock | 26.63 | 27.0 | 26.52 | 26.94 | 272491.0 |
| 2011-05-10 | ABM | Stock | 24.02 | 24.25 | 23.98 | 24.17 | 165200.0 |
| 2011-05-10 | ABMD-DELISTED | Stock | 17.35 | 17.79 | 17.2909 | 17.59 | 191540.0 |
| 2011-05-10 | ABR | Stock | 5.23 | 5.43 | 5.23 | 5.39 | 55000.0 |
| 2011-05-10 | ABT | Stock | 25.319 | 25.3862 | 25.2423 | 25.3526 | 8197374.0 |
| 2011-05-10 | ABTL-DELISTED | Stock | 6.275 | 6.4256 | 6.024 | 6.275 | 34379.0 |
| 2011-05-10 | ABUS | Stock | 2.94 | 2.97 | 2.69 | 2.94 | 13900.0 |
| 2011-05-10 | ABV-DELISTED | Stock | 32.22 | 32.52 | 32.15 | 32.35 | 1605052.0 |
| 2011-05-10 | ABVA-DELISTED | Stock | 6.51 | 6.53 | 6.51 | 6.53 | 2380.0 |
| 2011-05-10 | ABVT-DELISTED | Stock | 64.57 | 65.22 | 64.46 | 64.87 | 92541.0 |
> showing 50 of 6,100 rows — these rows as CSV