PREVIEW / etf_daily / 2019-08-19

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-19.parquet
  size:    69 KB
  rows:    1,812

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-19	SPY	ETF	292.19	293.08	291.44	292.33	53571800.0
2019-08-19	QQQ	ETF	188.03	188.83	187.5	188.43	22568634.0
2019-08-19	IWM	ETF	150.32	150.89	149.95	150.13	17023400.0
2019-08-19	DIA	ETF	262.04	262.25	260.82	261.34	1971800.0
2019-08-19	GLD	ETF	141.33	141.79	140.85	141.11	10552700.0
2019-08-19	TLT	ETF	143.57	144.66	143.51	144.04	13614700.0
2019-08-19	AAAU	ETF	14.97	15.01	14.91	14.93	84100.0
2019-08-19	AADR	ETF	49.17	49.17	48.64	48.81	5100.0
2019-08-19	AAXJ	ETF	65.54	65.59	65.1	65.13	972400.0
2019-08-19	ACES	ETF	31.77	33.0	31.04	31.193	327200.0
2019-08-19	ACIO	ETF	24.29	24.46	24.29	24.34	4900.0
2019-08-19	ACSI	ETF	33.4	33.5	33.4	33.41	2393.0
2019-08-19	ACTX	ETF	25.9602	25.9602	20.6502	21.2402	729.0
2019-08-19	ACWF	ETF	28.17	28.19	28.13	28.1595	35736.0
2019-08-19	ACWI	ETF	71.96	72.06	71.77	71.84	1769200.0
2019-08-19	ACWV	ETF	93.25	93.3	92.94	93.08	204800.0
2019-08-19	ACWX	ETF	44.59	44.62	44.425	44.45	1730866.0
2019-08-19	ADRE	ETF	38.21	38.3999	38.05	38.19	8203.0
2019-08-19	AFIF	ETF	9.57	9.6	9.56	9.58	12452.0
2019-08-19	AFK	ETF	19.7	19.75	19.6761	19.75	8991.0
2019-08-19	AFTY	ETF	16.8	16.822	16.76	16.76	1300.0
2019-08-19	AGG	ETF	113.34	113.46	113.27	113.37	2900800.0
2019-08-19	AGGY	ETF	52.47	52.53	52.422	52.48	161400.0
2019-08-19	AGNG	ETF	21.39	21.39	21.383	21.383	400.0
2019-08-19	AGQ	ETF	29.88	30.07	29.51	29.51	319400.0
2019-08-19	AGZ	ETF	116.81	116.8711	116.7407	116.75	22300.0
2019-08-19	AGZD	ETF	23.87	23.885	23.83	23.85	29000.0
2019-08-19	AIA	ETF	57.25	57.25	56.7655	56.83	45858.0
2019-08-19	AIEQ	ETF	25.96	26.02	25.87	25.9	26000.0
2019-08-19	AIQ	ETF	15.95	16.056	15.95	16.01	23507.0
2019-08-19	AIRR	ETF	25.33	25.37	25.22	25.22	6800.0
2019-08-19	AIVI	ETF	39.19	39.23	39.14	39.16	6400.0
2019-08-19	ALTY	ETF	14.74	14.75	14.69	14.72	5800.0
2019-08-19	AMJ	ETF	23.63	23.76	23.45	23.63	1762227.0
2019-08-19	AMLP	ETF	45.25	45.8	45.2	45.5	3389980.0
2019-08-19	AMUB	ETF	14.9038	14.9038	14.9038	14.9038	0.0
2019-08-19	AMZA	ETF	48.6	49.4	48.6	49.0	98710.0
2019-08-19	ANGL	ETF	28.84	29.0	28.84	28.98	178100.0
2019-08-19	AOA	ETF	53.72	53.78	53.65	53.72	45300.0
2019-08-19	AOK	ETF	35.45	35.45	35.38	35.4	61967.0
2019-08-19	AOM	ETF	38.89	38.89	38.8	38.83	88359.0
2019-08-19	AOR	ETF	45.29	45.35	45.22	45.23	52476.0
2019-08-19	ARCM	ETF	21.78	100.205	20.51	100.205	15400.0
2019-08-19	ARGT	ETF	25.39	25.39	23.85	23.85	154500.0
2019-08-19	ARKF	ETF	21.64	21.64	21.556	21.632	12200.0
2019-08-19	ARKG	ETF	32.88	32.93	32.47	32.82	231100.0
2019-08-19	ARKK	ETF	45.45	45.585	45.1	45.55	281100.0
2019-08-19	ARKQ	ETF	31.32	31.36	31.153	31.3	12000.0
2019-08-19	ARKW	ETF	49.67	50.02	49.5	49.97	143500.0
2019-08-19	ASEA	ETF	15.58	15.89	15.57	15.57	2400.0

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

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