PREVIEW / etf_daily / 2014-05-01

all etf daily files

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

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-05-01	SPY	ETF	188.22	188.84	187.73	188.33	93019000.0
2014-05-01	QQQ	ETF	87.53	88.15	87.31	87.65	37127219.0
2014-05-01	IWM	ETF	111.75	112.77	110.54	111.94	78690900.0
2014-05-01	DIA	ETF	165.3	165.71	164.9	165.23	3889400.0
2014-05-01	GLD	ETF	123.17	123.83	123.06	123.8	6687300.0
2014-05-01	TLT	ETF	110.88	112.08	110.84	112.02	11556500.0
2014-05-01	AADR	ETF	37.62	37.86	37.62	37.86	2900.0
2014-05-01	AAXJ	ETF	59.52	59.91	59.51	59.8	186200.0
2014-05-01	ACWI	ETF	58.78	58.96	58.7	58.8	3009900.0
2014-05-01	ACWV	ETF	65.47	65.47	65.29	65.42	113500.0
2014-05-01	ACWX	ETF	47.33	47.48	47.33	47.37	1721030.0
2014-05-01	ADRE	ETF	37.22	37.38	37.218	37.23	12052.0
2014-05-01	AFK	ETF	32.94	33.0	32.5735	32.7014	10393.0
2014-05-01	AGG	ETF	108.38	108.7	108.38	108.55	1727500.0
2014-05-01	AGQ	ETF	58.44	59.5	58.09	59.15	406900.0
2014-05-01	AGZ	ETF	111.9	112.1	111.88	112.06	20046.0
2014-05-01	AGZD	ETF	25.0	25.0	25.0	25.0	400.0
2014-05-01	AIA	ETF	46.56	46.7015	46.56	46.61	22376.0
2014-05-01	AIQ	ETF	28.57	28.89	27.92	28.25	33768.0
2014-05-01	AIRR	ETF	19.35	19.35	18.86	18.997	134400.0
2014-05-01	AIVI	ETF	50.31	50.45	50.19	50.34	13400.0
2014-05-01	AMJ	ETF	48.51	48.78	48.39	48.74	508532.0
2014-05-01	AMLP	ETF	90.75	91.1	90.6	91.0	441300.0
2014-05-01	ANGL	ETF	27.85	27.85	27.85	27.85	800.0
2014-05-01	AOA	ETF	45.47	45.56	45.35	45.5	25000.0
2014-05-01	AOK	ETF	32.53	32.57	32.48	32.53	10453.0
2014-05-01	AOM	ETF	34.91	34.95	34.85	34.92	22901.0
2014-05-01	AOR	ETF	39.25	39.31	39.15	39.27	15658.0
2014-05-01	ARGT	ETF	20.0	20.02	19.95	19.97	3100.0
2014-05-01	ASEA	ETF	16.54	16.56	16.52	16.54	2300.0
2014-05-01	ASHR	ETF	21.86	22.1	21.86	22.02	65700.0
2014-05-01	ATMP	ETF	29.0	29.36	29.0	29.36	28500.0
2014-05-01	AVIV	ETF	26.29	26.61	26.16	26.45	183440.0
2014-05-01	AWAY	ETF	32.61	33.95	32.6	33.44	3070799.0
2014-05-01	BAB	ETF	29.04	29.16	29.0201	29.07	110302.0
2014-05-01	BAL	ETF	58.09	58.58	57.21	58.56	72280.0
2014-05-01	BALT	ETF	5.98	6.23	5.91	6.17	714900.0
2014-05-01	BBH	ETF	87.77	89.13	86.58	88.14	98800.0
2014-05-01	BCHP	ETF	20.12	20.12	20.06	20.06	2322.0
2014-05-01	BCM	ETF	41.0	41.11	41.0	41.099	2584.0
2014-05-01	BFOR	ETF	7.4675	7.5	7.4125	7.4425	128400.0
2014-05-01	BIB	ETF	37.255	38.93	36.7	38.165	780716.0
2014-05-01	BICK	ETF	24.49	24.49	24.49	24.49	260.0
2014-05-01	BIL	ETF	91.54	91.54	91.52	91.52	152950.0
2014-05-01	BIS	ETF	722.0	736.396	694.0	710.8	12362.5
2014-05-01	BIV	ETF	83.79	84.03	83.76	83.94	367600.0
2014-05-01	BIZD	ETF	19.93	19.93	19.71	19.81	27600.0
2014-05-01	BJK	ETF	50.14	50.23	49.93	49.98	104300.0
2014-05-01	BKF	ETF	35.84	35.999	35.64	35.88	44133.0
2014-05-01	BKLN	ETF	24.74	24.76	24.72	24.76	3364000.0

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

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