PREVIEW / etf_daily / 2019-08-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-15.parquet
  size:    71 KB
  rows:    1,857

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-15	SPY	ETF	284.88	285.64	282.39	284.65	99556600.0
2019-08-15	QQQ	ETF	183.11	183.59	181.16	182.55	36848178.0
2019-08-15	IWM	ETF	146.62	146.67	144.79	145.49	24202400.0
2019-08-15	DIA	ETF	256.24	256.95	253.93	256.36	4034800.0
2019-08-15	GLD	ETF	142.96	144.02	142.61	143.7	13467800.0
2019-08-15	TLT	ETF	145.95	148.6	145.58	147.31	23588700.0
2019-08-15	AAAU	ETF	15.14	15.23	15.1	15.21	92900.0
2019-08-15	AADR	ETF	48.42	48.42	48.11	48.38	10800.0
2019-08-15	AAXJ	ETF	63.49	63.65	63.15	63.4	1079300.0
2019-08-15	ACES	ETF	30.49	30.49	30.0	30.13	8300.0
2019-08-15	ACIO	ETF	24.11	24.12	24.02	24.05	13500.0
2019-08-15	ACSI	ETF	32.7532	32.7532	32.56	32.6	1699.0
2019-08-15	ACTX	ETF	23.6002	23.6002	21.8302	21.8361	54.0
2019-08-15	ACWF	ETF	27.5	27.559	27.37	27.5305	12304.0
2019-08-15	ACWI	ETF	70.33	70.47	69.82	70.28	3528000.0
2019-08-15	ACWV	ETF	91.38	91.93	91.21	91.76	300000.0
2019-08-15	ACWX	ETF	43.67	43.74	43.44	43.62	1867757.0
2019-08-15	ADRE	ETF	37.3	37.3	36.9585	37.15	3385.0
2019-08-15	AFIF	ETF	9.6499	9.66	9.63	9.66	32198.0
2019-08-15	AFK	ETF	19.57	19.7189	19.53	19.71	2687.0
2019-08-15	AFTY	ETF	16.46	16.5	16.41	16.44	8800.0
2019-08-15	AGG	ETF	113.39	113.91	113.37	113.76	2815600.0
2019-08-15	AGGY	ETF	52.49	52.68	52.44	52.59	126400.0
2019-08-15	AGNG	ETF	20.921	21.2	20.921	21.2	800.0
2019-08-15	AGQ	ETF	30.83	31.01	30.62	30.89	366200.0
2019-08-15	AGZ	ETF	117.24	117.24	116.9	117.12	35048.0
2019-08-15	AGZD	ETF	23.83	23.875	23.805	23.815	10800.0
2019-08-15	AIA	ETF	55.4	55.54	55.21	55.32	34963.0
2019-08-15	AIEQ	ETF	25.31	25.402	25.23	25.4	29800.0
2019-08-15	AIQ	ETF	15.451	15.55	15.438	15.4978	3618.0
2019-08-15	AIRR	ETF	24.575	24.575	24.42	24.55	4600.0
2019-08-15	AIVI	ETF	38.54	38.58	38.38	38.53	16200.0
2019-08-15	ALTY	ETF	14.5	14.51	14.43	14.46	7100.0
2019-08-15	AMJ	ETF	23.11	23.11	22.85	22.96	2907516.0
2019-08-15	AMLP	ETF	44.5	44.55	44.0	44.25	3760880.0
2019-08-15	AMOM	ETF	26.018	26.018	26.018	26.018	300.0
2019-08-15	AMUB	ETF	14.4686	14.4686	14.4686	14.4686	0.0
2019-08-15	AMZA	ETF	47.3	47.6	47.0	47.2	114780.0
2019-08-15	ANGL	ETF	28.62	28.73	28.6	28.73	412400.0
2019-08-15	AOA	ETF	52.77	52.87	52.56	52.82	47200.0
2019-08-15	AOK	ETF	35.11	35.27	35.11	35.27	44273.0
2019-08-15	AOM	ETF	38.46	38.58	38.4464	38.53	93483.0
2019-08-15	AOR	ETF	44.65	44.7799	44.555	44.76	87128.0
2019-08-15	ARCM	ETF	100.25	100.25	100.195	100.195	600.0
2019-08-15	ARGT	ETF	24.86	25.05	24.44	24.93	353100.0
2019-08-15	ARKF	ETF	20.95	20.96	20.75	20.913	12500.0
2019-08-15	ARKG	ETF	31.57	31.634	31.11	31.17	121000.0
2019-08-15	ARKK	ETF	43.89	43.89	43.13	43.56	344900.0
2019-08-15	ARKQ	ETF	29.79	29.87	29.635	29.78	8600.0
2019-08-15	ARKW	ETF	48.14	48.25	47.42	47.74	100400.0

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

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