PREVIEW / etf_daily / 2019-08-29

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-29.parquet
  size:    70 KB
  rows:    1,833

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-08-29	SPY	ETF	291.72	293.16	290.61	292.58	57899400.0
2019-08-29	QQQ	ETF	187.37	188.4562	186.675	187.92	25427207.0
2019-08-29	IWM	ETF	148.15	149.29	147.96	149.11	18786300.0
2019-08-29	DIA	ETF	262.94	264.24	262.0	263.9	3740600.0
2019-08-29	GLD	ETF	145.4	145.49	143.28	144.12	14762500.0
2019-08-29	TLT	ETF	147.25	147.34	146.13	147.24	8884900.0
2019-08-29	AAAU	ETF	15.4	15.4	15.18	15.26	111200.0
2019-08-29	AADR	ETF	49.13	49.32	49.04	49.27	4300.0
2019-08-29	AAXJ	ETF	64.9	65.22	64.75	65.09	1779900.0
2019-08-29	ACES	ETF	30.75	30.75	30.587	30.683	2100.0
2019-08-29	ACIO	ETF	24.385	24.445	24.37	24.428	17200.0
2019-08-29	ACSI	ETF	33.2646	33.3322	33.2646	33.3322	520.0
2019-08-29	ACTX	ETF	20.6502	23.6002	20.6502	23.6002	349.0
2019-08-29	ACWF	ETF	28.3	28.35	28.2062	28.3021	9812.0
2019-08-29	ACWI	ETF	71.88	72.13	71.62	71.99	3962800.0
2019-08-29	ACWV	ETF	93.6	93.68	93.22	93.66	261800.0
2019-08-29	ACWX	ETF	44.6	44.69	44.46	44.62	1113492.0
2019-08-29	ADRE	ETF	37.64	37.9646	37.64	37.91	4597.0
2019-08-29	AFIF	ETF	9.63	9.65	9.61	9.6409	25881.0
2019-08-29	AFK	ETF	20.23	20.23	20.0102	20.015	13359.0
2019-08-29	AFTY	ETF	16.82	16.82	16.726	16.768	103800.0
2019-08-29	AGG	ETF	114.08	114.08	113.84	114.03	2671000.0
2019-08-29	AGGY	ETF	52.76	52.76	52.63	52.75	290700.0
2019-08-29	AGNG	ETF	21.5	21.5	21.391	21.391	400.0
2019-08-29	AGQ	ETF	35.6	35.79	33.69	34.48	1310100.0
2019-08-29	AGZ	ETF	117.34	117.34	117.12	117.21	17441.0
2019-08-29	AGZD	ETF	23.825	23.87	23.805	23.815	18200.0
2019-08-29	AIA	ETF	56.44	56.5942	56.3659	56.55	20156.0
2019-08-29	AIEQ	ETF	25.91	26.16	25.91	26.07	22000.0
2019-08-29	AIQ	ETF	15.9	16.0775	15.9	16.06	5507.0
2019-08-29	AIRR	ETF	24.86	25.026	24.86	24.97	7000.0
2019-08-29	AIVI	ETF	39.52	39.54	39.46	39.49	6700.0
2019-08-29	ALTY	ETF	14.63	14.675	14.61	14.673	4200.0
2019-08-29	AMJ	ETF	22.88	23.2	22.88	23.11	1015313.0
2019-08-29	AMLP	ETF	45.2	45.65	45.1	45.4	2737660.0
2019-08-29	AMOM	ETF	26.698	26.698	26.698	26.698	100.0
2019-08-29	AMUB	ETF	14.5563	14.5563	14.5563	14.5563	0.0
2019-08-29	AMZA	ETF	47.7	48.6	47.3	48.5	68840.0
2019-08-29	ANGL	ETF	29.4	29.46	29.34	29.38	780100.0
2019-08-29	AOA	ETF	53.77	53.91	53.63	53.89	40200.0
2019-08-29	AOK	ETF	35.53	35.58	35.5169	35.57	57985.0
2019-08-29	AOM	ETF	38.94	39.02	38.92	39.0	94239.0
2019-08-29	AOR	ETF	45.37	45.48	45.29	45.38	110352.0
2019-08-29	ARGT	ETF	22.99	23.15	22.59	22.79	276700.0
2019-08-29	ARKF	ETF	21.57	21.71	21.52	21.661	8600.0
2019-08-29	ARKG	ETF	31.61	31.64	31.26	31.55	75900.0
2019-08-29	ARKK	ETF	44.01	44.25	43.792	44.18	203300.0
2019-08-29	ARKQ	ETF	30.75	31.22	30.75	31.12	7100.0
2019-08-29	ARKW	ETF	49.38	50.133	49.38	49.94	38000.0
2019-08-29	ASEA	ETF	15.56	15.56	15.44	15.56	2800.0

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

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