PREVIEW / stock_daily / 2015-05-06
file: by_date/stock_daily/2015/2015-05-06.parquet size: 223 KB rows: 6,655 symbols: 3,520
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-06 | AAPL | Stock | 31.64 | 31.6875 | 30.84 | 31.2525 | 288564000.0 |
| 2015-05-06 | MSFT | Stock | 47.57 | 47.77 | 46.02 | 46.28 | 52433000.0 |
| 2015-05-06 | NVDA | Stock | 0.5538 | 0.559 | 0.5452 | 0.5525 | 316484000.0 |
| 2015-05-06 | AMZN | Stock | 21.0715 | 21.136 | 20.7275 | 20.955 | 51050000.0 |
| 2015-05-06 | GOOGL | Stock | 27.132 | 27.1965 | 26.6118 | 26.754 | 39034560.0 |
| 2015-05-06 | META | Stock | 77.97 | 78.81 | 77.05 | 78.1 | 28663000.0 |
| 2015-05-06 | TSLA | Stock | 15.6067 | 15.6313 | 15.2133 | 15.362 | 79063500.0 |
| 2015-05-06 | TLT | Stock | 121.99 | 122.06 | 120.37 | 120.56 | 14355025.0 |
| 2015-05-06 | ES | Stock | 48.22 | 48.58 | 47.32 | 47.78 | 1611600.0 |
| 2015-05-06 | CL | Stock | 67.75 | 67.87 | 67.14 | 67.79 | 2248800.0 |
| 2015-05-06 | A | Stock | 41.86 | 41.86 | 41.36 | 41.59 | 934600.0 |
| 2015-05-06 | AA.B-DELISTED | Stock | 46.85 | 46.85 | 45.91 | 46.11 | 88185.0 |
| 2015-05-06 | AABA-DELISTED | Stock | 41.31 | 41.73 | 41.21 | 41.665 | 12855523.0 |
| 2015-05-06 | AAC-DELISTED | Stock | 32.15 | 32.15 | 30.61 | 30.92 | 130358.0 |
| 2015-05-06 | AACG | Stock | 4.5 | 4.75 | 4.5 | 4.57 | 13000.0 |
| 2015-05-06 | AAIC-DELISTED | Stock | 21.39 | 21.48 | 21.0852 | 21.17 | 333748.0 |
| 2015-05-06 | AAL | Stock | 46.78 | 47.64 | 46.15 | 47.05 | 10116400.0 |
| 2015-05-06 | AAMC-DELISTED | Stock | 63.2353 | 64.7059 | 63.2353 | 63.6971 | 39280.0 |
| 2015-05-06 | AAME | Stock | 3.92 | 3.97 | 3.88 | 3.97 | 4000.0 |
| 2015-05-06 | AAMI | Stock | 19.62 | 20.05 | 19.35 | 19.56 | 85900.0 |
| 2015-05-06 | AAOI | Stock | 13.52 | 13.69 | 13.283 | 13.65 | 234800.0 |
| 2015-05-06 | AAON | Stock | 15.9933 | 16.1133 | 15.7867 | 16.0933 | 224250.0 |
| 2015-05-06 | AAP | Stock | 144.32 | 144.84 | 143.0 | 144.09 | 591700.0 |
| 2015-05-06 | AAT | Stock | 39.31 | 39.61 | 38.97 | 39.3 | 143300.0 |
| 2015-05-06 | AAU-DELISTED | Stock | 0.805 | 0.8272 | 0.7599 | 0.7919 | 248283.0 |
| 2015-05-06 | AAUAF-DELISTED | Stock | 0.805 | 0.8272 | 0.7599 | 0.7941 | 250215.0 |
| 2015-05-06 | AAV-DELISTED | Stock | 5.98 | 6.0 | 5.79 | 5.88 | 160419.0 |
| 2015-05-06 | AAVL-DELISTED | Stock | 29.27 | 33.65 | 29.06 | 33.5 | 414586.0 |
| 2015-05-06 | AAWW-DELISTED | Stock | 55.55 | 56.37 | 54.89 | 55.85 | 606792.0 |
| 2015-05-06 | AAXJ | Stock | 67.76 | 67.9 | 67.01 | 67.14 | 1473504.0 |
| 2015-05-06 | AAXN-DELISTED | Stock | 34.98 | 34.98 | 33.51 | 34.4 | 3661467.0 |
| 2015-05-06 | AB | Stock | 32.06 | 32.17 | 31.14 | 31.53 | 247900.0 |
| 2015-05-06 | ABAC-DELISTED | Stock | 1.62 | 1.62 | 1.551 | 1.5644 | 2223.0 |
| 2015-05-06 | ABAX-DELISTED | Stock | 53.36 | 53.47 | 52.02 | 52.75 | 265680.0 |
| 2015-05-06 | ABB-DELISTED | Stock | 21.64 | 21.7 | 21.395 | 21.48 | 1721534.0 |
| 2015-05-06 | ABBNY-DELISTED | Stock | 21.64 | 21.7 | 21.395 | 21.47 | 1953101.0 |
| 2015-05-06 | ABBV | Stock | 64.11 | 64.53 | 63.4 | 63.94 | 8476300.0 |
| 2015-05-06 | ABC-DELISTED | Stock | 114.9 | 115.13 | 113.507 | 114.07 | 1488184.0 |
| 2015-05-06 | ABCB | Stock | 24.76 | 25.0 | 24.44 | 24.77 | 56400.0 |
| 2015-05-06 | ABCD-DELISTED | Stock | 2.98 | 3.04 | 2.95 | 2.97 | 21636.0 |
| 2015-05-06 | ABCO-DELISTED | Stock | 50.96 | 51.7 | 48.31 | 50.16 | 335135.0 |
| 2015-05-06 | ABCW-DELISTED | Stock | 37.1 | 37.58 | 36.68 | 36.68 | 19084.0 |
| 2015-05-06 | ABDC-DELISTED | Stock | 14.0 | 14.0 | 13.68 | 13.7 | 29766.0 |
| 2015-05-06 | ABE-DELISTED | Stock | 13.11 | 13.15 | 13.04 | 13.0401 | 20777.0 |
| 2015-05-06 | ABEO | Stock | 227.5 | 278.75 | 205.0 | 215.0 | 2604408.0 |
| 2015-05-06 | ABEOW-DELISTED | Stock | 4.38 | 6.1 | 3.5 | 3.75 | 572708.0 |
| 2015-05-06 | ABEV | Stock | 6.62 | 6.63 | 6.41 | 6.45 | 16995600.0 |
| 2015-05-06 | ABG | Stock | 84.33 | 84.56 | 82.32 | 84.2 | 476700.0 |
| 2015-05-06 | ABGB-DELISTED | Stock | 16.11 | 16.11 | 15.86 | 15.92 | 19166.0 |
| 2015-05-06 | ABIL-DELISTED | Stock | 10.4 | 10.4 | 10.0 | 10.4 | 1308.0 |
> showing 50 of 6,655 rows — these rows as CSV