PREVIEW / etf_daily / 2015-04-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-27.parquet
  size:    48 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-04-27	SPY	ETF	212.33	212.48	210.54	210.77	79358100.0
2015-04-27	QQQ	ETF	110.95	111.16	110.02	110.26	31121321.0
2015-04-27	IWM	ETF	126.21	126.91	124.04	124.47	32924600.0
2015-04-27	DIA	ETF	181.46	181.54	179.96	180.17	4969100.0
2015-04-27	GLD	ETF	113.87	115.82	113.67	115.33	7487600.0
2015-04-27	TLT	ETF	129.07	129.5	128.37	129.07	4334900.0
2015-04-27	AADR	ETF	40.84	40.84	40.84	40.84	100.0
2015-04-27	AAXJ	ETF	69.88	69.94	69.68	69.87	987900.0
2015-04-27	ACWI	ETF	62.95	62.98	62.57	62.63	402300.0
2015-04-27	ACWV	ETF	74.41	74.41	73.82	73.83	125800.0
2015-04-27	ACWX	ETF	47.67	47.8899	47.6501	47.685	148101.0
2015-04-27	ADRE	ETF	38.65	38.97	38.65	38.7031	8759.0
2015-04-27	AFK	ETF	26.49	26.75	26.4501	26.64	16941.0
2015-04-27	AFTY	ETF	23.37	23.37	23.15	23.16	312100.0
2015-04-27	AGG	ETF	111.51	111.56	111.34	111.54	1595600.0
2015-04-27	AGQ	ETF	38.37	40.62	38.24	40.13	391100.0
2015-04-27	AGZ	ETF	114.0301	114.39	114.0301	114.11	94774.0
2015-04-27	AGZD	ETF	24.525	24.545	24.41	24.465	4600.0
2015-04-27	AIA	ETF	55.05	55.0999	54.88	54.99	59272.0
2015-04-27	AIQ	ETF	23.17	23.17	22.01	22.47	10956.0
2015-04-27	AIRR	ETF	18.72	18.942	18.58	18.58	85400.0
2015-04-27	AIVI	ETF	46.45	46.56	46.3	46.3	24200.0
2015-04-27	AMJ	ETF	44.8	44.94	44.57	44.59	1052941.0
2015-04-27	AMLP	ETF	85.45	85.7	85.25	85.45	980800.0
2015-04-27	AMZA	ETF	223.6	223.8	221.8	221.8	1360.0
2015-04-27	ANGL	ETF	27.72	27.8	27.67	27.75	16500.0
2015-04-27	AOA	ETF	49.07	49.07	48.87	48.87	50100.0
2015-04-27	AOK	ETF	33.39	33.44	33.34	33.38	85268.0
2015-04-27	AOM	ETF	36.31	36.31	36.1304	36.16	200568.0
2015-04-27	AOR	ETF	41.87	41.8905	41.72	41.72	42264.0
2015-04-27	ARGT	ETF	22.5	22.5	22.26	22.26	4200.0
2015-04-27	ARKG	ETF	24.94	24.94	23.236	23.25	6900.0
2015-04-27	ARKK	ETF	22.24	22.24	22.23	22.23	500.0
2015-04-27	ARKQ	ETF	20.6	20.77	20.6	20.76	22800.0
2015-04-27	ARKW	ETF	23.43	23.43	23.199	23.199	600.0
2015-04-27	ASEA	ETF	16.29	16.38	16.27	16.38	2700.0
2015-04-27	ASHR	ETF	49.48	49.62	49.21	49.4	1923500.0
2015-04-27	ASHS	ETF	56.0	56.25	55.75	55.96	77800.0
2015-04-27	ATMP	ETF	30.65	30.67	30.49	30.51	19100.0
2015-04-27	AWAY	ETF	27.36	27.72	27.17	27.71	2114110.0
2015-04-27	BAB	ETF	30.3	30.44	30.25	30.37	126733.0
2015-04-27	BAL	ETF	45.54	45.95	44.88	44.881	15958.0
2015-04-27	BALT	ETF	1.61	1.63	1.55	1.62	538179.0
2015-04-27	BAR	ETF	2.674	2.75	2.674	2.745	17990.0
2015-04-27	BBC	ETF	34.84	35.01	32.42	32.584	43085.0
2015-04-27	BBH	ETF	134.73	134.73	129.55	129.91	179000.0
2015-04-27	BBP	ETF	33.07	33.199	31.384	31.52	25000.0
2015-04-27	BCM	ETF	31.98	31.98	31.98	31.98	378.0
2015-04-27	BFOR	ETF	8.485	8.5325	8.4075	8.415	70400.0
2015-04-27	BIB	ETF	89.26	89.322	80.747	81.29	2098430.0

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

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