PREVIEW / stock_daily / 2010-08-16
file: by_date/stock_daily/2010/2010-08-16.parquet size: 189 KB rows: 5,972 symbols: 3,509
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-08-16 | AAPL | Stock | 8.8421 | 8.9289 | 8.8079 | 8.8443 | 318430000.0 |
| 2010-08-16 | MSFT | Stock | 24.36 | 24.61 | 24.3 | 24.5 | 40909700.0 |
| 2010-08-16 | NVDA | Stock | 0.2315 | 0.2362 | 0.2258 | 0.2288 | 814008000.0 |
| 2010-08-16 | AMZN | Stock | 6.1805 | 6.3685 | 6.152 | 6.3035 | 80494000.0 |
| 2010-08-16 | TSLA | Stock | 1.23 | 1.2533 | 1.2173 | 1.252 | 7287000.0 |
| 2010-08-16 | TLT | Stock | 104.21 | 104.89 | 104.07 | 104.85 | 7980454.0 |
| 2010-08-16 | ES | Stock | 28.61 | 28.91 | 28.41 | 28.85 | 861000.0 |
| 2010-08-16 | CL | Stock | 37.955 | 38.155 | 37.755 | 38.085 | 4632400.0 |
| 2010-08-16 | A | Stock | 19.392 | 19.7997 | 19.3133 | 19.4278 | 4635908.0 |
| 2010-08-16 | AABA-DELISTED | Stock | 13.75 | 13.9 | 13.68 | 13.8 | 11351526.0 |
| 2010-08-16 | AACC-DELISTED | Stock | 3.96 | 4.24 | 3.92 | 4.11 | 22772.0 |
| 2010-08-16 | AACG | Stock | 2.92 | 2.94 | 2.92 | 2.94 | 300.0 |
| 2010-08-16 | AAI-DELISTED | Stock | 4.49 | 4.68 | 4.49 | 4.56 | 1826186.0 |
| 2010-08-16 | AAIC-DELISTED | Stock | 19.8 | 19.95 | 19.6 | 19.93 | 48095.0 |
| 2010-08-16 | AAME | Stock | 1.21 | 1.21 | 1.21 | 1.21 | 400.0 |
| 2010-08-16 | AAON | Stock | 4.4444 | 4.4662 | 4.3536 | 4.3852 | 247050.0 |
| 2010-08-16 | AAP | Stock | 53.95 | 54.73 | 53.82 | 54.3 | 1235900.0 |
| 2010-08-16 | AATI-DELISTED | Stock | 3.01 | 3.27 | 3.01 | 3.19 | 93626.0 |
| 2010-08-16 | AAU-DELISTED | Stock | 1.81 | 1.9099 | 1.72 | 1.72 | 822386.0 |
| 2010-08-16 | AAUAF-DELISTED | Stock | 1.81 | 1.9099 | 1.72 | 1.72 | 824686.0 |
| 2010-08-16 | AAV-DELISTED | Stock | 5.99 | 6.06 | 5.97 | 5.98 | 321669.0 |
| 2010-08-16 | AAWW-DELISTED | Stock | 45.27 | 46.25 | 45.03 | 45.71 | 333770.0 |
| 2010-08-16 | AAXJ | Stock | 54.89 | 55.32 | 54.89 | 55.26 | 208431.0 |
| 2010-08-16 | AAXN-DELISTED | Stock | 3.85 | 3.97 | 3.85 | 3.94 | 435599.0 |
| 2010-08-16 | AB | Stock | 25.76 | 26.09 | 25.32 | 25.52 | 505900.0 |
| 2010-08-16 | ABAC-DELISTED | Stock | 4.35 | 4.42 | 4.1101 | 4.1511 | 22627.0 |
| 2010-08-16 | ABAX-DELISTED | Stock | 19.25 | 19.7 | 19.25 | 19.61 | 61087.0 |
| 2010-08-16 | ABB-DELISTED | Stock | 19.27 | 19.55 | 19.23 | 19.43 | 1863921.0 |
| 2010-08-16 | ABBC-DELISTED | Stock | 9.5 | 9.69 | 9.48 | 9.57 | 39369.0 |
| 2010-08-16 | ABBNY-DELISTED | Stock | 19.27 | 19.55 | 19.23 | 19.42 | 1869269.0 |
| 2010-08-16 | ABC-DELISTED | Stock | 28.75 | 29.03 | 28.51 | 28.73 | 2533861.0 |
| 2010-08-16 | ABCB | Stock | 8.51 | 8.8 | 8.51 | 8.64 | 135500.0 |
| 2010-08-16 | ABCD-DELISTED | Stock | 3.15 | 3.25 | 3.12 | 3.21 | 58758.0 |
| 2010-08-16 | ABCO-DELISTED | Stock | 21.08 | 21.36 | 20.92 | 21.22 | 458502.0 |
| 2010-08-16 | ABCW-DELISTED | Stock | 0.6006 | 0.6297 | 0.6006 | 0.62 | 12680.0 |
| 2010-08-16 | ABD-DELISTED | Stock | 5.95 | 6.31 | 5.88 | 6.02 | 228170.0 |
| 2010-08-16 | ABE-DELISTED | Stock | 17.08 | 17.3 | 17.07 | 17.2 | 11411.0 |
| 2010-08-16 | ABEO | Stock | 2437.5 | 2437.5 | 2250.0 | 2312.5 | 27.0 |
| 2010-08-16 | ABFS-DELISTED | Stock | 19.58 | 20.0 | 19.33 | 19.75 | 228712.0 |
| 2010-08-16 | ABG | Stock | 12.81 | 13.0 | 12.56 | 12.71 | 167400.0 |
| 2010-08-16 | ABII-DELISTED | Stock | 75.32 | 75.5 | 75.15 | 75.44 | 93793.0 |
| 2010-08-16 | ABK-DELISTED | Stock | 0.66 | 0.6744 | 0.6405 | 0.6626 | 9667120.0 |
| 2010-08-16 | ABM | Stock | 19.98 | 20.43 | 19.98 | 20.36 | 99100.0 |
| 2010-08-16 | ABMD-DELISTED | Stock | 9.84 | 9.96 | 9.7598 | 9.79 | 161393.0 |
| 2010-08-16 | ABR | Stock | 5.0 | 5.25 | 5.0 | 5.03 | 42800.0 |
| 2010-08-16 | ABT | Stock | 24.014 | 24.1963 | 23.8796 | 24.1531 | 9995415.0 |
| 2010-08-16 | ABTL-DELISTED | Stock | 4.505 | 4.505 | 4.2672 | 4.5 | 8890.0 |
| 2010-08-16 | ABV-DELISTED | Stock | 104.92 | 108.25 | 104.36 | 107.12 | 606217.0 |
| 2010-08-16 | ABVA-DELISTED | Stock | 2.94 | 3.13 | 2.94 | 3.1 | 4689.0 |
| 2010-08-16 | ABVT-DELISTED | Stock | 49.09 | 50.76 | 49.02 | 50.72 | 214691.0 |
> showing 50 of 5,972 rows — these rows as CSV