PREVIEW / etf_daily / 2018-11-14

all etf daily files

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

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-11-14	SPY	ETF	274.16	274.61	268.45	270.2	125335900.0
2018-11-14	QQQ	ETF	168.09	168.7	164.25	165.2	75270714.0
2018-11-14	IWM	ETF	151.82	152.46	148.48	149.45	24549100.0
2018-11-14	DIA	ETF	255.02	255.29	249.67	250.91	5610300.0
2018-11-14	GLD	ETF	113.53	115.06	113.46	114.64	13950200.0
2018-11-14	TLT	ETF	113.48	114.52	113.3	114.09	8690800.0
2018-11-14	AAAU	ETF	12.0	12.15	11.99	12.11	7400.0
2018-11-14	AADR	ETF	45.58	45.63	44.75	45.02	13300.0
2018-11-14	AAXJ	ETF	64.88	65.09	64.16	64.68	916500.0
2018-11-14	ACES	ETF	24.04	24.04	24.04	24.04	100.0
2018-11-14	ACSI	ETF	33.16	33.16	32.71	32.71	2001.0
2018-11-14	ACTX	ETF	70.8006	79.6507	64.9006	72.5707	1972.0
2018-11-14	ACWF	ETF	28.75	28.75	28.27	28.39	16036.0
2018-11-14	ACWI	ETF	69.41	69.61	68.35	68.74	3351800.0
2018-11-14	ACWV	ETF	85.45	85.6	84.62	84.9	222600.0
2018-11-14	ACWX	ETF	44.44	44.48	43.93	44.22	2048006.0
2018-11-14	ADRE	ETF	37.55	37.605	37.39	37.5758	3874.0
2018-11-14	AFIF	ETF	10.0453	10.05	10.03	10.05	8796.0
2018-11-14	AFK	ETF	20.25	20.25	20.0343	20.06	6558.0
2018-11-14	AFTY	ETF	14.31	14.31	14.1	14.14	4500.0
2018-11-14	AGG	ETF	104.22	104.5	104.2	104.36	3395900.0
2018-11-14	AGGY	ETF	47.48	47.58	47.448	47.53	88600.0
2018-11-14	AGNG	ETF	19.75	19.75	19.75	19.75	200.0
2018-11-14	AGQ	ETF	21.92	22.47	21.92	22.3	111700.0
2018-11-14	AGZ	ETF	110.32	110.56	110.2754	110.5	705988.0
2018-11-14	AGZD	ETF	23.855	23.91	23.75	23.84	17400.0
2018-11-14	AIA	ETF	56.56	56.81	56.02	56.34	97758.0
2018-11-14	AIEQ	ETF	26.39	26.67	25.93	26.04	26400.0
2018-11-14	AIQ	ETF	13.8218	13.84	13.68	13.76	7059.0
2018-11-14	AIRR	ETF	25.04	25.22	24.78	24.88	118100.0
2018-11-14	AIVI	ETF	40.04	40.06	39.65	39.96	4600.0
2018-11-14	ALTY	ETF	14.54	14.582	14.5	14.514	6200.0
2018-11-14	AMJ	ETF	25.39	25.45	24.94	25.08	4092513.0
2018-11-14	AMLP	ETF	48.55	48.9	47.5	47.75	4598340.0
2018-11-14	AMZA	ETF	63.2	63.62	61.9	62.2	126670.0
2018-11-14	ANGL	ETF	27.77	27.83	27.62	27.67	464000.0
2018-11-14	AOA	ETF	51.58	51.67	50.9	51.18	149400.0
2018-11-14	AOK	ETF	33.16	33.31	33.1101	33.13	38189.0
2018-11-14	AOM	ETF	36.55	36.61	36.37	36.45	367546.0
2018-11-14	AOR	ETF	42.98	43.0899	42.6599	42.81	91596.0
2018-11-14	ARGT	ETF	25.13	25.43	25.05	25.43	6700.0
2018-11-14	ARKG	ETF	29.15	29.23	27.91	28.0	61100.0
2018-11-14	ARKK	ETF	43.63	43.994	42.39	42.59	180800.0
2018-11-14	ARKQ	ETF	33.45	33.65	32.94	33.1	10800.0
2018-11-14	ARKW	ETF	52.8	53.35	51.69	51.99	114900.0
2018-11-14	ARVR	ETF	17.7215	17.7215	17.51	17.51	871.0
2018-11-14	ASEA	ETF	15.36	15.47	15.36	15.47	800.0
2018-11-14	ASET	ETF	26.83	26.95	26.83	26.9127	898.0
2018-11-14	ASHR	ETF	23.6	23.62	23.31	23.37	1855600.0
2018-11-14	ASHS	ETF	24.28	24.28	24.04	24.16	12000.0

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

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