PREVIEW / etf_daily / 2012-04-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-09.parquet
  size:    38 KB
  rows:    930

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-09	SPY	ETF	138.03	139.84	137.84	138.22	127555900.0
2012-04-09	QQQ	ETF	66.88	67.48	66.76	67.21	36908136.0
2012-04-09	IWM	ETF	80.09	80.57	79.85	80.24	50062200.0
2012-04-09	DIA	ETF	128.96	129.59	128.84	129.12	5360200.0
2012-04-09	GLD	ETF	159.72	160.01	158.91	159.37	8245800.0
2012-04-09	TLT	ETF	115.54	115.77	115.24	115.55	14374600.0
2012-04-09	AAXJ	ETF	55.67	55.9	55.59	55.66	127400.0
2012-04-09	ACTV	ETF	16.63	16.63	16.19	16.19	104496.0
2012-04-09	ACWI	ETF	45.86	46.13	45.74	45.98	723000.0
2012-04-09	ACWV	ETF	53.95	53.95	53.95	53.95	300.0
2012-04-09	ACWX	ETF	39.36	39.64	39.33	39.54	89564.0
2012-04-09	ADRE	ETF	40.94	41.32	40.81	41.22	37572.0
2012-04-09	AFK	ETF	28.45	28.83	28.32	28.51	13137.0
2012-04-09	AGEM	ETF	22.62	22.766	22.62	22.73	1870.0
2012-04-09	AGG	ETF	110.18	110.19	110.04	110.11	575600.0
2012-04-09	AGQ	ETF	209.2	210.08	204.0	206.24	288675.0
2012-04-09	AGZ	ETF	112.59	112.75	112.53	112.64	39961.0
2012-04-09	AIA	ETF	44.13	44.3832	44.13	44.25	9144.0
2012-04-09	AIQ	ETF	7.25	7.5	6.85	7.4	22739.0
2012-04-09	AIS	ETF	3.19	3.19	3.02	3.05	1037149.0
2012-04-09	AIVI	ETF	39.83	40.12	39.77	40.07	44300.0
2012-04-09	AMJ	ETF	38.49	38.89	38.49	38.8	1084599.0
2012-04-09	AMLP	ETF	82.45	82.95	82.45	82.65	262640.0
2012-04-09	AOA	ETF	35.75	35.83	35.6	35.78	7800.0
2012-04-09	AOK	ETF	29.9	29.98	29.89	29.95	30976.0
2012-04-09	AOM	ETF	30.89	30.986	30.87	30.92	9865.0
2012-04-09	AOR	ETF	32.88	32.97	32.812	32.89	14651.0
2012-04-09	ARB	ETF	36.25	36.46	35.98	36.25	155672.0
2012-04-09	ARGT	ETF	20.02	20.18	19.78	20.02	5100.0
2012-04-09	ASEA	ETF	16.0	16.03	15.88	16.0	6800.0
2012-04-09	AWAY	ETF	23.59	23.91	23.444	23.65	209426.0
2012-04-09	BAB	ETF	29.15	29.5856	29.15	29.47	376481.0
2012-04-09	BAL	ETF	54.08	54.76	54.03	54.47	14675.0
2012-04-09	BALT	ETF	4.2	4.3	4.02	4.07	111810.0
2012-04-09	BBH	ETF	43.9	43.98	43.57	43.62	38000.0
2012-04-09	BCM	ETF	45.07	45.07	45.07	45.07	696.0
2012-04-09	BIB	ETF	11.9413	11.9413	11.6017	11.6625	25936.0
2012-04-09	BICK	ETF	25.88	25.88	25.53	25.68	52284.0
2012-04-09	BIL	ETF	91.64	91.66	91.64	91.66	1136000.0
2012-04-09	BIS	ETF	3696.0	3767.36	3696.0	3767.36	25.6
2012-04-09	BIV	ETF	87.45	87.45	87.16	87.25	229300.0
2012-04-09	BJK	ETF	35.27	35.83	35.27	35.75	40400.0
2012-04-09	BKF	ETF	40.34	40.48	40.0	40.29	216380.0
2012-04-09	BKLN	ETF	24.54	24.54	24.46	24.5	114300.0
2012-04-09	BLV	ETF	90.25	90.44	89.99	90.04	54600.0
2012-04-09	BMVP	ETF	15.36	15.4	15.32	15.39	2808.0
2012-04-09	BND	ETF	83.45	83.53	83.36	83.37	1167600.0
2012-04-09	BNO	ETF	42.74	43.115	42.51	43.05	131000.0
2012-04-09	BOIL	ETF	734000.0	746000.0	721000.0	744000.0	4.6
2012-04-09	BOND	ETF	102.1	102.35	102.1	102.2573	234139.0

> showing 50 of 930 rows — these rows as CSV

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