PREVIEW / stock_daily / 2015-05-21
file: by_date/stock_daily/2015/2015-05-21.parquet size: 224 KB rows: 6,672 symbols: 3,517
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-05-21 | AAPL | Stock | 32.5175 | 32.9075 | 32.4575 | 32.8475 | 158921600.0 |
| 2015-05-21 | MSFT | Stock | 47.28 | 47.6 | 47.01 | 47.42 | 22410700.0 |
| 2015-05-21 | NVDA | Stock | 0.5262 | 0.5285 | 0.5218 | 0.5222 | 239692000.0 |
| 2015-05-21 | AMZN | Stock | 21.4 | 21.845 | 21.4 | 21.5815 | 82428000.0 |
| 2015-05-21 | GOOGL | Stock | 27.51 | 27.8805 | 27.4651 | 27.8405 | 34170240.0 |
| 2015-05-21 | META | Stock | 80.19 | 80.92 | 80.08 | 80.48 | 13402700.0 |
| 2015-05-21 | TSLA | Stock | 16.202 | 16.4413 | 16.1573 | 16.3747 | 29559000.0 |
| 2015-05-21 | TLT | Stock | 119.58 | 120.61 | 119.45 | 120.35 | 11760652.0 |
| 2015-05-21 | ES | Stock | 49.4 | 49.6 | 49.1 | 49.43 | 977000.0 |
| 2015-05-21 | CL | Stock | 68.81 | 68.86 | 68.47 | 68.82 | 1808800.0 |
| 2015-05-21 | A | Stock | 42.57 | 42.73 | 42.2 | 42.32 | 2126300.0 |
| 2015-05-21 | AA.B-DELISTED | Stock | 45.45 | 45.45 | 44.8925 | 44.9 | 28951.0 |
| 2015-05-21 | AABA-DELISTED | Stock | 43.05 | 43.865 | 43.05 | 43.68 | 27294614.0 |
| 2015-05-21 | AAC-DELISTED | Stock | 35.85 | 38.15 | 35.6 | 37.95 | 536370.0 |
| 2015-05-21 | AACG | Stock | 4.55 | 4.78 | 4.5 | 4.75 | 43100.0 |
| 2015-05-21 | AAIC-DELISTED | Stock | 21.4 | 21.43 | 21.2 | 21.21 | 142991.0 |
| 2015-05-21 | AAL | Stock | 43.19 | 43.39 | 42.4 | 42.47 | 23895800.0 |
| 2015-05-21 | AAMC-DELISTED | Stock | 52.9044 | 55.3676 | 52.0 | 54.4118 | 19999.0 |
| 2015-05-21 | AAME | Stock | 3.48 | 3.48 | 3.3 | 3.4 | 6300.0 |
| 2015-05-21 | AAMI | Stock | 19.49 | 19.7 | 19.27 | 19.66 | 53300.0 |
| 2015-05-21 | AAOI | Stock | 15.11 | 15.64 | 15.11 | 15.62 | 295100.0 |
| 2015-05-21 | AAON | Stock | 16.1933 | 16.2333 | 15.86 | 16.12 | 364500.0 |
| 2015-05-21 | AAP | Stock | 144.19 | 160.9 | 143.0 | 157.5 | 4243700.0 |
| 2015-05-21 | AAT | Stock | 40.76 | 40.8 | 40.22 | 40.56 | 248800.0 |
| 2015-05-21 | AAU-DELISTED | Stock | 0.9 | 0.9313 | 0.8904 | 0.9 | 94576.0 |
| 2015-05-21 | AAUAF-DELISTED | Stock | 0.9 | 0.9114 | 0.8714 | 0.9 | 96865.0 |
| 2015-05-21 | AAV-DELISTED | Stock | 6.19 | 6.4 | 6.19 | 6.3 | 99756.0 |
| 2015-05-21 | AAVL-DELISTED | Stock | 39.3 | 39.53 | 38.48 | 38.81 | 495287.0 |
| 2015-05-21 | AAWW-DELISTED | Stock | 58.16 | 58.52 | 57.6 | 57.62 | 480645.0 |
| 2015-05-21 | AAXJ | Stock | 67.48 | 67.74 | 67.34 | 67.68 | 1586314.0 |
| 2015-05-21 | AAXN-DELISTED | Stock | 31.9 | 32.9 | 31.9 | 32.26 | 1282113.0 |
| 2015-05-21 | AB | Stock | 31.72 | 31.84 | 31.44 | 31.74 | 180200.0 |
| 2015-05-21 | ABAC-DELISTED | Stock | 1.596 | 1.75 | 1.5801 | 1.7 | 6200.0 |
| 2015-05-21 | ABAX-DELISTED | Stock | 52.64 | 53.49 | 52.58 | 53.08 | 78887.0 |
| 2015-05-21 | ABB-DELISTED | Stock | 21.89 | 21.99 | 21.86 | 21.93 | 931904.0 |
| 2015-05-21 | ABBNY-DELISTED | Stock | 21.89 | 21.99 | 21.86 | 21.93 | 970132.0 |
| 2015-05-21 | ABBV | Stock | 65.45 | 65.81 | 64.87 | 65.65 | 10553400.0 |
| 2015-05-21 | ABC-DELISTED | Stock | 114.5 | 114.81 | 113.87 | 113.94 | 2104662.0 |
| 2015-05-21 | ABCB | Stock | 26.04 | 26.04 | 25.63 | 25.87 | 91000.0 |
| 2015-05-21 | ABCD-DELISTED | Stock | 3.81 | 3.86 | 3.75 | 3.79 | 19705.0 |
| 2015-05-21 | ABCO-DELISTED | Stock | 47.8 | 48.12 | 46.9 | 46.99 | 259079.0 |
| 2015-05-21 | ABCW-DELISTED | Stock | 37.03 | 37.24 | 36.9697 | 37.22 | 3827.0 |
| 2015-05-21 | ABDC-DELISTED | Stock | 14.02 | 14.02 | 13.8 | 13.8 | 36680.0 |
| 2015-05-21 | ABE-DELISTED | Stock | 13.34 | 13.42 | 12.02 | 13.36 | 9695.0 |
| 2015-05-21 | ABEO | Stock | 230.75 | 238.5 | 217.0 | 221.25 | 73032.0 |
| 2015-05-21 | ABEOW-DELISTED | Stock | 4.4 | 4.55 | 3.7205 | 3.952 | 48479.0 |
| 2015-05-21 | ABEV | Stock | 6.2 | 6.22 | 6.15 | 6.16 | 38887600.0 |
| 2015-05-21 | ABG | Stock | 86.48 | 87.17 | 86.35 | 86.39 | 158300.0 |
| 2015-05-21 | ABGB-DELISTED | Stock | 16.61 | 16.73 | 16.53 | 16.56 | 11870.0 |
| 2015-05-21 | ABM | Stock | 33.0 | 33.08 | 32.58 | 32.64 | 320500.0 |
> showing 50 of 6,672 rows — these rows as CSV