PREVIEW / stock_daily / 2013-06-17
file: by_date/stock_daily/2013/2013-06-17.parquet size: 210 KB rows: 6,370 symbols: 3,539
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-06-17 | AAPL | Stock | 15.4086 | 15.5607 | 15.37 | 15.4286 | 259414400.0 |
| 2013-06-17 | MSFT | Stock | 34.69 | 35.16 | 34.63 | 35.0 | 49670100.0 |
| 2013-06-17 | NVDA | Stock | 0.3615 | 0.3655 | 0.3595 | 0.3622 | 255336000.0 |
| 2013-06-17 | AMZN | Stock | 13.8175 | 14.01 | 13.7825 | 13.903 | 57680000.0 |
| 2013-06-17 | META | Stock | 23.91 | 24.25 | 23.75 | 24.02 | 33664500.0 |
| 2013-06-17 | TSLA | Stock | 6.9067 | 6.9833 | 6.7467 | 6.8133 | 105993000.0 |
| 2013-06-17 | TLT | Stock | 114.02 | 114.08 | 113.0 | 113.22 | 5982073.0 |
| 2013-06-17 | ES | Stock | 42.43 | 42.6 | 41.95 | 42.14 | 1617800.0 |
| 2013-06-17 | CL | Stock | 59.1 | 59.92 | 59.03 | 59.64 | 3724200.0 |
| 2013-06-17 | A | Stock | 31.7454 | 32.0959 | 31.6094 | 31.7454 | 2796280.0 |
| 2013-06-17 | AABA-DELISTED | Stock | 26.29 | 26.85 | 26.235 | 26.545 | 10135607.0 |
| 2013-06-17 | AACG | Stock | 4.39 | 4.45 | 4.08 | 4.15 | 151800.0 |
| 2013-06-17 | AAIC-DELISTED | Stock | 28.29 | 28.83 | 28.16 | 28.31 | 159795.0 |
| 2013-06-17 | AAMC-DELISTED | Stock | 73.5294 | 79.1176 | 73.5294 | 79.1176 | 22661.0 |
| 2013-06-17 | AAME | Stock | 3.91 | 3.96 | 3.9 | 3.96 | 16800.0 |
| 2013-06-17 | AAMRQ-DELISTED | Stock | 4.65 | 4.69 | 4.53 | 4.58 | 2015106.0 |
| 2013-06-17 | AAON | Stock | 9.6474 | 9.757 | 9.5052 | 9.5496 | 125550.0 |
| 2013-06-17 | AAP | Stock | 82.58 | 83.45 | 82.11 | 82.48 | 521000.0 |
| 2013-06-17 | AAT | Stock | 31.81 | 31.86 | 31.45 | 31.58 | 144700.0 |
| 2013-06-17 | AAU-DELISTED | Stock | 1.68 | 1.69 | 1.57 | 1.59 | 108213.0 |
| 2013-06-17 | AAUAF-DELISTED | Stock | 1.68 | 1.69 | 1.57 | 1.6 | 108513.0 |
| 2013-06-17 | AAV-DELISTED | Stock | 4.33 | 4.34 | 4.26 | 4.3 | 164346.0 |
| 2013-06-17 | AAWW-DELISTED | Stock | 46.55 | 46.83 | 44.85 | 46.15 | 191298.0 |
| 2013-06-17 | AAXJ | Stock | 56.39 | 56.69 | 56.17 | 56.38 | 265162.0 |
| 2013-06-17 | AAXN-DELISTED | Stock | 9.33 | 9.42 | 9.32 | 9.4 | 269412.0 |
| 2013-06-17 | AB | Stock | 24.52 | 24.89 | 24.13 | 24.15 | 226100.0 |
| 2013-06-17 | ABAC-DELISTED | Stock | 0.55 | 0.77 | 0.55 | 0.77 | 139177.0 |
| 2013-06-17 | ABAX-DELISTED | Stock | 46.84 | 46.9399 | 46.42 | 46.68 | 71955.0 |
| 2013-06-17 | ABB-DELISTED | Stock | 22.52 | 22.56 | 22.22 | 22.29 | 2144602.0 |
| 2013-06-17 | ABBNY-DELISTED | Stock | 22.52 | 22.56 | 22.22 | 22.3 | 2793522.0 |
| 2013-06-17 | ABBV | Stock | 43.4 | 43.5 | 42.68 | 43.01 | 3457700.0 |
| 2013-06-17 | ABC-DELISTED | Stock | 55.13 | 55.68 | 55.05 | 55.65 | 2886536.0 |
| 2013-06-17 | ABCB | Stock | 16.36 | 16.83 | 16.06 | 16.27 | 10900.0 |
| 2013-06-17 | ABCD-DELISTED | Stock | 1.32 | 1.3399 | 1.32 | 1.3399 | 500.0 |
| 2013-06-17 | ABCO-DELISTED | Stock | 53.66 | 53.98 | 52.87 | 53.97 | 218357.0 |
| 2013-06-17 | ABCW-DELISTED | Stock | 0.58 | 0.58 | 0.56 | 0.56 | 11146.0 |
| 2013-06-17 | ABE-DELISTED | Stock | 20.26 | 20.5 | 20.23 | 20.39 | 2402.0 |
| 2013-06-17 | ABEO | Stock | 575.0 | 625.0 | 575.0 | 625.0 | 33.0 |
| 2013-06-17 | ABFS-DELISTED | Stock | 19.93 | 19.93 | 19.1201 | 19.415 | 395625.0 |
| 2013-06-17 | ABG | Stock | 40.72 | 41.12 | 40.04 | 40.48 | 158100.0 |
| 2013-06-17 | ABM | Stock | 24.35 | 24.83 | 24.32 | 24.74 | 170700.0 |
| 2013-06-17 | ABMD-DELISTED | Stock | 21.75 | 22.028 | 21.29 | 21.74 | 458990.0 |
| 2013-06-17 | ABR | Stock | 6.86 | 6.86 | 6.53 | 6.57 | 264500.0 |
| 2013-06-17 | ABR.A-DELISTED | Stock | 24.95 | 24.97 | 24.801 | 24.82 | 6733.0 |
| 2013-06-17 | ABR.B-DELISTED | Stock | 24.44 | 24.44 | 24.195 | 24.195 | 2400.0 |
| 2013-06-17 | ABT | Stock | 37.07 | 37.33 | 36.72 | 36.89 | 6356000.0 |
| 2013-06-17 | ABTL-DELISTED | Stock | 4.76 | 4.76 | 4.7 | 4.73 | 17308.0 |
| 2013-06-17 | ABUS | Stock | 4.87 | 4.87 | 4.77 | 4.8 | 14600.0 |
| 2013-06-17 | ABV-DELISTED | Stock | 36.89 | 37.3525 | 36.151 | 36.38 | 3208466.0 |
| 2013-06-17 | ABX-DELISTED | Stock | 19.54 | 19.73 | 19.31 | 19.43 | 7934874.0 |
> showing 50 of 6,370 rows — these rows as CSV