PREVIEW / stock_daily / 2015-02-24
file: by_date/stock_daily/2015/2015-02-24.parquet size: 224 KB rows: 6,643 symbols: 3,516
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-02-24 | AAPL | Stock | 33.235 | 33.4 | 32.7925 | 33.0425 | 276912400.0 |
| 2015-02-24 | MSFT | Stock | 44.15 | 44.3 | 43.92 | 44.09 | 25271700.0 |
| 2015-02-24 | NVDA | Stock | 0.554 | 0.5578 | 0.549 | 0.5578 | 149356000.0 |
| 2015-02-24 | AMZN | Stock | 18.9325 | 19.024 | 18.808 | 18.9295 | 38416000.0 |
| 2015-02-24 | GOOGL | Stock | 26.5775 | 26.97 | 26.55 | 26.9325 | 28427460.0 |
| 2015-02-24 | META | Stock | 78.5 | 79.48 | 78.1 | 78.45 | 18897100.0 |
| 2015-02-24 | TSLA | Stock | 13.8193 | 13.8193 | 13.4467 | 13.6073 | 99054000.0 |
| 2015-02-24 | TLT | Stock | 127.65 | 129.79 | 127.18 | 129.67 | 11958343.0 |
| 2015-02-24 | ES | Stock | 52.57 | 53.52 | 52.37 | 53.34 | 1251200.0 |
| 2015-02-24 | CL | Stock | 70.86 | 71.22 | 70.47 | 71.01 | 2497100.0 |
| 2015-02-24 | A | Stock | 41.62 | 42.11 | 41.6 | 42.06 | 1922100.0 |
| 2015-02-24 | AA.B-DELISTED | Stock | 50.02 | 50.54 | 50.0 | 50.36 | 74059.0 |
| 2015-02-24 | AABA-DELISTED | Stock | 43.45 | 43.52 | 42.91 | 43.3774 | 9037748.0 |
| 2015-02-24 | AAC-DELISTED | Stock | 32.0 | 33.5 | 31.99 | 33.24 | 152275.0 |
| 2015-02-24 | AACG | Stock | 4.25 | 4.38 | 4.25 | 4.25 | 6500.0 |
| 2015-02-24 | AAIC-DELISTED | Stock | 24.7 | 24.82 | 24.7 | 24.7 | 339425.0 |
| 2015-02-24 | AAL | Stock | 50.29 | 51.56 | 49.36 | 51.52 | 13916700.0 |
| 2015-02-24 | AAMC-DELISTED | Stock | 63.2353 | 63.2353 | 61.1765 | 62.35 | 9768.0 |
| 2015-02-24 | AAME | Stock | 3.94 | 4.03 | 3.94 | 4.02 | 1200.0 |
| 2015-02-24 | AAMI | Stock | 17.25 | 17.45 | 17.115 | 17.22 | 164900.0 |
| 2015-02-24 | AAOI | Stock | 10.03 | 10.74 | 9.83 | 10.35 | 304000.0 |
| 2015-02-24 | AAON | Stock | 15.78 | 15.9333 | 15.7533 | 15.9133 | 182850.0 |
| 2015-02-24 | AAP | Stock | 157.35 | 157.7 | 155.3 | 156.4 | 643200.0 |
| 2015-02-24 | AAT | Stock | 42.87 | 42.87 | 41.55 | 41.74 | 175800.0 |
| 2015-02-24 | AAU-DELISTED | Stock | 1.1 | 1.1101 | 1.08 | 1.09 | 169429.0 |
| 2015-02-24 | AAUAF-DELISTED | Stock | 1.1 | 1.1 | 1.07 | 1.09 | 171860.0 |
| 2015-02-24 | AAV-DELISTED | Stock | 5.25 | 5.33 | 5.11 | 5.29 | 179755.0 |
| 2015-02-24 | AAVL-DELISTED | Stock | 37.04 | 37.7 | 36.1 | 36.65 | 153155.0 |
| 2015-02-24 | AAWW-DELISTED | Stock | 47.44 | 47.74 | 46.8 | 47.48 | 148840.0 |
| 2015-02-24 | AAXJ | Stock | 63.57 | 64.0094 | 63.2835 | 63.87 | 3455089.0 |
| 2015-02-24 | AAXN-DELISTED | Stock | 27.62 | 27.92 | 27.25 | 27.51 | 1090803.0 |
| 2015-02-24 | AB | Stock | 26.96 | 27.27 | 26.86 | 27.2 | 475400.0 |
| 2015-02-24 | ABAX-DELISTED | Stock | 62.25 | 62.25 | 60.89 | 60.89 | 117310.0 |
| 2015-02-24 | ABB-DELISTED | Stock | 21.37 | 21.495 | 21.345 | 21.42 | 1064997.0 |
| 2015-02-24 | ABBNY-DELISTED | Stock | 21.37 | 21.495 | 21.345 | 21.42 | 1139807.0 |
| 2015-02-24 | ABBV | Stock | 60.85 | 61.3 | 60.52 | 60.87 | 7900700.0 |
| 2015-02-24 | ABC-DELISTED | Stock | 102.76 | 103.14 | 102.29 | 102.97 | 1058307.0 |
| 2015-02-24 | ABCB | Stock | 26.03 | 26.37 | 26.03 | 26.26 | 42200.0 |
| 2015-02-24 | ABCD-DELISTED | Stock | 2.7 | 2.72 | 2.7 | 2.72 | 3500.0 |
| 2015-02-24 | ABCO-DELISTED | Stock | 53.4 | 54.31 | 53.26 | 53.7 | 387959.0 |
| 2015-02-24 | ABCW-DELISTED | Stock | 34.52 | 34.53 | 34.28 | 34.505 | 2464.0 |
| 2015-02-24 | ABDC-DELISTED | Stock | 13.899 | 13.93 | 13.67 | 13.93 | 31820.0 |
| 2015-02-24 | ABE-DELISTED | Stock | 13.27 | 13.301 | 13.16 | 13.3 | 15038.0 |
| 2015-02-24 | ABEO | Stock | 76.25 | 80.75 | 76.25 | 78.0 | 396.0 |
| 2015-02-24 | ABEOW-DELISTED | Stock | 1.0 | 1.0 | 0.9002 | 1.0 | 6300.0 |
| 2015-02-24 | ABEV | Stock | 6.44 | 6.59 | 6.37 | 6.52 | 10594800.0 |
| 2015-02-24 | ABG | Stock | 78.48 | 78.8 | 77.2 | 77.71 | 239700.0 |
| 2015-02-24 | ABGB-DELISTED | Stock | 17.57 | 17.69 | 17.41 | 17.69 | 369998.0 |
| 2015-02-24 | ABM | Stock | 30.93 | 31.37 | 30.89 | 31.12 | 197900.0 |
| 2015-02-24 | ABMD-DELISTED | Stock | 61.02 | 61.2 | 60.07 | 60.93 | 259145.0 |
> showing 50 of 6,643 rows — these rows as CSV