PREVIEW / etf_daily / 2016-09-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-08.parquet
  size:    52 KB
  rows:    1,305

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-09-08	SPY	ETF	218.62	218.94	218.15	218.51	74102900.0
2016-09-08	QQQ	ETF	117.57	117.6	116.92	117.23	20125319.0
2016-09-08	IWM	ETF	125.31	125.41	124.77	125.16	16265500.0
2016-09-08	DIA	ETF	184.68	185.11	184.48	184.82	2229900.0
2016-09-08	GLD	ETF	128.16	128.52	127.4	127.59	10561800.0
2016-09-08	TLT	ETF	138.86	139.27	137.26	137.79	14301500.0
2016-09-08	AADR	ETF	40.81	40.81	40.81	40.81	100.0
2016-09-08	AAXJ	ETF	61.11	61.23	60.89	61.0	996100.0
2016-09-08	ACTX	ETF	3.54	3.54	3.481	3.54	1472.0
2016-09-08	ACWI	ETF	59.49	59.64	59.37	59.46	1348200.0
2016-09-08	ACWV	ETF	77.14	77.14	76.72	76.81	175000.0
2016-09-08	ACWX	ETF	42.05	42.13	41.895	41.93	450396.0
2016-09-08	ADRE	ETF	35.35	35.4804	35.2215	35.35	6198.0
2016-09-08	AFK	ETF	20.6193	20.8204	20.6	20.75	3430.0
2016-09-08	AFTY	ETF	13.73	13.79	13.72	13.74	4300.0
2016-09-08	AGG	ETF	112.5	112.56	112.14	112.22	2605500.0
2016-09-08	AGGY	ETF	52.16	52.225	51.96	52.05	23000.0
2016-09-08	AGQ	ETF	51.5	51.93	50.34	50.68	144300.0
2016-09-08	AGZ	ETF	115.67	115.7799	115.446	115.488	21482.0
2016-09-08	AGZD	ETF	23.86	23.925	23.81	23.925	6200.0
2016-09-08	AIA	ETF	50.4	50.531	50.3	50.42	39500.0
2016-09-08	AIQ	ETF	6.33	6.42	6.3	6.39	9124.0
2016-09-08	AIRR	ETF	20.15	20.21	20.13	20.14	5400.0
2016-09-08	AIVI	ETF	39.66	39.82	39.57	39.68	13700.0
2016-09-08	ALTY	ETF	15.98	15.98	15.93	15.96	1000.0
2016-09-08	AMJ	ETF	31.71	32.05	31.66	31.84	2067228.0
2016-09-08	AMLP	ETF	63.95	64.1	63.65	63.7	2005600.0
2016-09-08	AMZA	ETF	118.3	119.1	117.6	118.2	14100.0
2016-09-08	ANGL	ETF	28.69	28.72	28.65	28.67	59600.0
2016-09-08	AOA	ETF	47.87	47.91	47.74	47.78	33800.0
2016-09-08	AOK	ETF	33.5	33.5	33.34	33.34	46345.0
2016-09-08	AOM	ETF	36.22	36.2799	36.07	36.1	54367.0
2016-09-08	AOR	ETF	41.36	41.38	41.1801	41.21	120685.0
2016-09-08	ARGT	ETF	23.39	23.39	23.06	23.15	67500.0
2016-09-08	ARKG	ETF	18.91	18.929	18.91	18.929	700.0
2016-09-08	ARKK	ETF	21.273	21.28	21.27	21.279	2700.0
2016-09-08	ARKQ	ETF	21.33	21.44	21.28	21.44	700.0
2016-09-08	ARKW	ETF	24.85	24.85	24.85	24.85	700.0
2016-09-08	ASEA	ETF	14.1	14.1	14.05	14.07	3300.0
2016-09-08	ASET	ETF	27.2099	27.2099	27.2099	27.2099	100.0
2016-09-08	ASHR	ETF	25.4	25.4	25.27	25.27	693300.0
2016-09-08	ASHS	ETF	35.55	35.7	35.55	35.68	6100.0
2016-09-08	ATMP	ETF	23.5	23.76	23.5	23.71	93900.0
2016-09-08	BAB	ETF	31.67	31.7008	31.5	31.53	269879.0
2016-09-08	BAL	ETF	45.89	46.13	45.84	45.9701	4662.0
2016-09-08	BBC	ETF	20.82	21.203	20.8001	21.1964	5852.0
2016-09-08	BBH	ETF	115.55	116.42	115.1	116.3	37800.0
2016-09-08	BBP	ETF	31.437	31.906	31.437	31.809	3700.0
2016-09-08	BCM	ETF	26.21	26.48	26.21	26.41	5154.0
2016-09-08	BFIT	ETF	15.99	16.0419	15.99	16.0419	1000.0

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

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