PREVIEW / etf_daily / 2018-12-17

all etf daily files

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

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-17	SPY	ETF	259.4	260.65	253.53	255.36	165492300.0
2018-12-17	QQQ	ETF	160.41	161.67	156.17	157.43	74834076.0
2018-12-17	IWM	ETF	139.67	140.88	136.16	137.02	36468500.0
2018-12-17	DIA	ETF	240.04	241.4	235.05	236.43	7036700.0
2018-12-17	GLD	ETF	117.37	118.03	117.35	117.87	8454900.0
2018-12-17	TLT	ETF	118.59	119.3	118.58	119.17	9726800.0
2018-12-17	AAAU	ETF	12.42	12.46	12.41	12.46	3000.0
2018-12-17	AADR	ETF	42.42	42.42	41.4	41.52	33200.0
2018-12-17	AAXJ	ETF	65.08	65.31	64.22	64.47	2614800.0
2018-12-17	ACES	ETF	23.835	23.835	23.512	23.512	700.0
2018-12-17	ACSI	ETF	30.6676	30.6676	30.0	30.0979	2109.0
2018-12-17	ACTX	ETF	61.3606	61.3606	53.6905	54.8705	590.0
2018-12-17	ACWF	ETF	26.91	27.08	26.5554	26.64	145495.0
2018-12-17	ACWI	ETF	66.43	66.63	65.2	65.58	9241500.0
2018-12-17	ACWV	ETF	84.34	84.4	82.82	83.2	567200.0
2018-12-17	ACWX	ETF	42.93	42.995	42.38	42.52	6364951.0
2018-12-17	ADRE	ETF	37.26	37.26	36.39	36.4275	5458.0
2018-12-17	AFIF	ETF	10.59	10.59	9.89	9.91	13711.0
2018-12-17	AFK	ETF	20.01	20.01	19.91	19.91	2715.0
2018-12-17	AFTY	ETF	13.85	13.89	13.776	13.82	9900.0
2018-12-17	AGG	ETF	105.66	105.78	105.61	105.74	7630500.0
2018-12-17	AGGY	ETF	47.88	48.0	47.88	47.985	42900.0
2018-12-17	AGNG	ETF	19.68	19.68	19.39	19.39	1900.0
2018-12-17	AGQ	ETF	23.61	23.94	23.56	23.84	56700.0
2018-12-17	AGZ	ETF	111.29	111.47	111.29	111.4336	22305.0
2018-12-17	AGZD	ETF	23.79	23.82	23.73	23.73	65800.0
2018-12-17	AIA	ETF	56.39	56.53	55.75	55.86	229807.0
2018-12-17	AIEQ	ETF	24.58	24.727	24.02	24.12	109200.0
2018-12-17	AIQ	ETF	13.55	13.57	13.15	13.19	12156.0
2018-12-17	AIRR	ETF	22.39	22.66	22.035	22.13	45000.0
2018-12-17	AIVI	ETF	38.91	38.91	38.47	38.55	34800.0
2018-12-17	ALTY	ETF	14.034	14.034	13.58	13.58	16300.0
2018-12-17	AMJ	ETF	24.13	24.39	23.345	23.51	3377619.0
2018-12-17	AMLP	ETF	47.55	47.7	45.75	46.25	5819560.0
2018-12-17	AMUB	ETF	14.7549	14.7549	14.7549	14.7549	0.0
2018-12-17	AMZA	ETF	59.1	59.1	55.9	56.1	174590.0
2018-12-17	ANGL	ETF	27.5	27.5	27.2	27.26	312300.0
2018-12-17	AOA	ETF	49.77	49.9	49.08	49.28	623900.0
2018-12-17	AOK	ETF	33.03	33.03	32.83	32.87	418268.0
2018-12-17	AOM	ETF	36.13	36.203	35.88	35.96	1209308.0
2018-12-17	AOR	ETF	42.03	43.1805	41.6	41.75	539609.0
2018-12-17	ARGT	ETF	24.52	24.52	23.65	23.72	45100.0
2018-12-17	ARKG	ETF	27.06	27.54	26.15	26.22	104100.0
2018-12-17	ARKK	ETF	41.45	41.648	39.68	39.92	503400.0
2018-12-17	ARKQ	ETF	31.43	31.58	30.53	30.73	152900.0
2018-12-17	ARKW	ETF	51.04	51.04	48.9	49.17	195500.0
2018-12-17	ARVR	ETF	16.77	16.77	16.0201	16.625	557.0
2018-12-17	ASEA	ETF	15.44	15.55	15.44	15.55	400.0
2018-12-17	ASET	ETF	26.61	26.61	26.61	26.61	218.0
2018-12-17	ASHR	ETF	22.82	22.89	22.65	22.7	1546300.0

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

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