PREVIEW / etf_daily / 2012-06-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-19.parquet
  size:    38 KB
  rows:    936

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-06-19	SPY	ETF	135.08	136.25	134.37	135.7	137382600.0
2012-06-19	QQQ	ETF	63.9	64.51	63.85	64.239	36476477.0
2012-06-19	IWM	ETF	77.65	79.08	77.54	78.65	66897000.0
2012-06-19	DIA	ETF	127.73	128.71	127.51	128.06	3869500.0
2012-06-19	GLD	ETF	158.0	158.14	156.97	157.16	6945900.0
2012-06-19	TLT	ETF	126.28	126.37	125.33	125.42	8227900.0
2012-06-19	AADR	ETF	28.93	28.93	28.9	28.9	300.0
2012-06-19	AAXJ	ETF	52.87	53.53	52.87	53.19	937700.0
2012-06-19	ACTV	ETF	15.84	15.94	15.66	15.93	379665.0
2012-06-19	ACWI	ETF	43.9	44.41	43.88	44.2	939300.0
2012-06-19	ACWV	ETF	54.93	55.46	54.9	55.03	19000.0
2012-06-19	ACWX	ETF	37.1	37.57	37.0977	37.36	283897.0
2012-06-19	ADRE	ETF	37.27	38.1391	37.27	38.03	21714.0
2012-06-19	AFK	ETF	27.49	27.67	27.47	27.67	21584.0
2012-06-19	AGEM	ETF	20.91	21.1499	20.91	21.1499	4502.0
2012-06-19	AGG	ETF	111.3	111.3	111.11	111.22	605500.0
2012-06-19	AGQ	ETF	168.0	168.56	162.76	164.4	268825.0
2012-06-19	AGZ	ETF	113.41	113.619	113.402	113.47	37261.0
2012-06-19	AIA	ETF	42.06	42.33	41.99	42.17	14527.0
2012-06-19	AIQ	ETF	4.409	4.5385	4.251	4.4305	44162.0
2012-06-19	AIVI	ETF	37.91	38.45	37.87	38.31	61000.0
2012-06-19	AMJ	ETF	36.33	36.92	36.25	36.885	1820470.0
2012-06-19	AMLP	ETF	77.8	79.0	77.8	78.9	415120.0
2012-06-19	ANGL	ETF	25.2	25.2	25.2	25.2	700.0
2012-06-19	AOA	ETF	34.86	35.16	34.84	35.13	29400.0
2012-06-19	AOK	ETF	29.88	29.94	29.88	29.93	32840.0
2012-06-19	AOM	ETF	30.77	30.88	30.755	30.84	38655.0
2012-06-19	AOR	ETF	32.49	32.68	32.49	32.5701	22183.0
2012-06-19	ARB	ETF	34.89	35.78	34.86	35.61	99485.0
2012-06-19	ARGT	ETF	15.84	16.14	15.84	16.14	1500.0
2012-06-19	ASEA	ETF	15.29	15.58	15.29	15.38	30500.0
2012-06-19	AWAY	ETF	21.61	21.62	20.82	21.14	452157.0
2012-06-19	BAB	ETF	30.05	30.05	29.65	29.66	242755.0
2012-06-19	BAL	ETF	48.67	49.35	48.62	49.0	22439.0
2012-06-19	BALT	ETF	3.24	3.45	3.21	3.4	233464.0
2012-06-19	BBH	ETF	46.26	46.71	46.22	46.6	43700.0
2012-06-19	BCM	ETF	41.1	41.1382	40.998	41.0494	5443.0
2012-06-19	BIB	ETF	12.5988	12.875	12.5988	12.7825	193592.0
2012-06-19	BICK	ETF	22.81	23.03	22.81	22.97	7507.0
2012-06-19	BIL	ETF	91.66	91.66	91.62	91.62	831750.0
2012-06-19	BIS	ETF	3364.8	3448.16	3259.2	3288.0	19.25
2012-06-19	BIV	ETF	88.75	88.78	88.5	88.73	288100.0
2012-06-19	BJK	ETF	32.11	32.59	32.11	32.42	20800.0
2012-06-19	BKF	ETF	36.33	36.93	36.33	36.78	116577.0
2012-06-19	BKLN	ETF	24.18	24.2	24.14	24.2	153100.0
2012-06-19	BLV	ETF	94.98	95.12	94.54	94.73	36500.0
2012-06-19	BMVP	ETF	14.9	15.111	14.9	15.082	44884.0
2012-06-19	BND	ETF	84.36	84.37	84.26	84.32	908900.0
2012-06-19	BNO	ETF	34.245	34.295	33.955	33.995	91200.0
2012-06-19	BOIL	ETF	793200.0	811800.0	749200.0	779800.0	11.0

> showing 50 of 936 rows — these rows as CSV

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