PREVIEW / etf_daily / 2015-02-12

all etf daily files

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

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-02-12	SPY	ETF	207.89	208.99	206.97	208.92	97545900.0
2015-02-12	QQQ	ETF	105.46	106.04	105.3	106.0	22520295.0
2015-02-12	IWM	ETF	120.16	120.92	119.84	120.81	27854600.0
2015-02-12	DIA	ETF	179.27	179.93	179.0	179.84	3742700.0
2015-02-12	GLD	ETF	117.68	117.82	117.09	117.34	4344400.0
2015-02-12	TLT	ETF	129.66	130.54	129.45	129.52	12548300.0
2015-02-12	AADR	ETF	37.06	37.95	37.06	37.91	1500.0
2015-02-12	AAXJ	ETF	62.88	63.22	62.8	63.17	1033600.0
2015-02-12	ACWI	ETF	59.7	60.09	59.67	60.06	592300.0
2015-02-12	ACWV	ETF	71.02	71.18	70.85	71.17	118800.0
2015-02-12	ACWX	ETF	44.01	44.34	43.9601	44.33	757871.0
2015-02-12	ADRE	ETF	35.94	36.39	35.94	36.39	6166.0
2015-02-12	AFK	ETF	25.07	25.2	24.98	25.19	61858.0
2015-02-12	AGG	ETF	110.91	111.12	110.87	110.89	2123700.0
2015-02-12	AGQ	ETF	43.33	43.66	42.66	43.21	97100.0
2015-02-12	AGZ	ETF	113.99	114.809	113.89	114.2	143703.0
2015-02-12	AGZD	ETF	24.575	24.625	24.505	24.555	14400.0
2015-02-12	AIA	ETF	48.68	48.815	48.52	48.81	6174.0
2015-02-12	AIQ	ETF	24.82	25.05	23.62	24.72	21389.0
2015-02-12	AIRR	ETF	17.91	17.97	17.88	17.94	24100.0
2015-02-12	AIVI	ETF	44.25	44.74	44.25	44.74	63900.0
2015-02-12	ALTL	ETF	38.0452	38.0452	38.0452	38.0452	852.0
2015-02-12	AMJ	ETF	45.15	45.47	44.95	45.41	897101.0
2015-02-12	AMLP	ETF	84.55	85.05	84.25	84.9	725960.0
2015-02-12	AMZA	ETF	218.1	218.6	216.9	218.6	260.0
2015-02-12	ANGL	ETF	27.17	27.45	26.97	27.35	10600.0
2015-02-12	AOA	ETF	46.82	47.18	46.82	47.18	38000.0
2015-02-12	AOK	ETF	32.63	32.69	32.63	32.69	15181.0
2015-02-12	AOM	ETF	35.11	35.3504	35.11	35.32	86394.0
2015-02-12	AOR	ETF	40.37	40.58	40.37	40.57	61510.0
2015-02-12	ARGT	ETF	19.58	19.7	19.41	19.7	14700.0
2015-02-12	ARKG	ETF	22.59	22.726	22.52	22.726	6600.0
2015-02-12	ARKK	ETF	21.0	21.19	21.0	21.184	1700.0
2015-02-12	ARKQ	ETF	19.74	19.87	19.72	19.87	10600.0
2015-02-12	ARKW	ETF	21.62	21.62	21.62	21.62	100.0
2015-02-12	ASEA	ETF	15.65	15.75	15.65	15.75	16500.0
2015-02-12	ASHR	ETF	35.2	35.47	35.08	35.38	626300.0
2015-02-12	ASHS	ETF	37.16	37.3	37.15	37.3	900.0
2015-02-12	ATMP	ETF	30.19	30.43	30.14	30.38	98200.0
2015-02-12	AVIV	ETF	36.26	36.7	36.26	36.53	77893.0
2015-02-12	AWAY	ETF	27.64	29.74	27.512	29.565	3148601.0
2015-02-12	BAB	ETF	30.75	30.78	30.5201	30.68	132802.0
2015-02-12	BAL	ETF	42.32	42.8899	42.03	42.8	3821.0
2015-02-12	BALT	ETF	1.68	1.71	1.64	1.65	1389314.0
2015-02-12	BAR	ETF	2.95	2.979	2.916	2.944	122540.0
2015-02-12	BBC	ETF	28.1367	28.8	28.1367	28.7978	3850.0
2015-02-12	BBH	ETF	121.63	122.43	119.87	121.59	151500.0
2015-02-12	BBP	ETF	27.96	28.24	27.84	28.24	1200.0
2015-02-12	BCM	ETF	31.77	31.9299	31.75	31.9299	39852.0
2015-02-12	BFOR	ETF	8.0	8.07	8.0	8.07	171600.0

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

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