PREVIEW / etf_daily / 2019-03-28

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-28.parquet
  size:    68 KB
  rows:    1,753

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-03-28	SPY	ETF	280.35	281.21	279.07	280.71	56238500.0
2019-03-28	QQQ	ETF	178.36	178.98	177.24	178.31	30368235.0
2019-03-28	IWM	ETF	151.79	152.93	150.93	152.62	19473300.0
2019-03-28	DIA	ETF	256.92	257.28	255.59	257.08	2434400.0
2019-03-28	GLD	ETF	122.28	122.36	121.71	121.9	11878300.0
2019-03-28	TLT	ETF	126.25	126.69	126.01	126.56	9143200.0
2019-03-28	AAAU	ETF	12.94	12.94	12.88	12.9	13200.0
2019-03-28	AADR	ETF	44.52	44.9	44.52	44.85	11100.0
2019-03-28	AAXJ	ETF	69.82	69.95	69.56	69.95	861900.0
2019-03-28	ACES	ETF	27.01	27.052	26.945	26.971	1500.0
2019-03-28	ACSI	ETF	32.4629	32.47	32.4451	32.4451	649.0
2019-03-28	ACTX	ETF	52.5105	54.2805	50.1505	51.9205	421.0
2019-03-28	ACWF	ETF	28.73	28.905	28.69	28.83	41256.0
2019-03-28	ACWI	ETF	71.55	71.76	71.3	71.7	1878100.0
2019-03-28	ACWV	ETF	89.12	89.15	88.73	89.11	115600.0
2019-03-28	ACWX	ETF	45.98	46.03	45.81	46.0	861212.0
2019-03-28	ADRE	ETF	40.2772	40.5	40.2626	40.5	2705.0
2019-03-28	AFIF	ETF	9.99	10.01	9.97	9.99	12888.0
2019-03-28	AFK	ETF	21.243	21.25	21.1983	21.23	3942.0
2019-03-28	AFTY	ETF	16.12	16.23	16.12	16.18	8300.0
2019-03-28	AGG	ETF	109.06	109.14	108.96	109.08	6071000.0
2019-03-28	AGGY	ETF	49.86	49.925	49.845	49.92	63800.0
2019-03-28	AGNG	ETF	21.445	21.445	21.195	21.195	700.0
2019-03-28	AGQ	ETF	24.45	24.47	24.01	24.13	509700.0
2019-03-28	AGZ	ETF	113.61	113.6694	113.603	113.65	10486.0
2019-03-28	AGZD	ETF	23.835	23.855	23.805	23.835	15600.0
2019-03-28	AIA	ETF	60.57	60.7	60.3786	60.66	32980.0
2019-03-28	AIEQ	ETF	25.63	25.74	25.53	25.712	16500.0
2019-03-28	AIQ	ETF	15.505	15.5732	15.4741	15.52	5594.0
2019-03-28	AIRR	ETF	24.03	24.28	23.99	24.28	8600.0
2019-03-28	AIVI	ETF	41.14	41.14	40.92	41.01	108400.0
2019-03-28	ALTY	ETF	14.85	15.0	14.8	14.946	14000.0
2019-03-28	AMJ	ETF	25.25	25.41	25.105	25.36	608564.0
2019-03-28	AMLP	ETF	49.65	50.05	49.45	49.95	2739560.0
2019-03-28	AMUB	ETF	15.9743	15.9743	15.9743	15.9743	0.0
2019-03-28	AMZA	ETF	58.8	59.4	58.6	59.4	59760.0
2019-03-28	ANGL	ETF	28.74	28.74	28.63	28.64	203800.0
2019-03-28	AOA	ETF	53.24	53.3	53.06	53.29	50300.0
2019-03-28	AOK	ETF	34.45	34.46	34.3801	34.46	28505.0
2019-03-28	AOM	ETF	37.98	37.98	37.87	37.95	207953.0
2019-03-28	AOR	ETF	44.51	44.61	44.4167	44.6	70212.0
2019-03-28	ARCM	ETF	100.24	100.24	100.24	100.24	100.0
2019-03-28	ARGT	ETF	26.86	27.3	26.86	27.23	20500.0
2019-03-28	ARKF	ETF	21.28	21.399	21.18	21.362	28600.0
2019-03-28	ARKG	ETF	31.79	32.33	31.79	32.29	72400.0
2019-03-28	ARKK	ETF	45.77	46.263	45.482	46.14	205700.0
2019-03-28	ARKQ	ETF	33.53	33.93	33.5	33.73	23000.0
2019-03-28	ARKW	ETF	50.77	51.25	50.53	51.14	35800.0
2019-03-28	ASEA	ETF	15.72	15.84	15.72	15.73	2100.0
2019-03-28	ASET	ETF	28.88	28.96	28.82	28.95	1683.0

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

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