PREVIEW / etf_daily / 2019-12-05

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-05.parquet
  size:    72 KB
  rows:    1,903

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-12-05	SPY	ETF	312.23	312.25	310.58	312.02	40709000.0
2019-12-05	QQQ	ETF	203.15	203.15	201.84	202.83	15038785.0
2019-12-05	IWM	ETF	161.47	161.65	160.45	160.94	11470700.0
2019-12-05	DIA	ETF	277.86	277.86	276.15	277.36	1453000.0
2019-12-05	GLD	ETF	138.8	139.45	138.79	139.0	5671500.0
2019-12-05	TLT	ETF	138.66	139.44	138.6	139.12	7273800.0
2019-12-05	AAAU	ETF	14.71	14.77	14.71	14.73	12800.0
2019-12-05	AADR	ETF	51.24	51.38	50.99	51.38	5600.0
2019-12-05	AAXJ	ETF	69.53	69.84	69.51	69.71	632300.0
2019-12-05	ACES	ETF	32.4	32.4	32.1	32.12	3300.0
2019-12-05	ACIO	ETF	25.25	25.25	25.187	25.187	4400.0
2019-12-05	ACSI	ETF	34.82	34.9702	34.82	34.8974	1674.0
2019-12-05	ACTX	ETF	7.0801	7.0801	6.4901	7.0801	301.0
2019-12-05	ACWF	ETF	30.4266	30.48	30.3779	30.48	4848.0
2019-12-05	ACWI	ETF	77.3	77.33	76.97	77.26	1986600.0
2019-12-05	ACWV	ETF	95.7	95.7	95.36	95.62	119200.0
2019-12-05	ACWX	ETF	47.99	47.99	47.83	47.95	1231178.0
2019-12-05	ADME	ETF	30.067	30.157	30.067	30.157	5100.0
2019-12-05	ADRE	ETF	41.61	42.1099	41.61	42.05	13439.0
2019-12-05	AFIF	ETF	9.76	9.7601	9.76	9.7601	1331.0
2019-12-05	AFK	ETF	20.74	20.74	20.61	20.645	4226.0
2019-12-05	AFLG	ETF	20.04	20.04	20.029	20.029	50200.0
2019-12-05	AFMC	ETF	20.04	20.06	20.04	20.06	51000.0
2019-12-05	AFSM	ETF	20.129	20.129	20.117	20.117	50100.0
2019-12-05	AFTY	ETF	17.2	17.26	17.2	17.245	11000.0
2019-12-05	AGG	ETF	112.58	112.74	112.53	112.68	4374700.0
2019-12-05	AGGY	ETF	52.23	52.28	52.172	52.28	100300.0
2019-12-05	AGNG	ETF	23.56	23.685	23.56	23.685	1000.0
2019-12-05	AGQ	ETF	28.32	28.84	28.32	28.69	155100.0
2019-12-05	AGZ	ETF	115.87	115.97	115.8179	115.935	23539.0
2019-12-05	AGZD	ETF	23.99	24.03	23.93	24.03	54000.0
2019-12-05	AIA	ETF	61.29	61.6	61.1728	61.6	62237.0
2019-12-05	AIEQ	ETF	27.57	27.671	27.527	27.57	11100.0
2019-12-05	AIQ	ETF	17.12	17.12	17.04	17.08	4721.0
2019-12-05	AIRR	ETF	28.5	28.5	28.39	28.451	3100.0
2019-12-05	AIVI	ETF	41.81	41.81	41.71	41.75	5500.0
2019-12-05	ALTY	ETF	14.62	14.64	14.6	14.626	15300.0
2019-12-05	AMJ	ETF	20.07	20.09	19.84	19.84	2918315.0
2019-12-05	AMLP	ETF	38.85	39.15	38.55	38.55	7664780.0
2019-12-05	AMOM	ETF	26.61	26.61	26.557	26.557	100.0
2019-12-05	AMUB	ETF	12.53	12.53	12.5165	12.5165	900.0
2019-12-05	AMZA	ETF	40.3	40.6	39.9	40.0	51020.0
2019-12-05	ANGL	ETF	29.26	29.29	29.21	29.29	419700.0
2019-12-05	AOA	ETF	56.79	56.87	56.7	56.73	48400.0
2019-12-05	AOK	ETF	35.99	36.0	35.87	35.99	72169.0
2019-12-05	AOM	ETF	39.82	39.84	39.71	39.82	129477.0
2019-12-05	AOR	ETF	47.15	47.15	47.03	47.07	122861.0
2019-12-05	ARGT	ETF	23.37	23.6	23.37	23.52	29700.0
2019-12-05	ARKF	ETF	23.62	23.675	23.607	23.646	10000.0
2019-12-05	ARKG	ETF	34.6	34.6	33.9	34.1	127200.0

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

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