PREVIEW / stock_daily / 2012-02-10
file: by_date/stock_daily/2012/2012-02-10.parquet size: 199 KB rows: 6,155 symbols: 3,547
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-10 | AAPL | Stock | 17.5343 | 17.7721 | 17.4482 | 17.6221 | 631302000.0 |
| 2012-02-10 | MSFT | Stock | 30.64 | 30.8 | 30.36 | 30.5 | 44605300.0 |
| 2012-02-10 | NVDA | Stock | 0.4035 | 0.405 | 0.3953 | 0.3975 | 440268000.0 |
| 2012-02-10 | AMZN | Stock | 9.171 | 9.3815 | 9.126 | 9.277 | 115942000.0 |
| 2012-02-10 | TSLA | Stock | 2.1507 | 2.1513 | 1.9893 | 2.0733 | 28113000.0 |
| 2012-02-10 | TLT | Stock | 116.8 | 117.33 | 116.52 | 116.99 | 7193085.0 |
| 2012-02-10 | ES | Stock | 35.31 | 35.44 | 35.12 | 35.2 | 1262100.0 |
| 2012-02-10 | CL | Stock | 45.655 | 45.79 | 45.455 | 45.585 | 3855200.0 |
| 2012-02-10 | A | Stock | 31.6452 | 31.6667 | 31.123 | 31.5737 | 3698828.0 |
| 2012-02-10 | AABA-DELISTED | Stock | 16.02 | 16.31 | 16.0 | 16.13 | 25420648.0 |
| 2012-02-10 | AACC-DELISTED | Stock | 4.67 | 4.67 | 4.45 | 4.5 | 21437.0 |
| 2012-02-10 | AACG | Stock | 7.24 | 7.24 | 6.85 | 7.0 | 5400.0 |
| 2012-02-10 | AAIC-DELISTED | Stock | 23.9 | 23.985 | 23.7 | 23.72 | 48558.0 |
| 2012-02-10 | AAME | Stock | 2.03 | 2.05 | 2.03 | 2.05 | 700.0 |
| 2012-02-10 | AAMRQ-DELISTED | Stock | 0.626 | 0.639 | 0.591 | 0.6 | 5018736.0 |
| 2012-02-10 | AAON | Stock | 5.7956 | 5.8726 | 5.6059 | 5.6148 | 170100.0 |
| 2012-02-10 | AAP | Stock | 79.18 | 80.05 | 79.02 | 79.99 | 823200.0 |
| 2012-02-10 | AAT | Stock | 22.0 | 22.29 | 21.78 | 22.05 | 62300.0 |
| 2012-02-10 | AAU-DELISTED | Stock | 2.49 | 2.63 | 2.41 | 2.51 | 251373.0 |
| 2012-02-10 | AAUAF-DELISTED | Stock | 2.49 | 2.63 | 2.41 | 2.51 | 252173.0 |
| 2012-02-10 | AAV-DELISTED | Stock | 3.7 | 3.75 | 3.6601 | 3.7 | 204221.0 |
| 2012-02-10 | AAWW-DELISTED | Stock | 49.73 | 50.36 | 48.9 | 49.46 | 370658.0 |
| 2012-02-10 | AAXJ | Stock | 56.3 | 56.3 | 55.96 | 56.28 | 1256723.0 |
| 2012-02-10 | AAXN-DELISTED | Stock | 4.86 | 4.92 | 4.8 | 4.8 | 147380.0 |
| 2012-02-10 | AB | Stock | 16.0 | 16.31 | 14.32 | 14.35 | 1298700.0 |
| 2012-02-10 | ABAC-DELISTED | Stock | 1.6 | 1.61 | 1.55 | 1.55 | 73850.0 |
| 2012-02-10 | ABAX-DELISTED | Stock | 27.61 | 27.67 | 27.26 | 27.47 | 74598.0 |
| 2012-02-10 | ABB-DELISTED | Stock | 21.4 | 21.57 | 21.34 | 21.48 | 1380262.0 |
| 2012-02-10 | ABBNY-DELISTED | Stock | 21.4 | 21.57 | 21.34 | 21.48 | 1381332.0 |
| 2012-02-10 | ABC-DELISTED | Stock | 38.81 | 38.88 | 38.38 | 38.6 | 1787954.0 |
| 2012-02-10 | ABCB | Stock | 10.98 | 11.14 | 10.92 | 10.95 | 43300.0 |
| 2012-02-10 | ABCD-DELISTED | Stock | 3.11 | 3.15 | 3.06 | 3.07 | 8894.0 |
| 2012-02-10 | ABCO-DELISTED | Stock | 36.65 | 36.7 | 36.19 | 36.42 | 192200.0 |
| 2012-02-10 | ABCW-DELISTED | Stock | 0.502 | 0.502 | 0.3012 | 0.3012 | 135050.0 |
| 2012-02-10 | ABD-DELISTED | Stock | 11.12 | 11.28 | 10.89 | 10.95 | 414280.0 |
| 2012-02-10 | ABE-DELISTED | Stock | 19.06 | 19.16 | 18.95 | 18.96 | 13651.0 |
| 2012-02-10 | ABEO | Stock | 1712.5 | 1750.0 | 1712.5 | 1750.0 | 7.0 |
| 2012-02-10 | ABFS-DELISTED | Stock | 18.89 | 19.06 | 18.61 | 18.89 | 188946.0 |
| 2012-02-10 | ABG | Stock | 24.36 | 24.77 | 24.22 | 24.68 | 194100.0 |
| 2012-02-10 | ABH-DELISTED | Stock | 14.94 | 15.29 | 14.86 | 15.27 | 354509.0 |
| 2012-02-10 | ABM | Stock | 22.42 | 22.58 | 22.18 | 22.19 | 270800.0 |
| 2012-02-10 | ABMD-DELISTED | Stock | 23.0 | 23.29 | 22.7 | 23.23 | 707396.0 |
| 2012-02-10 | ABR | Stock | 4.56 | 4.6 | 4.5 | 4.54 | 58500.0 |
| 2012-02-10 | ABT | Stock | 26.4178 | 26.461 | 26.293 | 26.4418 | 11477699.0 |
| 2012-02-10 | ABTL-DELISTED | Stock | 4.504 | 4.6 | 4.4545 | 4.6 | 7555.0 |
| 2012-02-10 | ABUS | Stock | 2.46 | 2.49 | 2.34 | 2.34 | 8200.0 |
| 2012-02-10 | ABV-DELISTED | Stock | 37.09 | 37.27 | 37.03 | 37.22 | 1897218.0 |
| 2012-02-10 | ABVT-DELISTED | Stock | 68.9 | 69.93 | 68.65 | 69.41 | 113164.0 |
| 2012-02-10 | ABX-DELISTED | Stock | 48.31 | 48.42 | 47.71 | 48.13 | 6149469.0 |
| 2012-02-10 | ACAD | Stock | 1.78 | 1.81 | 1.77 | 1.8 | 429300.0 |
> showing 50 of 6,155 rows — these rows as CSV