PREVIEW / etf_daily / 2020-07-30

all etf daily files

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

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-30	SPY	ETF	321.9	324.41	319.64	323.96	61861700.0
2020-07-30	QQQ	ETF	257.78	261.71	256.55	261.13	41774456.0
2020-07-30	IWM	ETF	147.14	149.12	146.33	148.76	23618900.0
2020-07-30	DIA	ETF	262.48	263.82	259.94	263.28	3055600.0
2020-07-30	GLD	ETF	183.44	184.33	182.13	183.76	18061200.0
2020-07-30	TLT	ETF	171.05	171.26	170.75	171.11	9376100.0
2020-07-30	AAAU	ETF	19.47	19.56	19.31	19.5	645300.0
2020-07-30	AADR	ETF	57.08	57.55	56.95	57.01	2900.0
2020-07-30	AAXJ	ETF	75.03	75.22	74.34	75.17	1319100.0
2020-07-30	ABEQ	ETF	23.098	23.24	23.098	23.22	6200.0
2020-07-30	ACES	ETF	45.0	45.21	44.8	45.01	64300.0
2020-07-30	ACIO	ETF	25.85	26.02	25.809	25.98	16200.0
2020-07-30	ACSI	ETF	35.427	35.427	35.427	35.427	107.0
2020-07-30	ACTX	ETF	2.95	2.95	2.1299	2.242	262.0
2020-07-30	ACWF	ETF	29.14	29.43	29.07	29.43	26090.0
2020-07-30	ACWI	ETF	77.34	77.97	76.8	77.9	1933100.0
2020-07-30	ACWV	ETF	90.6	91.36	90.33	91.28	800200.0
2020-07-30	ACWX	ETF	45.38	45.76	45.02	45.74	1349533.0
2020-07-30	ADME	ETF	33.39	33.49	33.113	33.434	26700.0
2020-07-30	ADRE	ETF	45.58	45.83	45.361	45.83	3208.0
2020-07-30	AESR	ETF	10.33	10.46	10.3	10.44	28800.0
2020-07-30	AFIF	ETF	9.84	9.86	9.84	9.845	38790.0
2020-07-30	AFK	ETF	17.22	17.35	17.0811	17.3291	4288.0
2020-07-30	AFLG	ETF	19.707	19.707	19.707	19.707	200.0
2020-07-30	AFSM	ETF	17.59	17.751	17.59	17.751	6100.0
2020-07-30	AFTY	ETF	18.48	18.587	18.48	18.573	5200.0
2020-07-30	AGG	ETF	119.51	119.54	119.45	119.51	3052800.0
2020-07-30	AGGY	ETF	54.44	54.6	54.43	54.47	221800.0
2020-07-30	AGNG	ETF	25.44	25.67	25.395	25.67	41600.0
2020-07-30	AGQ	ETF	45.59	46.96	44.28	45.91	2954700.0
2020-07-30	AGZ	ETF	121.88	121.88	121.6992	121.78	34265.0
2020-07-30	AGZD	ETF	23.555	23.595	23.505	23.55	49600.0
2020-07-30	AIA	ETF	70.18	70.39	69.55	70.33	86316.0
2020-07-30	AIEQ	ETF	29.84	30.29	29.801	30.2	12800.0
2020-07-30	AIQ	ETF	21.84	22.14	21.7	22.11	138103.0
2020-07-30	AIRR	ETF	24.825	24.921	24.683	24.875	3000.0
2020-07-30	AIVI	ETF	36.2	36.54	36.02	36.52	6700.0
2020-07-30	ALTL	ETF	24.75	25.06	24.75	25.0148	12162.0
2020-07-30	ALTY	ETF	10.77	10.77	10.68	10.758	8300.0
2020-07-30	AMJ	ETF	13.0	13.0	12.79	12.91	1004857.0
2020-07-30	AMLP	ETF	24.14	24.16	23.7	23.9	1095500.0
2020-07-30	AMNA	ETF	23.54	23.83	23.52	23.7701	67200.0
2020-07-30	AMND	ETF	25.09	25.09	24.89	25.04	17100.0
2020-07-30	AMOM	ETF	32.78	33.62	32.78	33.527	2700.0
2020-07-30	AMUB	ETF	8.31	8.31	8.12	8.1238	3082.0
2020-07-30	AMZA	ETF	17.29	17.29	16.93	17.08	42700.0
2020-07-30	ANGL	ETF	30.28	30.44	30.15	30.37	1081400.0
2020-07-30	AOA	ETF	56.5	56.97	56.37	56.93	115700.0
2020-07-30	AOK	ETF	37.16	37.23	37.02	37.23	109188.0
2020-07-30	AOM	ETF	40.81	40.89	40.58	40.75	120858.0

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

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