PREVIEW / etf_daily / 2013-06-10

all etf daily files

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

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-10	SPY	ETF	165.31	165.4	164.37	164.8	105667100.0
2013-06-10	QQQ	ETF	73.55	73.76	73.26	73.42	25393169.0
2013-06-10	IWM	ETF	98.64	98.8	97.81	98.8	32136500.0
2013-06-10	DIA	ETF	152.79	152.88	151.98	152.21	4917900.0
2013-06-10	GLD	ETF	133.3	134.28	132.99	133.94	6142800.0
2013-06-10	TLT	ETF	112.7	113.12	112.38	112.62	7892600.0
2013-06-10	AADR	ETF	34.08	34.08	34.08	34.08	100.0
2013-06-10	AAXJ	ETF	57.25	57.25	56.75	56.84	221200.0
2013-06-10	ACTV	ETF	7.47	7.57	7.34	7.51	382445.0
2013-06-10	ACWI	ETF	52.25	52.25	51.9	52.04	507300.0
2013-06-10	ACWV	ETF	61.07	61.11	60.8	60.93	27800.0
2013-06-10	ACWX	ETF	43.01	43.01	42.74	42.89	437029.0
2013-06-10	ADRE	ETF	36.42	36.549	36.3	36.48	59148.0
2013-06-10	AFK	ETF	29.72	29.74	29.38	29.44	34883.0
2013-06-10	AGEM	ETF	21.25	21.25	21.03	21.17	26765.0
2013-06-10	AGG	ETF	108.35	108.51	108.33	108.39	1173300.0
2013-06-10	AGQ	ETF	85.12	87.4	84.52	85.96	431725.0
2013-06-10	AGZ	ETF	112.79	112.79	111.8	111.96	13166.0
2013-06-10	AIA	ETF	44.3	44.3001	44.09	44.21	19249.0
2013-06-10	AIQ	ETF	15.9	16.25	15.71	15.91	27791.0
2013-06-10	AIVI	ETF	42.88	42.99	42.76	42.85	18100.0
2013-06-10	ALTL	ETF	28.85	28.85	28.77	28.77	1087.0
2013-06-10	AMJ	ETF	45.99	46.66	45.51	46.54	2002269.0
2013-06-10	AMLP	ETF	88.5	88.7	87.55	88.0	517160.0
2013-06-10	ANGL	ETF	26.98	27.2	26.98	27.14	2800.0
2013-06-10	AOA	ETF	40.8	40.8	40.64	40.72	17400.0
2013-06-10	AOK	ETF	31.19	31.19	31.111	31.16	21213.0
2013-06-10	AOM	ETF	32.93	32.95	32.86	32.871	26185.0
2013-06-10	AOR	ETF	36.2	36.2	36.0905	36.13	36685.0
2013-06-10	ARB	ETF	47.02	47.02	46.89	46.94	97094.0
2013-06-10	ARGT	ETF	17.62	17.72	17.62	17.71	5200.0
2013-06-10	ASEA	ETF	17.26	17.26	17.1	17.16	321500.0
2013-06-10	ATMP	ETF	25.49	25.56	25.45	25.54	48800.0
2013-06-10	AVIV	ETF	26.8	27.07	26.7	26.9	200691.0
2013-06-10	AWAY	ETF	29.65	30.14	29.65	29.89	471441.0
2013-06-10	BAB	ETF	29.64	29.676	29.55	29.62	404202.0
2013-06-10	BAL	ETF	53.3	54.456	53.3	54.34	40608.0
2013-06-10	BALT	ETF	3.51	3.56	3.475	3.52	36758.0
2013-06-10	BBH	ETF	71.3	71.31	69.76	70.26	66100.0
2013-06-10	BCM	ETF	40.558	40.6	40.47	40.488	4386.0
2013-06-10	BFOR	ETF	6.4	6.565	6.2525	6.28	2331200.0
2013-06-10	BIB	ETF	24.595	24.6165	23.6618	23.9425	130232.0
2013-06-10	BICK	ETF	22.52	22.6599	22.52	22.56	10610.0
2013-06-10	BIL	ETF	91.62	91.62	91.6	91.6	212800.0
2013-06-10	BIS	ETF	1436.0	1485.996	1436.0	1480.0	159.5
2013-06-10	BIV	ETF	85.42	85.53	85.31	85.39	491000.0
2013-06-10	BIZD	ETF	19.8	19.95	19.8	19.95	6700.0
2013-06-10	BJK	ETF	42.37	42.42	42.3	42.34	3300.0
2013-06-10	BKF	ETF	36.74	36.74	36.37	36.56	92451.0
2013-06-10	BKLN	ETF	24.98	25.0	24.95	24.99	3221000.0

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

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