PREVIEW / etf_daily / 2015-07-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-07.parquet
  size:    48 KB
  rows:    1,200

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-07	SPY	ETF	206.96	208.17	204.11	208.02	173820200.0
2015-07-07	QQQ	ETF	107.82	108.07	105.83	107.97	44230772.0
2015-07-07	IWM	ETF	123.88	123.99	121.53	123.88	39347100.0
2015-07-07	DIA	ETF	176.88	177.73	174.44	177.63	7783800.0
2015-07-07	GLD	ETF	111.08	111.14	110.05	110.76	9073400.0
2015-07-07	TLT	ETF	119.66	120.49	118.95	119.26	16160100.0
2015-07-07	AADR	ETF	38.17	38.17	38.17	38.17	200.0
2015-07-07	AAXJ	ETF	60.3	60.68	59.65	60.63	3519700.0
2015-07-07	ACTX	ETF	1.77	1.77	1.77	1.77	792.0
2015-07-07	ACWF	ETF	24.1799	24.27	24.1799	24.27	4100.0
2015-07-07	ACWI	ETF	58.89	59.27	58.13	59.2	2057900.0
2015-07-07	ACWV	ETF	69.8	70.38	69.39	70.28	77400.0
2015-07-07	ACWX	ETF	43.18	43.51	42.6264	43.46	373516.0
2015-07-07	ADRE	ETF	33.88	33.9894	33.11	33.98	14413.0
2015-07-07	AFK	ETF	23.26	23.48	22.84	23.08	41230.0
2015-07-07	AFTY	ETF	19.78	19.81	18.995	19.8	373300.0
2015-07-07	AGG	ETF	109.12	109.38	108.96	108.98	2502500.0
2015-07-07	AGQ	ETF	34.25	34.39	32.0	33.74	840500.0
2015-07-07	AGZ	ETF	113.38	113.5799	113.16	113.26	63531.0
2015-07-07	AGZD	ETF	24.31	24.42	24.31	24.395	6400.0
2015-07-07	AIA	ETF	48.26	48.46	47.6376	48.46	107328.0
2015-07-07	AIQ	ETF	17.93	17.93	17.0	17.2	24397.0
2015-07-07	AIRR	ETF	18.39	18.39	17.83	18.11	10500.0
2015-07-07	AIVI	ETF	41.4	41.82	40.8	41.74	88700.0
2015-07-07	AMJ	ETF	39.25	40.255	38.71	40.1	2192802.0
2015-07-07	AMLP	ETF	77.25	78.9	76.8	78.9	1722500.0
2015-07-07	AMZA	ETF	188.7	193.5	184.7	193.5	1100.0
2015-07-07	ANGL	ETF	27.15	27.15	27.03	27.11	30100.0
2015-07-07	AOA	ETF	46.92	46.92	46.09	46.87	42600.0
2015-07-07	AOK	ETF	32.32	32.43	32.22	32.33	228904.0
2015-07-07	AOM	ETF	35.13	35.13	34.73	35.06	67279.0
2015-07-07	AOR	ETF	40.23	40.23	39.7461	40.11	50212.0
2015-07-07	ARGT	ETF	19.26	19.35	18.82	19.35	7100.0
2015-07-07	ARKG	ETF	22.53	22.82	22.53	22.82	1000.0
2015-07-07	ARKK	ETF	21.0	21.0	20.74	20.98	1500.0
2015-07-07	ARKQ	ETF	19.51	19.718	19.49	19.715	3900.0
2015-07-07	ARKW	ETF	22.25	22.819	22.25	22.819	3300.0
2015-07-07	ASEA	ETF	14.8	14.88	14.7	14.88	8200.0
2015-07-07	ASHR	ETF	38.79	38.8	36.53	38.21	15114800.0
2015-07-07	ASHS	ETF	40.5	40.98	37.5	40.31	718700.0
2015-07-07	ATMP	ETF	26.71	27.44	26.51	27.39	33100.0
2015-07-07	AWAY	ETF	30.7	30.79	29.17	29.85	1989109.0
2015-07-07	BAB	ETF	29.0	29.25	28.7751	28.95	140895.0
2015-07-07	BAL	ETF	44.74	44.74	43.61	44.15	8953.0
2015-07-07	BALT	ETF	1.61	1.61	1.5	1.53	229039.0
2015-07-07	BBC	ETF	36.74	37.1	35.82	36.54	37081.0
2015-07-07	BBH	ETF	136.28	136.28	133.51	135.99	83900.0
2015-07-07	BBP	ETF	34.46	34.68	33.92	34.619	28100.0
2015-07-07	BCM	ETF	29.5	29.915	29.5	29.91	2233.0
2015-07-07	BFOR	ETF	8.265	8.2875	8.12	8.2875	104400.0

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

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