PREVIEW / etf_daily / 2019-06-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-03.parquet
  size:    70 KB
  rows:    1,810

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-03	SPY	ETF	275.31	276.55	273.09	274.57	96428000.0
2019-06-03	QQQ	ETF	173.52	173.95	169.27	170.12	75842290.0
2019-06-03	IWM	ETF	146.13	147.21	145.33	146.37	26554500.0
2019-06-03	DIA	ETF	248.34	249.61	247.04	248.5	5479600.0
2019-06-03	GLD	ETF	124.09	125.34	123.9	125.11	14173600.0
2019-06-03	TLT	ETF	131.91	132.58	131.55	132.44	17822400.0
2019-06-03	AAAU	ETF	13.13	13.26	13.12	13.24	35300.0
2019-06-03	AADR	ETF	46.31	46.73	46.31	46.52	9100.0
2019-06-03	AAXJ	ETF	66.39	66.68	66.24	66.37	1907800.0
2019-06-03	ACES	ETF	27.06	27.34	27.06	27.224	7700.0
2019-06-03	ACSI	ETF	31.8231	31.9123	31.8133	31.9123	3794.0
2019-06-03	ACTX	ETF	32.3323	35.2823	28.9693	29.5003	303.0
2019-06-03	ACWF	ETF	27.65	27.82	27.63	27.76	4695.0
2019-06-03	ACWI	ETF	70.18	71.78	69.89	70.22	6591200.0
2019-06-03	ACWV	ETF	89.7	90.16	89.54	90.08	429800.0
2019-06-03	ACWX	ETF	45.08	45.27	44.99	45.17	954496.0
2019-06-03	ADRE	ETF	37.88	37.955	37.85	37.93	6506.0
2019-06-03	AFIF	ETF	9.8888	9.92	9.88	9.905	32559.0
2019-06-03	AFK	ETF	20.72	21.0	20.72	20.77	35483.0
2019-06-03	AFTY	ETF	16.12	16.26	16.12	16.26	3300.0
2019-06-03	AGG	ETF	110.26	110.52	110.17	110.4	7137500.0
2019-06-03	AGGY	ETF	50.53	50.661	50.5	50.61	97600.0
2019-06-03	AGNG	ETF	20.286	20.371	20.274	20.371	1200.0
2019-06-03	AGQ	ETF	22.86	23.26	22.77	23.16	268000.0
2019-06-03	AGZ	ETF	114.65	114.8499	114.61	114.83	19421.0
2019-06-03	AGZD	ETF	23.765	23.77	23.73	23.75	17600.0
2019-06-03	AIA	ETF	57.63	57.86	57.5001	57.78	135738.0
2019-06-03	AIEQ	ETF	24.75	24.9	24.57	24.68	32200.0
2019-06-03	AIQ	ETF	15.25	15.25	14.87	14.87	19137.0
2019-06-03	AIRR	ETF	23.86	24.195	23.86	24.195	2900.0
2019-06-03	AIVI	ETF	39.6	39.77	39.56	39.77	3500.0
2019-06-03	ALTY	ETF	14.47	14.59	14.455	14.48	3200.0
2019-06-03	AMJ	ETF	24.54	24.74	24.44	24.62	860860.0
2019-06-03	AMLP	ETF	48.3	48.75	48.2	48.4	2468620.0
2019-06-03	AMOM	ETF	23.993	23.993	23.993	23.993	100.0
2019-06-03	AMUB	ETF	15.4633	15.4633	15.4633	15.4633	6.0
2019-06-03	AMZA	ETF	53.9	54.07	53.3	53.5	66760.0
2019-06-03	ANGL	ETF	28.33	28.39	28.16	28.24	724900.0
2019-06-03	AOA	ETF	52.38	52.55	52.27	52.38	42300.0
2019-06-03	AOK	ETF	34.44	34.5499	34.44	34.49	68740.0
2019-06-03	AOM	ETF	37.82	37.92	37.76	37.91	66315.0
2019-06-03	AOR	ETF	44.11	44.2396	44.02	44.18	71163.0
2019-06-03	ARCM	ETF	100.355	100.355	100.355	100.355	50000.0
2019-06-03	ARGT	ETF	28.28	28.44	27.99	28.15	64000.0
2019-06-03	ARKF	ETF	21.01	21.09	20.56	20.664	48400.0
2019-06-03	ARKG	ETF	29.2	29.52	28.93	29.17	231900.0
2019-06-03	ARKK	ETF	40.73	40.99	39.88	40.14	482800.0
2019-06-03	ARKQ	ETF	29.32	29.32	28.8	29.0	91200.0
2019-06-03	ARKW	ETF	47.59	47.879	45.96	46.29	485000.0
2019-06-03	ASEA	ETF	15.8	16.1	15.78	15.96	700.0

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

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