PREVIEW / etf_daily / 2020-06-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-04.parquet
  size:    76 KB
  rows:    2,011

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-06-04	SPY	ETF	311.11	313.0	309.08	311.36	75794400.0
2020-06-04	QQQ	ETF	236.32	237.79	233.68	235.03	38716097.0
2020-06-04	IWM	ETF	143.84	145.6	143.18	144.59	28904700.0
2020-06-04	DIA	ETF	262.37	264.43	261.39	263.33	3937100.0
2020-06-04	GLD	ETF	161.14	161.87	159.84	161.28	10094000.0
2020-06-04	TLT	ETF	158.92	159.01	157.19	157.23	14038600.0
2020-06-04	AAAU	ETF	17.07	17.16	16.95	17.11	270800.0
2020-06-04	AADR	ETF	50.43	50.44	49.99	49.99	2200.0
2020-06-04	AAXJ	ETF	68.25	68.68	67.87	68.13	1687300.0
2020-06-04	ABEQ	ETF	22.833	22.833	22.833	22.833	1500.0
2020-06-04	ACES	ETF	38.0	38.0	37.512	37.82	38400.0
2020-06-04	ACIO	ETF	24.8	24.8	24.68	24.79	8100.0
2020-06-04	ACSI	ETF	34.2527	34.2527	34.2527	34.2527	197.0
2020-06-04	ACTX	ETF	4.251	4.8498	4.248	4.7141	198.0
2020-06-04	ACWF	ETF	28.4499	28.47	28.3152	28.3474	8732.0
2020-06-04	ACWI	ETF	74.79	75.21	74.37	74.74	4406400.0
2020-06-04	ACWV	ETF	90.07	90.2	89.28	89.72	397700.0
2020-06-04	ACWX	ETF	44.08	44.35	43.92	44.09	2434369.0
2020-06-04	ADME	ETF	32.09	32.09	31.609	31.649	12700.0
2020-06-04	ADRE	ETF	39.17	39.498	39.17	39.33	11344.0
2020-06-04	AESR	ETF	9.835	9.85	9.76	9.83	56200.0
2020-06-04	AFIF	ETF	9.81	9.81	9.79	9.79	63940.0
2020-06-04	AFK	ETF	16.15	16.3098	16.15	16.23	4380.0
2020-06-04	AFLG	ETF	18.983	18.983	18.983	18.983	100.0
2020-06-04	AFMC	ETF	17.678	17.678	17.678	17.678	200.0
2020-06-04	AFSM	ETF	17.089	17.089	17.089	17.089	100.0
2020-06-04	AFTY	ETF	16.259	16.263	16.23	16.263	3900.0
2020-06-04	AGG	ETF	117.27	117.3	116.82	116.83	5002700.0
2020-06-04	AGGY	ETF	53.41	53.41	53.22	53.33	358600.0
2020-06-04	AGNG	ETF	24.58	24.58	24.375	24.375	1200.0
2020-06-04	AGQ	ETF	28.4	28.7	27.79	28.39	329400.0
2020-06-04	AGZ	ETF	120.63	120.63	120.27	120.38	46551.0
2020-06-04	AGZD	ETF	23.505	23.505	23.38	23.445	10600.0
2020-06-04	AIA	ETF	62.82	63.33	62.6992	62.95	54011.0
2020-06-04	AIEQ	ETF	27.52	27.73	27.21	27.27	13200.0
2020-06-04	AIQ	ETF	20.16	20.245	19.91	19.93	45491.0
2020-06-04	AIRR	ETF	24.26	24.8	24.12	24.8	14500.0
2020-06-04	AIVI	ETF	36.46	36.69	36.41	36.45	17900.0
2020-06-04	ALTY	ETF	11.34	11.46	11.239	11.46	8800.0
2020-06-04	AMJ	ETF	15.3	15.6	15.06	15.6	1072211.0
2020-06-04	AMLP	ETF	28.05	28.98	27.98	28.94	1816100.0
2020-06-04	AMOM	ETF	28.01	28.051	28.0	28.051	700.0
2020-06-04	AMUB	ETF	9.67	9.7871	9.67	9.7871	3499.0
2020-06-04	AMZA	ETF	21.36	22.2	21.3	22.1	63000.0
2020-06-04	ANGL	ETF	28.63	28.66	28.5	28.61	959400.0
2020-06-04	AOA	ETF	55.14	55.3	54.95	55.11	44800.0
2020-06-04	AOK	ETF	36.26	36.2917	36.1601	36.22	155300.0
2020-06-04	AOM	ETF	39.76	39.951	39.7	39.74	193823.0
2020-06-04	AOR	ETF	46.47	46.58	46.25	46.37	123922.0
2020-06-04	APRT	ETF	25.37	25.37	25.2682	25.2682	4406.0

> showing 50 of 2,011 rows — these rows as CSV

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