PREVIEW / stock_daily / 2010-12-16
file: by_date/stock_daily/2010/2010-12-16.parquet size: 196 KB rows: 6,066 symbols: 3,563
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-12-16 | AAPL | Stock | 11.4675 | 11.5218 | 11.4321 | 11.4732 | 322030800.0 |
| 2010-12-16 | MSFT | Stock | 27.76 | 27.99 | 27.66 | 27.99 | 57680200.0 |
| 2010-12-16 | NVDA | Stock | 0.3605 | 0.3625 | 0.3562 | 0.3572 | 631872000.0 |
| 2010-12-16 | AMZN | Stock | 8.779 | 8.915 | 8.752 | 8.902 | 82430000.0 |
| 2010-12-16 | TSLA | Stock | 2.0 | 2.0607 | 1.9767 | 2.054 | 11851500.0 |
| 2010-12-16 | TLT | Stock | 91.03 | 91.58 | 90.57 | 91.57 | 17939176.0 |
| 2010-12-16 | ES | Stock | 31.39 | 31.83 | 31.28 | 31.83 | 785500.0 |
| 2010-12-16 | CL | Stock | 40.375 | 40.59 | 40.165 | 40.59 | 6601800.0 |
| 2010-12-16 | A | Stock | 27.618 | 28.4478 | 27.525 | 28.4263 | 6021885.0 |
| 2010-12-16 | AABA-DELISTED | Stock | 16.47 | 16.7 | 16.435 | 16.51 | 12646969.0 |
| 2010-12-16 | AACC-DELISTED | Stock | 5.93 | 6.05 | 5.93 | 6.03 | 37082.0 |
| 2010-12-16 | AACG | Stock | 3.65 | 3.67 | 3.65 | 3.67 | 700.0 |
| 2010-12-16 | AAI-DELISTED | Stock | 7.37 | 7.41 | 7.37 | 7.39 | 1466227.0 |
| 2010-12-16 | AAIC-DELISTED | Stock | 23.92 | 24.05 | 23.76 | 23.78 | 33630.0 |
| 2010-12-16 | AAME | Stock | 1.97 | 1.97 | 1.96 | 1.97 | 1000.0 |
| 2010-12-16 | AAON | Stock | 5.5723 | 5.6968 | 5.5723 | 5.6869 | 152887.0 |
| 2010-12-16 | AAP | Stock | 67.9 | 68.02 | 66.88 | 67.88 | 664100.0 |
| 2010-12-16 | AATI-DELISTED | Stock | 3.94 | 3.96 | 3.92 | 3.96 | 85822.0 |
| 2010-12-16 | AAU-DELISTED | Stock | 4.46 | 4.53 | 4.33 | 4.39 | 490410.0 |
| 2010-12-16 | AAUAF-DELISTED | Stock | 4.46 | 4.53 | 4.33 | 4.38 | 491610.0 |
| 2010-12-16 | AAV-DELISTED | Stock | 6.4 | 6.49 | 6.35 | 6.46 | 264004.0 |
| 2010-12-16 | AAWW-DELISTED | Stock | 56.33 | 57.33 | 56.05 | 56.98 | 162375.0 |
| 2010-12-16 | AAXJ | Stock | 62.32 | 62.66 | 62.1506 | 62.6 | 1611140.0 |
| 2010-12-16 | AAXN-DELISTED | Stock | 4.52 | 4.69 | 4.52 | 4.67 | 345471.0 |
| 2010-12-16 | AB | Stock | 23.05 | 23.24 | 22.76 | 22.89 | 531400.0 |
| 2010-12-16 | ABAC-DELISTED | Stock | 5.33 | 5.33 | 5.05 | 5.21 | 55697.0 |
| 2010-12-16 | ABAX-DELISTED | Stock | 27.38 | 27.63 | 27.03 | 27.14 | 115083.0 |
| 2010-12-16 | ABB-DELISTED | Stock | 21.45 | 21.62 | 21.37 | 21.62 | 1969893.0 |
| 2010-12-16 | ABBC-DELISTED | Stock | 11.85 | 12.0 | 11.84 | 11.99 | 35074.0 |
| 2010-12-16 | ABBNY-DELISTED | Stock | 21.45 | 21.62 | 21.37 | 21.61 | 1971373.0 |
| 2010-12-16 | ABC-DELISTED | Stock | 32.35 | 32.75 | 31.9 | 32.69 | 2979700.0 |
| 2010-12-16 | ABCB | Stock | 10.35 | 10.57 | 10.14 | 10.49 | 61400.0 |
| 2010-12-16 | ABCD-DELISTED | Stock | 3.51 | 3.51 | 3.33 | 3.5 | 27257.0 |
| 2010-12-16 | ABCO-DELISTED | Stock | 24.2 | 24.62 | 24.2 | 24.45 | 92146.0 |
| 2010-12-16 | ABCW-DELISTED | Stock | 1.05 | 1.18 | 1.05 | 1.11 | 108660.0 |
| 2010-12-16 | ABD-DELISTED | Stock | 8.315 | 8.495 | 8.237 | 8.485 | 245410.0 |
| 2010-12-16 | ABE-DELISTED | Stock | 18.7 | 18.75 | 18.59 | 18.74 | 4536.0 |
| 2010-12-16 | ABEO | Stock | 3112.5 | 3187.5 | 3000.0 | 3162.5 | 33.0 |
| 2010-12-16 | ABFS-DELISTED | Stock | 28.1 | 29.08 | 27.25 | 28.09 | 390123.0 |
| 2010-12-16 | ABG | Stock | 16.97 | 17.19 | 16.79 | 17.04 | 179300.0 |
| 2010-12-16 | ABH-DELISTED | Stock | 0.08 | 0.11 | 0.08 | 0.11 | 2500.0 |
| 2010-12-16 | ABM | Stock | 25.81 | 25.81 | 25.0 | 25.62 | 484600.0 |
| 2010-12-16 | ABMD-DELISTED | Stock | 9.19 | 9.28 | 9.12 | 9.22 | 185224.0 |
| 2010-12-16 | ABR | Stock | 5.27 | 5.29 | 5.16 | 5.2 | 28300.0 |
| 2010-12-16 | ABT | Stock | 23.112 | 23.3279 | 22.944 | 23.2991 | 15183618.0 |
| 2010-12-16 | ABTL-DELISTED | Stock | 4.4518 | 4.4518 | 4.1988 | 4.3 | 7136.0 |
| 2010-12-16 | ABUS | Stock | 4.6 | 4.74 | 4.6 | 4.69 | 12800.0 |
| 2010-12-16 | ABV-DELISTED | Stock | 145.4 | 146.43 | 145.16 | 146.12 | 428222.0 |
| 2010-12-16 | ABVT-DELISTED | Stock | 56.0 | 56.81 | 55.82 | 56.63 | 104424.0 |
| 2010-12-16 | ABX-DELISTED | Stock | 52.06 | 52.22 | 50.72 | 51.6 | 10792255.0 |
> showing 50 of 6,066 rows — these rows as CSV