PREVIEW / etf_daily / 2019-12-11

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-11.parquet
  size:    73 KB
  rows:    1,905

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
2019-12-11	SPY	ETF	314.03	314.7	313.44	314.42	53429100.0
2019-12-11	QQQ	ETF	204.37	205.19	204.04	204.98	18897759.0
2019-12-11	IWM	ETF	162.88	163.08	161.95	162.56	19612200.0
2019-12-11	DIA	ETF	279.13	279.9	278.65	279.72	1921700.0
2019-12-11	GLD	ETF	138.2	139.3	138.12	138.92	6097500.0
2019-12-11	TLT	ETF	139.3	140.14	139.23	139.75	6256700.0
2019-12-11	AAAU	ETF	14.64	14.75	14.63	14.71	28200.0
2019-12-11	AADR	ETF	52.16	52.34	51.82	52.34	4800.0
2019-12-11	AAXJ	ETF	70.46	71.05	70.43	70.92	1047300.0
2019-12-11	ACES	ETF	32.58	32.58	32.331	32.481	13600.0
2019-12-11	ACIO	ETF	25.43	25.43	25.37	25.374	1700.0
2019-12-11	ACSI	ETF	35.11	35.1164	35.0872	35.1164	1964.0
2019-12-11	ACTX	ETF	5.9001	7.3751	5.9001	6.8441	215.0
2019-12-11	ACWF	ETF	30.63	30.75	30.63	30.75	6249.0
2019-12-11	ACWI	ETF	77.74	78.06	77.7	77.94	1249100.0
2019-12-11	ACWV	ETF	95.76	95.89	95.53	95.81	163300.0
2019-12-11	ACWX	ETF	48.25	48.57	48.25	48.53	1373287.0
2019-12-11	ADME	ETF	30.29	30.29	30.235	30.244	20900.0
2019-12-11	ADRE	ETF	42.49	42.8095	42.49	42.805	7036.0
2019-12-11	AFIF	ETF	9.7854	9.7917	9.77	9.775	51740.0
2019-12-11	AFK	ETF	20.33	20.33	20.3022	20.33	8217.0
2019-12-11	AFLG	ETF	20.11	20.123	20.1	20.123	300.0
2019-12-11	AFMC	ETF	20.139	20.139	20.132	20.132	100.0
2019-12-11	AFSM	ETF	20.34	20.351	20.34	20.351	100.0
2019-12-11	AFTY	ETF	17.3	17.398	17.25	17.398	252300.0
2019-12-11	AGG	ETF	112.67	112.9	112.61	112.84	3764500.0
2019-12-11	AGGY	ETF	52.3	52.405	52.24	52.36	173900.0
2019-12-11	AGNG	ETF	23.35	23.51	23.35	23.47	900.0
2019-12-11	AGQ	ETF	27.63	28.6	27.57	28.31	164500.0
2019-12-11	AGZ	ETF	115.89	116.02	115.8497	116.02	28819.0
2019-12-11	AGZD	ETF	24.035	24.065	24.0	24.035	16200.0
2019-12-11	AIA	ETF	62.58	63.08	62.53	63.0081	36359.0
2019-12-11	AIEQ	ETF	27.67	27.777	27.63	27.71	8900.0
2019-12-11	AIQ	ETF	17.15	17.2	17.1001	17.19	18717.0
2019-12-11	AIRR	ETF	28.7	28.848	28.7	28.802	3800.0
2019-12-11	AIVI	ETF	41.96	42.2	41.96	42.2	2900.0
2019-12-11	ALTY	ETF	14.71	14.71	14.68	14.695	11500.0
2019-12-11	AMJ	ETF	20.98	21.14	20.88	20.98	8393470.0
2019-12-11	AMLP	ETF	41.05	41.3	40.7	40.9	6625840.0
2019-12-11	AMOM	ETF	26.75	26.773	26.73	26.773	600.0
2019-12-11	AMUB	ETF	13.1906	13.1906	13.1906	13.1906	0.0
2019-12-11	AMZA	ETF	43.1	43.4	42.8	43.0	54680.0
2019-12-11	ANGL	ETF	29.47	29.49	29.38	29.48	245400.0
2019-12-11	AOA	ETF	57.02	57.29	57.02	57.24	51800.0
2019-12-11	AOK	ETF	36.01	36.16	36.01	36.15	46147.0
2019-12-11	AOM	ETF	39.91	40.0	39.8801	39.98	132373.0
2019-12-11	AOR	ETF	47.32	47.46	47.266	47.44	278535.0
2019-12-11	ARCM	ETF	100.34	100.345	100.34	100.345	600.0
2019-12-11	ARGT	ETF	23.98	24.24	23.84	24.06	39000.0
2019-12-11	ARKF	ETF	23.51	23.599	23.414	23.55	8900.0

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

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