PREVIEW / etf_daily / 2018-12-14

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-14.parquet
  size:    67 KB
  rows:    1,727

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
2018-12-14	SPY	ETF	262.96	264.03	259.85	260.47	116961100.0
2018-12-14	QQQ	ETF	163.19	163.81	160.7	161.08	56547419.0
2018-12-14	IWM	ETF	141.73	143.23	140.1	140.61	24037200.0
2018-12-14	DIA	ETF	244.06	244.83	240.82	241.42	6591200.0
2018-12-14	GLD	ETF	116.63	117.3	116.58	117.06	7501700.0
2018-12-14	TLT	ETF	118.55	118.77	118.22	118.48	8169200.0
2018-12-14	AAAU	ETF	12.34	12.39	12.32	12.38	4700.0
2018-12-14	AADR	ETF	42.79	42.88	41.77	42.46	24700.0
2018-12-14	AAXJ	ETF	65.03	65.52	64.97	65.12	1601800.0
2018-12-14	ACES	ETF	24.67	24.74	24.391	24.391	3300.0
2018-12-14	ACSI	ETF	31.1	31.1	30.7904	30.7904	1519.0
2018-12-14	ACTX	ETF	59.5905	61.3606	56.6405	59.5905	362.0
2018-12-14	ACWF	ETF	27.335	27.335	27.01	27.0499	58354.0
2018-12-14	ACWI	ETF	67.0	67.25	66.49	66.59	5837000.0
2018-12-14	ACWV	ETF	84.83	84.88	84.2	84.31	274700.0
2018-12-14	ACWX	ETF	43.02	43.21	42.905	42.95	6429232.0
2018-12-14	ADRE	ETF	37.0955	37.4499	37.0955	37.2	5382.0
2018-12-14	AFIF	ETF	9.96	9.9659	9.94	9.95	24631.0
2018-12-14	AFK	ETF	20.061	20.1999	19.982	20.0278	2706.0
2018-12-14	AFTY	ETF	13.99	14.01	13.951	13.973	5600.0
2018-12-14	AGG	ETF	105.68	105.68	105.56	105.56	6265000.0
2018-12-14	AGGY	ETF	47.9	47.97	47.88	47.88	32200.0
2018-12-14	AGNG	ETF	19.939	19.939	19.68	19.68	900.0
2018-12-14	AGQ	ETF	23.35	23.68	23.27	23.55	106300.0
2018-12-14	AGZ	ETF	111.23	111.36	111.23	111.31	21636.0
2018-12-14	AGZD	ETF	23.78	23.835	23.755	23.755	42600.0
2018-12-14	AIA	ETF	56.41	56.65	56.22	56.32	79402.0
2018-12-14	AIEQ	ETF	24.99	25.13	24.71	24.73	46900.0
2018-12-14	AIQ	ETF	13.75	13.83	13.65	13.663	17034.0
2018-12-14	AIRR	ETF	22.64	22.89	22.45	22.53	42700.0
2018-12-14	AIVI	ETF	38.87	38.99	38.8	38.8	17600.0
2018-12-14	ALTY	ETF	14.05	14.16	14.05	14.08	4700.0
2018-12-14	AMJ	ETF	24.38	24.73	24.23	24.3	2197395.0
2018-12-14	AMLP	ETF	47.85	48.55	47.5	47.5	5722840.0
2018-12-14	AMUB	ETF	15.2666	15.2666	15.2666	15.2666	0.0
2018-12-14	AMZA	ETF	60.3	60.7	59.0	59.1	63590.0
2018-12-14	ANGL	ETF	27.43	27.54	27.39	27.42	119800.0
2018-12-14	AOA	ETF	50.11	50.25	49.82	49.89	184400.0
2018-12-14	AOK	ETF	33.01	33.1469	32.97	32.97	177426.0
2018-12-14	AOM	ETF	36.26	36.29	36.11	36.17	603618.0
2018-12-14	AOR	ETF	42.26	42.34	42.0701	42.12	689421.0
2018-12-14	ARCM	ETF	99.815	99.815	99.815	99.815	100.0
2018-12-14	ARGT	ETF	24.6	24.86	24.6	24.6	54100.0
2018-12-14	ARKG	ETF	27.48	27.96	27.1	27.25	214300.0
2018-12-14	ARKK	ETF	41.98	42.662	41.55	41.77	222000.0
2018-12-14	ARKQ	ETF	31.76	32.15	31.68	31.78	15500.0
2018-12-14	ARKW	ETF	51.59	52.363	51.18	51.33	44100.0
2018-12-14	ARVR	ETF	16.77	17.045	16.77	17.045	687.0
2018-12-14	ASEA	ETF	15.83	15.85	15.7	15.82	11500.0
2018-12-14	ASET	ETF	26.7461	26.7461	26.6597	26.6597	906.0

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

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