PREVIEW / etf_daily / 2015-07-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-02.parquet
  size:    47 KB
  rows:    1,181

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-07-02	SPY	ETF	208.07	208.27	206.81	207.31	104373700.0
2015-07-02	QQQ	ETF	108.23	108.32	107.62	107.95	20499447.0
2015-07-02	IWM	ETF	124.81	124.96	123.37	123.78	31486400.0
2015-07-02	DIA	ETF	177.79	178.05	176.65	177.05	4008600.0
2015-07-02	GLD	ETF	111.66	111.84	111.41	111.76	3838600.0
2015-07-02	TLT	ETF	116.32	116.66	115.88	116.0	6682100.0
2015-07-02	AAXJ	ETF	63.56	63.88	63.44	63.48	592000.0
2015-07-02	ACTX	ETF	2.36	2.36	1.77	1.77	2005.0
2015-07-02	ACWF	ETF	24.59	24.59	24.58	24.58	492.0
2015-07-02	ACWI	ETF	59.85	60.02	59.71	59.85	747900.0
2015-07-02	ACWV	ETF	70.29	70.46	70.02	70.34	99700.0
2015-07-02	ACWX	ETF	44.57	44.615	44.44	44.56	324851.0
2015-07-02	ADRE	ETF	35.02	35.21	35.02	35.14	13420.0
2015-07-02	AFK	ETF	24.26	24.5	24.1	24.42	8753.0
2015-07-02	AFTY	ETF	19.64	19.82	19.64	19.77	31100.0
2015-07-02	AGG	ETF	108.48	108.6	108.43	108.44	994600.0
2015-07-02	AGQ	ETF	36.4	36.57	35.94	36.28	87800.0
2015-07-02	AGZ	ETF	112.98	113.12	112.64	112.95	11422.0
2015-07-02	AGZD	ETF	24.51	24.51	24.315	24.42	132800.0
2015-07-02	AIA	ETF	50.82	50.92	50.6221	50.67	33302.0
2015-07-02	AIQ	ETF	18.34	18.48	18.0	18.3	16147.0
2015-07-02	AIRR	ETF	18.41	18.41	18.189	18.23	3800.0
2015-07-02	AIVI	ETF	42.8	42.9	42.72	42.8	6900.0
2015-07-02	ALTL	ETF	36.16	36.16	36.16	36.16	525.0
2015-07-02	AMJ	ETF	39.02	39.79	38.96	39.64	2664312.0
2015-07-02	AMLP	ETF	77.3	78.15	77.15	77.95	1144120.0
2015-07-02	AMZA	ETF	196.3	196.5	193.3	195.2	2130.0
2015-07-02	ANGL	ETF	26.91	27.11	26.91	27.06	19000.0
2015-07-02	AOA	ETF	47.4	47.4	47.08	47.25	31800.0
2015-07-02	AOK	ETF	32.31	32.42	32.31	32.33	12297.0
2015-07-02	AOM	ETF	34.99	35.24	34.97	35.07	59267.0
2015-07-02	AOR	ETF	40.47	40.47	40.311	40.4	105011.0
2015-07-02	ARGT	ETF	19.9	19.9	19.76	19.8	1400.0
2015-07-02	ARKG	ETF	22.74	22.74	22.74	22.74	200.0
2015-07-02	ARKK	ETF	21.294	21.294	21.248	21.248	900.0
2015-07-02	ARKQ	ETF	19.889	19.93	19.889	19.93	400.0
2015-07-02	ARKW	ETF	22.96	22.96	22.96	22.96	300.0
2015-07-02	ASEA	ETF	14.99	15.16	14.99	15.08	13000.0
2015-07-02	ASHR	ETF	42.52	42.69	42.35	42.42	4177100.0
2015-07-02	ASHS	ETF	50.37	50.55	50.29	50.43	166000.0
2015-07-02	ATMP	ETF	27.08	27.35	26.94	27.28	745500.0
2015-07-02	AWAY	ETF	31.24	31.36	30.61	31.17	741942.0
2015-07-02	BAB	ETF	28.5	28.8675	28.5	28.69	107144.0
2015-07-02	BAL	ETF	45.49	45.78	45.014	45.07	20444.0
2015-07-02	BALT	ETF	1.61	1.63	1.57	1.63	296761.0
2015-07-02	BBC	ETF	35.67	35.74	35.19	35.65	33993.0
2015-07-02	BBH	ETF	135.65	135.65	134.47	135.1	76400.0
2015-07-02	BBP	ETF	34.46	34.77	34.25	34.77	13400.0
2015-07-02	BFOR	ETF	8.345	8.345	8.285	8.3025	41600.0
2015-07-02	BIB	ETF	91.2	91.65	89.77	90.88	433351.0

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

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