PREVIEW / stock_daily / 2013-05-28
file: by_date/stock_daily/2013/2013-05-28.parquet size: 210 KB rows: 6,368 symbols: 3,542
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-28 | AAPL | Stock | 16.0679 | 16.1111 | 15.7446 | 15.7657 | 386145200.0 |
| 2013-05-28 | MSFT | Stock | 34.42 | 35.18 | 34.41 | 35.02 | 48212100.0 |
| 2013-05-28 | NVDA | Stock | 0.3662 | 0.3672 | 0.3598 | 0.3632 | 279300000.0 |
| 2013-05-28 | AMZN | Stock | 13.324 | 13.555 | 13.3 | 13.3645 | 69420000.0 |
| 2013-05-28 | META | Stock | 24.54 | 24.54 | 23.92 | 24.1 | 50079700.0 |
| 2013-05-28 | TSLA | Stock | 6.77 | 7.3833 | 6.6867 | 7.3553 | 295378500.0 |
| 2013-05-28 | TLT | Stock | 116.09 | 116.27 | 113.82 | 113.838 | 13567727.0 |
| 2013-05-28 | ES | Stock | 42.96 | 42.96 | 42.19 | 42.52 | 1459900.0 |
| 2013-05-28 | CL | Stock | 61.86 | 62.25 | 61.39 | 61.63 | 2717100.0 |
| 2013-05-28 | A | Stock | 32.9685 | 33.5765 | 32.9685 | 33.2117 | 6701872.0 |
| 2013-05-28 | AABA-DELISTED | Stock | 26.63 | 26.77 | 25.98 | 26.08 | 18986842.0 |
| 2013-05-28 | AACC-DELISTED | Stock | 6.72 | 6.795 | 6.7 | 6.765 | 333096.0 |
| 2013-05-28 | AACG | Stock | 4.71 | 4.71 | 4.25 | 4.5 | 1400.0 |
| 2013-05-28 | AAIC-DELISTED | Stock | 28.51 | 29.0 | 27.86 | 27.99 | 235007.0 |
| 2013-05-28 | AAMC-DELISTED | Stock | 83.8353 | 84.4118 | 82.9412 | 83.8235 | 5372.0 |
| 2013-05-28 | AAME | Stock | 3.87 | 3.91 | 3.85 | 3.89 | 16700.0 |
| 2013-05-28 | AAMRQ-DELISTED | Stock | 6.01 | 6.15 | 5.76 | 5.8 | 6891040.0 |
| 2013-05-28 | AAON | Stock | 10.1363 | 10.6933 | 10.1185 | 10.2756 | 409050.0 |
| 2013-05-28 | AAP | Stock | 84.0 | 84.53 | 82.87 | 83.63 | 543800.0 |
| 2013-05-28 | AAT | Stock | 35.02 | 35.14 | 33.82 | 34.21 | 116900.0 |
| 2013-05-28 | AAU-DELISTED | Stock | 1.58 | 1.655 | 1.57 | 1.58 | 55137.0 |
| 2013-05-28 | AAUAF-DELISTED | Stock | 1.59 | 1.66 | 1.57 | 1.57 | 66437.0 |
| 2013-05-28 | AAV-DELISTED | Stock | 4.45 | 4.51 | 4.44 | 4.48 | 489156.0 |
| 2013-05-28 | AAWW-DELISTED | Stock | 46.0 | 46.98 | 45.49 | 45.9 | 262534.0 |
| 2013-05-28 | AAXJ | Stock | 60.01 | 60.12 | 59.65 | 59.75 | 341913.0 |
| 2013-05-28 | AAXN-DELISTED | Stock | 9.64 | 9.79 | 9.47 | 9.59 | 718236.0 |
| 2013-05-28 | AB | Stock | 25.41 | 26.17 | 25.37 | 25.73 | 477000.0 |
| 2013-05-28 | ABAC-DELISTED | Stock | 0.64 | 0.6969 | 0.55 | 0.61 | 77709.0 |
| 2013-05-28 | ABAX-DELISTED | Stock | 44.17 | 44.98 | 43.57 | 44.66 | 101675.0 |
| 2013-05-28 | ABB-DELISTED | Stock | 22.38 | 22.42 | 22.04 | 22.07 | 1528487.0 |
| 2013-05-28 | ABBNY-DELISTED | Stock | 22.38 | 22.42 | 22.04 | 22.07 | 1647716.0 |
| 2013-05-28 | ABBV | Stock | 45.89 | 46.04 | 44.7 | 45.39 | 6181800.0 |
| 2013-05-28 | ABC-DELISTED | Stock | 54.8 | 55.2 | 54.045 | 54.39 | 2750144.0 |
| 2013-05-28 | ABCB | Stock | 16.76 | 17.23 | 16.55 | 16.71 | 68800.0 |
| 2013-05-28 | ABCD-DELISTED | Stock | 1.38 | 1.4 | 1.38 | 1.38 | 22423.0 |
| 2013-05-28 | ABCO-DELISTED | Stock | 50.54 | 51.85 | 50.17 | 51.74 | 284585.0 |
| 2013-05-28 | ABCW-DELISTED | Stock | 0.63 | 0.64 | 0.598 | 0.6 | 58732.0 |
| 2013-05-28 | ABE-DELISTED | Stock | 21.56 | 21.64 | 21.55 | 21.6 | 8673.0 |
| 2013-05-28 | ABFS-DELISTED | Stock | 18.0 | 18.86 | 17.75 | 18.8 | 1043195.0 |
| 2013-05-28 | ABG | Stock | 41.55 | 42.86 | 41.49 | 42.21 | 219800.0 |
| 2013-05-28 | ABM | Stock | 23.75 | 24.28 | 23.75 | 24.04 | 248000.0 |
| 2013-05-28 | ABMD-DELISTED | Stock | 21.98 | 22.48 | 21.98 | 22.18 | 350004.0 |
| 2013-05-28 | ABR | Stock | 7.05 | 7.08 | 6.87 | 6.88 | 307200.0 |
| 2013-05-28 | ABR.A-DELISTED | Stock | 25.55 | 25.6 | 25.13 | 25.13 | 15664.0 |
| 2013-05-28 | ABR.B-DELISTED | Stock | 25.2 | 25.2 | 24.87 | 24.87 | 30600.0 |
| 2013-05-28 | ABT | Stock | 37.98 | 38.64 | 37.95 | 38.56 | 8425100.0 |
| 2013-05-28 | ABTL-DELISTED | Stock | 4.65 | 4.9901 | 4.65 | 4.915 | 69054.0 |
| 2013-05-28 | ABUS | Stock | 4.76 | 4.76 | 4.63 | 4.75 | 40900.0 |
| 2013-05-28 | ABV-DELISTED | Stock | 41.55 | 42.19 | 41.49 | 41.84 | 1746266.0 |
| 2013-05-28 | ABX-DELISTED | Stock | 19.26 | 19.63 | 18.89 | 19.13 | 13927794.0 |
> showing 50 of 6,368 rows — these rows as CSV