PREVIEW / etf_daily / 2019-08-05

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-05.parquet
  size:    71 KB
  rows:    1,846

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-08-05	SPY	ETF	288.09	288.21	281.72	283.82	178745400.0
2019-08-05	QQQ	ETF	183.51	183.51	179.2	180.73	75039971.0
2019-08-05	IWM	ETF	149.78	149.92	146.21	148.0	39221500.0
2019-08-05	DIA	ETF	260.99	261.15	255.13	257.1	6608200.0
2019-08-05	GLD	ETF	137.93	138.64	137.05	137.79	17519800.0
2019-08-05	TLT	ETF	138.14	138.89	137.66	138.87	18543000.0
2019-08-05	AAAU	ETF	14.6	14.67	14.55	14.58	75100.0
2019-08-05	AADR	ETF	49.36	49.48	48.77	48.92	6700.0
2019-08-05	AAXJ	ETF	63.91	63.94	62.7	63.06	4305200.0
2019-08-05	ACES	ETF	32.49	32.49	29.53	29.851	23900.0
2019-08-05	ACIO	ETF	24.29	24.29	24.194	24.24	42700.0
2019-08-05	ACSI	ETF	33.3808	33.3808	32.8899	33.01	8223.0
2019-08-05	ACTX	ETF	19.4761	20.9452	15.6941	17.1102	264.0
2019-08-05	ACWF	ETF	28.0	28.0	27.45	27.63	8171.0
2019-08-05	ACWI	ETF	71.32	71.32	69.92	70.37	6066100.0
2019-08-05	ACWV	ETF	91.22	91.29	89.83	90.27	1219400.0
2019-08-05	ACWX	ETF	44.4	44.4	43.725	43.95	2634716.0
2019-08-05	ADRE	ETF	37.02	37.0704	36.528	36.55	7317.0
2019-08-05	AFIF	ETF	9.82	9.85	9.815	9.839	14154.0
2019-08-05	AFK	ETF	20.15	20.474	20.15	20.2399	7244.0
2019-08-05	AFTY	ETF	16.11	16.18	15.76	15.82	16200.0
2019-08-05	AGG	ETF	112.28	112.58	112.25	112.44	7626600.0
2019-08-05	AGGY	ETF	51.92	51.99	51.86	51.97	266200.0
2019-08-05	AGNG	ETF	21.14	21.14	20.842	20.842	3000.0
2019-08-05	AGQ	ETF	28.2	28.6	27.65	28.05	506000.0
2019-08-05	AGZ	ETF	115.95	116.14	115.87	116.03	22356.0
2019-08-05	AGZD	ETF	23.875	23.875	23.795	23.795	7400.0
2019-08-05	AIA	ETF	56.49	56.49	55.25	55.4	48318.0
2019-08-05	AIEQ	ETF	25.74	25.74	24.92	25.14	193900.0
2019-08-05	AIQ	ETF	15.76	15.76	15.4562	15.55	9920.0
2019-08-05	AIRR	ETF	25.03	25.05	24.62	24.71	35300.0
2019-08-05	AIVI	ETF	39.2	39.2	38.83	38.96	7600.0
2019-08-05	ALTY	ETF	15.0	15.0	14.55	14.61	30300.0
2019-08-05	AMJ	ETF	24.38	24.4	23.725	23.89	2729614.0
2019-08-05	AMLP	ETF	47.9	47.9	46.55	46.9	5858220.0
2019-08-05	AMOM	ETF	25.25	25.266	25.25	25.266	400.0
2019-08-05	AMUB	ETF	15.0614	15.0614	15.0614	15.0614	0.0
2019-08-05	AMZA	ETF	51.6	51.8	50.0	50.0	174720.0
2019-08-05	ANGL	ETF	29.02	29.02	28.68	28.76	1457500.0
2019-08-05	AOA	ETF	53.41	53.5	52.56	52.81	100700.0
2019-08-05	AOK	ETF	35.0	35.11	34.94	35.05	65386.0
2019-08-05	AOM	ETF	38.46	38.76	38.2601	38.32	164906.0
2019-08-05	AOR	ETF	44.98	44.98	44.4413	44.64	86960.0
2019-08-05	ARGT	ETF	30.99	30.99	30.43	30.62	87600.0
2019-08-05	ARKF	ETF	21.54	21.54	20.965	21.17	30900.0
2019-08-05	ARKG	ETF	32.41	32.82	31.286	31.64	221000.0
2019-08-05	ARKK	ETF	44.97	45.07	43.57	44.16	862300.0
2019-08-05	ARKQ	ETF	30.96	30.96	30.139	30.37	40300.0
2019-08-05	ARKW	ETF	49.19	49.19	48.06	48.52	142000.0
2019-08-05	ASEA	ETF	15.75	16.01	15.69	15.72	14800.0

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

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