PREVIEW / etf_daily / 2019-11-20

all etf daily files

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

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-20	SPY	ETF	311.28	311.85	309.06	310.77	79406200.0
2019-11-20	QQQ	ETF	202.85	203.45	200.62	202.15	36706275.0
2019-11-20	IWM	ETF	158.55	159.6	157.26	158.51	21314300.0
2019-11-20	DIA	ETF	278.64	278.9	276.72	278.2	2463600.0
2019-11-20	GLD	ETF	138.53	139.0	138.1	138.76	6892100.0
2019-11-20	TLT	ETF	139.91	140.6	139.77	140.6	7905500.0
2019-11-20	AAAU	ETF	14.69	14.72	14.64	14.7	33300.0
2019-11-20	AADR	ETF	50.13	50.13	49.79	50.02	3600.0
2019-11-20	AAXJ	ETF	70.26	70.4	69.86	70.03	602900.0
2019-11-20	ACES	ETF	31.96	32.01	31.65	31.715	13600.0
2019-11-20	ACIO	ETF	25.14	25.18	25.1	25.113	217800.0
2019-11-20	ACSI	ETF	34.62	34.6719	34.5661	34.5661	5642.0
2019-11-20	ACTX	ETF	6.7851	7.3161	6.496	7.0801	198.0
2019-11-20	ACWF	ETF	30.53	30.5583	30.32	30.4358	11601.0
2019-11-20	ACWI	ETF	77.16	77.32	76.71	77.04	1767200.0
2019-11-20	ACWV	ETF	95.57	95.91	95.4	95.59	185400.0
2019-11-20	ACWX	ETF	47.93	48.045	47.73	47.88	1282550.0
2019-11-20	ADME	ETF	30.26	30.26	30.115	30.179	70900.0
2019-11-20	ADRE	ETF	40.89	40.923	40.6753	40.8	4936.0
2019-11-20	AFIF	ETF	9.76	9.7752	9.76	9.7752	2304.0
2019-11-20	AFK	ETF	20.818	20.8773	20.75	20.7851	1777.0
2019-11-20	AFTY	ETF	17.54	17.62	17.407	17.506	6600.0
2019-11-20	AGG	ETF	112.83	112.98	112.81	112.97	3474400.0
2019-11-20	AGGY	ETF	52.28	52.31	52.24	52.31	66000.0
2019-11-20	AGNG	ETF	23.356	23.362	23.24	23.285	2800.0
2019-11-20	AGQ	ETF	29.25	29.56	29.11	29.55	140700.0
2019-11-20	AGZ	ETF	116.29	116.3699	116.21	116.32	86087.0
2019-11-20	AGZD	ETF	24.005	24.005	23.965	23.975	7600.0
2019-11-20	AIA	ETF	62.55	62.68	62.18	62.4	19405.0
2019-11-20	AIEQ	ETF	27.43	27.602	27.4	27.58	35000.0
2019-11-20	AIQ	ETF	17.11	17.1899	17.02	17.065	8984.0
2019-11-20	AIRR	ETF	28.365	28.424	28.01	28.286	8000.0
2019-11-20	AIVI	ETF	41.7	41.85	41.63	41.71	4300.0
2019-11-20	ALTY	ETF	14.69	14.69	14.603	14.65	10800.0
2019-11-20	AMJ	ETF	20.23	20.44	20.17	20.34	4267504.0
2019-11-20	AMLP	ETF	38.6	38.95	38.4	38.7	6824720.0
2019-11-20	AMUB	ETF	12.8394	12.8394	12.8394	12.8394	1.0
2019-11-20	AMZA	ETF	40.2	40.4	39.6	40.4	123770.0
2019-11-20	ANGL	ETF	29.25	29.25	29.02	29.07	1102300.0
2019-11-20	AOA	ETF	56.73	56.82	56.37	56.66	31000.0
2019-11-20	AOK	ETF	35.99	36.1	35.96	36.03	73263.0
2019-11-20	AOM	ETF	39.75	39.8073	39.65	39.75	306157.0
2019-11-20	AOR	ETF	47.01	47.13	46.93	47.04	216427.0
2019-11-20	ARGT	ETF	21.96	22.62	21.96	22.59	35400.0
2019-11-20	ARKF	ETF	23.14	23.37	23.08	23.26	19100.0
2019-11-20	ARKG	ETF	32.71	33.35	32.38	32.89	161600.0
2019-11-20	ARKK	ETF	48.15	48.79	47.749	48.43	213200.0
2019-11-20	ARKQ	ETF	34.46	34.54	34.031	34.32	42700.0
2019-11-20	ARKW	ETF	54.29	54.94	53.984	54.53	58700.0
2019-11-20	ASEA	ETF	16.01	16.04	15.99	16.01	2500.0

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

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