PREVIEW / etf_daily / 2013-09-06

all etf daily files

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

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-06	SPY	ETF	166.51	166.98	164.48	166.04	159756500.0
2013-09-06	QQQ	ETF	77.09	77.34	76.05	76.93	27724535.0
2013-09-06	IWM	ETF	102.7	102.89	100.74	102.39	36792000.0
2013-09-06	DIA	ETF	149.7	149.97	147.77	149.09	9001900.0
2013-09-06	GLD	ETF	133.42	134.4	133.33	134.15	8448700.0
2013-09-06	TLT	ETF	103.25	103.82	102.81	103.05	9478400.0
2013-09-06	AADR	ETF	33.95	33.95	33.95	33.95	300.0
2013-09-06	AAXJ	ETF	57.03	57.4	56.59	57.12	158400.0
2013-09-06	ACTV	ETF	10.0	10.02	9.51	9.53	675685.0
2013-09-06	ACWI	ETF	52.35	52.55	51.9	52.32	904000.0
2013-09-06	ACWV	ETF	60.42	60.57	60.1	60.36	24400.0
2013-09-06	ACWX	ETF	43.21	43.38	42.94	43.25	218295.0
2013-09-06	ADRE	ETF	36.32	36.44	36.11	36.29	22590.0
2013-09-06	AFK	ETF	28.78	29.5	28.75	29.05	15341.0
2013-09-06	AGEM	ETF	21.64	21.75	21.5	21.61	135871.0
2013-09-06	AGG	ETF	105.33	105.48	105.23	105.28	639500.0
2013-09-06	AGQ	ETF	97.48	99.04	97.44	98.12	462650.0
2013-09-06	AGZ	ETF	110.17	110.17	108.47	109.994	13101.0
2013-09-06	AIA	ETF	46.4	46.4399	45.86	46.27	25608.0
2013-09-06	AIQ	ETF	25.3	25.55	24.29	25.08	35354.0
2013-09-06	AIVI	ETF	43.35	43.59	43.25	43.47	22200.0
2013-09-06	AMJ	ETF	44.6	44.6	44.13	44.41	490773.0
2013-09-06	AMLP	ETF	86.35	86.6	86.15	86.3	414960.0
2013-09-06	ANGL	ETF	26.37	26.37	26.37	26.37	700.0
2013-09-06	AOA	ETF	40.98	41.07	40.68	40.91	10500.0
2013-09-06	AOK	ETF	30.84	30.88	30.82	30.85	10096.0
2013-09-06	AOM	ETF	32.604	32.731	32.5901	32.64	43658.0
2013-09-06	AOR	ETF	36.115	36.15	35.95	36.04	14891.0
2013-09-06	ARB	ETF	47.46	47.55	47.37	47.45	488575.0
2013-09-06	ARGT	ETF	18.71	18.81	18.71	18.76	2000.0
2013-09-06	ASEA	ETF	15.37	15.58	15.36	15.58	36200.0
2013-09-06	ATMP	ETF	25.57	25.57	25.43	25.43	4900.0
2013-09-06	AVIV	ETF	21.79	22.32	21.79	22.05	323989.0
2013-09-06	AWAY	ETF	31.87	31.93	31.29	31.35	520320.0
2013-09-06	BAB	ETF	26.99	27.1407	26.98	27.02	146171.0
2013-09-06	BAL	ETF	53.31	53.36	52.92	53.1882	4719.0
2013-09-06	BALT	ETF	5.61	5.7	5.15	5.21	990802.0
2013-09-06	BBH	ETF	81.15	81.24	79.48	80.9	76500.0
2013-09-06	BCM	ETF	41.7	41.7	41.7	41.7	467.0
2013-09-06	BFOR	ETF	6.5925	6.6	6.5	6.5675	121600.0
2013-09-06	BIB	ETF	30.775	30.7875	29.2575	30.2975	82856.0
2013-09-06	BICK	ETF	22.76	22.87	22.68	22.87	1433.0
2013-09-06	BIL	ETF	91.58	91.6	91.58	91.6	265500.0
2013-09-06	BIS	ETF	1105.6	1127.6	1093.608	1107.52	171.0
2013-09-06	BIV	ETF	81.67	81.83	81.47	81.6	161500.0
2013-09-06	BIZD	ETF	20.05	20.12	20.05	20.12	1000.0
2013-09-06	BJK	ETF	44.23	44.64	44.23	44.44	5500.0
2013-09-06	BKF	ETF	36.1	36.31	35.9	36.13	107493.0
2013-09-06	BKLN	ETF	24.76	24.78	24.75	24.76	2626000.0
2013-09-06	BLV	ETF	80.83	81.07	80.59	80.74	46500.0

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

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