PREVIEW / etf_daily / 2012-10-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-31.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-10-31	SPY	ETF	141.85	142.03	140.68	141.35	103438500.0
2012-10-31	QQQ	ETF	65.31	65.39	64.73	64.95	38524479.0
2012-10-31	IWM	ETF	81.16	81.65	80.88	81.63	24879800.0
2012-10-31	DIA	ETF	131.35	131.59	130.23	130.6	3939600.0
2012-10-31	GLD	ETF	166.47	167.28	166.38	166.83	4681500.0
2012-10-31	TLT	ETF	122.68	123.7	122.63	123.36	5025600.0
2012-10-31	AADR	ETF	29.85	29.85	29.85	29.85	800.0
2012-10-31	AAXJ	ETF	56.8	56.8	56.19	56.3	276100.0
2012-10-31	ACTV	ETF	9.01	9.14	8.5	8.86	3131352.0
2012-10-31	ACWI	ETF	46.99	46.99	46.3	46.45	848200.0
2012-10-31	ACWV	ETF	56.35	56.68	56.21	56.55	48200.0
2012-10-31	ACWX	ETF	39.85	39.85	39.504	39.64	88834.0
2012-10-31	ADRE	ETF	38.68	39.3457	38.54	38.84	47787.0
2012-10-31	AFK	ETF	31.49	31.7	31.29	31.68	66964.0
2012-10-31	AGG	ETF	112.04	112.24	112.0	112.19	2200200.0
2012-10-31	AGQ	ETF	201.52	204.44	201.08	202.76	179700.0
2012-10-31	AGZ	ETF	113.63	113.73	113.51	113.73	81103.0
2012-10-31	AIA	ETF	44.89	44.9326	44.482	44.58	12079.0
2012-10-31	AIQ	ETF	6.7	7.0	6.7	6.9	9935.0
2012-10-31	AIVI	ETF	40.53	40.53	40.13	40.26	83900.0
2012-10-31	AMJ	ETF	40.55	40.79	40.27	40.57	542693.0
2012-10-31	AMLP	ETF	83.1	83.35	82.6	83.0	374460.0
2012-10-31	ANGL	ETF	27.45	27.45	26.69	26.79	7300.0
2012-10-31	AOA	ETF	36.39	36.43	36.28	36.4	3300.0
2012-10-31	AOK	ETF	30.4	30.55	30.39	30.44	35319.0
2012-10-31	AOM	ETF	31.45	31.51	31.4	31.44	46281.0
2012-10-31	AOR	ETF	33.46	33.559	33.398	33.5	22851.0
2012-10-31	ARB	ETF	36.57	36.84	35.96	36.36	56903.0
2012-10-31	ARGT	ETF	16.9	16.9	16.64	16.72	2300.0
2012-10-31	ASEA	ETF	16.76	16.82	16.67	16.79	3100.0
2012-10-31	AWAY	ETF	24.93	26.28	24.77	25.71	442917.0
2012-10-31	BAB	ETF	29.97	30.19	29.9401	30.16	204406.0
2012-10-31	BAL	ETF	46.9	46.9	45.81	46.36	17986.0
2012-10-31	BALT	ETF	3.44	3.5	3.38	3.41	40880.0
2012-10-31	BBH	ETF	52.18	52.2	50.98	51.22	116900.0
2012-10-31	BCM	ETF	44.65	44.65	44.398	44.42	17261.0
2012-10-31	BIB	ETF	13.9475	14.175	13.3475	13.45	106672.0
2012-10-31	BICK	ETF	23.64	23.64	23.53	23.62	5213.0
2012-10-31	BIL	ETF	91.62	91.64	91.62	91.64	395350.0
2012-10-31	BIS	ETF	2820.0	2951.932	2820.0	2951.932	85.5
2012-10-31	BIV	ETF	90.14	90.36	90.13	90.3	268100.0
2012-10-31	BJK	ETF	34.49	34.55	34.45	34.51	16500.0
2012-10-31	BKF	ETF	38.41	38.4812	38.08	38.15	73274.0
2012-10-31	BKLN	ETF	24.81	24.84	24.81	24.84	578300.0
2012-10-31	BLV	ETF	96.38	96.97	96.33	96.82	93900.0
2012-10-31	BMVP	ETF	15.7067	15.72	15.57	15.67	16706.0
2012-10-31	BND	ETF	84.89	84.96	84.8	84.89	1030900.0
2012-10-31	BNO	ETF	39.725	39.845	39.42	39.435	44000.0
2012-10-31	BOIL	ETF	1090400.0	1092600.0	1050200.0	1054200.0	5.8
2012-10-31	BOND	ETF	109.25	109.44	109.224	109.44	608473.0

> showing 50 of 949 rows — these rows as CSV

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