PREVIEW / etf_daily / 2020-11-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-18.parquet
  size:    81 KB
  rows:    2,148

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
2020-11-18	SPY	ETF	360.91	361.5	356.24	356.28	70591300.0
2020-11-18	QQQ	ETF	291.7	293.37	290.02	290.11	28069619.0
2020-11-18	IWM	ETF	178.94	179.72	175.86	175.96	24377800.0
2020-11-18	DIA	ETF	299.2	299.75	294.76	294.76	3566400.0
2020-11-18	GLD	ETF	176.26	176.86	175.35	175.49	7384700.0
2020-11-18	TLT	ETF	159.44	159.57	158.35	159.27	10333300.0
2020-11-18	AAA	ETF	25.029	25.05	25.011	25.03	27964.0
2020-11-18	AAAU	ETF	18.7	18.77	18.62	18.62	545500.0
2020-11-18	AADR	ETF	56.81	56.9	56.69	56.84	4000.0
2020-11-18	AAXJ	ETF	85.55	85.55	84.94	84.97	1078500.0
2020-11-18	ABEQ	ETF	24.918	24.92	24.681	24.681	1700.0
2020-11-18	ACES	ETF	64.06	64.43	63.28	63.41	91200.0
2020-11-18	ACIO	ETF	27.39	27.4	27.18	27.24	30400.0
2020-11-18	ACSI	ETF	41.3281	41.3281	41.3281	41.3281	218.0
2020-11-18	ACTV	ETF	28.6	28.62	28.115	28.115	2505.0
2020-11-18	ACTX	ETF	2.9	2.93	2.78	2.78	899.0
2020-11-18	ACVF	ETF	26.79	26.79	26.44	26.44	5100.0
2020-11-18	ACWF	ETF	32.14	32.24	31.9086	31.9086	32281.0
2020-11-18	ACWI	ETF	86.99	87.14	86.12	86.12	3746700.0
2020-11-18	ACWV	ETF	96.48	96.56	95.47	95.47	244200.0
2020-11-18	ACWX	ETF	50.67	50.785	50.345	50.35	890708.0
2020-11-18	ADME	ETF	34.925	34.99	34.7	34.7	23600.0
2020-11-18	ADRE	ETF	53.35	53.35	52.4091	52.6934	20025.0
2020-11-18	AESR	ETF	11.51	11.51	11.409	11.409	1100.0
2020-11-18	AFIF	ETF	9.785	9.8	9.77	9.79	22408.0
2020-11-18	AFK	ETF	19.79	19.87	19.5	19.69	9264.0
2020-11-18	AFLG	ETF	21.55	21.55	21.267	21.267	200.0
2020-11-18	AFMC	ETF	19.79	19.79	19.79	19.79	200.0
2020-11-18	AFSM	ETF	20.3	20.3	19.97	19.97	300.0
2020-11-18	AFTY	ETF	21.43	21.5	21.418	21.418	3400.0
2020-11-18	AGG	ETF	117.95	117.99	117.89	117.95	6191100.0
2020-11-18	AGGY	ETF	53.81	53.81	53.74	53.75	114100.0
2020-11-18	AGNG	ETF	26.64	26.69	26.41	26.41	5900.0
2020-11-18	AGQ	ETF	44.69	45.73	43.98	43.98	1174600.0
2020-11-18	AGZ	ETF	120.8	120.8	120.675	120.7	27547.0
2020-11-18	AGZD	ETF	23.54	23.54	23.495	23.495	20800.0
2020-11-18	AIA	ETF	82.39	82.39	81.93	81.93	102964.0
2020-11-18	AIEQ	ETF	32.3	32.36	31.977	32.03	25200.0
2020-11-18	AIQ	ETF	25.2	25.3	25.025	25.0331	36208.0
2020-11-18	AIRR	ETF	31.435	31.52	31.262	31.33	28200.0
2020-11-18	AIVI	ETF	39.07	39.07	38.76	38.76	3500.0
2020-11-18	ALTL	ETF	29.45	29.62	28.87	28.87	4697.0
2020-11-18	ALTY	ETF	11.48	11.58	11.39	11.4	10700.0
2020-11-18	AMJ	ETF	13.74	14.08	13.49	13.51	1907430.0
2020-11-18	AMLP	ETF	24.69	25.49	24.32	24.37	3853200.0
2020-11-18	AMNA	ETF	23.9574	23.9574	23.9574	23.9574	13.0
2020-11-18	AMND	ETF	25.486	25.486	25.486	25.486	0.0
2020-11-18	AMOM	ETF	36.74	36.795	36.539	36.539	1000.0
2020-11-18	AMTR	ETF	27.43	27.85	26.95	26.96	525295.0
2020-11-18	AMUB	ETF	8.54	8.7881	8.495	8.495	17179.0

> showing 50 of 2,148 rows — these rows as CSV

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