PREVIEW / etf_daily / 2019-08-07

all etf daily files

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

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-07	SPY	ETF	284.4	288.82	282.04	287.97	140572300.0
2019-08-07	QQQ	ETF	181.32	184.51	179.89	184.25	49990586.0
2019-08-07	IWM	ETF	147.92	149.71	146.69	149.32	23952100.0
2019-08-07	DIA	ETF	257.13	260.69	254.36	260.24	5089500.0
2019-08-07	GLD	ETF	141.28	142.47	140.88	141.02	26671100.0
2019-08-07	TLT	ETF	142.4	143.06	139.78	140.03	32582000.0
2019-08-07	AAAU	ETF	14.96	15.07	14.92	14.93	194100.0
2019-08-07	AADR	ETF	49.3	49.78	49.17	49.78	4100.0
2019-08-07	AAXJ	ETF	63.34	64.25	63.11	64.15	1383800.0
2019-08-07	ACES	ETF	30.252	31.04	30.25	30.979	6700.0
2019-08-07	ACIO	ETF	24.32	24.32	24.095	24.297	10900.0
2019-08-07	ACSI	ETF	32.9765	33.31	32.94	33.265	2044.0
2019-08-07	ACTX	ETF	17.7002	20.0602	15.9773	16.6381	408.0
2019-08-07	ACWF	ETF	27.67	28.03	27.62	28.03	20111.0
2019-08-07	ACWI	ETF	70.54	71.53	70.15	71.42	4399700.0
2019-08-07	ACWV	ETF	90.95	92.12	90.59	91.86	405000.0
2019-08-07	ACWX	ETF	44.02	44.55	43.915	44.48	2939967.0
2019-08-07	ADRE	ETF	36.96	37.33	36.9114	37.32	2532.0
2019-08-07	AFIF	ETF	9.77	9.77	9.7263	9.7263	1237292.0
2019-08-07	AFK	ETF	20.45	20.45	20.2279	20.4331	2613.0
2019-08-07	AFTY	ETF	15.91	16.26	15.91	16.22	6400.0
2019-08-07	AGG	ETF	113.17	113.29	112.61	112.68	9156600.0
2019-08-07	AGGY	ETF	52.33	52.33	52.04	52.04	134600.0
2019-08-07	AGNG	ETF	21.1	21.1	20.981	20.981	400.0
2019-08-07	AGQ	ETF	29.91	31.03	29.87	30.33	1133600.0
2019-08-07	AGZ	ETF	116.61	116.68	116.25	116.25	27528.0
2019-08-07	AGZD	ETF	23.8	23.85	23.795	23.81	9200.0
2019-08-07	AIA	ETF	55.82	56.62	55.68	56.59	22103.0
2019-08-07	AIEQ	ETF	25.3	25.644	25.118	25.53	41600.0
2019-08-07	AIQ	ETF	15.44	15.82	15.44	15.805	6891.0
2019-08-07	AIRR	ETF	24.878	25.281	24.83	25.255	17100.0
2019-08-07	AIVI	ETF	39.03	39.44	39.03	39.43	7700.0
2019-08-07	ALTY	ETF	14.587	14.72	14.57	14.72	4900.0
2019-08-07	AMJ	ETF	23.42	23.66	23.15	23.39	2131811.0
2019-08-07	AMLP	ETF	46.4	46.4	45.4	46.0	5023560.0
2019-08-07	AMOM	ETF	25.932	25.932	25.932	25.932	800.0
2019-08-07	AMUB	ETF	14.7386	14.7386	14.7386	14.7386	1.0
2019-08-07	AMZA	ETF	49.8	49.8	48.2	49.0	237440.0
2019-08-07	ANGL	ETF	28.81	28.86	28.71	28.85	173700.0
2019-08-07	AOA	ETF	52.96	53.5	52.7	53.47	37300.0
2019-08-07	AOK	ETF	35.16	35.265	35.0812	35.18	28626.0
2019-08-07	AOM	ETF	38.5	38.66	38.3824	38.66	91221.0
2019-08-07	AOR	ETF	44.76	45.0487	44.65	45.0	72396.0
2019-08-07	ARCM	ETF	100.15	100.165	100.15	100.165	7500.0
2019-08-07	ARGT	ETF	30.52	31.12	30.5	31.05	74900.0
2019-08-07	ARKF	ETF	21.19	21.59	21.12	21.58	12600.0
2019-08-07	ARKG	ETF	32.14	32.379	31.705	32.29	233900.0
2019-08-07	ARKK	ETF	44.21	45.14	44.0	45.13	436900.0
2019-08-07	ARKQ	ETF	29.69	30.58	29.69	30.56	78900.0
2019-08-07	ARKW	ETF	48.39	49.68	48.39	49.68	39200.0

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

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