PREVIEW / etf_daily / 2019-08-22

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-22.parquet
  size:    70 KB
  rows:    1,833

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-22	SPY	ETF	293.23	293.93	290.4	292.36	51666400.0
2019-08-22	QQQ	ETF	188.98	189.46	186.54	188.02	24270520.0
2019-08-22	IWM	ETF	150.67	151.08	149.14	150.03	12979100.0
2019-08-22	DIA	ETF	262.71	263.82	260.95	262.56	2329200.0
2019-08-22	GLD	ETF	141.39	141.9	141.17	141.4	6846500.0
2019-08-22	TLT	ETF	144.0	144.7	143.48	143.6	13878800.0
2019-08-22	AAAU	ETF	14.97	15.02	14.94	14.97	63100.0
2019-08-22	AADR	ETF	49.62	49.62	49.22	49.35	5400.0
2019-08-22	AAXJ	ETF	64.93	64.97	64.42	64.66	679500.0
2019-08-22	ACES	ETF	31.12	31.12	30.83	30.871	3200.0
2019-08-22	ACIO	ETF	24.44	24.5	24.43	24.45	3400.0
2019-08-22	ACSI	ETF	33.46	33.46	33.18	33.3957	977.0
2019-08-22	ACTX	ETF	20.6502	22.1252	20.6502	21.2402	113.0
2019-08-22	ACWF	ETF	28.2844	28.2844	28.0959	28.2392	15970.0
2019-08-22	ACWI	ETF	72.14	72.27	71.56	71.94	1921100.0
2019-08-22	ACWV	ETF	93.19	93.27	92.64	93.05	201500.0
2019-08-22	ACWX	ETF	44.6	44.65	44.32	44.44	496655.0
2019-08-22	ADRE	ETF	38.22	38.23	37.68	37.7025	2052.0
2019-08-22	AFIF	ETF	9.65	9.65	9.6449	9.645	1813.0
2019-08-22	AFK	ETF	19.9	19.97	19.9	19.97	3606.0
2019-08-22	AFTY	ETF	16.82	16.856	16.77	16.82	3400.0
2019-08-22	AGG	ETF	113.51	113.68	113.3	113.32	6294900.0
2019-08-22	AGGY	ETF	52.56	52.64	52.51	52.55	148300.0
2019-08-22	AGNG	ETF	21.557	21.557	21.49	21.49	400.0
2019-08-22	AGQ	ETF	30.2	30.52	30.16	30.23	307100.0
2019-08-22	AGZ	ETF	116.78	116.84	116.64	116.73	58853.0
2019-08-22	AGZD	ETF	23.875	23.91	23.85	23.875	25200.0
2019-08-22	AIA	ETF	56.61	56.72	56.34	56.45	22037.0
2019-08-22	AIEQ	ETF	26.04	26.142	25.89	26.073	21900.0
2019-08-22	AIQ	ETF	16.08	16.15	15.975	16.15	4063.0
2019-08-22	AIRR	ETF	25.08	25.16	25.04	25.16	2400.0
2019-08-22	AIVI	ETF	39.19	39.26	39.05	39.16	4800.0
2019-08-22	ALTY	ETF	14.76	14.82	14.7	14.73	9400.0
2019-08-22	AMJ	ETF	23.74	23.9	23.475	23.5	1166508.0
2019-08-22	AMLP	ETF	45.9	46.0	45.2	45.35	3095180.0
2019-08-22	AMOM	ETF	26.679	26.679	26.679	26.679	100.0
2019-08-22	AMUB	ETF	14.7968	14.7968	14.7968	14.7968	0.0
2019-08-22	AMZA	ETF	48.6	48.71	47.7	47.7	45010.0
2019-08-22	ANGL	ETF	29.21	29.31	29.16	29.23	1588500.0
2019-08-22	AOA	ETF	53.83	53.9	53.54	53.7	118100.0
2019-08-22	AOK	ETF	35.5	35.5	35.35	35.4	133206.0
2019-08-22	AOM	ETF	38.85	38.9	38.74	38.82	67425.0
2019-08-22	AOR	ETF	45.43	45.43	45.1538	45.23	44982.0
2019-08-22	ARCM	ETF	100.245	100.245	100.245	100.245	49800.0
2019-08-22	ARGT	ETF	24.47	24.7	24.35	24.54	152300.0
2019-08-22	ARKF	ETF	21.94	21.94	21.65	21.77	12100.0
2019-08-22	ARKG	ETF	33.02	33.1	32.1	32.25	59600.0
2019-08-22	ARKK	ETF	45.67	45.741	44.68	44.99	127500.0
2019-08-22	ARKQ	ETF	31.27	31.49	30.93	31.22	12600.0
2019-08-22	ARKW	ETF	50.57	50.69	49.69	50.19	41800.0

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

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