PREVIEW / etf_daily / 2019-01-22

all etf daily files

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

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-22	SPY	ETF	264.82	265.06	261.06	262.86	115531200.0
2019-01-22	QQQ	ETF	164.05	164.14	160.76	161.94	56711694.0
2019-01-22	IWM	ETF	146.46	146.76	144.05	145.0	27741100.0
2019-01-22	DIA	ETF	245.35	245.74	242.35	244.0	5218500.0
2019-01-22	GLD	ETF	121.18	121.5	120.9	121.45	7896500.0
2019-01-22	TLT	ETF	120.31	120.72	120.07	120.37	8881100.0
2019-01-22	AAAU	ETF	12.81	12.85	12.79	12.84	24200.0
2019-01-22	AADR	ETF	42.46	42.58	42.14	42.2	10600.0
2019-01-22	AAXJ	ETF	65.97	66.06	65.31	65.67	3533600.0
2019-01-22	ACES	ETF	24.5	24.5	24.245	24.245	600.0
2019-01-22	ACSI	ETF	31.0099	31.0099	30.6526	30.6618	711.0
2019-01-22	ACTX	ETF	47.2004	53.1005	47.2004	49.0884	617.0
2019-01-22	ACWF	ETF	27.67	27.6714	27.36	27.48	543266.0
2019-01-22	ACWI	ETF	67.67	67.76	66.94	67.33	7538200.0
2019-01-22	ACWV	ETF	83.64	83.76	82.98	83.42	390300.0
2019-01-22	ACWX	ETF	43.9	43.96	43.57	43.71	7500766.0
2019-01-22	ADRE	ETF	38.7278	38.7278	38.06	38.15	22641.0
2019-01-22	AFIF	ETF	9.94	9.97	9.92	9.9599	32726.0
2019-01-22	AFK	ETF	20.65	20.65	20.36	20.43	7452.0
2019-01-22	AFTY	ETF	14.07	14.07	13.931	13.931	3500.0
2019-01-22	AGG	ETF	106.44	106.62	106.44	106.44	6824000.0
2019-01-22	AGGY	ETF	48.38	48.4	48.32	48.35	86900.0
2019-01-22	AGNG	ETF	20.412	20.412	20.412	20.412	700.0
2019-01-22	AGQ	ETF	25.55	25.78	25.41	25.71	150000.0
2019-01-22	AGZ	ETF	112.01	112.03	111.9201	112.02	64007.0
2019-01-22	AGZD	ETF	23.6	23.695	23.44	23.615	114600.0
2019-01-22	AIA	ETF	57.52	57.59	57.08	57.26	64567.0
2019-01-22	AIEQ	ETF	24.1	24.128	23.69	23.85	68200.0
2019-01-22	AIQ	ETF	14.17	14.17	13.8601	13.92	9001.0
2019-01-22	AIRR	ETF	23.73	23.8	23.36	23.46	89600.0
2019-01-22	AIVI	ETF	39.24	39.28	38.96	39.05	27900.0
2019-01-22	ALTY	ETF	14.33	14.36	14.21	14.23	9900.0
2019-01-22	AMJ	ETF	24.82	24.89	24.285	24.36	3570626.0
2019-01-22	AMLP	ETF	48.9	49.2	47.85	47.95	5855060.0
2019-01-22	AMUB	ETF	15.3626	15.3626	15.3626	15.3626	6.0
2019-01-22	AMZA	ETF	57.9	58.2	56.9	57.1	89080.0
2019-01-22	ANGL	ETF	27.95	27.98	27.85	27.85	239500.0
2019-01-22	AOA	ETF	50.82	50.83	50.25	50.4	650800.0
2019-01-22	AOK	ETF	33.37	33.3999	33.22	33.27	637564.0
2019-01-22	AOM	ETF	36.55	36.56	36.34	36.38	785726.0
2019-01-22	AOR	ETF	42.68	42.68	42.3672	42.46	424520.0
2019-01-22	ARGT	ETF	26.26	26.26	25.75	25.86	36400.0
2019-01-22	ARKG	ETF	28.22	28.565	27.58	27.81	188800.0
2019-01-22	ARKK	ETF	42.12	42.12	40.888	41.11	417000.0
2019-01-22	ARKQ	ETF	31.64	31.64	30.7	30.87	24600.0
2019-01-22	ARKW	ETF	47.98	47.98	46.59	46.85	363500.0
2019-01-22	ASEA	ETF	16.01	16.01	15.73	15.76	5900.0
2019-01-22	ASET	ETF	27.04	27.04	26.8503	26.8503	966.0
2019-01-22	ASHR	ETF	23.19	23.22	23.02	23.07	2180800.0
2019-01-22	ASHS	ETF	23.25	23.3	23.18	23.19	14700.0

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

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