PREVIEW / etf_daily / 2012-12-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-06.parquet
  size:    39 KB
  rows:    950

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-12-06	SPY	ETF	141.37	142.04	141.16	141.98	103220600.0
2012-12-06	QQQ	ETF	64.71	65.4801	64.53	65.32	47519071.0
2012-12-06	IWM	ETF	81.98	82.31	81.61	82.12	31829500.0
2012-12-06	DIA	ETF	130.34	130.8	130.09	130.74	4129400.0
2012-12-06	GLD	ETF	163.72	165.0	163.53	164.5	7301600.0
2012-12-06	TLT	ETF	125.86	126.08	125.51	125.59	2301200.0
2012-12-06	AADR	ETF	30.75	30.75	30.6	30.6	800.0
2012-12-06	AAXJ	ETF	58.64	59.06	58.64	59.04	160700.0
2012-12-06	ACTV	ETF	4.7	4.79	4.64	4.65	586957.0
2012-12-06	ACWI	ETF	47.41	47.5	47.28	47.49	566200.0
2012-12-06	ACWV	ETF	56.56	57.09	55.33	56.48	206900.0
2012-12-06	ACWX	ETF	41.01	41.01	40.81	40.97	144957.0
2012-12-06	ADRE	ETF	38.47	38.74	38.47	38.74	18859.0
2012-12-06	AFK	ETF	30.47	30.5299	30.3415	30.37	14448.0
2012-12-06	AGEM	ETF	22.66	22.71	22.53	22.71	1209.0
2012-12-06	AGG	ETF	111.77	111.84	111.73	111.76	519400.0
2012-12-06	AGQ	ETF	205.84	213.32	205.52	209.88	264675.0
2012-12-06	AGZ	ETF	113.9508	113.9508	113.6901	113.78	14194.0
2012-12-06	AIA	ETF	46.65	46.88	46.63	46.88	8562.0
2012-12-06	AIQ	ETF	6.15	6.15	6.05	6.1	6729.0
2012-12-06	AIVI	ETF	40.92	40.95	40.67	40.85	42700.0
2012-12-06	AMJ	ETF	38.47	38.6966	38.3718	38.45	1674108.0
2012-12-06	AMLP	ETF	80.15	80.15	79.6	79.8	497660.0
2012-12-06	ANGL	ETF	27.22	27.22	27.1	27.11	7900.0
2012-12-06	AOA	ETF	36.76	36.88	36.75	36.87	18800.0
2012-12-06	AOK	ETF	30.55	30.59	30.55	30.55	5910.0
2012-12-06	AOM	ETF	31.69	31.78	31.69	31.78	15581.0
2012-12-06	AOR	ETF	33.8	33.84	33.722	33.82	14280.0
2012-12-06	ARB	ETF	37.8	38.29	37.67	38.25	69387.0
2012-12-06	ARGT	ETF	16.44	16.46	16.38	16.38	3550.0
2012-12-06	ASEA	ETF	16.69	16.79	16.69	16.74	15700.0
2012-12-06	AWAY	ETF	20.54	20.98	20.2367	20.35	221588.0
2012-12-06	BAB	ETF	30.69	30.75	30.67	30.72	157063.0
2012-12-06	BAL	ETF	47.7201	48.0	47.69	47.95	6350.0
2012-12-06	BALT	ETF	2.81	2.87	2.75	2.78	58070.0
2012-12-06	BBH	ETF	54.41	54.65	54.12	54.25	14200.0
2012-12-06	BCM	ETF	44.63	44.63	44.3931	44.4799	3373.0
2012-12-06	BIB	ETF	14.6975	14.85	14.5725	14.5725	26932.0
2012-12-06	BICK	ETF	24.13	24.38	24.13	24.38	47348.0
2012-12-06	BIL	ETF	91.62	91.64	91.62	91.62	137200.0
2012-12-06	BIS	ETF	2620.8	2653.6	2602.8	2650.0	682.5
2012-12-06	BIV	ETF	90.69	90.71	90.58	90.61	335200.0
2012-12-06	BJK	ETF	35.27	35.71	35.19	35.71	28900.0
2012-12-06	BKF	ETF	38.86	39.17	38.841	39.14	92543.0
2012-12-06	BKLN	ETF	24.86	24.89	24.82	24.86	584000.0
2012-12-06	BLV	ETF	97.34	97.54	97.23	97.36	94600.0
2012-12-06	BMVP	ETF	15.9712	16.0767	15.9567	16.0767	2960.0
2012-12-06	BND	ETF	85.0	85.04	84.94	84.97	771800.0
2012-12-06	BNO	ETF	39.39	39.485	39.09	39.155	61000.0
2012-12-06	BOIL	ETF	959400.0	999000.0	929200.0	946000.0	19.4

> showing 50 of 950 rows — these rows as CSV

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