PREVIEW / stock_daily / 2015-08-25
file: by_date/stock_daily/2015/2015-08-25.parquet size: 222 KB rows: 6,700 symbols: 3,491
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-25 | AAPL | Stock | 27.7775 | 27.7775 | 25.875 | 25.935 | 414406400.0 |
| 2015-08-25 | MSFT | Stock | 42.57 | 43.24 | 40.39 | 40.47 | 70616600.0 |
| 2015-08-25 | NVDA | Stock | 0.5405 | 0.5425 | 0.507 | 0.507 | 622684000.0 |
| 2015-08-25 | AMZN | Stock | 24.3745 | 24.472 | 23.3125 | 23.3185 | 113586000.0 |
| 2015-08-25 | GOOGL | Stock | 32.3234 | 32.35 | 30.5835 | 30.6235 | 71429380.0 |
| 2015-08-25 | META | Stock | 86.95 | 87.67 | 83.0 | 83.0 | 52021200.0 |
| 2015-08-25 | TSLA | Stock | 15.368 | 15.3933 | 14.608 | 14.6687 | 64909500.0 |
| 2015-08-25 | TLT | Stock | 124.55 | 124.79 | 123.56 | 124.33 | 15354785.0 |
| 2015-08-25 | ES | Stock | 49.24 | 49.72 | 47.21 | 47.25 | 2158200.0 |
| 2015-08-25 | CL | Stock | 63.24 | 63.49 | 60.32 | 60.37 | 6483500.0 |
| 2015-08-25 | A | Stock | 35.68 | 36.17 | 34.3 | 34.36 | 3802700.0 |
| 2015-08-25 | AA.B-DELISTED | Stock | 32.43 | 32.75 | 31.58 | 31.58 | 43848.0 |
| 2015-08-25 | AABA-DELISTED | Stock | 33.02 | 33.03 | 31.535 | 31.75 | 14556830.0 |
| 2015-08-25 | AAC-DELISTED | Stock | 23.33 | 25.49 | 21.065 | 21.29 | 326275.0 |
| 2015-08-25 | AACG | Stock | 2.4 | 2.71 | 2.4 | 2.4 | 17500.0 |
| 2015-08-25 | AAIC-DELISTED | Stock | 16.64 | 16.8 | 16.09 | 16.1 | 302526.0 |
| 2015-08-25 | AAL | Stock | 39.39 | 39.49 | 37.49 | 37.5 | 12820300.0 |
| 2015-08-25 | AAMC-DELISTED | Stock | 10.1471 | 10.4059 | 8.7794 | 8.8294 | 48963.0 |
| 2015-08-25 | AAME | Stock | 3.58 | 3.6 | 3.53 | 3.53 | 1700.0 |
| 2015-08-25 | AAMI | Stock | 16.04 | 16.945 | 15.17 | 15.28 | 263000.0 |
| 2015-08-25 | AAOI | Stock | 19.76 | 19.99 | 19.05 | 19.18 | 431800.0 |
| 2015-08-25 | AAON | Stock | 14.0667 | 14.0667 | 13.1267 | 13.2267 | 258900.0 |
| 2015-08-25 | AAP | Stock | 177.49 | 179.13 | 171.14 | 171.22 | 1044000.0 |
| 2015-08-25 | AAT | Stock | 40.0 | 40.0 | 37.87 | 37.88 | 245100.0 |
| 2015-08-25 | AAU-DELISTED | Stock | 0.5487 | 0.5488 | 0.512 | 0.54 | 97187.0 |
| 2015-08-25 | AAUAF-DELISTED | Stock | 0.5474 | 0.5475 | 0.5108 | 0.54 | 98069.0 |
| 2015-08-25 | AAV-DELISTED | Stock | 4.97 | 4.99 | 4.83 | 4.85 | 87233.0 |
| 2015-08-25 | AAVL-DELISTED | Stock | 10.5 | 10.5 | 9.96 | 10.08 | 455754.0 |
| 2015-08-25 | AAWW-DELISTED | Stock | 41.18 | 41.18 | 39.14 | 39.21 | 350466.0 |
| 2015-08-25 | AAXJ | Stock | 52.76 | 53.11 | 50.81 | 50.81 | 3614131.0 |
| 2015-08-25 | AAXN-DELISTED | Stock | 21.2 | 22.21 | 20.73 | 21.3789 | 2099268.0 |
| 2015-08-25 | AB | Stock | 25.84 | 26.34 | 25.22 | 25.42 | 251200.0 |
| 2015-08-25 | ABAC-DELISTED | Stock | 0.7398 | 0.7398 | 0.6561 | 0.7 | 28693.0 |
| 2015-08-25 | ABAX-DELISTED | Stock | 46.98 | 47.45 | 46.006 | 46.42 | 166891.0 |
| 2015-08-25 | ABB-DELISTED | Stock | 19.21 | 19.23 | 18.61 | 18.61 | 3198128.0 |
| 2015-08-25 | ABBNY-DELISTED | Stock | 19.2 | 19.23 | 18.61 | 18.62 | 3287626.0 |
| 2015-08-25 | ABBV | Stock | 65.11 | 65.12 | 60.65 | 60.71 | 15267000.0 |
| 2015-08-25 | ABC-DELISTED | Stock | 100.62 | 100.88 | 97.32 | 97.42 | 2228471.0 |
| 2015-08-25 | ABCB | Stock | 27.46 | 27.46 | 26.08 | 26.13 | 193200.0 |
| 2015-08-25 | ABCD-DELISTED | Stock | 4.74 | 4.99 | 4.6101 | 4.85 | 124963.0 |
| 2015-08-25 | ABCO-DELISTED | Stock | 50.6 | 50.6 | 49.0 | 49.29 | 371044.0 |
| 2015-08-25 | ABCW-DELISTED | Stock | 40.1 | 40.1 | 38.715 | 39.19 | 13276.0 |
| 2015-08-25 | ABDC-DELISTED | Stock | 12.0 | 12.15 | 11.75 | 11.75 | 55232.0 |
| 2015-08-25 | ABE-DELISTED | Stock | 11.12 | 11.3264 | 10.65 | 10.69 | 37807.0 |
| 2015-08-25 | ABEO | Stock | 112.0 | 115.25 | 108.0 | 110.0 | 6088.0 |
| 2015-08-25 | ABEOW-DELISTED | Stock | 1.67 | 2.05 | 1.62 | 1.85 | 21268.0 |
| 2015-08-25 | ABEV | Stock | 5.16 | 5.2 | 5.07 | 5.07 | 26542100.0 |
| 2015-08-25 | ABG | Stock | 78.84 | 79.42 | 77.3 | 77.94 | 490100.0 |
| 2015-08-25 | ABGB-DELISTED | Stock | 5.62 | 5.62 | 4.8 | 4.87 | 201422.0 |
| 2015-08-25 | ABIL-DELISTED | Stock | 10.05 | 10.05 | 10.05 | 10.05 | 200.0 |
> showing 50 of 6,700 rows — these rows as CSV