PREVIEW / etf_daily / 2018-12-06

all etf daily files

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

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-06	SPY	ETF	265.92	269.97	262.44	269.84	204185400.0
2018-12-06	QQQ	ETF	162.46	166.91	161.77	166.89	71715526.0
2018-12-06	IWM	ETF	145.45	147.2	143.43	147.2	37581200.0
2018-12-06	DIA	ETF	246.36	249.87	242.82	249.72	8232800.0
2018-12-06	GLD	ETF	117.38	117.69	116.92	117.14	9267600.0
2018-12-06	TLT	ETF	118.54	119.2	118.13	118.19	15319400.0
2018-12-06	AAAU	ETF	12.65	14.85	12.36	12.37	28200.0
2018-12-06	AADR	ETF	43.19	43.63	42.93	43.63	77400.0
2018-12-06	AAXJ	ETF	65.02	66.07	64.65	66.02	2513500.0
2018-12-06	ACES	ETF	24.778	25.21	24.59	25.15	11300.0
2018-12-06	ACSI	ETF	31.97	31.97	31.7399	31.87	1767.0
2018-12-06	ACTX	ETF	61.3606	62.5406	53.6905	57.2305	1159.0
2018-12-06	ACWF	ETF	27.59	27.9	27.3428	27.87	210350.0
2018-12-06	ACWI	ETF	67.5	68.45	66.77	68.45	9554700.0
2018-12-06	ACWV	ETF	85.02	85.64	84.06	85.63	422500.0
2018-12-06	ACWX	ETF	43.27	43.68	42.8	43.64	5480933.0
2018-12-06	ADRE	ETF	37.47	37.945	37.1939	37.945	6303.0
2018-12-06	AFIF	ETF	9.41	10.01	9.41	10.01	55638.0
2018-12-06	AFK	ETF	20.42	20.5	19.85	20.48	27634.0
2018-12-06	AFTY	ETF	14.13	14.3	14.13	14.3	4900.0
2018-12-06	AGG	ETF	105.29	105.54	105.28	105.34	7396800.0
2018-12-06	AGGY	ETF	47.73	47.83	47.674	47.78	108700.0
2018-12-06	AGNG	ETF	20.29	20.34	20.29	20.34	10600.0
2018-12-06	AGQ	ETF	23.14	23.29	23.01	23.29	75000.0
2018-12-06	AGZ	ETF	111.18	111.39	111.1683	111.21	67559.0
2018-12-06	AGZD	ETF	23.71	23.785	23.685	23.78	81200.0
2018-12-06	AIA	ETF	56.33	57.3499	56.051	57.2	68734.0
2018-12-06	AIEQ	ETF	25.53	25.91	25.2	25.91	55100.0
2018-12-06	AIQ	ETF	13.68	13.8717	13.58	13.8717	2238.0
2018-12-06	AIRR	ETF	23.35	23.71	23.15	23.71	30900.0
2018-12-06	AIVI	ETF	38.75	39.05	38.51	39.03	10000.0
2018-12-06	ALTY	ETF	14.42	14.42	14.08	14.27	15900.0
2018-12-06	AMJ	ETF	24.12	24.37	23.73	24.36	6020646.0
2018-12-06	AMLP	ETF	47.0	47.45	46.2	47.4	6119780.0
2018-12-06	AMZA	ETF	60.0	60.3	58.13	60.3	176640.0
2018-12-06	ANGL	ETF	27.28	27.36	27.19	27.32	458000.0
2018-12-06	AOA	ETF	50.46	50.92	50.01	50.89	236000.0
2018-12-06	AOK	ETF	33.04	33.21	33.02	33.21	149917.0
2018-12-06	AOM	ETF	36.36	36.5	36.161	36.46	664530.0
2018-12-06	AOR	ETF	42.48	42.746	42.1661	42.58	373468.0
2018-12-06	ARCM	ETF	99.73	99.73	99.73	99.73	900.0
2018-12-06	ARGT	ETF	25.37	25.82	25.1	25.78	157600.0
2018-12-06	ARKG	ETF	28.38	29.11	28.08	28.98	155400.0
2018-12-06	ARKK	ETF	42.13	43.59	42.03	43.54	406700.0
2018-12-06	ARKQ	ETF	32.05	32.71	31.83	32.71	67200.0
2018-12-06	ARKW	ETF	51.29	53.38	51.19	53.31	119200.0
2018-12-06	ARVR	ETF	17.55	17.55	17.15	17.15	1006.0
2018-12-06	ASEA	ETF	15.99	16.2	15.59	16.2	100400.0
2018-12-06	ASET	ETF	26.74	26.8067	26.6399	26.8067	1661.0
2018-12-06	ASHR	ETF	23.31	23.6	23.21	23.58	3112800.0

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

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