PREVIEW / etf_daily / 2017-10-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-06.parquet
  size:    57 KB
  rows:    1,463

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
2017-10-06	SPY	ETF	254.15	254.7	253.85	254.37	80646000.0
2017-10-06	QQQ	ETF	146.97	147.66	146.96	147.66	23561069.0
2017-10-06	IWM	ETF	149.71	150.34	149.57	150.05	19350800.0
2017-10-06	DIA	ETF	227.34	227.63	227.23	227.55	2090300.0
2017-10-06	GLD	ETF	120.26	121.21	119.78	121.09	10013300.0
2017-10-06	TLT	ETF	123.29	124.1	123.03	123.59	10375000.0
2017-10-06	AADR	ETF	56.41	56.71	56.35	56.71	19900.0
2017-10-06	AAXJ	ETF	73.47	73.65	73.22	73.56	2092100.0
2017-10-06	ACSI	ETF	29.51	29.52	29.45	29.52	1513.0
2017-10-06	ACTX	ETF	61.0655	63.1306	56.0505	59.0005	181.0
2017-10-06	ACWF	ETF	29.3596	29.409	29.3596	29.37	1268.0
2017-10-06	ACWI	ETF	69.21	69.4	69.19	69.4	1034100.0
2017-10-06	ACWV	ETF	81.61	81.75	81.5	81.75	328300.0
2017-10-06	ACWX	ETF	48.34	48.54	48.293	48.54	128033.0
2017-10-06	ADRE	ETF	42.68	42.6902	42.5705	42.65	5292.0
2017-10-06	AFK	ETF	23.5	23.5152	23.48	23.5	2983.0
2017-10-06	AFTY	ETF	17.25	17.25	17.25	17.25	200.0
2017-10-06	AGG	ETF	109.22	109.42	109.15	109.28	1824000.0
2017-10-06	AGGY	ETF	50.61	50.72	50.61	50.68	16800.0
2017-10-06	AGNG	ETF	19.55	19.634	19.55	19.611	5400.0
2017-10-06	AGQ	ETF	32.8	33.97	31.88	33.65	242500.0
2017-10-06	AGZ	ETF	113.328	113.474	113.328	113.4215	9702.0
2017-10-06	AGZD	ETF	24.055	24.055	24.01	24.01	2600.0
2017-10-06	AIA	ETF	62.58	62.8	62.45	62.79	34871.0
2017-10-06	AIRR	ETF	26.29	26.33	26.222	26.32	800300.0
2017-10-06	AIVI	ETF	42.12	42.27	42.1	42.27	12300.0
2017-10-06	ALTY	ETF	15.77	15.77	15.71	15.715	10300.0
2017-10-06	AMJ	ETF	28.6	28.68	28.3808	28.68	2015156.0
2017-10-06	AMLP	ETF	56.8	57.1	56.4	57.0	1302300.0
2017-10-06	AMZA	ETF	89.4	89.9	88.9	89.7	82740.0
2017-10-06	ANGL	ETF	30.21	30.22	30.16	30.21	352600.0
2017-10-06	AOA	ETF	53.69	53.78	53.65	53.78	52600.0
2017-10-06	AOK	ETF	34.4	34.5	34.39	34.44	57881.0
2017-10-06	AOM	ETF	37.92	37.94	37.85	37.87	122370.0
2017-10-06	AOR	ETF	44.83	44.89	44.76	44.89	71258.0
2017-10-06	ARGT	ETF	32.33	32.74	32.3	32.37	145100.0
2017-10-06	ARKG	ETF	26.8	27.01	26.67	26.89	29100.0
2017-10-06	ARKK	ETF	35.12	35.19	34.89	35.02	114000.0
2017-10-06	ARKQ	ETF	32.62	32.629	32.431	32.596	26900.0
2017-10-06	ARKW	ETF	41.49	41.658	41.37	41.63	33300.0
2017-10-06	ASEA	ETF	15.7	15.73	15.7	15.73	1500.0
2017-10-06	ASET	ETF	28.009	28.03	28.009	28.03	1148.0
2017-10-06	ASHR	ETF	29.84	30.02	29.75	29.96	494900.0
2017-10-06	ASHS	ETF	37.28	37.35	37.23	37.35	3900.0
2017-10-06	ASHX	ETF	22.2048	22.2481	22.2048	22.2481	450.0
2017-10-06	ATMP	ETF	21.63	21.64	21.47	21.63	9700.0
2017-10-06	BAB	ETF	30.29	30.37	30.23	30.34	61706.0
2017-10-06	BAL	ETF	45.0	45.4899	44.7128	45.39	3302.0
2017-10-06	BAR	ETF	12.635	12.741	12.635	12.741	80520.0
2017-10-06	BBC	ETF	29.78	29.9549	29.5209	29.605	8274.0

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

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