PREVIEW / etf_daily / 2020-11-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-04.parquet
  size:    80 KB
  rows:    2,133

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-11-04	SPY	ETF	340.86	347.94	339.59	343.54	126959700.0
2020-11-04	QQQ	ETF	283.56	288.77	281.87	286.91	75728206.0
2020-11-04	IWM	ETF	157.75	162.35	157.71	160.42	45226300.0
2020-11-04	DIA	ETF	275.9	283.06	275.56	278.51	6766400.0
2020-11-04	GLD	ETF	178.93	179.19	177.66	178.82	11117300.0
2020-11-04	TLT	ETF	161.64	162.17	160.54	161.08	21570800.0
2020-11-04	AAA	ETF	24.88	24.9	24.88	24.89	202.0
2020-11-04	AAAU	ETF	19.0	19.01	18.86	18.97	969700.0
2020-11-04	AADR	ETF	56.19	57.26	56.19	57.03	4600.0
2020-11-04	AAXJ	ETF	80.93	82.81	80.93	82.58	2236800.0
2020-11-04	ABEQ	ETF	23.79	23.79	23.491	23.491	3300.0
2020-11-04	ACES	ETF	57.15	57.786	56.0	57.23	297500.0
2020-11-04	ACIO	ETF	27.19	27.19	27.0	27.0	56400.0
2020-11-04	ACSI	ETF	39.427	39.427	39.427	39.427	125.0
2020-11-04	ACTV	ETF	25.12	25.65	25.12	25.3213	10833.0
2020-11-04	ACTX	ETF	2.5	2.5	2.485	2.49	1079.0
2020-11-04	ACVF	ETF	25.77	25.77	25.5	25.507	1600.0
2020-11-04	ACWF	ETF	30.39	30.9898	30.39	30.67	8869.0
2020-11-04	ACWI	ETF	81.35	82.93	81.15	82.15	7627400.0
2020-11-04	ACWV	ETF	92.48	93.89	92.4	92.84	220700.0
2020-11-04	ACWX	ETF	46.8262	47.55	46.64	47.25	2055901.0
2020-11-04	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-11-04	ADME	ETF	34.31	34.71	34.31	34.399	24700.0
2020-11-04	ADRE	ETF	50.2	51.1	50.2	50.8122	56477.0
2020-11-04	AESR	ETF	11.07	11.27	11.07	11.168	4100.0
2020-11-04	AFIF	ETF	9.84	9.86	9.83	9.84	5876.0
2020-11-04	AFK	ETF	18.43	18.52	18.35	18.5	6425.0
2020-11-04	AFLG	ETF	20.63	20.72	20.63	20.72	400.0
2020-11-04	AFMC	ETF	18.8	18.8	18.75	18.75	400.0
2020-11-04	AFSM	ETF	18.77	19.08	18.77	18.926	200.0
2020-11-04	AFTY	ETF	20.99	21.305	20.99	21.305	10600.0
2020-11-04	AGG	ETF	117.9	118.04	117.83	117.95	5308700.0
2020-11-04	AGGY	ETF	53.68	53.795	53.68	53.72	259100.0
2020-11-04	AGNG	ETF	25.66	26.35	25.66	26.15	2100.0
2020-11-04	AGQ	ETF	43.84	44.46	42.82	43.4	1145400.0
2020-11-04	AGZ	ETF	121.0	121.0	120.84	120.94	23519.0
2020-11-04	AGZD	ETF	23.545	23.55	23.48	23.49	20000.0
2020-11-04	AIA	ETF	77.76	79.05	77.545	78.79	228850.0
2020-11-04	AIEQ	ETF	31.14	31.665	31.015	31.45	10400.0
2020-11-04	AIQ	ETF	24.36	24.8	24.2342	24.68	45723.0
2020-11-04	AIRR	ETF	27.5	27.622	26.88	27.262	49900.0
2020-11-04	AIVI	ETF	35.66	36.14	35.51	35.9	5600.0
2020-11-04	ALTL	ETF	25.04	25.1155	24.615	24.7139	25377.0
2020-11-04	ALTY	ETF	10.58	10.7	10.485	10.6	9600.0
2020-11-04	AMJ	ETF	11.68	11.75	11.21	11.48	890068.0
2020-11-04	AMLP	ETF	21.27	21.74	20.71	21.19	3267500.0
2020-11-04	AMNA	ETF	21.506	21.506	21.506	21.506	0.0
2020-11-04	AMND	ETF	22.65	23.125	22.42	22.7748	16012.0
2020-11-04	AMOM	ETF	36.65	36.915	36.65	36.776	2500.0
2020-11-04	AMTR	ETF	24.48	24.48	24.15	24.16	39000.0

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

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