PREVIEW / etf_daily / 2013-09-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-09.parquet
  size:    42 KB
  rows:    1,030

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-09-09	SPY	ETF	166.45	167.73	166.45	167.63	87559300.0
2013-09-09	QQQ	ETF	77.23	77.96	77.23	77.83	25161869.0
2013-09-09	IWM	ETF	102.74	104.03	102.73	103.94	27358500.0
2013-09-09	DIA	ETF	149.5	150.78	149.48	150.47	4402500.0
2013-09-09	GLD	ETF	134.13	134.32	133.67	133.91	5090500.0
2013-09-09	TLT	ETF	103.8	103.81	103.08	103.1	6874900.0
2013-09-09	AADR	ETF	34.42	34.64	34.3	34.44	5700.0
2013-09-09	AAXJ	ETF	57.54	58.43	57.54	58.36	716900.0
2013-09-09	ACTV	ETF	9.55	9.875	9.49	9.79	340762.0
2013-09-09	ACWI	ETF	52.56	53.0	52.56	52.97	1314000.0
2013-09-09	ACWV	ETF	60.54	61.04	60.54	61.01	28000.0
2013-09-09	ACWX	ETF	43.47	43.94	43.47	43.92	479940.0
2013-09-09	ADRE	ETF	36.57	37.1045	36.55	37.1045	21240.0
2013-09-09	AFK	ETF	29.28	29.439	29.17	29.3	51269.0
2013-09-09	AGEM	ETF	21.82	22.2796	21.82	22.18	18619.0
2013-09-09	AGG	ETF	105.6	105.61	105.41	105.49	897200.0
2013-09-09	AGQ	ETF	97.28	97.96	96.4	97.0	217300.0
2013-09-09	AGZ	ETF	110.24	110.24	110.09	110.12	15377.0
2013-09-09	AIA	ETF	46.54	46.969	46.49	46.9	18035.0
2013-09-09	AIQ	ETF	25.22	25.37	24.42	24.89	42840.0
2013-09-09	AIVI	ETF	43.65	44.04	43.65	43.96	25000.0
2013-09-09	AMJ	ETF	44.09	44.62	44.09	44.33	725337.0
2013-09-09	AMLP	ETF	86.3	87.1	86.15	87.1	439480.0
2013-09-09	ANGL	ETF	27.26	27.84	25.94	26.3	1500.0
2013-09-09	AOA	ETF	41.07	41.37	41.07	41.37	22800.0
2013-09-09	AOK	ETF	30.93	30.98	30.91	30.98	19591.0
2013-09-09	AOM	ETF	32.79	32.874	32.7701	32.87	27882.0
2013-09-09	AOR	ETF	36.17	36.34	36.12	36.34	157676.0
2013-09-09	ARB	ETF	47.39	47.51	47.39	47.48	180780.0
2013-09-09	ARGT	ETF	18.9	19.22	18.88	19.22	600.0
2013-09-09	ASEA	ETF	15.83	16.24	15.83	16.24	73400.0
2013-09-09	ATMP	ETF	25.75	25.82	25.48	25.82	15900.0
2013-09-09	AVIV	ETF	22.05	22.84	22.05	22.21	127337.0
2013-09-09	AWAY	ETF	31.35	32.21	31.34	32.0	620602.0
2013-09-09	BAB	ETF	27.1	27.18	26.92	26.95	217105.0
2013-09-09	BAL	ETF	53.7	53.8	53.43	53.43	5339.0
2013-09-09	BALT	ETF	5.33	5.589	5.33	5.57	1022773.0
2013-09-09	BBH	ETF	81.24	82.39	81.15	82.39	107900.0
2013-09-09	BCM	ETF	41.55	41.55	41.29	41.33	1800.0
2013-09-09	BFOR	ETF	6.58	6.645	6.58	6.6425	166800.0
2013-09-09	BIB	ETF	30.665	31.55	30.65	31.4675	188388.0
2013-09-09	BICK	ETF	23.0	23.38	23.0	23.38	703.0
2013-09-09	BIL	ETF	91.6	91.6	91.56	91.56	903150.0
2013-09-09	BIS	ETF	1090.8	1091.2	1061.64	1062.96	72.0
2013-09-09	BIV	ETF	81.82	81.91	81.67	81.67	176500.0
2013-09-09	BIZD	ETF	20.17	20.28	20.15	20.28	11900.0
2013-09-09	BJK	ETF	45.0	45.42	45.0	45.41	23500.0
2013-09-09	BKF	ETF	36.5	37.1755	36.495	37.11	107803.0
2013-09-09	BKLN	ETF	24.77	24.82	24.77	24.81	3536200.0
2013-09-09	BLNG	ETF	40.032	40.032	40.032	40.032	252.0

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

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