PREVIEW / stock_daily / 2010-11-08
file: by_date/stock_daily/2010/2010-11-08.parquet size: 195 KB rows: 6,036 symbols: 3,541
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-11-08 | AAPL | Stock | 11.3286 | 11.4204 | 11.3129 | 11.3793 | 281758400.0 |
| 2010-11-08 | MSFT | Stock | 26.68 | 28.87 | 26.58 | 26.81 | 71670800.0 |
| 2010-11-08 | NVDA | Stock | 0.315 | 0.3193 | 0.3125 | 0.3165 | 605156000.0 |
| 2010-11-08 | AMZN | Stock | 8.542 | 8.66 | 8.439 | 8.5995 | 114120000.0 |
| 2010-11-08 | TSLA | Stock | 1.6333 | 1.6667 | 1.602 | 1.6653 | 7642500.0 |
| 2010-11-08 | TLT | Stock | 98.59 | 98.92 | 97.8196 | 98.42 | 6795528.0 |
| 2010-11-08 | ES | Stock | 31.63 | 31.7 | 31.32 | 31.51 | 1232500.0 |
| 2010-11-08 | CL | Stock | 38.58 | 38.835 | 38.435 | 38.76 | 4638200.0 |
| 2010-11-08 | A | Stock | 25.8584 | 26.0229 | 25.6366 | 25.8798 | 2605732.0 |
| 2010-11-08 | AABA-DELISTED | Stock | 16.3 | 16.5 | 16.25 | 16.45 | 15099908.0 |
| 2010-11-08 | AACC-DELISTED | Stock | 6.04 | 6.04 | 5.9 | 5.96 | 62316.0 |
| 2010-11-08 | AACG | Stock | 3.44 | 3.5 | 3.35 | 3.44 | 5500.0 |
| 2010-11-08 | AAI-DELISTED | Stock | 7.44 | 7.48 | 7.42 | 7.46 | 3607948.0 |
| 2010-11-08 | AAIC-DELISTED | Stock | 25.94 | 25.95 | 24.99 | 25.48 | 49156.0 |
| 2010-11-08 | AAME | Stock | 1.81 | 1.84 | 1.79 | 1.79 | 1800.0 |
| 2010-11-08 | AAON | Stock | 4.9067 | 4.9304 | 4.8198 | 4.9126 | 84037.0 |
| 2010-11-08 | AAP | Stock | 64.9 | 66.79 | 64.9 | 65.97 | 1313900.0 |
| 2010-11-08 | AATI-DELISTED | Stock | 3.77 | 3.83 | 3.74 | 3.82 | 118332.0 |
| 2010-11-08 | AAU-DELISTED | Stock | 3.14 | 3.1411 | 3.0 | 3.14 | 289750.0 |
| 2010-11-08 | AAUAF-DELISTED | Stock | 3.14 | 3.1411 | 3.0 | 3.14 | 296344.0 |
| 2010-11-08 | AAV-DELISTED | Stock | 6.52 | 6.63 | 6.52 | 6.62 | 374656.0 |
| 2010-11-08 | AAWW-DELISTED | Stock | 61.16 | 61.999 | 60.8 | 61.03 | 243838.0 |
| 2010-11-08 | AAXJ | Stock | 65.48 | 65.5 | 65.254 | 65.5 | 1197945.0 |
| 2010-11-08 | AAXN-DELISTED | Stock | 4.1 | 4.14 | 4.03 | 4.11 | 300575.0 |
| 2010-11-08 | AB | Stock | 25.06 | 25.3 | 24.91 | 25.05 | 440800.0 |
| 2010-11-08 | ABAC-DELISTED | Stock | 7.98 | 8.43 | 7.74 | 7.989 | 247176.0 |
| 2010-11-08 | ABAX-DELISTED | Stock | 25.28 | 25.86 | 25.11 | 25.81 | 70058.0 |
| 2010-11-08 | ABB-DELISTED | Stock | 21.22 | 21.53 | 21.19 | 21.46 | 3293360.0 |
| 2010-11-08 | ABBC-DELISTED | Stock | 11.53 | 11.56 | 11.31 | 11.45 | 22145.0 |
| 2010-11-08 | ABBNY-DELISTED | Stock | 21.22 | 21.53 | 21.19 | 21.44 | 3425620.0 |
| 2010-11-08 | ABC-DELISTED | Stock | 31.51 | 31.69 | 31.33 | 31.42 | 2787915.0 |
| 2010-11-08 | ABCB | Stock | 9.07 | 9.07 | 8.81 | 8.89 | 37900.0 |
| 2010-11-08 | ABCD-DELISTED | Stock | 3.2 | 3.25 | 3.18 | 3.2 | 14764.0 |
| 2010-11-08 | ABCO-DELISTED | Stock | 25.23 | 25.35 | 24.77 | 24.98 | 60262.0 |
| 2010-11-08 | ABCW-DELISTED | Stock | 0.6721 | 0.7597 | 0.5747 | 0.75 | 396480.0 |
| 2010-11-08 | ABD-DELISTED | Stock | 6.52 | 6.61 | 6.3 | 6.38 | 281890.0 |
| 2010-11-08 | ABE-DELISTED | Stock | 19.32 | 19.39 | 19.225 | 19.36 | 12099.0 |
| 2010-11-08 | ABEO | Stock | 3762.5 | 3975.0 | 3762.5 | 3962.5 | 62.0 |
| 2010-11-08 | ABFS-DELISTED | Stock | 25.33 | 25.615 | 24.69 | 25.0 | 259968.0 |
| 2010-11-08 | ABG | Stock | 15.78 | 16.16 | 15.71 | 16.01 | 150500.0 |
| 2010-11-08 | ABK-DELISTED | Stock | 0.51 | 0.55 | 0.4921 | 0.5297 | 30100249.0 |
| 2010-11-08 | ABM | Stock | 23.81 | 24.15 | 23.5 | 23.9 | 150700.0 |
| 2010-11-08 | ABMD-DELISTED | Stock | 11.84 | 12.06 | 11.8 | 12.0 | 106591.0 |
| 2010-11-08 | ABR | Stock | 5.42 | 5.65 | 5.3 | 5.52 | 57500.0 |
| 2010-11-08 | ABT | Stock | 24.4362 | 24.4362 | 24.0956 | 24.2059 | 13792414.0 |
| 2010-11-08 | ABTL-DELISTED | Stock | 4.05 | 4.2 | 3.95 | 4.0 | 7646.0 |
| 2010-11-08 | ABV-DELISTED | Stock | 142.67 | 145.36 | 142.67 | 144.264 | 532871.0 |
| 2010-11-08 | ABVA-DELISTED | Stock | 3.25 | 3.25 | 3.25 | 3.25 | 800.0 |
| 2010-11-08 | ABVT-DELISTED | Stock | 62.63 | 63.145 | 61.914 | 62.5 | 145715.0 |
| 2010-11-08 | ABX-DELISTED | Stock | 48.98 | 51.29 | 48.95 | 51.2 | 12017402.0 |
> showing 50 of 6,036 rows — these rows as CSV