PREVIEW / etf_daily / 2019-10-02

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-02.parquet
  size:    71 KB
  rows:    1,849

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-10-02	SPY	ETF	291.5	291.51	286.64	288.06	122539500.0
2019-10-02	QQQ	ETF	186.01	187.204	183.02	184.05	48931982.0
2019-10-02	IWM	ETF	147.63	147.63	145.86	147.25	24894600.0
2019-10-02	DIA	ETF	264.06	264.06	259.57	260.72	6690100.0
2019-10-02	GLD	ETF	140.79	141.88	140.46	141.26	11914300.0
2019-10-02	TLT	ETF	143.46	144.27	143.24	143.61	12891500.0
2019-10-02	AAAU	ETF	14.91	15.02	14.9	14.95	124400.0
2019-10-02	AADR	ETF	46.53	46.71	46.47	46.71	4600.0
2019-10-02	AAXJ	ETF	65.47	65.67	65.31	65.64	824000.0
2019-10-02	ACES	ETF	30.11	30.19	29.971	30.075	30300.0
2019-10-02	ACIO	ETF	24.276	24.276	24.21	24.23	4100.0
2019-10-02	ACSI	ETF	33.4132	33.4132	33.0809	33.0809	683.0
2019-10-02	ACTX	ETF	16.1071	16.1071	12.4078	13.5701	322.0
2019-10-02	ACWF	ETF	28.42	28.44	28.08	28.1832	21427.0
2019-10-02	ACWI	ETF	72.36	72.37	71.38	71.68	2518000.0
2019-10-02	ACWV	ETF	93.85	93.87	92.95	93.18	607400.0
2019-10-02	ACWX	ETF	45.16	45.16	44.73	44.83	2337975.0
2019-10-02	ADRE	ETF	37.96	38.01	37.89	37.9677	9360.0
2019-10-02	AFIF	ETF	9.78	9.78	9.775	9.775	12910.0
2019-10-02	AFK	ETF	19.97	19.97	19.77	19.81	2212.0
2019-10-02	AFTY	ETF	16.6	16.626	16.58	16.626	6900.0
2019-10-02	AGG	ETF	113.19	113.31	113.09	113.2	8637000.0
2019-10-02	AGGY	ETF	52.37	52.46	52.37	52.4	91700.0
2019-10-02	AGNG	ETF	20.96	20.96	20.7	20.932	1000.0
2019-10-02	AGQ	ETF	30.99	31.74	30.77	31.36	367000.0
2019-10-02	AGZ	ETF	116.62	116.8	116.59	116.73	42712.0
2019-10-02	AGZD	ETF	23.91	23.925	23.875	23.895	20200.0
2019-10-02	AIA	ETF	58.0901	58.1	57.8005	57.94	71240.0
2019-10-02	AIEQ	ETF	25.83	25.83	25.41	25.57	22600.0
2019-10-02	AIQ	ETF	15.67	15.67	15.4317	15.5	6341.0
2019-10-02	AIRR	ETF	25.95	25.95	25.668	25.715	2000.0
2019-10-02	AIVI	ETF	39.59	39.59	39.21	39.31	4400.0
2019-10-02	ALTY	ETF	14.83	14.83	14.6	14.65	15200.0
2019-10-02	AMJ	ETF	23.03	23.03	22.75	22.92	1160136.0
2019-10-02	AMLP	ETF	45.35	45.4	44.7	45.05	3789880.0
2019-10-02	AMOM	ETF	25.81	25.81	25.528	25.528	300.0
2019-10-02	AMUB	ETF	14.4012	14.4012	14.4012	14.4012	3.0
2019-10-02	AMZA	ETF	48.8	48.8	47.6	47.8	162290.0
2019-10-02	ANGL	ETF	29.14	29.14	28.92	28.99	268000.0
2019-10-02	AOA	ETF	53.94	54.12	53.39	53.52	135600.0
2019-10-02	AOK	ETF	35.49	35.49	35.29	35.3	78495.0
2019-10-02	AOM	ETF	38.79	38.82	38.6001	38.71	116952.0
2019-10-02	AOR	ETF	45.43	45.43	45.0213	45.15	87699.0
2019-10-02	ARGT	ETF	22.5	22.72	22.3	22.69	46900.0
2019-10-02	ARKF	ETF	21.16	21.16	20.832	20.946	28500.0
2019-10-02	ARKG	ETF	28.23	28.232	27.71	28.22	145400.0
2019-10-02	ARKK	ETF	41.59	41.59	40.82	41.27	699400.0
2019-10-02	ARKQ	ETF	30.93	30.965	30.66	30.91	16300.0
2019-10-02	ARKW	ETF	47.73	47.73	47.0	47.46	76000.0
2019-10-02	ASEA	ETF	15.48	15.51	15.41	15.42	4600.0

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

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