PREVIEW / stock_daily / 2013-10-08
file: by_date/stock_daily/2013/2013-10-08.parquet size: 214 KB rows: 6,399 symbols: 3,523
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-10-08 | AAPL | Stock | 17.4979 | 17.5229 | 17.1621 | 17.1764 | 290917200.0 |
| 2013-10-08 | MSFT | Stock | 33.31 | 33.33 | 32.8 | 33.01 | 41017600.0 |
| 2013-10-08 | NVDA | Stock | 0.3888 | 0.3942 | 0.3835 | 0.3865 | 290712000.0 |
| 2013-10-08 | AMZN | Stock | 15.575 | 15.5775 | 15.0135 | 15.1615 | 63324000.0 |
| 2013-10-08 | META | Stock | 50.6 | 50.6 | 47.08 | 47.14 | 136081000.0 |
| 2013-10-08 | TSLA | Stock | 12.2933 | 12.3953 | 11.5473 | 11.6487 | 206358000.0 |
| 2013-10-08 | TLT | Stock | 105.9799 | 106.5099 | 105.828 | 106.17 | 5904709.0 |
| 2013-10-08 | ES | Stock | 40.68 | 41.35 | 40.6 | 41.02 | 1657000.0 |
| 2013-10-08 | CL | Stock | 59.3 | 59.6 | 58.94 | 58.96 | 3958200.0 |
| 2013-10-08 | A | Stock | 36.6094 | 36.7167 | 35.6867 | 35.8584 | 3367223.0 |
| 2013-10-08 | AABA-DELISTED | Stock | 34.46 | 34.5 | 32.1 | 32.92 | 40949725.0 |
| 2013-10-08 | AACG | Stock | 4.93 | 4.93 | 4.93 | 4.93 | 900.0 |
| 2013-10-08 | AAIC-DELISTED | Stock | 23.17 | 23.255 | 22.79 | 22.82 | 172434.0 |
| 2013-10-08 | AAMC-DELISTED | Stock | 207.05 | 210.2941 | 177.9412 | 178.0147 | 28652.0 |
| 2013-10-08 | AAME | Stock | 3.98 | 4.07 | 3.91 | 4.07 | 12700.0 |
| 2013-10-08 | AAMRQ-DELISTED | Stock | 5.285 | 5.44 | 4.8 | 5.05 | 13796792.0 |
| 2013-10-08 | AAOI | Stock | 10.2 | 10.2 | 10.1 | 10.12 | 13900.0 |
| 2013-10-08 | AAON | Stock | 11.4311 | 11.5289 | 11.0267 | 11.0533 | 229050.0 |
| 2013-10-08 | AAP | Stock | 81.84 | 82.5 | 81.04 | 81.25 | 493600.0 |
| 2013-10-08 | AAT | Stock | 31.16 | 31.31 | 30.59 | 30.75 | 562400.0 |
| 2013-10-08 | AAU-DELISTED | Stock | 1.39 | 1.41 | 1.33 | 1.33 | 63974.0 |
| 2013-10-08 | AAUAF-DELISTED | Stock | 1.39 | 1.41 | 1.33 | 1.33 | 65074.0 |
| 2013-10-08 | AAV-DELISTED | Stock | 3.86 | 3.88 | 3.77 | 3.78 | 79698.0 |
| 2013-10-08 | AAWW-DELISTED | Stock | 43.48 | 43.83 | 43.14 | 43.25 | 188957.0 |
| 2013-10-08 | AAXJ | Stock | 59.89 | 59.91 | 59.14 | 59.17 | 333483.0 |
| 2013-10-08 | AAXN-DELISTED | Stock | 14.87 | 15.82 | 14.63 | 14.74 | 3470099.0 |
| 2013-10-08 | AB | Stock | 20.07 | 20.17 | 19.5 | 19.5 | 271300.0 |
| 2013-10-08 | ABAC-DELISTED | Stock | 1.25 | 1.4 | 1.25 | 1.26 | 292545.0 |
| 2013-10-08 | ABAX-DELISTED | Stock | 38.68 | 39.49 | 38.66 | 39.05 | 151096.0 |
| 2013-10-08 | ABB-DELISTED | Stock | 23.37 | 23.399 | 23.0 | 23.01 | 2348285.0 |
| 2013-10-08 | ABBNY-DELISTED | Stock | 23.37 | 23.399 | 23.0 | 23.0 | 2446124.0 |
| 2013-10-08 | ABBV | Stock | 46.29 | 46.32 | 44.39 | 44.52 | 7091500.0 |
| 2013-10-08 | ABC-DELISTED | Stock | 61.98 | 62.445 | 61.07 | 61.18 | 1761578.0 |
| 2013-10-08 | ABCB | Stock | 17.95 | 17.97 | 17.56 | 17.76 | 25300.0 |
| 2013-10-08 | ABCD-DELISTED | Stock | 1.4 | 1.45 | 1.35 | 1.44 | 38980.0 |
| 2013-10-08 | ABCO-DELISTED | Stock | 60.79 | 61.22 | 60.06 | 60.31 | 148804.0 |
| 2013-10-08 | ABE-DELISTED | Stock | 19.85 | 19.9386 | 19.7824 | 19.85 | 2955.0 |
| 2013-10-08 | ABEO | Stock | 475.0 | 500.0 | 437.5 | 487.5 | 3.0 |
| 2013-10-08 | ABFS-DELISTED | Stock | 23.74 | 23.99 | 21.88 | 22.02 | 812125.0 |
| 2013-10-08 | ABG | Stock | 54.2 | 54.2 | 51.52 | 51.55 | 457100.0 |
| 2013-10-08 | ABM | Stock | 25.9 | 26.07 | 25.71 | 25.9 | 164100.0 |
| 2013-10-08 | ABMD-DELISTED | Stock | 20.52 | 20.89 | 19.69 | 19.77 | 652648.0 |
| 2013-10-08 | ABR | Stock | 6.74 | 6.8 | 6.68 | 6.7 | 189600.0 |
| 2013-10-08 | ABR.A-DELISTED | Stock | 24.89 | 24.89 | 24.87 | 24.87 | 500.0 |
| 2013-10-08 | ABR.B-DELISTED | Stock | 23.0421 | 23.49 | 23.04 | 23.0601 | 2376.0 |
| 2013-10-08 | ABT | Stock | 33.55 | 33.59 | 32.99 | 33.01 | 8158500.0 |
| 2013-10-08 | ABTL-DELISTED | Stock | 7.44 | 7.53 | 7.12 | 7.37 | 81255.0 |
| 2013-10-08 | ABUS | Stock | 11.42 | 11.42 | 9.5 | 10.08 | 1066400.0 |
| 2013-10-08 | ABV-DELISTED | Stock | 38.4 | 38.48 | 37.51 | 37.68 | 2180486.0 |
| 2013-10-08 | ABX-DELISTED | Stock | 18.26 | 18.28 | 17.55 | 17.65 | 10667681.0 |
> showing 50 of 6,399 rows — these rows as CSV