PREVIEW / etf_daily / 2018-10-05

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-05.parquet
  size:    63 KB
  rows:    1,636

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-05	SPY	ETF	289.69	290.27	286.22	287.82	105951700.0
2018-10-05	QQQ	ETF	182.39	182.97	178.43	180.15	83325630.0
2018-10-05	IWM	ETF	163.75	164.16	160.66	162.16	31240100.0
2018-10-05	DIA	ETF	266.34	266.62	262.9	264.32	7477100.0
2018-10-05	GLD	ETF	113.81	114.1	113.57	113.8	7994400.0
2018-10-05	TLT	ETF	113.39	113.72	112.62	113.04	18096500.0
2018-10-05	AAAU	ETF	12.02	12.04	12.01	12.01	4400.0
2018-10-05	AADR	ETF	51.88	51.88	50.96	51.2	63800.0
2018-10-05	AAXJ	ETF	66.85	66.9	65.97	66.51	1679000.0
2018-10-05	ACES	ETF	24.99	24.99	24.67	24.67	500.0
2018-10-05	ACSI	ETF	33.765	33.765	33.5	33.5	1968.0
2018-10-05	ACTX	ETF	106.201	106.201	77.2907	79.6507	3619.0
2018-10-05	ACWF	ETF	30.26	30.29	29.9511	30.02	8353.0
2018-10-05	ACWI	ETF	73.3	73.42	72.53	72.95	2577500.0
2018-10-05	ACWV	ETF	86.53	86.78	86.24	86.51	158200.0
2018-10-05	ACWX	ETF	46.55	46.61	46.1731	46.39	518977.0
2018-10-05	ADRE	ETF	39.1109	39.38	39.04	39.38	2269.0
2018-10-05	AFIF	ETF	10.064	10.0734	10.0206	10.0603	6274.0
2018-10-05	AFK	ETF	20.88	21.0667	20.63	20.81	4627.0
2018-10-05	AFTY	ETF	14.61	14.85	14.61	14.767	7100.0
2018-10-05	AGG	ETF	104.46	104.48	104.19	104.33	3460500.0
2018-10-05	AGGY	ETF	47.8	47.81	47.7	47.725	43900.0
2018-10-05	AGNG	ETF	21.93	21.939	21.54	21.54	2100.0
2018-10-05	AGQ	ETF	24.2	24.35	23.93	24.09	200300.0
2018-10-05	AGZ	ETF	110.01	110.0983	109.93	110.0	20659.0
2018-10-05	AGZD	ETF	23.925	24.0	23.915	24.0	6200.0
2018-10-05	AIA	ETF	59.39	59.42	58.6377	59.15	116939.0
2018-10-05	AIEQ	ETF	29.14	29.229	28.675	28.85	128600.0
2018-10-05	AIQ	ETF	15.3601	15.49	15.1425	15.31	26524.0
2018-10-05	AIRR	ETF	27.57	27.57	27.11	27.22	22600.0
2018-10-05	AIVI	ETF	41.43	41.45	41.2	41.3	5000.0
2018-10-05	ALTY	ETF	14.82	14.89	14.771	14.771	17600.0
2018-10-05	AMJ	ETF	27.82	28.185	27.81	27.95	1352935.0
2018-10-05	AMLP	ETF	54.1	54.55	53.9	54.1	2136360.0
2018-10-05	AMZA	ETF	75.8	76.3	75.55	75.9	51290.0
2018-10-05	ANGL	ETF	28.81	28.83	28.64	28.69	489800.0
2018-10-05	AOA	ETF	54.0	54.0	53.35	53.6	94500.0
2018-10-05	AOK	ETF	33.77	33.8086	33.62	33.68	37753.0
2018-10-05	AOM	ETF	37.3	37.3749	37.12	37.23	70213.0
2018-10-05	AOR	ETF	44.5	44.52	44.12	44.21	128943.0
2018-10-05	ARGT	ETF	26.12	26.57	25.87	25.98	35600.0
2018-10-05	ARKG	ETF	30.59	31.12	29.65	30.3	233100.0
2018-10-05	ARKK	ETF	44.69	45.06	43.17	43.98	459800.0
2018-10-05	ARKQ	ETF	35.252	35.252	34.07	34.33	27300.0
2018-10-05	ARKW	ETF	55.68	56.045	54.145	54.91	267100.0
2018-10-05	ARVR	ETF	20.75	20.75	20.75	20.75	231.0
2018-10-05	ASEA	ETF	15.77	15.77	15.59	15.6	5600.0
2018-10-05	ASET	ETF	27.45	27.45	27.3398	27.38	1915.0
2018-10-05	ASHR	ETF	24.28	24.57	24.23	24.54	3749300.0
2018-10-05	ASHS	ETF	24.58	24.58	24.41	24.57	5800.0

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

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