PREVIEW / etf_daily / 2013-07-10

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-10.parquet
  size:    41 KB
  rows:    997

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-07-10	SPY	ETF	164.97	165.75	164.63	165.19	121410100.0
2013-07-10	QQQ	ETF	73.0	73.62	72.98	73.51	25598894.0
2013-07-10	IWM	ETF	101.04	101.38	100.74	101.28	36061100.0
2013-07-10	DIA	ETF	152.77	153.29	152.36	152.71	6126900.0
2013-07-10	GLD	ETF	121.15	122.35	120.59	120.95	14697100.0
2013-07-10	TLT	ETF	107.39	107.39	106.3	106.56	10792200.0
2013-07-10	AADR	ETF	33.17	33.2	33.17	33.2	400.0
2013-07-10	AAXJ	ETF	54.38	54.62	54.08	54.17	271300.0
2013-07-10	ACTV	ETF	8.1	8.75	8.05	8.61	1294269.0
2013-07-10	ACWI	ETF	51.02	51.33	50.95	51.08	752300.0
2013-07-10	ACWV	ETF	60.71	60.9	60.51	60.76	27400.0
2013-07-10	ACWX	ETF	41.23	41.62	41.21	41.39	585703.0
2013-07-10	ADRE	ETF	33.71	33.877	33.563	33.66	62829.0
2013-07-10	AFK	ETF	27.98	28.1	27.84	27.94	33227.0
2013-07-10	AGEM	ETF	20.33	20.46	20.33	20.36	2350.0
2013-07-10	AGG	ETF	106.59	106.59	106.22	106.22	717100.0
2013-07-10	AGQ	ETF	65.4	66.72	64.48	64.64	499800.0
2013-07-10	AGZ	ETF	110.6	110.7799	110.4101	110.42	38498.0
2013-07-10	AIA	ETF	42.47	42.5779	42.27	42.32	14355.0
2013-07-10	AIQ	ETF	16.58	16.58	16.4501	16.56	56792.0
2013-07-10	AIVI	ETF	40.41	40.89	40.41	40.59	57300.0
2013-07-10	ALTL	ETF	29.11	29.11	29.11	29.11	148.0
2013-07-10	AMJ	ETF	47.89	48.0	47.02	47.22	1469784.0
2013-07-10	AMLP	ETF	90.0	90.2	89.5	90.2	498800.0
2013-07-10	ANGL	ETF	26.39	26.39	26.25	26.39	2700.0
2013-07-10	AOA	ETF	40.39	40.5	40.33	40.42	20200.0
2013-07-10	AOK	ETF	30.82	30.83	30.78	30.79	51108.0
2013-07-10	AOM	ETF	32.51	32.5599	32.4403	32.5	29556.0
2013-07-10	AOR	ETF	35.71	35.82	35.7025	35.76	22173.0
2013-07-10	ARB	ETF	46.3	46.37	46.25	46.34	173688.0
2013-07-10	ARGT	ETF	16.55	16.55	16.55	16.55	400.0
2013-07-10	ASEA	ETF	16.62	16.7	16.6	16.62	20500.0
2013-07-10	ATMP	ETF	26.33	26.45	26.32	26.33	28400.0
2013-07-10	AVIV	ETF	25.01	25.54	24.995	25.52	80406.0
2013-07-10	AWAY	ETF	33.61	33.62	31.53	31.62	1719195.0
2013-07-10	BAB	ETF	27.75	27.83	27.64	27.65	237801.0
2013-07-10	BAL	ETF	55.0601	55.655	55.0	55.56	19318.0
2013-07-10	BALT	ETF	3.8	3.83	3.73	3.75	51896.0
2013-07-10	BBH	ETF	73.32	74.22	73.05	74.2	68200.0
2013-07-10	BFOR	ETF	6.43	6.4375	6.4	6.43	330800.0
2013-07-10	BIB	ETF	25.1325	25.7123	24.92	25.6425	205584.0
2013-07-10	BICK	ETF	20.67	20.713	20.65	20.68	4462.0
2013-07-10	BIL	ETF	91.58	91.6	91.58	91.58	239350.0
2013-07-10	BIS	ETF	1373.6	1380.0	1346.76	1346.76	79.0
2013-07-10	BIV	ETF	82.9	82.99	82.67	82.7	292500.0
2013-07-10	BIZD	ETF	20.0	20.0	19.89	19.99	1800.0
2013-07-10	BJK	ETF	40.55	40.55	40.37	40.44	3500.0
2013-07-10	BKF	ETF	33.34	33.48	33.1601	33.26	57568.0
2013-07-10	BKLN	ETF	24.79	24.8	24.76	24.76	2266500.0
2013-07-10	BLV	ETF	83.75	83.94	83.3	83.47	46700.0

> showing 50 of 997 rows — these rows as CSV

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