PREVIEW / etf_daily / 2014-04-01

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-01.parquet
  size:    44 KB
  rows:    1,077

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
2014-04-01	SPY	ETF	187.62	188.36	187.0	188.25	89193000.0
2014-04-01	QQQ	ETF	88.1	89.27	87.7106	89.21	38683837.0
2014-04-01	IWM	ETF	116.63	118.06	116.59	117.87	47906600.0
2014-04-01	DIA	ETF	164.67	165.31	164.58	164.95	4076100.0
2014-04-01	GLD	ETF	123.71	123.85	123.11	123.39	5992000.0
2014-04-01	TLT	ETF	108.26	108.36	107.84	107.89	9067300.0
2014-04-01	AADR	ETF	38.18	38.28	37.87	37.87	400.0
2014-04-01	AAXJ	ETF	59.66	59.84	59.58	59.83	379700.0
2014-04-01	ACWI	ETF	58.3	58.57	58.3	58.56	1410900.0
2014-04-01	ACWV	ETF	64.33	64.54	64.14	64.46	16000.0
2014-04-01	ACWX	ETF	46.77	46.89	46.76	46.89	223325.0
2014-04-01	ADRE	ETF	36.58	36.7811	36.58	36.7811	18741.0
2014-04-01	AFK	ETF	31.13	31.61	31.13	31.6	8168.0
2014-04-01	AGG	ETF	107.66	107.67	107.54	107.54	760000.0
2014-04-01	AGQ	ETF	64.19	64.38	63.41	64.23	159900.0
2014-04-01	AGZ	ETF	111.37	111.58	111.37	111.58	67290.0
2014-04-01	AIA	ETF	46.33	46.4304	46.3	46.4304	10144.0
2014-04-01	AIQ	ETF	33.11	34.46	33.0	34.15	65203.0
2014-04-01	AIRR	ETF	19.66	19.82	19.65	19.8	13800.0
2014-04-01	AIVI	ETF	49.55	49.64	49.29	49.42	22300.0
2014-04-01	AMJ	ETF	46.48	47.24	46.26	47.22	963817.0
2014-04-01	AMLP	ETF	88.4	89.3	88.3	89.2	713180.0
2014-04-01	ANGL	ETF	27.52	27.52	27.47	27.47	1100.0
2014-04-01	AOA	ETF	45.52	45.65	45.45	45.65	32500.0
2014-04-01	AOK	ETF	32.37	32.49	32.37	32.49	10811.0
2014-04-01	AOM	ETF	34.89	34.93	34.84	34.93	46452.0
2014-04-01	AOR	ETF	39.27	39.33	39.18	39.33	55915.0
2014-04-01	ARGT	ETF	19.88	19.98	19.82	19.98	10900.0
2014-04-01	ASEA	ETF	16.19	16.2	16.12	16.2	35400.0
2014-04-01	ASHR	ETF	21.88	22.08	21.88	22.08	72200.0
2014-04-01	ATMP	ETF	27.82	28.14	27.78	28.07	19600.0
2014-04-01	AVIV	ETF	24.47	24.6	24.14	24.58	123044.0
2014-04-01	AWAY	ETF	37.86	39.37	37.86	38.39	2058709.0
2014-04-01	BAB	ETF	28.59	28.658	28.55	28.58	214399.0
2014-04-01	BAL	ETF	57.65	57.65	57.4304	57.58	8456.0
2014-04-01	BALT	ETF	6.31	6.55	6.255	6.4	554221.0
2014-04-01	BBH	ETF	91.79	94.33	91.74	93.31	582500.0
2014-04-01	BCM	ETF	40.85	40.85	40.674	40.674	2170.0
2014-04-01	BFOR	ETF	7.6325	7.6875	7.6325	7.68	259600.0
2014-04-01	BIB	ETF	40.94	42.775	40.51	41.705	1498518.0
2014-04-01	BICK	ETF	24.7	24.909	24.7	24.909	40619.0
2014-04-01	BIL	ETF	91.54	91.56	91.54	91.54	1279350.0
2014-04-01	BIS	ETF	693.2	703.984	662.8	679.2	15385.5
2014-04-01	BIV	ETF	82.98	83.11	82.96	83.0	309100.0
2014-04-01	BIZD	ETF	20.52	20.52	20.31	20.37	51000.0
2014-04-01	BJK	ETF	53.11	53.41	52.76	53.04	13600.0
2014-04-01	BKF	ETF	36.44	36.5	36.27	36.44	49038.0
2014-04-01	BKLN	ETF	24.83	24.84	24.81	24.84	2671900.0
2014-04-01	BLV	ETF	86.02	86.19	85.95	86.05	53000.0
2014-04-01	BMVP	ETF	23.943	24.027	23.897	24.027	5757.0

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

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