PREVIEW / stock_daily / 2017-05-03
file: by_date/stock_daily/2017/2017-05-03.parquet size: 214 KB rows: 6,424 symbols: 3,016
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-05-03 | AAPL | Stock | 36.3975 | 36.8725 | 36.0675 | 36.765 | 182788000.0 |
| 2017-05-03 | MSFT | Stock | 69.38 | 69.38 | 68.71 | 69.08 | 28928000.0 |
| 2017-05-03 | NVDA | Stock | 2.58 | 2.616 | 2.565 | 2.6062 | 336904000.0 |
| 2017-05-03 | AMZN | Stock | 47.3 | 47.3 | 46.795 | 47.0515 | 71654000.0 |
| 2017-05-03 | GOOGL | Stock | 46.8025 | 47.51 | 46.7605 | 47.4225 | 36495180.0 |
| 2017-05-03 | META | Stock | 153.6 | 153.6 | 151.34 | 151.8 | 29782500.0 |
| 2017-05-03 | TSLA | Stock | 21.178 | 21.4353 | 20.6967 | 20.7347 | 107001000.0 |
| 2017-05-03 | TLT | Stock | 122.22 | 122.39 | 121.55 | 121.78 | 8932912.0 |
| 2017-05-03 | ES | Stock | 59.14 | 59.48 | 59.03 | 59.11 | 952000.0 |
| 2017-05-03 | CL | Stock | 70.9 | 71.18 | 70.66 | 71.08 | 3703900.0 |
| 2017-05-03 | A | Stock | 55.68 | 56.26 | 55.61 | 56.16 | 1702600.0 |
| 2017-05-03 | AA | Stock | 32.9 | 32.9 | 31.51 | 31.69 | 7334500.0 |
| 2017-05-03 | AAAP-DELISTED | Stock | 38.12 | 38.12 | 37.22 | 37.99 | 133923.0 |
| 2017-05-03 | AABA-DELISTED | Stock | 49.19 | 49.19 | 48.17 | 48.54 | 4393731.0 |
| 2017-05-03 | AAC-DELISTED | Stock | 7.84 | 8.09 | 7.365 | 7.37 | 89377.0 |
| 2017-05-03 | AACG | Stock | 3.66 | 3.74 | 3.66 | 3.7 | 7300.0 |
| 2017-05-03 | AAIC-DELISTED | Stock | 14.49 | 14.49 | 14.19 | 14.2 | 332384.0 |
| 2017-05-03 | AAL | Stock | 43.67 | 44.17 | 43.42 | 43.92 | 5144300.0 |
| 2017-05-03 | AAM.A-DELISTED | Stock | 25.41 | 25.57 | 25.36 | 25.56 | 107962.0 |
| 2017-05-03 | AAMC-DELISTED | Stock | 20.8971 | 21.1029 | 19.8971 | 20.75 | 12468.0 |
| 2017-05-03 | AAME | Stock | 3.7 | 3.7 | 3.7 | 3.7 | 200.0 |
| 2017-05-03 | AAMI | Stock | 15.07 | 15.215 | 14.97 | 15.13 | 278500.0 |
| 2017-05-03 | AAOI | Stock | 45.99 | 46.92 | 45.01 | 46.47 | 2121300.0 |
| 2017-05-03 | AAON | Stock | 24.8667 | 24.9333 | 24.6 | 24.8 | 142200.0 |
| 2017-05-03 | AAP | Stock | 142.49 | 143.43 | 141.96 | 142.82 | 545300.0 |
| 2017-05-03 | AAT | Stock | 42.67 | 42.98 | 41.36 | 41.55 | 436500.0 |
| 2017-05-03 | AAU-DELISTED | Stock | 1.43 | 1.48 | 1.39 | 1.45 | 345430.0 |
| 2017-05-03 | AAUAF-DELISTED | Stock | 1.43 | 1.48 | 1.39 | 1.45 | 348996.0 |
| 2017-05-03 | AAV-DELISTED | Stock | 6.1 | 6.1 | 5.95 | 6.05 | 71329.0 |
| 2017-05-03 | AAWW-DELISTED | Stock | 56.35 | 57.0 | 53.35 | 53.35 | 475331.0 |
| 2017-05-03 | AAXJ | Stock | 64.76 | 64.76 | 64.415 | 64.61 | 351729.0 |
| 2017-05-03 | AAXN-DELISTED | Stock | 24.58 | 24.77 | 24.5 | 24.745 | 304724.0 |
| 2017-05-03 | AB | Stock | 21.55 | 21.9 | 21.3 | 21.45 | 822400.0 |
| 2017-05-03 | ABAC-DELISTED | Stock | 1.71 | 1.81 | 1.71 | 1.73 | 19449.0 |
| 2017-05-03 | ABAX-DELISTED | Stock | 46.52 | 47.41 | 46.17 | 47.27 | 133574.0 |
| 2017-05-03 | ABB-DELISTED | Stock | 24.62 | 24.68 | 24.485 | 24.62 | 1442380.0 |
| 2017-05-03 | ABBNY-DELISTED | Stock | 24.62 | 24.68 | 24.485 | 24.61 | 1607481.0 |
| 2017-05-03 | ABBV | Stock | 66.45 | 66.88 | 66.21 | 66.74 | 4993400.0 |
| 2017-05-03 | ABC-DELISTED | Stock | 82.45 | 83.11 | 81.6 | 82.68 | 2645311.0 |
| 2017-05-03 | ABCB | Stock | 46.45 | 47.05 | 45.95 | 46.9 | 171000.0 |
| 2017-05-03 | ABCD-DELISTED | Stock | 4.9 | 5.22 | 4.9 | 5.1401 | 49617.0 |
| 2017-05-03 | ABCO-DELISTED | Stock | 50.325 | 50.85 | 49.95 | 50.75 | 222323.0 |
| 2017-05-03 | ABDC-DELISTED | Stock | 14.12 | 14.1756 | 13.62 | 14.12 | 23988.0 |
| 2017-05-03 | ABE-DELISTED | Stock | 13.83 | 13.83 | 13.73 | 13.77 | 11852.0 |
| 2017-05-03 | ABEO | Stock | 143.75 | 145.0 | 132.5 | 133.75 | 7088.0 |
| 2017-05-03 | ABEV | Stock | 5.83 | 5.88 | 5.78 | 5.84 | 28535000.0 |
| 2017-05-03 | ABG | Stock | 58.05 | 58.4 | 57.45 | 58.35 | 194400.0 |
| 2017-05-03 | ABIL-DELISTED | Stock | 0.79 | 0.82 | 0.79 | 0.81 | 19164.0 |
| 2017-05-03 | ABM | Stock | 43.29 | 43.59 | 43.25 | 43.41 | 156100.0 |
| 2017-05-03 | ABMD-DELISTED | Stock | 134.15 | 134.15 | 129.68 | 129.89 | 460661.0 |
> showing 50 of 6,424 rows — these rows as CSV