PREVIEW / etf_daily / 2019-11-26

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-26.parquet
  size:    72 KB
  rows:    1,876

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-26	SPY	ETF	313.41	314.28	313.06	314.08	37569000.0
2019-11-26	QQQ	ETF	204.32	204.87	204.05	204.61	14812921.0
2019-11-26	IWM	ETF	161.75	162.54	161.29	161.69	15496700.0
2019-11-26	DIA	ETF	281.07	281.58	280.61	281.36	1300300.0
2019-11-26	GLD	ETF	136.98	137.8	136.58	137.74	4724400.0
2019-11-26	TLT	ETF	141.0	141.31	140.94	141.13	4281100.0
2019-11-26	AAAU	ETF	14.5	14.59	14.5	14.58	48900.0
2019-11-26	AADR	ETF	50.38	50.65	50.03	50.65	16400.0
2019-11-26	AAXJ	ETF	70.52	70.81	70.36	70.81	1094800.0
2019-11-26	ACES	ETF	32.17	32.19	32.13	32.16	24600.0
2019-11-26	ACIO	ETF	25.288	25.344	25.282	25.344	25400.0
2019-11-26	ACSI	ETF	35.2211	35.2941	35.2211	35.2941	1283.0
2019-11-26	ACTX	ETF	6.4901	7.0801	5.9001	6.4901	517.0
2019-11-26	ACWF	ETF	30.64	30.77	30.64	30.74	5985.0
2019-11-26	ACWI	ETF	77.62	77.82	77.54	77.73	1372300.0
2019-11-26	ACWV	ETF	95.37	95.9	95.28	95.82	182500.0
2019-11-26	ACWX	ETF	48.16	48.27	48.095	48.21	1193952.0
2019-11-26	ADME	ETF	30.244	30.281	30.22	30.281	19200.0
2019-11-26	ADRE	ETF	41.33	41.6057	41.33	41.6057	162147.0
2019-11-26	AFIF	ETF	9.7501	9.7501	9.7501	9.7501	141.0
2019-11-26	AFK	ETF	20.82	21.98	20.5627	20.6012	10236.0
2019-11-26	AFTY	ETF	17.345	17.421	17.345	17.421	4200.0
2019-11-26	AGG	ETF	113.09	113.16	113.08	113.14	2382200.0
2019-11-26	AGGY	ETF	52.3	52.33	52.27	52.33	70600.0
2019-11-26	AGNG	ETF	23.67	23.783	23.67	23.755	3900.0
2019-11-26	AGQ	ETF	28.75	29.34	28.39	29.33	160800.0
2019-11-26	AGZ	ETF	116.3	116.45	116.3	116.45	79712.0
2019-11-26	AGZD	ETF	23.935	23.975	23.905	23.94	13200.0
2019-11-26	AIA	ETF	62.67	62.88	62.49	62.88	81423.0
2019-11-26	AIEQ	ETF	27.74	27.84	27.667	27.76	41400.0
2019-11-26	AIQ	ETF	17.2619	17.341	17.2619	17.325	6192.0
2019-11-26	AIRR	ETF	28.74	28.934	28.74	28.869	4000.0
2019-11-26	AIVI	ETF	41.9	41.96	41.88	41.96	4300.0
2019-11-26	ALTY	ETF	14.69	14.743	14.67	14.695	15300.0
2019-11-26	AMJ	ETF	21.08	21.1123	20.62	20.7	3402974.0
2019-11-26	AMLP	ETF	40.15	40.25	39.25	39.5	4920820.0
2019-11-26	AMUB	ETF	13.39	13.39	13.0326	13.0326	821.0
2019-11-26	AMZA	ETF	42.1	42.39	41.0	41.2	65760.0
2019-11-26	ANGL	ETF	29.23	29.3	29.22	29.29	516700.0
2019-11-26	AOA	ETF	56.98	57.08	56.98	57.08	36500.0
2019-11-26	AOK	ETF	36.14	36.14	36.04	36.09	340012.0
2019-11-26	AOM	ETF	39.9	39.92	39.87	39.92	178785.0
2019-11-26	AOR	ETF	47.28	47.34	47.23	47.33	92096.0
2019-11-26	ARGT	ETF	23.23	23.3	22.95	23.23	105300.0
2019-11-26	ARKF	ETF	23.85	23.95	23.818	23.95	67300.0
2019-11-26	ARKG	ETF	34.43	34.56	34.001	34.41	173800.0
2019-11-26	ARKK	ETF	49.98	50.128	49.7	50.0	168700.0
2019-11-26	ARKQ	ETF	34.96	34.96	34.654	34.73	8700.0
2019-11-26	ARKW	ETF	55.91	56.16	55.79	56.16	92100.0
2019-11-26	ASEA	ETF	15.89	15.91	15.84	15.84	5600.0

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

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