PREVIEW / etf_daily / 2020-04-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-13.parquet
  size:    74 KB
  rows:    1,961

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
2020-04-13	SPY	ETF	277.14	277.51	271.41	275.66	114839100.0
2020-04-13	QQQ	ETF	199.92	203.42	198.75	203.03	42853948.0
2020-04-13	IWM	ETF	122.85	123.51	119.12	120.37	40198200.0
2020-04-13	DIA	ETF	236.41	236.69	230.96	233.96	6761900.0
2020-04-13	GLD	ETF	159.17	162.38	158.63	161.41	20549200.0
2020-04-13	TLT	ETF	164.75	165.71	163.88	163.88	8750300.0
2020-04-13	AAAU	ETF	16.99	17.2	16.82	17.14	521600.0
2020-04-13	AADR	ETF	42.77	43.65	42.76	43.65	2300.0
2020-04-13	AAXJ	ETF	61.57	61.73	61.07	61.68	1039400.0
2020-04-13	ABEQ	ETF	22.2	22.2	21.28	21.452	7900.0
2020-04-13	ACES	ETF	32.0	32.0	30.5	31.243	36900.0
2020-04-13	ACIO	ETF	23.15	23.52	23.15	23.52	11700.0
2020-04-13	ACSI	ETF	29.7908	29.7908	29.7908	29.7908	157.0
2020-04-13	ACTX	ETF	3.953	5.8411	3.835	4.307	129.0
2020-04-13	ACWF	ETF	25.1862	25.475	25.1862	25.38	19681.0
2020-04-13	ACWI	ETF	65.99	66.17	64.92	65.72	5530800.0
2020-04-13	ACWV	ETF	85.7	85.73	84.4	85.05	384300.0
2020-04-13	ACWX	ETF	39.02	39.04	38.48	38.82	2582653.0
2020-04-13	ADME	ETF	29.67	29.67	28.8	29.19	30900.0
2020-04-13	ADRE	ETF	34.55	34.8499	34.3465	34.805	7509.0
2020-04-13	AESR	ETF	8.72	8.81	8.72	8.81	52000.0
2020-04-13	AFIF	ETF	9.7441	9.76	9.71	9.71	50667.0
2020-04-13	AFK	ETF	14.32	14.32	13.8612	13.97	18326.0
2020-04-13	AFLG	ETF	16.79	16.848	16.79	16.848	100.0
2020-04-13	AFSM	ETF	14.5	14.559	14.5	14.559	100.0
2020-04-13	AFTY	ETF	15.223	15.31	15.22	15.269	3200.0
2020-04-13	AGG	ETF	117.09	117.17	116.53	116.7	5738300.0
2020-04-13	AGGY	ETF	53.01	53.33	52.89	53.08	360600.0
2020-04-13	AGNG	ETF	21.52	21.52	21.182	21.28	1600.0
2020-04-13	AGQ	ETF	21.82	22.78	21.63	22.66	254600.0
2020-04-13	AGZ	ETF	119.86	120.2168	119.86	120.0	88440.0
2020-04-13	AGZD	ETF	23.87	23.87	23.4	23.4	18200.0
2020-04-13	AIA	ETF	57.54	57.54	56.84	57.41	97569.0
2020-04-13	AIEQ	ETF	23.56	23.88	23.41	23.77	27700.0
2020-04-13	AIQ	ETF	16.21	16.48	16.2	16.48	7606.0
2020-04-13	AIRR	ETF	21.28	21.35	20.73	20.94	16700.0
2020-04-13	AIVI	ETF	32.82	32.89	32.42	32.63	16100.0
2020-04-13	ALTY	ETF	9.71	9.75	9.426	9.67	11000.0
2020-04-13	AMJ	ETF	10.89	10.89	10.17	10.45	2664564.0
2020-04-13	AMLP	ETF	20.25	20.5	19.3	19.9	9365220.0
2020-04-13	AMOM	ETF	23.58	23.848	23.58	23.848	200.0
2020-04-13	AMUB	ETF	6.62	6.62	6.54	6.5809	3751.0
2020-04-13	AMZA	ETF	13.68	14.0	13.19	13.2	63900.0
2020-04-13	ANGL	ETF	27.25	27.35	26.73	27.25	2536800.0
2020-04-13	AOA	ETF	49.71	49.73	49.01	49.5	204100.0
2020-04-13	AOK	ETF	34.82	34.82	34.514	34.56	234942.0
2020-04-13	AOM	ETF	37.62	37.6311	37.35	37.45	454913.0
2020-04-13	AOR	ETF	42.98	42.98	42.4633	42.75	348151.0
2020-04-13	ARCM	ETF	99.789	100.05	99.785	100.05	2000.0
2020-04-13	ARGT	ETF	17.34	17.42	16.74	17.27	15100.0

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

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