PREVIEW / etf_daily / 2019-01-25

all etf daily files

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

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-25	SPY	ETF	265.61	266.7	263.66	265.78	96883400.0
2019-01-25	QQQ	ETF	164.48	165.65	163.95	165.15	36466069.0
2019-01-25	IWM	ETF	146.62	147.64	146.43	147.34	22266900.0
2019-01-25	DIA	ETF	247.39	248.55	246.68	247.39	4110600.0
2019-01-25	GLD	ETF	122.02	122.91	122.02	122.86	11103300.0
2019-01-25	TLT	ETF	120.59	120.75	120.32	120.53	6460800.0
2019-01-25	AAAU	ETF	12.91	12.99	12.91	12.99	19300.0
2019-01-25	AADR	ETF	43.14	43.14	42.97	43.1	4700.0
2019-01-25	AAXJ	ETF	67.62	68.06	67.57	67.85	2356500.0
2019-01-25	ACES	ETF	24.936	25.04	24.936	25.025	6300.0
2019-01-25	ACSI	ETF	31.01	31.0159	30.9619	30.9619	1930.0
2019-01-25	ACTX	ETF	48.0854	51.9205	47.2004	49.8554	649.0
2019-01-25	ACWF	ETF	28.0819	28.15	28.05	28.0841	13528.0
2019-01-25	ACWI	ETF	68.22	68.5	68.15	68.37	5303400.0
2019-01-25	ACWV	ETF	84.09	84.2	83.83	83.98	667100.0
2019-01-25	ACWX	ETF	44.51	44.7	44.51	44.65	2304671.0
2019-01-25	ADRE	ETF	39.44	39.44	39.1651	39.22	2075.0
2019-01-25	AFIF	ETF	9.95	9.9998	9.93	9.975	19043.0
2019-01-25	AFK	ETF	20.78	21.0	20.7773	20.97	15058.0
2019-01-25	AFTY	ETF	14.5	14.522	14.495	14.498	1900.0
2019-01-25	AGG	ETF	106.64	106.7	106.56	106.68	3469500.0
2019-01-25	AGGY	ETF	48.45	48.51	48.441	48.51	76300.0
2019-01-25	AGNG	ETF	20.61	20.69	20.61	20.69	1200.0
2019-01-25	AGQ	ETF	26.4	27.05	26.4	27.01	212500.0
2019-01-25	AGZ	ETF	112.16	112.16	112.04	112.08	34175.0
2019-01-25	AGZD	ETF	23.68	23.725	23.68	23.725	10600.0
2019-01-25	AIA	ETF	59.35	59.7262	59.35	59.57	50078.0
2019-01-25	AIEQ	ETF	24.08	24.35	24.08	24.27	47200.0
2019-01-25	AIQ	ETF	14.18	14.39	14.17	14.34	14151.0
2019-01-25	AIRR	ETF	23.8	23.83	23.71	23.73	27500.0
2019-01-25	AIVI	ETF	39.62	39.72	39.62	39.64	3700.0
2019-01-25	ALTY	ETF	14.6	14.6	14.42	14.42	6300.0
2019-01-25	AMJ	ETF	24.68	24.89	24.64	24.72	4553857.0
2019-01-25	AMLP	ETF	48.6	49.0	48.5	48.9	4777380.0
2019-01-25	AMUB	ETF	15.6547	15.6547	15.6547	15.6547	0.0
2019-01-25	AMZA	ETF	57.5	58.1	57.25	57.8	85500.0
2019-01-25	ANGL	ETF	27.92	28.04	27.85	27.87	516700.0
2019-01-25	AOA	ETF	51.01	51.17	51.01	51.07	188400.0
2019-01-25	AOK	ETF	33.45	33.4768	33.42	33.46	159362.0
2019-01-25	AOM	ETF	36.63	36.71	36.63	36.64	307533.0
2019-01-25	AOR	ETF	42.84	42.9411	42.84	42.88	258000.0
2019-01-25	ARCM	ETF	100.0	100.035	100.0	100.035	2000.0
2019-01-25	ARGT	ETF	26.85	27.05	26.7	26.9	171800.0
2019-01-25	ARKG	ETF	27.95	28.22	27.505	28.188	87600.0
2019-01-25	ARKK	ETF	41.96	42.64	41.71	42.57	242300.0
2019-01-25	ARKQ	ETF	31.61	32.26	31.61	32.18	52000.0
2019-01-25	ARKW	ETF	48.18	49.08	48.0	49.07	91300.0
2019-01-25	ASEA	ETF	16.19	16.19	16.09	16.09	5100.0
2019-01-25	ASET	ETF	27.19	27.19	27.19	27.19	1526.0
2019-01-25	ASHR	ETF	23.83	23.91	23.75	23.88	3469300.0

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

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