PREVIEW / etf_daily / 2019-06-06

all etf daily files

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

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-06	SPY	ETF	283.29	285.55	282.57	284.8	69430400.0
2019-06-06	QQQ	ETF	176.52	178.04	175.73	177.61	29913205.0
2019-06-06	IWM	ETF	150.12	150.52	148.31	149.8	20772500.0
2019-06-06	DIA	ETF	256.12	258.35	255.53	257.72	2796200.0
2019-06-06	GLD	ETF	125.93	126.45	125.8	125.88	5551800.0
2019-06-06	TLT	ETF	130.97	131.59	130.32	130.61	9621100.0
2019-06-06	AAAU	ETF	13.33	13.38	13.31	13.32	253300.0
2019-06-06	AADR	ETF	47.17	47.29	47.02	47.15	9000.0
2019-06-06	AAXJ	ETF	66.15	66.33	65.95	66.22	1049500.0
2019-06-06	ACES	ETF	27.98	27.98	27.79	27.944	2200.0
2019-06-06	ACSI	ETF	32.86	33.0075	32.75	33.0075	1466.0
2019-06-06	ACTX	ETF	27.1402	29.5003	27.1402	27.7302	209.0
2019-06-06	ACWF	ETF	28.3	28.36	28.22	28.36	5354.0
2019-06-06	ACWI	ETF	71.7	72.11	71.53	71.99	2228900.0
2019-06-06	ACWV	ETF	91.44	91.84	91.27	91.65	367700.0
2019-06-06	ACWX	ETF	45.63	45.76	45.55	45.65	515746.0
2019-06-06	ADRE	ETF	37.82	37.992	37.8	37.992	3738.0
2019-06-06	AFIF	ETF	9.9301	9.9455	9.91	9.93	6254.0
2019-06-06	AFK	ETF	20.75	20.76	20.75	20.76	3307.0
2019-06-06	AFTY	ETF	15.94	16.07	15.94	16.04	4700.0
2019-06-06	AGG	ETF	110.34	110.42	110.16	110.22	2660400.0
2019-06-06	AGGY	ETF	50.59	50.69	50.555	50.59	87700.0
2019-06-06	AGNG	ETF	20.545	20.545	20.545	20.545	100.0
2019-06-06	AGQ	ETF	23.54	23.64	23.34	23.36	187300.0
2019-06-06	AGZ	ETF	114.71	114.7639	114.571	114.62	11652.0
2019-06-06	AGZD	ETF	23.79	23.79	23.745	23.75	3000.0
2019-06-06	AIA	ETF	57.35	57.5851	57.3211	57.45	30520.0
2019-06-06	AIEQ	ETF	25.51	25.7	25.45	25.7	37000.0
2019-06-06	AIQ	ETF	15.41	15.495	15.3896	15.495	2606.0
2019-06-06	AIRR	ETF	25.01	25.01	24.71	24.9	5700.0
2019-06-06	AIVI	ETF	40.44	40.59	40.42	40.5	16400.0
2019-06-06	ALTY	ETF	14.675	14.77	14.57	14.695	6200.0
2019-06-06	AMJ	ETF	24.56	24.73	24.56	24.69	632446.0
2019-06-06	AMLP	ETF	48.45	48.75	48.35	48.75	3576180.0
2019-06-06	AMUB	ETF	15.5524	15.5524	15.5524	15.5524	341.0
2019-06-06	AMZA	ETF	54.1	54.6	54.0	54.4	55430.0
2019-06-06	ANGL	ETF	28.5	28.7	28.45	28.65	733000.0
2019-06-06	AOA	ETF	53.28	53.51	53.21	53.46	30000.0
2019-06-06	AOK	ETF	34.7	34.732	34.62	34.71	58617.0
2019-06-06	AOM	ETF	38.22	38.2776	38.12	38.24	63171.0
2019-06-06	AOR	ETF	44.7	44.83	44.6305	44.79	53505.0
2019-06-06	ARGT	ETF	28.69	28.89	28.68	28.84	24900.0
2019-06-06	ARKF	ETF	21.37	21.546	21.307	21.546	6500.0
2019-06-06	ARKG	ETF	30.0	30.0	29.42	29.56	117300.0
2019-06-06	ARKK	ETF	42.32	42.37	41.82	42.13	725600.0
2019-06-06	ARKQ	ETF	30.17	30.326	30.03	30.22	15900.0
2019-06-06	ARKW	ETF	48.23	48.645	47.94	48.5	88500.0
2019-06-06	ASEA	ETF	16.22	16.22	15.99	16.11	1500.0
2019-06-06	ASET	ETF	29.19	29.2501	29.19	29.2501	479.0
2019-06-06	ASHR	ETF	25.86	26.14	25.8	26.08	6091600.0

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

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