PREVIEW / etf_daily / 2015-09-21

all etf daily files

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

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-09-21	SPY	ETF	196.44	197.68	195.21	196.46	105726200.0
2015-09-21	QQQ	ETF	105.93	106.55	104.73	105.68	35772624.0
2015-09-21	IWM	ETF	116.54	117.3	115.08	115.51	33021700.0
2015-09-21	DIA	ETF	164.67	165.56	163.67	164.9	7762600.0
2015-09-21	GLD	ETF	108.49	108.66	108.33	108.53	4104800.0
2015-09-21	TLT	ETF	121.01	121.11	119.78	120.11	10085600.0
2015-09-21	AAXJ	ETF	54.3	54.36	53.94	54.12	1892800.0
2015-09-21	ACTX	ETF	4.72	4.72	4.071	4.72	948.0
2015-09-21	ACWI	ETF	55.55	55.71	55.11	55.41	784300.0
2015-09-21	ACWV	ETF	67.71	68.04	67.51	67.64	46800.0
2015-09-21	ACWX	ETF	40.33	40.36	39.99	40.16	410629.0
2015-09-21	ADRE	ETF	28.83	28.89	28.68	28.75	5762.0
2015-09-21	AFK	ETF	20.38	20.416	20.25	20.25	4280.0
2015-09-21	AFTY	ETF	14.95	15.32	14.95	15.22	47200.0
2015-09-21	AGG	ETF	109.17	109.17	108.88	108.99	2325800.0
2015-09-21	AGGY	ETF	49.66	49.66	49.64	49.66	1400.0
2015-09-21	AGQ	ETF	33.4	33.68	33.33	33.39	111900.0
2015-09-21	AGZ	ETF	113.5	113.67	113.3501	113.49	17671.0
2015-09-21	AGZD	ETF	24.05	24.055	24.05	24.055	1200.0
2015-09-21	AIA	ETF	42.95	43.11	42.87	42.94	45314.0
2015-09-21	AIQ	ETF	11.91	12.2	11.5	11.53	97364.0
2015-09-21	AIRR	ETF	16.25	16.362	16.15	16.2	37600.0
2015-09-21	AIVI	ETF	39.3	39.39	39.0	39.15	13100.0
2015-09-21	AMJ	ETF	33.6	33.85	33.4	33.7	2200799.0
2015-09-21	AMLP	ETF	69.55	69.85	68.9	69.7	776560.0
2015-09-21	AMZA	ETF	157.45	162.4	152.6	156.7	660.0
2015-09-21	ANGL	ETF	26.39	26.39	26.35	26.37	10800.0
2015-09-21	AOA	ETF	44.55	44.72	44.38	44.52	35000.0
2015-09-21	AOK	ETF	31.77	31.77	31.64	31.73	24278.0
2015-09-21	AOM	ETF	34.24	34.26	34.0633	34.09	71402.0
2015-09-21	AOR	ETF	38.79	38.8399	38.59	38.72	43878.0
2015-09-21	ARGT	ETF	17.51	17.51	17.07	17.09	34700.0
2015-09-21	ARKG	ETF	21.9	21.96	21.8	21.8	1100.0
2015-09-21	ARKK	ETF	20.3	20.3	20.3	20.3	2400.0
2015-09-21	ARKQ	ETF	18.395	18.395	18.395	18.395	300.0
2015-09-21	ARKW	ETF	22.5	22.5	22.3	22.3	3600.0
2015-09-21	ASEA	ETF	12.63	12.63	12.62	12.62	500.0
2015-09-21	ASHR	ETF	32.8	33.1	32.79	32.97	1938600.0
2015-09-21	ASHS	ETF	36.33	36.94	36.33	36.58	81200.0
2015-09-21	ATMP	ETF	22.72	23.04	22.71	23.02	116100.0
2015-09-21	AWAY	ETF	28.85	28.85	27.855	28.0	803154.0
2015-09-21	BAB	ETF	28.79	28.82	28.63	28.71	139211.0
2015-09-21	BAL	ETF	40.12	40.46	40.1	40.3599	6977.0
2015-09-21	BBC	ETF	35.58	35.58	32.7401	33.01	14831.0
2015-09-21	BBH	ETF	132.01	132.01	125.08	126.22	365900.0
2015-09-21	BBP	ETF	33.67	33.67	31.33	31.701	25900.0
2015-09-21	BCHP	ETF	17.8305	17.8305	17.69	17.74	5791.0
2015-09-21	BCM	ETF	26.92	27.017	26.92	26.95	22548.0
2015-09-21	BFOR	ETF	7.725	7.7975	7.7	7.71	87600.0
2015-09-21	BIB	ETF	83.5	83.54	73.4	74.99	1862948.0

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

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