PREVIEW / etf_daily / 2012-04-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-16.parquet
  size:    39 KB
  rows:    935

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-16	SPY	ETF	137.84	138.04	136.58	137.05	147825300.0
2012-04-16	QQQ	ETF	66.53	66.56	65.24	65.45	57587271.0
2012-04-16	IWM	ETF	79.89	80.2	78.88	79.67	44725900.0
2012-04-16	DIA	ETF	129.23	129.7	128.68	129.07	7503100.0
2012-04-16	GLD	ETF	160.51	161.18	159.53	160.46	6670500.0
2012-04-16	TLT	ETF	116.7	117.6	116.57	116.67	7735000.0
2012-04-16	AADR	ETF	30.21	30.21	30.21	30.21	200.0
2012-04-16	AAXJ	ETF	56.15	56.29	55.5	55.72	1441200.0
2012-04-16	ACTV	ETF	16.55	16.74	16.52	16.71	191276.0
2012-04-16	ACWI	ETF	46.03	46.05	45.58	45.78	171100.0
2012-04-16	ACWV	ETF	53.64	53.64	53.64	53.64	200.0
2012-04-16	ACWX	ETF	39.63	39.69	39.24	39.46	143930.0
2012-04-16	ADRE	ETF	41.48	41.48	40.84	40.9888	29309.0
2012-04-16	AFK	ETF	28.55	28.55	28.31	28.38	5567.0
2012-04-16	AGEM	ETF	22.76	22.79	22.55	22.654	4219.0
2012-04-16	AGG	ETF	110.24	110.49	110.24	110.38	1121200.0
2012-04-16	AGQ	ETF	206.92	208.68	203.24	205.6	302050.0
2012-04-16	AGZ	ETF	112.63	112.83	112.63	112.81	11406.0
2012-04-16	AIA	ETF	44.7	44.7	44.12	44.249	2291.0
2012-04-16	AIQ	ETF	7.15	7.3	7.1	7.3	6335.0
2012-04-16	AIS	ETF	2.99	3.05	2.97	3.0	538333.0
2012-04-16	AIVI	ETF	39.82	39.95	39.51	39.82	34300.0
2012-04-16	AMJ	ETF	38.66	38.89	38.44	38.61	796949.0
2012-04-16	AMLP	ETF	82.65	82.95	82.05	82.15	367600.0
2012-04-16	ANGL	ETF	25.4	25.4	25.36	25.38	10600.0
2012-04-16	AOA	ETF	35.78	35.78	35.49	35.63	16500.0
2012-04-16	AOK	ETF	30.06	30.06	29.9423	29.97	15205.0
2012-04-16	AOM	ETF	30.99	30.99	30.84	30.95	22307.0
2012-04-16	AOR	ETF	32.91	32.93	32.742	32.81	17187.0
2012-04-16	ARB	ETF	38.0	38.64	37.45	38.04	261418.0
2012-04-16	ARGT	ETF	19.4	19.4	19.32	19.32	900.0
2012-04-16	ASEA	ETF	16.05	16.09	15.97	16.05	5900.0
2012-04-16	AWAY	ETF	24.02	24.18	23.41	24.02	155842.0
2012-04-16	BAB	ETF	29.37	29.5	29.329	29.4	101550.0
2012-04-16	BAL	ETF	55.69	55.82	53.777	54.58	32196.0
2012-04-16	BALT	ETF	4.08	4.2	4.01	4.13	57530.0
2012-04-16	BBH	ETF	42.66	42.7	41.96	42.35	16800.0
2012-04-16	BIB	ETF	11.0113	11.0538	10.6664	10.9488	33024.0
2012-04-16	BICK	ETF	26.06	26.06	25.59	25.6	4621.0
2012-04-16	BIL	ETF	91.64	91.66	91.62	91.64	617250.0
2012-04-16	BIS	ETF	3932.8	4067.2	3932.8	4003.072	91.0
2012-04-16	BIV	ETF	87.66	87.75	87.41	87.41	630100.0
2012-04-16	BJK	ETF	36.33	36.44	35.71	35.85	14300.0
2012-04-16	BKF	ETF	40.73	40.79	39.97	40.11	68874.0
2012-04-16	BKLN	ETF	24.41	24.44	24.36	24.36	429800.0
2012-04-16	BLV	ETF	90.96	91.32	90.76	90.92	51100.0
2012-04-16	BMVP	ETF	15.26	15.26	15.12	15.15	4291.0
2012-04-16	BND	ETF	83.73	83.8	83.67	83.71	1235900.0
2012-04-16	BNO	ETF	42.27	42.3	41.715	41.745	92200.0
2012-04-16	BOIL	ETF	656000.0	660000.0	638000.0	654000.0	4.4

> showing 50 of 935 rows — these rows as CSV

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