PREVIEW / etf_daily / 2013-07-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-05.parquet
  size:    41 KB
  rows:    1,002

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
2013-07-05	SPY	ETF	162.47	163.08	161.3	163.02	122416900.0
2013-07-05	QQQ	ETF	72.45	72.61	71.86	72.58	28795991.0
2013-07-05	IWM	ETF	99.38	99.75	98.31	99.67	29427500.0
2013-07-05	DIA	ETF	150.72	151.09	149.41	151.02	5528500.0
2013-07-05	GLD	ETF	118.08	118.18	116.74	118.09	11592500.0
2013-07-05	TLT	ETF	107.28	107.5	106.17	106.26	14511900.0
2013-07-05	AADR	ETF	32.79	32.8	32.73	32.8	400.0
2013-07-05	AAXJ	ETF	54.0	54.2	53.41	53.77	299500.0
2013-07-05	ACTV	ETF	8.18	8.28	7.85	8.07	585781.0
2013-07-05	ACWI	ETF	50.52	50.52	49.99	50.42	453600.0
2013-07-05	ACWV	ETF	60.37	61.49	59.55	60.06	63000.0
2013-07-05	ACWX	ETF	40.79	41.03	40.56	40.85	389733.0
2013-07-05	ADRE	ETF	33.87	33.87	33.154	33.4601	19431.0
2013-07-05	AFK	ETF	27.98	27.98	27.58	27.86	23998.0
2013-07-05	AGG	ETF	106.17	106.27	105.82	105.84	1476400.0
2013-07-05	AGQ	ETF	64.0	64.0	61.84	62.88	768300.0
2013-07-05	AGZ	ETF	110.86	110.86	110.28	110.28	9037.0
2013-07-05	AIA	ETF	41.9	41.9	41.52	41.6601	20505.0
2013-07-05	AIQ	ETF	16.15	16.15	15.7001	16.01	37741.0
2013-07-05	AIVI	ETF	40.03	40.03	39.6	39.82	12500.0
2013-07-05	AMJ	ETF	46.74	46.74	45.6	46.02	658084.0
2013-07-05	AMLP	ETF	89.15	89.75	88.8	89.4	373420.0
2013-07-05	ANGL	ETF	26.27	26.28	26.25	26.28	700.0
2013-07-05	AOA	ETF	39.92	39.94	39.68	39.94	38500.0
2013-07-05	AOK	ETF	30.59	30.59	30.54	30.55	13659.0
2013-07-05	AOM	ETF	32.27	32.36	32.152	32.23	42164.0
2013-07-05	AOR	ETF	35.42	35.42	35.23	35.41	29414.0
2013-07-05	ARB	ETF	46.39	46.39	46.25	46.34	237745.0
2013-07-05	ARGT	ETF	16.25	16.25	16.25	16.25	100.0
2013-07-05	ASEA	ETF	16.7	16.75	16.38	16.41	5100.0
2013-07-05	ATMP	ETF	25.96	25.97	25.96	25.97	600.0
2013-07-05	AVIV	ETF	24.8	24.93	23.83	24.66	204877.0
2013-07-05	AWAY	ETF	31.97	32.17	31.31	31.51	566938.0
2013-07-05	BAB	ETF	27.81	27.87	27.61	27.7	360870.0
2013-07-05	BAL	ETF	54.71	54.71	54.339	54.61	4728.0
2013-07-05	BALT	ETF	3.67	3.68	3.62	3.68	18356.0
2013-07-05	BBH	ETF	72.4	72.94	72.06	72.93	66600.0
2013-07-05	BCM	ETF	38.82	38.8388	38.82	38.83	5711.0
2013-07-05	BFOR	ETF	6.275	6.3375	6.2625	6.3375	269200.0
2013-07-05	BIB	ETF	24.2525	24.9	24.225	24.9	98932.0
2013-07-05	BICK	ETF	20.49	20.49	20.38	20.38	900.0
2013-07-05	BIL	ETF	91.62	91.62	91.6	91.62	342300.0
2013-07-05	BIS	ETF	1404.8	1406.8	1398.36	1398.36	151.5
2013-07-05	BIV	ETF	82.49	82.57	82.26	82.35	387000.0
2013-07-05	BIZD	ETF	19.76	19.76	19.55	19.67	3400.0
2013-07-05	BJK	ETF	40.48	40.48	40.02	40.42	2300.0
2013-07-05	BKF	ETF	33.34	33.34	32.799	33.08	119379.0
2013-07-05	BKLN	ETF	24.74	24.76	24.71	24.75	1402100.0
2013-07-05	BLV	ETF	83.36	83.94	82.97	83.25	96100.0
2013-07-05	BMVP	ETF	18.837	18.953	18.837	18.953	500.0

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

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