PREVIEW / etf_daily / 2012-10-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-12.parquet
  size:    39 KB
  rows:    939

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-10-12	SPY	ETF	143.46	143.95	142.58	142.89	124181900.0
2012-10-12	QQQ	ETF	66.73	67.06	66.55	66.68	24894927.0
2012-10-12	IWM	ETF	82.74	83.02	81.91	82.1	31847100.0
2012-10-12	DIA	ETF	133.26	133.83	132.75	133.13	3271200.0
2012-10-12	GLD	ETF	171.15	171.41	169.81	170.06	8266000.0
2012-10-12	TLT	ETF	124.07	124.78	123.78	123.97	4934900.0
2012-10-12	AAXJ	ETF	56.02	56.34	55.96	56.05	167800.0
2012-10-12	ACTV	ETF	10.84	10.84	10.715	10.81	235085.0
2012-10-12	ACWI	ETF	46.79	46.9	46.53	46.63	748600.0
2012-10-12	ACWV	ETF	56.65	56.68	56.19	56.24	16200.0
2012-10-12	ACWX	ETF	39.5	39.62	39.24	39.33	195387.0
2012-10-12	ADRE	ETF	39.01	39.22	38.886	38.97	26791.0
2012-10-12	AFK	ETF	31.7523	31.7523	31.33	31.38	15578.0
2012-10-12	AGEM	ETF	22.29	22.3	22.29	22.29	1960.0
2012-10-12	AGG	ETF	112.32	112.41	112.26	112.32	1646900.0
2012-10-12	AGQ	ETF	221.72	223.72	218.52	219.0	262550.0
2012-10-12	AGZ	ETF	113.82	113.93	113.82	113.9	31543.0
2012-10-12	AIA	ETF	44.39	44.4599	44.2	44.36	7581.0
2012-10-12	AIQ	ETF	6.8	7.05	6.8	7.05	13698.0
2012-10-12	AIVI	ETF	40.16	40.21	39.86	39.97	14000.0
2012-10-12	AMJ	ETF	40.84	40.86	40.62	40.69	1266255.0
2012-10-12	AMLP	ETF	83.3	83.9	83.15	83.35	241360.0
2012-10-12	ANGL	ETF	26.51	26.64	26.5	26.5	1000.0
2012-10-12	AOA	ETF	36.62	36.62	36.4	36.45	8100.0
2012-10-12	AOK	ETF	30.46	30.48	30.44	30.47	6966.0
2012-10-12	AOM	ETF	31.5799	31.6	31.4815	31.49	69824.0
2012-10-12	AOR	ETF	33.6335	33.67	33.54	33.5683	14430.0
2012-10-12	ARB	ETF	38.1	38.59	37.675	38.0	78710.0
2012-10-12	ASEA	ETF	16.75	16.78	16.68	16.68	14800.0
2012-10-12	AWAY	ETF	26.96	27.26	26.2	26.87	666496.0
2012-10-12	BAB	ETF	30.01	30.13	30.01	30.12	201140.0
2012-10-12	BAL	ETF	46.6501	47.07	46.5701	47.07	2000.0
2012-10-12	BALT	ETF	3.13	3.27	3.11	3.24	62445.0
2012-10-12	BBH	ETF	54.5	54.53	53.95	53.97	23200.0
2012-10-12	BCM	ETF	45.6834	45.75	45.6834	45.75	550.0
2012-10-12	BIB	ETF	15.965	15.965	15.505	15.555	25940.0
2012-10-12	BICK	ETF	23.58	23.7699	23.4801	23.5901	4364.0
2012-10-12	BIL	ETF	91.64	91.64	91.62	91.62	189650.0
2012-10-12	BIS	ETF	2568.4	2578.4	2568.4	2578.4	26.6
2012-10-12	BIV	ETF	90.27	90.44	90.24	90.33	164200.0
2012-10-12	BJK	ETF	33.84	33.84	33.54	33.58	1200.0
2012-10-12	BKF	ETF	38.25	38.41	38.11	38.15	37598.0
2012-10-12	BKLN	ETF	25.0	25.05	24.99	24.99	695600.0
2012-10-12	BLV	ETF	97.07	97.42	96.84	97.08	309100.0
2012-10-12	BMVP	ETF	15.9333	15.9434	15.8567	15.91	8429.0
2012-10-12	BND	ETF	85.0	85.03	84.96	85.0	2403700.0
2012-10-12	BNO	ETF	41.4	41.58	41.095	41.35	48000.0
2012-10-12	BOIL	ETF	1147000.0	1159800.0	1135000.0	1150000.0	13.6
2012-10-12	BOND	ETF	109.23	109.369	109.21	109.32	608699.0
2012-10-12	BRF	ETF	41.048	41.32	40.88	40.88	51811.0

> showing 50 of 939 rows — these rows as CSV

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