PREVIEW / etf_daily / 2018-11-12

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-12.parquet
  size:    64 KB
  rows:    1,671

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
2018-11-12	SPY	ETF	277.19	277.46	271.99	272.57	99673600.0
2018-11-12	QQQ	ETF	170.33	170.64	166.18	166.33	62578371.0
2018-11-12	IWM	ETF	154.02	154.17	150.84	151.03	21886800.0
2018-11-12	DIA	ETF	259.7	259.92	253.68	254.22	10153000.0
2018-11-12	GLD	ETF	114.01	114.05	113.58	113.66	7498600.0
2018-11-12	TLT	ETF	113.95	114.31	113.91	114.09	6840000.0
2018-11-12	AAAU	ETF	12.05	12.05	12.01	12.01	7700.0
2018-11-12	AADR	ETF	46.39	46.39	45.5	45.63	26100.0
2018-11-12	AAXJ	ETF	63.9	63.97	63.13	63.23	2963700.0
2018-11-12	ACES	ETF	24.6	24.6	24.6	24.6	1300.0
2018-11-12	ACSI	ETF	33.46	33.46	33.2201	33.2201	2570.0
2018-11-12	ACTX	ETF	83.4857	85.5508	76.7007	80.8307	855.0
2018-11-12	ACWF	ETF	28.91	28.91	28.465	28.48	59870.0
2018-11-12	ACWI	ETF	69.85	69.89	68.76	68.89	3088100.0
2018-11-12	ACWV	ETF	85.7	85.78	84.89	85.01	79300.0
2018-11-12	ACWX	ETF	44.3	44.3	43.8	43.86	1555304.0
2018-11-12	ADRE	ETF	37.53	37.53	36.81	36.81	4291.0
2018-11-12	AFIF	ETF	10.0505	10.06	10.02	10.06	21867.0
2018-11-12	AFK	ETF	20.3	20.3	20.09	20.09	4338.0
2018-11-12	AFTY	ETF	14.034	14.064	13.98	13.99	7500.0
2018-11-12	AGG	ETF	104.31	104.35	104.25	104.31	2779700.0
2018-11-12	AGGY	ETF	47.54	47.55	47.49	47.51	49800.0
2018-11-12	AGNG	ETF	20.385	20.39	20.0	20.0	12900.0
2018-11-12	AGQ	ETF	22.1	22.11	21.88	21.92	129800.0
2018-11-12	AGZ	ETF	110.25	110.26	110.1608	110.26	5296.0
2018-11-12	AGZD	ETF	24.25	24.25	23.85	23.93	22200.0
2018-11-12	AIA	ETF	55.95	56.12	55.31	55.33	35800.0
2018-11-12	AIEQ	ETF	27.01	27.01	26.3	26.34	68000.0
2018-11-12	AIQ	ETF	13.63	13.6837	13.63	13.6837	5556.0
2018-11-12	AIRR	ETF	25.56	25.56	25.05	25.05	8800.0
2018-11-12	AIVI	ETF	39.97	39.97	39.75	39.75	3600.0
2018-11-12	ALTY	ETF	14.62	14.657	14.62	14.63	5400.0
2018-11-12	AMJ	ETF	25.96	26.02	25.55	25.58	1088962.0
2018-11-12	AMLP	ETF	49.65	49.7	48.75	48.8	4584260.0
2018-11-12	AMZA	ETF	65.4	65.4	63.6	63.7	67030.0
2018-11-12	ANGL	ETF	27.99	28.01	27.82	27.85	192000.0
2018-11-12	AOA	ETF	51.79	51.79	51.1	51.15	98600.0
2018-11-12	AOK	ETF	33.3	33.38	33.09	33.13	275123.0
2018-11-12	AOM	ETF	36.68	36.68	36.4244	36.45	450451.0
2018-11-12	AOR	ETF	43.21	43.21	42.77	42.78	159549.0
2018-11-12	ARGT	ETF	25.62	25.63	25.3	25.39	18600.0
2018-11-12	ARKG	ETF	29.76	29.76	28.51	28.66	79300.0
2018-11-12	ARKK	ETF	44.13	44.18	42.32	42.76	365200.0
2018-11-12	ARKQ	ETF	33.59	33.59	32.72	32.76	10000.0
2018-11-12	ARKW	ETF	53.18	53.29	50.93	51.46	146000.0
2018-11-12	ARVR	ETF	18.47	18.47	18.47	18.47	779.0
2018-11-12	ASEA	ETF	15.27	15.3	15.17	15.3	1500.0
2018-11-12	ASET	ETF	26.98	26.993	26.8259	26.8259	5063.0
2018-11-12	ASHR	ETF	23.21	23.21	23.01	23.06	2010200.0
2018-11-12	ASHS	ETF	23.54	23.55	23.39	23.46	21700.0

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

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