PREVIEW / etf_daily / 2016-05-12

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-12.parquet
  size:    50 KB
  rows:    1,262

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
2016-05-12	SPY	ETF	207.29	207.49	205.37	206.56	89586300.0
2016-05-12	QQQ	ETF	106.68	106.735	105.14	105.89	29196323.0
2016-05-12	IWM	ETF	111.19	111.49	109.5	110.37	34803000.0
2016-05-12	DIA	ETF	177.81	178.12	176.4	177.42	2534900.0
2016-05-12	GLD	ETF	122.02	122.39	121.0	121.16	7447100.0
2016-05-12	TLT	ETF	130.66	131.17	130.59	131.01	6087400.0
2016-05-12	AADR	ETF	37.97	38.05	37.92	38.05	1800.0
2016-05-12	AAXJ	ETF	52.33	52.39	51.85	51.92	503500.0
2016-05-12	ACTX	ETF	4.13	4.13	4.13	4.13	25.0
2016-05-12	ACWI	ETF	56.55	56.56	55.89	56.23	1357700.0
2016-05-12	ACWV	ETF	74.21	74.3	73.81	74.1	89600.0
2016-05-12	ACWX	ETF	39.97	39.98	39.44	39.62	386126.0
2016-05-12	ADRE	ETF	30.52	30.52	30.0801	30.22	8063.0
2016-05-12	AFK	ETF	20.52	20.55	20.11	20.35	8420.0
2016-05-12	AFTY	ETF	12.35	12.35	12.35	12.35	500.0
2016-05-12	AGG	ETF	110.92	111.1	110.92	110.99	1938800.0
2016-05-12	AGGY	ETF	51.106	51.13	50.99	51.096	6700.0
2016-05-12	AGNG	ETF	15.179	15.179	15.179	15.179	300.0
2016-05-12	AGQ	ETF	41.26	41.47	39.58	39.81	175500.0
2016-05-12	AGZ	ETF	114.94	115.1363	114.82	114.9	23793.0
2016-05-12	AGZD	ETF	23.92	23.92	23.92	23.92	800.0
2016-05-12	AIA	ETF	41.4	41.4	41.0	41.05	30523.0
2016-05-12	AIQ	ETF	6.81	6.91	6.78	6.81	20111.0
2016-05-12	AIRR	ETF	17.78	17.799	17.67	17.678	3100.0
2016-05-12	AIVI	ETF	38.82	38.82	38.26	38.46	44300.0
2016-05-12	AMJ	ETF	29.78	30.15	29.6	29.92	1786701.0
2016-05-12	AMLP	ETF	59.55	60.15	59.1	59.85	1461100.0
2016-05-12	AMZA	ETF	103.5	106.0	102.61	103.8	15110.0
2016-05-12	ANGL	ETF	26.84	26.84	26.72	26.75	131800.0
2016-05-12	AOA	ETF	45.5	45.5	45.13	45.26	49800.0
2016-05-12	AOK	ETF	32.53	32.53	32.3	32.41	49019.0
2016-05-12	AOM	ETF	35.02	35.02	34.712	34.86	78343.0
2016-05-12	AOR	ETF	39.67	39.67	39.3408	39.4885	23895.0
2016-05-12	ARGT	ETF	20.85	20.97	20.71	20.94	15000.0
2016-05-12	ARKG	ETF	16.54	16.54	16.15	16.25	700.0
2016-05-12	ARKK	ETF	18.29	18.29	17.949	17.949	1800.0
2016-05-12	ARKQ	ETF	18.062	18.062	18.062	18.062	100.0
2016-05-12	ARKW	ETF	20.468	20.468	20.185	20.25	700.0
2016-05-12	ASEA	ETF	12.88	12.88	12.88	12.88	800.0
2016-05-12	ASET	ETF	26.06	26.06	26.06	26.06	200.0
2016-05-12	ASHR	ETF	23.15	23.24	23.01	23.06	1032900.0
2016-05-12	ASHS	ETF	31.72	31.72	31.29	31.44	60500.0
2016-05-12	ASHX	ETF	20.6744	20.6744	20.6744	20.6744	250.0
2016-05-12	ATMP	ETF	20.41	20.66	20.41	20.57	9100.0
2016-05-12	BAB	ETF	30.51	30.56	30.3801	30.51	117041.0
2016-05-12	BAL	ETF	40.29	40.34	40.1	40.25	8071.0
2016-05-12	BBC	ETF	18.07	18.07	17.01	17.175	18983.0
2016-05-12	BBH	ETF	103.86	103.95	101.24	102.08	92200.0
2016-05-12	BBP	ETF	24.8	24.8	23.999	24.02	7100.0
2016-05-12	BFOR	ETF	7.5375	7.5375	7.4175	7.46	58800.0

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

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