PREVIEW / etf_daily / 2012-12-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-14.parquet
  size:    39 KB
  rows:    957

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-14	SPY	ETF	142.32	142.58	141.88	142.1	137701700.0
2012-12-14	QQQ	ETF	64.9	65.08	64.47	64.69	39630252.0
2012-12-14	IWM	ETF	82.22	82.81	82.12	82.36	28508000.0
2012-12-14	DIA	ETF	131.7	132.0	131.26	131.46	3114300.0
2012-12-14	GLD	ETF	164.17	164.48	164.02	164.13	5351700.0
2012-12-14	TLT	ETF	123.19	123.71	123.08	123.6	3832800.0
2012-12-14	AADR	ETF	30.84	30.94	30.84	30.85	1600.0
2012-12-14	AAXJ	ETF	59.85	59.98	59.68	59.84	287600.0
2012-12-14	ACTV	ETF	4.98	5.04	4.87	4.96	752232.0
2012-12-14	ACWI	ETF	47.77	47.87	47.67	47.76	1414700.0
2012-12-14	ACWV	ETF	56.8	56.8	56.5	56.6	24100.0
2012-12-14	ACWX	ETF	41.49	41.63	41.4	41.52	202937.0
2012-12-14	ADRE	ETF	39.49	39.6485	39.49	39.59	33751.0
2012-12-14	AFK	ETF	31.15	31.28	31.08	31.18	17156.0
2012-12-14	AGEM	ETF	22.81	23.094	22.8	23.09	7392.0
2012-12-14	AGG	ETF	111.34	111.42	111.28	111.35	1678800.0
2012-12-14	AGQ	ETF	202.96	204.4	199.52	199.52	185250.0
2012-12-14	AGZ	ETF	113.66	113.74	113.577	113.74	16685.0
2012-12-14	AIA	ETF	47.89	47.9599	47.8435	47.906	3868.0
2012-12-14	AIQ	ETF	6.4	6.4	6.1	6.15	4026.0
2012-12-14	AIVI	ETF	41.32	41.58	41.3	41.4	48300.0
2012-12-14	AMJ	ETF	37.95	38.29	37.82	37.87	586131.0
2012-12-14	AMLP	ETF	78.75	79.4	78.75	78.8	467120.0
2012-12-14	ANGL	ETF	27.53	27.53	27.07	27.07	5600.0
2012-12-14	AOA	ETF	36.99	37.05	36.96	36.99	4300.0
2012-12-14	AOK	ETF	30.57	30.59	30.551	30.5736	9813.0
2012-12-14	AOM	ETF	31.78	31.79	31.74	31.75	14039.0
2012-12-14	AOR	ETF	33.9	33.93	33.856	33.87	14735.0
2012-12-14	ARB	ETF	37.65	37.865	37.3701	37.49	74217.0
2012-12-14	ARGT	ETF	17.24	17.36	17.2	17.36	1350.0
2012-12-14	ASEA	ETF	17.1	17.14	16.99	17.06	13100.0
2012-12-14	AWAY	ETF	20.64	21.26	20.64	21.1	513844.0
2012-12-14	BAB	ETF	30.4	30.42	30.311	30.39	121332.0
2012-12-14	BAL	ETF	48.82	49.03	48.82	49.03	19881.0
2012-12-14	BALT	ETF	2.88	3.1	2.88	3.08	89088.0
2012-12-14	BBH	ETF	54.93	54.99	54.18	54.2	18400.0
2012-12-14	BIB	ETF	14.83	14.9842	14.6275	14.6975	62592.0
2012-12-14	BICK	ETF	24.79	24.87	24.7201	24.731	24525.0
2012-12-14	BIL	ETF	91.64	91.64	91.62	91.62	163350.0
2012-12-14	BIS	ETF	2603.2	2636.8	2578.4	2636.8	982.5
2012-12-14	BIV	ETF	90.02	90.11	90.0	90.02	555300.0
2012-12-14	BJK	ETF	36.5	36.63	36.42	36.44	5500.0
2012-12-14	BKF	ETF	39.73	39.9199	39.57	39.83	70665.0
2012-12-14	BKLN	ETF	24.83	24.86	24.82	24.86	501800.0
2012-12-14	BLNG	ETF	51.0799	51.1001	50.99	51.03	1000.0
2012-12-14	BLV	ETF	95.7	96.16	95.7	96.04	32900.0
2012-12-14	BMVP	ETF	16.1667	16.21	16.1667	16.1767	3877.0
2012-12-14	BND	ETF	84.54	84.62	84.51	84.54	2883600.0
2012-12-14	BNO	ETF	39.585	39.945	39.58	39.9	59800.0
2012-12-14	BOIL	ETF	783000.0	814200.0	772000.0	791600.0	11.4

> showing 50 of 957 rows — these rows as CSV

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