PREVIEW / etf_daily / 2019-03-19

all etf daily files

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

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-19	SPY	ETF	283.51	284.36	281.41	282.4	90268100.0
2019-03-19	QQQ	ETF	179.16	180.0	178.29	179.05	36893341.0
2019-03-19	IWM	ETF	156.48	156.53	154.57	154.96	18633100.0
2019-03-19	DIA	ETF	260.11	260.96	258.0	258.88	4761400.0
2019-03-19	GLD	ETF	123.72	123.79	123.34	123.38	6558700.0
2019-03-19	TLT	ETF	121.09	121.62	120.89	121.41	5220200.0
2019-03-19	AAAU	ETF	13.09	13.09	13.05	13.06	2200.0
2019-03-19	AADR	ETF	46.26	46.45	46.15	46.3	16100.0
2019-03-19	AAXJ	ETF	71.07	71.26	70.83	71.08	1144000.0
2019-03-19	ACES	ETF	27.306	27.33	27.306	27.33	15200.0
2019-03-19	ACSI	ETF	32.7701	32.8591	32.6048	32.6048	2059.0
2019-03-19	ACTX	ETF	52.5105	52.5105	51.0355	51.9205	505.0
2019-03-19	ACWF	ETF	29.4497	29.5268	29.27	29.33	11016.0
2019-03-19	ACWI	ETF	72.72	72.88	72.29	72.52	4977800.0
2019-03-19	ACWV	ETF	88.68	88.91	88.3	88.48	227900.0
2019-03-19	ACWX	ETF	46.96	47.04	46.7315	46.82	783797.0
2019-03-19	ADRE	ETF	41.772	41.93	41.73	41.7425	3226.0
2019-03-19	AFIF	ETF	10.0	10.03	10.0	10.016	14785.0
2019-03-19	AFK	ETF	21.8473	21.86	21.84	21.84	2803.0
2019-03-19	AFTY	ETF	16.65	16.727	16.65	16.653	7600.0
2019-03-19	AGG	ETF	107.58	107.71	107.53	107.62	2928300.0
2019-03-19	AGGY	ETF	49.24	49.29	49.19	49.27	126700.0
2019-03-19	AGNG	ETF	21.8	21.902	21.69	21.825	3000.0
2019-03-19	AGQ	ETF	25.54	25.61	25.33	25.39	76200.0
2019-03-19	AGZ	ETF	112.5	112.59	112.5	112.56	14916.0
2019-03-19	AGZD	ETF	23.85	23.905	23.835	23.905	14800.0
2019-03-19	AIA	ETF	61.81	61.83	61.51	61.59	91248.0
2019-03-19	AIEQ	ETF	26.1	26.172	25.911	25.98	40300.0
2019-03-19	AIQ	ETF	15.72	15.7602	15.66	15.7343	37281.0
2019-03-19	AIRR	ETF	25.26	25.386	24.903	24.93	306300.0
2019-03-19	AIVI	ETF	42.19	42.21	41.97	42.05	6800.0
2019-03-19	ALTY	ETF	14.78	14.85	14.76	14.8	17300.0
2019-03-19	AMJ	ETF	25.54	25.81	25.51	25.6	1159096.0
2019-03-19	AMLP	ETF	50.25	50.85	50.15	50.35	3490340.0
2019-03-19	AMUB	ETF	16.06	16.1152	16.06	16.1152	200.0
2019-03-19	AMZA	ETF	60.7	61.5	60.6	60.9	85850.0
2019-03-19	ANGL	ETF	28.57	28.62	28.54	28.58	238800.0
2019-03-19	AOA	ETF	53.83	53.85	53.49	53.55	48700.0
2019-03-19	AOK	ETF	34.37	34.39	34.2601	34.31	149493.0
2019-03-19	AOM	ETF	37.94	37.98	37.84	37.85	93922.0
2019-03-19	AOR	ETF	44.72	44.7933	44.57	44.6	97289.0
2019-03-19	ARCM	ETF	100.17	100.17	100.17	100.17	100.0
2019-03-19	ARGT	ETF	29.05	29.25	28.63	28.66	29700.0
2019-03-19	ARKF	ETF	21.57	21.6	21.45	21.52	66100.0
2019-03-19	ARKG	ETF	33.02	33.09	32.625	32.86	159700.0
2019-03-19	ARKK	ETF	47.02	47.26	46.656	46.98	349300.0
2019-03-19	ARKQ	ETF	34.18	34.48	34.16	34.26	16000.0
2019-03-19	ARKW	ETF	51.83	52.11	51.72	51.9	139100.0
2019-03-19	ASEA	ETF	15.94	15.99	15.92	15.99	1300.0
2019-03-19	ASET	ETF	28.9	28.9	28.8	28.8	1055.0

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

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