PREVIEW / etf_daily / 2018-12-20

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-20.parquet
  size:    67 KB
  rows:    1,742

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-20	SPY	ETF	249.86	251.62	244.65	247.17	252053400.0
2018-12-20	QQQ	ETF	154.16	155.87	150.39	152.29	99002139.0
2018-12-20	IWM	ETF	133.63	134.41	130.23	131.79	57908100.0
2018-12-20	DIA	ETF	232.59	233.37	226.95	228.89	11912800.0
2018-12-20	GLD	ETF	119.11	119.74	118.68	119.24	18615100.0
2018-12-20	TLT	ETF	122.01	122.03	120.67	120.74	18543700.0
2018-12-20	AAAU	ETF	12.59	12.64	12.56	12.6	7200.0
2018-12-20	AADR	ETF	40.92	40.92	39.63	40.05	94000.0
2018-12-20	AAXJ	ETF	63.32	63.62	62.77	63.2	1269500.0
2018-12-20	ACES	ETF	22.95	22.95	22.0	22.366	14400.0
2018-12-20	ACSI	ETF	29.4	29.4	29.112	29.112	966.0
2018-12-20	ACTX	ETF	52.5105	52.5105	47.2004	48.0854	1051.0
2018-12-20	ACWF	ETF	26.0	26.14	25.58	25.7435	141840.0
2018-12-20	ACWI	ETF	64.06	64.36	63.01	63.49	14400300.0
2018-12-20	ACWV	ETF	81.41	81.5	80.22	80.76	1023700.0
2018-12-20	ACWX	ETF	41.97	42.07	41.53	41.71	9003772.0
2018-12-20	ADRE	ETF	35.95	36.3	35.7	35.8895	9951.0
2018-12-20	AFIF	ETF	9.87	9.88	9.85	9.88	27208.0
2018-12-20	AFK	ETF	19.62	19.86	18.01	19.24	17477.0
2018-12-20	AFTY	ETF	13.36	13.51	13.36	13.396	1100.0
2018-12-20	AGG	ETF	106.1	106.12	105.81	105.84	7695000.0
2018-12-20	AGGY	ETF	48.27	48.27	48.07	48.07	75200.0
2018-12-20	AGNG	ETF	19.16	19.16	18.725	18.725	4900.0
2018-12-20	AGQ	ETF	24.19	24.39	23.93	24.15	161800.0
2018-12-20	AGZ	ETF	111.74	111.74	111.46	111.48	47642.0
2018-12-20	AGZD	ETF	23.765	23.89	23.755	23.755	29800.0
2018-12-20	AIA	ETF	54.8	54.94	54.2801	54.7	1043202.0
2018-12-20	AIEQ	ETF	23.59	23.77	22.97	23.24	124900.0
2018-12-20	AIQ	ETF	13.11	13.14	12.73	12.89	6785.0
2018-12-20	AIRR	ETF	21.45	21.635	21.0	21.24	115900.0
2018-12-20	AIVI	ETF	38.28	38.37	38.03	38.09	46100.0
2018-12-20	ALTY	ETF	13.68	13.68	13.196	13.233	22400.0
2018-12-20	AMJ	ETF	22.96	23.28	22.34	22.55	7424232.0
2018-12-20	AMLP	ETF	45.35	45.8	43.85	44.25	8725240.0
2018-12-20	AMUB	ETF	14.1433	14.1433	14.1433	14.1433	0.0
2018-12-20	AMZA	ETF	53.5	54.26	50.7	51.1	237140.0
2018-12-20	ANGL	ETF	26.93	26.98	26.56	26.73	1331800.0
2018-12-20	AOA	ETF	48.5	48.9	48.12	48.46	672100.0
2018-12-20	AOK	ETF	32.79	32.87	32.61	32.73	282905.0
2018-12-20	AOM	ETF	35.84	35.92	35.62	35.73	968625.0
2018-12-20	AOR	ETF	41.39	41.5599	41.02	41.17	689927.0
2018-12-20	ARGT	ETF	23.54	23.66	23.08	23.08	21900.0
2018-12-20	ARKG	ETF	25.13	25.465	23.88	24.1	345100.0
2018-12-20	ARKK	ETF	38.92	39.3	37.17	37.82	842200.0
2018-12-20	ARKQ	ETF	30.17	30.57	29.57	29.92	72700.0
2018-12-20	ARKW	ETF	48.3	48.81	46.26	47.17	488600.0
2018-12-20	ARVR	ETF	16.2911	16.4	16.2911	16.4	200.0
2018-12-20	ASEA	ETF	15.46	15.64	15.43	15.43	2600.0
2018-12-20	ASET	ETF	26.06	26.1	26.0238	26.0238	958.0
2018-12-20	ASHR	ETF	22.28	22.39	22.15	22.23	1678600.0

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

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