PREVIEW / etf_daily / 2019-12-09

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-09.parquet
  size:    73 KB
  rows:    1,911

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-09	SPY	ETF	314.44	315.18	313.8	313.88	34838500.0
2019-12-09	QQQ	ETF	204.63	205.5937	203.98	204.07	14032175.0
2019-12-09	IWM	ETF	162.75	163.16	162.39	162.51	13476700.0
2019-12-09	DIA	ETF	280.44	280.72	279.7	279.76	1206100.0
2019-12-09	GLD	ETF	137.8	137.81	137.45	137.58	2711600.0
2019-12-09	TLT	ETF	138.99	139.11	138.57	138.65	4016900.0
2019-12-09	AAAU	ETF	14.6	14.6	14.56	14.58	18300.0
2019-12-09	AADR	ETF	51.54	51.83	51.39	51.7	2200.0
2019-12-09	AAXJ	ETF	70.06	70.24	69.78	69.82	346200.0
2019-12-09	ACES	ETF	32.48	32.48	32.197	32.197	9200.0
2019-12-09	ACIO	ETF	25.4	25.4	25.32	25.35	12800.0
2019-12-09	ACSI	ETF	35.237	35.25	35.1377	35.1377	752.0
2019-12-09	ACTX	ETF	5.9001	7.6701	5.9001	5.9001	258.0
2019-12-09	ACWF	ETF	30.7044	30.7063	30.6185	30.6227	2670.0
2019-12-09	ACWI	ETF	77.78	77.96	77.62	77.62	2160500.0
2019-12-09	ACWV	ETF	95.8	95.89	95.64	95.64	327400.0
2019-12-09	ACWX	ETF	48.23	48.33	48.09	48.11	1356763.0
2019-12-09	ADME	ETF	30.29	30.305	30.262	30.262	9000.0
2019-12-09	ADRE	ETF	42.31	42.4242	42.17	42.17	3119.0
2019-12-09	AFIF	ETF	9.7801	9.785	9.77	9.785	5513.0
2019-12-09	AFK	ETF	20.61	20.61	20.42	20.42	3871.0
2019-12-09	AFLG	ETF	20.131	20.137	20.128	20.128	1300.0
2019-12-09	AFMC	ETF	20.178	20.178	20.168	20.168	1000.0
2019-12-09	AFSM	ETF	20.367	20.37	20.367	20.37	1000.0
2019-12-09	AFTY	ETF	17.36	17.36	17.22	17.23	3000.0
2019-12-09	AGG	ETF	112.69	112.72	112.57	112.58	7398300.0
2019-12-09	AGGY	ETF	52.26	52.29	52.2	52.2	225900.0
2019-12-09	AGNG	ETF	23.75	23.75	23.33	23.518	5200.0
2019-12-09	AGQ	ETF	27.39	27.47	27.31	27.39	97700.0
2019-12-09	AGZ	ETF	115.94	115.94	115.8	115.84	17216.0
2019-12-09	AGZD	ETF	24.025	24.055	24.0	24.055	34400.0
2019-12-09	AIA	ETF	62.21	62.261	61.91	61.99	16770.0
2019-12-09	AIEQ	ETF	27.75	27.84	27.7	27.71	53500.0
2019-12-09	AIQ	ETF	17.24	17.3086	17.13	17.13	8148.0
2019-12-09	AIRR	ETF	28.79	28.79	28.63	28.657	7800.0
2019-12-09	AIVI	ETF	41.96	42.07	41.92	41.92	3900.0
2019-12-09	ALTY	ETF	14.68	14.74	14.67	14.695	100900.0
2019-12-09	AMJ	ETF	20.06	20.51	19.9612	20.51	5490726.0
2019-12-09	AMLP	ETF	38.95	39.9	38.8	39.8	7064320.0
2019-12-09	AMOM	ETF	26.731	26.746	26.682	26.682	500.0
2019-12-09	AMUB	ETF	12.8893	12.8893	12.8893	12.8893	0.0
2019-12-09	AMZA	ETF	40.5	41.8	40.3	41.8	71040.0
2019-12-09	ANGL	ETF	29.29	29.35	29.26	29.3	434700.0
2019-12-09	AOA	ETF	57.11	57.21	56.95	56.95	87800.0
2019-12-09	AOK	ETF	36.07	36.0982	36.03	36.03	52625.0
2019-12-09	AOM	ETF	39.93	39.988	39.85	39.85	117198.0
2019-12-09	AOR	ETF	47.38	47.39	47.2486	47.26	557489.0
2019-12-09	ARGT	ETF	24.08	24.48	24.08	24.42	102600.0
2019-12-09	ARKF	ETF	23.68	23.819	23.59	23.59	10400.0
2019-12-09	ARKG	ETF	34.83	34.911	34.22	34.22	102800.0

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

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