PREVIEW / stock_daily / 2015-01-08
file: by_date/stock_daily/2015/2015-01-08.parquet size: 222 KB rows: 6,642 symbols: 3,535
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-01-08 | AAPL | Stock | 27.3075 | 28.0375 | 27.175 | 27.9725 | 237458000.0 |
| 2015-01-08 | MSFT | Stock | 46.75 | 47.75 | 46.72 | 47.59 | 29645200.0 |
| 2015-01-08 | NVDA | Stock | 0.484 | 0.4995 | 0.4838 | 0.4965 | 283780000.0 |
| 2015-01-08 | AMZN | Stock | 15.016 | 15.157 | 14.8055 | 15.023 | 61768000.0 |
| 2015-01-08 | GOOGL | Stock | 25.0755 | 25.375 | 24.751 | 25.3455 | 73244480.0 |
| 2015-01-08 | META | Stock | 76.74 | 78.23 | 76.08 | 78.18 | 23961000.0 |
| 2015-01-08 | TSLA | Stock | 14.1873 | 14.2533 | 14.0007 | 14.0413 | 51637500.0 |
| 2015-01-08 | TLT | Stock | 130.36 | 130.37 | 129.42 | 129.65 | 8055253.0 |
| 2015-01-08 | ES | Stock | 53.96 | 54.46 | 53.84 | 54.16 | 2115100.0 |
| 2015-01-08 | CL | Stock | 68.95 | 69.31 | 68.68 | 69.28 | 2745200.0 |
| 2015-01-08 | A | Stock | 40.24 | 40.98 | 40.18 | 40.89 | 2116300.0 |
| 2015-01-08 | AA.B-DELISTED | Stock | 50.44 | 51.24 | 50.44 | 51.24 | 40559.0 |
| 2015-01-08 | AABA-DELISTED | Stock | 48.87 | 50.23 | 48.72 | 50.22 | 13709290.0 |
| 2015-01-08 | AAC-DELISTED | Stock | 28.96 | 29.51 | 28.57 | 29.36 | 69286.0 |
| 2015-01-08 | AACG | Stock | 4.33 | 4.33 | 4.03 | 4.23 | 17200.0 |
| 2015-01-08 | AAIC-DELISTED | Stock | 26.51 | 26.6863 | 26.41 | 26.62 | 151887.0 |
| 2015-01-08 | AAL | Stock | 53.48 | 54.28 | 53.25 | 53.66 | 9672100.0 |
| 2015-01-08 | AAMC-DELISTED | Stock | 97.0588 | 100.8382 | 91.25 | 100.8382 | 23630.0 |
| 2015-01-08 | AAME | Stock | 3.92 | 3.95 | 3.92 | 3.95 | 2200.0 |
| 2015-01-08 | AAMI | Stock | 15.54 | 15.714 | 15.22 | 15.51 | 195400.0 |
| 2015-01-08 | AAOI | Stock | 9.99 | 10.23 | 9.84 | 9.96 | 214200.0 |
| 2015-01-08 | AAON | Stock | 14.0933 | 14.38 | 13.9733 | 14.3733 | 246450.0 |
| 2015-01-08 | AAP | Stock | 163.36 | 163.46 | 161.0 | 161.12 | 1025700.0 |
| 2015-01-08 | AAT | Stock | 42.25 | 42.38 | 41.56 | 42.18 | 209200.0 |
| 2015-01-08 | AAU-DELISTED | Stock | 1.07 | 1.18 | 1.05 | 1.11 | 914224.0 |
| 2015-01-08 | AAUAF-DELISTED | Stock | 1.07 | 1.18 | 1.05 | 1.11 | 919386.0 |
| 2015-01-08 | AAV-DELISTED | Stock | 4.5 | 4.64 | 4.48 | 4.51 | 157013.0 |
| 2015-01-08 | AAVL-DELISTED | Stock | 61.82 | 62.48 | 58.97 | 59.23 | 1819678.0 |
| 2015-01-08 | AAWW-DELISTED | Stock | 46.82 | 48.43 | 46.49 | 48.2 | 339445.0 |
| 2015-01-08 | AAXJ | Stock | 60.96 | 61.53 | 60.92 | 61.4 | 2052973.0 |
| 2015-01-08 | AAXN-DELISTED | Stock | 26.19 | 26.66 | 25.75 | 26.63 | 2292789.0 |
| 2015-01-08 | AB | Stock | 25.03 | 25.59 | 25.01 | 25.5 | 220000.0 |
| 2015-01-08 | ABAC-DELISTED | Stock | 1.66 | 1.6999 | 1.66 | 1.6748 | 6400.0 |
| 2015-01-08 | ABAX-DELISTED | Stock | 57.69 | 59.18 | 57.15 | 58.52 | 177217.0 |
| 2015-01-08 | ABB-DELISTED | Stock | 20.06 | 20.4 | 20.05 | 20.29 | 1818934.0 |
| 2015-01-08 | ABBNY-DELISTED | Stock | 20.06 | 20.4 | 20.05 | 20.31 | 2049965.0 |
| 2015-01-08 | ABBV | Stock | 68.16 | 68.29 | 67.42 | 67.63 | 7949000.0 |
| 2015-01-08 | ABC-DELISTED | Stock | 91.74 | 92.77 | 91.16 | 92.18 | 2117033.0 |
| 2015-01-08 | ABCB | Stock | 24.6 | 24.85 | 24.54 | 24.7 | 56600.0 |
| 2015-01-08 | ABCD-DELISTED | Stock | 1.75 | 1.79 | 1.74 | 1.79 | 23982.0 |
| 2015-01-08 | ABCO-DELISTED | Stock | 48.89 | 48.92 | 48.22 | 48.71 | 292883.0 |
| 2015-01-08 | ABCW-DELISTED | Stock | 34.93 | 34.93 | 34.5 | 34.71 | 5974.0 |
| 2015-01-08 | ABDC-DELISTED | Stock | 13.05 | 13.21 | 12.76 | 13.09 | 37664.0 |
| 2015-01-08 | ABE-DELISTED | Stock | 13.29 | 13.29 | 13.09 | 13.1001 | 47049.0 |
| 2015-01-08 | ABEO | Stock | 82.5 | 85.0 | 82.5 | 82.5 | 484.0 |
| 2015-01-08 | ABEOW-DELISTED | Stock | 0.801 | 0.801 | 0.8 | 0.8 | 2200.0 |
| 2015-01-08 | ABEV | Stock | 6.12 | 6.23 | 6.1 | 6.19 | 10792200.0 |
| 2015-01-08 | ABG | Stock | 75.78 | 76.68 | 75.03 | 75.5 | 339400.0 |
| 2015-01-08 | ABGB-DELISTED | Stock | 12.87 | 12.9374 | 12.54 | 12.6 | 44266.0 |
| 2015-01-08 | ABIL-DELISTED | Stock | 9.74 | 9.89 | 9.74 | 9.77 | 22800.0 |
> showing 50 of 6,642 rows — these rows as CSV