PREVIEW / stock_daily / 2015-11-18
file: by_date/stock_daily/2015/2015-11-18.parquet size: 222 KB rows: 6,658 symbols: 3,427
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-18 | AAPL | Stock | 28.94 | 29.3725 | 28.875 | 29.3225 | 186698800.0 |
| 2015-11-18 | MSFT | Stock | 53.0 | 53.98 | 52.98 | 53.85 | 29710000.0 |
| 2015-11-18 | NVDA | Stock | 0.7603 | 0.7768 | 0.752 | 0.7758 | 350216000.0 |
| 2015-11-18 | AMZN | Stock | 32.3255 | 33.244 | 32.3185 | 33.177 | 89396000.0 |
| 2015-11-18 | GOOGL | Stock | 37.4785 | 38.055 | 37.3695 | 38.0005 | 36266720.0 |
| 2015-11-18 | META | Stock | 105.8 | 107.88 | 105.39 | 107.77 | 23836500.0 |
| 2015-11-18 | TSLA | Stock | 14.3 | 14.7587 | 14.168 | 14.738 | 42178500.0 |
| 2015-11-18 | TLT | Stock | 119.58 | 120.189 | 119.36 | 120.02 | 5233883.0 |
| 2015-11-18 | ES | Stock | 49.79 | 50.68 | 49.4 | 50.6 | 1603900.0 |
| 2015-11-18 | CL | Stock | 65.32 | 66.14 | 65.12 | 66.06 | 2921400.0 |
| 2015-11-18 | A | Stock | 38.43 | 39.36 | 38.36 | 39.34 | 6589600.0 |
| 2015-11-18 | AA.B-DELISTED | Stock | 29.96 | 30.31 | 29.6558 | 30.31 | 30642.0 |
| 2015-11-18 | AAAP-DELISTED | Stock | 24.62 | 26.31 | 24.06 | 25.0 | 104546.0 |
| 2015-11-18 | AABA-DELISTED | Stock | 32.89 | 33.02 | 32.32 | 32.97 | 10309151.0 |
| 2015-11-18 | AAC-DELISTED | Stock | 22.5 | 23.75 | 22.43 | 22.54 | 234629.0 |
| 2015-11-18 | AACG | Stock | 4.67 | 4.9 | 4.52 | 4.89 | 28600.0 |
| 2015-11-18 | AAIC-DELISTED | Stock | 13.32 | 13.53 | 13.27 | 13.52 | 105028.0 |
| 2015-11-18 | AAL | Stock | 42.32 | 42.32 | 41.01 | 41.75 | 11071100.0 |
| 2015-11-18 | AAMC-DELISTED | Stock | 3.6941 | 4.3794 | 3.601 | 3.8853 | 131804.0 |
| 2015-11-18 | AAME | Stock | 4.99 | 5.0 | 4.83 | 4.87 | 10400.0 |
| 2015-11-18 | AAMI | Stock | 16.2 | 16.25 | 15.94 | 16.16 | 112800.0 |
| 2015-11-18 | AAOI | Stock | 16.7 | 16.7 | 16.12 | 16.64 | 389800.0 |
| 2015-11-18 | AAON | Stock | 15.8467 | 16.1333 | 15.7467 | 16.0733 | 282600.0 |
| 2015-11-18 | AAP | Stock | 164.37 | 164.67 | 162.6 | 164.44 | 784800.0 |
| 2015-11-18 | AAT | Stock | 39.36 | 40.01 | 39.11 | 40.0 | 131500.0 |
| 2015-11-18 | AAU-DELISTED | Stock | 0.54 | 0.54 | 0.5227 | 0.5227 | 368625.0 |
| 2015-11-18 | AAUAF-DELISTED | Stock | 0.54 | 0.54 | 0.5227 | 0.5227 | 385628.0 |
| 2015-11-18 | AAV-DELISTED | Stock | 5.63 | 5.68 | 5.49 | 5.56 | 61909.0 |
| 2015-11-18 | AAVL-DELISTED | Stock | 7.75 | 8.48 | 7.75 | 8.42 | 550095.0 |
| 2015-11-18 | AAWW-DELISTED | Stock | 40.56 | 40.85 | 39.805 | 40.62 | 107312.0 |
| 2015-11-18 | AAXJ | Stock | 54.83 | 55.54 | 54.83 | 55.48 | 1032404.0 |
| 2015-11-18 | AAXN-DELISTED | Stock | 18.12 | 19.1 | 18.0 | 18.31 | 4499915.0 |
| 2015-11-18 | AB | Stock | 24.41 | 24.72 | 24.08 | 24.67 | 265500.0 |
| 2015-11-18 | ABAC-DELISTED | Stock | 0.6365 | 0.6365 | 0.619 | 0.619 | 1000.0 |
| 2015-11-18 | ABAX-DELISTED | Stock | 52.52 | 52.52 | 51.66 | 52.12 | 157251.0 |
| 2015-11-18 | ABB-DELISTED | Stock | 18.67 | 18.77 | 18.59 | 18.75 | 1573941.0 |
| 2015-11-18 | ABBNY-DELISTED | Stock | 18.67 | 18.77 | 18.59 | 18.75 | 1619858.0 |
| 2015-11-18 | ABBV | Stock | 60.26 | 61.06 | 59.85 | 60.99 | 5470200.0 |
| 2015-11-18 | ABC-DELISTED | Stock | 99.07 | 100.44 | 98.87 | 100.3 | 1722296.0 |
| 2015-11-18 | ABCB | Stock | 32.96 | 33.1 | 32.47 | 33.08 | 158700.0 |
| 2015-11-18 | ABCD-DELISTED | Stock | 5.26 | 5.26 | 5.01 | 5.21 | 26775.0 |
| 2015-11-18 | ABCO-DELISTED | Stock | 52.24 | 53.25 | 51.79 | 52.265 | 132973.0 |
| 2015-11-18 | ABCW-DELISTED | Stock | 41.54 | 41.54 | 40.77 | 40.98 | 7050.0 |
| 2015-11-18 | ABDC-DELISTED | Stock | 11.94 | 11.99 | 11.62 | 11.69 | 32826.0 |
| 2015-11-18 | ABE-DELISTED | Stock | 11.1727 | 11.24 | 11.15 | 11.15 | 2223.0 |
| 2015-11-18 | ABEO | Stock | 100.0 | 101.75 | 98.75 | 100.0 | 2688.0 |
| 2015-11-18 | ABEV | Stock | 5.01 | 5.13 | 5.01 | 5.13 | 20550400.0 |
| 2015-11-18 | ABG | Stock | 70.67 | 71.31 | 70.13 | 70.71 | 621800.0 |
| 2015-11-18 | ABGB-DELISTED | Stock | 5.1 | 5.1 | 4.97 | 4.98 | 7082.0 |
| 2015-11-18 | ABIL-DELISTED | Stock | 10.1 | 10.1 | 10.06 | 10.09 | 53684.0 |
> showing 50 of 6,658 rows — these rows as CSV