PREVIEW / etf_daily / 2020-08-11

all etf daily files

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

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-11	SPY	ETF	336.85	337.54	332.01	332.8	69601100.0
2020-08-11	QQQ	ETF	269.1	270.44	264.63	265.19	43104323.0
2020-08-11	IWM	ETF	159.27	159.82	156.16	156.88	30359400.0
2020-08-11	DIA	ETF	280.9	281.78	276.47	277.19	4546400.0
2020-08-11	GLD	ETF	183.57	183.98	179.43	179.94	45355000.0
2020-08-11	TLT	ETF	167.17	167.49	165.88	167.11	19234200.0
2020-08-11	AAAU	ETF	19.44	19.52	19.04	19.08	1604500.0
2020-08-11	AADR	ETF	56.75	56.81	56.35	56.45	2400.0
2020-08-11	AAXJ	ETF	76.7	76.88	75.97	76.03	1507500.0
2020-08-11	ABEQ	ETF	23.625	23.655	23.526	23.526	20700.0
2020-08-11	ACES	ETF	50.49	50.49	48.64	48.73	51200.0
2020-08-11	ACIO	ETF	26.575	26.575	26.43	26.43	6300.0
2020-08-11	ACSI	ETF	37.73	37.73	37.35	37.35	1498.0
2020-08-11	ACTX	ETF	2.3541	2.8999	2.3541	2.8999	958.0
2020-08-11	ACWF	ETF	30.1406	30.2043	29.8496	29.8496	5251.0
2020-08-11	ACWI	ETF	80.16	80.25	79.12	79.28	3092900.0
2020-08-11	ACWV	ETF	92.1	92.22	91.13	91.27	703600.0
2020-08-11	ACWX	ETF	46.66	46.73	46.13	46.14	888593.0
2020-08-11	ADME	ETF	33.746	33.746	33.5	33.5	6500.0
2020-08-11	ADRE	ETF	45.62	45.75	45.195	45.195	8718.0
2020-08-11	AESR	ETF	11.57	11.57	10.665	10.665	8200.0
2020-08-11	AFIF	ETF	9.85	9.85	9.81	9.8384	16462.0
2020-08-11	AFK	ETF	17.16	17.4373	17.14	17.14	3305.0
2020-08-11	AFLG	ETF	20.179	20.179	20.179	20.179	100.0
2020-08-11	AFMC	ETF	18.61	18.61	18.44	18.44	100.0
2020-08-11	AFSM	ETF	18.73	18.73	18.395	18.395	7100.0
2020-08-11	AFTY	ETF	18.95	18.95	18.81	18.81	8900.0
2020-08-11	AGG	ETF	119.11	119.21	118.84	118.99	7809900.0
2020-08-11	AGGY	ETF	54.37	54.397	54.281	54.37	102000.0
2020-08-11	AGNG	ETF	25.6	25.62	25.377	25.377	3700.0
2020-08-11	AGQ	ETF	60.39	61.75	49.81	50.93	8606200.0
2020-08-11	AGZ	ETF	121.42	121.42	121.1881	121.21	38540.0
2020-08-11	AGZD	ETF	23.665	23.665	23.57	23.605	93200.0
2020-08-11	AIA	ETF	71.87	71.87	71.1	71.16	44526.0
2020-08-11	AIEQ	ETF	30.54	30.54	29.955	29.955	11300.0
2020-08-11	AIQ	ETF	22.46	22.54	22.1442	22.16	25702.0
2020-08-11	AIRR	ETF	27.95	28.2	27.769	27.769	54500.0
2020-08-11	AIVI	ETF	37.45	37.45	36.95	36.95	10700.0
2020-08-11	ALTL	ETF	25.29	25.31	24.863	24.863	17212.0
2020-08-11	ALTY	ETF	11.29	11.29	11.07	11.07	53200.0
2020-08-11	AMJ	ETF	14.0	14.26	13.78	13.8	1083507.0
2020-08-11	AMLP	ETF	26.15	26.46	25.53	25.63	2430900.0
2020-08-11	AMNA	ETF	25.75	25.82	25.3379	25.3379	24410.0
2020-08-11	AMND	ETF	26.85	26.85	26.773	26.773	200.0
2020-08-11	AMOM	ETF	33.79	33.79	32.949	32.949	3300.0
2020-08-11	AMUB	ETF	8.5	8.95	8.4	8.4	23552.0
2020-08-11	AMZA	ETF	19.25	19.49	18.601	18.69	129500.0
2020-08-11	ANGL	ETF	30.66	30.69	30.36	30.4	1251500.0
2020-08-11	AOA	ETF	58.4	58.57	57.89	57.95	29600.0
2020-08-11	AOK	ETF	37.44	37.559	37.33	37.38	163767.0

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

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