PREVIEW / etf_daily / 2020-08-12

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-12.parquet
  size:    78 KB
  rows:    2,059

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-08-12	SPY	ETF	335.44	338.28	335.41	337.44	53774400.0
2020-08-12	QQQ	ETF	267.37	272.84	267.37	271.86	38894272.0
2020-08-12	IWM	ETF	158.67	158.89	156.49	157.52	23378300.0
2020-08-12	DIA	ETF	279.84	280.74	278.72	280.04	2641600.0
2020-08-12	GLD	ETF	182.61	183.1	179.04	179.1	28660500.0
2020-08-12	TLT	ETF	165.7	166.07	164.99	165.59	11744800.0
2020-08-12	AAAU	ETF	19.36	19.42	19.01	19.03	582100.0
2020-08-12	AADR	ETF	57.06	57.64	57.06	57.42	1500.0
2020-08-12	AAXJ	ETF	76.81	77.44	76.72	77.2	725900.0
2020-08-12	ABEQ	ETF	23.587	23.61	23.544	23.544	2800.0
2020-08-12	ACES	ETF	49.45	50.2	49.025	49.835	59100.0
2020-08-12	ACIO	ETF	26.55	26.77	26.55	26.7	8200.0
2020-08-12	ACSI	ETF	37.75	37.75	37.75	37.75	421.0
2020-08-12	ACTX	ETF	2.3541	2.9441	2.3541	2.8999	420.0
2020-08-12	ACWF	ETF	30.27	30.31	30.2501	30.275	4329.0
2020-08-12	ACWI	ETF	80.14	80.73	80.14	80.53	1063700.0
2020-08-12	ACWV	ETF	92.42	92.8	92.21	92.42	378300.0
2020-08-12	ACWX	ETF	46.85	47.17	46.85	47.03	1197881.0
2020-08-12	ADME	ETF	33.752	34.005	33.752	33.929	2900.0
2020-08-12	ADRE	ETF	45.63	46.05	45.35	46.02	7089.0
2020-08-12	AESR	ETF	10.82	10.846	10.82	10.846	1600.0
2020-08-12	AFIF	ETF	9.84	9.85	9.825	9.8282	11007.0
2020-08-12	AFK	ETF	17.37	17.49	17.355	17.3995	5566.0
2020-08-12	AFLG	ETF	20.48	20.49	20.465	20.465	500.0
2020-08-12	AFMC	ETF	18.591	18.591	18.591	18.591	100.0
2020-08-12	AFSM	ETF	18.585	18.585	18.585	18.585	100.0
2020-08-12	AFTY	ETF	18.83	18.979	18.83	18.91	11300.0
2020-08-12	AGG	ETF	118.73	118.89	118.65	118.75	5524500.0
2020-08-12	AGGY	ETF	54.27	54.29	54.17	54.25	120600.0
2020-08-12	AGNG	ETF	25.654	25.69	25.63	25.63	1600.0
2020-08-12	AGQ	ETF	54.82	56.01	51.56	51.62	3741600.0
2020-08-12	AGZ	ETF	121.23	121.32	121.05	121.08	35727.0
2020-08-12	AGZD	ETF	23.615	23.63	23.55	23.615	77600.0
2020-08-12	AIA	ETF	72.23	72.625	72.2	72.5	73669.0
2020-08-12	AIEQ	ETF	30.17	30.43	30.1	30.29	22000.0
2020-08-12	AIQ	ETF	22.29	22.62	22.29	22.5396	23204.0
2020-08-12	AIRR	ETF	28.25	28.25	27.54	27.7	35100.0
2020-08-12	AIVI	ETF	37.75	37.94	37.74	37.78	6300.0
2020-08-12	ALTL	ETF	25.18	25.33	25.156	25.2841	4839.0
2020-08-12	ALTY	ETF	11.175	11.18	11.13	11.145	3900.0
2020-08-12	AMJ	ETF	13.92	14.135	13.92	13.99	937280.0
2020-08-12	AMLP	ETF	25.98	26.2	25.78	25.98	2743000.0
2020-08-12	AMNA	ETF	25.65	25.8	25.51	25.6787	37400.0
2020-08-12	AMND	ETF	27.15	27.15	27.1	27.1414	300.0
2020-08-12	AMOM	ETF	33.48	33.865	33.48	33.787	2500.0
2020-08-12	AMUB	ETF	8.83	8.85	8.76	8.82	34878.0
2020-08-12	AMZA	ETF	18.86	19.13	18.86	19.03	64500.0
2020-08-12	ANGL	ETF	30.45	30.62	30.39	30.45	1082800.0
2020-08-12	AOA	ETF	58.36	58.77	58.36	58.69	24200.0
2020-08-12	AOK	ETF	37.49	37.566	37.44	37.53	65502.0

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

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