PREVIEW / etf_daily / 2019-12-10

all etf daily files

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

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-10	SPY	ETF	313.82	314.55	312.81	313.53	52649800.0
2019-12-10	QQQ	ETF	204.17	204.88	203.44	203.9	21849714.0
2019-12-10	IWM	ETF	162.41	162.96	161.94	162.61	13704400.0
2019-12-10	DIA	ETF	279.69	280.14	278.63	279.46	1406900.0
2019-12-10	GLD	ETF	138.25	138.33	137.74	137.97	3240800.0
2019-12-10	TLT	ETF	139.18	139.35	138.41	138.66	4947600.0
2019-12-10	AAAU	ETF	14.64	14.64	14.6	14.61	39500.0
2019-12-10	AADR	ETF	51.75	51.87	51.54	51.72	2200.0
2019-12-10	AAXJ	ETF	70.02	70.21	69.88	70.13	1819500.0
2019-12-10	ACES	ETF	32.23	32.329	32.18	32.277	8600.0
2019-12-10	ACIO	ETF	25.36	25.4	25.326	25.35	6200.0
2019-12-10	ACSI	ETF	35.02	35.13	35.017	35.0604	1426.0
2019-12-10	ACTX	ETF	5.9001	5.9001	5.9001	5.9001	49.0
2019-12-10	ACWF	ETF	30.56	30.6877	30.56	30.6049	9477.0
2019-12-10	ACWI	ETF	77.62	77.8	77.43	77.57	2081800.0
2019-12-10	ACWV	ETF	95.74	95.76	95.54	95.63	180700.0
2019-12-10	ACWX	ETF	48.11	48.25	48.01	48.19	2256994.0
2019-12-10	ADME	ETF	30.256	30.29	30.209	30.209	2900.0
2019-12-10	ADRE	ETF	42.2677	42.2677	42.235	42.235	569.0
2019-12-10	AFIF	ETF	9.7807	9.7807	9.77	9.7701	1912.0
2019-12-10	AFK	ETF	20.4	20.42	20.27	20.27	3890.0
2019-12-10	AFLG	ETF	20.13	20.13	20.082	20.082	300.0
2019-12-10	AFMC	ETF	20.133	20.133	20.102	20.102	100.0
2019-12-10	AFSM	ETF	20.381	20.381	20.345	20.345	100.0
2019-12-10	AFTY	ETF	17.319	17.341	17.3	17.341	1400.0
2019-12-10	AGG	ETF	112.67	112.67	112.49	112.54	3761100.0
2019-12-10	AGGY	ETF	52.26	52.26	52.184	52.209	406200.0
2019-12-10	AGNG	ETF	23.5	23.5	23.5	23.5	300.0
2019-12-10	AGQ	ETF	27.68	27.77	27.45	27.65	116500.0
2019-12-10	AGZ	ETF	115.83	115.84	115.74	115.8	26246.0
2019-12-10	AGZD	ETF	24.005	24.06	24.005	24.035	8400.0
2019-12-10	AIA	ETF	62.05	62.1464	61.89	62.05	62294.0
2019-12-10	AIEQ	ETF	27.68	27.789	27.59	27.66	13900.0
2019-12-10	AIQ	ETF	17.2	17.2396	17.135	17.135	7510.0
2019-12-10	AIRR	ETF	28.53	28.58	28.503	28.53	2800.0
2019-12-10	AIVI	ETF	41.9	42.03	41.77	41.94	43000.0
2019-12-10	ALTY	ETF	14.66	14.73	14.66	14.717	14500.0
2019-12-10	AMJ	ETF	20.51	21.06	20.5	20.94	6680485.0
2019-12-10	AMLP	ETF	39.95	41.05	39.9	40.95	13328080.0
2019-12-10	AMOM	ETF	26.77	26.77	26.666	26.666	600.0
2019-12-10	AMUB	ETF	13.19	13.19	13.1862	13.1862	1178.0
2019-12-10	AMZA	ETF	41.8	43.2	41.71	43.1	96590.0
2019-12-10	ANGL	ETF	29.33	29.41	29.3	29.41	417400.0
2019-12-10	AOA	ETF	56.96	57.08	56.84	57.01	36200.0
2019-12-10	AOK	ETF	36.02	36.05	36.0	36.03	76091.0
2019-12-10	AOM	ETF	39.87	39.9199	39.8002	39.81	219756.0
2019-12-10	AOR	ETF	47.28	47.3	47.17	47.2	88586.0
2019-12-10	ARGT	ETF	24.38	24.41	23.89	23.91	61800.0
2019-12-10	ARKF	ETF	23.61	23.61	23.48	23.481	7500.0
2019-12-10	ARKG	ETF	34.24	34.64	34.002	34.58	96000.0

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

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