PREVIEW / etf_daily / 2014-06-05

all etf daily files

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

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-06-05	SPY	ETF	193.41	194.65	192.7	194.45	92103000.0
2014-06-05	QQQ	ETF	91.61	92.46	91.29	92.29	35583055.0
2014-06-05	IWM	ETF	112.72	114.88	112.09	114.78	67182000.0
2014-06-05	DIA	ETF	167.51	168.31	166.92	168.14	5416500.0
2014-06-05	GLD	ETF	120.55	120.88	120.43	120.66	4180400.0
2014-06-05	TLT	ETF	111.13	111.97	111.02	111.59	6915600.0
2014-06-05	AADR	ETF	38.11	38.11	38.07	38.09	2600.0
2014-06-05	AAXJ	ETF	62.36	62.69	62.3	62.67	481300.0
2014-06-05	ACWI	ETF	60.33	60.58	60.06	60.52	520300.0
2014-06-05	ACWV	ETF	66.61	67.03	66.51	66.98	61400.0
2014-06-05	ACWX	ETF	48.39	48.546	48.2	48.5	93882.0
2014-06-05	ADRE	ETF	37.95	38.08	37.9	37.93	11195.0
2014-06-05	AFK	ETF	33.1	33.26	32.89	33.12	91997.0
2014-06-05	AGG	ETF	108.82	108.98	108.77	108.94	643500.0
2014-06-05	AGQ	ETF	58.28	59.02	58.18	58.44	285800.0
2014-06-05	AGZ	ETF	112.37	112.64	112.32	112.4397	8138.0
2014-06-05	AGZD	ETF	24.975	25.015	24.975	25.0	9800.0
2014-06-05	AIA	ETF	48.67	48.8665	48.67	48.8	11671.0
2014-06-05	AIQ	ETF	29.37	31.0	29.305	29.6	59413.0
2014-06-05	AIRR	ETF	18.737	19.08	18.722	19.08	18000.0
2014-06-05	AIVI	ETF	51.09	51.45	51.05	51.39	30400.0
2014-06-05	ALTL	ETF	34.7975	34.7975	34.7975	34.7975	552.0
2014-06-05	AMJ	ETF	50.04	50.16	49.86	50.05	307475.0
2014-06-05	AMLP	ETF	92.0	92.15	91.6	92.05	611780.0
2014-06-05	ANGL	ETF	28.2	28.21	28.2	28.21	4300.0
2014-06-05	AOA	ETF	46.36	46.72	46.29	46.72	22100.0
2014-06-05	AOK	ETF	32.73	32.87	32.73	32.87	146828.0
2014-06-05	AOM	ETF	35.31	35.478	35.305	35.47	17850.0
2014-06-05	AOR	ETF	39.86	40.1	39.8001	40.09	40319.0
2014-06-05	ARGT	ETF	20.46	20.7	20.46	20.69	4100.0
2014-06-05	ASEA	ETF	16.64	16.75	16.64	16.75	5500.0
2014-06-05	ASHR	ETF	21.99	22.11	21.99	22.07	42500.0
2014-06-05	ASHS	ETF	25.69	25.71	25.67	25.67	2900.0
2014-06-05	ATMP	ETF	29.98	30.14	29.96	30.09	66600.0
2014-06-05	AVIV	ETF	28.88	29.31	28.65	29.12	344592.0
2014-06-05	AWAY	ETF	30.15	30.92	29.73	30.84	2096459.0
2014-06-05	BAB	ETF	29.33	29.33	29.21	29.22	77161.0
2014-06-05	BAL	ETF	52.85	53.0202	52.48	52.48	4706.0
2014-06-05	BALT	ETF	6.36	6.49	6.33	6.44	656971.0
2014-06-05	BBH	ETF	93.02	93.93	92.5	93.35	66900.0
2014-06-05	BCHP	ETF	20.54	20.54	20.49	20.5399	10795.0
2014-06-05	BCM	ETF	40.63	40.64	40.63	40.64	1055.0
2014-06-05	BFOR	ETF	7.61	7.6825	7.5825	7.68	96000.0
2014-06-05	BIB	ETF	42.0	42.765	41.185	42.135	522220.0
2014-06-05	BICK	ETF	25.91	26.0999	25.91	25.93	1605.0
2014-06-05	BIL	ETF	91.54	91.54	91.52	91.52	148000.0
2014-06-05	BIS	ETF	638.4	645.2	620.0	628.8	10263.5
2014-06-05	BIV	ETF	84.15	84.28	84.1	84.21	190900.0
2014-06-05	BIZD	ETF	19.7	19.89	19.67	19.81	18900.0
2014-06-05	BJK	ETF	49.47	49.47	49.2	49.34	24000.0

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

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