PREVIEW / etf_daily / 2018-02-21

all etf daily files

  file:    by_date/etf_daily/2018/2018-02-21.parquet
  size:    61 KB
  rows:    1,566

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-02-21	SPY	ETF	271.9	274.72	269.94	270.05	98883700.0
2018-02-21	QQQ	ETF	166.06	167.72	164.72	164.82	41161779.0
2018-02-21	IWM	ETF	152.42	154.81	152.01	152.24	26735500.0
2018-02-21	DIA	ETF	249.6	252.51	247.71	247.72	5894800.0
2018-02-21	GLD	ETF	126.36	126.76	125.44	125.66	7908800.0
2018-02-21	TLT	ETF	118.24	118.29	116.51	116.74	12054300.0
2018-02-21	AADR	ETF	61.37	62.13	61.2	61.2	36100.0
2018-02-21	AAXJ	ETF	78.55	79.39	77.87	77.89	503600.0
2018-02-21	ACSI	ETF	31.13	31.16	31.06	31.06	690.0
2018-02-21	ACTX	ETF	72.5707	72.5707	66.0806	70.8006	382.0
2018-02-21	ACWF	ETF	31.62	31.72	31.4801	31.5	23861.0
2018-02-21	ACWI	ETF	73.44	74.12	72.92	72.93	1340900.0
2018-02-21	ACWV	ETF	83.95	84.4	83.16	83.24	150500.0
2018-02-21	ACWX	ETF	50.75	51.09	50.33	50.35	434327.0
2018-02-21	ADRE	ETF	45.94	46.4	44.76	45.51	6822.0
2018-02-21	AFK	ETF	25.75	26.15	25.31	26.0	36557.0
2018-02-21	AFTY	ETF	18.8	18.99	18.69	18.69	5000.0
2018-02-21	AGG	ETF	106.77	106.8	106.26	106.35	3223800.0
2018-02-21	AGGY	ETF	49.13	49.17	48.97	49.01	42100.0
2018-02-21	AGNG	ETF	20.1	20.25	20.05	20.22	3700.0
2018-02-21	AGQ	ETF	32.16	32.83	31.67	31.75	383700.0
2018-02-21	AGZ	ETF	111.35	111.39	111.17	111.2048	17930.0
2018-02-21	AGZD	ETF	24.065	24.19	24.025	24.04	13800.0
2018-02-21	AIA	ETF	69.23	69.82	68.48	68.5	82695.0
2018-02-21	AIEQ	ETF	26.7	27.0	26.561	26.561	75100.0
2018-02-21	AIRR	ETF	26.644	26.85	26.5	26.5	32100.0
2018-02-21	AIVI	ETF	43.36	43.52	43.15	43.28	8200.0
2018-02-21	ALTY	ETF	14.74	14.77	14.74	14.75	4400.0
2018-02-21	AMJ	ETF	27.3	27.53	27.045	27.08	1364809.0
2018-02-21	AMLP	ETF	53.0	53.15	52.0	52.1	2370320.0
2018-02-21	AMZA	ETF	80.9	81.4	79.03	79.3	247020.0
2018-02-21	ANGL	ETF	29.55	29.59	29.33	29.38	344800.0
2018-02-21	AOA	ETF	54.39	54.75	54.01	54.07	71700.0
2018-02-21	AOK	ETF	34.36	34.45	34.23	34.25	62486.0
2018-02-21	AOM	ETF	37.93	38.0448	37.75	37.75	77990.0
2018-02-21	AOR	ETF	45.04	45.259	44.75	44.79	109659.0
2018-02-21	ARGT	ETF	37.03	37.36	36.74	36.78	161500.0
2018-02-21	ARKG	ETF	26.5	27.48	26.4	26.71	107500.0
2018-02-21	ARKK	ETF	41.29	42.05	41.031	41.07	348400.0
2018-02-21	ARKQ	ETF	35.34	35.5	34.99	35.0	31100.0
2018-02-21	ARKW	ETF	51.57	52.22	51.25	51.25	288300.0
2018-02-21	ASEA	ETF	17.88	18.23	17.88	18.07	5800.0
2018-02-21	ASET	ETF	27.6092	27.6092	27.53	27.53	1263.0
2018-02-21	ASHR	ETF	32.02	32.24	31.77	31.79	1056300.0
2018-02-21	ASHS	ETF	33.85	33.94	33.63	33.63	6600.0
2018-02-21	ASHX	ETF	22.26	22.26	22.26	22.26	500.0
2018-02-21	ATMP	ETF	20.87	20.87	20.48	20.5	50800.0
2018-02-21	BAB	ETF	29.48	29.5383	29.34	29.34	79368.0
2018-02-21	BAL	ETF	52.79	52.9275	52.14	52.66	3756.0
2018-02-21	BAR	ETF	13.29	13.29	13.223	13.223	14380.0

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

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