PREVIEW / etf_daily / 2019-11-22

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-22.parquet
  size:    71 KB
  rows:    1,871

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-11-22	SPY	ETF	311.09	311.24	309.85	310.96	44850200.0
2019-11-22	QQQ	ETF	202.17	202.32	200.74	201.83	17197019.0
2019-11-22	IWM	ETF	158.31	158.54	157.35	158.22	13482400.0
2019-11-22	DIA	ETF	278.38	279.03	277.79	278.86	1419300.0
2019-11-22	GLD	ETF	138.37	138.46	137.66	137.74	3620300.0
2019-11-22	TLT	ETF	140.1	140.28	139.68	139.9	4664800.0
2019-11-22	AAAU	ETF	14.66	14.66	14.59	14.59	17200.0
2019-11-22	AADR	ETF	49.99	50.03	49.82	49.93	5400.0
2019-11-22	AAXJ	ETF	69.91	69.92	69.61	69.8	353500.0
2019-11-22	ACES	ETF	31.7	31.81	31.52	31.718	8300.0
2019-11-22	ACIO	ETF	25.22	25.22	25.196	25.199	6100.0
2019-11-22	ACSI	ETF	34.7908	34.8612	34.7399	34.8612	5904.0
2019-11-22	ACTX	ETF	7.0801	7.0801	6.4901	7.0801	547.0
2019-11-22	ACWF	ETF	30.51	30.51	30.3737	30.4422	14114.0
2019-11-22	ACWI	ETF	77.15	77.19	76.87	77.08	905500.0
2019-11-22	ACWV	ETF	95.46	95.54	95.04	95.25	175000.0
2019-11-22	ACWX	ETF	47.98	48.01	47.818	47.9	3670396.0
2019-11-22	ADME	ETF	30.092	30.12	30.09	30.11	11200.0
2019-11-22	ADRE	ETF	41.01	41.12	41.01	41.085	1739.0
2019-11-22	AFIF	ETF	9.735	9.7403	9.7052	9.7401	2783.0
2019-11-22	AFK	ETF	20.9	20.9	20.7702	20.785	1797.0
2019-11-22	AFTY	ETF	17.28	17.28	17.132	17.187	19900.0
2019-11-22	AGG	ETF	112.89	112.9	112.76	112.87	2507000.0
2019-11-22	AGGY	ETF	52.27	52.29	52.231	52.27	75200.0
2019-11-22	AGNG	ETF	23.59	23.59	23.115	23.25	4500.0
2019-11-22	AGQ	ETF	29.35	29.45	28.97	28.98	126200.0
2019-11-22	AGZ	ETF	116.33	116.33	116.2341	116.2732	21680.0
2019-11-22	AGZD	ETF	23.99	23.995	23.985	23.99	6200.0
2019-11-22	AIA	ETF	62.09	62.09	61.95	61.97	23720.0
2019-11-22	AIEQ	ETF	27.54	27.54	27.32	27.43	25200.0
2019-11-22	AIQ	ETF	17.051	17.115	17.002	17.115	9061.0
2019-11-22	AIRR	ETF	28.15	28.195	28.061	28.195	1800.0
2019-11-22	AIVI	ETF	41.79	41.82	41.72	41.76	3800.0
2019-11-22	ALTY	ETF	14.66	14.68	14.62	14.66	10500.0
2019-11-22	AMJ	ETF	20.81	21.0	20.76	21.0	3280459.0
2019-11-22	AMLP	ETF	39.75	40.05	39.55	39.85	5225560.0
2019-11-22	AMOM	ETF	26.41	26.41	26.327	26.327	900.0
2019-11-22	AMUB	ETF	13.1956	13.1956	13.1897	13.1897	1250.0
2019-11-22	AMZA	ETF	41.4	41.9	41.2	41.8	246120.0
2019-11-22	ANGL	ETF	29.09	29.15	29.06	29.09	1002500.0
2019-11-22	AOA	ETF	56.7	56.7	56.5	56.68	25900.0
2019-11-22	AOK	ETF	36.03	36.09	35.91	35.95	105515.0
2019-11-22	AOM	ETF	39.76	39.8092	39.7	39.77	167237.0
2019-11-22	AOR	ETF	47.04	47.0958	46.99	47.03	81079.0
2019-11-22	ARGT	ETF	22.69	22.95	22.67	22.78	56500.0
2019-11-22	ARKF	ETF	23.43	23.49	23.303	23.478	11700.0
2019-11-22	ARKG	ETF	32.48	32.788	32.39	32.73	74400.0
2019-11-22	ARKK	ETF	48.26	48.42	48.0	48.42	196700.0
2019-11-22	ARKQ	ETF	34.08	34.32	34.08	34.22	8600.0
2019-11-22	ARKW	ETF	54.74	54.85	54.194	54.84	76100.0

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

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