PREVIEW / etf_daily / 2018-11-26

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-26.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-26	SPY	ETF	265.78	267.75	265.34	267.5	79981400.0
2018-11-26	QQQ	ETF	161.44	162.97	160.76	162.89	42012633.0
2018-11-26	IWM	ETF	149.32	150.4	148.74	149.81	15346400.0
2018-11-26	DIA	ETF	244.87	246.73	244.68	246.39	3435500.0
2018-11-26	GLD	ETF	115.84	115.87	115.53	115.64	4018600.0
2018-11-26	TLT	ETF	114.86	115.06	114.78	114.88	6599000.0
2018-11-26	AAAU	ETF	12.25	12.25	12.22	12.22	1500.0
2018-11-26	AADR	ETF	43.75	43.89	43.48	43.72	24300.0
2018-11-26	AAXJ	ETF	65.67	65.85	65.55	65.82	2752100.0
2018-11-26	ACES	ETF	23.94	24.73	23.94	24.728	2800.0
2018-11-26	ACSI	ETF	32.0032	32.15	32.0032	32.15	820.0
2018-11-26	ACTX	ETF	66.6706	66.6706	59.5905	64.3106	805.0
2018-11-26	ACWF	ETF	27.92	28.1599	27.92	28.1396	12109.0
2018-11-26	ACWI	ETF	68.15	68.45	68.05	68.44	4068100.0
2018-11-26	ACWV	ETF	85.03	85.16	84.72	85.13	315000.0
2018-11-26	ACWX	ETF	44.17	44.3366	44.09	44.22	2719810.0
2018-11-26	ADRE	ETF	37.44	37.44	37.2087	37.2087	964.0
2018-11-26	AFIF	ETF	10.01	10.01	10.0034	10.01	5055.0
2018-11-26	AFK	ETF	20.37	20.59	20.32	20.51	4514.0
2018-11-26	AFTY	ETF	14.12	14.14	14.067	14.099	13600.0
2018-11-26	AGG	ETF	104.67	104.67	104.59	104.63	4326100.0
2018-11-26	AGGY	ETF	47.39	47.439	47.38	47.404	48300.0
2018-11-26	AGNG	ETF	19.82	20.0	19.81	19.96	1600.0
2018-11-26	AGQ	ETF	22.74	22.82	22.52	22.61	42700.0
2018-11-26	AGZ	ETF	110.63	110.71	110.6201	110.6854	15111.0
2018-11-26	AGZD	ETF	23.745	23.83	23.705	23.755	117200.0
2018-11-26	AIA	ETF	57.09	57.3003	56.98	57.24	54278.0
2018-11-26	AIEQ	ETF	25.45	25.85	25.45	25.85	27700.0
2018-11-26	AIQ	ETF	13.6003	13.66	13.5161	13.66	14851.0
2018-11-26	AIRR	ETF	24.63	24.86	24.6	24.76	15800.0
2018-11-26	AIVI	ETF	39.7	39.71	39.62	39.68	3800.0
2018-11-26	ALTY	ETF	14.5	14.5	14.42	14.42	4100.0
2018-11-26	AMJ	ETF	24.87	25.14	24.7501	24.82	1449513.0
2018-11-26	AMLP	ETF	47.3	47.95	47.15	47.4	3122720.0
2018-11-26	AMZA	ETF	60.3	61.2	60.1	60.4	88900.0
2018-11-26	ANGL	ETF	27.3	27.47	27.3	27.43	197800.0
2018-11-26	AOA	ETF	50.86	51.02	50.78	51.01	152900.0
2018-11-26	AOK	ETF	33.06	33.1592	33.03	33.11	192017.0
2018-11-26	AOM	ETF	36.31	36.4	36.2999	36.4	317356.0
2018-11-26	AOR	ETF	42.6	42.78	42.5642	42.73	169962.0
2018-11-26	ARCM	ETF	100.17	100.17	100.17	100.17	100.0
2018-11-26	ARGT	ETF	25.14	25.24	24.99	25.17	42200.0
2018-11-26	ARKG	ETF	28.78	29.07	28.54	28.96	226300.0
2018-11-26	ARKK	ETF	42.35	43.07	42.28	42.95	269900.0
2018-11-26	ARKQ	ETF	32.344	32.82	32.344	32.82	6000.0
2018-11-26	ARKW	ETF	50.2	51.439	50.12	51.34	70800.0
2018-11-26	ARVR	ETF	17.37	17.37	17.37	17.37	136.0
2018-11-26	ASEA	ETF	15.6	15.71	15.51	15.71	16600.0
2018-11-26	ASET	ETF	26.85	26.93	26.85	26.8768	1102.0
2018-11-26	ASHR	ETF	23.08	23.14	22.96	23.1	1674400.0

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

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