PREVIEW / stock_daily / 2011-08-30
file: by_date/stock_daily/2011/2011-08-30.parquet size: 194 KB rows: 6,077 symbols: 3,528
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-08-30 | AAPL | Stock | 13.8661 | 13.9943 | 13.7932 | 13.9282 | 417922400.0 |
| 2011-08-30 | MSFT | Stock | 25.73 | 26.43 | 25.7 | 26.23 | 57341400.0 |
| 2011-08-30 | NVDA | Stock | 0.3318 | 0.3448 | 0.3295 | 0.342 | 684760000.0 |
| 2011-08-30 | AMZN | Stock | 10.289 | 10.6245 | 10.216 | 10.546 | 118314000.0 |
| 2011-08-30 | TSLA | Stock | 1.6333 | 1.6513 | 1.606 | 1.642 | 5493000.0 |
| 2011-08-30 | TLT | Stock | 108.43 | 109.15 | 108.25 | 108.71 | 9508630.0 |
| 2011-08-30 | ES | Stock | 34.33 | 34.67 | 34.2 | 34.49 | 1458200.0 |
| 2011-08-30 | CL | Stock | 44.89 | 45.45 | 44.5 | 45.32 | 4772000.0 |
| 2011-08-30 | A | Stock | 26.0944 | 26.5236 | 25.6652 | 26.1946 | 5448705.0 |
| 2011-08-30 | AABA-DELISTED | Stock | 13.3 | 13.98 | 13.23 | 13.84 | 28785494.0 |
| 2011-08-30 | AACC-DELISTED | Stock | 4.04 | 4.15 | 3.94 | 4.05 | 17292.0 |
| 2011-08-30 | AACG | Stock | 8.63 | 9.09 | 8.63 | 9.09 | 800.0 |
| 2011-08-30 | AAIC-DELISTED | Stock | 26.53 | 26.68 | 25.61 | 26.09 | 44461.0 |
| 2011-08-30 | AAME | Stock | 1.98 | 1.99 | 1.94 | 1.99 | 7700.0 |
| 2011-08-30 | AAON | Stock | 5.1141 | 5.2148 | 4.9541 | 5.1852 | 132975.0 |
| 2011-08-30 | AAP | Stock | 59.99 | 60.69 | 59.65 | 60.39 | 970000.0 |
| 2011-08-30 | AAT | Stock | 19.56 | 19.82 | 19.24 | 19.7 | 74100.0 |
| 2011-08-30 | AATI-DELISTED | Stock | 5.96 | 6.02 | 5.92 | 5.99 | 371445.0 |
| 2011-08-30 | AAU-DELISTED | Stock | 3.12 | 3.26 | 3.06 | 3.23 | 294797.0 |
| 2011-08-30 | AAUAF-DELISTED | Stock | 3.12 | 3.26 | 3.06 | 3.23 | 295597.0 |
| 2011-08-30 | AAV-DELISTED | Stock | 5.68 | 5.895 | 5.57 | 5.86 | 345257.0 |
| 2011-08-30 | AAWW-DELISTED | Stock | 46.81 | 48.86 | 45.96 | 48.45 | 317625.0 |
| 2011-08-30 | AAXJ | Stock | 55.08 | 55.6185 | 54.8 | 55.27 | 231902.0 |
| 2011-08-30 | AAXN-DELISTED | Stock | 4.46 | 4.52 | 4.42 | 4.47 | 425245.0 |
| 2011-08-30 | AB | Stock | 16.42 | 17.26 | 16.42 | 17.0 | 978500.0 |
| 2011-08-30 | ABAC-DELISTED | Stock | 2.37 | 2.37 | 2.16 | 2.25 | 34563.0 |
| 2011-08-30 | ABAX-DELISTED | Stock | 25.5 | 25.75 | 24.89 | 25.37 | 87321.0 |
| 2011-08-30 | ABB-DELISTED | Stock | 20.76 | 20.95 | 20.49 | 20.82 | 2397348.0 |
| 2011-08-30 | ABBC-DELISTED | Stock | 8.57 | 8.73 | 8.4 | 8.64 | 23733.0 |
| 2011-08-30 | ABBNY-DELISTED | Stock | 20.76 | 20.95 | 20.49 | 20.83 | 2397148.0 |
| 2011-08-30 | ABC-DELISTED | Stock | 38.93 | 39.53 | 38.78 | 39.28 | 2465569.0 |
| 2011-08-30 | ABCB | Stock | 9.23 | 9.37 | 8.95 | 9.31 | 152900.0 |
| 2011-08-30 | ABCD-DELISTED | Stock | 3.09 | 3.09 | 3.03 | 3.04 | 22390.0 |
| 2011-08-30 | ABCO-DELISTED | Stock | 29.31 | 31.94 | 29.31 | 31.59 | 179355.0 |
| 2011-08-30 | ABCW-DELISTED | Stock | 0.62 | 0.66 | 0.6 | 0.62 | 47820.0 |
| 2011-08-30 | ABD-DELISTED | Stock | 6.56 | 6.79 | 6.4 | 6.7 | 168650.0 |
| 2011-08-30 | ABE-DELISTED | Stock | 18.31 | 18.5 | 18.31 | 18.5 | 6550.0 |
| 2011-08-30 | ABFS-DELISTED | Stock | 20.36 | 21.09 | 20.13 | 20.85 | 181434.0 |
| 2011-08-30 | ABG | Stock | 18.65 | 19.01 | 18.16 | 18.57 | 345400.0 |
| 2011-08-30 | ABH-DELISTED | Stock | 16.95 | 17.29 | 16.66 | 17.14 | 198958.0 |
| 2011-08-30 | ABM | Stock | 20.48 | 20.48 | 20.0 | 20.22 | 337400.0 |
| 2011-08-30 | ABMD-DELISTED | Stock | 12.08 | 12.25 | 11.88 | 12.12 | 80434.0 |
| 2011-08-30 | ABR | Stock | 3.9 | 4.17 | 3.7 | 4.11 | 61800.0 |
| 2011-08-30 | ABT | Stock | 24.4938 | 24.8872 | 24.2587 | 24.8249 | 14993331.0 |
| 2011-08-30 | ABTL-DELISTED | Stock | 4.4532 | 4.6 | 4.4047 | 4.6 | 16922.0 |
| 2011-08-30 | ABUS | Stock | 1.76 | 1.85 | 1.75 | 1.83 | 10700.0 |
| 2011-08-30 | ABV-DELISTED | Stock | 34.22 | 34.98 | 34.02 | 34.7 | 2527611.0 |
| 2011-08-30 | ABVA-DELISTED | Stock | 4.83 | 4.9 | 4.75 | 4.75 | 4045.0 |
| 2011-08-30 | ABVT-DELISTED | Stock | 59.67 | 60.65 | 59.26 | 60.32 | 85281.0 |
| 2011-08-30 | ABX-DELISTED | Stock | 50.73 | 51.21 | 50.08 | 50.88 | 8546165.0 |
> showing 50 of 6,077 rows — these rows as CSV