PREVIEW / etf_daily / 2012-11-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-01.parquet
  size:    39 KB
  rows:    949

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-11-01	SPY	ETF	141.65	143.01	141.52	142.83	100995600.0
2012-11-01	QQQ	ETF	65.32	66.0	65.17	65.8729	26944931.0
2012-11-01	IWM	ETF	81.82	82.71	81.52	82.49	77113300.0
2012-11-01	DIA	ETF	131.02	132.44	130.97	131.98	3807400.0
2012-11-01	GLD	ETF	167.02	167.04	166.04	166.07	6018000.0
2012-11-01	TLT	ETF	122.77	122.88	122.08	122.35	3659700.0
2012-11-01	AADR	ETF	29.86	30.2	29.86	30.2	1100.0
2012-11-01	AAXJ	ETF	57.0	57.42	56.84	57.32	533400.0
2012-11-01	ACTV	ETF	8.63	9.49	8.46	9.29	2261315.0
2012-11-01	ACWI	ETF	46.7	47.09	46.66	47.07	1188700.0
2012-11-01	ACWV	ETF	56.63	56.82	56.57	56.74	46400.0
2012-11-01	ACWX	ETF	39.85	40.1	39.85	40.1	132827.0
2012-11-01	ADRE	ETF	39.0	39.45	39.0	39.39	23077.0
2012-11-01	AFK	ETF	31.46	31.7	31.391	31.6217	21927.0
2012-11-01	AGG	ETF	112.05	112.05	111.78	111.8	1350800.0
2012-11-01	AGQ	ETF	206.0	206.0	201.6	202.08	159350.0
2012-11-01	AGZ	ETF	113.64	113.89	113.62	113.67	6884.0
2012-11-01	AIA	ETF	44.88	45.1999	44.88	45.14	17041.0
2012-11-01	AIQ	ETF	7.0	7.4	6.95	7.1	85399.0
2012-11-01	AIVI	ETF	40.47	40.67	40.41	40.52	18800.0
2012-11-01	ALTL	ETF	25.61	25.61	25.61	25.61	700.0
2012-11-01	AMJ	ETF	40.63	40.87	40.5801	40.75	366169.0
2012-11-01	AMLP	ETF	83.05	83.3	82.95	83.25	278540.0
2012-11-01	AOA	ETF	36.47	36.76	36.47	36.76	7000.0
2012-11-01	AOK	ETF	30.44	30.55	30.44	30.5349	19765.0
2012-11-01	AOM	ETF	31.52	31.62	31.52	31.57	33728.0
2012-11-01	AOR	ETF	33.55	33.74	33.55	33.7352	15910.0
2012-11-01	ARB	ETF	36.3	37.38	36.2024	37.25	119875.0
2012-11-01	ARGT	ETF	17.0	17.0	17.0	17.0	500.0
2012-11-01	ASEA	ETF	16.84	16.91	16.8	16.82	4600.0
2012-11-01	AWAY	ETF	25.32	26.06	24.96	25.9	828941.0
2012-11-01	BAB	ETF	30.21	30.21	30.05	30.1	189738.0
2012-11-01	BAL	ETF	46.12	46.3752	45.991	46.34	4000.0
2012-11-01	BALT	ETF	3.39	3.43	3.35	3.41	58252.0
2012-11-01	BBH	ETF	51.26	52.35	51.26	51.96	60700.0
2012-11-01	BCM	ETF	44.67	44.68	44.612	44.65	2227.0
2012-11-01	BIB	ETF	13.4675	14.09	13.425	13.9	141208.0
2012-11-01	BICK	ETF	23.76	24.099	23.76	24.05	7320.0
2012-11-01	BIL	ETF	91.64	91.64	91.62	91.64	66550.0
2012-11-01	BIS	ETF	2886.0	2886.0	2804.4	2808.64	97.0
2012-11-01	BIV	ETF	90.08	90.15	90.0	90.12	180400.0
2012-11-01	BJK	ETF	34.89	35.18	34.76	35.13	4200.0
2012-11-01	BKF	ETF	38.72	39.06	38.64	39.05	68623.0
2012-11-01	BKLN	ETF	24.82	24.86	24.81	24.86	3872600.0
2012-11-01	BLV	ETF	96.38	96.38	96.0	96.32	113300.0
2012-11-01	BMVP	ETF	15.7	15.8611	15.7	15.8611	2428.0
2012-11-01	BND	ETF	84.73	84.78	84.65	84.76	1039100.0
2012-11-01	BNO	ETF	39.335	39.55	39.235	39.31	79400.0
2012-11-01	BOIL	ETF	1057400.0	1072000.0	1030000.0	1041000.0	4.4
2012-11-01	BOND	ETF	109.4	109.43	109.25	109.38	958854.0

> showing 50 of 949 rows — these rows as CSV

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