PREVIEW / etf_daily / 2020-12-07

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-07.parquet
  size:    81 KB
  rows:    2,173

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-12-07	SPY	ETF	369.02	369.62	367.72	369.09	48944300.0
2020-12-07	QQQ	ETF	305.71	307.63	305.52	307.25	20850969.0
2020-12-07	IWM	ETF	188.23	188.95	187.44	188.38	14671500.0
2020-12-07	DIA	ETF	301.77	302.16	300.0	301.1	2589900.0
2020-12-07	GLD	ETF	172.56	175.29	172.51	174.89	10555100.0
2020-12-07	TLT	ETF	156.35	156.88	156.18	156.6	9316100.0
2020-12-07	AAA	ETF	25.0583	25.06	25.055	25.055	643.0
2020-12-07	AAAU	ETF	18.33	18.6	18.32	18.56	297500.0
2020-12-07	AADR	ETF	58.89	59.0	58.7	58.78	6800.0
2020-12-07	AAXJ	ETF	87.78	88.13	87.69	87.88	1190100.0
2020-12-07	ABEQ	ETF	24.46	25.26	24.46	25.225	1600.0
2020-12-07	ACES	ETF	69.5	69.5	68.35	68.74	98800.0
2020-12-07	ACIO	ETF	27.52	27.58	27.45	27.54	69700.0
2020-12-07	ACSI	ETF	42.9948	42.9948	42.9948	42.9948	202.0
2020-12-07	ACTV	ETF	30.35	30.5099	30.23	30.348	5960.0
2020-12-07	ACTX	ETF	2.8	2.8	2.7999	2.8	930.0
2020-12-07	ACVF	ETF	27.42	27.42	27.357	27.357	8200.0
2020-12-07	ACWF	ETF	33.04	33.07	32.94	32.9899	4804.0
2020-12-07	ACWI	ETF	89.45	89.64	89.21	89.47	915600.0
2020-12-07	ACWV	ETF	96.3	96.33	95.82	96.12	259400.0
2020-12-07	ACWX	ETF	52.27	52.43	52.15	52.26	1222963.0
2020-12-07	ADFI	ETF	9.975	9.975	9.97	9.97	1300.0
2020-12-07	ADME	ETF	35.46	35.46	35.2	35.38	8800.0
2020-12-07	ADRE	ETF	55.54	55.62	55.29	55.36	39474.0
2020-12-07	AESR	ETF	11.83	11.83	11.77	11.812	4200.0
2020-12-07	AFIF	ETF	9.83	9.83	9.8101	9.82	15281.0
2020-12-07	AFK	ETF	20.7	20.71	20.35	20.4666	9881.0
2020-12-07	AFLG	ETF	21.93	21.93	21.905	21.906	600.0
2020-12-07	AFMC	ETF	20.743	20.743	20.743	20.743	100.0
2020-12-07	AFSM	ETF	21.08	21.08	21.08	21.08	100.0
2020-12-07	AFTY	ETF	22.37	22.37	22.32	22.348	4300.0
2020-12-07	AGG	ETF	117.76	117.83	117.69	117.77	6127800.0
2020-12-07	AGGY	ETF	53.75	53.76	53.697	53.74	82100.0
2020-12-07	AGNG	ETF	27.4	27.4	27.32	27.325	2400.0
2020-12-07	AGQ	ETF	42.35	45.53	42.31	44.64	1542300.0
2020-12-07	AGZ	ETF	119.49	119.54	119.4275	119.52	35756.0
2020-12-07	AGZD	ETF	23.56	23.64	23.56	23.56	26000.0
2020-12-07	AIA	ETF	85.18	85.534	85.14	85.39	318686.0
2020-12-07	AIEQ	ETF	34.69	34.97	34.69	34.9	21600.0
2020-12-07	AIQ	ETF	26.63	26.7299	26.6	26.71	46378.0
2020-12-07	AIRR	ETF	32.94	32.94	32.42	32.77	63400.0
2020-12-07	AIVI	ETF	40.09	40.12	40.05	40.05	21900.0
2020-12-07	ALTL	ETF	32.46	32.46	32.06	32.1738	4446.0
2020-12-07	ALTY	ETF	11.69	11.767	11.69	11.72	7000.0
2020-12-07	AMJ	ETF	15.25	15.25	14.86	15.06	903788.0
2020-12-07	AMLP	ETF	28.25	28.25	27.55	27.79	2690000.0
2020-12-07	AMNA	ETF	26.75	26.7809	26.75	26.7809	200.0
2020-12-07	AMND	ETF	28.6906	28.6906	28.6906	28.6906	0.0
2020-12-07	AMOM	ETF	38.61	38.8	38.61	38.773	3700.0
2020-12-07	AMTR	ETF	30.18	30.5	29.93	30.21	109375.0

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

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