PREVIEW / etf_daily / 2015-04-06

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-06.parquet
  size:    47 KB
  rows:    1,175

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-06	SPY	ETF	205.37	208.45	205.21	207.83	114368200.0
2015-04-06	QQQ	ETF	104.5	106.27	104.34	105.98	24451142.0
2015-04-06	IWM	ETF	123.91	125.48	123.88	125.2	22045600.0
2015-04-06	DIA	ETF	176.32	179.17	176.09	178.59	6284900.0
2015-04-06	GLD	ETF	117.32	117.47	116.52	116.69	5914200.0
2015-04-06	TLT	ETF	131.43	131.48	129.72	130.0	5923800.0
2015-04-06	AADR	ETF	39.46	39.46	39.14	39.18	1000.0
2015-04-06	AAXJ	ETF	65.62	66.13	65.55	65.83	1138900.0
2015-04-06	ACWI	ETF	60.56	61.33	60.56	61.06	469600.0
2015-04-06	ACWV	ETF	72.29	72.97	72.13	72.73	109100.0
2015-04-06	ACWX	ETF	45.68	46.2099	45.59	45.98	133087.0
2015-04-06	ADRE	ETF	35.55	35.95	35.55	35.8383	9663.0
2015-04-06	AFK	ETF	25.92	26.25	25.92	26.25	22852.0
2015-04-06	AFTY	ETF	19.98	20.15	19.98	20.08	13600.0
2015-04-06	AGG	ETF	111.78	111.78	111.37	111.5	1431000.0
2015-04-06	AGQ	ETF	44.42	45.09	43.33	43.46	266600.0
2015-04-06	AGZ	ETF	114.46	114.64	114.3401	114.51	14227.0
2015-04-06	AGZD	ETF	24.53	24.595	24.485	24.595	5600.0
2015-04-06	AIA	ETF	50.95	51.34	50.95	51.26	22900.0
2015-04-06	AIQ	ETF	22.85	23.43	22.63	23.29	13351.0
2015-04-06	AIRR	ETF	19.03	19.11	19.02	19.08	12900.0
2015-04-06	AIVI	ETF	44.58	45.15	44.44	44.85	28500.0
2015-04-06	ALTL	ETF	37.9959	37.9959	37.9959	37.9959	166.0
2015-04-06	AMJ	ETF	43.13	43.38	42.97	43.27	1237614.0
2015-04-06	AMLP	ETF	83.0	83.45	82.95	83.25	678660.0
2015-04-06	AMZA	ETF	214.5	217.2	214.5	216.3	1380.0
2015-04-06	ANGL	ETF	27.3	27.33	27.07	27.3	2800.0
2015-04-06	AOA	ETF	47.58	48.17	47.58	48.01	57000.0
2015-04-06	AOK	ETF	33.06	33.18	32.992	33.14	115988.0
2015-04-06	AOM	ETF	35.66	35.9	35.66	35.86	83702.0
2015-04-06	AOR	ETF	40.76	41.3	40.76	41.21	306502.0
2015-04-06	ARGT	ETF	21.27	21.78	21.27	21.7	10500.0
2015-04-06	ARKG	ETF	22.29	22.69	22.29	22.69	1600.0
2015-04-06	ARKK	ETF	20.76	20.97	20.76	20.97	1800.0
2015-04-06	ARKQ	ETF	20.0	20.15	20.0	20.15	1000.0
2015-04-06	ARKW	ETF	21.68	22.1	21.68	22.1	1600.0
2015-04-06	ASEA	ETF	16.06	16.21	16.06	16.1	2800.0
2015-04-06	ASHR	ETF	43.0	43.61	42.97	43.46	930000.0
2015-04-06	ASHS	ETF	51.66	52.31	51.66	52.24	118500.0
2015-04-06	ATMP	ETF	29.38	29.5	29.36	29.39	19800.0
2015-04-06	AWAY	ETF	30.25	30.946	30.08	30.45	754892.0
2015-04-06	BAB	ETF	30.54	30.5499	30.3001	30.37	58383.0
2015-04-06	BAL	ETF	44.23	44.59	44.1	44.35	17981.0
2015-04-06	BALT	ETF	1.5	1.63	1.5	1.6	337762.0
2015-04-06	BAR	ETF	2.875	2.885	2.833	2.833	19270.0
2015-04-06	BBC	ETF	32.71	32.9599	32.35	32.3976	23871.0
2015-04-06	BBH	ETF	127.26	128.94	126.93	127.48	127100.0
2015-04-06	BBP	ETF	31.6	31.65	31.231	31.231	25500.0
2015-04-06	BCHP	ETF	19.18	19.5558	19.18	19.5558	643.0
2015-04-06	BCM	ETF	31.01	31.34	31.01	31.285	66380.0

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

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