PREVIEW / stock_daily / 2013-11-12
file: by_date/stock_daily/2013/2013-11-12.parquet size: 215 KB rows: 6,441 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-12 | AAPL | Stock | 18.4882 | 18.7114 | 18.4643 | 18.5718 | 204276800.0 |
| 2013-11-12 | MSFT | Stock | 37.38 | 37.6 | 37.2 | 37.36 | 31651600.0 |
| 2013-11-12 | NVDA | Stock | 0.394 | 0.3962 | 0.3885 | 0.393 | 316032000.0 |
| 2013-11-12 | AMZN | Stock | 17.6495 | 17.774 | 17.364 | 17.4765 | 46862000.0 |
| 2013-11-12 | META | Stock | 46.0 | 47.37 | 45.83 | 46.61 | 68196000.0 |
| 2013-11-12 | TSLA | Stock | 9.646 | 9.6467 | 9.0787 | 9.1867 | 224778000.0 |
| 2013-11-12 | TLT | Stock | 103.21 | 103.59 | 103.18 | 103.5 | 4840369.0 |
| 2013-11-12 | ES | Stock | 42.17 | 42.25 | 41.67 | 41.95 | 1751800.0 |
| 2013-11-12 | CL | Stock | 64.44 | 64.86 | 64.0 | 64.72 | 3570800.0 |
| 2013-11-12 | A | Stock | 36.6237 | 36.7668 | 36.309 | 36.6237 | 3295366.0 |
| 2013-11-12 | AABA-DELISTED | Stock | 34.01 | 34.52 | 33.88 | 34.09 | 18150613.0 |
| 2013-11-12 | AACG | Stock | 4.2 | 4.2 | 4.2 | 4.2 | 5100.0 |
| 2013-11-12 | AAIC-DELISTED | Stock | 24.5 | 24.9155 | 24.5 | 24.83 | 97663.0 |
| 2013-11-12 | AAMC-DELISTED | Stock | 181.5029 | 182.3529 | 179.5588 | 179.5588 | 4175.0 |
| 2013-11-12 | AAME | Stock | 4.03 | 4.06 | 4.0 | 4.04 | 14600.0 |
| 2013-11-12 | AAMRQ-DELISTED | Stock | 9.51 | 13.5 | 9.36 | 12.0 | 73347752.0 |
| 2013-11-12 | AAOI | Stock | 12.92 | 13.1 | 12.86 | 13.0 | 12200.0 |
| 2013-11-12 | AAON | Stock | 11.8978 | 12.0667 | 11.6 | 11.9956 | 324900.0 |
| 2013-11-12 | AAP | Stock | 98.98 | 99.31 | 98.5 | 99.24 | 419000.0 |
| 2013-11-12 | AAT | Stock | 31.61 | 31.78 | 31.26 | 31.45 | 166500.0 |
| 2013-11-12 | AAU-DELISTED | Stock | 1.285 | 1.3006 | 1.25 | 1.28 | 42460.0 |
| 2013-11-12 | AAUAF-DELISTED | Stock | 1.29 | 1.31 | 1.25 | 1.27 | 42494.0 |
| 2013-11-12 | AAV-DELISTED | Stock | 3.92 | 3.947 | 3.85 | 3.85 | 116916.0 |
| 2013-11-12 | AAWW-DELISTED | Stock | 38.24 | 38.4999 | 37.76 | 37.82 | 232407.0 |
| 2013-11-12 | AAXJ | Stock | 58.92 | 58.92 | 58.33 | 58.61 | 955114.0 |
| 2013-11-12 | AAXN-DELISTED | Stock | 16.77 | 16.999 | 16.35 | 16.47 | 1123674.0 |
| 2013-11-12 | AB | Stock | 21.64 | 21.95 | 21.53 | 21.62 | 267100.0 |
| 2013-11-12 | ABAC-DELISTED | Stock | 1.83 | 1.99 | 1.71 | 1.97 | 172639.0 |
| 2013-11-12 | ABAX-DELISTED | Stock | 35.33 | 35.64 | 34.78 | 35.49 | 126171.0 |
| 2013-11-12 | ABB-DELISTED | Stock | 25.05 | 25.169 | 24.9 | 25.04 | 1018553.0 |
| 2013-11-12 | ABBNY-DELISTED | Stock | 25.07 | 25.169 | 24.9 | 25.05 | 1101297.0 |
| 2013-11-12 | ABBV | Stock | 48.45 | 48.48 | 47.28 | 47.48 | 5351100.0 |
| 2013-11-12 | ABC-DELISTED | Stock | 68.18 | 68.44 | 67.82 | 68.28 | 1308972.0 |
| 2013-11-12 | ABCB | Stock | 18.88 | 19.02 | 18.61 | 18.86 | 34700.0 |
| 2013-11-12 | ABCD-DELISTED | Stock | 1.34 | 1.35 | 1.32 | 1.32 | 14410.0 |
| 2013-11-12 | ABCO-DELISTED | Stock | 62.42 | 62.98 | 61.86 | 62.57 | 146956.0 |
| 2013-11-12 | ABE-DELISTED | Stock | 19.544 | 19.544 | 19.45 | 19.45 | 5082.0 |
| 2013-11-12 | ABEO | Stock | 400.0 | 400.0 | 375.0 | 400.0 | 15.0 |
| 2013-11-12 | ABEV | Stock | 7.27 | 7.46 | 7.17 | 7.38 | 6859500.0 |
| 2013-11-12 | ABFS-DELISTED | Stock | 30.99 | 31.8 | 30.8029 | 31.35 | 888807.0 |
| 2013-11-12 | ABG | Stock | 48.46 | 50.08 | 48.39 | 49.94 | 385600.0 |
| 2013-11-12 | ABGB-DELISTED | Stock | 12.55 | 12.5703 | 11.9 | 12.4 | 10666.0 |
| 2013-11-12 | ABM | Stock | 27.5 | 27.7 | 27.41 | 27.68 | 76900.0 |
| 2013-11-12 | ABMD-DELISTED | Stock | 27.16 | 27.48 | 26.83 | 27.42 | 415982.0 |
| 2013-11-12 | ABR | Stock | 6.52 | 6.58 | 6.42 | 6.5 | 64400.0 |
| 2013-11-12 | ABR.A-DELISTED | Stock | 25.03 | 25.03 | 24.9 | 25.0 | 8858.0 |
| 2013-11-12 | ABR.B-DELISTED | Stock | 23.49 | 23.51 | 23.28 | 23.51 | 4843.0 |
| 2013-11-12 | ABT | Stock | 37.83 | 37.97 | 37.29 | 37.47 | 6015600.0 |
| 2013-11-12 | ABTL-DELISTED | Stock | 10.22 | 11.25 | 9.96 | 10.45 | 409028.0 |
| 2013-11-12 | ABUS | Stock | 8.06 | 8.26 | 7.7 | 7.84 | 117800.0 |
> showing 50 of 6,441 rows — these rows as CSV