PREVIEW / stock_daily / 2015-08-04
file: by_date/stock_daily/2015/2015-08-04.parquet size: 223 KB rows: 6,648 symbols: 3,454
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-08-04 | AAPL | Stock | 29.355 | 29.425 | 28.3125 | 28.66 | 496554400.0 |
| 2015-08-04 | MSFT | Stock | 46.75 | 47.71 | 46.68 | 47.54 | 33403900.0 |
| 2015-08-04 | NVDA | Stock | 0.5055 | 0.5108 | 0.5035 | 0.5093 | 260100000.0 |
| 2015-08-04 | AMZN | Stock | 26.4845 | 26.8475 | 26.458 | 26.595 | 58692000.0 |
| 2015-08-04 | GOOGL | Stock | 33.217 | 33.4 | 33.0255 | 33.064 | 26188200.0 |
| 2015-08-04 | META | Stock | 93.79 | 94.73 | 93.33 | 94.06 | 20136000.0 |
| 2015-08-04 | TSLA | Stock | 17.334 | 17.7813 | 17.2227 | 17.752 | 35287500.0 |
| 2015-08-04 | TLT | Stock | 123.16 | 123.315 | 122.46 | 122.57 | 6448757.0 |
| 2015-08-04 | ES | Stock | 49.83 | 49.83 | 49.02 | 49.1 | 1004300.0 |
| 2015-08-04 | CL | Stock | 68.34 | 68.71 | 68.06 | 68.45 | 2770500.0 |
| 2015-08-04 | A | Stock | 40.94 | 41.35 | 40.55 | 40.62 | 1448100.0 |
| 2015-08-04 | AA.B-DELISTED | Stock | 35.71 | 36.41 | 35.6367 | 35.8 | 72640.0 |
| 2015-08-04 | AABA-DELISTED | Stock | 36.61 | 37.21 | 36.6 | 37.12 | 8520484.0 |
| 2015-08-04 | AAC-DELISTED | Stock | 32.79 | 32.86 | 15.09 | 20.0 | 7823287.0 |
| 2015-08-04 | AACG | Stock | 3.5 | 3.55 | 3.41 | 3.41 | 16500.0 |
| 2015-08-04 | AAIC-DELISTED | Stock | 19.12 | 19.12 | 18.82 | 18.84 | 173853.0 |
| 2015-08-04 | AAL | Stock | 42.15 | 42.77 | 41.88 | 42.74 | 13354300.0 |
| 2015-08-04 | AAMC-DELISTED | Stock | 38.2324 | 39.1206 | 38.2324 | 38.25 | 12291.0 |
| 2015-08-04 | AAME | Stock | 3.66 | 3.7 | 3.52 | 3.7 | 4800.0 |
| 2015-08-04 | AAMI | Stock | 17.41 | 17.47 | 17.22 | 17.27 | 101600.0 |
| 2015-08-04 | AAOI | Stock | 18.98 | 19.2 | 18.53 | 18.73 | 250000.0 |
| 2015-08-04 | AAON | Stock | 14.5533 | 14.8133 | 14.5267 | 14.5467 | 176250.0 |
| 2015-08-04 | AAP | Stock | 174.3 | 176.1 | 173.7 | 175.1 | 474700.0 |
| 2015-08-04 | AAT | Stock | 41.53 | 41.69 | 40.98 | 41.05 | 124900.0 |
| 2015-08-04 | AAU-DELISTED | Stock | 0.5613 | 0.7564 | 0.5613 | 0.69 | 158994.0 |
| 2015-08-04 | AAUAF-DELISTED | Stock | 0.5613 | 0.7564 | 0.5613 | 0.69 | 161327.0 |
| 2015-08-04 | AAV-DELISTED | Stock | 5.36 | 5.71 | 5.36 | 5.65 | 60177.0 |
| 2015-08-04 | AAVL-DELISTED | Stock | 15.41 | 15.49 | 15.0 | 15.13 | 150872.0 |
| 2015-08-04 | AAWW-DELISTED | Stock | 48.99 | 49.39 | 47.8 | 47.98 | 448045.0 |
| 2015-08-04 | AAXJ | Stock | 58.8 | 58.97 | 58.4605 | 58.62 | 1297341.0 |
| 2015-08-04 | AAXN-DELISTED | Stock | 25.53 | 26.54 | 25.29 | 26.23 | 3300948.0 |
| 2015-08-04 | AB | Stock | 28.19 | 29.21 | 28.19 | 29.02 | 313200.0 |
| 2015-08-04 | ABAC-DELISTED | Stock | 1.08 | 1.0899 | 1.08 | 1.0899 | 800.0 |
| 2015-08-04 | ABAX-DELISTED | Stock | 49.59 | 49.85 | 49.09 | 49.38 | 133589.0 |
| 2015-08-04 | ABB-DELISTED | Stock | 20.17 | 20.26 | 20.02 | 20.05 | 1378167.0 |
| 2015-08-04 | ABBNY-DELISTED | Stock | 20.17 | 20.26 | 20.02 | 20.04 | 1422785.0 |
| 2015-08-04 | ABBV | Stock | 70.04 | 70.39 | 69.67 | 69.95 | 5410900.0 |
| 2015-08-04 | ABC-DELISTED | Stock | 106.16 | 106.96 | 105.78 | 106.19 | 1939758.0 |
| 2015-08-04 | ABCB | Stock | 27.27 | 27.89 | 27.27 | 27.78 | 171800.0 |
| 2015-08-04 | ABCD-DELISTED | Stock | 4.88 | 5.0 | 4.76 | 4.8 | 56489.0 |
| 2015-08-04 | ABCO-DELISTED | Stock | 59.38 | 59.96 | 59.08 | 59.38 | 211750.0 |
| 2015-08-04 | ABCW-DELISTED | Stock | 38.91 | 40.05 | 38.91 | 39.25 | 7568.0 |
| 2015-08-04 | ABDC-DELISTED | Stock | 12.45 | 12.45 | 12.23 | 12.32 | 19646.0 |
| 2015-08-04 | ABE-DELISTED | Stock | 12.6 | 12.6 | 12.52 | 12.52 | 2839.0 |
| 2015-08-04 | ABEO | Stock | 163.5 | 174.75 | 162.0 | 172.25 | 16416.0 |
| 2015-08-04 | ABEOW-DELISTED | Stock | 2.45 | 2.8 | 2.45 | 2.5501 | 1538.0 |
| 2015-08-04 | ABEV | Stock | 5.6 | 5.7 | 5.6 | 5.68 | 10808900.0 |
| 2015-08-04 | ABG | Stock | 85.36 | 86.35 | 83.72 | 84.04 | 487300.0 |
| 2015-08-04 | ABGB-DELISTED | Stock | 6.46 | 6.5 | 5.7701 | 6.0 | 453246.0 |
| 2015-08-04 | ABIL-DELISTED | Stock | 9.9601 | 9.9601 | 9.95 | 9.95 | 7400.0 |
> showing 50 of 6,648 rows — these rows as CSV