PREVIEW / stock_daily / 2015-03-24
file: by_date/stock_daily/2015/2015-03-24.parquet size: 222 KB rows: 6,615 symbols: 3,497
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-03-24 | AAPL | Stock | 31.8075 | 32.01 | 31.64 | 31.6725 | 131369200.0 |
| 2015-03-24 | MSFT | Stock | 42.78 | 43.17 | 42.75 | 42.9 | 25513300.0 |
| 2015-03-24 | NVDA | Stock | 0.566 | 0.57 | 0.5575 | 0.56 | 330480000.0 |
| 2015-03-24 | AMZN | Stock | 18.6995 | 18.762 | 18.6135 | 18.7045 | 44564000.0 |
| 2015-03-24 | GOOGL | Stock | 28.427 | 29.094 | 28.4045 | 28.877 | 79156880.0 |
| 2015-03-24 | META | Stock | 84.71 | 86.07 | 84.52 | 85.31 | 32576500.0 |
| 2015-03-24 | TSLA | Stock | 13.4387 | 13.586 | 13.3167 | 13.448 | 54748500.0 |
| 2015-03-24 | TLT | Stock | 131.83 | 132.64 | 131.48 | 132.62 | 6713032.0 |
| 2015-03-24 | ES | Stock | 51.27 | 51.58 | 50.66 | 50.81 | 1961400.0 |
| 2015-03-24 | CL | Stock | 69.98 | 70.65 | 69.31 | 69.31 | 2849300.0 |
| 2015-03-24 | A | Stock | 42.13 | 42.13 | 41.01 | 41.09 | 3626000.0 |
| 2015-03-24 | AA.B-DELISTED | Stock | 44.2 | 44.4699 | 43.51 | 44.18 | 82666.0 |
| 2015-03-24 | AABA-DELISTED | Stock | 44.69 | 44.78 | 44.28 | 44.42 | 6974882.0 |
| 2015-03-24 | AAC-DELISTED | Stock | 28.59 | 29.1 | 28.14 | 28.16 | 45249.0 |
| 2015-03-24 | AACG | Stock | 4.0 | 4.0 | 3.85 | 3.88 | 3900.0 |
| 2015-03-24 | AAIC-DELISTED | Stock | 25.54 | 25.55 | 25.36 | 25.39 | 314305.0 |
| 2015-03-24 | AAL | Stock | 54.04 | 54.41 | 53.66 | 53.93 | 11940800.0 |
| 2015-03-24 | AAMC-DELISTED | Stock | 57.6471 | 58.5294 | 57.3529 | 58.5294 | 8524.0 |
| 2015-03-24 | AAME | Stock | 4.01 | 4.05 | 4.01 | 4.05 | 1900.0 |
| 2015-03-24 | AAMI | Stock | 18.69 | 18.99 | 18.61 | 18.71 | 133200.0 |
| 2015-03-24 | AAOI | Stock | 14.0 | 14.219 | 13.9 | 14.08 | 149000.0 |
| 2015-03-24 | AAON | Stock | 15.6667 | 15.7333 | 15.5867 | 15.6733 | 163050.0 |
| 2015-03-24 | AAP | Stock | 148.9 | 151.91 | 148.15 | 151.01 | 688500.0 |
| 2015-03-24 | AAT | Stock | 44.49 | 44.81 | 44.12 | 44.15 | 152300.0 |
| 2015-03-24 | AAU-DELISTED | Stock | 0.92 | 0.96 | 0.92 | 0.94 | 72243.0 |
| 2015-03-24 | AAUAF-DELISTED | Stock | 0.92 | 0.96 | 0.92 | 0.94 | 72954.0 |
| 2015-03-24 | AAV-DELISTED | Stock | 5.24 | 5.27 | 5.2199 | 5.26 | 545868.0 |
| 2015-03-24 | AAVL-DELISTED | Stock | 43.12 | 44.51 | 42.59 | 43.79 | 242221.0 |
| 2015-03-24 | AAWW-DELISTED | Stock | 47.36 | 47.52 | 46.69 | 47.27 | 165892.0 |
| 2015-03-24 | AAXJ | Stock | 63.74 | 63.86 | 63.66 | 63.85 | 1776670.0 |
| 2015-03-24 | AAXN-DELISTED | Stock | 24.39 | 25.6525 | 24.39 | 25.3 | 1842663.0 |
| 2015-03-24 | AB | Stock | 30.49 | 30.49 | 29.96 | 29.98 | 213100.0 |
| 2015-03-24 | ABAC-DELISTED | Stock | 1.51 | 1.52 | 1.51 | 1.52 | 700.0 |
| 2015-03-24 | ABAX-DELISTED | Stock | 63.78 | 64.82 | 63.44 | 64.34 | 62340.0 |
| 2015-03-24 | ABB-DELISTED | Stock | 21.81 | 21.82 | 21.61 | 21.62 | 1724743.0 |
| 2015-03-24 | ABBNY-DELISTED | Stock | 21.81 | 21.82 | 21.61 | 21.64 | 1815018.0 |
| 2015-03-24 | ABBV | Stock | 60.65 | 60.82 | 59.45 | 59.63 | 7970000.0 |
| 2015-03-24 | ABC-DELISTED | Stock | 113.64 | 114.73 | 113.36 | 113.89 | 1612397.0 |
| 2015-03-24 | ABCB | Stock | 25.99 | 26.25 | 25.81 | 26.19 | 71500.0 |
| 2015-03-24 | ABCD-DELISTED | Stock | 3.25 | 3.3 | 3.2 | 3.2 | 36643.0 |
| 2015-03-24 | ABCO-DELISTED | Stock | 52.61 | 52.79 | 51.65 | 51.66 | 123828.0 |
| 2015-03-24 | ABCW-DELISTED | Stock | 34.57 | 35.37 | 34.57 | 35.055 | 5281.0 |
| 2015-03-24 | ABDC-DELISTED | Stock | 14.25 | 14.25 | 13.81 | 13.99 | 49307.0 |
| 2015-03-24 | ABE-DELISTED | Stock | 12.6993 | 12.6993 | 12.67 | 12.68 | 1153.0 |
| 2015-03-24 | ABEO | Stock | 79.75 | 79.75 | 76.5 | 77.75 | 652.0 |
| 2015-03-24 | ABEV | Stock | 6.04 | 6.04 | 5.9 | 5.94 | 9369300.0 |
| 2015-03-24 | ABG | Stock | 81.68 | 82.84 | 81.07 | 82.14 | 331100.0 |
| 2015-03-24 | ABGB-DELISTED | Stock | 17.54 | 17.6 | 17.31 | 17.32 | 10858.0 |
| 2015-03-24 | ABIL-DELISTED | Stock | 9.819 | 9.87 | 9.79 | 9.85 | 1600.0 |
| 2015-03-24 | ABM | Stock | 32.17 | 32.49 | 32.01 | 32.38 | 171200.0 |
> showing 50 of 6,615 rows — these rows as CSV