PREVIEW / etf_daily / 2020-07-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-29.parquet
  size:    77 KB
  rows:    2,047

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-07-29	SPY	ETF	322.12	325.73	322.08	325.12	48454200.0
2020-07-29	QQQ	ETF	258.33	260.66	257.91	259.77	27556884.0
2020-07-29	IWM	ETF	147.0	149.45	146.98	149.35	19864400.0
2020-07-29	DIA	ETF	264.19	266.07	263.8	265.5	1917900.0
2020-07-29	GLD	ETF	184.01	186.14	182.39	185.13	25640100.0
2020-07-29	TLT	ETF	170.05	170.39	168.98	169.99	6733700.0
2020-07-29	AAAU	ETF	19.57	19.75	19.37	19.64	694200.0
2020-07-29	AADR	ETF	57.91	58.21	57.74	58.07	2900.0
2020-07-29	AAXJ	ETF	75.21	75.97	75.21	75.82	681800.0
2020-07-29	ABEQ	ETF	23.3	23.47	23.3	23.397	26700.0
2020-07-29	ACES	ETF	45.27	45.56	45.1	45.407	109200.0
2020-07-29	ACIO	ETF	25.901	26.081	25.901	26.081	8300.0
2020-07-29	ACSI	ETF	35.28	35.5081	35.28	35.5081	941.0
2020-07-29	ACTX	ETF	3.186	3.186	2.1417	3.068	1289.0
2020-07-29	ACWF	ETF	29.3301	29.62	29.3301	29.5322	4947.0
2020-07-29	ACWI	ETF	77.83	78.58	77.81	78.41	911500.0
2020-07-29	ACWV	ETF	91.34	91.97	91.34	91.86	99900.0
2020-07-29	ACWX	ETF	46.04	46.365	45.9699	46.31	1075888.0
2020-07-29	ADME	ETF	33.375	33.455	33.375	33.427	7300.0
2020-07-29	ADRE	ETF	45.59	46.55	45.59	46.3855	77045.0
2020-07-29	AESR	ETF	10.43	10.478	10.41	10.452	112400.0
2020-07-29	AFIF	ETF	9.83	9.85	9.82	9.845	69033.0
2020-07-29	AFK	ETF	17.73	17.75	17.625	17.6549	1604.0
2020-07-29	AFLG	ETF	19.785	19.785	19.785	19.785	100.0
2020-07-29	AFSM	ETF	17.71	17.755	17.71	17.755	9800.0
2020-07-29	AFTY	ETF	18.75	18.8	18.75	18.784	1500.0
2020-07-29	AGG	ETF	119.3	119.43	119.24	119.42	9727900.0
2020-07-29	AGGY	ETF	54.43	54.45	54.35	54.43	179400.0
2020-07-29	AGNG	ETF	25.665	25.729	25.601	25.672	2000.0
2020-07-29	AGQ	ETF	50.03	52.69	45.85	49.5	4607900.0
2020-07-29	AGZ	ETF	121.73	121.8	121.64	121.75	35313.0
2020-07-29	AGZD	ETF	23.55	23.555	23.495	23.555	37000.0
2020-07-29	AIA	ETF	70.47	71.26	70.45	71.26	55500.0
2020-07-29	AIEQ	ETF	29.85	30.2	29.85	30.115	6800.0
2020-07-29	AIQ	ETF	21.93	22.1	21.85	22.06	37323.0
2020-07-29	AIRR	ETF	24.595	25.125	24.595	25.12	23900.0
2020-07-29	AIVI	ETF	36.92	37.14	36.91	37.07	4600.0
2020-07-29	ALTL	ETF	24.98	25.42	24.94	25.4157	11010.0
2020-07-29	ALTY	ETF	10.75	10.823	10.711	10.823	12900.0
2020-07-29	AMJ	ETF	12.8	13.23	12.76	13.18	1151943.0
2020-07-29	AMLP	ETF	23.8	24.55	23.63	24.49	1990200.0
2020-07-29	AMNA	ETF	23.49	24.18	23.44	24.17	15200.0
2020-07-29	AMND	ETF	24.92	25.4461	24.92	25.4461	3010.0
2020-07-29	AMOM	ETF	32.97	33.19	32.695	33.07	2900.0
2020-07-29	AMUB	ETF	8.21	8.32	8.21	8.2715	36506.0
2020-07-29	AMZA	ETF	16.98	17.626	16.89	17.49	45200.0
2020-07-29	ANGL	ETF	30.17	30.36	30.13	30.32	980400.0
2020-07-29	AOA	ETF	56.99	57.42	56.92	57.24	48500.0
2020-07-29	AOK	ETF	37.08	37.31	37.06	37.31	131427.0
2020-07-29	AOM	ETF	40.8	40.97	40.7701	40.95	134434.0

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

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