PREVIEW / etf_daily / 2019-07-10

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-10.parquet
  size:    70 KB
  rows:    1,828

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-10	SPY	ETF	298.37	299.66	297.78	298.61	58448500.0
2019-07-10	QQQ	ETF	191.79	193.09	191.47	192.56	28374513.0
2019-07-10	IWM	ETF	156.2	156.56	154.85	155.67	17325400.0
2019-07-10	DIA	ETF	268.84	269.88	268.17	268.69	1978600.0
2019-07-10	GLD	ETF	132.94	133.87	132.35	133.83	13920600.0
2019-07-10	TLT	ETF	132.35	132.44	131.51	131.83	9470000.0
2019-07-10	AAAU	ETF	14.07	14.17	14.04	14.15	23200.0
2019-07-10	AADR	ETF	50.67	50.98	50.51	50.63	10500.0
2019-07-10	AAXJ	ETF	69.49	69.67	69.21	69.3	2141000.0
2019-07-10	ACES	ETF	30.5	30.5	30.13	30.28	6500.0
2019-07-10	ACIO	ETF	25.12	25.1599	25.04	25.1162	170139.0
2019-07-10	ACSI	ETF	34.3301	34.3351	34.2	34.2562	1500.0
2019-07-10	ACTX	ETF	29.5003	30.0903	26.6269	27.732	115.0
2019-07-10	ACWF	ETF	29.4799	29.48	29.3967	29.4244	3090.0
2019-07-10	ACWI	ETF	74.52	74.76	74.33	74.54	3731800.0
2019-07-10	ACWV	ETF	93.41	93.53	93.22	93.42	234700.0
2019-07-10	ACWX	ETF	46.88	46.99	46.7811	46.83	3140307.0
2019-07-10	ADRE	ETF	40.37	40.4406	40.14	40.15	4553.0
2019-07-10	AFIF	ETF	9.87	9.885	9.86	9.885	9051.0
2019-07-10	AFK	ETF	21.71	21.91	21.71	21.87	8997.0
2019-07-10	AFTY	ETF	17.41	17.48	17.41	17.455	3000.0
2019-07-10	AGG	ETF	111.14	111.16	110.97	111.08	4589800.0
2019-07-10	AGGY	ETF	51.26	51.27	51.175	51.26	141400.0
2019-07-10	AGNG	ETF	21.587	21.587	21.587	21.587	700.0
2019-07-10	AGQ	ETF	24.42	24.45	23.98	24.39	343300.0
2019-07-10	AGZ	ETF	114.8	114.88	114.7349	114.8556	13569.0
2019-07-10	AGZD	ETF	23.915	23.93	23.895	23.91	14400.0
2019-07-10	AIA	ETF	60.86	61.04	60.69	60.72	27108.0
2019-07-10	AIEQ	ETF	26.78	26.909	26.769	26.78	23700.0
2019-07-10	AIQ	ETF	16.62	16.7993	16.62	16.685	13077.0
2019-07-10	AIRR	ETF	26.21	26.21	25.91	25.91	55500.0
2019-07-10	AIVI	ETF	41.06	41.12	40.97	41.06	7000.0
2019-07-10	ALTY	ETF	14.99	15.11	14.99	15.07	4900.0
2019-07-10	AMJ	ETF	25.45	25.75	25.41	25.64	1264657.0
2019-07-10	AMLP	ETF	50.1	50.7	50.1	50.4	3504280.0
2019-07-10	AMOM	ETF	26.465	26.465	26.465	26.465	100.0
2019-07-10	AMUB	ETF	16.1694	16.1694	16.1694	16.1694	0.0
2019-07-10	AMZA	ETF	56.7	57.7	56.7	57.4	56290.0
2019-07-10	ANGL	ETF	29.15	29.23	29.12	29.16	430200.0
2019-07-10	AOA	ETF	55.07	55.15	54.91	55.03	67400.0
2019-07-10	AOK	ETF	35.3	35.3	35.25	35.3	87288.0
2019-07-10	AOM	ETF	38.86	38.93	38.85	38.88	134238.0
2019-07-10	AOR	ETF	45.86	45.93	45.76	45.85	244839.0
2019-07-10	ARGT	ETF	33.62	33.85	33.15	33.72	287500.0
2019-07-10	ARKF	ETF	23.13	23.26	23.126	23.14	9300.0
2019-07-10	ARKG	ETF	34.67	34.94	34.25	34.52	380900.0
2019-07-10	ARKK	ETF	48.58	48.95	48.316	48.58	173800.0
2019-07-10	ARKQ	ETF	33.54	33.768	33.42	33.52	34100.0
2019-07-10	ARKW	ETF	53.75	54.122	53.503	53.63	108100.0
2019-07-10	ASEA	ETF	17.0	17.0	16.7	16.71	600.0

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

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