PREVIEW / etf_daily / 2015-06-22

all etf daily files

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

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-22	SPY	ETF	211.91	212.59	211.64	211.89	70696000.0
2015-06-22	QQQ	ETF	110.7	111.03	110.45	110.7	19120898.0
2015-06-22	IWM	ETF	128.42	128.84	128.15	128.74	25230000.0
2015-06-22	DIA	ETF	181.03	181.5	180.67	180.92	4048300.0
2015-06-22	GLD	ETF	113.79	113.94	113.34	113.64	5763700.0
2015-06-22	TLT	ETF	117.84	118.14	116.59	116.65	9769000.0
2015-06-22	AAXJ	ETF	64.89	65.12	64.81	64.9	464800.0
2015-06-22	ACTX	ETF	2.36	2.36	1.77	2.36	3510.0
2015-06-22	ACWF	ETF	25.3899	25.4	25.3438	25.38	4332.0
2015-06-22	ACWI	ETF	62.09	62.39	62.08	62.16	1040400.0
2015-06-22	ACWV	ETF	71.96	72.18	71.89	71.96	63000.0
2015-06-22	ACWX	ETF	46.49	46.68	46.4153	46.47	147034.0
2015-06-22	ADRE	ETF	35.91	35.9899	35.8779	35.8779	8441.0
2015-06-22	AFK	ETF	25.05	25.0699	24.87	24.96	28719.0
2015-06-22	AFTY	ETF	21.0	21.05	20.87	20.87	25200.0
2015-06-22	AGG	ETF	108.95	109.0	108.64	108.67	1173800.0
2015-06-22	AGQ	ETF	38.17	39.17	38.14	38.85	239000.0
2015-06-22	AGZ	ETF	113.98	113.98	113.021	113.17	27238.0
2015-06-22	AGZD	ETF	24.39	24.39	24.28	24.28	6200.0
2015-06-22	AIA	ETF	51.73	51.9	51.704	51.7693	25477.0
2015-06-22	AIQ	ETF	20.28	20.28	19.48	19.56	25937.0
2015-06-22	AIRR	ETF	18.82	18.85	18.78	18.83	11500.0
2015-06-22	AIVI	ETF	44.63	44.87	44.51	44.61	129400.0
2015-06-22	AMJ	ETF	41.61	41.84	41.41	41.51	1056501.0
2015-06-22	AMLP	ETF	81.15	81.3	80.4	80.6	1293060.0
2015-06-22	AMZA	ETF	208.2	208.25	206.7	207.6	950.0
2015-06-22	ANGL	ETF	27.6	27.6	27.28	27.33	25600.0
2015-06-22	AOA	ETF	48.5	48.71	48.49	48.6	45000.0
2015-06-22	AOK	ETF	32.84	32.8599	32.7101	32.8	31807.0
2015-06-22	AOM	ETF	35.55	35.77	35.55	35.709	65800.0
2015-06-22	AOR	ETF	41.38	41.4	41.3003	41.32	60878.0
2015-06-22	ARGT	ETF	20.54	20.92	20.51	20.8	8700.0
2015-06-22	ARKG	ETF	23.9	24.01	23.89	24.01	700.0
2015-06-22	ARKK	ETF	22.05	22.05	22.05	22.05	200.0
2015-06-22	ARKQ	ETF	20.467	20.51	20.467	20.51	300.0
2015-06-22	ARKW	ETF	24.04	24.04	24.04	24.04	1000.0
2015-06-22	ASEA	ETF	15.34	15.34	15.25	15.28	5600.0
2015-06-22	ASHR	ETF	48.5	49.08	48.5	48.61	3013100.0
2015-06-22	ASHS	ETF	64.85	66.27	64.85	66.14	171600.0
2015-06-22	ATMP	ETF	28.57	28.57	28.44	28.54	14700.0
2015-06-22	AWAY	ETF	31.25	31.57	30.88	31.06	745010.0
2015-06-22	BAB	ETF	28.93	28.93	28.73	28.75	63635.0
2015-06-22	BAL	ETF	42.81	43.45	42.73	43.41	3790.0
2015-06-22	BALT	ETF	1.56	1.57	1.5	1.56	1074232.0
2015-06-22	BBC	ETF	36.59	37.49	36.59	37.4201	28149.0
2015-06-22	BBH	ETF	139.92	140.92	139.48	140.62	178700.0
2015-06-22	BBP	ETF	36.45	36.8	35.7	36.44	73300.0
2015-06-22	BCM	ETF	31.04	31.24	31.03	31.16	12777.0
2015-06-22	BFOR	ETF	8.5375	8.5525	8.525	8.5525	37200.0
2015-06-22	BIB	ETF	96.0	97.62	95.54	97.5	765264.0

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

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