PREVIEW / etf_daily / 2018-11-21

all etf daily files

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

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-21	SPY	ETF	265.86	267.15	265.01	265.02	75563700.0
2018-11-21	QQQ	ETF	161.29	161.97	159.2323	160.37	42965839.0
2018-11-21	IWM	ETF	146.78	149.37	146.53	148.03	17902300.0
2018-11-21	DIA	ETF	245.84	246.63	244.58	244.65	4257600.0
2018-11-21	GLD	ETF	115.94	116.35	115.86	115.86	8834200.0
2018-11-21	TLT	ETF	114.89	115.09	114.54	115.02	4951100.0
2018-11-21	AAAU	ETF	12.26	12.26	12.26	12.26	451900.0
2018-11-21	AADR	ETF	43.39	44.04	43.39	43.73	14300.0
2018-11-21	AAXJ	ETF	65.02	65.54	64.98	65.11	1833100.0
2018-11-21	ACES	ETF	24.22	24.22	24.22	24.22	100.0
2018-11-21	ACSI	ETF	31.55	31.9537	31.55	31.85	3038.0
2018-11-21	ACTX	ETF	64.9006	69.0306	64.3106	68.4406	622.0
2018-11-21	ACWF	ETF	27.8125	28.04	27.8125	27.9	18968.0
2018-11-21	ACWI	ETF	67.92	68.3	67.8	67.9	3029500.0
2018-11-21	ACWV	ETF	84.61	84.77	84.34	84.39	167400.0
2018-11-21	ACWX	ETF	43.89	44.1894	43.86	43.98	2320395.0
2018-11-21	ADRE	ETF	37.21	37.537	37.21	37.4782	4405.0
2018-11-21	AFIF	ETF	10.0355	10.04	10.0107	10.04	10227.0
2018-11-21	AFK	ETF	20.41	20.5805	20.41	20.51	6773.0
2018-11-21	AFTY	ETF	14.45	14.45	14.38	14.38	3000.0
2018-11-21	AGG	ETF	104.6	104.69	104.58	104.68	5701700.0
2018-11-21	AGGY	ETF	47.37	47.41	47.351	47.38	41500.0
2018-11-21	AGNG	ETF	19.74	19.86	19.57	19.57	1100.0
2018-11-21	AGQ	ETF	23.26	23.58	23.21	23.33	62800.0
2018-11-21	AGZ	ETF	110.68	110.82	110.6709	110.82	14925.0
2018-11-21	AGZD	ETF	23.705	23.73	23.685	23.715	21800.0
2018-11-21	AIA	ETF	56.18	56.51	56.09	56.14	63843.0
2018-11-21	AIEQ	ETF	25.42	25.67	25.36	25.47	29400.0
2018-11-21	AIQ	ETF	13.39	13.42	13.3485	13.38	6132.0
2018-11-21	AIRR	ETF	24.29	24.791	24.29	24.49	23400.0
2018-11-21	AIVI	ETF	39.55	39.71	39.55	39.56	11200.0
2018-11-21	ALTY	ETF	14.331	14.41	14.331	14.391	3500.0
2018-11-21	AMJ	ETF	24.9	25.39	24.71	25.17	3417320.0
2018-11-21	AMLP	ETF	47.3	48.5	47.15	47.95	4282160.0
2018-11-21	AMZA	ETF	60.3	62.0	60.1	61.4	75270.0
2018-11-21	ANGL	ETF	27.33	27.54	27.33	27.41	220200.0
2018-11-21	AOA	ETF	50.65	50.94	50.65	50.66	130600.0
2018-11-21	AOK	ETF	32.99	33.0859	32.95	33.04	68587.0
2018-11-21	AOM	ETF	36.25	36.37	36.2118	36.3	473177.0
2018-11-21	AOR	ETF	42.48	42.66	42.48	42.49	124753.0
2018-11-21	ARGT	ETF	25.12	25.43	25.12	25.39	13800.0
2018-11-21	ARKG	ETF	28.0	28.21	27.54	28.15	178200.0
2018-11-21	ARKK	ETF	41.45	41.9	41.21	41.74	135700.0
2018-11-21	ARKQ	ETF	32.0	32.34	32.0	32.03	5100.0
2018-11-21	ARKW	ETF	50.14	50.407	49.41	49.63	78000.0
2018-11-21	ARVR	ETF	17.2347	17.2347	17.2347	17.2347	112.0
2018-11-21	ASEA	ETF	15.49	15.72	15.49	15.72	3300.0
2018-11-21	ASET	ETF	26.8894	26.93	26.7945	26.8045	1347.0
2018-11-21	ASHR	ETF	23.73	23.83	23.64	23.69	2607400.0
2018-11-21	ASHS	ETF	24.29	24.33	24.26	24.28	7500.0

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

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