PREVIEW / stock_daily / 2012-12-04
file: by_date/stock_daily/2012/2012-12-04.parquet size: 201 KB rows: 6,196 symbols: 3,487
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-04 | AAPL | Stock | 20.7786 | 20.7786 | 20.4332 | 20.5661 | 557068400.0 |
| 2012-12-04 | MSFT | Stock | 26.5 | 26.63 | 26.34 | 26.37 | 49777500.0 |
| 2012-12-04 | NVDA | Stock | 0.2942 | 0.303 | 0.2925 | 0.3025 | 528068000.0 |
| 2012-12-04 | AMZN | Stock | 12.497 | 12.65 | 12.433 | 12.6245 | 62294000.0 |
| 2012-12-04 | META | Stock | 27.06 | 27.76 | 26.68 | 27.46 | 72869200.0 |
| 2012-12-04 | TSLA | Stock | 2.272 | 2.32 | 2.2367 | 2.26 | 18949500.0 |
| 2012-12-04 | TLT | Stock | 125.02 | 125.41 | 124.84 | 125.38 | 2586243.0 |
| 2012-12-04 | ES | Stock | 38.68 | 38.81 | 38.44 | 38.46 | 810200.0 |
| 2012-12-04 | CL | Stock | 54.0 | 54.05 | 53.765 | 53.79 | 2070400.0 |
| 2012-12-04 | A | Stock | 27.1459 | 27.3391 | 26.9599 | 27.2747 | 3059383.0 |
| 2012-12-04 | AABA-DELISTED | Stock | 18.64 | 18.96 | 18.6 | 18.925 | 26364825.0 |
| 2012-12-04 | AACC-DELISTED | Stock | 5.34 | 5.43 | 5.2 | 5.28 | 8071.0 |
| 2012-12-04 | AACG | Stock | 4.18 | 4.19 | 3.86 | 3.94 | 14700.0 |
| 2012-12-04 | AAIC-DELISTED | Stock | 21.45 | 21.45 | 21.101 | 21.32 | 95351.0 |
| 2012-12-04 | AAME | Stock | 2.94 | 2.97 | 2.92 | 2.94 | 2800.0 |
| 2012-12-04 | AAMRQ-DELISTED | Stock | 0.502 | 0.505 | 0.4955 | 0.5025 | 881323.0 |
| 2012-12-04 | AAON | Stock | 6.3704 | 6.4356 | 6.1926 | 6.2667 | 725625.0 |
| 2012-12-04 | AAP | Stock | 72.85 | 72.92 | 71.97 | 72.38 | 866100.0 |
| 2012-12-04 | AAT | Stock | 27.0 | 27.25 | 26.71 | 27.09 | 112700.0 |
| 2012-12-04 | AAU-DELISTED | Stock | 2.91 | 2.92 | 2.79 | 2.86 | 224638.0 |
| 2012-12-04 | AAUAF-DELISTED | Stock | 2.91 | 2.92 | 2.79 | 2.86 | 225238.0 |
| 2012-12-04 | AAV-DELISTED | Stock | 3.34 | 3.35 | 3.31 | 3.32 | 107642.0 |
| 2012-12-04 | AAWW-DELISTED | Stock | 42.95 | 43.0 | 42.36 | 42.59 | 243922.0 |
| 2012-12-04 | AAXJ | Stock | 58.12 | 58.29 | 57.99 | 58.02 | 452219.0 |
| 2012-12-04 | AAXN-DELISTED | Stock | 8.1 | 8.33 | 8.0 | 8.31 | 454068.0 |
| 2012-12-04 | AB | Stock | 17.84 | 17.99 | 17.64 | 17.76 | 94100.0 |
| 2012-12-04 | ABAC-DELISTED | Stock | 0.89 | 0.89 | 0.8615 | 0.88 | 3200.0 |
| 2012-12-04 | ABAX-DELISTED | Stock | 37.4 | 37.4 | 36.1 | 36.83 | 117287.0 |
| 2012-12-04 | ABB-DELISTED | Stock | 19.67 | 19.72 | 19.58 | 19.65 | 1689278.0 |
| 2012-12-04 | ABBNY-DELISTED | Stock | 19.67 | 19.72 | 19.58 | 19.66 | 1736930.0 |
| 2012-12-04 | ABC-DELISTED | Stock | 42.39 | 42.85 | 42.33 | 42.75 | 2818851.0 |
| 2012-12-04 | ABCB | Stock | 11.54 | 11.66 | 11.38 | 11.54 | 23600.0 |
| 2012-12-04 | ABCD-DELISTED | Stock | 1.16 | 1.22 | 1.0001 | 1.04 | 26378.0 |
| 2012-12-04 | ABCO-DELISTED | Stock | 45.37 | 45.98 | 44.79 | 45.91 | 197731.0 |
| 2012-12-04 | ABCW-DELISTED | Stock | 0.38 | 0.4099 | 0.38 | 0.3999 | 45736.0 |
| 2012-12-04 | ABE-DELISTED | Stock | 20.37 | 20.56 | 20.37 | 20.47 | 22401.0 |
| 2012-12-04 | ABEO | Stock | 375.0 | 375.0 | 325.0 | 337.5 | 17.0 |
| 2012-12-04 | ABFS-DELISTED | Stock | 8.26 | 8.53 | 8.23 | 8.46 | 260754.0 |
| 2012-12-04 | ABG | Stock | 30.69 | 31.56 | 30.48 | 31.5 | 310800.0 |
| 2012-12-04 | ABM | Stock | 19.25 | 19.43 | 19.11 | 19.28 | 220200.0 |
| 2012-12-04 | ABMD-DELISTED | Stock | 13.04 | 13.27 | 12.82 | 13.07 | 640254.0 |
| 2012-12-04 | ABR | Stock | 5.24 | 5.24 | 5.16 | 5.2 | 25800.0 |
| 2012-12-04 | ABT | Stock | 30.7984 | 31.1726 | 30.736 | 30.8943 | 12975198.0 |
| 2012-12-04 | ABTL-DELISTED | Stock | 3.8001 | 3.85 | 3.8 | 3.85 | 2300.0 |
| 2012-12-04 | ABUS | Stock | 4.74 | 4.87 | 4.74 | 4.84 | 19600.0 |
| 2012-12-04 | ABV-DELISTED | Stock | 42.24 | 42.24 | 41.11 | 41.17 | 2016866.0 |
| 2012-12-04 | ABVA-DELISTED | Stock | 4.61 | 4.7 | 4.61 | 4.6868 | 7307.0 |
| 2012-12-04 | ABX-DELISTED | Stock | 33.34 | 34.47 | 33.25 | 34.17 | 8254680.0 |
| 2012-12-04 | ACAD | Stock | 5.11 | 5.17 | 4.95 | 5.0 | 2979900.0 |
| 2012-12-04 | ACAS-DELISTED | Stock | 11.87 | 11.99 | 11.8 | 11.86 | 1836944.0 |
> showing 50 of 6,196 rows — these rows as CSV