PREVIEW / etf_daily / 2019-01-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-03.parquet
  size:    67 KB
  rows:    1,740

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
2019-01-03	SPY	ETF	248.23	248.57	243.67	244.21	144140700.0
2019-01-03	QQQ	ETF	152.6	153.26	149.49	149.82	74820225.0
2019-01-03	IWM	ETF	133.91	134.64	131.65	132.25	29294600.0
2019-01-03	DIA	ETF	231.25	231.42	226.36	226.72	7350200.0
2019-01-03	GLD	ETF	121.78	122.46	121.73	122.43	15440800.0
2019-01-03	TLT	ETF	122.29	123.86	122.23	123.54	21187000.0
2019-01-03	AAAU	ETF	12.89	12.93	12.88	12.93	62600.0
2019-01-03	AADR	ETF	40.1	40.24	39.74	39.88	37100.0
2019-01-03	AAXJ	ETF	62.19	62.26	61.55	61.6	1505800.0
2019-01-03	ACES	ETF	22.73	22.76	22.468	22.518	5700.0
2019-01-03	ACSI	ETF	28.8999	28.8999	28.582	28.582	812.0
2019-01-03	ACTX	ETF	50.7405	53.1005	50.1505	53.1005	341.0
2019-01-03	ACWF	ETF	25.7247	25.7247	25.452	25.4876	36576.0
2019-01-03	ACWI	ETF	63.75	63.8	62.91	63.05	5111900.0
2019-01-03	ACWV	ETF	80.56	80.73	79.95	80.12	347900.0
2019-01-03	ACWX	ETF	41.64	41.65	41.27	41.42	2160972.0
2019-01-03	ADRE	ETF	35.77	35.8147	35.705	35.7505	2535.0
2019-01-03	AFIF	ETF	9.9	9.93	9.88	9.915	6948.0
2019-01-03	AFK	ETF	19.63	19.83	19.55	19.71	5175.0
2019-01-03	AFTY	ETF	12.97	13.031	12.97	12.99	9500.0
2019-01-03	AGG	ETF	106.57	107.08	106.57	107.01	6497000.0
2019-01-03	AGGY	ETF	48.4	48.47	48.39	48.47	51900.0
2019-01-03	AGNG	ETF	18.79	18.8	18.739	18.739	1600.0
2019-01-03	AGQ	ETF	26.94	27.34	26.76	27.29	551200.0
2019-01-03	AGZ	ETF	112.3244	112.71	112.2901	112.63	13358.0
2019-01-03	AGZD	ETF	23.695	23.695	23.6	23.625	14200.0
2019-01-03	AIA	ETF	54.0	54.0	53.23	53.23	157485.0
2019-01-03	AIEQ	ETF	21.74	21.76	21.44	21.442	41800.0
2019-01-03	AIQ	ETF	12.85	12.87	12.67	12.67	2458.0
2019-01-03	AIRR	ETF	21.72	21.886	21.49	21.63	12400.0
2019-01-03	AIVI	ETF	37.6	37.8	37.6	37.69	3900.0
2019-01-03	ALTY	ETF	13.32	13.435	13.32	13.431	8900.0
2019-01-03	AMJ	ETF	22.36	23.01	22.36	22.82	4732298.0
2019-01-03	AMLP	ETF	44.55	45.25	44.2	44.7	4924600.0
2019-01-03	AMUB	ETF	14.3347	14.3347	14.3347	14.3347	0.0
2019-01-03	AMZA	ETF	51.8	53.0	51.5	52.4	97660.0
2019-01-03	ANGL	ETF	26.74	26.84	26.67	26.77	476600.0
2019-01-03	AOA	ETF	48.36	48.42	47.83	47.96	178900.0
2019-01-03	AOK	ETF	32.67	32.7442	32.6	32.65	70496.0
2019-01-03	AOM	ETF	35.62	35.81	35.4746	35.53	1919287.0
2019-01-03	AOR	ETF	41.13	41.15	40.85	40.86	259850.0
2019-01-03	ARGT	ETF	23.63	23.72	23.37	23.58	15300.0
2019-01-03	ARKG	ETF	24.5	24.67	24.088	24.21	62100.0
2019-01-03	ARKK	ETF	37.0	37.141	35.91	36.19	256100.0
2019-01-03	ARKQ	ETF	29.3	29.3	28.41	28.43	13700.0
2019-01-03	ARKW	ETF	41.93	42.07	40.74	40.89	93700.0
2019-01-03	ASEA	ETF	15.2	15.35	15.08	15.2	9500.0
2019-01-03	ASET	ETF	25.3801	25.389	25.29	25.32	2024.0
2019-01-03	ASHR	ETF	21.68	21.69	21.51	21.51	1082400.0
2019-01-03	ASHS	ETF	22.0	22.07	21.99	22.03	6300.0

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

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