PREVIEW / etf_daily / 2017-12-22

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-22.parquet
  size:    59 KB
  rows:    1,521

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
2017-12-22	SPY	ETF	267.6	267.64	266.9	267.51	78720900.0
2017-12-22	QQQ	ETF	157.31	157.432	156.95	157.37	23330440.0
2017-12-22	IWM	ETF	153.38	153.39	152.8	153.19	13599400.0
2017-12-22	DIA	ETF	247.58	247.61	246.97	247.4	1847000.0
2017-12-22	GLD	ETF	120.67	121.14	120.57	120.94	5791300.0
2017-12-22	TLT	ETF	124.7	124.84	124.53	124.77	3974300.0
2017-12-22	AADR	ETF	58.8	58.93	58.61	58.93	25100.0
2017-12-22	AAXJ	ETF	75.25	75.57	75.18	75.57	673400.0
2017-12-22	ACSI	ETF	31.33	31.35	31.3	31.35	1602.0
2017-12-22	ACTX	ETF	86.7308	95.5809	82.6007	93.8108	1203.0
2017-12-22	ACWF	ETF	30.375	30.48	30.375	30.4672	2147.0
2017-12-22	ACWI	ETF	71.97	72.02	71.84	72.0	1107500.0
2017-12-22	ACWV	ETF	83.82	83.94	83.75	83.89	47000.0
2017-12-22	ACWX	ETF	49.54	49.68	49.52	49.68	555726.0
2017-12-22	ADRE	ETF	42.92	42.9618	42.77	42.831	4798.0
2017-12-22	AFK	ETF	24.46	24.58	23.91	24.13	272263.0
2017-12-22	AFTY	ETF	17.58	17.6	17.57	17.585	4600.0
2017-12-22	AGG	ETF	108.82	108.89	108.81	108.87	3292800.0
2017-12-22	AGGY	ETF	50.54	50.56	50.5	50.525	78100.0
2017-12-22	AGNG	ETF	19.455	19.51	19.43	19.44	900.0
2017-12-22	AGQ	ETF	31.3	31.89	31.12	31.52	161900.0
2017-12-22	AGZ	ETF	112.81	112.82	112.7317	112.7984	9652.0
2017-12-22	AGZD	ETF	24.245	24.245	24.195	24.24	25600.0
2017-12-22	AIA	ETF	65.06	65.3	64.93	65.3	36725.0
2017-12-22	AIEQ	ETF	26.2	26.2	26.0	26.1	60500.0
2017-12-22	AIRR	ETF	27.73	27.73	27.491	27.59	30100.0
2017-12-22	AIVI	ETF	43.46	43.5	43.39	43.48	12400.0
2017-12-22	ALTY	ETF	15.34	15.34	15.28	15.295	2400.0
2017-12-22	AMJ	ETF	27.07	27.43	27.07	27.35	3450025.0
2017-12-22	AMLP	ETF	53.5	54.2	53.4	54.2	5790040.0
2017-12-22	AMZA	ETF	85.4	86.1	85.0	85.8	108040.0
2017-12-22	ANGL	ETF	29.95	29.99	29.87	29.94	517000.0
2017-12-22	AOA	ETF	55.77	55.78	55.69	55.78	72600.0
2017-12-22	AOK	ETF	34.51	34.5691	34.4801	34.51	82036.0
2017-12-22	AOM	ETF	38.7	38.7	38.55	38.61	177541.0
2017-12-22	AOR	ETF	46.16	46.16	46.07	46.1	230942.0
2017-12-22	ARGT	ETF	35.66	35.7	35.48	35.52	23100.0
2017-12-22	ARKG	ETF	24.81	24.93	24.44	24.84	21100.0
2017-12-22	ARKK	ETF	37.38	37.75	36.641	37.75	340100.0
2017-12-22	ARKQ	ETF	33.75	33.829	33.4	33.75	41400.0
2017-12-22	ARKW	ETF	46.43	47.207	45.701	47.14	317900.0
2017-12-22	ASEA	ETF	17.0	17.16	16.99	17.0	5200.0
2017-12-22	ASET	ETF	28.6981	28.6981	28.6981	28.6981	267.0
2017-12-22	ASHR	ETF	30.93	31.05	30.88	30.95	377300.0
2017-12-22	ASHS	ETF	34.5	34.5	34.48	34.48	4500.0
2017-12-22	ASHX	ETF	22.9	22.9	22.75	22.854	6117.0
2017-12-22	ATMP	ETF	20.46	20.69	20.46	20.67	977600.0
2017-12-22	BAB	ETF	30.43	30.44	30.36	30.437	101214.0
2017-12-22	BAL	ETF	51.545	51.84	51.2	51.79	5077.0
2017-12-22	BBC	ETF	27.7	28.42	27.7	28.39	35799.0

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

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