PREVIEW / etf_daily / 2017-09-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-05.parquet
  size:    57 KB
  rows:    1,451

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-09-05	SPY	ETF	247.26	247.52	244.95	246.06	91398800.0
2017-09-05	QQQ	ETF	145.55	145.88	143.6	144.69	45480562.0
2017-09-05	IWM	ETF	140.63	140.89	138.58	139.17	21908400.0
2017-09-05	DIA	ETF	219.53	219.53	217.18	217.67	3828600.0
2017-09-05	GLD	ETF	126.65	127.78	126.57	127.46	11813100.0
2017-09-05	TLT	ETF	127.69	128.8	127.69	128.76	15215700.0
2017-09-05	AADR	ETF	53.15	53.15	52.48	52.73	32100.0
2017-09-05	AAXJ	ETF	71.71	71.88	71.15	71.41	1022200.0
2017-09-05	ACSI	ETF	28.78	28.78	28.65	28.69	14045.0
2017-09-05	ACTX	ETF	73.7507	76.7007	72.5707	72.5707	341.0
2017-09-05	ACWF	ETF	28.21	28.22	28.01	28.0662	2573.0
2017-09-05	ACWI	ETF	67.48	67.59	66.94	67.19	4411300.0
2017-09-05	ACWV	ETF	81.01	81.07	80.64	80.85	659900.0
2017-09-05	ACWX	ETF	47.43	47.45	47.0	47.17	258176.0
2017-09-05	ADRE	ETF	42.58	42.6099	42.0309	42.13	19818.0
2017-09-05	AFK	ETF	24.1	24.2235	23.86	24.2235	11591.0
2017-09-05	AFTY	ETF	17.357	17.37	17.34	17.36	9100.0
2017-09-05	AGG	ETF	110.27	110.5	110.21	110.42	2257000.0
2017-09-05	AGGY	ETF	51.0	51.13	50.988	51.13	9600.0
2017-09-05	AGNG	ETF	19.36	19.36	19.22	19.22	15000.0
2017-09-05	AGQ	ETF	38.58	38.99	38.2	38.48	229800.0
2017-09-05	AGZ	ETF	114.3	114.43	114.266	114.43	87872.0
2017-09-05	AIA	ETF	60.42	60.54	59.941	60.25	30782.0
2017-09-05	AIRR	ETF	23.94	23.94	23.571	23.631	12500.0
2017-09-05	AIVI	ETF	42.15	42.29	41.97	42.08	12500.0
2017-09-05	ALTY	ETF	15.7	15.7	15.453	15.453	15300.0
2017-09-05	AMJ	ETF	28.35	28.39	27.95	27.95	2637266.0
2017-09-05	AMLP	ETF	56.45	56.6	55.8	55.9	2266920.0
2017-09-05	AMZA	ETF	94.2	94.2	91.8	92.2	99760.0
2017-09-05	ANGL	ETF	29.93	30.0	29.89	29.97	387700.0
2017-09-05	AOA	ETF	52.77	52.77	52.35	52.53	65500.0
2017-09-05	AOK	ETF	34.36	34.41	34.3085	34.3608	582063.0
2017-09-05	AOM	ETF	37.72	37.76	37.62	37.7	57362.0
2017-09-05	AOR	ETF	44.26	44.33	44.0797	44.2	118551.0
2017-09-05	ARCM	ETF	100.5	100.5	100.5	100.5	340.0
2017-09-05	ARGT	ETF	29.96	30.5	29.96	30.39	53800.0
2017-09-05	ARKG	ETF	25.09	25.305	24.755	25.16	53600.0
2017-09-05	ARKK	ETF	33.51	33.555	32.95	33.43	113500.0
2017-09-05	ARKQ	ETF	30.08	30.2	29.807	30.023	20300.0
2017-09-05	ARKW	ETF	40.0	40.089	39.54	39.92	105900.0
2017-09-05	ASEA	ETF	15.49	15.49	15.39	15.4	2400.0
2017-09-05	ASET	ETF	28.21	28.21	28.0032	28.025	1663.0
2017-09-05	ASHR	ETF	29.96	30.0	29.87	29.95	1215700.0
2017-09-05	ASHS	ETF	36.51	36.82	36.51	36.82	21600.0
2017-09-05	ATMP	ETF	21.53	21.54	21.28	21.33	9200.0
2017-09-05	BAB	ETF	30.67	30.84	30.61	30.82	190773.0
2017-09-05	BAL	ETF	48.76	50.2473	48.76	50.12	39815.0
2017-09-05	BAR	ETF	13.698	14.107	13.365	13.4404	34230.0
2017-09-05	BBC	ETF	27.78	28.06	27.3474	27.75	17305.0
2017-09-05	BBH	ETF	135.52	135.69	133.67	134.91	20100.0

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

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