PREVIEW / stock_daily / 2015-04-10
file: by_date/stock_daily/2015/2015-04-10.parquet size: 223 KB rows: 6,647 symbols: 3,508
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-04-10 | AAPL | Stock | 31.4875 | 31.8025 | 31.315 | 31.775 | 160752000.0 |
| 2015-04-10 | MSFT | Stock | 41.63 | 41.95 | 41.41 | 41.72 | 28022000.0 |
| 2015-04-10 | NVDA | Stock | 0.5638 | 0.5692 | 0.5618 | 0.569 | 258728000.0 |
| 2015-04-10 | AMZN | Stock | 19.2155 | 19.356 | 19.066 | 19.1325 | 51470000.0 |
| 2015-04-10 | GOOGL | Stock | 27.4785 | 27.4925 | 27.249 | 27.427 | 26104380.0 |
| 2015-04-10 | META | Stock | 82.21 | 82.61 | 81.91 | 82.04 | 12529700.0 |
| 2015-04-10 | TSLA | Stock | 13.99 | 14.11 | 13.9333 | 14.06 | 61015500.0 |
| 2015-04-10 | TLT | Stock | 130.32 | 130.45 | 129.55 | 129.62 | 4842983.0 |
| 2015-04-10 | ES | Stock | 50.12 | 50.83 | 50.05 | 50.5 | 679900.0 |
| 2015-04-10 | CL | Stock | 69.89 | 70.04 | 69.58 | 69.61 | 1708400.0 |
| 2015-04-10 | A | Stock | 42.8 | 43.56 | 42.57 | 43.55 | 3370600.0 |
| 2015-04-10 | AA.B-DELISTED | Stock | 44.92 | 44.92 | 44.18 | 44.46 | 293803.0 |
| 2015-04-10 | AABA-DELISTED | Stock | 45.79 | 45.79 | 45.0 | 45.175 | 7619092.0 |
| 2015-04-10 | AAC-DELISTED | Stock | 32.08 | 32.5 | 30.77 | 32.12 | 170635.0 |
| 2015-04-10 | AACG | Stock | 4.4 | 4.6 | 4.38 | 4.6 | 28100.0 |
| 2015-04-10 | AAIC-DELISTED | Stock | 24.17 | 24.23 | 24.07 | 24.22 | 117868.0 |
| 2015-04-10 | AAL | Stock | 48.16 | 48.79 | 47.72 | 47.73 | 11713400.0 |
| 2015-04-10 | AAMC-DELISTED | Stock | 72.6471 | 72.6471 | 68.7676 | 70.2941 | 40525.0 |
| 2015-04-10 | AAME | Stock | 3.99 | 4.0 | 3.98 | 4.0 | 4400.0 |
| 2015-04-10 | AAMI | Stock | 19.0 | 19.14 | 18.52 | 18.62 | 207600.0 |
| 2015-04-10 | AAOI | Stock | 13.75 | 13.75 | 13.26 | 13.45 | 204200.0 |
| 2015-04-10 | AAON | Stock | 15.7533 | 15.9667 | 15.7533 | 15.9 | 86250.0 |
| 2015-04-10 | AAP | Stock | 148.67 | 150.53 | 147.57 | 150.2 | 587900.0 |
| 2015-04-10 | AAT | Stock | 42.37 | 42.51 | 41.92 | 42.1 | 115900.0 |
| 2015-04-10 | AAU-DELISTED | Stock | 0.8 | 0.8302 | 0.8 | 0.8 | 104667.0 |
| 2015-04-10 | AAUAF-DELISTED | Stock | 0.8 | 0.82 | 0.8 | 0.81 | 106721.0 |
| 2015-04-10 | AAV-DELISTED | Stock | 5.65 | 5.65 | 5.57 | 5.61 | 78523.0 |
| 2015-04-10 | AAVL-DELISTED | Stock | 39.52 | 41.28 | 39.06 | 40.61 | 171127.0 |
| 2015-04-10 | AAWW-DELISTED | Stock | 43.19 | 43.9 | 42.97 | 43.72 | 140500.0 |
| 2015-04-10 | AAXJ | Stock | 68.13 | 68.43 | 67.94 | 68.35 | 784998.0 |
| 2015-04-10 | AAXN-DELISTED | Stock | 27.48 | 27.5 | 26.8 | 27.07 | 1873952.0 |
| 2015-04-10 | AB | Stock | 31.05 | 31.34 | 30.91 | 31.32 | 120500.0 |
| 2015-04-10 | ABAC-DELISTED | Stock | 1.65 | 1.72 | 1.59 | 1.6501 | 12848.0 |
| 2015-04-10 | ABAX-DELISTED | Stock | 63.92 | 64.48 | 63.5 | 63.97 | 53983.0 |
| 2015-04-10 | ABB-DELISTED | Stock | 21.5 | 21.55 | 21.416 | 21.54 | 595417.0 |
| 2015-04-10 | ABBNY-DELISTED | Stock | 21.5 | 21.55 | 21.416 | 21.54 | 647446.0 |
| 2015-04-10 | ABBV | Stock | 60.5 | 62.33 | 60.32 | 62.0 | 17894700.0 |
| 2015-04-10 | ABC-DELISTED | Stock | 113.4 | 115.55 | 113.2244 | 115.36 | 1699873.0 |
| 2015-04-10 | ABCB | Stock | 26.58 | 26.76 | 26.47 | 26.66 | 72000.0 |
| 2015-04-10 | ABCD-DELISTED | Stock | 3.05 | 3.07 | 2.969 | 3.03 | 113033.0 |
| 2015-04-10 | ABCO-DELISTED | Stock | 52.38 | 53.46 | 51.85 | 53.41 | 140650.0 |
| 2015-04-10 | ABCW-DELISTED | Stock | 34.9 | 35.0 | 34.39 | 34.76 | 5420.0 |
| 2015-04-10 | ABDC-DELISTED | Stock | 14.2 | 14.25 | 13.89 | 14.15 | 48890.0 |
| 2015-04-10 | ABE-DELISTED | Stock | 13.17 | 13.1921 | 13.14 | 13.17 | 21051.0 |
| 2015-04-10 | ABEO | Stock | 88.0 | 88.75 | 83.0 | 87.5 | 1800.0 |
| 2015-04-10 | ABEV | Stock | 6.29 | 6.37 | 6.27 | 6.35 | 7689800.0 |
| 2015-04-10 | ABG | Stock | 85.49 | 86.19 | 85.16 | 85.48 | 184000.0 |
| 2015-04-10 | ABGB-DELISTED | Stock | 17.85 | 18.44 | 17.76 | 17.97 | 256447.0 |
| 2015-04-10 | ABIL-DELISTED | Stock | 10.08 | 10.08 | 10.065 | 10.065 | 70811.0 |
| 2015-04-10 | ABM | Stock | 32.46 | 32.52 | 31.86 | 31.89 | 289300.0 |
> showing 50 of 6,647 rows — these rows as CSV