PREVIEW / etf_daily / 2019-02-11

all etf daily files

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

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-11	SPY	ETF	271.2	271.49	270.03	270.62	68021400.0
2019-02-11	QQQ	ETF	169.14	169.58	167.98	168.4	21434088.0
2019-02-11	IWM	ETF	150.29	151.15	149.63	151.1	16374800.0
2019-02-11	DIA	ETF	252.12	252.32	250.35	250.94	2677600.0
2019-02-11	GLD	ETF	123.19	123.82	123.19	123.6	4821800.0
2019-02-11	TLT	ETF	121.86	122.18	121.75	121.87	4352800.0
2019-02-11	AAAU	ETF	13.03	13.09	13.03	13.08	53000.0
2019-02-11	AADR	ETF	43.95	44.02	43.84	43.93	8100.0
2019-02-11	AAXJ	ETF	68.49	68.5	68.17	68.19	715100.0
2019-02-11	ACES	ETF	25.795	25.95	25.795	25.95	17000.0
2019-02-11	ACSI	ETF	31.92	31.92	31.7201	31.84	47263.0
2019-02-11	ACTX	ETF	48.9704	48.9704	46.0204	47.2004	428.0
2019-02-11	ACWF	ETF	28.3312	28.37	28.2921	28.34	7330.0
2019-02-11	ACWI	ETF	69.12	69.18	68.82	68.94	2323100.0
2019-02-11	ACWV	ETF	85.75	85.75	85.41	85.5	170300.0
2019-02-11	ACWX	ETF	44.56	44.6366	44.42	44.47	1236514.0
2019-02-11	ADRE	ETF	39.54	39.54	39.3721	39.3721	976.0
2019-02-11	AFIF	ETF	9.9907	10.01	9.97	10.01	29636.0
2019-02-11	AFK	ETF	21.92	21.92	21.6399	21.6955	5680.0
2019-02-11	AFTY	ETF	14.941	14.95	14.91	14.92	2300.0
2019-02-11	AGG	ETF	107.23	107.28	107.15	107.23	3521000.0
2019-02-11	AGGY	ETF	48.98	48.99	48.91	48.98	152000.0
2019-02-11	AGNG	ETF	20.976	20.976	20.885	20.885	2900.0
2019-02-11	AGQ	ETF	26.81	27.1	26.8	26.88	59400.0
2019-02-11	AGZ	ETF	112.12	112.23	112.12	112.16	19134.0
2019-02-11	AGZD	ETF	23.865	23.87	23.78	23.795	27600.0
2019-02-11	AIA	ETF	59.98	59.98	59.71	59.78	78064.0
2019-02-11	AIEQ	ETF	24.93	25.04	24.88	24.98	149000.0
2019-02-11	AIQ	ETF	14.85	14.87	14.8214	14.87	1177.0
2019-02-11	AIRR	ETF	23.92	24.01	23.75	24.01	56400.0
2019-02-11	AIVI	ETF	39.64	39.71	39.62	39.68	4100.0
2019-02-11	ALTY	ETF	14.57	14.638	14.57	14.603	8600.0
2019-02-11	AMJ	ETF	24.28	24.525	24.27	24.48	2631831.0
2019-02-11	AMLP	ETF	48.0	48.35	47.8	48.25	2888080.0
2019-02-11	AMUB	ETF	15.4343	15.4343	15.4343	15.4343	0.0
2019-02-11	AMZA	ETF	57.1	57.3	56.5	57.2	65840.0
2019-02-11	ANGL	ETF	28.2	28.25	28.14	28.19	238800.0
2019-02-11	AOA	ETF	51.54	51.61	51.4	51.59	506700.0
2019-02-11	AOK	ETF	33.66	33.6999	33.6302	33.65	68011.0
2019-02-11	AOM	ETF	37.02	37.04	36.94	36.99	215064.0
2019-02-11	AOR	ETF	43.27	43.3	43.18	43.25	377649.0
2019-02-11	ARGT	ETF	27.29	27.58	27.19	27.46	24600.0
2019-02-11	ARKF	ETF	20.37	20.439	20.26	20.28	88400.0
2019-02-11	ARKG	ETF	27.83	28.31	27.83	28.13	74500.0
2019-02-11	ARKK	ETF	43.16	43.735	43.136	43.42	185800.0
2019-02-11	ARKQ	ETF	33.62	33.76	33.37	33.65	25100.0
2019-02-11	ARKW	ETF	49.98	50.26	49.51	49.65	68800.0
2019-02-11	ASEA	ETF	15.88	15.94	15.88	15.94	2900.0
2019-02-11	ASHR	ETF	24.46	24.5	24.39	24.45	1789100.0
2019-02-11	ASHS	ETF	23.75	23.97	23.75	23.97	61500.0

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

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