PREVIEW / etf_daily / 2019-06-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-04.parquet
  size:    69 KB
  rows:    1,806

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
2019-06-04	SPY	ETF	277.12	280.68	276.62	280.53	77231900.0
2019-06-04	QQQ	ETF	171.98	174.97	171.37	174.91	47797848.0
2019-06-04	IWM	ETF	147.92	150.29	146.42	150.16	21217600.0
2019-06-04	DIA	ETF	250.73	253.7	250.51	253.65	3796100.0
2019-06-04	GLD	ETF	124.88	125.42	124.61	125.15	7997100.0
2019-06-04	TLT	ETF	131.39	131.76	130.55	130.93	14250000.0
2019-06-04	AAAU	ETF	13.2	13.24	13.2	13.24	59700.0
2019-06-04	AADR	ETF	46.62	47.08	46.62	47.08	8200.0
2019-06-04	AAXJ	ETF	66.08	66.57	66.02	66.5	1124400.0
2019-06-04	ACES	ETF	27.53	27.785	27.53	27.785	2300.0
2019-06-04	ACSI	ETF	32.2159	32.6309	32.2159	32.6309	3815.0
2019-06-04	ACTX	ETF	31.8603	31.8603	28.9103	29.3528	443.0
2019-06-04	ACWF	ETF	27.94	28.2399	27.94	28.2014	8541.0
2019-06-04	ACWI	ETF	70.67	71.36	70.52	71.36	4660300.0
2019-06-04	ACWV	ETF	90.4	90.6	89.94	90.54	233900.0
2019-06-04	ACWX	ETF	45.37	45.63	45.2711	45.61	1059979.0
2019-06-04	ADRE	ETF	38.3086	38.3424	38.2145	38.3366	3095.0
2019-06-04	AFIF	ETF	9.9	9.9	9.86	9.872	3873.0
2019-06-04	AFK	ETF	20.81	20.81	20.65	20.81	9596.0
2019-06-04	AFTY	ETF	16.116	16.206	16.097	16.199	3600.0
2019-06-04	AGG	ETF	110.28	110.38	110.13	110.3	5131700.0
2019-06-04	AGGY	ETF	50.63	50.68	50.53	50.58	270500.0
2019-06-04	AGNG	ETF	20.51	20.51	20.362	20.4	23400.0
2019-06-04	AGQ	ETF	23.01	23.32	22.91	23.26	215300.0
2019-06-04	AGZ	ETF	114.37	114.6699	114.37	114.65	25370.0
2019-06-04	AGZD	ETF	23.74	23.775	23.74	23.75	33600.0
2019-06-04	AIA	ETF	57.28	57.74	57.24	57.74	27593.0
2019-06-04	AIEQ	ETF	24.9	25.35	24.9	25.35	29400.0
2019-06-04	AIQ	ETF	15.0	15.31	15.0	15.3073	13965.0
2019-06-04	AIRR	ETF	24.29	24.88	24.29	24.88	7800.0
2019-06-04	AIVI	ETF	40.13	40.31	40.1	40.31	18000.0
2019-06-04	ALTY	ETF	14.64	14.67	14.619	14.66	4400.0
2019-06-04	AMJ	ETF	24.72	24.9	24.67	24.9	1425486.0
2019-06-04	AMLP	ETF	48.7	49.05	48.6	49.0	2763240.0
2019-06-04	AMOM	ETF	24.23	24.608	24.23	24.608	100.0
2019-06-04	AMUB	ETF	15.6696	15.6696	15.6696	15.6696	0.0
2019-06-04	AMZA	ETF	54.0	54.9	54.0	54.9	72460.0
2019-06-04	ANGL	ETF	28.26	28.51	28.26	28.45	643100.0
2019-06-04	AOA	ETF	52.71	53.13	52.61	53.13	40100.0
2019-06-04	AOK	ETF	34.56	34.6167	34.4601	34.6133	51550.0
2019-06-04	AOM	ETF	38.02	38.13	37.9	38.13	69692.0
2019-06-04	AOR	ETF	44.35	44.58	44.21	44.58	50846.0
2019-06-04	ARGT	ETF	28.14	28.52	28.1	28.52	22600.0
2019-06-04	ARKF	ETF	20.76	21.102	20.69	21.102	23300.0
2019-06-04	ARKG	ETF	29.67	29.99	29.21	29.99	196000.0
2019-06-04	ARKK	ETF	40.84	41.84	40.52	41.8	320400.0
2019-06-04	ARKQ	ETF	28.61	30.13	28.61	30.13	94500.0
2019-06-04	ARKW	ETF	46.89	48.06	46.71	48.06	275400.0
2019-06-04	ASEA	ETF	15.85	15.9	15.64	15.9	1700.0
2019-06-04	ASET	ETF	28.73	28.8117	28.73	28.805	605.0

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

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