PREVIEW / etf_daily / 2018-12-26

all etf daily files

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

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-26	SPY	ETF	235.97	246.18	233.76	246.18	218485400.0
2018-12-26	QQQ	ETF	145.12	152.54	144.09	152.46	98982064.0
2018-12-26	IWM	ETF	126.28	132.1	125.81	131.93	40182700.0
2018-12-26	DIA	ETF	219.19	228.74	216.97	228.71	9761100.0
2018-12-26	GLD	ETF	120.62	121.0	119.57	119.66	14293500.0
2018-12-26	TLT	ETF	120.99	121.39	119.97	120.02	11700400.0
2018-12-26	AAAU	ETF	12.79	12.83	12.67	12.67	23300.0
2018-12-26	AADR	ETF	38.44	39.83	38.15	39.83	46000.0
2018-12-26	AAXJ	ETF	62.67	63.48	62.06	63.48	765100.0
2018-12-26	ACES	ETF	21.9	22.368	21.89	22.368	27000.0
2018-12-26	ACSI	ETF	28.14	29.05	27.86	29.05	52775.0
2018-12-26	ACTX	ETF	41.3004	53.1005	41.3004	47.2004	759.0
2018-12-26	ACWF	ETF	25.04	25.83	24.88	25.83	422158.0
2018-12-26	ACWI	ETF	61.55	63.45	61.01	63.44	15493100.0
2018-12-26	ACWV	ETF	78.83	80.25	78.03	80.24	1158800.0
2018-12-26	ACWX	ETF	40.88	41.65	40.51	41.65	5827310.0
2018-12-26	ADRE	ETF	35.2	35.8723	34.9744	35.8723	4459.0
2018-12-26	AFIF	ETF	9.9	9.92	9.88	9.9029	35687.0
2018-12-26	AFK	ETF	19.24	19.56	19.18	19.56	13532.0
2018-12-26	AFTY	ETF	13.17	13.25	13.1	13.25	2500.0
2018-12-26	AGG	ETF	105.92	106.0	105.63	105.66	8606900.0
2018-12-26	AGGY	ETF	47.92	47.97	47.84	47.845	65100.0
2018-12-26	AGNG	ETF	18.251	18.76	18.251	18.76	7200.0
2018-12-26	AGQ	ETF	24.89	25.43	24.79	24.99	215800.0
2018-12-26	AGZ	ETF	111.78	111.81	111.47	111.525	28244.0
2018-12-26	AGZD	ETF	23.775	23.81	23.655	23.685	21200.0
2018-12-26	AIA	ETF	54.4	55.19	54.0	55.19	102754.0
2018-12-26	AIEQ	ETF	20.44	21.5	20.351	21.48	88300.0
2018-12-26	AIQ	ETF	12.19	12.76	12.19	12.76	26619.0
2018-12-26	AIRR	ETF	20.57	21.44	20.44	21.43	118400.0
2018-12-26	AIVI	ETF	36.89	37.73	36.77	37.73	25700.0
2018-12-26	ALTY	ETF	12.89	13.325	12.89	13.28	5900.0
2018-12-26	AMJ	ETF	21.31	22.38	21.09	22.38	11591760.0
2018-12-26	AMLP	ETF	42.0	43.95	41.35	43.85	9097120.0
2018-12-26	AMUB	ETF	14.0385	14.0385	14.0385	14.0385	0.0
2018-12-26	AMZA	ETF	47.9	51.2	47.1	51.1	247720.0
2018-12-26	ANGL	ETF	26.3	26.7	26.25	26.66	860700.0
2018-12-26	AOA	ETF	47.17	48.4	46.97	48.38	750800.0
2018-12-26	AOK	ETF	32.36	32.68	32.33	32.68	536014.0
2018-12-26	AOM	ETF	35.34	35.7	35.16	35.7	1626831.0
2018-12-26	AOR	ETF	40.45	41.205	40.2991	41.17	612644.0
2018-12-26	ARGT	ETF	21.87	22.84	21.75	22.82	41500.0
2018-12-26	ARKG	ETF	22.6	23.72	22.42	23.68	193100.0
2018-12-26	ARKK	ETF	35.62	37.59	35.298	37.52	959700.0
2018-12-26	ARKQ	ETF	28.89	30.1	28.54	30.09	33300.0
2018-12-26	ARKW	ETF	45.11	47.46	44.55	47.46	143200.0
2018-12-26	ASEA	ETF	15.44	15.64	15.44	15.64	500.0
2018-12-26	ASET	ETF	24.93	25.33	24.8873	25.33	2418.0
2018-12-26	ASHR	ETF	21.8	22.07	21.74	22.07	2843000.0
2018-12-26	ASHS	ETF	22.72	22.78	22.45	22.78	13300.0

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

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