PREVIEW / etf_daily / 2020-06-03

all etf daily files

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

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-03	SPY	ETF	310.24	313.22	309.94	312.18	92567600.0
2020-06-03	QQQ	ETF	236.23	237.47	235.35	236.69	37228701.0
2020-06-03	IWM	ETF	143.67	146.07	143.11	144.8	36111700.0
2020-06-03	DIA	ETF	260.35	264.0	259.66	263.17	5184500.0
2020-06-03	GLD	ETF	160.34	160.9	158.82	159.6	17000500.0
2020-06-03	TLT	ETF	160.18	160.33	158.94	159.54	12255700.0
2020-06-03	AAAU	ETF	17.01	17.06	16.84	16.92	480300.0
2020-06-03	AADR	ETF	50.26	50.53	50.26	50.4	7700.0
2020-06-03	AAXJ	ETF	68.43	69.18	68.37	69.08	2134200.0
2020-06-03	ABEQ	ETF	22.78	22.82	22.72	22.779	3000.0
2020-06-03	ACES	ETF	37.28	37.812	37.28	37.71	40500.0
2020-06-03	ACIO	ETF	24.8	24.85	24.8	24.84	1800.0
2020-06-03	ACSI	ETF	33.8522	34.0657	33.8522	34.0657	532.0
2020-06-03	ACTX	ETF	5.1448	5.31	4.2864	4.8085	868.0
2020-06-03	ACWF	ETF	28.3	28.5335	28.3	28.46	31668.0
2020-06-03	ACWI	ETF	74.63	75.37	74.53	75.15	4526100.0
2020-06-03	ACWV	ETF	90.08	90.53	90.0	90.34	381100.0
2020-06-03	ACWX	ETF	43.94	44.49	43.92	44.34	4632917.0
2020-06-03	ADME	ETF	32.02	32.11	31.97	32.047	3700.0
2020-06-03	ADRE	ETF	39.07	39.64	39.07	39.5073	4919.0
2020-06-03	AESR	ETF	10.8	10.8	9.81	9.866	9100.0
2020-06-03	AFIF	ETF	9.65	9.82	9.65	9.8	30389.0
2020-06-03	AFK	ETF	16.19	16.325	16.13	16.3	7226.0
2020-06-03	AFLG	ETF	19.082	19.082	19.082	19.082	100.0
2020-06-03	AFTY	ETF	16.4	16.46	16.4	16.446	2300.0
2020-06-03	AGG	ETF	117.26	117.41	117.06	117.18	6077600.0
2020-06-03	AGGY	ETF	53.48	53.49	53.31	53.42	292700.0
2020-06-03	AGNG	ETF	24.65	24.65	24.575	24.575	300.0
2020-06-03	AGQ	ETF	28.29	28.58	27.31	28.2	931800.0
2020-06-03	AGZ	ETF	120.56	120.7501	120.5	120.51	112742.0
2020-06-03	AGZD	ETF	23.42	23.445	23.34	23.43	6800.0
2020-06-03	AIA	ETF	63.16	63.77	63.1	63.72	84578.0
2020-06-03	AIEQ	ETF	27.72	27.75	27.604	27.68	17700.0
2020-06-03	AIQ	ETF	19.96	20.2299	19.96	20.1	13476.0
2020-06-03	AIRR	ETF	24.1	24.64	24.1	24.47	7000.0
2020-06-03	AIVI	ETF	36.45	36.87	36.38	36.81	7700.0
2020-06-03	ALTY	ETF	11.17	11.35	11.06	11.297	12300.0
2020-06-03	AMJ	ETF	14.8	15.34	14.77	15.2	1360994.0
2020-06-03	AMLP	ETF	27.5	28.53	27.5	28.28	2550100.0
2020-06-03	AMOM	ETF	28.603	28.603	28.603	28.603	100.0
2020-06-03	AMUB	ETF	9.38	9.65	9.32	9.58	30094.0
2020-06-03	AMZA	ETF	20.9	21.75	20.85	21.68	59700.0
2020-06-03	ANGL	ETF	28.52	28.7	28.5	28.63	1500100.0
2020-06-03	AOA	ETF	54.93	55.4	54.85	55.33	71800.0
2020-06-03	AOK	ETF	36.27	36.36	36.24	36.32	395558.0
2020-06-03	AOM	ETF	39.75	39.94	39.75	39.94	636340.0
2020-06-03	AOR	ETF	46.27	46.6359	46.27	46.58	174415.0
2020-06-03	APRT	ETF	25.32	25.3357	25.32	25.3357	498.0
2020-06-03	ARB	ETF	24.53	24.58	24.53	24.55	1400.0
2020-06-03	ARCM	ETF	100.3	100.31	100.3	100.31	1000.0

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

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