PREVIEW / etf_daily / 2019-01-09

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-09.parquet
  size:    67 KB
  rows:    1,736

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-01-09	SPY	ETF	257.56	258.91	256.19	257.97	95006600.0
2019-01-09	QQQ	ETF	160.15	161.5229	159.47	160.82	46491747.0
2019-01-09	IWM	ETF	142.22	143.39	141.62	142.9	25764600.0
2019-01-09	DIA	ETF	238.93	239.88	237.78	238.92	4872000.0
2019-01-09	GLD	ETF	121.45	122.34	121.44	122.31	10555900.0
2019-01-09	TLT	ETF	121.26	121.43	120.8	121.24	9349200.0
2019-01-09	AAAU	ETF	12.89	12.92	12.89	12.92	11600.0
2019-01-09	AADR	ETF	42.57	42.97	42.5	42.92	28200.0
2019-01-09	AAXJ	ETF	64.82	65.58	64.82	65.28	1094300.0
2019-01-09	ACES	ETF	24.05	24.156	24.05	24.135	6000.0
2019-01-09	ACSI	ETF	30.07	30.2371	30.07	30.1311	665.0
2019-01-09	ACTX	ETF	50.7405	54.2805	48.9704	48.9704	633.0
2019-01-09	ACWF	ETF	26.94	27.17	26.9149	27.03	95811.0
2019-01-09	ACWI	ETF	66.33	66.77	66.13	66.55	3461600.0
2019-01-09	ACWV	ETF	82.67	82.79	82.37	82.55	370100.0
2019-01-09	ACWX	ETF	43.4	43.72	43.36	43.58	1273448.0
2019-01-09	ADRE	ETF	38.0	38.568	38.0	38.4832	15268.0
2019-01-09	AFIF	ETF	9.92	9.97	9.27	9.925	22790.0
2019-01-09	AFK	ETF	20.1785	20.34	20.17	20.34	6550.0
2019-01-09	AFTY	ETF	13.65	13.65	13.59	13.646	8100.0
2019-01-09	AGG	ETF	106.42	106.57	106.4	106.52	5458100.0
2019-01-09	AGGY	ETF	48.31	48.448	48.31	48.42	64800.0
2019-01-09	AGNG	ETF	20.257	20.257	20.086	20.086	1000.0
2019-01-09	AGQ	ETF	26.9	27.33	26.83	27.27	107900.0
2019-01-09	AGZ	ETF	111.97	112.12	111.97	112.03	38568.0
2019-01-09	AGZD	ETF	23.725	23.81	23.67	23.765	19200.0
2019-01-09	AIA	ETF	56.4	56.99	56.39	56.69	104037.0
2019-01-09	AIEQ	ETF	23.03	23.258	23.0	23.19	40400.0
2019-01-09	AIQ	ETF	13.6829	13.75	13.6829	13.695	8002.0
2019-01-09	AIRR	ETF	23.188	23.195	22.961	23.13	22200.0
2019-01-09	AIVI	ETF	39.1	39.3	39.1	39.23	5300.0
2019-01-09	ALTY	ETF	14.18	14.18	13.99	14.01	7100.0
2019-01-09	AMJ	ETF	25.19	25.22	24.93	25.11	4074872.0
2019-01-09	AMLP	ETF	49.5	49.7	49.05	49.55	5462300.0
2019-01-09	AMUB	ETF	16.145	16.145	15.817	15.817	200.0
2019-01-09	AMZA	ETF	59.5	59.8	58.8	59.3	142970.0
2019-01-09	ANGL	ETF	27.73	27.85	27.68	27.83	509200.0
2019-01-09	AOA	ETF	49.88	50.12	49.8	50.04	149700.0
2019-01-09	AOK	ETF	33.01	33.18	33.01	33.14	75000.0
2019-01-09	AOM	ETF	36.13	36.31	36.13	36.26	327231.0
2019-01-09	AOR	ETF	42.13	42.2647	42.06	42.15	121062.0
2019-01-09	ARCM	ETF	99.73	99.755	99.73	99.755	9000.0
2019-01-09	ARGT	ETF	25.63	26.37	25.56	26.04	110500.0
2019-01-09	ARKG	ETF	27.22	28.08	27.153	27.93	144100.0
2019-01-09	ARKK	ETF	40.4	41.75	40.31	41.48	797800.0
2019-01-09	ARKQ	ETF	31.01	31.48	31.01	31.37	18900.0
2019-01-09	ARKW	ETF	45.71	46.598	45.66	46.33	191800.0
2019-01-09	ASEA	ETF	15.94	16.11	15.92	16.01	6900.0
2019-01-09	ASET	ETF	26.53	26.53	26.38	26.38	1301.0
2019-01-09	ASHR	ETF	22.7	22.9	22.66	22.87	1550100.0

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

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