PREVIEW / stock_daily / 2016-04-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-13.parquet
  size:    220 KB
  rows:    6,605
  symbols: 3,320

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
2016-04-13	AAPL	Stock	27.7	28.085	27.7	28.01	133029200.0
2016-04-13	MSFT	Stock	55.12	55.44	54.89	55.35	20818000.0
2016-04-13	NVDA	Stock	0.9	0.9188	0.9	0.9185	350716000.0
2016-04-13	AMZN	Stock	30.384	30.8405	30.2645	30.741	84566000.0
2016-04-13	GOOGL	Stock	38.5155	38.7875	38.2295	38.5955	35426160.0
2016-04-13	META	Stock	112.23	112.65	106.52	110.51	88227400.0
2016-04-13	TSLA	Stock	16.5673	17.0333	16.4887	16.9687	73884000.0
2016-04-13	TLT	Stock	130.69	131.58	130.52	131.39	5207859.0
2016-04-13	ES	Stock	56.86	56.86	55.95	56.07	1752200.0
2016-04-13	CL	Stock	71.33	71.5	70.58	70.83	2600000.0
2016-04-13	A	Stock	39.52	41.0	39.5	40.69	2494600.0
2016-04-13	AA.B-DELISTED	Stock	33.44	34.76	33.17	34.23	150794.0
2016-04-13	AAAP-DELISTED	Stock	36.3	36.3	34.7505	35.0	21855.0
2016-04-13	AABA-DELISTED	Stock	36.91	37.35	36.9	37.31	16400591.0
2016-04-13	AAC-DELISTED	Stock	18.5	19.77	18.5	19.54	191308.0
2016-04-13	AACG	Stock	5.49	5.49	5.25	5.33	1600.0
2016-04-13	AAIC-DELISTED	Stock	12.55	12.96	12.49	12.82	218595.0
2016-04-13	AAL	Stock	39.3	40.01	38.89	39.94	12493500.0
2016-04-13	AAMC-DELISTED	Stock	5.8853	6.0193	5.5706	5.6971	79706.0
2016-04-13	AAMI	Stock	13.18	13.92	13.04	13.81	182700.0
2016-04-13	AAOI	Stock	15.58	16.31	15.51	16.04	268200.0
2016-04-13	AAON	Stock	17.7733	18.2667	17.7733	18.24	393600.0
2016-04-13	AAP	Stock	157.68	160.9	157.46	160.49	696500.0
2016-04-13	AAT	Stock	38.68	38.68	38.06	38.3	187800.0
2016-04-13	AAU-DELISTED	Stock	1.16	1.2	1.15	1.16	479990.0
2016-04-13	AAUAF-DELISTED	Stock	1.16	1.2	1.15	1.16	483782.0
2016-04-13	AAV-DELISTED	Stock	5.54	5.64	5.43	5.43	68849.0
2016-04-13	AAVL-DELISTED	Stock	5.19	5.43	5.1	5.34	318079.0
2016-04-13	AAWW-DELISTED	Stock	39.23	40.9	39.23	40.84	176577.0
2016-04-13	AAXJ	Stock	55.4	55.57	55.28	55.56	723991.0
2016-04-13	AAXN-DELISTED	Stock	18.99	19.63	18.92	19.52	823716.0
2016-04-13	AB	Stock	23.85	24.12	23.78	23.8	252300.0
2016-04-13	ABAC-DELISTED	Stock	0.57	0.625	0.57	0.62	52366.0
2016-04-13	ABAX-DELISTED	Stock	45.57	45.87	44.665	45.87	150143.0
2016-04-13	ABB-DELISTED	Stock	19.77	19.79	19.67	19.77	1039039.0
2016-04-13	ABBNY-DELISTED	Stock	19.77	19.79	19.67	19.78	1087004.0
2016-04-13	ABBV	Stock	59.87	60.0	58.7	59.06	7023000.0
2016-04-13	ABC-DELISTED	Stock	85.33	85.78	84.65	85.17	1781897.0
2016-04-13	ABCB	Stock	29.06	29.97	29.06	29.85	129200.0
2016-04-13	ABCD-DELISTED	Stock	4.03	4.17	3.97	4.01	168251.0
2016-04-13	ABCO-DELISTED	Stock	31.5	32.39	31.325	32.02	363080.0
2016-04-13	ABCW-DELISTED	Stock	45.07	45.98	44.95	45.94	52403.0
2016-04-13	ABDC-DELISTED	Stock	11.81	11.95	11.66	11.87	25218.0
2016-04-13	ABE-DELISTED	Stock	11.92	12.18	11.92	12.13	13630.0
2016-04-13	ABEO	Stock	64.25	67.75	63.5	66.5	3056.0
2016-04-13	ABEV	Stock	5.22	5.27	5.19	5.24	20089000.0
2016-04-13	ABG	Stock	56.42	59.17	56.42	59.12	398500.0
2016-04-13	ABGB-DELISTED	Stock	1.51	1.51	1.47	1.5	8008.0
2016-04-13	ABIL-DELISTED	Stock	6.8	6.8	6.65	6.74	4380.0
2016-04-13	ABM	Stock	32.05	32.46	31.88	32.42	384400.0

> showing 50 of 6,605 rows — these rows as CSV

> unlock the full archive -- $79 one-time