PREVIEW / etf_daily / 2019-03-20

all etf daily files

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

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-20	SPY	ETF	282.16	283.5	280.32	281.55	84609200.0
2019-03-20	QQQ	ETF	179.06	180.86	178.24	179.76	50104996.0
2019-03-20	IWM	ETF	154.54	155.42	152.41	153.26	29463200.0
2019-03-20	DIA	ETF	258.46	259.17	256.55	257.29	4382600.0
2019-03-20	GLD	ETF	123.66	124.42	122.65	124.18	11304900.0
2019-03-20	TLT	ETF	121.74	122.85	121.73	122.68	10123700.0
2019-03-20	AAAU	ETF	13.08	13.15	12.99	13.12	5000.0
2019-03-20	AADR	ETF	46.27	46.61	46.03	46.61	6100.0
2019-03-20	AAXJ	ETF	70.79	71.54	70.34	71.05	1286000.0
2019-03-20	ACES	ETF	27.38	27.54	27.12	27.346	8400.0
2019-03-20	ACSI	ETF	32.459	32.459	32.3939	32.3939	2450.0
2019-03-20	ACTX	ETF	56.0505	56.0505	50.7405	51.9205	1234.0
2019-03-20	ACWF	ETF	29.28	29.32	29.021	29.18	6788.0
2019-03-20	ACWI	ETF	72.36	72.83	71.95	72.34	4063800.0
2019-03-20	ACWV	ETF	88.53	88.86	87.99	88.4	452200.0
2019-03-20	ACWX	ETF	46.65	47.11	46.48	46.84	1778914.0
2019-03-20	ADRE	ETF	41.61	41.8174	41.35	41.8174	1884.0
2019-03-20	AFIF	ETF	10.0003	10.02	10.0003	10.0126	53546.0
2019-03-20	AFK	ETF	21.84	21.9959	21.69	21.86	6650.0
2019-03-20	AFTY	ETF	16.73	16.76	16.62	16.714	8300.0
2019-03-20	AGG	ETF	107.71	108.09	107.67	108.06	4236200.0
2019-03-20	AGGY	ETF	49.29	49.48	49.25	49.47	64900.0
2019-03-20	AGNG	ETF	21.7	21.7	21.69	21.69	9200.0
2019-03-20	AGQ	ETF	25.5	26.02	25.07	25.83	186900.0
2019-03-20	AGZ	ETF	112.59	112.9372	112.59	112.92	13179.0
2019-03-20	AGZD	ETF	23.85	23.89	23.84	23.89	5200.0
2019-03-20	AIA	ETF	61.37	61.9139	61.02	61.58	87056.0
2019-03-20	AIEQ	ETF	25.95	26.05	25.8	25.9	29100.0
2019-03-20	AIQ	ETF	15.8	15.8	15.59	15.6997	20076.0
2019-03-20	AIRR	ETF	24.85	24.892	24.6	24.65	12000.0
2019-03-20	AIVI	ETF	41.81	42.25	41.77	42.07	119000.0
2019-03-20	ALTY	ETF	14.73	14.83	14.71	14.766	9500.0
2019-03-20	AMJ	ETF	25.65	25.94	25.5	25.7	1474792.0
2019-03-20	AMLP	ETF	50.5	51.1	50.2	50.5	4004120.0
2019-03-20	AMUB	ETF	16.1792	16.1792	16.1792	16.1792	0.0
2019-03-20	AMZA	ETF	60.2	60.9	59.5	60.3	85490.0
2019-03-20	ANGL	ETF	28.6	28.82	28.53	28.68	343400.0
2019-03-20	AOA	ETF	53.6	53.85	53.28	53.53	35700.0
2019-03-20	AOK	ETF	34.32	34.43	34.2341	34.39	54084.0
2019-03-20	AOM	ETF	37.87	38.04	37.7986	37.96	111133.0
2019-03-20	AOR	ETF	44.61	44.85	44.48	44.64	103783.0
2019-03-20	ARGT	ETF	28.61	29.06	28.46	28.86	46200.0
2019-03-20	ARKF	ETF	21.5	21.56	21.21	21.43	31800.0
2019-03-20	ARKG	ETF	32.8	33.37	32.661	33.04	156700.0
2019-03-20	ARKK	ETF	46.93	47.48	46.5	47.1	283300.0
2019-03-20	ARKQ	ETF	34.179	34.429	33.87	34.25	11500.0
2019-03-20	ARKW	ETF	51.97	52.3	51.353	51.98	71500.0
2019-03-20	ASEA	ETF	15.88	16.09	15.85	16.09	3900.0
2019-03-20	ASET	ETF	28.71	28.79	28.71	28.79	436.0
2019-03-20	ASHR	ETF	28.59	28.9	28.43	28.71	4187700.0

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

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