PREVIEW / stock_daily / 2015-11-06
file: by_date/stock_daily/2015/2015-11-06.parquet size: 222 KB rows: 6,636 symbols: 3,414
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-11-06 | AAPL | Stock | 30.2775 | 30.4525 | 30.155 | 30.265 | 132169200.0 |
| 2015-11-06 | MSFT | Stock | 54.09 | 54.98 | 53.96 | 54.92 | 32851200.0 |
| 2015-11-06 | NVDA | Stock | 0.7612 | 0.7985 | 0.7455 | 0.7888 | 1172272000.0 |
| 2015-11-06 | AMZN | Stock | 32.75 | 33.113 | 32.6 | 32.9685 | 81844000.0 |
| 2015-11-06 | GOOGL | Stock | 37.9695 | 38.1511 | 37.7515 | 38.08 | 33543980.0 |
| 2015-11-06 | META | Stock | 108.04 | 108.74 | 105.91 | 107.1 | 35084300.0 |
| 2015-11-06 | TSLA | Stock | 15.38 | 15.5573 | 15.3 | 15.4907 | 36679500.0 |
| 2015-11-06 | TLT | Stock | 119.49 | 119.525 | 118.735 | 119.0 | 10604737.0 |
| 2015-11-06 | ES | Stock | 50.75 | 51.06 | 48.84 | 49.02 | 1801700.0 |
| 2015-11-06 | CL | Stock | 67.21 | 67.21 | 65.4 | 65.82 | 5226700.0 |
| 2015-11-06 | A | Stock | 38.1 | 38.44 | 37.98 | 38.14 | 1964100.0 |
| 2015-11-06 | AA.B-DELISTED | Stock | 32.64 | 32.64 | 31.25 | 32.5914 | 18302.0 |
| 2015-11-06 | AABA-DELISTED | Stock | 34.94 | 35.2001 | 33.46 | 34.195 | 15757661.0 |
| 2015-11-06 | AAC-DELISTED | Stock | 24.14 | 24.66 | 23.91 | 24.54 | 96310.0 |
| 2015-11-06 | AACG | Stock | 4.23 | 4.26 | 4.11 | 4.15 | 6800.0 |
| 2015-11-06 | AAIC-DELISTED | Stock | 13.83 | 14.15 | 13.72 | 14.07 | 220713.0 |
| 2015-11-06 | AAL | Stock | 45.51 | 45.97 | 45.05 | 45.34 | 11669600.0 |
| 2015-11-06 | AAMC-DELISTED | Stock | 7.7941 | 10.1853 | 7.6471 | 7.6471 | 277280.0 |
| 2015-11-06 | AAME | Stock | 4.75 | 4.75 | 4.75 | 4.75 | 1000.0 |
| 2015-11-06 | AAMI | Stock | 16.52 | 17.04 | 16.52 | 16.91 | 210400.0 |
| 2015-11-06 | AAOI | Stock | 17.69 | 20.2 | 16.945 | 17.63 | 1311600.0 |
| 2015-11-06 | AAON | Stock | 16.1867 | 16.3333 | 15.6 | 16.1533 | 361050.0 |
| 2015-11-06 | AAP | Stock | 201.24 | 201.24 | 197.07 | 198.72 | 684100.0 |
| 2015-11-06 | AAT | Stock | 40.83 | 41.49 | 39.84 | 39.9 | 420800.0 |
| 2015-11-06 | AAU-DELISTED | Stock | 0.55 | 0.5663 | 0.55 | 0.5512 | 78845.0 |
| 2015-11-06 | AAUAF-DELISTED | Stock | 0.55 | 0.5663 | 0.55 | 0.5585 | 79777.0 |
| 2015-11-06 | AAV-DELISTED | Stock | 5.76 | 6.02 | 5.76 | 5.85 | 69414.0 |
| 2015-11-06 | AAVL-DELISTED | Stock | 9.12 | 9.39 | 8.86 | 9.33 | 322582.0 |
| 2015-11-06 | AAWW-DELISTED | Stock | 38.86 | 41.57 | 38.39 | 41.29 | 244059.0 |
| 2015-11-06 | AAXJ | Stock | 56.7 | 57.215 | 56.44 | 57.18 | 1059633.0 |
| 2015-11-06 | AAXN-DELISTED | Stock | 20.07 | 20.36 | 19.8832 | 20.19 | 1511132.0 |
| 2015-11-06 | AB | Stock | 25.41 | 25.61 | 25.18 | 25.39 | 206900.0 |
| 2015-11-06 | ABAC-DELISTED | Stock | 0.64 | 0.67 | 0.64 | 0.66 | 8624.0 |
| 2015-11-06 | ABAX-DELISTED | Stock | 52.59 | 53.07 | 51.65 | 52.93 | 108404.0 |
| 2015-11-06 | ABB-DELISTED | Stock | 19.13 | 19.21 | 19.0 | 19.16 | 2052917.0 |
| 2015-11-06 | ABBNY-DELISTED | Stock | 19.13 | 19.21 | 19.0 | 19.15 | 2341645.0 |
| 2015-11-06 | ABBV | Stock | 62.25 | 64.3 | 62.13 | 64.13 | 7261100.0 |
| 2015-11-06 | ABC-DELISTED | Stock | 98.01 | 98.71 | 96.53 | 97.61 | 1388585.0 |
| 2015-11-06 | ABCB | Stock | 32.13 | 33.49 | 32.13 | 33.49 | 310500.0 |
| 2015-11-06 | ABCD-DELISTED | Stock | 5.28 | 5.4 | 5.19 | 5.37 | 23768.0 |
| 2015-11-06 | ABCO-DELISTED | Stock | 50.03 | 53.74 | 47.33 | 53.36 | 766550.0 |
| 2015-11-06 | ABCW-DELISTED | Stock | 41.66 | 42.15 | 41.65 | 42.035 | 13125.0 |
| 2015-11-06 | ABDC-DELISTED | Stock | 11.57 | 12.27 | 11.57 | 12.1199 | 18305.0 |
| 2015-11-06 | ABE-DELISTED | Stock | 11.45 | 11.45 | 11.34 | 11.42 | 3484.0 |
| 2015-11-06 | ABEO | Stock | 108.5 | 112.25 | 103.75 | 111.5 | 4236.0 |
| 2015-11-06 | ABEOW-DELISTED | Stock | 1.6 | 1.6414 | 1.55 | 1.55 | 4204.0 |
| 2015-11-06 | ABEV | Stock | 5.0 | 5.01 | 4.91 | 4.98 | 14362100.0 |
| 2015-11-06 | ABG | Stock | 79.85 | 80.42 | 77.98 | 78.14 | 626200.0 |
| 2015-11-06 | ABGB-DELISTED | Stock | 5.32 | 5.36 | 5.2 | 5.34 | 24266.0 |
| 2015-11-06 | ABIL-DELISTED | Stock | 10.09 | 10.09 | 10.09 | 10.09 | 130.0 |
> showing 50 of 6,636 rows — these rows as CSV