PREVIEW / etf_daily / 2018-12-13

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-13.parquet
  size:    66 KB
  rows:    1,714

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-12-13	SPY	ETF	266.52	267.49	264.12	265.37	96662700.0
2018-12-13	QQQ	ETF	166.06	166.82	164.03	165.1	46377864.0
2018-12-13	IWM	ETF	145.24	145.69	142.54	142.77	23205400.0
2018-12-13	DIA	ETF	246.42	247.86	245.17	246.27	4455300.0
2018-12-13	GLD	ETF	117.54	117.62	117.26	117.53	4131800.0
2018-12-13	TLT	ETF	118.46	118.58	117.98	118.07	5564200.0
2018-12-13	AAAU	ETF	12.41	12.43	12.41	12.43	23100.0
2018-12-13	AADR	ETF	43.62	43.62	43.06	43.41	29400.0
2018-12-13	AAXJ	ETF	66.2	66.33	65.87	65.92	3135200.0
2018-12-13	ACES	ETF	24.95	24.95	24.862	24.862	6200.0
2018-12-13	ACSI	ETF	31.5151	31.5151	31.2952	31.2952	735.0
2018-12-13	ACTX	ETF	62.5406	62.5406	56.0505	59.5905	599.0
2018-12-13	ACWF	ETF	27.64	27.67	27.3704	27.47	137737.0
2018-12-13	ACWI	ETF	67.96	68.14	67.46	67.68	5521400.0
2018-12-13	ACWV	ETF	85.35	85.67	85.11	85.3	266500.0
2018-12-13	ACWX	ETF	43.67	43.76	43.4799	43.53	6005601.0
2018-12-13	ADRE	ETF	37.73	37.7978	37.6774	37.7497	1924.0
2018-12-13	AFIF	ETF	9.9637	9.99	9.96	9.97	24050.0
2018-12-13	AFK	ETF	20.89	20.89	20.3	20.3189	1266.0
2018-12-13	AFTY	ETF	14.395	14.455	14.39	14.41	2000.0
2018-12-13	AGG	ETF	105.59	105.65	105.53	105.53	5762500.0
2018-12-13	AGGY	ETF	47.83	47.9	47.828	47.85	168000.0
2018-12-13	AGNG	ETF	20.02	20.1	20.02	20.1	400.0
2018-12-13	AGQ	ETF	24.11	24.2	23.95	24.17	52200.0
2018-12-13	AGZ	ETF	111.247	111.2891	111.1609	111.212	10434.0
2018-12-13	AGZD	ETF	23.87	23.91	23.75	23.81	62200.0
2018-12-13	AIA	ETF	57.34	57.555	57.15	57.15	33228.0
2018-12-13	AIEQ	ETF	25.41	25.56	25.2	25.3	21600.0
2018-12-13	AIQ	ETF	14.11	14.11	13.87	13.92	13534.0
2018-12-13	AIRR	ETF	23.27	23.28	22.85	22.89	32200.0
2018-12-13	AIVI	ETF	39.28	39.38	39.2	39.24	17500.0
2018-12-13	ALTY	ETF	14.13	14.19	14.11	14.11	2800.0
2018-12-13	AMJ	ETF	23.98	24.6	23.98	24.54	3283912.0
2018-12-13	AMLP	ETF	47.0	48.3	46.9	48.2	6644380.0
2018-12-13	AMUB	ETF	15.4416	15.4416	15.4416	15.4416	0.0
2018-12-13	AMZA	ETF	59.4	60.58	58.8	60.4	108610.0
2018-12-13	ANGL	ETF	27.47	27.54	27.42	27.53	276100.0
2018-12-13	AOA	ETF	50.79	50.79	50.39	50.55	262900.0
2018-12-13	AOK	ETF	33.24	33.24	33.1	33.1	424945.0
2018-12-13	AOM	ETF	36.46	36.5164	36.31	36.4	723607.0
2018-12-13	AOR	ETF	42.56	42.67	42.4311	42.48	676970.0
2018-12-13	ARGT	ETF	25.3	25.3	24.98	24.98	25000.0
2018-12-13	ARKG	ETF	28.83	28.83	27.802	27.93	89000.0
2018-12-13	ARKK	ETF	43.59	43.59	42.46	42.64	275800.0
2018-12-13	ARKQ	ETF	32.7	32.75	32.129	32.249	10300.0
2018-12-13	ARKW	ETF	53.4	53.54	52.28	52.55	232900.0
2018-12-13	ARVR	ETF	17.235	17.235	17.235	17.235	115.0
2018-12-13	ASEA	ETF	15.77	15.84	15.68	15.77	4200.0
2018-12-13	ASET	ETF	26.92	26.96	26.8898	26.8898	690.0
2018-12-13	ASHR	ETF	23.37	23.47	23.31	23.44	2647100.0

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

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