PREVIEW / etf_daily / 2013-06-04

all etf daily files

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

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-04	SPY	ETF	164.44	165.1	162.73	163.56	157631500.0
2013-06-04	QQQ	ETF	73.52	73.82	72.7	73.0	35256035.0
2013-06-04	IWM	ETF	98.68	99.2	96.92	97.68	68206900.0
2013-06-04	DIA	ETF	152.26	152.91	150.82	151.64	7956400.0
2013-06-04	GLD	ETF	135.21	135.44	134.27	135.23	5505200.0
2013-06-04	TLT	ETF	113.96	114.49	113.66	113.72	7504300.0
2013-06-04	AADR	ETF	33.77	33.77	33.77	33.77	700.0
2013-06-04	AAXJ	ETF	58.81	58.93	58.28	58.47	514800.0
2013-06-04	ACTV	ETF	6.88	7.01	6.77	6.92	441102.0
2013-06-04	ACWI	ETF	52.29	52.42	51.79	51.99	1042700.0
2013-06-04	ACWV	ETF	60.98	61.26	60.75	60.94	41100.0
2013-06-04	ACWX	ETF	43.44	43.51	43.04	43.09	490416.0
2013-06-04	ADRE	ETF	37.58	37.61	37.18	37.33	32104.0
2013-06-04	AFK	ETF	30.38	30.4403	30.08	30.24	27233.0
2013-06-04	AGEM	ETF	21.7	21.7645	21.5401	21.7499	2159.0
2013-06-04	AGG	ETF	108.83	108.89	108.68	108.73	980500.0
2013-06-04	AGQ	ETF	90.64	91.4	89.2	91.2	350200.0
2013-06-04	AGZ	ETF	112.49	112.55	112.44	112.4401	11325.0
2013-06-04	AIA	ETF	45.95	46.09	45.55	45.67	12787.0
2013-06-04	AIQ	ETF	16.27	16.82	15.81	15.91	47925.0
2013-06-04	AIVI	ETF	43.1	43.18	42.79	43.0	24600.0
2013-06-04	ALTL	ETF	28.68	28.68	28.68	28.68	1000.0
2013-06-04	AMJ	ETF	45.08	45.7399	45.08	45.21	806084.0
2013-06-04	AMLP	ETF	87.45	87.65	86.75	86.75	788800.0
2013-06-04	ANGL	ETF	27.28	27.3	27.17	27.28	4400.0
2013-06-04	AOA	ETF	40.8	40.86	40.44	40.63	13600.0
2013-06-04	AOK	ETF	31.24	31.26	31.13	31.19	31107.0
2013-06-04	AOM	ETF	33.0	33.09	32.881	33.09	13289.0
2013-06-04	AOR	ETF	36.24	36.264	36.0	36.09	35158.0
2013-06-04	ARB	ETF	46.81	46.949	46.81	46.89	348518.0
2013-06-04	ARGT	ETF	17.76	17.8	17.68	17.75	1200.0
2013-06-04	ASEA	ETF	17.89	17.89	17.6	17.66	20000.0
2013-06-04	ATMP	ETF	25.48	25.53	25.22	25.22	12000.0
2013-06-04	AVIV	ETF	26.41	26.89	26.31	26.58	298239.0
2013-06-04	AWAY	ETF	28.2	29.46	28.012	29.19	737480.0
2013-06-04	BAB	ETF	29.9	30.0199	29.881	29.9022	276650.0
2013-06-04	BAL	ETF	52.16	54.21	51.91	52.99	42427.0
2013-06-04	BALT	ETF	3.62	3.675	3.62	3.62	170860.0
2013-06-04	BBH	ETF	70.68	71.0	69.01	69.27	176900.0
2013-06-04	BCM	ETF	40.61	40.78	40.51	40.734	11574.0
2013-06-04	BFOR	ETF	6.275	6.2775	6.2	6.22	238732.0
2013-06-04	BIB	ETF	23.8575	23.995	22.7	22.925	549908.0
2013-06-04	BICK	ETF	23.3	23.403	23.26	23.3	2720.0
2013-06-04	BIL	ETF	91.6	91.62	91.6	91.62	147200.0
2013-06-04	BIS	ETF	1496.0	1563.04	1471.92	1552.8	223.0
2013-06-04	BIV	ETF	85.8	85.85	85.65	85.7	394400.0
2013-06-04	BIZD	ETF	19.79	19.79	19.65	19.65	1100.0
2013-06-04	BJK	ETF	42.5	42.5	42.1	42.33	4400.0
2013-06-04	BKF	ETF	37.98	38.03	37.45	37.61	159462.0
2013-06-04	BKLN	ETF	25.05	25.06	25.0	25.03	3099900.0

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

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