PREVIEW / etf_daily / 2018-12-11

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-11.parquet
  size:    66 KB
  rows:    1,715

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-11	SPY	ETF	267.66	267.87	262.48	264.13	121504400.0
2018-12-11	QQQ	ETF	165.66	165.77	162.23	163.61	59058296.0
2018-12-11	IWM	ETF	145.68	146.19	142.39	143.45	29229300.0
2018-12-11	DIA	ETF	248.44	248.5	242.66	244.23	5646500.0
2018-12-11	GLD	ETF	117.67	117.89	117.35	117.54	6395400.0
2018-12-11	TLT	ETF	118.97	119.38	118.61	118.88	8071900.0
2018-12-11	AAAU	ETF	12.44	12.44	12.42	12.42	5600.0
2018-12-11	AADR	ETF	43.25	43.34	42.49	42.8	139200.0
2018-12-11	AAXJ	ETF	65.21	65.22	64.39	64.85	1344100.0
2018-12-11	ACES	ETF	24.724	24.741	24.67	24.723	4600.0
2018-12-11	ACSI	ETF	31.7379	31.7383	31.3864	31.3864	1354.0
2018-12-11	ACTX	ETF	57.5255	61.9506	57.5255	60.1805	375.0
2018-12-11	ACWF	ETF	27.52	27.52	27.0618	27.2	16866.0
2018-12-11	ACWI	ETF	67.69	67.85	66.68	67.03	12914300.0
2018-12-11	ACWV	ETF	85.43	85.61	84.55	84.92	606200.0
2018-12-11	ACWX	ETF	43.24	43.25	42.68	42.93	9498985.0
2018-12-11	ADRE	ETF	37.49	37.49	36.856	37.1094	6074.0
2018-12-11	AFIF	ETF	9.32	9.98	9.32	9.97	21741.0
2018-12-11	AFK	ETF	20.1	20.11	19.95	19.9504	2163.0
2018-12-11	AFTY	ETF	14.2	14.28	14.16	14.16	1700.0
2018-12-11	AGG	ETF	105.63	105.72	105.51	105.58	8086200.0
2018-12-11	AGGY	ETF	47.91	47.95	47.83	47.867	206200.0
2018-12-11	AGNG	ETF	19.792	19.792	19.792	19.792	100.0
2018-12-11	AGQ	ETF	23.81	24.0	23.38	23.5	103200.0
2018-12-11	AGZ	ETF	111.32	111.448	111.26	111.3728	19837.0
2018-12-11	AGZD	ETF	23.745	23.92	23.715	23.825	50200.0
2018-12-11	AIA	ETF	56.71	56.79	56.0551	56.48	67186.0
2018-12-11	AIEQ	ETF	25.61	25.68	25.086	25.2	36500.0
2018-12-11	AIQ	ETF	13.92	13.95	13.705	13.86	26375.0
2018-12-11	AIRR	ETF	23.23	23.34	22.72	22.83	60500.0
2018-12-11	AIVI	ETF	39.02	39.03	38.55	38.73	11500.0
2018-12-11	ALTY	ETF	14.39	14.39	14.12	14.12	4300.0
2018-12-11	AMJ	ETF	24.08	24.23	23.845	23.94	6513824.0
2018-12-11	AMLP	ETF	47.1	47.3	46.45	46.75	6746520.0
2018-12-11	AMUB	ETF	15.0372	15.0372	15.0372	15.0372	0.0
2018-12-11	AMZA	ETF	59.8	60.0	58.4	58.8	92710.0
2018-12-11	ANGL	ETF	27.36	27.44	27.33	27.33	238600.0
2018-12-11	AOA	ETF	50.75	50.75	49.92	50.13	190100.0
2018-12-11	AOK	ETF	33.18	33.18	33.0087	33.04	1367538.0
2018-12-11	AOM	ETF	36.41	36.43	36.171	36.23	1868426.0
2018-12-11	AOR	ETF	42.55	42.57	42.1334	42.25	577037.0
2018-12-11	ARGT	ETF	25.33	25.58	25.06	25.23	76600.0
2018-12-11	ARKG	ETF	28.47	28.53	27.86	28.2	157300.0
2018-12-11	ARKK	ETF	43.3	43.3	42.09	42.46	309600.0
2018-12-11	ARKQ	ETF	32.19	32.51	31.78	32.06	58400.0
2018-12-11	ARKW	ETF	53.02	53.33	51.613	52.05	69500.0
2018-12-11	ARVR	ETF	17.1353	17.205	17.1353	17.205	250.0
2018-12-11	ASEA	ETF	15.64	15.68	15.64	15.68	300.0
2018-12-11	ASET	ETF	27.0	27.01	26.75	26.95	3644.0
2018-12-11	ASHR	ETF	23.08	23.1	22.88	23.07	1934400.0

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

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