PREVIEW / etf_daily / 2012-12-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-05.parquet
  size:    40 KB
  rows:    962

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
2012-12-05	SPY	ETF	141.37	142.16	140.37	141.5	147300500.0
2012-12-05	QQQ	ETF	65.53	65.54	64.55	64.9032	54076124.0
2012-12-05	IWM	ETF	82.48	82.51	81.4	81.99	40376100.0
2012-12-05	DIA	ETF	129.71	130.82	129.16	130.24	8697300.0
2012-12-05	GLD	ETF	164.22	164.5	163.2	164.12	10646800.0
2012-12-05	TLT	ETF	125.4	125.81	125.17	125.32	1978200.0
2012-12-05	AADR	ETF	30.65	30.65	30.65	30.65	400.0
2012-12-05	AAXJ	ETF	58.67	59.08	58.57	58.75	421900.0
2012-12-05	ACTV	ETF	4.99	5.079	4.66	4.69	856256.0
2012-12-05	ACWI	ETF	47.31	47.55	47.06	47.36	842700.0
2012-12-05	ACWV	ETF	56.55	56.76	56.43	56.67	119300.0
2012-12-05	ACWX	ETF	40.75	41.0445	40.7	40.87	380670.0
2012-12-05	ADRE	ETF	38.43	38.6799	38.36	38.53	30531.0
2012-12-05	AFK	ETF	30.49	30.5295	30.2301	30.38	30832.0
2012-12-05	AGEM	ETF	22.76	22.76	22.68	22.68	1268.0
2012-12-05	AGG	ETF	111.69	111.79	111.68	111.77	538200.0
2012-12-05	AGQ	ETF	208.4	209.4	204.0	208.28	310625.0
2012-12-05	AGZ	ETF	114.0	114.0	113.73	113.73	11858.0
2012-12-05	AIA	ETF	46.77	46.9897	46.62	46.62	62518.0
2012-12-05	AIQ	ETF	6.1	6.2	6.05	6.2	14116.0
2012-12-05	AIVI	ETF	40.81	41.21	40.73	41.03	27900.0
2012-12-05	ALTL	ETF	25.44	25.44	25.354	25.354	755.0
2012-12-05	AMJ	ETF	38.75	38.94	38.455	38.53	1823717.0
2012-12-05	AMLP	ETF	80.5	80.7	79.8	80.05	290500.0
2012-12-05	ANGL	ETF	27.25	27.25	26.95	27.08	2600.0
2012-12-05	AOA	ETF	36.79	36.91	36.6	36.75	16900.0
2012-12-05	AOK	ETF	30.56	30.59	30.5101	30.52	16068.0
2012-12-05	AOM	ETF	31.68	31.76	31.6499	31.72	12464.0
2012-12-05	AOR	ETF	33.73	33.8299	33.6699	33.79	10442.0
2012-12-05	ARB	ETF	37.49	37.94	37.26	37.69	90800.0
2012-12-05	ARGT	ETF	16.4	16.4	16.22	16.22	200.0
2012-12-05	ASEA	ETF	16.62	16.78	16.62	16.68	6400.0
2012-12-05	AWAY	ETF	21.0	21.01	20.16	20.55	1474884.0
2012-12-05	BAB	ETF	30.7	30.7	30.61	30.65	178396.0
2012-12-05	BAL	ETF	47.39	47.71	47.26	47.6301	3750.0
2012-12-05	BALT	ETF	2.83	2.91	2.81	2.81	55088.0
2012-12-05	BBH	ETF	54.42	54.5	53.8	54.44	11100.0
2012-12-05	BCM	ETF	44.71	44.72	44.71	44.72	400.0
2012-12-05	BIB	ETF	14.825	14.825	14.4725	14.7125	29856.0
2012-12-05	BICK	ETF	24.04	24.1504	24.02	24.0818	3504.0
2012-12-05	BIL	ETF	91.62	91.64	91.62	91.62	141750.0
2012-12-05	BIS	ETF	2617.996	2626.004	2612.396	2624.8	430.0
2012-12-05	BIV	ETF	90.54	90.6	90.51	90.55	399100.0
2012-12-05	BJK	ETF	35.12	35.34	35.12	35.27	2600.0
2012-12-05	BKF	ETF	38.64	39.08	38.64	38.89	127535.0
2012-12-05	BKLN	ETF	24.81	24.83	24.77	24.83	535200.0
2012-12-05	BLV	ETF	97.16	97.39	97.06	97.17	56900.0
2012-12-05	BMVP	ETF	15.96	16.02	15.89	16.01	977.0
2012-12-05	BND	ETF	84.86	84.99	84.86	84.97	1058300.0
2012-12-05	BNO	ETF	40.24	40.24	39.745	39.76	51800.0

> showing 50 of 962 rows — these rows as CSV

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