PREVIEW / etf_daily / 2021-01-05

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-05.parquet
  size:    84 KB
  rows:    2,217

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
2021-01-05	SPY	ETF	368.1	372.5	368.05	371.33	66426200.0
2021-01-05	QQQ	ETF	308.29	312.14	308.29	311.86	29323409.0
2021-01-05	IWM	ETF	193.09	197.62	193.07	196.49	27442900.0
2021-01-05	DIA	ETF	301.93	305.05	301.38	303.84	3355200.0
2021-01-05	GLD	ETF	182.87	183.21	181.82	182.87	12718800.0
2021-01-05	TLT	ETF	156.95	156.95	155.66	156.37	10458100.0
2021-01-05	AAA	ETF	25.08	25.0815	25.07	25.08	2326.0
2021-01-05	AAAU	ETF	19.42	19.44	19.31	19.41	607000.0
2021-01-05	AADR	ETF	61.56	62.17	61.56	61.82	8600.0
2021-01-05	AAXJ	ETF	91.47	92.72	91.47	92.65	1247700.0
2021-01-05	ABEQ	ETF	25.36	25.53	25.32	25.514	2400.0
2021-01-05	ACES	ETF	80.01	81.512	79.67	81.36	350200.0
2021-01-05	ACIO	ETF	27.52	27.739	27.52	27.66	60600.0
2021-01-05	ACSI	ETF	42.64	42.8495	42.64	42.8052	770.0
2021-01-05	ACTV	ETF	31.3801	31.73	31.3801	31.622	9161.0
2021-01-05	ACTX	ETF	2.5	2.5	2.5	2.5	237.0
2021-01-05	ACVF	ETF	27.43	27.62	27.424	27.56	3700.0
2021-01-05	ACWF	ETF	33.89	34.095	33.89	34.0	2149.0
2021-01-05	ACWI	ETF	90.32	91.31	90.27	91.15	1805800.0
2021-01-05	ACWV	ETF	96.52	96.99	96.28	96.9	337600.0
2021-01-05	ACWX	ETF	53.54	54.19	53.54	54.1	1296544.0
2021-01-05	ADME	ETF	35.93	35.93	35.59	35.75	46500.0
2021-01-05	ADRE	ETF	56.62	58.0	56.62	57.96	12489.0
2021-01-05	AESR	ETF	11.78	11.822	11.78	11.822	1400.0
2021-01-05	AFIF	ETF	9.77	9.78	9.7572	9.76	5484.0
2021-01-05	AFK	ETF	20.83	21.01	20.68	21.01	10275.0
2021-01-05	AFLG	ETF	22.05	22.22	22.021	22.175	13300.0
2021-01-05	AFMC	ETF	21.399	21.399	21.336	21.336	500.0
2021-01-05	AFSM	ETF	22.33	22.33	22.294	22.294	600.0
2021-01-05	AFTY	ETF	23.73	23.836	23.65	23.836	30000.0
2021-01-05	AGG	ETF	118.06	118.06	117.75	117.92	7477900.0
2021-01-05	AGGY	ETF	53.62	53.62	53.509	53.57	194200.0
2021-01-05	AGNG	ETF	27.75	28.04	27.75	28.04	3700.0
2021-01-05	AGQ	ETF	55.04	56.3	54.26	55.87	847500.0
2021-01-05	AGZ	ETF	119.67	119.67	119.48	119.61	41864.0
2021-01-05	AGZD	ETF	23.565	23.62	23.565	23.6	3800.0
2021-01-05	AIA	ETF	89.77	90.68	89.69	90.44	450595.0
2021-01-05	AIEQ	ETF	35.24	35.78	35.24	35.7	44300.0
2021-01-05	AIQ	ETF	26.95	27.34	26.9	27.34	43481.0
2021-01-05	AIRR	ETF	33.1	34.03	33.1	33.86	4900.0
2021-01-05	AIVI	ETF	40.88	41.28	40.88	41.18	4100.0
2021-01-05	ALTL	ETF	32.35	32.35	32.23	32.23	1751.0
2021-01-05	ALTY	ETF	11.55	11.68	11.55	11.654	8400.0
2021-01-05	AMJ	ETF	13.91	14.7	13.83	14.31	1226856.0
2021-01-05	AMLP	ETF	25.66	27.2	25.5	26.49	5340100.0
2021-01-05	AMNA	ETF	26.1396	26.1396	26.1396	26.1396	0.0
2021-01-05	AMND	ETF	27.8236	27.8236	27.8236	27.8236	0.0
2021-01-05	AMOM	ETF	31.31	31.972	31.31	31.972	2700.0
2021-01-05	AMTR	ETF	29.57	29.77	29.47	29.4718	2800.0
2021-01-05	AMUB	ETF	8.7441	9.22	8.7441	9.0244	13232.0

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

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