PREVIEW / etf_daily / 2019-01-31

all etf daily files

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

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-31	SPY	ETF	267.51	270.47	267.27	269.93	104012100.0
2019-01-31	QQQ	ETF	166.65	168.99	166.4701	168.16	37258361.0
2019-01-31	IWM	ETF	147.61	149.3	147.53	149.06	27252900.0
2019-01-31	DIA	ETF	248.95	250.43	248.34	250.12	5649600.0
2019-01-31	GLD	ETF	125.18	125.23	124.62	124.75	10209500.0
2019-01-31	TLT	ETF	121.55	122.18	121.5	121.97	11843400.0
2019-01-31	AAAU	ETF	13.24	13.24	13.19	13.19	30300.0
2019-01-31	AADR	ETF	43.91	44.43	43.91	44.32	18600.0
2019-01-31	AAXJ	ETF	68.44	69.05	68.44	68.98	1222500.0
2019-01-31	ACES	ETF	25.099	25.58	25.099	25.55	20500.0
2019-01-31	ACSI	ETF	31.06	31.3877	31.06	31.3877	1156.0
2019-01-31	ACTX	ETF	47.7904	50.1505	47.2004	47.7904	1350.0
2019-01-31	ACWF	ETF	28.35	28.49	28.31	28.49	15739.0
2019-01-31	ACWI	ETF	68.91	69.42	68.8	69.32	5528500.0
2019-01-31	ACWV	ETF	84.77	85.56	84.65	85.44	579400.0
2019-01-31	ACWX	ETF	45.0	45.235	44.945	45.12	3503065.0
2019-01-31	ADRE	ETF	39.9	40.165	39.9	40.05	6998.0
2019-01-31	AFIF	ETF	9.99	10.0099	9.94	9.985	28548.0
2019-01-31	AFK	ETF	21.702	21.89	21.702	21.89	3440.0
2019-01-31	AFTY	ETF	14.75	14.964	14.75	14.964	5600.0
2019-01-31	AGG	ETF	107.3	107.53	107.29	107.46	14766500.0
2019-01-31	AGGY	ETF	48.82	48.97	48.82	48.89	85100.0
2019-01-31	AGNG	ETF	20.49	20.92	20.49	20.78	1500.0
2019-01-31	AGQ	ETF	28.54	28.63	28.04	28.15	176700.0
2019-01-31	AGZ	ETF	112.45	112.53	112.4301	112.5	70285.0
2019-01-31	AGZD	ETF	23.745	23.745	23.66	23.735	30400.0
2019-01-31	AIA	ETF	60.16	60.67	60.1	60.64	121079.0
2019-01-31	AIEQ	ETF	24.46	24.7	24.46	24.675	94900.0
2019-01-31	AIQ	ETF	14.37	14.62	14.37	14.55	13177.0
2019-01-31	AIRR	ETF	23.73	23.941	23.63	23.92	46800.0
2019-01-31	AIVI	ETF	40.15	40.39	40.15	40.29	118700.0
2019-01-31	ALTY	ETF	14.81	14.81	14.6	14.66	7300.0
2019-01-31	AMJ	ETF	25.41	25.47	24.81	25.01	3950476.0
2019-01-31	AMLP	ETF	50.05	50.25	48.85	49.2	6418040.0
2019-01-31	AMUB	ETF	15.7605	15.7605	15.7605	15.7605	0.0
2019-01-31	AMZA	ETF	59.6	60.0	58.2	58.7	87800.0
2019-01-31	ANGL	ETF	28.14	28.29	28.11	28.21	294700.0
2019-01-31	AOA	ETF	51.44	51.75	51.42	51.71	288400.0
2019-01-31	AOK	ETF	33.62	33.75	33.605	33.74	187596.0
2019-01-31	AOM	ETF	36.9	37.02	36.85	37.01	655272.0
2019-01-31	AOR	ETF	43.17	43.39	43.1201	43.34	275430.0
2019-01-31	ARGT	ETF	27.66	28.03	27.58	27.95	47300.0
2019-01-31	ARKG	ETF	27.59	28.24	27.58	28.22	150500.0
2019-01-31	ARKK	ETF	42.25	43.24	42.105	43.05	401100.0
2019-01-31	ARKQ	ETF	32.21	33.32	32.21	33.26	37500.0
2019-01-31	ARKW	ETF	48.65	49.7	48.39	49.52	199300.0
2019-01-31	ASEA	ETF	16.05	16.2	16.0	16.18	17400.0
2019-01-31	ASET	ETF	27.75	27.8092	27.75	27.805	462.0
2019-01-31	ASHR	ETF	23.95	24.26	23.95	24.25	1749900.0
2019-01-31	ASHS	ETF	23.01	23.12	22.91	23.1	20800.0

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

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