PREVIEW / etf_daily / 2012-07-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-25.parquet
  size:    38 KB
  rows:    921

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-25	SPY	ETF	134.21	134.56	133.25	133.96	129122300.0
2012-07-25	QQQ	ETF	62.49	62.95	62.15	62.54	46267404.0
2012-07-25	IWM	ETF	77.0	77.38	76.47	76.82	37217500.0
2012-07-25	DIA	ETF	126.6	127.04	126.0	126.51	3872300.0
2012-07-25	GLD	ETF	155.33	156.29	155.05	155.67	9355900.0
2012-07-25	TLT	ETF	131.63	132.21	131.48	132.16	5328000.0
2012-07-25	AADR	ETF	27.69	27.69	27.69	27.69	100.0
2012-07-25	AAXJ	ETF	51.0	51.18	50.61	50.85	158400.0
2012-07-25	ACTV	ETF	14.51	14.54	14.08	14.22	92302.0
2012-07-25	ACWI	ETF	42.82	42.95	42.5	42.71	546600.0
2012-07-25	ACWV	ETF	54.45	54.56	54.23	54.42	46900.0
2012-07-25	ACWX	ETF	35.82	35.9	35.53	35.7	142147.0
2012-07-25	ADRE	ETF	36.51	36.59	36.186	36.34	11456.0
2012-07-25	AFK	ETF	27.48	27.62	27.32	27.521	40061.0
2012-07-25	AGEM	ETF	20.31	20.54	20.31	20.54	60791.0
2012-07-25	AGG	ETF	112.63	112.71	112.61	112.7	874700.0
2012-07-25	AGQ	ETF	149.12	152.16	147.12	150.0	357975.0
2012-07-25	AGZ	ETF	114.07	114.18	113.99	114.09	4201.0
2012-07-25	AIA	ETF	40.25	40.28	39.9812	40.08	22757.0
2012-07-25	AIQ	ETF	4.2	4.2	3.75	3.75	17870.0
2012-07-25	AIVI	ETF	36.16	36.17	35.83	35.98	45400.0
2012-07-25	AMJ	ETF	39.38	39.4799	38.85	38.85	1341110.0
2012-07-25	AMLP	ETF	82.25	82.25	81.25	81.45	589620.0
2012-07-25	ANGL	ETF	25.45	25.85	25.4	25.85	41100.0
2012-07-25	AOA	ETF	34.43	34.5	34.22	34.37	17100.0
2012-07-25	AOK	ETF	29.81	29.8496	29.775	29.82	9818.0
2012-07-25	AOM	ETF	30.55	30.6	30.5101	30.53	13785.0
2012-07-25	AOR	ETF	32.21	32.2182	32.08	32.14	15906.0
2012-07-25	ARB	ETF	34.87	35.43	34.87	35.27	80776.0
2012-07-25	ASEA	ETF	15.84	15.89	15.7	15.77	178000.0
2012-07-25	AWAY	ETF	22.6	22.6	21.23	21.55	534626.0
2012-07-25	BAB	ETF	30.75	30.81	30.616	30.81	192834.0
2012-07-25	BAL	ETF	47.12	47.28	45.75	45.81	17327.0
2012-07-25	BALT	ETF	3.3	3.35	3.25	3.25	62470.0
2012-07-25	BBH	ETF	48.09	48.54	47.88	48.47	29000.0
2012-07-25	BCM	ETF	43.55	43.56	43.547	43.547	2088.0
2012-07-25	BIB	ETF	13.3637	13.555	13.1325	13.5325	19664.0
2012-07-25	BICK	ETF	21.31	21.329	21.21	21.255	3977.0
2012-07-25	BIL	ETF	91.64	91.66	91.62	91.66	1505750.0
2012-07-25	BIS	ETF	3070.4	3126.384	3028.96	3028.96	25.0
2012-07-25	BIV	ETF	90.25	90.28	90.15	90.28	239600.0
2012-07-25	BJK	ETF	30.02	30.02	29.64	29.69	16500.0
2012-07-25	BKF	ETF	34.54	34.59	34.1664	34.33	49862.0
2012-07-25	BKLN	ETF	24.53	24.54	24.52	24.53	181700.0
2012-07-25	BLV	ETF	99.26	99.66	99.2	99.5	54000.0
2012-07-25	BMVP	ETF	14.9025	14.9534	14.86	14.8993	49667.0
2012-07-25	BND	ETF	85.32	85.36	85.27	85.36	483400.0
2012-07-25	BNO	ETF	36.775	37.145	36.34	37.075	87400.0
2012-07-25	BOIL	ETF	1099400.0	1108600.0	1031200.0	1044800.0	8.8
2012-07-25	BOND	ETF	107.5	107.57	107.4	107.53	550161.0

> showing 50 of 921 rows — these rows as CSV

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