PREVIEW / etf_daily / 2020-03-10

all etf daily files

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

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-10	SPY	ETF	284.64	288.52	273.5	288.42	276444100.0
2020-03-10	QQQ	ETF	201.11	204.3	193.6802	204.11	100599233.0
2020-03-10	IWM	ETF	134.71	134.8	128.02	134.43	54432700.0
2020-03-10	DIA	ETF	247.29	250.54	237.09	250.47	9407100.0
2020-03-10	GLD	ETF	156.18	156.41	154.39	154.48	18811500.0
2020-03-10	TLT	ETF	169.64	172.93	162.03	162.51	37728300.0
2020-03-10	AAAU	ETF	16.56	16.56	16.39	16.4	230100.0
2020-03-10	AADR	ETF	46.86	47.5	46.04	47.49	89000.0
2020-03-10	AAXJ	ETF	66.87	67.38	65.78	67.29	5463500.0
2020-03-10	ABEQ	ETF	22.25	22.25	21.55	21.806	21900.0
2020-03-10	ACES	ETF	35.89	35.89	34.02	35.026	180100.0
2020-03-10	ACIO	ETF	23.866	24.151	23.78	24.126	18800.0
2020-03-10	ACSI	ETF	31.57	31.8338	30.8108	31.8338	2802.0
2020-03-10	ACTX	ETF	5.9001	6.9621	5.9001	6.2541	134.0
2020-03-10	ACWF	ETF	27.04	27.1872	26.23	27.1872	94451.0
2020-03-10	ACWI	ETF	69.21	69.86	66.81	69.86	6150500.0
2020-03-10	ACWV	ETF	90.44	90.44	87.44	90.14	868600.0
2020-03-10	ACWX	ETF	42.06	42.19	40.85	42.1	4135705.0
2020-03-10	ADME	ETF	29.6	30.112	29.3	30.112	17300.0
2020-03-10	ADRE	ETF	37.93	38.1362	37.11	38.1362	12985.0
2020-03-10	AESR	ETF	9.0	9.101	8.79	9.101	3300.0
2020-03-10	AFIF	ETF	10.19	10.19	10.03	10.04	7969.0
2020-03-10	AFK	ETF	15.66	16.0	15.66	16.0	25927.0
2020-03-10	AFLG	ETF	17.72	18.037	17.72	18.037	100.0
2020-03-10	AFTY	ETF	16.79	16.89	16.63	16.863	13200.0
2020-03-10	AGG	ETF	117.41	117.68	116.17	116.38	18694100.0
2020-03-10	AGGY	ETF	53.87	54.01	53.13	53.16	1003800.0
2020-03-10	AGNG	ETF	21.571	21.913	20.97	21.913	5100.0
2020-03-10	AGQ	ETF	27.95	27.95	27.19	27.42	367100.0
2020-03-10	AGZ	ETF	121.52	121.646	120.74	120.74	163799.0
2020-03-10	AGZD	ETF	23.49	23.545	23.09	23.295	90200.0
2020-03-10	AIA	ETF	60.91	61.35	59.97	61.28	232412.0
2020-03-10	AIEQ	ETF	25.15	25.25	24.082	25.25	36700.0
2020-03-10	AIQ	ETF	16.62	16.8088	16.1107	16.7949	24254.0
2020-03-10	AIRR	ETF	23.36	23.36	22.1	22.991	13900.0
2020-03-10	AIVI	ETF	35.43	35.43	34.26	35.26	31300.0
2020-03-10	ALTY	ETF	12.66	12.66	12.0	12.29	15100.0
2020-03-10	AMJ	ETF	12.49	12.8	10.66	12.57	11680825.0
2020-03-10	AMLP	ETF	24.35	24.9	20.7	24.45	16769560.0
2020-03-10	AMOM	ETF	24.75	24.75	24.75	24.75	100.0
2020-03-10	AMUB	ETF	7.75	7.98	6.77	7.9446	6503.0
2020-03-10	AMZA	ETF	17.9	18.9	14.5	18.2	358620.0
2020-03-10	ANGL	ETF	27.9	28.25	27.25	28.14	1774500.0
2020-03-10	AOA	ETF	51.5	52.36	50.67	52.36	198800.0
2020-03-10	AOK	ETF	35.65	35.66	35.26	35.52	406102.0
2020-03-10	AOM	ETF	38.71	38.8123	38.22	38.59	295559.0
2020-03-10	AOR	ETF	44.69	44.69	43.69	44.62	259119.0
2020-03-10	ARCM	ETF	100.185	100.185	100.185	100.185	100.0
2020-03-10	ARGT	ETF	20.79	21.28	20.29	21.23	14800.0
2020-03-10	ARKF	ETF	22.96	23.1	22.111	23.09	112200.0

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

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