PREVIEW / stock_daily / 2013-01-08
file: by_date/stock_daily/2013/2013-01-08.parquet size: 201 KB rows: 6,204 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-08 | AAPL | Stock | 18.9004 | 18.9961 | 18.6161 | 18.7611 | 458707200.0 |
| 2013-01-08 | MSFT | Stock | 26.75 | 26.79 | 26.46 | 26.55 | 44703100.0 |
| 2013-01-08 | NVDA | Stock | 0.32 | 0.321 | 0.31 | 0.3123 | 466424000.0 |
| 2013-01-08 | AMZN | Stock | 13.3535 | 13.449 | 13.1785 | 13.319 | 60214000.0 |
| 2013-01-08 | META | Stock | 29.51 | 29.6 | 28.86 | 29.06 | 45871300.0 |
| 2013-01-08 | TSLA | Stock | 2.3 | 2.3 | 2.2073 | 2.2453 | 19260000.0 |
| 2013-01-08 | TLT | Stock | 119.04 | 119.29 | 118.82 | 119.23 | 4380803.0 |
| 2013-01-08 | ES | Stock | 39.08 | 39.2 | 38.96 | 39.0 | 2764800.0 |
| 2013-01-08 | CL | Stock | 52.955 | 53.16 | 52.875 | 53.16 | 1771200.0 |
| 2013-01-08 | A | Stock | 30.3791 | 30.6009 | 30.1144 | 30.1931 | 3896925.0 |
| 2013-01-08 | AABA-DELISTED | Stock | 19.32 | 19.68 | 19.3 | 19.68 | 15622925.0 |
| 2013-01-08 | AACC-DELISTED | Stock | 4.61 | 4.675 | 4.53 | 4.61 | 21004.0 |
| 2013-01-08 | AACG | Stock | 5.98 | 6.03 | 5.98 | 6.03 | 700.0 |
| 2013-01-08 | AAIC-DELISTED | Stock | 21.95 | 22.11 | 21.64 | 22.07 | 105861.0 |
| 2013-01-08 | AAMC-DELISTED | Stock | 23.2353 | 24.7029 | 23.0147 | 23.5294 | 58167.0 |
| 2013-01-08 | AAME | Stock | 3.2 | 3.22 | 3.17 | 3.2 | 3800.0 |
| 2013-01-08 | AAMRQ-DELISTED | Stock | 0.896 | 0.9201 | 0.8622 | 0.903 | 3475571.0 |
| 2013-01-08 | AAON | Stock | 6.3852 | 6.4267 | 6.2815 | 6.3881 | 154913.0 |
| 2013-01-08 | AAP | Stock | 73.17 | 73.66 | 72.14 | 72.17 | 840000.0 |
| 2013-01-08 | AAT | Stock | 28.38 | 28.51 | 28.16 | 28.4 | 130400.0 |
| 2013-01-08 | AAU-DELISTED | Stock | 3.08 | 3.141 | 3.02 | 3.11 | 142045.0 |
| 2013-01-08 | AAUAF-DELISTED | Stock | 2.97 | 3.11 | 2.95 | 3.11 | 150455.0 |
| 2013-01-08 | AAV-DELISTED | Stock | 3.27 | 3.28 | 3.18 | 3.2 | 130288.0 |
| 2013-01-08 | AAWW-DELISTED | Stock | 44.67 | 45.63 | 44.36 | 45.55 | 143873.0 |
| 2013-01-08 | AAXJ | Stock | 60.59 | 60.6 | 60.1197 | 60.3 | 219090.0 |
| 2013-01-08 | AAXN-DELISTED | Stock | 8.98 | 9.22 | 8.98 | 9.14 | 500950.0 |
| 2013-01-08 | AB | Stock | 19.2 | 19.25 | 18.95 | 19.12 | 330700.0 |
| 2013-01-08 | ABAC-DELISTED | Stock | 0.851 | 0.97 | 0.85 | 0.97 | 8400.0 |
| 2013-01-08 | ABAX-DELISTED | Stock | 37.4 | 38.07 | 37.0 | 37.99 | 116140.0 |
| 2013-01-08 | ABB-DELISTED | Stock | 20.9 | 20.95 | 20.792 | 20.88 | 988137.0 |
| 2013-01-08 | ABBNY-DELISTED | Stock | 20.9 | 20.95 | 20.792 | 20.87 | 993739.0 |
| 2013-01-08 | ABBV | Stock | 34.29 | 34.64 | 33.36 | 33.71 | 17863300.0 |
| 2013-01-08 | ABC-DELISTED | Stock | 43.76 | 44.1 | 43.67 | 43.78 | 1529927.0 |
| 2013-01-08 | ABCB | Stock | 12.9 | 12.93 | 12.8 | 12.9 | 17000.0 |
| 2013-01-08 | ABCD-DELISTED | Stock | 1.19 | 1.24 | 1.18 | 1.2 | 50012.0 |
| 2013-01-08 | ABCO-DELISTED | Stock | 50.0 | 50.11 | 49.66 | 49.79 | 211066.0 |
| 2013-01-08 | ABCW-DELISTED | Stock | 0.42 | 0.42 | 0.3401 | 0.41 | 25032.0 |
| 2013-01-08 | ABE-DELISTED | Stock | 21.65 | 21.76 | 21.65 | 21.7448 | 1604.0 |
| 2013-01-08 | ABEO | Stock | 300.0 | 312.5 | 300.0 | 312.5 | 18.0 |
| 2013-01-08 | ABFS-DELISTED | Stock | 9.83 | 10.245 | 9.61 | 10.205 | 367323.0 |
| 2013-01-08 | ABG | Stock | 33.53 | 34.29 | 33.01 | 34.14 | 223500.0 |
| 2013-01-08 | ABM | Stock | 20.51 | 20.53 | 20.34 | 20.51 | 167000.0 |
| 2013-01-08 | ABMD-DELISTED | Stock | 13.28 | 13.5 | 13.16 | 13.19 | 456610.0 |
| 2013-01-08 | ABR | Stock | 6.55 | 6.8 | 6.55 | 6.72 | 171400.0 |
| 2013-01-08 | ABT | Stock | 33.29 | 33.56 | 33.08 | 33.35 | 15042300.0 |
| 2013-01-08 | ABTL-DELISTED | Stock | 4.06 | 4.06 | 3.86 | 3.95 | 52527.0 |
| 2013-01-08 | ABUS | Stock | 4.99 | 5.03 | 4.97 | 5.03 | 26100.0 |
| 2013-01-08 | ABV-DELISTED | Stock | 42.6 | 42.66 | 42.22 | 42.32 | 1672183.0 |
| 2013-01-08 | ABX-DELISTED | Stock | 34.04 | 34.06 | 33.32 | 33.52 | 9405256.0 |
| 2013-01-08 | ACAD | Stock | 4.82 | 4.93 | 4.82 | 4.92 | 707300.0 |
> showing 50 of 6,204 rows — these rows as CSV