PREVIEW / etf_daily / 2015-01-09

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-09.parquet
  size:    47 KB
  rows:    1,159

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-01-09	SPY	ETF	206.4	206.42	203.51	204.25	158567300.0
2015-01-09	QQQ	ETF	103.62	103.65	102.02	102.62	41410071.0
2015-01-09	IWM	ETF	118.81	118.84	117.31	117.57	26975200.0
2015-01-09	DIA	ETF	178.98	179.06	176.63	177.22	6646600.0
2015-01-09	GLD	ETF	116.51	117.34	116.5	117.26	7962900.0
2015-01-09	TLT	ETF	129.2	131.11	129.04	131.07	9398800.0
2015-01-09	AAXJ	ETF	61.49	61.61	61.17	61.36	2575700.0
2015-01-09	ACWI	ETF	58.4	58.4	57.69	57.9	3150200.0
2015-01-09	ACWV	ETF	69.61	69.61	68.98	69.23	101900.0
2015-01-09	ACWX	ETF	42.46	42.49	42.0701	42.25	1064691.0
2015-01-09	ADRE	ETF	35.81	35.87	35.52	35.69	21258.0
2015-01-09	AFK	ETF	25.9	25.9	25.6324	25.71	14895.0
2015-01-09	AGG	ETF	110.89	111.14	110.73	111.03	1322600.0
2015-01-09	AGQ	ETF	41.47	42.44	41.24	41.66	124700.0
2015-01-09	AGZ	ETF	114.0	114.5199	113.6201	114.16	49676.0
2015-01-09	AGZD	ETF	24.58	24.59	24.5	24.5	5800.0
2015-01-09	AIA	ETF	47.6	47.6	47.22	47.39	19748.0
2015-01-09	AIQ	ETF	20.72	20.87	19.76	19.96	17200.0
2015-01-09	AIRR	ETF	17.75	17.86	17.52	17.52	5400.0
2015-01-09	AIVI	ETF	42.51	42.51	42.08	42.24	25900.0
2015-01-09	AMJ	ETF	44.5	44.5699	43.83	44.37	1047189.0
2015-01-09	AMLP	ETF	85.35	85.55	84.6	85.25	1065940.0
2015-01-09	AMZA	ETF	215.9	215.9	209.1	211.54	450.0
2015-01-09	ANGL	ETF	26.47	26.49	26.26	26.26	6200.0
2015-01-09	AOA	ETF	46.4	46.4	45.96	46.08	46700.0
2015-01-09	AOK	ETF	32.72	32.72	32.55	32.5732	30111.0
2015-01-09	AOM	ETF	35.11	35.15	35.01	35.09	61045.0
2015-01-09	AOR	ETF	40.27	40.27	39.8801	39.96	50104.0
2015-01-09	ARGT	ETF	18.36	18.36	18.1	18.21	7100.0
2015-01-09	ARKG	ETF	21.91	21.91	21.58	21.73	2700.0
2015-01-09	ARKK	ETF	20.1	20.1	19.94	19.97	1100.0
2015-01-09	ARKQ	ETF	19.05	19.05	19.05	19.05	100.0
2015-01-09	ARKW	ETF	20.5	20.5	20.38	20.41	700.0
2015-01-09	ASEA	ETF	15.5	15.51	15.44	15.51	3800.0
2015-01-09	ASHR	ETF	36.81	37.04	36.51	36.96	1276900.0
2015-01-09	ASHS	ETF	35.73	35.73	35.48	35.54	3600.0
2015-01-09	ATMP	ETF	29.29	29.46	29.17	29.4	86900.0
2015-01-09	AVIV	ETF	37.48	37.69	37.14	37.2	205953.0
2015-01-09	AWAY	ETF	28.0	28.12	27.04	27.14	2077820.0
2015-01-09	BAB	ETF	30.94	30.94	30.59	30.71	262221.0
2015-01-09	BAL	ETF	41.22	41.4499	41.1828	41.34	2531.0
2015-01-09	BALT	ETF	2.34	2.35	2.03	2.11	1229962.0
2015-01-09	BAR	ETF	2.963	2.967	2.92	2.936	18450.0
2015-01-09	BBC	ETF	29.06	29.49	28.8	29.3124	15711.0
2015-01-09	BBH	ETF	120.07	120.07	117.77	118.57	106900.0
2015-01-09	BBP	ETF	28.25	28.25	27.45	27.67	13400.0
2015-01-09	BCHP	ETF	17.815	17.82	17.74	17.78	2217.0
2015-01-09	BFOR	ETF	7.84	7.84	7.75	7.7775	52400.0
2015-01-09	BIB	ETF	67.975	68.0	65.406	66.69	799272.0
2015-01-09	BICK	ETF	23.67	23.71	23.5812	23.5812	2035.0

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

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