PREVIEW / etf_daily / 2015-05-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-14.parquet
  size:    48 KB
  rows:    1,178

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-05-14	SPY	ETF	211.24	212.32	210.91	212.21	95934000.0
2015-05-14	QQQ	ETF	108.88	109.67	108.48	109.58	23904233.0
2015-05-14	IWM	ETF	123.08	123.86	122.45	123.79	23293200.0
2015-05-14	DIA	ETF	181.81	182.64	181.73	182.54	4921400.0
2015-05-14	GLD	ETF	117.28	117.75	117.03	117.18	6923000.0
2015-05-14	TLT	ETF	118.92	119.83	118.69	119.2	9128400.0
2015-05-14	AAXJ	ETF	67.26	67.5	67.11	67.44	485700.0
2015-05-14	ACTX	ETF	2.36	2.95	2.36	2.36	901.0
2015-05-14	ACWF	ETF	25.74	25.75	25.38	25.38	500.0
2015-05-14	ACWI	ETF	62.56	62.81	62.49	62.79	1947300.0
2015-05-14	ACWV	ETF	73.3	73.67	73.28	73.59	117500.0
2015-05-14	ACWX	ETF	47.55	47.64	47.42	47.61	521231.0
2015-05-14	ADRE	ETF	37.12	37.32	37.05	37.2101	7146.0
2015-05-14	AFK	ETF	26.95	26.95	26.781	26.8	12811.0
2015-05-14	AFTY	ETF	22.09	22.1	22.02	22.08	16100.0
2015-05-14	AGG	ETF	109.65	109.79	109.58	109.74	1796900.0
2015-05-14	AGQ	ETF	45.41	46.06	44.93	45.2	375100.0
2015-05-14	AGZ	ETF	113.13	113.29	113.1	113.18	13811.0
2015-05-14	AGZD	ETF	24.51	24.51	24.44	24.465	8200.0
2015-05-14	AIA	ETF	52.76	52.979	52.72	52.91	40182.0
2015-05-14	AIQ	ETF	21.0	21.16	20.85	21.0	14725.0
2015-05-14	AIRR	ETF	18.3	18.41	18.29	18.36	5300.0
2015-05-14	AIVI	ETF	47.03	47.14	46.96	47.11	15500.0
2015-05-14	AMJ	ETF	45.25	45.31	45.01	45.2	1120075.0
2015-05-14	AMLP	ETF	84.5	84.75	84.4	84.45	597740.0
2015-05-14	AMZA	ETF	224.9	225.3	224.0	224.0	2840.0
2015-05-14	ANGL	ETF	27.59	27.61	27.46	27.59	4700.0
2015-05-14	AOA	ETF	48.78	48.94	48.7	48.91	24100.0
2015-05-14	AOK	ETF	33.02	33.09	32.93	33.08	40263.0
2015-05-14	AOM	ETF	35.78	35.96	35.76	35.96	98843.0
2015-05-14	AOR	ETF	41.5799	41.65	41.47	41.65	50735.0
2015-05-14	ARGT	ETF	22.2	22.42	22.16	22.35	16200.0
2015-05-14	ARKG	ETF	22.8	22.84	22.6	22.835	1900.0
2015-05-14	ARKK	ETF	21.18	21.18	21.18	21.18	200.0
2015-05-14	ARKQ	ETF	19.99	19.99	19.99	19.99	200.0
2015-05-14	ARKW	ETF	22.9	22.9	22.74	22.74	900.0
2015-05-14	ASEA	ETF	16.03	16.12	16.03	16.09	8000.0
2015-05-14	ASHR	ETF	48.24	48.65	48.12	48.65	1117800.0
2015-05-14	ASHS	ETF	57.87	58.07	57.6	58.0	68700.0
2015-05-14	ATMP	ETF	30.6	30.61	30.51	30.55	31700.0
2015-05-14	AWAY	ETF	27.2	27.95	27.01	27.91	1313885.0
2015-05-14	BAB	ETF	29.02	29.23	29.02	29.07	148148.0
2015-05-14	BAL	ETF	44.98	45.35	44.7	45.0801	3822.0
2015-05-14	BALT	ETF	1.45	1.52	1.45	1.52	350409.0
2015-05-14	BAR	ETF	2.862	2.9	2.857	2.8887	49460.0
2015-05-14	BBC	ETF	32.93	33.42	32.19	33.14	13100.0
2015-05-14	BBH	ETF	130.86	131.92	129.38	131.89	84000.0
2015-05-14	BBP	ETF	31.83	31.83	31.452	31.621	6500.0
2015-05-14	BCM	ETF	32.62	32.7499	32.61	32.7499	13964.0
2015-05-14	BFOR	ETF	8.3575	8.4025	8.3525	8.4	32800.0

> showing 50 of 1,178 rows — these rows as CSV

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