PREVIEW / etf_daily / 2017-05-10

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-10.parquet
  size:    55 KB
  rows:    1,393

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-05-10	SPY	ETF	239.39	239.87	239.15	239.87	54293800.0
2017-05-10	QQQ	ETF	138.4	138.45	137.91	138.4	20499363.0
2017-05-10	IWM	ETF	138.04	139.48	137.86	139.21	19791500.0
2017-05-10	DIA	ETF	209.19	209.81	208.9	209.48	1394300.0
2017-05-10	GLD	ETF	116.42	116.5	115.86	116.04	4290500.0
2017-05-10	TLT	ETF	120.91	121.06	120.16	120.48	6517000.0
2017-05-10	AADR	ETF	47.92	48.49	47.92	48.49	42900.0
2017-05-10	AAXJ	ETF	65.32	65.54	65.2	65.54	1241300.0
2017-05-10	ACSI	ETF	28.58	28.64	28.58	28.64	1291.0
2017-05-10	ACTX	ETF	73.7507	79.6507	70.8006	75.5207	289.0
2017-05-10	ACWF	ETF	26.57	26.595	26.57	26.595	970.0
2017-05-10	ACWI	ETF	64.84	65.05	64.84	65.02	932100.0
2017-05-10	ACWV	ETF	78.4	78.49	78.32	78.48	56000.0
2017-05-10	ACWX	ETF	45.33	45.36	45.22	45.35	283320.0
2017-05-10	ADRE	ETF	38.06	38.25	38.06	38.25	22522.0
2017-05-10	AFK	ETF	21.15	21.35	20.9	21.2597	9056.0
2017-05-10	AFTY	ETF	13.6	13.6	13.6	13.6	1300.0
2017-05-10	AGG	ETF	108.6	108.66	108.44	108.53	1653400.0
2017-05-10	AGGY	ETF	50.06	50.06	49.962	50.01	22000.0
2017-05-10	AGQ	ETF	32.66	32.68	32.38	32.54	184700.0
2017-05-10	AGZ	ETF	113.11	113.17	112.87	113.04	15603.0
2017-05-10	AGZD	ETF	24.03	24.09	24.03	24.065	40400.0
2017-05-10	AIA	ETF	55.01	55.07	54.79	55.07	41190.0
2017-05-10	AIQ	ETF	13.15	13.2	13.15	13.2	7365.0
2017-05-10	AIRR	ETF	24.07	24.27	24.0	24.16	29500.0
2017-05-10	AIVI	ETF	40.53	40.58	40.43	40.52	13600.0
2017-05-10	ALTY	ETF	15.37	15.397	15.3	15.397	4900.0
2017-05-10	AMJ	ETF	31.12	31.56	31.01	31.54	1154837.0
2017-05-10	AMLP	ETF	61.15	61.45	60.9	61.45	1393320.0
2017-05-10	AMZA	ETF	103.5	105.0	103.5	105.0	70360.0
2017-05-10	ANGL	ETF	29.46	29.54	29.42	29.54	803600.0
2017-05-10	AOA	ETF	50.93	51.01	50.9	51.0	40000.0
2017-05-10	AOK	ETF	33.59	33.63	33.58	33.6145	67065.0
2017-05-10	AOM	ETF	36.75	36.8	36.746	36.8	71840.0
2017-05-10	AOR	ETF	42.98	43.08	42.9641	43.08	54930.0
2017-05-10	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-05-10	ARGT	ETF	29.93	30.27	29.89	30.16	92600.0
2017-05-10	ARKG	ETF	19.93	20.1	19.83	20.02	6400.0
2017-05-10	ARKK	ETF	26.34	26.55	26.32	26.519	21700.0
2017-05-10	ARKQ	ETF	27.5	27.94	27.46	27.94	40600.0
2017-05-10	ARKW	ETF	31.82	32.1	31.76	31.91	18500.0
2017-05-10	ASHR	ETF	24.05	24.09	24.0	24.02	883100.0
2017-05-10	ASHS	ETF	30.78	30.78	30.7	30.76	14600.0
2017-05-10	ASHX	ETF	18.75	18.78	18.75	18.78	4000.0
2017-05-10	ATMP	ETF	23.15	23.23	22.99	23.22	30300.0
2017-05-10	BAB	ETF	29.4	29.413	29.32	29.33	61223.0
2017-05-10	BAL	ETF	49.19	49.19	48.5739	48.6	11064.0
2017-05-10	BBC	ETF	21.08	21.7517	21.08	21.67	6257.0
2017-05-10	BBH	ETF	120.25	120.25	118.48	118.81	23800.0
2017-05-10	BBP	ETF	37.25	37.25	36.54	36.99	4900.0

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

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