PREVIEW / etf_daily / 2018-11-06

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-06.parquet
  size:    63 KB
  rows:    1,657

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-06	SPY	ETF	273.32	275.3	273.25	275.12	60085900.0
2018-11-06	QQQ	ETF	168.93	171.19	168.72	170.24	34410390.0
2018-11-06	IWM	ETF	153.65	155.11	153.52	154.64	15572900.0
2018-11-06	DIA	ETF	254.53	256.38	254.33	256.23	2193300.0
2018-11-06	GLD	ETF	116.44	116.53	115.74	116.04	7270800.0
2018-11-06	TLT	ETF	112.6	112.73	112.33	112.37	3159900.0
2018-11-06	AAAU	ETF	12.31	12.31	12.24	12.26	13800.0
2018-11-06	AADR	ETF	47.31	47.63	47.26	47.42	16700.0
2018-11-06	AAXJ	ETF	65.23	65.56	65.18	65.5	393000.0
2018-11-06	ACES	ETF	24.735	24.735	24.63	24.65	5100.0
2018-11-06	ACSI	ETF	32.57	32.69	32.57	32.69	1871.0
2018-11-06	ACTX	ETF	83.7808	94.4008	81.4207	87.3208	1835.0
2018-11-06	ACWF	ETF	28.7301	28.8875	28.66	28.7201	28579.0
2018-11-06	ACWI	ETF	69.71	70.12	69.68	70.08	2304500.0
2018-11-06	ACWV	ETF	84.56	85.07	84.56	85.0	80000.0
2018-11-06	ACWX	ETF	44.79	44.99	44.77	44.98	1580913.0
2018-11-06	ADRE	ETF	38.44	38.7056	38.4	38.4	2662.0
2018-11-06	AFIF	ETF	10.06	10.0668	10.04	10.0614	12846.0
2018-11-06	AFK	ETF	20.82	21.42	20.76	20.76	3384.0
2018-11-06	AFTY	ETF	14.55	14.62	14.54	14.62	8400.0
2018-11-06	AGG	ETF	104.09	104.17	104.06	104.11	2619900.0
2018-11-06	AGGY	ETF	47.47	47.47	47.41	47.43	82800.0
2018-11-06	AGNG	ETF	20.277	20.277	20.277	20.277	400.0
2018-11-06	AGQ	ETF	23.69	23.81	23.44	23.56	75200.0
2018-11-06	AGZ	ETF	110.0696	110.1017	110.055	110.06	10781.0
2018-11-06	AGZD	ETF	23.8	23.855	23.745	23.785	91600.0
2018-11-06	AIA	ETF	57.25	57.47	57.1854	57.47	12820.0
2018-11-06	AIEQ	ETF	26.93	26.988	26.778	26.92	71700.0
2018-11-06	AIQ	ETF	14.1428	14.2	14.02	14.05	6028.0
2018-11-06	AIRR	ETF	25.23	25.71	25.23	25.68	11700.0
2018-11-06	AIVI	ETF	40.25	40.28	40.16	40.26	13000.0
2018-11-06	ALTY	ETF	14.51	14.517	14.51	14.515	500.0
2018-11-06	AMJ	ETF	25.66	25.87	25.45	25.85	1638365.0
2018-11-06	AMLP	ETF	50.25	50.45	49.6	50.3	2753140.0
2018-11-06	AMZA	ETF	64.9	65.0	63.7	64.7	93040.0
2018-11-06	ANGL	ETF	28.22	28.22	28.15	28.21	275700.0
2018-11-06	AOA	ETF	51.72	51.89	51.71	51.89	211500.0
2018-11-06	AOK	ETF	33.23	33.3199	33.19	33.28	108120.0
2018-11-06	AOM	ETF	36.57	36.68	36.52	36.64	135060.0
2018-11-06	AOR	ETF	43.11	43.26	43.0655	43.26	1040561.0
2018-11-06	ARGT	ETF	27.01	27.1	26.51	26.59	24500.0
2018-11-06	ARKG	ETF	29.82	30.17	29.535	29.75	100800.0
2018-11-06	ARKK	ETF	44.82	45.21	44.5	44.83	310500.0
2018-11-06	ARKQ	ETF	33.69	34.07	33.646	33.95	46500.0
2018-11-06	ARKW	ETF	54.35	55.08	54.07	54.5	75000.0
2018-11-06	ARVR	ETF	19.09	19.09	19.09	19.09	212.0
2018-11-06	ASEA	ETF	15.79	15.79	15.63	15.63	900.0
2018-11-06	ASET	ETF	26.8701	26.89	26.86	26.89	3441.0
2018-11-06	ASHR	ETF	23.8	23.89	23.71	23.77	1826200.0
2018-11-06	ASHS	ETF	23.54	23.56	23.48	23.54	5500.0

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

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