PREVIEW / etf_daily / 2019-02-08

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-08.parquet
  size:    67 KB
  rows:    1,749

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-02-08	SPY	ETF	268.75	270.58	267.83	270.47	75788900.0
2019-02-08	QQQ	ETF	166.73	168.59	166.57	168.56	29020747.0
2019-02-08	IWM	ETF	149.06	149.9	148.5	149.85	13463000.0
2019-02-08	DIA	ETF	250.51	251.37	249.13	251.32	2942300.0
2019-02-08	GLD	ETF	124.05	124.33	123.98	124.21	4235200.0
2019-02-08	TLT	ETF	122.26	122.47	122.07	122.35	5885400.0
2019-02-08	AAAU	ETF	13.12	13.14	13.11	13.14	17400.0
2019-02-08	AADR	ETF	43.73	44.13	43.68	44.12	15300.0
2019-02-08	AAXJ	ETF	67.97	68.3	67.8	68.24	782600.0
2019-02-08	ACES	ETF	25.67	25.705	25.588	25.682	4300.0
2019-02-08	ACSI	ETF	31.5301	31.6705	31.525	31.6705	1707.0
2019-02-08	ACTX	ETF	48.3804	49.5604	44.8404	48.9704	290.0
2019-02-08	ACWF	ETF	28.19	28.32	28.11	28.32	32279.0
2019-02-08	ACWI	ETF	68.74	69.03	68.43	69.03	3991200.0
2019-02-08	ACWV	ETF	85.25	85.68	85.21	85.59	265800.0
2019-02-08	ACWX	ETF	44.46	44.6	44.285	44.59	3015743.0
2019-02-08	ADRE	ETF	39.28	39.57	39.221	39.54	8650.0
2019-02-08	AFIF	ETF	10.0	10.0099	9.97	9.995	27361.0
2019-02-08	AFK	ETF	21.57	21.77	21.57	21.705	1341.0
2019-02-08	AFTY	ETF	14.561	14.631	14.561	14.631	1200.0
2019-02-08	AGG	ETF	107.17	107.38	107.17	107.34	4288600.0
2019-02-08	AGGY	ETF	49.01	49.02	48.96	49.01	29700.0
2019-02-08	AGNG	ETF	20.86	20.86	20.86	20.86	500.0
2019-02-08	AGQ	ETF	27.1	27.36	27.01	27.31	75000.0
2019-02-08	AGZ	ETF	112.28	112.35	112.25	112.32	64745.0
2019-02-08	AGZD	ETF	23.865	23.865	23.77	23.77	6400.0
2019-02-08	AIA	ETF	59.67	59.7699	59.29	59.65	21501.0
2019-02-08	AIEQ	ETF	24.7	24.872	24.65	24.82	23300.0
2019-02-08	AIQ	ETF	14.66	14.731	14.6503	14.731	1417.0
2019-02-08	AIRR	ETF	23.99	23.99	23.626	23.84	435400.0
2019-02-08	AIVI	ETF	39.59	39.74	39.59	39.74	3500.0
2019-02-08	ALTY	ETF	14.64	14.64	14.55	14.566	3200.0
2019-02-08	AMJ	ETF	24.52	24.7	24.09	24.45	3183028.0
2019-02-08	AMLP	ETF	48.3	48.6	47.45	48.25	3705220.0
2019-02-08	AMUB	ETF	15.3846	15.3846	15.3846	15.3846	1.0
2019-02-08	AMZA	ETF	57.6	57.8	56.0	57.3	88390.0
2019-02-08	ANGL	ETF	28.11	28.22	28.07	28.22	209200.0
2019-02-08	AOA	ETF	51.35	51.51	51.17	51.51	63700.0
2019-02-08	AOK	ETF	33.58	33.65	33.5763	33.65	47962.0
2019-02-08	AOM	ETF	36.93	37.0	36.871	37.0	213776.0
2019-02-08	AOR	ETF	43.15	43.28	43.05	43.28	165797.0
2019-02-08	ARGT	ETF	27.24	27.33	26.89	27.33	48600.0
2019-02-08	ARKF	ETF	20.0	20.21	19.95	20.19	18900.0
2019-02-08	ARKG	ETF	27.29	27.89	27.29	27.78	40300.0
2019-02-08	ARKK	ETF	42.15	43.04	42.13	42.99	292800.0
2019-02-08	ARKQ	ETF	33.09	33.35	32.84	33.277	14800.0
2019-02-08	ARKW	ETF	48.67	49.64	48.67	49.61	143900.0
2019-02-08	ASEA	ETF	16.0	16.0	15.92	16.0	3300.0
2019-02-08	ASET	ETF	27.71	27.76	27.66	27.76	3442.0
2019-02-08	ASHR	ETF	23.89	23.91	23.69	23.81	1901600.0

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

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