PREVIEW / etf_daily / 2012-04-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-02.parquet
  size:    39 KB
  rows:    928

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-04-02	SPY	ETF	140.64	142.21	140.36	141.84	151741100.0
2012-04-02	QQQ	ETF	67.46	68.34	67.36	68.25	40031540.0
2012-04-02	IWM	ETF	82.54	83.86	82.38	83.83	52756800.0
2012-04-02	DIA	ETF	131.56	132.68	131.23	132.3	8683800.0
2012-04-02	GLD	ETF	161.96	163.56	161.81	162.94	7541700.0
2012-04-02	TLT	ETF	113.0	113.3	112.2	112.53	8944000.0
2012-04-02	AAXJ	ETF	56.46	57.24	56.35	57.07	229900.0
2012-04-02	ACTV	ETF	16.77	16.87	16.42	16.79	136659.0
2012-04-02	ACWI	ETF	47.08	47.82	46.99	47.69	565800.0
2012-04-02	ACWV	ETF	54.91	55.02	54.91	55.01	3800.0
2012-04-02	ACWX	ETF	40.68	41.49	40.66	41.35	301387.0
2012-04-02	ADRE	ETF	42.19	42.8419	42.1	42.68	66401.0
2012-04-02	AFK	ETF	29.41	29.72	29.247	29.64	17178.0
2012-04-02	AGEM	ETF	23.3	23.3	23.25	23.2501	550.0
2012-04-02	AGG	ETF	109.88	109.88	109.46	109.62	2398400.0
2012-04-02	AGQ	ETF	219.84	230.44	219.24	227.12	524775.0
2012-04-02	AGZ	ETF	112.31	112.4882	112.24	112.345	19879.0
2012-04-02	AIA	ETF	44.62	45.15	44.46	45.15	21827.0
2012-04-02	AIQ	ETF	7.5	7.85	7.5	7.7	31795.0
2012-04-02	AIS	ETF	3.26	3.28	3.18	3.22	1002656.0
2012-04-02	AIVI	ETF	41.59	42.34	41.57	42.17	33500.0
2012-04-02	AMJ	ETF	39.05	39.42	39.02	39.16	1264578.0
2012-04-02	AMLP	ETF	82.8	83.5	82.8	83.25	301500.0
2012-04-02	AOA	ETF	36.39	36.76	36.35	36.69	30400.0
2012-04-02	AOK	ETF	30.18	30.28	30.1424	30.26	37827.0
2012-04-02	AOM	ETF	31.1901	31.3897	31.1901	31.36	32532.0
2012-04-02	AOR	ETF	33.32	33.55	33.26	33.49	23550.0
2012-04-02	ARB	ETF	37.31	37.68	36.7	37.66	288460.0
2012-04-02	ARGT	ETF	21.42	21.42	21.16	21.16	1750.0
2012-04-02	ASEA	ETF	16.28	16.44	16.28	16.43	8700.0
2012-04-02	AWAY	ETF	25.2	25.32	23.455	23.84	313429.0
2012-04-02	BAB	ETF	29.09	29.2	29.07	29.152	77070.0
2012-04-02	BAL	ETF	56.82	56.99	56.06	56.6	47366.0
2012-04-02	BALT	ETF	4.18	4.32	4.08	4.3	117851.0
2012-04-02	BBH	ETF	44.36	44.63	44.0	44.54	15200.0
2012-04-02	BCM	ETF	46.98	47.3	45.5941	46.02	8425.0
2012-04-02	BIB	ETF	12.0	12.2112	11.875	12.2112	18816.0
2012-04-02	BICK	ETF	26.44	26.7	26.42	26.61	8650.0
2012-04-02	BIL	ETF	91.64	91.66	91.62	91.62	778250.0
2012-04-02	BIS	ETF	3654.4	3654.4	3589.76	3589.76	2.81
2012-04-02	BIV	ETF	86.55	86.77	86.52	86.66	395600.0
2012-04-02	BJK	ETF	36.1	36.61	36.08	36.38	15600.0
2012-04-02	BKF	ETF	40.9	41.572	40.7	41.41	102903.0
2012-04-02	BKLN	ETF	24.58	24.63	24.54	24.6	298900.0
2012-04-02	BLNG	ETF	51.52	51.52	51.1901	51.1901	900.0
2012-04-02	BLV	ETF	89.02	89.15	88.56	88.78	35200.0
2012-04-02	BMVP	ETF	15.51	15.72	15.51	15.69	15841.0
2012-04-02	BND	ETF	83.05	83.2	82.93	83.0	1856700.0
2012-04-02	BNO	ETF	42.84	44.125	42.805	44.08	66200.0
2012-04-02	BOIL	ETF	731000.0	780000.0	728000.0	773000.0	5.8

> showing 50 of 928 rows — these rows as CSV

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