PREVIEW / etf_daily / 2019-06-25

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-25.parquet
  size:    70 KB
  rows:    1,811

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-06-25	SPY	ETF	293.7	293.73	290.64	290.76	82028700.0
2019-06-25	QQQ	ETF	188.06	188.14	184.65	184.93	33921112.0
2019-06-25	IWM	ETF	152.31	152.5	151.0	151.15	17462200.0
2019-06-25	DIA	ETF	267.39	267.4	265.13	265.26	7240300.0
2019-06-25	GLD	ETF	134.9	135.55	133.21	134.2	24772200.0
2019-06-25	TLT	ETF	132.79	133.09	132.72	132.82	9604600.0
2019-06-25	AAAU	ETF	14.28	14.34	14.12	14.22	105400.0
2019-06-25	AADR	ETF	49.3	49.41	48.86	48.94	7400.0
2019-06-25	AAXJ	ETF	69.07	69.09	68.62	68.65	1067800.0
2019-06-25	ACES	ETF	29.081	29.139	28.882	28.882	13600.0
2019-06-25	ACSI	ETF	33.6057	33.6057	33.35	33.35	2473.0
2019-06-25	ACTX	ETF	17.7002	22.7152	17.7002	20.0602	77.0
2019-06-25	ACWF	ETF	29.0353	29.04	28.85	28.85	3893.0
2019-06-25	ACWI	ETF	73.67	73.7	73.02	73.07	3736200.0
2019-06-25	ACWV	ETF	92.85	92.85	92.29	92.32	189800.0
2019-06-25	ACWX	ETF	46.69	46.7	46.33	46.33	975579.0
2019-06-25	ADRE	ETF	39.96	40.0	39.36	39.36	4268.0
2019-06-25	AFIF	ETF	9.896	9.896	9.85	9.87	15024.0
2019-06-25	AFK	ETF	22.04	22.0489	21.86	21.86	2588.0
2019-06-25	AFTY	ETF	17.25	17.25	17.13	17.131	7400.0
2019-06-25	AGG	ETF	111.36	111.44	111.22	111.34	3111100.0
2019-06-25	AGGY	ETF	51.19	51.25	51.14	51.185	77200.0
2019-06-25	AGNG	ETF	21.42	21.58	21.274	21.274	2500.0
2019-06-25	AGQ	ETF	25.04	25.31	24.63	24.83	530000.0
2019-06-25	AGZ	ETF	115.2699	115.3199	115.23	115.28	16677.0
2019-06-25	AGZD	ETF	23.785	23.82	23.775	23.785	7000.0
2019-06-25	AIA	ETF	60.43	60.43	59.96	60.05	30256.0
2019-06-25	AIEQ	ETF	26.28	26.28	26.02	26.02	17100.0
2019-06-25	AIQ	ETF	16.33	16.33	15.96	15.96	3937.0
2019-06-25	AIRR	ETF	25.42	25.531	25.42	25.46	7300.0
2019-06-25	AIVI	ETF	40.92	40.92	40.67	40.67	135500.0
2019-06-25	ALTY	ETF	15.0	15.0	14.9	14.95	3600.0
2019-06-25	AMJ	ETF	24.74	24.84	24.56	24.63	558186.0
2019-06-25	AMLP	ETF	48.95	48.95	48.35	48.45	2328840.0
2019-06-25	AMOM	ETF	25.95	25.95	25.498	25.498	400.0
2019-06-25	AMUB	ETF	15.51	15.5108	15.51	15.5108	5000.0
2019-06-25	AMZA	ETF	54.5	54.7	54.05	54.5	42580.0
2019-06-25	ANGL	ETF	29.22	29.22	29.11	29.11	177200.0
2019-06-25	AOA	ETF	55.01	55.01	54.64	54.65	45400.0
2019-06-25	AOK	ETF	35.38	35.38	35.2601	35.28	74469.0
2019-06-25	AOM	ETF	38.97	39.03	38.86	38.9	154299.0
2019-06-25	AOR	ETF	45.92	45.95	45.7	45.72	46107.0
2019-06-25	ARGT	ETF	32.09	32.23	31.95	32.03	24400.0
2019-06-25	ARKF	ETF	22.48	22.48	22.068	22.068	16900.0
2019-06-25	ARKG	ETF	32.03	32.67	31.956	32.32	243200.0
2019-06-25	ARKK	ETF	44.84	45.1	44.3	44.46	227700.0
2019-06-25	ARKQ	ETF	32.13	32.2	31.8	31.87	12800.0
2019-06-25	ARKW	ETF	51.27	51.47	50.09	50.12	72900.0
2019-06-25	ASEA	ETF	16.48	16.76	16.4	16.59	5800.0
2019-06-25	ASHR	ETF	27.92	27.92	27.69	27.74	7954300.0

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

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