PREVIEW / etf_daily / 2019-07-09

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-09.parquet
  size:    69 KB
  rows:    1,823

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-07-09	SPY	ETF	295.54	297.52	295.48	297.19	41101300.0
2019-07-09	QQQ	ETF	188.79	190.9	188.65	190.66	19193497.0
2019-07-09	IWM	ETF	154.54	155.43	154.48	155.4	12381600.0
2019-07-09	DIA	ETF	266.72	268.12	266.69	267.86	1407000.0
2019-07-09	GLD	ETF	131.43	132.1	131.16	131.75	6633400.0
2019-07-09	TLT	ETF	132.68	132.71	132.16	132.56	6215700.0
2019-07-09	AAAU	ETF	13.92	13.97	13.89	13.94	28000.0
2019-07-09	AADR	ETF	50.06	50.38	50.05	50.38	9300.0
2019-07-09	AAXJ	ETF	68.55	68.97	68.54	68.89	1780300.0
2019-07-09	ACES	ETF	30.1	30.27	30.1	30.234	7700.0
2019-07-09	ACSI	ETF	34.1867	34.2219	34.14	34.2219	1067.0
2019-07-09	ACTX	ETF	21.8302	30.0903	21.8302	29.5003	304.0
2019-07-09	ACWF	ETF	29.26	29.37	29.26	29.3437	2521.0
2019-07-09	ACWI	ETF	73.81	74.24	73.8	74.16	1650600.0
2019-07-09	ACWV	ETF	92.64	93.05	92.64	92.98	650600.0
2019-07-09	ACWX	ETF	46.45	46.61	46.41	46.58	1098732.0
2019-07-09	ADRE	ETF	39.56	39.9264	39.56	39.9	2134.0
2019-07-09	AFIF	ETF	9.891	9.897	9.87	9.8802	6195.0
2019-07-09	AFK	ETF	21.745	21.745	21.475	21.58	18234.0
2019-07-09	AFTY	ETF	17.32	17.356	17.3	17.352	4200.0
2019-07-09	AGG	ETF	111.04	111.06	110.95	111.0	2525800.0
2019-07-09	AGGY	ETF	51.29	51.29	51.21	51.25	108500.0
2019-07-09	AGNG	ETF	21.311	21.318	21.311	21.318	800.0
2019-07-09	AGQ	ETF	23.76	24.01	23.63	23.96	239200.0
2019-07-09	AGZ	ETF	114.84	114.84	114.7393	114.78	63741.0
2019-07-09	AGZD	ETF	23.905	23.935	23.875	23.91	12400.0
2019-07-09	AIA	ETF	59.9	60.32	59.9	60.29	25525.0
2019-07-09	AIEQ	ETF	26.32	26.72	26.32	26.69	31500.0
2019-07-09	AIQ	ETF	16.5	16.64	16.49	16.59	9929.0
2019-07-09	AIRR	ETF	26.11	26.14	26.0	26.1	11300.0
2019-07-09	AIVI	ETF	40.87	40.92	40.81	40.9	3800.0
2019-07-09	ALTY	ETF	15.0	15.03	14.94	14.971	4900.0
2019-07-09	AMJ	ETF	25.34	25.4299	25.17	25.31	667371.0
2019-07-09	AMLP	ETF	50.0	50.0	49.5	49.9	2073480.0
2019-07-09	AMUB	ETF	15.9576	15.9576	15.9576	15.9576	0.0
2019-07-09	AMZA	ETF	56.5	56.6	56.1	56.5	33500.0
2019-07-09	ANGL	ETF	29.11	29.17	29.1	29.13	178900.0
2019-07-09	AOA	ETF	54.66	54.84	54.62	54.84	66200.0
2019-07-09	AOK	ETF	35.19	35.23	35.158	35.19	44484.0
2019-07-09	AOM	ETF	38.8	38.8	38.68	38.75	75719.0
2019-07-09	AOR	ETF	45.58	45.73	45.57	45.73	87045.0
2019-07-09	ARGT	ETF	32.7	33.32	32.58	33.31	49100.0
2019-07-09	ARKF	ETF	22.63	23.077	22.63	23.07	26500.0
2019-07-09	ARKG	ETF	33.7	34.42	33.64	34.42	127900.0
2019-07-09	ARKK	ETF	47.08	48.25	47.08	48.25	235900.0
2019-07-09	ARKQ	ETF	32.91	33.38	32.91	33.37	20400.0
2019-07-09	ARKW	ETF	52.09	53.38	52.09	53.34	80400.0
2019-07-09	ASEA	ETF	16.6	16.64	16.59	16.64	51800.0
2019-07-09	ASET	ETF	29.71	29.748	29.71	29.748	667.0
2019-07-09	ASHR	ETF	27.64	27.83	27.64	27.81	4487500.0

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

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