PREVIEW / etf_daily / 2020-05-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-12.parquet
  size:    75 KB
  rows:    1,986

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-05-12	SPY	ETF	293.79	294.24	286.52	286.67	95870800.0
2020-05-12	QQQ	ETF	227.48	228.095	222.09	222.12	41054123.0
2020-05-12	IWM	ETF	132.26	132.29	126.84	126.97	44275300.0
2020-05-12	DIA	ETF	243.81	244.14	237.94	238.08	6433900.0
2020-05-12	GLD	ETF	160.3	160.95	159.72	160.04	10406000.0
2020-05-12	TLT	ETF	163.16	164.93	163.13	164.37	10057300.0
2020-05-12	AAAU	ETF	17.0	17.06	16.94	16.98	191700.0
2020-05-12	AADR	ETF	47.35	47.71	46.81	46.81	1300.0
2020-05-12	AAXJ	ETF	64.6	65.18	64.09	64.12	3183200.0
2020-05-12	ABEQ	ETF	21.795	21.795	21.543	21.543	6600.0
2020-05-12	ACES	ETF	35.09	35.3	33.99	34.16	47800.0
2020-05-12	ACIO	ETF	24.015	24.015	23.8	23.8	73500.0
2020-05-12	ACSI	ETF	30.75	30.75	30.3008	30.3008	673.0
2020-05-12	ACTX	ETF	4.13	5.5874	4.012	4.956	217.0
2020-05-12	ACWF	ETF	26.53	26.56	25.91	25.91	38964.0
2020-05-12	ACWI	ETF	69.62	69.7	68.16	68.16	3864600.0
2020-05-12	ACWV	ETF	86.81	86.92	85.6	85.67	611600.0
2020-05-12	ACWX	ETF	40.32	40.45	39.74	39.74	2277318.0
2020-05-12	ADME	ETF	30.715	30.8	30.468	30.468	61100.0
2020-05-12	ADRE	ETF	35.98	36.0559	35.6164	35.6164	2171.0
2020-05-12	AESR	ETF	9.41	9.42	9.245	9.245	10400.0
2020-05-12	AFIF	ETF	9.85	10.08	9.8	9.8199	21740.0
2020-05-12	AFK	ETF	14.56	14.95	14.1	14.35	10976.0
2020-05-12	AFLG	ETF	17.606	17.606	17.606	17.606	100.0
2020-05-12	AFMC	ETF	15.86	15.86	15.47	15.47	200.0
2020-05-12	AFTY	ETF	16.15	16.15	16.008	16.008	900.0
2020-05-12	AGG	ETF	116.46	116.6	116.23	116.41	6161500.0
2020-05-12	AGGY	ETF	52.7	52.78	52.53	52.73	172500.0
2020-05-12	AGNG	ETF	23.41	23.52	23.24	23.31	1800.0
2020-05-12	AGQ	ETF	22.02	22.27	21.6	21.66	314600.0
2020-05-12	AGZ	ETF	120.73	120.8604	120.59	120.8284	34473.0
2020-05-12	AGZD	ETF	23.325	23.325	22.825	23.175	23000.0
2020-05-12	AIA	ETF	59.62	59.81	58.93	58.95	136840.0
2020-05-12	AIEQ	ETF	27.06	27.12	26.51	26.571	25700.0
2020-05-12	AIQ	ETF	18.83	18.83	18.36	18.4184	66854.0
2020-05-12	AIRR	ETF	21.09	21.09	19.93	19.945	85200.0
2020-05-12	AIVI	ETF	33.44	33.55	33.0	33.0	4600.0
2020-05-12	ALTY	ETF	10.0	10.03	9.895	9.895	3200.0
2020-05-12	AMJ	ETF	13.25	13.64	13.05	13.05	1512695.0
2020-05-12	AMLP	ETF	24.1	24.85	23.7	23.85	4330100.0
2020-05-12	AMOM	ETF	27.65	27.65	27.121	27.121	700.0
2020-05-12	AMUB	ETF	8.12	8.58	8.12	8.2418	11375.0
2020-05-12	AMZA	ETF	17.2	17.9	17.05	17.13	70400.0
2020-05-12	ANGL	ETF	27.05	27.23	26.86	26.86	3805000.0
2020-05-12	AOA	ETF	51.66	51.8	50.88	50.88	133300.0
2020-05-12	AOK	ETF	35.09	35.1775	34.95	34.95	364965.0
2020-05-12	AOM	ETF	38.38	38.4	38.02	38.06	387546.0
2020-05-12	AOR	ETF	44.19	44.19	43.56	43.56	190986.0
2020-05-12	ARB	ETF	25.03	25.03	24.9058	24.9058	1874.0
2020-05-12	ARGT	ETF	20.56	21.05	20.26	20.3	36500.0

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

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