PREVIEW / etf_daily / 2012-12-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-31.parquet
  size:    40 KB
  rows:    978

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-31	SPY	ETF	139.66	142.56	139.54	142.41	243935200.0
2012-12-31	QQQ	ETF	63.68	65.2521	63.58	65.1301	57553098.0
2012-12-31	IWM	ETF	82.66	84.43	82.35	84.32	67461100.0
2012-12-31	DIA	ETF	128.66	130.9	128.54	130.58	12067800.0
2012-12-31	GLD	ETF	160.9	162.75	160.77	162.02	11786200.0
2012-12-31	TLT	ETF	122.87	122.97	120.91	121.18	6423000.0
2012-12-31	AADR	ETF	31.0	31.0	30.74	30.74	500.0
2012-12-31	AAXJ	ETF	59.86	60.52	59.53	60.52	729100.0
2012-12-31	ACTV	ETF	4.78	5.1	4.74	4.91	879815.0
2012-12-31	ACWI	ETF	47.17	48.12	47.17	48.08	1015900.0
2012-12-31	ACWV	ETF	55.29	55.63	55.12	55.63	27400.0
2012-12-31	ACWX	ETF	41.67	42.071	41.3725	41.88	564045.0
2012-12-31	ADRE	ETF	39.79	40.22	39.5601	40.22	82494.0
2012-12-31	AFK	ETF	31.0	31.35	30.87	31.35	47921.0
2012-12-31	AGEM	ETF	23.3	23.51	23.16	23.51	8053.0
2012-12-31	AGG	ETF	111.25	111.26	111.02	111.08	905400.0
2012-12-31	AGQ	ETF	173.04	177.64	172.0	176.4	322350.0
2012-12-31	AGZ	ETF	113.45	113.53	113.295	113.295	29535.0
2012-12-31	AIA	ETF	47.5	48.15	47.5	48.15	31543.0
2012-12-31	AIQ	ETF	6.31	6.61	6.31	6.38	9550.0
2012-12-31	AIVI	ETF	41.34	41.9	41.34	41.9	24600.0
2012-12-31	AMJ	ETF	37.89	38.54	37.69	38.46	2068828.0
2012-12-31	AMLP	ETF	79.0	79.9	78.75	79.75	518500.0
2012-12-31	ANGL	ETF	26.61	26.8	26.59	26.8	7900.0
2012-12-31	AOA	ETF	36.72	37.2	36.72	37.17	41400.0
2012-12-31	AOK	ETF	30.45	30.58	30.45	30.58	96515.0
2012-12-31	AOM	ETF	31.47	31.73	31.47	31.73	29126.0
2012-12-31	AOR	ETF	33.61	33.97	33.61	33.97	41831.0
2012-12-31	ARB	ETF	46.62	46.7	46.5	46.68	881848.0
2012-12-31	ARGT	ETF	17.34	17.34	16.94	17.1	1350.0
2012-12-31	ASEA	ETF	16.75	17.06	16.75	17.04	62500.0
2012-12-31	AWAY	ETF	20.96	22.07	20.92	22.0	549693.0
2012-12-31	BAB	ETF	30.37	30.382	30.11	30.24	344063.0
2012-12-31	BAL	ETF	48.75	49.35	48.7101	49.14	9841.0
2012-12-31	BALT	ETF	2.93	3.0	2.92	2.98	74149.0
2012-12-31	BBH	ETF	52.76	53.57	52.5	53.5	21200.0
2012-12-31	BCM	ETF	43.63	65.42	43.63	44.622	2949.0
2012-12-31	BIB	ETF	13.76	14.4923	13.76	14.4923	83664.0
2012-12-31	BICK	ETF	25.17	25.3915	25.0608	25.33	11270.0
2012-12-31	BIL	ETF	91.64	91.64	91.62	91.62	373700.0
2012-12-31	BIS	ETF	2760.0	2760.0	2653.2	2653.2	167.5
2012-12-31	BIV	ETF	88.52	88.57	88.25	88.25	438100.0
2012-12-31	BJK	ETF	35.24	35.6	35.24	35.45	32800.0
2012-12-31	BKF	ETF	40.3	40.93	40.13	40.84	385607.0
2012-12-31	BKLN	ETF	24.93	24.99	24.93	24.98	744600.0
2012-12-31	BLV	ETF	94.5	94.6	93.68	93.87	82900.0
2012-12-31	BMVP	ETF	15.96	16.26	15.96	16.26	7546.0
2012-12-31	BND	ETF	84.13	84.16	83.96	84.03	2099100.0
2012-12-31	BNO	ETF	40.415	41.035	40.415	41.035	69600.0
2012-12-31	BOIL	ETF	802000.0	804800.0	777000.0	784800.0	15.2

> showing 50 of 978 rows — these rows as CSV

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