PREVIEW / etf_daily / 2019-09-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-09-12.parquet
  size:    70 KB
  rows:    1,827

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-09-12	SPY	ETF	301.25	302.46	300.41	301.29	72908700.0
2019-09-12	QQQ	ETF	193.64	194.71	192.97	193.23	28689878.0
2019-09-12	IWM	ETF	157.18	157.9	155.57	157.04	38648300.0
2019-09-12	DIA	ETF	272.62	273.44	271.46	272.32	3272200.0
2019-09-12	GLD	ETF	142.68	143.1	141.11	141.32	12673700.0
2019-09-12	TLT	ETF	141.5	141.8	139.06	139.52	19163300.0
2019-09-12	AAAU	ETF	15.11	15.14	14.95	14.96	110600.0
2019-09-12	AADR	ETF	49.59	49.79	49.42	49.42	4400.0
2019-09-12	AAXJ	ETF	68.31	68.78	68.07	68.45	1073300.0
2019-09-12	ACES	ETF	32.0	32.0	30.789	30.886	5000.0
2019-09-12	ACIO	ETF	25.16	25.33	25.16	25.248	14900.0
2019-09-12	ACSI	ETF	34.5786	34.69	34.5786	34.6091	981.0
2019-09-12	ACTX	ETF	21.8302	21.8302	20.0602	20.0602	30.0
2019-09-12	ACWF	ETF	29.3669	29.5349	29.3669	29.44	8464.0
2019-09-12	ACWI	ETF	74.46	74.76	74.24	74.58	1732400.0
2019-09-12	ACWV	ETF	94.28	94.62	94.21	94.23	399800.0
2019-09-12	ACWX	ETF	46.37	46.64	46.31	46.59	937901.0
2019-09-12	ADRE	ETF	39.65	39.7392	39.415	39.5227	8960.0
2019-09-12	AFIF	ETF	9.7306	9.735	9.7176	9.733	11585.0
2019-09-12	AFK	ETF	20.5	20.52	20.4544	20.52	4448.0
2019-09-12	AFTY	ETF	17.3	17.5	17.3	17.471	3200.0
2019-09-12	AGG	ETF	112.91	112.91	112.34	112.42	4069600.0
2019-09-12	AGGY	ETF	52.21	52.285	51.99	52.06	378700.0
2019-09-12	AGNG	ETF	21.495	21.608	21.394	21.608	7100.0
2019-09-12	AGQ	ETF	33.79	34.31	33.29	33.52	606100.0
2019-09-12	AGZ	ETF	116.31	116.31	115.8955	115.96	26804.0
2019-09-12	AGZD	ETF	23.875	23.975	23.875	23.905	282800.0
2019-09-12	AIA	ETF	60.06	60.48	59.9312	60.23	56416.0
2019-09-12	AIEQ	ETF	26.5	26.681	26.5	26.51	28000.0
2019-09-12	AIQ	ETF	16.41	16.5462	16.4	16.4402	7251.0
2019-09-12	AIRR	ETF	27.02	27.05	26.745	26.99	8800.0
2019-09-12	AIVI	ETF	41.03	41.26	41.03	41.23	32000.0
2019-09-12	ALTY	ETF	14.87	14.88	14.841	14.88	3000.0
2019-09-12	AMJ	ETF	23.35	23.44	23.2431	23.27	1073396.0
2019-09-12	AMLP	ETF	45.95	46.1	45.7	45.9	3795380.0
2019-09-12	AMOM	ETF	26.68	26.68	26.246	26.246	2000.0
2019-09-12	AMUB	ETF	14.6802	14.6802	14.6802	14.6802	0.0
2019-09-12	AMZA	ETF	50.0	50.1	49.3	49.4	76620.0
2019-09-12	ANGL	ETF	29.43	29.5	29.39	29.46	205200.0
2019-09-12	AOA	ETF	55.25	55.41	55.13	55.31	112500.0
2019-09-12	AOK	ETF	35.68	35.68	35.5801	35.6	42696.0
2019-09-12	AOM	ETF	39.32	39.36	39.235	39.29	83260.0
2019-09-12	AOR	ETF	46.2	46.29	46.13	46.22	92566.0
2019-09-12	ARGT	ETF	22.97	23.11	22.79	22.85	55100.0
2019-09-12	ARKF	ETF	22.15	22.22	22.039	22.061	7800.0
2019-09-12	ARKG	ETF	31.84	31.969	31.47	31.85	99500.0
2019-09-12	ARKK	ETF	45.71	45.89	45.267	45.5	269400.0
2019-09-12	ARKQ	ETF	33.57	33.67	33.214	33.49	10200.0
2019-09-12	ARKW	ETF	51.7	51.99	51.38	51.43	47600.0
2019-09-12	ASEA	ETF	16.26	16.36	16.16	16.16	1500.0

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

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