PREVIEW / etf_daily / 2012-12-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-17.parquet
  size:    40 KB
  rows:    961

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-17	SPY	ETF	142.47	143.85	142.43	143.77	143238200.0
2012-12-17	QQQ	ETF	64.73	65.57	64.66	65.55	42302841.0
2012-12-17	IWM	ETF	82.68	83.53	82.52	83.52	35849400.0
2012-12-17	DIA	ETF	131.65	132.52	131.63	132.44	4534100.0
2012-12-17	GLD	ETF	164.16	164.62	164.13	164.44	8173300.0
2012-12-17	TLT	ETF	123.5	123.52	121.71	121.75	6870000.0
2012-12-17	AADR	ETF	30.86	30.91	30.82	30.82	600.0
2012-12-17	AAXJ	ETF	59.68	59.88	59.53	59.82	364900.0
2012-12-17	ACTV	ETF	4.99	5.01	4.91	4.97	404057.0
2012-12-17	ACWI	ETF	47.69	48.13	47.69	48.11	3527700.0
2012-12-17	ACWV	ETF	56.8	56.89	56.71	56.82	14700.0
2012-12-17	ACWX	ETF	41.54	41.68	41.45	41.68	269493.0
2012-12-17	ADRE	ETF	39.46	39.63	39.45	39.62	20107.0
2012-12-17	AFK	ETF	31.35	31.44	31.32	31.4375	23024.0
2012-12-17	AGEM	ETF	23.14	23.502	22.9375	23.09	12400.0
2012-12-17	AGG	ETF	111.35	111.36	111.04	111.08	1464100.0
2012-12-17	AGQ	ETF	200.4	201.28	197.52	199.92	241300.0
2012-12-17	AGZ	ETF	113.55	113.75	113.5	113.501	20877.0
2012-12-17	AIA	ETF	47.21	47.38	47.17	47.38	41714.0
2012-12-17	AIQ	ETF	6.15	6.45	6.1	6.45	12649.0
2012-12-17	AIVI	ETF	41.42	41.65	41.37	41.64	24800.0
2012-12-17	ALTL	ETF	25.86	25.96	25.86	25.94	1953.0
2012-12-17	AMJ	ETF	38.03	38.09	37.91	37.96	1302406.0
2012-12-17	AMLP	ETF	78.75	79.05	78.7	79.0	695540.0
2012-12-17	ANGL	ETF	27.04	27.21	27.04	27.2	6100.0
2012-12-17	AOA	ETF	36.99	37.2	36.99	37.2	29500.0
2012-12-17	AOK	ETF	30.5896	30.61	30.56	30.61	26868.0
2012-12-17	AOM	ETF	31.83	31.83	31.77	31.82	57271.0
2012-12-17	AOR	ETF	33.87	34.0165	33.87	34.01	44276.0
2012-12-17	ARB	ETF	37.6	38.3	37.42	38.04	160747.0
2012-12-17	ARGT	ETF	17.26	17.44	17.26	17.44	8950.0
2012-12-17	ASEA	ETF	17.0	17.17	17.0	17.13	32200.0
2012-12-17	AWAY	ETF	21.13	21.46	20.83	21.03	778380.0
2012-12-17	BAB	ETF	30.49	30.49	30.12	30.1374	255808.0
2012-12-17	BAL	ETF	49.22	49.7374	49.22	49.48	41714.0
2012-12-17	BALT	ETF	3.04	3.09	2.99	3.09	84542.0
2012-12-17	BBH	ETF	54.78	54.79	54.36	54.79	28200.0
2012-12-17	BCM	ETF	44.33	44.33	44.3099	44.3099	1000.0
2012-12-17	BIB	ETF	14.9175	14.9475	14.75	14.9475	44316.0
2012-12-17	BICK	ETF	24.78	24.85	24.75	24.85	22442.0
2012-12-17	BIL	ETF	91.62	91.64	91.62	91.62	665300.0
2012-12-17	BIS	ETF	2616.0	2621.2	2575.6	2575.6	627.5
2012-12-17	BIV	ETF	89.95	90.06	89.73	89.76	285200.0
2012-12-17	BJK	ETF	36.6	36.6	36.34	36.5	8700.0
2012-12-17	BKF	ETF	39.68	39.96	39.67	39.87	81775.0
2012-12-17	BKLN	ETF	24.89	24.92	24.88	24.92	495200.0
2012-12-17	BLV	ETF	96.12	96.12	95.17	95.25	55800.0
2012-12-17	BMVP	ETF	16.25	16.35	16.25	16.35	4039.0
2012-12-17	BND	ETF	84.59	84.59	84.39	84.39	1348100.0
2012-12-17	BNO	ETF	39.75	39.925	39.75	39.83	56800.0

> showing 50 of 961 rows — these rows as CSV

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