PREVIEW / stock_daily / 2019-02-11
file: by_date/stock_daily/2019/2019-02-11.parquet size: 219 KB rows: 6,541 symbols: 2,638
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-11 | AAPL | Stock | 42.7625 | 42.8025 | 42.3125 | 42.3575 | 83973600.0 |
| 2019-02-11 | MSFT | Stock | 106.2 | 106.58 | 104.97 | 105.25 | 18914100.0 |
| 2019-02-11 | NVDA | Stock | 3.6598 | 3.7145 | 3.6125 | 3.6612 | 495180000.0 |
| 2019-02-11 | AMZN | Stock | 80.049 | 80.4645 | 79.3 | 79.55 | 66346000.0 |
| 2019-02-11 | GOOGL | Stock | 55.1875 | 55.6715 | 55.0 | 55.106 | 18497620.0 |
| 2019-02-11 | META | Stock | 167.9 | 168.3 | 165.08 | 165.79 | 12811200.0 |
| 2019-02-11 | TSLA | Stock | 20.7733 | 21.24 | 20.7 | 20.856 | 106945500.0 |
| 2019-02-11 | TLT | Stock | 121.86 | 122.18 | 121.75 | 121.87 | 4353004.0 |
| 2019-02-11 | ES | Stock | 69.71 | 70.49 | 69.69 | 70.15 | 1509100.0 |
| 2019-02-11 | CL | Stock | 65.59 | 65.84 | 65.34 | 65.79 | 4212800.0 |
| 2019-02-11 | A | Stock | 76.0 | 76.39 | 75.75 | 76.08 | 1018000.0 |
| 2019-02-11 | AA | Stock | 27.55 | 28.12 | 27.26 | 27.97 | 3448100.0 |
| 2019-02-11 | AABA-DELISTED | Stock | 68.99 | 69.53 | 68.49 | 68.52 | 2716699.0 |
| 2019-02-11 | AAC-DELISTED | Stock | 2.85 | 2.99 | 2.61 | 2.72 | 357049.0 |
| 2019-02-11 | AACG | Stock | 1.03 | 1.1 | 1.03 | 1.03 | 62200.0 |
| 2019-02-11 | AAIC-DELISTED | Stock | 8.7 | 8.85 | 8.645 | 8.81 | 323682.0 |
| 2019-02-11 | AAL | Stock | 36.08 | 36.72 | 36.08 | 36.59 | 4932600.0 |
| 2019-02-11 | AAM.A-DELISTED | Stock | 24.58 | 24.7 | 24.55 | 24.7 | 33450.0 |
| 2019-02-11 | AAM.B-DELISTED | Stock | 24.3701 | 24.459 | 24.36 | 24.42 | 20290.0 |
| 2019-02-11 | AAME | Stock | 2.7 | 2.7 | 2.58 | 2.58 | 2400.0 |
| 2019-02-11 | AAMI | Stock | 13.44 | 13.59 | 13.34 | 13.57 | 737800.0 |
| 2019-02-11 | AAOI | Stock | 15.96 | 16.0 | 15.34 | 15.77 | 549200.0 |
| 2019-02-11 | AAON | Stock | 25.2067 | 25.3933 | 25.02 | 25.3667 | 121350.0 |
| 2019-02-11 | AAP | Stock | 162.44 | 165.35 | 162.44 | 165.13 | 917500.0 |
| 2019-02-11 | AAT | Stock | 43.9 | 44.25 | 43.57 | 44.22 | 118000.0 |
| 2019-02-11 | AAU-DELISTED | Stock | 0.71 | 0.7269 | 0.702 | 0.72 | 201076.0 |
| 2019-02-11 | AAUAF-DELISTED | Stock | 0.71 | 0.7269 | 0.702 | 0.72 | 214524.0 |
| 2019-02-11 | AAWW-DELISTED | Stock | 51.56 | 53.38 | 50.97 | 53.27 | 168711.0 |
| 2019-02-11 | AAXJ | Stock | 68.49 | 68.5 | 68.17 | 68.19 | 715071.0 |
| 2019-02-11 | AAXN-DELISTED | Stock | 51.52 | 53.24 | 51.52 | 53.13 | 295197.0 |
| 2019-02-11 | AB | Stock | 30.52 | 31.17 | 30.5 | 31.15 | 418700.0 |
| 2019-02-11 | ABB-DELISTED | Stock | 19.09 | 19.19 | 19.02 | 19.08 | 2232871.0 |
| 2019-02-11 | ABBNY-DELISTED | Stock | 19.09 | 19.19 | 19.02 | 19.08 | 2286052.0 |
| 2019-02-11 | ABBV | Stock | 79.89 | 80.18 | 79.17 | 79.77 | 4803500.0 |
| 2019-02-11 | ABC-DELISTED | Stock | 84.25 | 84.35 | 83.29 | 83.64 | 1106032.0 |
| 2019-02-11 | ABCB | Stock | 37.99 | 38.31 | 37.5 | 38.31 | 265400.0 |
| 2019-02-11 | ABDC-DELISTED | Stock | 7.37 | 7.4 | 7.3373 | 7.3873 | 4691.0 |
| 2019-02-11 | ABEO | Stock | 166.75 | 168.75 | 160.0 | 167.5 | 12696.0 |
| 2019-02-11 | ABEV | Stock | 4.83 | 4.96 | 4.8 | 4.93 | 57084100.0 |
| 2019-02-11 | ABG | Stock | 69.03 | 69.58 | 67.91 | 69.02 | 151500.0 |
| 2019-02-11 | ABIL-DELISTED | Stock | 1.85 | 1.85 | 1.76 | 1.82 | 90037.0 |
| 2019-02-11 | ABM | Stock | 34.78 | 35.3 | 34.67 | 35.25 | 310400.0 |
| 2019-02-11 | ABMD-DELISTED | Stock | 343.52 | 356.3 | 342.55 | 355.03 | 356023.0 |
| 2019-02-11 | ABR | Stock | 11.93 | 11.96 | 11.88 | 11.91 | 666500.0 |
| 2019-02-11 | ABR.A-DELISTED | Stock | 25.728 | 25.75 | 25.55 | 25.57 | 7009.0 |
| 2019-02-11 | ABR.B-DELISTED | Stock | 25.59 | 25.78 | 25.5801 | 25.78 | 3400.0 |
| 2019-02-11 | ABR.C-DELISTED | Stock | 25.89 | 25.89 | 25.7 | 25.7173 | 2900.0 |
| 2019-02-11 | ABT | Stock | 73.48 | 73.84 | 73.29 | 73.54 | 4782700.0 |
| 2019-02-11 | ABTC | Stock | 305100.0 | 305100.0 | 304200.0 | 304500.0 | 1.0799999999999998 |
| 2019-02-11 | ABTS | Stock | 41.25 | 42.0 | 41.25 | 42.0 | 348.0 |
> showing 50 of 6,541 rows — these rows as CSV