PREVIEW / etf_daily / 2019-07-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-15.parquet
  size:    69 KB
  rows:    1,809

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-07-15	SPY	ETF	301.13	301.13	300.19	300.75	33900000.0
2019-07-15	QQQ	ETF	193.97	194.19	193.44	194.15	15606074.0
2019-07-15	IWM	ETF	156.56	156.59	154.85	155.29	12194300.0
2019-07-15	DIA	ETF	273.55	273.6	272.96	273.6	2624500.0
2019-07-15	GLD	ETF	133.18	133.53	132.81	133.53	4026600.0
2019-07-15	TLT	ETF	130.45	131.05	130.45	130.97	6055500.0
2019-07-15	AAAU	ETF	14.11	14.13	14.06	14.12	5700.0
2019-07-15	AADR	ETF	51.23	51.4	51.21	51.35	7600.0
2019-07-15	AAXJ	ETF	69.72	69.82	69.61	69.82	456200.0
2019-07-15	ACES	ETF	30.51	30.51	30.22	30.37	9700.0
2019-07-15	ACIO	ETF	25.16	25.2	25.16	25.166	292600.0
2019-07-15	ACSI	ETF	34.57	34.57	34.4459	34.5134	2977.0
2019-07-15	ACTX	ETF	26.8806	27.7302	26.8806	27.7302	32.0
2019-07-15	ACWF	ETF	29.76	29.7742	29.681	29.7603	9281.0
2019-07-15	ACWI	ETF	74.99	74.99	74.81	74.91	1982800.0
2019-07-15	ACWV	ETF	93.37	93.56	93.33	93.48	391000.0
2019-07-15	ACWX	ETF	46.99	47.0	46.89	46.93	1589759.0
2019-07-15	ADRE	ETF	40.67	40.7286	40.6283	40.715	2553.0
2019-07-15	AFIF	ETF	9.9	9.91	9.88	9.9	6457.0
2019-07-15	AFK	ETF	22.07	22.07	21.935	21.94	1394.0
2019-07-15	AFTY	ETF	17.55	17.55	17.468	17.51	5500.0
2019-07-15	AGG	ETF	110.87	110.96	110.85	110.95	3619000.0
2019-07-15	AGGY	ETF	51.15	51.18	51.11	51.18	80600.0
2019-07-15	AGNG	ETF	21.18	21.445	21.18	21.36	140200.0
2019-07-15	AGQ	ETF	24.41	24.89	24.41	24.87	283200.0
2019-07-15	AGZ	ETF	114.66	114.8	114.66	114.8	10574.0
2019-07-15	AGZD	ETF	23.92	23.935	23.875	23.915	20600.0
2019-07-15	AIA	ETF	61.1	61.26	61.1	61.25	9779.0
2019-07-15	AIEQ	ETF	27.02	27.04	26.95	26.97	28400.0
2019-07-15	AIQ	ETF	16.81	16.905	16.81	16.8883	3113.0
2019-07-15	AIRR	ETF	26.08	26.09	26.004	26.023	4300.0
2019-07-15	AIVI	ETF	41.18	41.2	41.14	41.16	3300.0
2019-07-15	ALTY	ETF	15.071	15.15	15.07	15.1	4000.0
2019-07-15	AMJ	ETF	25.89	25.89	25.6901	25.7	850384.0
2019-07-15	AMLP	ETF	50.85	50.85	50.5	50.55	1548500.0
2019-07-15	AMOM	ETF	26.7	26.7	26.7	26.7	200.0
2019-07-15	AMUB	ETF	16.2073	16.2073	16.2073	16.2073	0.0
2019-07-15	AMZA	ETF	57.8	57.8	57.5	57.7	41370.0
2019-07-15	ANGL	ETF	29.23	29.33	29.18	29.22	1034900.0
2019-07-15	AOA	ETF	55.24	55.25	55.11	55.21	31900.0
2019-07-15	AOK	ETF	35.29	35.32	35.25	35.26	121441.0
2019-07-15	AOM	ETF	38.85	38.92	38.85	38.91	121967.0
2019-07-15	AOR	ETF	45.92	45.93	45.83	45.93	77540.0
2019-07-15	ARGT	ETF	33.89	33.89	33.01	33.16	143400.0
2019-07-15	ARKF	ETF	23.33	23.357	23.28	23.353	18300.0
2019-07-15	ARKG	ETF	33.61	33.74	33.33	33.57	101900.0
2019-07-15	ARKK	ETF	48.6	48.7	48.18	48.67	129300.0
2019-07-15	ARKQ	ETF	34.1	34.147	33.88	34.1	18800.0
2019-07-15	ARKW	ETF	54.18	54.61	54.0	54.54	51600.0
2019-07-15	ASEA	ETF	16.77	16.98	16.77	16.98	8900.0

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

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