PREVIEW / etf_daily / 2018-10-11

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-11.parquet
  size:    64 KB
  rows:    1,667

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-10-11	SPY	ETF	277.08	278.9	270.36	272.17	274840500.0
2018-10-11	QQQ	ETF	171.04	173.4	167.81	169.6	143084463.0
2018-10-11	IWM	ETF	155.81	157.32	153.51	153.57	68877400.0
2018-10-11	DIA	ETF	254.73	256.73	248.86	250.27	15270300.0
2018-10-11	GLD	ETF	114.2	116.04	114.09	115.78	26810900.0
2018-10-11	TLT	ETF	114.0	115.15	113.79	114.87	16086800.0
2018-10-11	AAAU	ETF	12.07	12.24	12.07	12.23	8800.0
2018-10-11	AADR	ETF	47.84	48.63	47.62	47.86	46200.0
2018-10-11	AAXJ	ETF	63.42	64.07	62.67	63.26	2910300.0
2018-10-11	ACES	ETF	23.577	23.577	23.577	23.577	600.0
2018-10-11	ACSI	ETF	32.82	32.9299	32.678	32.678	1749.0
2018-10-11	ACTX	ETF	126.8511	132.1612	113.871	120.9511	3147.0
2018-10-11	ACWF	ETF	28.89	29.015	28.45	28.45	60245.0
2018-10-11	ACWI	ETF	70.35	70.72	68.91	69.39	14971000.0
2018-10-11	ACWV	ETF	84.66	84.84	83.17	83.56	970900.0
2018-10-11	ACWX	ETF	44.81	45.06	44.12	44.43	1398710.0
2018-10-11	ADRE	ETF	37.65	38.0312	37.37	37.72	10366.0
2018-10-11	AFIF	ETF	10.0435	10.06	9.9701	10.05	15008.0
2018-10-11	AFK	ETF	20.27	20.375	20.2684	20.3266	5420.0
2018-10-11	AFTY	ETF	14.044	14.3	14.044	14.235	3900.0
2018-10-11	AGG	ETF	104.59	104.86	104.51	104.72	7053900.0
2018-10-11	AGGY	ETF	47.77	47.89	47.77	47.83	55300.0
2018-10-11	AGNG	ETF	20.7	20.771	20.41	20.41	7000.0
2018-10-11	AGQ	ETF	23.5	24.08	23.37	23.78	275100.0
2018-10-11	AGZ	ETF	110.2269	110.37	110.1811	110.32	37139.0
2018-10-11	AGZD	ETF	23.98	23.99	23.92	23.97	21200.0
2018-10-11	AIA	ETF	56.12	56.753	55.68	55.91	139519.0
2018-10-11	AIEQ	ETF	27.53	27.882	27.12	27.29	136100.0
2018-10-11	AIQ	ETF	14.24	14.2812	14.02	14.1765	9311.0
2018-10-11	AIRR	ETF	26.36	26.477	25.92	25.97	24500.0
2018-10-11	AIVI	ETF	40.67	40.67	40.11	40.21	8400.0
2018-10-11	ALTY	ETF	14.57	14.58	14.412	14.47	3500.0
2018-10-11	AMJ	ETF	27.4	27.594	27.025	27.12	2675704.0
2018-10-11	AMLP	ETF	53.3	53.7	52.55	52.7	3717220.0
2018-10-11	AMZA	ETF	74.0	74.2	72.6	72.9	122100.0
2018-10-11	ANGL	ETF	28.58	28.68	28.48	28.54	619700.0
2018-10-11	AOA	ETF	52.06	52.25	51.34	51.51	77000.0
2018-10-11	AOK	ETF	33.36	33.4168	33.14	33.26	116011.0
2018-10-11	AOM	ETF	36.69	36.77	36.43	36.54	152379.0
2018-10-11	AOR	ETF	43.33	43.4999	42.871	42.97	124363.0
2018-10-11	ARGT	ETF	24.93	25.05	24.42	24.42	73600.0
2018-10-11	ARKG	ETF	28.99	29.145	28.13	28.42	140000.0
2018-10-11	ARKK	ETF	41.06	41.75	40.33	40.7	1026800.0
2018-10-11	ARKQ	ETF	31.91	32.56	31.48	31.66	79200.0
2018-10-11	ARKW	ETF	50.33	51.406	49.67	50.27	273000.0
2018-10-11	ARVR	ETF	19.33	19.51	19.2352	19.2352	1229.0
2018-10-11	ASEA	ETF	15.15	15.35	15.15	15.25	2300.0
2018-10-11	ASET	ETF	26.77	26.77	26.77	26.77	147.0
2018-10-11	ASHR	ETF	22.97	23.4	22.9	23.13	5963300.0
2018-10-11	ASHS	ETF	23.15	23.25	22.86	23.25	19400.0

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

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