PREVIEW / etf_daily / 2015-05-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-29.parquet
  size:    47 KB
  rows:    1,168

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-05-29	SPY	ETF	212.38	212.43	210.82	211.14	124919600.0
2015-05-29	QQQ	ETF	110.64	110.79	109.79	110.05	30382987.0
2015-05-29	IWM	ETF	124.61	124.73	123.32	123.89	33468900.0
2015-05-29	DIA	ETF	181.17	181.19	179.67	180.11	4923700.0
2015-05-29	GLD	ETF	114.14	114.48	114.0	114.1	3407500.0
2015-05-29	TLT	ETF	123.23	123.57	122.51	122.71	7912000.0
2015-05-29	AAXJ	ETF	66.29	66.58	65.98	66.03	2620100.0
2015-05-29	ACTX	ETF	2.95	4.72	2.655	4.72	5009.0
2015-05-29	ACWF	ETF	25.15	25.15	25.15	25.15	440.0
2015-05-29	ACWI	ETF	62.12	62.12	61.62	61.74	1497700.0
2015-05-29	ACWV	ETF	72.56	72.56	72.01	72.2	116100.0
2015-05-29	ACWX	ETF	46.55	46.6699	46.15	46.31	168646.0
2015-05-29	ADRE	ETF	36.16	36.16	35.87	35.87	6468.0
2015-05-29	AFK	ETF	25.76	25.9	25.61	25.76	9025.0
2015-05-29	AFTY	ETF	22.04	22.04	21.85	21.87	27500.0
2015-05-29	AGG	ETF	110.18	110.3	110.08	110.17	2780300.0
2015-05-29	AGQ	ETF	41.7	41.91	41.39	41.52	85500.0
2015-05-29	AGZ	ETF	113.69	113.8999	113.6	113.729	11084.0
2015-05-29	AGZD	ETF	24.38	24.42	24.365	24.415	5800.0
2015-05-29	AIA	ETF	52.58	52.58	52.262	52.306	8138.0
2015-05-29	AIQ	ETF	19.13	19.13	18.31	18.39	20016.0
2015-05-29	AIRR	ETF	18.13	18.149	18.04	18.13	4800.0
2015-05-29	AIVI	ETF	45.49	45.61	45.2	45.28	14200.0
2015-05-29	AMJ	ETF	43.46	43.68	43.19	43.27	1400685.0
2015-05-29	AMLP	ETF	83.05	83.2	82.7	82.75	504120.0
2015-05-29	AMZA	ETF	216.5	216.9	214.8	216.0	780.0
2015-05-29	ANGL	ETF	27.65	27.69	27.65	27.69	10000.0
2015-05-29	AOA	ETF	48.72	48.72	48.27	48.28	33500.0
2015-05-29	AOK	ETF	33.04	33.06	32.93	32.99	20590.0
2015-05-29	AOM	ETF	35.78	35.9591	35.75	35.8	46450.0
2015-05-29	AOR	ETF	41.41	41.54	41.2101	41.34	48862.0
2015-05-29	ARGT	ETF	21.12	21.13	21.01	21.01	3500.0
2015-05-29	ARKG	ETF	23.51	23.52	23.497	23.497	1300.0
2015-05-29	ARKK	ETF	21.42	21.596	21.42	21.596	600.0
2015-05-29	ARKQ	ETF	20.118	20.118	20.06	20.06	1400.0
2015-05-29	ARKW	ETF	23.47	23.47	23.13	23.13	800.0
2015-05-29	ASEA	ETF	15.35	15.35	15.29	15.31	4200.0
2015-05-29	ASHR	ETF	50.01	50.08	49.78	49.95	1529300.0
2015-05-29	ASHS	ETF	65.14	65.55	64.88	65.48	211800.0
2015-05-29	ATMP	ETF	29.44	29.47	29.35	29.4	18500.0
2015-05-29	AWAY	ETF	28.51	28.596	27.86	28.07	976036.0
2015-05-29	BAB	ETF	29.25	29.3299	29.17	29.18	245810.0
2015-05-29	BAL	ETF	44.6071	45.2199	43.6215	43.65	20003.0
2015-05-29	BALT	ETF	1.5	1.54	1.49	1.52	124788.0
2015-05-29	BAR	ETF	2.6827	2.6827	2.619	2.6436	24650.0
2015-05-29	BBC	ETF	35.05	35.9899	35.05	35.7999	33162.0
2015-05-29	BBH	ETF	135.05	135.71	134.18	134.66	134700.0
2015-05-29	BBP	ETF	32.77	32.85	32.54	32.6	5500.0
2015-05-29	BCHP	ETF	20.5	20.5	20.4999	20.4999	1414.0
2015-05-29	BCM	ETF	31.23	31.51	31.23	31.51	3669.0

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

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