PREVIEW / etf_daily / 2020-03-19

all etf daily files

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

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-19	SPY	ETF	239.25	247.38	232.22	240.51	289322000.0
2020-03-19	QQQ	ETF	175.69	183.49	171.63	177.66	120896481.0
2020-03-19	IWM	ETF	99.66	106.8	95.69	103.87	62654700.0
2020-03-19	DIA	ETF	198.37	204.98	192.32	201.31	13532100.0
2020-03-19	GLD	ETF	139.08	140.5	137.85	138.04	20828900.0
2020-03-19	TLT	ETF	146.95	153.45	145.25	148.28	21175300.0
2020-03-19	AAAU	ETF	14.74	14.88	14.63	14.65	189800.0
2020-03-19	AADR	ETF	34.78	36.35	34.72	35.67	16300.0
2020-03-19	AAXJ	ETF	53.91	55.0	53.13	54.01	2132300.0
2020-03-19	ABEQ	ETF	19.3	19.472	19.06	19.472	3000.0
2020-03-19	ACES	ETF	23.99	26.11	23.155	25.69	40900.0
2020-03-19	ACIO	ETF	22.7	22.885	22.568	22.86	10100.0
2020-03-19	ACSI	ETF	26.1	26.62	26.1	26.2972	1540.0
2020-03-19	ACTX	ETF	3.245	3.5695	2.1329	2.7199	2222.0
2020-03-19	ACWF	ETF	21.3733	22.379	21.3733	22.04	49759.0
2020-03-19	ACWI	ETF	56.19	58.35	55.14	57.12	9173800.0
2020-03-19	ACWV	ETF	75.6	77.21	73.49	75.35	945000.0
2020-03-19	ACWX	ETF	33.1	34.35	32.7501	33.67	5104317.0
2020-03-19	ADME	ETF	27.57	27.87	27.42	27.46	13600.0
2020-03-19	ADRE	ETF	30.49	31.2613	30.05	30.8701	18620.0
2020-03-19	AESR	ETF	7.585	7.74	7.2	7.688	22100.0
2020-03-19	AFIF	ETF	9.585	9.8073	9.505	9.8073	3304.0
2020-03-19	AFK	ETF	11.58	12.2634	11.2383	12.17	19937.0
2020-03-19	AFLG	ETF	14.9	14.91	14.699	14.699	2200.0
2020-03-19	AFTY	ETF	14.25	14.65	14.19	14.419	4800.0
2020-03-19	AGG	ETF	106.47	109.22	105.56	108.95	11720200.0
2020-03-19	AGGY	ETF	47.34	47.79	47.041	47.17	571600.0
2020-03-19	AGNG	ETF	17.56	18.47	17.44	18.138	8700.0
2020-03-19	AGQ	ETF	13.7	14.0	13.05	13.71	531100.0
2020-03-19	AGZ	ETF	118.62	120.21	118.62	119.43	307297.0
2020-03-19	AGZD	ETF	22.035	22.955	21.96	22.48	63200.0
2020-03-19	AIA	ETF	50.21	51.01	49.152	49.85	163690.0
2020-03-19	AIEQ	ETF	20.31	21.361	19.81	20.73	31000.0
2020-03-19	AIQ	ETF	13.5	14.34	13.4126	14.0106	63123.0
2020-03-19	AIRR	ETF	16.94	18.235	16.66	18.235	20600.0
2020-03-19	AIVI	ETF	27.98	28.91	27.86	28.38	179300.0
2020-03-19	ALTY	ETF	6.98	8.18	6.79	7.879	38700.0
2020-03-19	AMJ	ETF	7.13	8.8599	6.72	8.25	8743786.0
2020-03-19	AMLP	ETF	14.05	17.3	13.2	16.15	13306000.0
2020-03-19	AMOM	ETF	20.857	20.857	20.857	20.857	100.0
2020-03-19	AMUB	ETF	4.85	5.44	4.85	5.2426	8739.0
2020-03-19	AMZA	ETF	8.94	11.5	8.41	10.3	174250.0
2020-03-19	ANGL	ETF	21.96	23.2	21.13	21.5	1783800.0
2020-03-19	AOA	ETF	42.77	44.44	42.74	43.68	184200.0
2020-03-19	AOK	ETF	31.3	31.85	31.16	31.52	778868.0
2020-03-19	AOM	ETF	34.09	34.5	33.6902	34.02	506291.0
2020-03-19	AOR	ETF	38.05	38.9173	37.55	38.36	396162.0
2020-03-19	ARGT	ETF	14.75	15.33	14.42	14.97	53700.0
2020-03-19	ARKF	ETF	17.82	18.66	17.43	18.3	76700.0
2020-03-19	ARKG	ETF	24.91	27.3	24.64	27.01	233000.0

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

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