PREVIEW / etf_daily / 2019-12-02

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-02.parquet
  size:    72 KB
  rows:    1,888

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-02	SPY	ETF	314.59	314.66	311.17	311.64	75767800.0
2019-12-02	QQQ	ETF	205.11	205.18	201.78	203.0	28121020.0
2019-12-02	IWM	ETF	162.15	162.21	159.91	160.19	17190900.0
2019-12-02	DIA	ETF	281.45	281.49	278.2	278.2	2544300.0
2019-12-02	GLD	ETF	137.32	138.09	137.3	137.79	8274700.0
2019-12-02	TLT	ETF	138.14	138.67	137.95	138.31	17702200.0
2019-12-02	AAAU	ETF	14.55	14.61	14.55	14.59	39400.0
2019-12-02	AADR	ETF	50.87	50.87	50.32	50.58	5700.0
2019-12-02	AAXJ	ETF	69.72	69.81	69.28	69.44	2421300.0
2019-12-02	ACES	ETF	32.105	32.2	32.1	32.184	11000.0
2019-12-02	ACIO	ETF	25.31	25.31	25.238	25.262	6800.0
2019-12-02	ACSI	ETF	35.272	35.2721	35.0886	35.0886	1173.0
2019-12-02	ACTX	ETF	5.9001	7.0801	5.9001	7.0801	445.0
2019-12-02	ACWF	ETF	30.43	30.5011	30.41	30.4166	7369.0
2019-12-02	ACWI	ETF	77.64	77.64	76.86	77.04	3269300.0
2019-12-02	ACWV	ETF	95.61	95.62	94.97	95.17	203600.0
2019-12-02	ACWX	ETF	47.93	47.93	47.56	47.71	1212256.0
2019-12-02	ADME	ETF	30.16	30.16	30.085	30.085	4300.0
2019-12-02	ADRE	ETF	41.48	41.59	41.2	41.3	8523.0
2019-12-02	AFIF	ETF	9.72	9.73	9.72	9.73	966.0
2019-12-02	AFK	ETF	20.5	20.51	20.483	20.49	8460.0
2019-12-02	AFTY	ETF	17.08	17.08	16.95	16.95	7000.0
2019-12-02	AGG	ETF	112.31	112.51	112.29	112.49	9325100.0
2019-12-02	AGGY	ETF	52.2	52.2	52.061	52.15	120700.0
2019-12-02	AGNG	ETF	23.7	23.71	23.53	23.59	7300.0
2019-12-02	AGQ	ETF	28.5	28.81	28.47	28.51	138400.0
2019-12-02	AGZ	ETF	115.83	115.95	115.83	115.93	33351.0
2019-12-02	AGZD	ETF	23.97	24.035	23.94	23.995	32400.0
2019-12-02	AIA	ETF	61.56	61.56	61.32	61.4	16059.0
2019-12-02	AIEQ	ETF	27.85	27.85	27.44	27.545	25500.0
2019-12-02	AIQ	ETF	17.41	17.41	16.9977	17.0439	11658.0
2019-12-02	AIRR	ETF	28.8	28.84	28.486	28.486	8100.0
2019-12-02	AIVI	ETF	41.8	41.8	41.44	41.56	4100.0
2019-12-02	ALTY	ETF	14.8	14.8	14.654	14.66	7600.0
2019-12-02	AMJ	ETF	20.2	20.24	19.9	19.9	3616799.0
2019-12-02	AMLP	ETF	39.35	39.4	38.75	38.85	5961540.0
2019-12-02	AMUB	ETF	12.59	12.59	12.5425	12.5425	202.0
2019-12-02	AMZA	ETF	40.9	40.9	40.2	40.2	76240.0
2019-12-02	ANGL	ETF	29.22	29.24	29.08	29.19	1119600.0
2019-12-02	AOA	ETF	56.91	56.91	56.52	56.57	46600.0
2019-12-02	AOK	ETF	36.1	36.1	35.87	35.88	97831.0
2019-12-02	AOM	ETF	39.79	39.79	39.6101	39.68	246497.0
2019-12-02	AOR	ETF	47.16	47.16	46.93	46.93	109957.0
2019-12-02	ARGT	ETF	23.65	23.71	23.2	23.2	72900.0
2019-12-02	ARKF	ETF	23.9	23.9	23.431	23.6	7000.0
2019-12-02	ARKG	ETF	35.0	35.06	33.7	33.98	157700.0
2019-12-02	ARKK	ETF	50.32	50.43	48.72	48.96	207100.0
2019-12-02	ARKQ	ETF	34.89	34.89	34.38	34.48	10400.0
2019-12-02	ARKW	ETF	55.94	55.94	54.12	54.46	352900.0
2019-12-02	ASEA	ETF	15.69	15.69	15.65	15.66	2200.0

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

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