PREVIEW / etf_daily / 2012-07-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-23.parquet
  size:    39 KB
  rows:    945

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-07-23	SPY	ETF	134.47	136.38	133.84	135.09	145210900.0
2012-07-23	QQQ	ETF	63.0	63.68	62.51	63.46	48657617.0
2012-07-23	IWM	ETF	77.51	78.03	77.18	77.67	47367200.0
2012-07-23	DIA	ETF	126.02	127.18	125.53	126.91	4647900.0
2012-07-23	GLD	ETF	152.5	153.33	152.29	153.03	5256700.0
2012-07-23	TLT	ETF	131.31	131.44	130.51	130.79	6141100.0
2012-07-23	AADR	ETF	27.23	27.23	27.23	27.23	200.0
2012-07-23	AAXJ	ETF	50.63	51.04	50.26	50.87	312700.0
2012-07-23	ACTV	ETF	14.68	14.72	14.59	14.59	103371.0
2012-07-23	ACWI	ETF	42.77	43.1	42.59	43.01	928700.0
2012-07-23	ACWV	ETF	54.33	54.62	54.31	54.59	15800.0
2012-07-23	ACWX	ETF	35.67	35.95	35.48	35.87	103213.0
2012-07-23	ADRE	ETF	36.31	36.53	35.94	36.46	27347.0
2012-07-23	AFK	ETF	27.78	27.78	27.3	27.68	17349.0
2012-07-23	AGEM	ETF	20.4	20.4	20.4	20.4	300.0
2012-07-23	AGG	ETF	112.62	112.62	112.49	112.52	498200.0
2012-07-23	AGQ	ETF	144.8	148.28	143.88	146.36	323750.0
2012-07-23	AGZ	ETF	114.0	114.16	113.99	114.12	15325.0
2012-07-23	AIA	ETF	39.86	40.18	39.64	40.12	17765.0
2012-07-23	AIQ	ETF	4.0	4.4	4.0	4.0	7058.0
2012-07-23	AIVI	ETF	36.07	36.5	36.0	36.45	24200.0
2012-07-23	AMJ	ETF	39.75	39.8	39.35	39.64	732765.0
2012-07-23	AMLP	ETF	82.5	82.7	82.0	82.35	517980.0
2012-07-23	ANGL	ETF	25.85	25.85	25.59	25.65	1400.0
2012-07-23	AOA	ETF	34.43	34.65	34.34	34.64	9500.0
2012-07-23	AOK	ETF	29.86	29.89	29.78	29.89	16256.0
2012-07-23	AOM	ETF	30.6	30.6896	30.52	30.63	88278.0
2012-07-23	AOR	ETF	32.27	32.341	32.2051	32.341	3389.0
2012-07-23	ARB	ETF	35.43	35.97	35.29	35.34	70268.0
2012-07-23	ARGT	ETF	15.5	15.52	15.5	15.52	250.0
2012-07-23	ASEA	ETF	15.57	15.77	15.57	15.75	32700.0
2012-07-23	AWAY	ETF	21.82	22.33	21.53	22.17	440408.0
2012-07-23	BAB	ETF	30.56	30.67	30.56	30.64	363282.0
2012-07-23	BAL	ETF	47.34	48.1	46.9401	47.83	21967.0
2012-07-23	BALT	ETF	3.41	3.47	3.35	3.36	28249.0
2012-07-23	BBH	ETF	48.34	48.34	47.57	48.15	27500.0
2012-07-23	BIB	ETF	13.3488	13.424	12.875	13.424	207440.0
2012-07-23	BICK	ETF	21.36	21.36	21.15	21.36	7616.0
2012-07-23	BIL	ETF	91.64	91.64	91.62	91.62	144550.0
2012-07-23	BIS	ETF	3104.0	3126.464	3092.8	3092.8	9.7
2012-07-23	BIV	ETF	90.18	90.18	89.98	90.09	179600.0
2012-07-23	BJK	ETF	30.32	30.47	30.11	30.47	21300.0
2012-07-23	BKF	ETF	34.44	34.6	34.08	34.54	67955.0
2012-07-23	BKLN	ETF	24.55	24.55	24.47	24.52	213300.0
2012-07-23	BLV	ETF	99.14	99.24	98.72	98.79	49800.0
2012-07-23	BMVP	ETF	15.0333	15.0934	14.9133	15.0934	3950.0
2012-07-23	BND	ETF	85.28	85.28	85.16	85.2	912200.0
2012-07-23	BNO	ETF	36.615	37.15	36.465	36.795	111000.0
2012-07-23	BOIL	ETF	1036800.0	1091800.0	1032600.0	1073600.0	10.4
2012-07-23	BOND	ETF	107.61	107.61	107.5014	107.549	627727.0

> showing 50 of 945 rows — these rows as CSV

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