PREVIEW / etf_daily / 2020-03-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-13.parquet
  size:    75 KB
  rows:    1,981

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-03-13	SPY	ETF	263.09	271.48	248.52	269.32	329566100.0
2020-03-13	QQQ	ETF	187.07	194.48	178.13	192.34	134881981.0
2020-03-13	IWM	ETF	118.31	119.96	109.55	119.47	57915100.0
2020-03-13	DIA	ETF	225.65	232.48	213.29	232.11	13676000.0
2020-03-13	GLD	ETF	149.42	149.6	141.58	143.28	35177200.0
2020-03-13	TLT	ETF	155.0	158.2	152.19	153.94	19812900.0
2020-03-13	AAAU	ETF	15.85	15.85	15.04	15.19	530600.0
2020-03-13	AADR	ETF	41.64	41.64	39.47	40.9	14300.0
2020-03-13	AAXJ	ETF	63.31	63.67	59.92	62.52	2631300.0
2020-03-13	ABEQ	ETF	20.19	20.86	19.792	20.86	197200.0
2020-03-13	ACES	ETF	29.2	32.12	28.26	29.75	45700.0
2020-03-13	ACIO	ETF	23.35	24.361	23.281	24.361	24500.0
2020-03-13	ACSI	ETF	28.6325	28.9367	27.77	28.9367	708.0
2020-03-13	ACTX	ETF	6.1951	6.8588	4.72	6.4901	1352.0
2020-03-13	ACWF	ETF	24.97	24.97	23.45	24.8916	18100.0
2020-03-13	ACWI	ETF	63.29	64.84	59.85	64.02	10082700.0
2020-03-13	ACWV	ETF	82.61	83.03	78.36	82.93	1504200.0
2020-03-13	ACWX	ETF	38.03	38.3	35.9	37.9	1884330.0
2020-03-13	ADME	ETF	29.19	29.42	28.296	29.11	32600.0
2020-03-13	ADRE	ETF	35.51	36.135	33.7601	35.3642	28703.0
2020-03-13	AESR	ETF	8.339	8.49	8.339	8.49	200.0
2020-03-13	AFIF	ETF	10.01	10.06	9.98	10.0516	10842.0
2020-03-13	AFK	ETF	14.04	14.8087	13.71	13.8001	35618.0
2020-03-13	AFLG	ETF	16.13	16.641	15.6	16.641	55200.0
2020-03-13	AFMC	ETF	14.5	15.152	14.5	15.152	200.0
2020-03-13	AFSM	ETF	13.69	14.443	13.69	14.443	1300.0
2020-03-13	AFTY	ETF	16.17	16.17	15.774	16.083	9600.0
2020-03-13	AGG	ETF	111.53	112.46	110.25	111.86	24960500.0
2020-03-13	AGGY	ETF	51.11	51.9	49.75	49.75	782900.0
2020-03-13	AGNG	ETF	19.65	19.66	18.5	19.61	25300.0
2020-03-13	AGQ	ETF	23.77	23.81	19.83	20.32	873600.0
2020-03-13	AGZ	ETF	119.46	120.13	118.925	119.4171	126580.0
2020-03-13	AGZD	ETF	23.11	23.555	22.08	23.035	34200.0
2020-03-13	AIA	ETF	58.09	58.31	55.28	57.09	165793.0
2020-03-13	AIEQ	ETF	22.74	23.27	21.34	23.25	57900.0
2020-03-13	AIQ	ETF	15.08	15.46	14.4483	15.46	21174.0
2020-03-13	AIRR	ETF	20.47	20.76	19.39	20.645	347600.0
2020-03-13	AIVI	ETF	31.68	31.68	29.94	31.44	40000.0
2020-03-13	ALTY	ETF	10.665	10.665	10.1	10.5	22700.0
2020-03-13	AMJ	ETF	10.81	11.0	10.0	10.71	5409131.0
2020-03-13	AMLP	ETF	20.85	21.4	19.45	21.05	11402560.0
2020-03-13	AMOM	ETF	23.24	23.24	22.996	22.996	400.0
2020-03-13	AMUB	ETF	6.4	6.7474	6.37	6.7474	40885.0
2020-03-13	AMZA	ETF	15.2	16.0	14.05	15.0	149970.0
2020-03-13	ANGL	ETF	25.9	26.75	25.79	26.67	1471800.0
2020-03-13	AOA	ETF	47.6	48.8	46.01	48.29	167500.0
2020-03-13	AOK	ETF	33.02	33.83	32.9	33.83	229472.0
2020-03-13	AOM	ETF	36.29	36.67	35.675	36.41	403908.0
2020-03-13	AOR	ETF	41.71	41.9201	40.2314	41.61	533034.0
2020-03-13	ARGT	ETF	18.87	18.87	17.66	18.33	27700.0

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

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