PREVIEW / etf_daily / 2018-12-19

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-19.parquet
  size:    67 KB
  rows:    1,726

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
2018-12-19	SPY	ETF	255.17	259.4	249.35	251.26	214992800.0
2018-12-19	QQQ	ETF	158.24	160.72	153.34	154.53	81856456.0
2018-12-19	IWM	ETF	136.8	138.68	133.25	134.0	47676600.0
2018-12-19	DIA	ETF	237.55	241.2	232.07	233.42	9545700.0
2018-12-19	GLD	ETF	118.24	118.96	117.4	117.43	13827500.0
2018-12-19	TLT	ETF	120.11	121.66	119.92	121.18	23046300.0
2018-12-19	AAAU	ETF	12.51	12.57	12.42	12.42	16200.0
2018-12-19	AADR	ETF	41.39	41.77	40.55	40.83	122300.0
2018-12-19	AAXJ	ETF	64.04	64.48	62.41	62.86	2122100.0
2018-12-19	ACES	ETF	23.45	23.45	22.98	23.012	3300.0
2018-12-19	ACSI	ETF	30.23	30.35	29.6513	29.6513	2748.0
2018-12-19	ACTX	ETF	52.5105	57.5255	47.7904	49.5604	926.0
2018-12-19	ACWF	ETF	26.55	26.8018	25.93	26.09	199221.0
2018-12-19	ACWI	ETF	65.12	65.98	63.73	64.05	6191300.0
2018-12-19	ACWV	ETF	82.25	82.85	81.0	81.46	902400.0
2018-12-19	ACWX	ETF	42.44	42.72	41.6	41.74	5363416.0
2018-12-19	ADRE	ETF	36.8146	36.9299	35.84	35.8895	3905.0
2018-12-19	AFIF	ETF	9.9	9.91	9.88	9.885	20112.0
2018-12-19	AFK	ETF	20.01	20.2984	19.77	19.82	16017.0
2018-12-19	AFTY	ETF	13.78	13.785	13.33	13.48	23100.0
2018-12-19	AGG	ETF	105.88	106.17	105.79	105.94	7264800.0
2018-12-19	AGGY	ETF	48.14	48.24	48.13	48.13	251500.0
2018-12-19	AGNG	ETF	19.463	19.463	19.048	19.146	500.0
2018-12-19	AGQ	ETF	23.93	24.32	23.42	23.51	184800.0
2018-12-19	AGZ	ETF	111.54	111.65	111.41	111.5634	32994.0
2018-12-19	AGZD	ETF	23.76	24.755	23.75	23.87	31600.0
2018-12-19	AIA	ETF	55.41	55.742	53.995	54.28	152462.0
2018-12-19	AIEQ	ETF	24.16	24.64	23.628	23.761	50600.0
2018-12-19	AIQ	ETF	13.47	13.55	13.145	13.145	24039.0
2018-12-19	AIRR	ETF	22.07	22.3	21.4	21.53	108600.0
2018-12-19	AIVI	ETF	38.69	38.91	38.07	38.24	52600.0
2018-12-19	ALTY	ETF	13.716	13.73	13.675	13.675	4600.0
2018-12-19	AMJ	ETF	22.98	23.73	22.93	23.13	5192803.0
2018-12-19	AMLP	ETF	45.05	46.6	45.05	45.5	9425200.0
2018-12-19	AMUB	ETF	14.5644	14.5644	14.5644	14.5644	0.0
2018-12-19	AMZA	ETF	54.9	56.9	54.6	55.0	109290.0
2018-12-19	ANGL	ETF	27.16	27.39	26.92	26.98	443700.0
2018-12-19	AOA	ETF	49.38	49.77	48.66	48.87	432800.0
2018-12-19	AOK	ETF	33.0	33.05	32.77	32.85	216889.0
2018-12-19	AOM	ETF	36.05	36.22	35.81	35.89	790933.0
2018-12-19	AOR	ETF	41.88	42.08	41.35	41.52	709694.0
2018-12-19	ARGT	ETF	24.07	24.37	23.38	23.39	57900.0
2018-12-19	ARKG	ETF	25.85	26.485	25.02	25.28	97900.0
2018-12-19	ARKK	ETF	40.0	40.75	38.72	39.28	399000.0
2018-12-19	ARKQ	ETF	30.81	31.43	30.28	30.56	27900.0
2018-12-19	ARKW	ETF	49.62	50.56	48.111	48.57	244100.0
2018-12-19	ARVR	ETF	16.67	16.862	16.2943	16.2943	854.0
2018-12-19	ASEA	ETF	15.75	15.76	15.31	15.42	7700.0
2018-12-19	ASET	ETF	26.44	26.4441	26.07	26.084	4589.0
2018-12-19	ASHR	ETF	22.7	22.73	22.16	22.25	4349400.0

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

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