PREVIEW / stock_daily / 2017-03-03
file: by_date/stock_daily/2017/2017-03-03.parquet size: 216 KB rows: 6,460 symbols: 3,048
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-03-03 | AAPL | Stock | 34.695 | 34.9575 | 34.6475 | 34.945 | 84432400.0 |
| 2017-03-03 | MSFT | Stock | 63.99 | 64.28 | 63.62 | 64.25 | 18135900.0 |
| 2017-03-03 | NVDA | Stock | 2.4642 | 2.4692 | 2.4055 | 2.4608 | 864692000.0 |
| 2017-03-03 | AMZN | Stock | 42.36 | 42.5995 | 42.3135 | 42.494 | 38822000.0 |
| 2017-03-03 | GOOGL | Stock | 42.447 | 42.541 | 42.2353 | 42.454 | 20132240.0 |
| 2017-03-03 | META | Stock | 136.63 | 137.33 | 136.08 | 137.17 | 11160600.0 |
| 2017-03-03 | TSLA | Stock | 16.716 | 16.7933 | 16.6 | 16.7713 | 43791000.0 |
| 2017-03-03 | TLT | Stock | 119.23 | 119.35 | 118.5511 | 119.35 | 9515219.0 |
| 2017-03-03 | ES | Stock | 58.48 | 58.6 | 57.9 | 58.28 | 1674100.0 |
| 2017-03-03 | CL | Stock | 73.47 | 73.7 | 72.58 | 73.59 | 3807700.0 |
| 2017-03-03 | A | Stock | 51.38 | 52.04 | 51.15 | 51.98 | 1824400.0 |
| 2017-03-03 | AA | Stock | 36.06 | 36.89 | 35.75 | 36.38 | 3238100.0 |
| 2017-03-03 | AAAP-DELISTED | Stock | 37.64 | 38.655 | 37.4601 | 38.36 | 54363.0 |
| 2017-03-03 | AABA-DELISTED | Stock | 45.88 | 46.0 | 45.6 | 45.91 | 4370954.0 |
| 2017-03-03 | AAC-DELISTED | Stock | 8.87 | 9.06 | 8.82 | 9.0 | 214045.0 |
| 2017-03-03 | AACG | Stock | 3.76 | 3.83 | 3.66 | 3.71 | 39700.0 |
| 2017-03-03 | AAIC-DELISTED | Stock | 14.43 | 14.45 | 13.71 | 14.31 | 1248014.0 |
| 2017-03-03 | AAL | Stock | 45.85 | 47.26 | 45.77 | 46.82 | 7256900.0 |
| 2017-03-03 | AAMC-DELISTED | Stock | 23.25 | 25.2647 | 23.1618 | 25.2647 | 69720.0 |
| 2017-03-03 | AAME | Stock | 3.75 | 3.75 | 3.75 | 3.75 | 1300.0 |
| 2017-03-03 | AAMI | Stock | 15.03 | 15.095 | 14.88 | 15.03 | 201000.0 |
| 2017-03-03 | AAOI | Stock | 50.0 | 53.98 | 49.88 | 53.32 | 2676100.0 |
| 2017-03-03 | AAON | Stock | 23.6667 | 23.9 | 23.3667 | 23.5333 | 321300.0 |
| 2017-03-03 | AAP | Stock | 157.3 | 158.14 | 154.3 | 155.35 | 1252000.0 |
| 2017-03-03 | AAT | Stock | 43.24 | 43.26 | 42.63 | 42.99 | 163000.0 |
| 2017-03-03 | AAU-DELISTED | Stock | 1.07 | 1.12 | 1.05 | 1.1 | 209620.0 |
| 2017-03-03 | AAUAF-DELISTED | Stock | 1.07 | 1.12 | 1.05 | 1.1 | 211957.0 |
| 2017-03-03 | AAV-DELISTED | Stock | 5.95 | 6.0 | 5.7 | 5.8 | 167843.0 |
| 2017-03-03 | AAWW-DELISTED | Stock | 56.85 | 57.509 | 55.0 | 56.8 | 86537.0 |
| 2017-03-03 | AAXJ | Stock | 60.44 | 60.5 | 60.17 | 60.35 | 1587264.0 |
| 2017-03-03 | AAXN-DELISTED | Stock | 23.01 | 23.27 | 22.1 | 22.805 | 1785028.0 |
| 2017-03-03 | AB | Stock | 23.35 | 23.51 | 22.95 | 22.95 | 340400.0 |
| 2017-03-03 | ABAC-DELISTED | Stock | 2.88 | 2.88 | 2.71 | 2.71 | 3010.0 |
| 2017-03-03 | ABAX-DELISTED | Stock | 49.65 | 50.05 | 48.86 | 49.23 | 42696.0 |
| 2017-03-03 | ABB-DELISTED | Stock | 22.73 | 22.8 | 22.6 | 22.78 | 869775.0 |
| 2017-03-03 | ABBNY-DELISTED | Stock | 22.73 | 22.8 | 22.6 | 22.78 | 905961.0 |
| 2017-03-03 | ABBV | Stock | 63.11 | 63.53 | 62.83 | 63.34 | 6125800.0 |
| 2017-03-03 | ABC-DELISTED | Stock | 92.22 | 92.67 | 91.47 | 92.21 | 1214068.0 |
| 2017-03-03 | ABCB | Stock | 46.55 | 47.45 | 46.05 | 46.95 | 285800.0 |
| 2017-03-03 | ABCD-DELISTED | Stock | 4.83 | 4.98 | 4.66 | 4.87 | 52490.0 |
| 2017-03-03 | ABCO-DELISTED | Stock | 45.2 | 46.05 | 44.65 | 45.3 | 572291.0 |
| 2017-03-03 | ABDC-DELISTED | Stock | 12.46 | 12.7488 | 12.46 | 12.51 | 44910.0 |
| 2017-03-03 | ABE-DELISTED | Stock | 12.0701 | 12.1218 | 12.07 | 12.1208 | 11905.0 |
| 2017-03-03 | ABEO | Stock | 126.25 | 132.5 | 121.25 | 125.0 | 11788.0 |
| 2017-03-03 | ABEV | Stock | 5.42 | 5.55 | 5.41 | 5.54 | 17901800.0 |
| 2017-03-03 | ABG | Stock | 66.0 | 66.0 | 64.05 | 65.3 | 142600.0 |
| 2017-03-03 | ABIL-DELISTED | Stock | 2.59 | 2.91 | 2.43 | 2.48 | 48811.0 |
| 2017-03-03 | ABM | Stock | 41.03 | 41.36 | 40.62 | 40.81 | 294400.0 |
| 2017-03-03 | ABMD-DELISTED | Stock | 119.93 | 121.72 | 119.41 | 120.75 | 150255.0 |
| 2017-03-03 | ABR | Stock | 7.46 | 7.65 | 7.46 | 7.64 | 298800.0 |
> showing 50 of 6,460 rows — these rows as CSV