PREVIEW / etf_daily / 2015-06-09

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-09.parquet
  size:    48 KB
  rows:    1,187

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-06-09	SPY	ETF	208.45	209.1	207.69	208.45	105034700.0
2015-06-09	QQQ	ETF	107.93	108.4	107.2	108.01	27554599.0
2015-06-09	IWM	ETF	124.71	124.86	123.5	124.44	23928300.0
2015-06-09	DIA	ETF	177.82	178.26	177.2	177.71	4722400.0
2015-06-09	GLD	ETF	113.15	113.23	112.71	112.82	3529900.0
2015-06-09	TLT	ETF	117.06	117.13	116.11	116.54	12393900.0
2015-06-09	AADR	ETF	39.53	39.53	39.32	39.32	1500.0
2015-06-09	AAXJ	ETF	64.17	64.24	63.94	64.03	743300.0
2015-06-09	ACTX	ETF	4.13	4.13	2.95	4.13	745.0
2015-06-09	ACWF	ETF	24.64	24.68	24.64	24.68	1000.0
2015-06-09	ACWI	ETF	60.71	60.81	60.45	60.66	550500.0
2015-06-09	ACWV	ETF	70.5	70.73	70.33	70.44	100800.0
2015-06-09	ACWX	ETF	45.3	45.3707	45.0994	45.23	414142.0
2015-06-09	ADRE	ETF	35.22	35.26	35.1501	35.1501	2626.0
2015-06-09	AFK	ETF	25.12	25.37	24.9	24.9	49856.0
2015-06-09	AFTY	ETF	23.69	24.01	23.69	23.897	43700.0
2015-06-09	AGG	ETF	108.65	108.65	108.32	108.4	1206700.0
2015-06-09	AGQ	ETF	38.33	38.44	37.85	37.93	135800.0
2015-06-09	AGZ	ETF	112.74	112.83	112.68	112.71	30000.0
2015-06-09	AGZD	ETF	24.35	24.475	24.35	24.455	9400.0
2015-06-09	AIA	ETF	51.05	51.125	50.8	51.08	17521.0
2015-06-09	AIQ	ETF	18.3491	18.37	18.05	18.3	15947.0
2015-06-09	AIRR	ETF	18.51	18.51	18.37	18.38	4100.0
2015-06-09	AIVI	ETF	44.36	44.36	44.0	44.2	25500.0
2015-06-09	ALTL	ETF	36.49	36.49	36.49	36.49	180.0
2015-06-09	AMJ	ETF	41.91	42.16	41.79	41.82	1734346.0
2015-06-09	AMLP	ETF	81.15	81.3	80.85	80.85	584040.0
2015-06-09	AMZA	ETF	207.0	207.49	206.9	206.9	1590.0
2015-06-09	ANGL	ETF	27.54	27.6	27.35	27.42	26100.0
2015-06-09	AOA	ETF	47.69	47.69	47.4	47.54	29600.0
2015-06-09	AOK	ETF	32.47	32.5	32.37	32.4699	24618.0
2015-06-09	AOM	ETF	35.39	35.39	35.14	35.25	78936.0
2015-06-09	AOR	ETF	40.73	40.74	40.56	40.65	50427.0
2015-06-09	ARGT	ETF	21.28	21.42	21.28	21.3	9800.0
2015-06-09	ARKG	ETF	23.15	23.15	23.13	23.13	400.0
2015-06-09	ARKK	ETF	21.46	21.46	21.46	21.46	300.0
2015-06-09	ARKQ	ETF	20.09	20.09	20.04	20.05	1700.0
2015-06-09	ARKW	ETF	23.0	23.15	23.0	23.15	500.0
2015-06-09	ASEA	ETF	14.91	15.0	14.91	14.95	12000.0
2015-06-09	ASHR	ETF	53.85	53.94	53.27	53.7	3679300.0
2015-06-09	ASHS	ETF	71.33	71.37	70.42	70.85	138000.0
2015-06-09	ATMP	ETF	28.51	28.51	28.38	28.42	18600.0
2015-06-09	AWAY	ETF	30.59	30.78	29.58	29.91	1183419.0
2015-06-09	BAB	ETF	28.8	28.94	28.76	28.8	111210.0
2015-06-09	BAL	ETF	43.971	44.34	43.93	44.08	2928.0
2015-06-09	BALT	ETF	1.48	1.51	1.47	1.5	250825.0
2015-06-09	BAR	ETF	2.567	2.567	2.551	2.56	5090.0
2015-06-09	BBC	ETF	36.65	36.65	35.3	35.9524	16115.0
2015-06-09	BBH	ETF	132.86	132.86	130.75	131.81	108600.0
2015-06-09	BBP	ETF	33.91	34.42	33.221	33.65	31100.0

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

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