PREVIEW / etf_daily / 2020-02-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-27.parquet
  size:    76 KB
  rows:    1,969

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-02-27	SPY	ETF	305.46	311.56	297.51	297.51	284353500.0
2020-02-27	QQQ	ETF	211.05	216.4235	205.5	205.64	121822562.0
2020-02-27	IWM	ETF	151.35	155.01	148.82	149.06	50530300.0
2020-02-27	DIA	ETF	264.86	267.73	257.39	257.5	11188900.0
2020-02-27	GLD	ETF	155.58	156.27	153.9	154.0	27878500.0
2020-02-27	TLT	ETF	152.7	153.08	150.83	151.88	30687900.0
2020-02-27	AAAU	ETF	16.49	16.55	16.32	16.32	146400.0
2020-02-27	AADR	ETF	51.29	51.9	50.64	50.64	12200.0
2020-02-27	AAXJ	ETF	69.0	69.45	68.19	68.28	1803500.0
2020-02-27	ABEQ	ETF	23.551	23.68	23.227	23.227	7000.0
2020-02-27	ACES	ETF	38.16	38.679	36.772	37.19	90200.0
2020-02-27	ACIO	ETF	24.25	24.44	24.04	24.307	13000.0
2020-02-27	ACSI	ETF	34.2499	34.3816	33.6879	33.6879	1442.0
2020-02-27	ACTX	ETF	6.8264	7.3391	6.8264	7.0801	143.0
2020-02-27	ACWF	ETF	29.0	29.4	28.53	28.53	16394.0
2020-02-27	ACWI	ETF	74.38	75.23	72.84	73.03	10056300.0
2020-02-27	ACWV	ETF	93.78	94.39	91.46	91.46	781700.0
2020-02-27	ACWX	ETF	45.17	45.6	44.55	44.55	3774570.0
2020-02-27	ADME	ETF	30.36	30.42	30.07	30.08	14800.0
2020-02-27	ADRE	ETF	40.24	40.7839	39.621	40.0217	12250.0
2020-02-27	AFIF	ETF	9.81	9.82	9.8	9.8	8126.0
2020-02-27	AFK	ETF	18.13	18.19	18.0	18.03	16356.0
2020-02-27	AFLG	ETF	18.854	18.854	18.854	18.854	100.0
2020-02-27	AFSM	ETF	18.21	18.21	18.21	18.21	100.0
2020-02-27	AFTY	ETF	16.32	16.455	16.22	16.32	7100.0
2020-02-27	AGG	ETF	115.75	115.75	115.35	115.37	11606400.0
2020-02-27	AGGY	ETF	53.6	53.6	53.43	53.43	610600.0
2020-02-27	AGNG	ETF	22.94	23.4	22.711	22.8	9700.0
2020-02-27	AGQ	ETF	31.54	31.68	30.31	30.33	577100.0
2020-02-27	AGZ	ETF	118.58	118.59	118.23	118.48	30298.0
2020-02-27	AGZD	ETF	23.97	23.97	23.74	23.89	13400.0
2020-02-27	AIA	ETF	62.66	62.86	61.82	61.98	75339.0
2020-02-27	AIEQ	ETF	27.12	27.597	26.61	26.61	67600.0
2020-02-27	AIQ	ETF	17.78	17.902	17.41	17.4334	57097.0
2020-02-27	AIRR	ETF	26.16	26.808	26.02	26.03	25600.0
2020-02-27	AIVI	ETF	38.68	38.86	38.1	38.1	11700.0
2020-02-27	ALTY	ETF	14.17	14.17	13.7	13.725	36200.0
2020-02-27	AMJ	ETF	18.0	18.058	17.13	17.5	8083878.0
2020-02-27	AMLP	ETF	34.0	34.15	32.4	33.15	12270880.0
2020-02-27	AMOM	ETF	24.889	24.889	24.889	24.889	100.0
2020-02-27	AMUB	ETF	11.51	11.51	10.89	11.0337	36821.0
2020-02-27	AMZA	ETF	31.3	32.0	29.6	30.6	302680.0
2020-02-27	ANGL	ETF	29.56	29.84	29.16	29.51	2179500.0
2020-02-27	AOA	ETF	55.11	55.6	54.22	54.22	136100.0
2020-02-27	AOK	ETF	36.02	36.15	35.87	35.87	239897.0
2020-02-27	AOM	ETF	39.55	39.7498	39.25	39.25	457590.0
2020-02-27	AOR	ETF	46.22	46.5499	45.73	45.73	191620.0
2020-02-27	ARCM	ETF	100.15	100.15	100.1	100.15	30600.0
2020-02-27	ARGT	ETF	23.72	23.83	22.98	23.16	22800.0
2020-02-27	ARKF	ETF	24.75	25.366	24.4	24.41	92100.0

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

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