PREVIEW / etf_daily / 2013-06-06

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-06.parquet
  size:    41 KB
  rows:    1,004

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-06-06	SPY	ETF	161.2	162.74	160.25	162.73	200225500.0
2013-06-06	QQQ	ETF	72.15	72.41	71.47	72.4	62524010.0
2013-06-06	IWM	ETF	96.36	97.45	95.73	97.45	46335300.0
2013-06-06	DIA	ETF	149.38	150.27	148.31	150.25	15155100.0
2013-06-06	GLD	ETF	135.39	137.62	134.98	136.53	9847700.0
2013-06-06	TLT	ETF	114.88	116.79	114.41	115.22	8925200.0
2013-06-06	AADR	ETF	33.4	33.62	33.4	33.62	2700.0
2013-06-06	AAXJ	ETF	57.5	57.95	57.27	57.93	438200.0
2013-06-06	ACTV	ETF	7.22	7.39	7.15	7.38	326058.0
2013-06-06	ACWI	ETF	51.15	51.56	50.94	51.56	1590000.0
2013-06-06	ACWV	ETF	60.24	60.51	59.86	60.5	186100.0
2013-06-06	ACWX	ETF	42.33	42.59	42.2	42.56	610083.0
2013-06-06	ADRE	ETF	36.47	36.91	36.47	36.91	36671.0
2013-06-06	AFK	ETF	29.67	29.89	29.62	29.87	22225.0
2013-06-06	AGEM	ETF	21.1	21.36	21.1	21.36	1403.0
2013-06-06	AGG	ETF	108.66	109.09	108.61	108.95	1142500.0
2013-06-06	AGQ	ETF	90.8	94.08	90.2	92.44	403775.0
2013-06-06	AGZ	ETF	112.51	112.68	112.4901	112.5	16492.0
2013-06-06	AIA	ETF	44.86	45.13	44.64	45.11	26858.0
2013-06-06	AIQ	ETF	16.22	16.6	15.1801	16.18	47313.0
2013-06-06	AIVI	ETF	42.33	42.59	42.12	42.57	35500.0
2013-06-06	AMJ	ETF	43.87	45.41	43.5	45.35	878288.0
2013-06-06	AMLP	ETF	85.95	87.0	85.6	86.95	1259640.0
2013-06-06	ANGL	ETF	26.91	27.19	26.89	26.98	15500.0
2013-06-06	AOA	ETF	40.0	40.32	39.92	40.32	13900.0
2013-06-06	AOK	ETF	30.96	31.07	30.96	31.07	19483.0
2013-06-06	AOM	ETF	32.62	32.84	32.62	32.84	37631.0
2013-06-06	AOR	ETF	35.66	35.88	35.6432	35.88	22569.0
2013-06-06	ARB	ETF	46.79	46.8	46.73	46.75	424440.0
2013-06-06	ARGT	ETF	17.66	17.68	17.61	17.61	600.0
2013-06-06	ASEA	ETF	17.19	17.35	17.18	17.35	20800.0
2013-06-06	ATMP	ETF	24.85	25.22	24.74	25.22	22800.0
2013-06-06	AVIV	ETF	25.5	26.31	25.38	26.22	336561.0
2013-06-06	AWAY	ETF	28.93	29.47	28.5	29.46	696550.0
2013-06-06	BAB	ETF	29.92	30.15	29.8384	29.96	203503.0
2013-06-06	BAL	ETF	52.82	53.42	52.7401	53.2592	23913.0
2013-06-06	BALT	ETF	3.55	3.55	3.5	3.54	42243.0
2013-06-06	BBH	ETF	67.35	69.24	67.35	69.24	128100.0
2013-06-06	BCM	ETF	40.731	40.731	40.731	40.731	255.0
2013-06-06	BFOR	ETF	6.185	6.185	6.125	6.17	127200.0
2013-06-06	BIB	ETF	21.485	23.2325	21.485	23.2325	362664.0
2013-06-06	BICK	ETF	22.93	22.99	22.9	22.93	1381.0
2013-06-06	BIL	ETF	91.62	91.62	91.58	91.6	2841800.0
2013-06-06	BIS	ETF	1627.2	1627.2	1525.24	1526.4	362.5
2013-06-06	BIV	ETF	85.9	86.3	85.71	85.96	269200.0
2013-06-06	BIZD	ETF	19.56	19.7	19.51	19.7	4000.0
2013-06-06	BJK	ETF	41.41	41.57	41.26	41.56	9200.0
2013-06-06	BKF	ETF	36.88	37.35	36.834	37.35	117576.0
2013-06-06	BKLN	ETF	24.96	24.97	24.87	24.93	6662200.0
2013-06-06	BLV	ETF	88.86	89.72	88.47	89.14	42600.0

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

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