PREVIEW / stock_daily / 2017-11-02
file: by_date/stock_daily/2017/2017-11-02.parquet size: 216 KB rows: 6,458 symbols: 2,908
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-02 | AAPL | Stock | 41.65 | 42.125 | 41.32 | 42.0275 | 165573600.0 |
| 2017-11-02 | MSFT | Stock | 83.35 | 84.46 | 83.12 | 84.05 | 23992900.0 |
| 2017-11-02 | NVDA | Stock | 5.15 | 5.1953 | 5.0913 | 5.1485 | 342308000.0 |
| 2017-11-02 | AMZN | Stock | 54.8905 | 55.097 | 54.3435 | 54.711 | 73698000.0 |
| 2017-11-02 | GOOGL | Stock | 51.9995 | 52.276 | 51.433 | 52.1485 | 26693940.0 |
| 2017-11-02 | META | Stock | 180.63 | 181.94 | 177.34 | 178.92 | 35529900.0 |
| 2017-11-02 | TSLA | Stock | 20.0087 | 20.5793 | 19.5087 | 19.9507 | 296871000.0 |
| 2017-11-02 | TLT | Stock | 125.0 | 125.52 | 124.92 | 125.3 | 7222693.0 |
| 2017-11-02 | ES | Stock | 63.13 | 63.27 | 62.25 | 63.23 | 1998000.0 |
| 2017-11-02 | CL | Stock | 70.63 | 71.11 | 70.02 | 70.94 | 4638200.0 |
| 2017-11-02 | A | Stock | 68.08 | 68.38 | 67.81 | 68.13 | 1856900.0 |
| 2017-11-02 | AA | Stock | 47.68 | 47.767 | 47.07 | 47.46 | 2059000.0 |
| 2017-11-02 | AAAP-DELISTED | Stock | 80.85 | 81.15 | 80.85 | 80.99 | 816591.0 |
| 2017-11-02 | AABA-DELISTED | Stock | 72.06 | 72.47 | 69.84 | 70.5 | 9256857.0 |
| 2017-11-02 | AAC-DELISTED | Stock | 8.9 | 10.97 | 8.575 | 10.02 | 535703.0 |
| 2017-11-02 | AACG | Stock | 4.6 | 4.6 | 4.2 | 4.36 | 6000.0 |
| 2017-11-02 | AAIC-DELISTED | Stock | 11.35 | 11.36 | 11.11 | 11.18 | 595083.0 |
| 2017-11-02 | AAL | Stock | 47.79 | 47.93 | 47.09 | 47.36 | 2410700.0 |
| 2017-11-02 | AAM.A-DELISTED | Stock | 26.3 | 26.3119 | 26.16 | 26.16 | 16945.0 |
| 2017-11-02 | AAMC-DELISTED | Stock | 25.1471 | 25.9559 | 25.1471 | 25.8824 | 4848.0 |
| 2017-11-02 | AAME | Stock | 3.65 | 3.65 | 3.08 | 3.65 | 4300.0 |
| 2017-11-02 | AAMI | Stock | 15.38 | 15.88 | 15.24 | 15.74 | 445100.0 |
| 2017-11-02 | AAOI | Stock | 39.08 | 42.5 | 39.01 | 39.28 | 2239400.0 |
| 2017-11-02 | AAON | Stock | 22.8667 | 23.1733 | 22.7667 | 22.9 | 208650.0 |
| 2017-11-02 | AAP | Stock | 81.02 | 82.91 | 80.21 | 81.69 | 1669100.0 |
| 2017-11-02 | AAT | Stock | 37.81 | 39.2 | 37.26 | 38.99 | 517300.0 |
| 2017-11-02 | AAU-DELISTED | Stock | 1.0 | 1.021 | 0.8821 | 0.9099 | 742755.0 |
| 2017-11-02 | AAUAF-DELISTED | Stock | 1.0 | 1.021 | 0.8821 | 0.9099 | 751635.0 |
| 2017-11-02 | AAV-DELISTED | Stock | 5.55 | 5.7254 | 5.55 | 5.7 | 174023.0 |
| 2017-11-02 | AAWW-DELISTED | Stock | 61.6 | 61.85 | 60.8 | 61.2 | 295591.0 |
| 2017-11-02 | AAXJ | Stock | 75.99 | 76.16 | 75.75 | 76.14 | 1289310.0 |
| 2017-11-02 | AAXN-DELISTED | Stock | 23.0 | 23.5 | 22.9 | 23.48 | 408801.0 |
| 2017-11-02 | AB | Stock | 25.95 | 26.3 | 25.95 | 26.05 | 235100.0 |
| 2017-11-02 | ABAC-DELISTED | Stock | 3.2864 | 3.49 | 3.2864 | 3.4 | 5768.0 |
| 2017-11-02 | ABAX-DELISTED | Stock | 47.69 | 48.01 | 47.05 | 47.46 | 88985.0 |
| 2017-11-02 | ABB-DELISTED | Stock | 25.99 | 26.11 | 25.97 | 26.095 | 1776202.0 |
| 2017-11-02 | ABBNY-DELISTED | Stock | 25.99 | 26.11 | 25.97 | 26.09 | 1820021.0 |
| 2017-11-02 | ABBV | Stock | 92.08 | 92.34 | 90.19 | 91.02 | 4981900.0 |
| 2017-11-02 | ABC-DELISTED | Stock | 77.02 | 78.93 | 71.9 | 73.24 | 3460651.0 |
| 2017-11-02 | ABCB | Stock | 47.55 | 48.55 | 47.15 | 48.45 | 115800.0 |
| 2017-11-02 | ABCD-DELISTED | Stock | 6.08 | 6.48 | 6.0575 | 6.29 | 60049.0 |
| 2017-11-02 | ABCO-DELISTED | Stock | 53.8 | 53.825 | 53.65 | 53.75 | 331291.0 |
| 2017-11-02 | ABDC-DELISTED | Stock | 8.7 | 8.99 | 8.6 | 8.76 | 115875.0 |
| 2017-11-02 | ABE-DELISTED | Stock | 14.42 | 14.44 | 14.42 | 14.4356 | 1700.0 |
| 2017-11-02 | ABEO | Stock | 407.5 | 424.5 | 403.75 | 418.75 | 16416.0 |
| 2017-11-02 | ABEOW-DELISTED | Stock | 11.4408 | 11.9 | 11.4 | 11.63 | 8000.0 |
| 2017-11-02 | ABEV | Stock | 6.31 | 6.32 | 6.21 | 6.28 | 20815400.0 |
| 2017-11-02 | ABG | Stock | 62.6 | 63.65 | 61.8 | 62.6 | 576300.0 |
| 2017-11-02 | ABIL-DELISTED | Stock | 0.64 | 0.6424 | 0.6253 | 0.6253 | 21127.0 |
| 2017-11-02 | ABLX-DELISTED | Stock | 20.76 | 21.17 | 20.5257 | 20.67 | 293209.0 |
> showing 50 of 6,458 rows — these rows as CSV