PREVIEW / etf_daily / 2015-06-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-23.parquet
  size:    48 KB
  rows:    1,182

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
2015-06-23	SPY	ETF	212.14	212.44	211.57	212.04	68476800.0
2015-06-23	QQQ	ETF	110.82	110.89	110.33	110.79	18127916.0
2015-06-23	IWM	ETF	128.68	129.09	128.4	129.01	23378500.0
2015-06-23	DIA	ETF	181.12	181.57	180.75	181.12	3116800.0
2015-06-23	GLD	ETF	112.96	113.17	112.79	112.89	4522800.0
2015-06-23	TLT	ETF	115.73	116.96	115.69	115.95	8945100.0
2015-06-23	AAXJ	ETF	65.36	65.64	65.35	65.62	1961000.0
2015-06-23	ACTX	ETF	2.36	2.36	1.77	2.36	649.0
2015-06-23	ACWF	ETF	25.39	25.39	25.3899	25.3899	2016.0
2015-06-23	ACWI	ETF	62.27	62.4	62.2	62.3	2570700.0
2015-06-23	ACWV	ETF	71.98	72.11	71.91	72.03	78000.0
2015-06-23	ACWX	ETF	46.56	46.7	46.45	46.66	128801.0
2015-06-23	ADRE	ETF	36.0	36.24	35.99	36.24	5551.0
2015-06-23	AFK	ETF	24.87	25.062	24.6254	25.01	33769.0
2015-06-23	AFTY	ETF	21.43	21.52	21.35	21.48	22800.0
2015-06-23	AGG	ETF	108.41	108.64	108.35	108.42	1339000.0
2015-06-23	AGQ	ETF	37.19	37.45	36.79	37.14	471300.0
2015-06-23	AGZ	ETF	113.104	113.159	112.93	112.93	22734.0
2015-06-23	AGZD	ETF	24.39	24.39	24.27	24.355	7000.0
2015-06-23	AIA	ETF	52.2	52.375	52.2	52.36	29958.0
2015-06-23	AIQ	ETF	19.41	19.81	19.07	19.78	14788.0
2015-06-23	AIRR	ETF	18.83	18.891	18.82	18.891	8300.0
2015-06-23	AIVI	ETF	44.55	44.68	44.55	44.6	28400.0
2015-06-23	ALTL	ETF	37.23	37.2669	37.23	37.2669	1350.0
2015-06-23	AMJ	ETF	41.51	41.88	41.46	41.52	1195627.0
2015-06-23	AMLP	ETF	80.7	80.75	80.4	80.5	705580.0
2015-06-23	AMZA	ETF	208.9	208.9	206.9	208.0	2040.0
2015-06-23	ANGL	ETF	27.3	27.32	27.26	27.32	45000.0
2015-06-23	AOA	ETF	48.76	48.76	48.56	48.68	31800.0
2015-06-23	AOK	ETF	32.79	32.8399	32.66	32.72	40852.0
2015-06-23	AOM	ETF	35.56	35.69	35.56	35.66	58851.0
2015-06-23	AOR	ETF	41.32	41.39	41.29	41.39	82535.0
2015-06-23	ARGT	ETF	20.77	20.98	20.77	20.97	6500.0
2015-06-23	ARKG	ETF	24.01	24.01	23.27	23.92	5600.0
2015-06-23	ARKK	ETF	22.23	22.23	22.23	22.23	200.0
2015-06-23	ARKQ	ETF	20.55	20.58	20.55	20.58	2500.0
2015-06-23	ARKW	ETF	23.96	23.96	23.786	23.91	1400.0
2015-06-23	ASEA	ETF	15.25	15.32	15.24	15.3	6000.0
2015-06-23	ASHR	ETF	49.64	49.89	49.46	49.85	2648500.0
2015-06-23	ASHS	ETF	66.04	66.04	65.59	65.92	150100.0
2015-06-23	ATMP	ETF	28.39	28.61	28.39	28.49	59000.0
2015-06-23	AWAY	ETF	31.06	31.51	30.99	31.5	534971.0
2015-06-23	BAB	ETF	28.62	28.7848	28.62	28.62	103221.0
2015-06-23	BAL	ETF	43.19	43.461	42.83	43.37	4688.0
2015-06-23	BALT	ETF	1.55	1.59	1.55	1.58	358955.0
2015-06-23	BBC	ETF	37.5	37.97	36.861	37.44	65382.0
2015-06-23	BBH	ETF	140.96	141.33	139.83	140.57	152300.0
2015-06-23	BBP	ETF	36.72	36.81	35.931	36.53	77600.0
2015-06-23	BCHP	ETF	20.36	20.409	20.36	20.4	881.0
2015-06-23	BCM	ETF	31.47	31.53	31.46	31.53	1849.0

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

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