PREVIEW / etf_daily / 2019-08-02

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-02.parquet
  size:    70 KB
  rows:    1,848

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-08-02	SPY	ETF	293.85	294.12	290.9	292.62	116749700.0
2019-08-02	QQQ	ETF	188.82	188.99	186.21	187.35	55214006.0
2019-08-02	IWM	ETF	153.35	153.75	151.28	152.58	30148300.0
2019-08-02	DIA	ETF	265.21	265.67	262.43	264.81	5691500.0
2019-08-02	GLD	ETF	135.39	136.6	135.37	135.89	13753200.0
2019-08-02	TLT	ETF	135.66	136.51	135.4	136.51	15143100.0
2019-08-02	AAAU	ETF	14.33	14.45	14.33	14.39	55500.0
2019-08-02	AADR	ETF	50.48	50.55	50.19	50.26	9900.0
2019-08-02	AAXJ	ETF	66.06	66.23	65.55	65.65	1631700.0
2019-08-02	ACES	ETF	31.03	31.03	30.77	30.992	12600.0
2019-08-02	ACIO	ETF	24.7	24.7	24.538	24.631	54200.0
2019-08-02	ACSI	ETF	34.0	34.0	33.79	33.855	1353.0
2019-08-02	ACTX	ETF	20.0602	22.4202	19.4761	19.4761	81.0
2019-08-02	ACWF	ETF	28.62	28.62	28.3824	28.4545	6896.0
2019-08-02	ACWI	ETF	72.87	72.89	72.14	72.51	3615500.0
2019-08-02	ACWV	ETF	92.0	92.31	91.72	92.03	483800.0
2019-08-02	ACWX	ETF	45.4	45.44	45.02	45.21	2246534.0
2019-08-02	ADRE	ETF	38.041	38.18	38.04	38.11	1926.0
2019-08-02	AFIF	ETF	9.81	9.8302	9.81	9.8302	7500.0
2019-08-02	AFK	ETF	21.02	21.08	20.6434	20.6434	3305.0
2019-08-02	AFTY	ETF	16.907	16.907	16.58	16.64	73900.0
2019-08-02	AGG	ETF	111.93	112.04	111.82	111.95	3293700.0
2019-08-02	AGGY	ETF	51.73	51.8	51.68	51.76	173800.0
2019-08-02	AGNG	ETF	21.285	21.337	21.148	21.148	2400.0
2019-08-02	AGQ	ETF	27.18	27.8	27.14	27.49	385900.0
2019-08-02	AGZ	ETF	115.5	115.59	115.44	115.59	26011.0
2019-08-02	AGZD	ETF	23.895	23.94	23.885	23.885	13400.0
2019-08-02	AIA	ETF	58.16	58.33	57.76	57.89	24460.0
2019-08-02	AIEQ	ETF	26.12	26.12	25.81	25.89	77900.0
2019-08-02	AIQ	ETF	16.37	16.37	16.01	16.1225	8009.0
2019-08-02	AIRR	ETF	25.59	25.59	25.37	25.464	9900.0
2019-08-02	AIVI	ETF	39.98	39.98	39.66	39.74	3800.0
2019-08-02	ALTY	ETF	15.25	15.25	15.0	15.0	13500.0
2019-08-02	AMJ	ETF	24.69	24.78	24.41	24.56	2103278.0
2019-08-02	AMLP	ETF	48.45	48.7	47.9	47.9	2469820.0
2019-08-02	AMOM	ETF	26.125	26.125	26.011	26.069	800.0
2019-08-02	AMUB	ETF	15.4614	15.4614	15.4614	15.4614	1.0
2019-08-02	AMZA	ETF	52.9	53.1	52.0	52.2	66150.0
2019-08-02	ANGL	ETF	29.29	29.3	29.14	29.24	459500.0
2019-08-02	AOA	ETF	54.08	54.22	53.77	53.99	44400.0
2019-08-02	AOK	ETF	35.31	35.34	35.16	35.25	66602.0
2019-08-02	AOM	ETF	38.7	38.7842	38.63	38.76	98310.0
2019-08-02	AOR	ETF	45.34	45.4018	45.1314	45.31	66924.0
2019-08-02	ARCM	ETF	99.29	100.125	99.29	100.125	100.0
2019-08-02	ARGT	ETF	31.99	31.99	31.3	31.77	109500.0
2019-08-02	ARKF	ETF	22.46	22.46	21.971	22.144	29700.0
2019-08-02	ARKG	ETF	34.26	34.26	33.0	33.24	151400.0
2019-08-02	ARKK	ETF	47.0	47.21	45.71	46.12	354300.0
2019-08-02	ARKQ	ETF	31.69	31.844	31.25	31.41	18600.0
2019-08-02	ARKW	ETF	51.25	51.314	50.18	50.68	75200.0

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

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