PREVIEW / etf_daily / 2019-08-23

all etf daily files

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

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-23	SPY	ETF	290.92	292.76	283.47	284.85	149161500.0
2019-08-23	QQQ	ETF	186.76	188.45	181.56	182.07	55442893.0
2019-08-23	IWM	ETF	149.22	150.11	144.93	145.43	36974600.0
2019-08-23	DIA	ETF	261.27	263.19	255.04	256.29	6293900.0
2019-08-23	GLD	ETF	141.84	144.33	141.64	144.17	20282200.0
2019-08-23	TLT	ETF	143.52	146.27	143.43	145.96	16191800.0
2019-08-23	AAAU	ETF	15.02	15.27	15.0	15.27	49900.0
2019-08-23	AADR	ETF	49.35	49.71	48.67	48.67	5800.0
2019-08-23	AAXJ	ETF	64.59	65.12	63.72	63.77	1798000.0
2019-08-23	ACES	ETF	30.692	30.97	30.26	30.269	3600.0
2019-08-23	ACIO	ETF	24.413	24.413	24.092	24.092	3400.0
2019-08-23	ACSI	ETF	33.1225	33.3	32.4253	32.4253	1464.0
2019-08-23	ACTX	ETF	20.6502	23.6002	20.6502	23.6002	295.0
2019-08-23	ACWF	ETF	28.0287	28.1604	27.6	27.6	5291.0
2019-08-23	ACWI	ETF	71.6	72.1	70.25	70.44	3962000.0
2019-08-23	ACWV	ETF	93.01	93.5	91.87	92.09	161000.0
2019-08-23	ACWX	ETF	44.36	44.67	43.85	43.87	1290444.0
2019-08-23	ADRE	ETF	37.47	37.47	37.47	37.47	351.0
2019-08-23	AFIF	ETF	9.55	9.705	9.55	9.7	1069.0
2019-08-23	AFK	ETF	19.9608	19.9608	19.76	19.775	2543.0
2019-08-23	AFTY	ETF	16.845	16.925	16.576	16.576	2600.0
2019-08-23	AGG	ETF	113.34	113.91	113.31	113.78	3772100.0
2019-08-23	AGGY	ETF	52.52	52.75	52.5	52.71	139600.0
2019-08-23	AGNG	ETF	21.46	21.46	21.45	21.45	600.0
2019-08-23	AGQ	ETF	30.51	31.73	30.39	31.65	513400.0
2019-08-23	AGZ	ETF	116.77	117.145	116.72	117.07	198744.0
2019-08-23	AGZD	ETF	23.9	23.905	23.845	23.85	9000.0
2019-08-23	AIA	ETF	56.41	56.68	55.4544	55.55	30834.0
2019-08-23	AIEQ	ETF	26.06	26.1	25.45	25.51	27100.0
2019-08-23	AIQ	ETF	15.96	16.1	15.61	15.61	14251.0
2019-08-23	AIRR	ETF	24.96	24.96	24.17	24.17	8800.0
2019-08-23	AIVI	ETF	38.95	39.07	38.62	38.64	143000.0
2019-08-23	ALTY	ETF	14.74	14.75	14.628	14.628	4300.0
2019-08-23	AMJ	ETF	23.36	23.46	22.94	23.01	1636823.0
2019-08-23	AMLP	ETF	45.0	45.25	44.15	44.15	4130280.0
2019-08-23	AMOM	ETF	25.953	25.953	25.953	25.953	100.0
2019-08-23	AMUB	ETF	14.4473	14.4473	14.4473	14.4473	0.0
2019-08-23	AMZA	ETF	47.5	47.6	46.0	46.1	127050.0
2019-08-23	ANGL	ETF	29.24	29.3	29.07	29.11	531400.0
2019-08-23	AOA	ETF	53.54	53.8	52.79	52.89	29300.0
2019-08-23	AOK	ETF	35.39	35.4299	35.2464	35.28	46170.0
2019-08-23	AOM	ETF	38.74	38.862	38.56	38.61	129670.0
2019-08-23	AOR	ETF	45.19	45.352	44.73	44.74	51417.0
2019-08-23	ARGT	ETF	24.5	24.52	23.87	23.89	71300.0
2019-08-23	ARKF	ETF	21.77	21.94	21.273	21.273	13700.0
2019-08-23	ARKG	ETF	32.12	32.46	31.079	31.17	72700.0
2019-08-23	ARKK	ETF	44.69	45.155	43.36	43.51	243600.0
2019-08-23	ARKQ	ETF	31.0	31.18	30.276	30.278	9900.0
2019-08-23	ARKW	ETF	49.8	50.43	48.58	48.66	52100.0
2019-08-23	ASEA	ETF	15.38	15.56	15.32	15.32	1600.0

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

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