PREVIEW / etf_daily / 2019-12-06

all etf daily files

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

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-06	SPY	ETF	314.12	315.31	314.11	314.87	48927000.0
2019-12-06	QQQ	ETF	204.25	205.145	204.1501	205.0	16562247.0
2019-12-06	IWM	ETF	162.59	163.41	162.5	162.82	16486200.0
2019-12-06	DIA	ETF	279.45	280.94	279.39	280.7	2686400.0
2019-12-06	GLD	ETF	137.76	137.83	137.4	137.62	8714500.0
2019-12-06	TLT	ETF	138.03	139.12	137.86	138.35	7931100.0
2019-12-06	AAAU	ETF	14.6	14.6	14.55	14.57	171400.0
2019-12-06	AADR	ETF	51.59	51.68	51.35	51.56	10000.0
2019-12-06	AAXJ	ETF	70.23	70.26	70.09	70.24	509400.0
2019-12-06	ACES	ETF	32.37	32.48	32.37	32.45	6700.0
2019-12-06	ACIO	ETF	25.38	25.41	25.379	25.385	19000.0
2019-12-06	ACSI	ETF	35.21	35.2907	35.21	35.2152	1114.0
2019-12-06	ACTX	ETF	7.0801	7.6701	5.9001	6.4901	89.0
2019-12-06	ACWF	ETF	30.67	30.7494	30.67	30.74	3685.0
2019-12-06	ACWI	ETF	77.82	77.97	77.76	77.87	1684300.0
2019-12-06	ACWV	ETF	96.04	96.06	95.84	95.9	170100.0
2019-12-06	ACWX	ETF	48.25	48.325	48.22	48.29	1318918.0
2019-12-06	ADME	ETF	30.333	30.4	30.301	30.301	2500.0
2019-12-06	ADRE	ETF	42.21	42.3745	42.18	42.345	13952.0
2019-12-06	AFIF	ETF	9.77	9.7828	9.75	9.765	134104.0
2019-12-06	AFK	ETF	20.7873	20.7873	20.755	20.755	1527.0
2019-12-06	AFLG	ETF	20.2	20.2	20.172	20.172	200.0
2019-12-06	AFMC	ETF	20.258	20.258	20.233	20.233	100.0
2019-12-06	AFSM	ETF	20.438	20.438	20.405	20.405	100.0
2019-12-06	AFTY	ETF	17.47	17.47	17.39	17.4	3800.0
2019-12-06	AGG	ETF	112.47	112.68	112.41	112.52	4648200.0
2019-12-06	AGGY	ETF	52.17	52.266	52.15	52.25	144200.0
2019-12-06	AGNG	ETF	23.818	23.95	23.818	23.95	1200.0
2019-12-06	AGQ	ETF	27.77	27.88	27.17	27.35	522600.0
2019-12-06	AGZ	ETF	115.77	115.92	115.753	115.82	17688.0
2019-12-06	AGZD	ETF	24.015	24.03	23.99	24.0	13600.0
2019-12-06	AIA	ETF	62.09	62.28	62.06	62.28	43947.0
2019-12-06	AIEQ	ETF	27.72	27.848	27.72	27.77	16800.0
2019-12-06	AIQ	ETF	17.24	17.2557	17.2	17.22	2706.0
2019-12-06	AIRR	ETF	28.65	28.94	28.65	28.797	40500.0
2019-12-06	AIVI	ETF	42.07	42.13	42.04	42.1	38300.0
2019-12-06	ALTY	ETF	14.681	14.7	14.64	14.683	11100.0
2019-12-06	AMJ	ETF	19.84	20.1	19.84	20.01	2701966.0
2019-12-06	AMLP	ETF	38.5	39.15	38.5	38.75	4465660.0
2019-12-06	AMOM	ETF	26.78	26.79	26.72	26.746	900.0
2019-12-06	AMUB	ETF	12.5812	12.5812	12.5812	12.5812	0.0
2019-12-06	AMZA	ETF	40.0	40.7	40.0	40.5	60680.0
2019-12-06	ANGL	ETF	29.36	29.39	29.3	29.32	419500.0
2019-12-06	AOA	ETF	57.09	57.23	57.06	57.19	34300.0
2019-12-06	AOK	ETF	36.0	36.06	35.9599	36.04	81747.0
2019-12-06	AOM	ETF	39.91	39.9678	39.8652	39.94	230938.0
2019-12-06	AOR	ETF	47.25	47.3899	47.11	47.37	144379.0
2019-12-06	ARGT	ETF	23.77	24.16	23.73	24.06	51000.0
2019-12-06	ARKF	ETF	23.82	23.836	23.777	23.779	14900.0
2019-12-06	ARKG	ETF	34.3	34.62	34.08	34.59	67200.0

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

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