PREVIEW / etf_daily / 2012-11-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-16.parquet
  size:    39 KB
  rows:    951

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-16	SPY	ETF	135.9	136.64	134.7	136.37	239483900.0
2012-11-16	QQQ	ETF	62.08	62.48	61.31	62.3	70868025.0
2012-11-16	IWM	ETF	76.78	77.68	76.13	77.48	62748300.0
2012-11-16	DIA	ETF	125.25	125.77	124.42	125.6	9350400.0
2012-11-16	GLD	ETF	165.74	166.36	165.47	165.88	6944000.0
2012-11-16	TLT	ETF	126.36	127.19	126.28	126.37	4591100.0
2012-11-16	AAXJ	ETF	55.55	55.67	55.11	55.59	286500.0
2012-11-16	ACTV	ETF	4.98	5.07	4.67	4.94	1290902.0
2012-11-16	ACWI	ETF	45.08	45.21	44.68	45.18	1030400.0
2012-11-16	ACWV	ETF	54.92	55.0	54.48	55.0	5400.0
2012-11-16	ACWX	ETF	38.64	38.64	38.2	38.59	192947.0
2012-11-16	ADRE	ETF	37.49	37.49	37.05	37.44	33467.0
2012-11-16	AFK	ETF	30.73	30.88	30.5201	30.88	44059.0
2012-11-16	AGEM	ETF	21.72	21.72	21.42	21.534	2025.0
2012-11-16	AGG	ETF	112.2	112.3	112.15	112.21	981700.0
2012-11-16	AGQ	ETF	202.8	205.8	198.52	201.08	253350.0
2012-11-16	AGZ	ETF	113.927	114.05	113.91	113.9616	8462.0
2012-11-16	AIA	ETF	43.97	43.97	43.55	43.94	6339.0
2012-11-16	AIQ	ETF	5.85	6.1	5.7075	6.0	26737.0
2012-11-16	AIVI	ETF	38.44	38.44	37.92	38.33	40300.0
2012-11-16	AMJ	ETF	37.44	38.74	37.24	38.71	1983534.0
2012-11-16	AMLP	ETF	78.0	79.4	77.6	79.35	755440.0
2012-11-16	ANGL	ETF	26.5	26.5	26.29	26.45	48600.0
2012-11-16	AOA	ETF	35.33	35.43	35.09	35.41	14700.0
2012-11-16	AOK	ETF	30.15	30.17	30.06	30.14	29703.0
2012-11-16	AOM	ETF	31.02	31.08	30.9499	31.07	27840.0
2012-11-16	AOR	ETF	32.78	32.86	32.66	32.84	11591.0
2012-11-16	ARB	ETF	34.98	35.77	34.73	35.59	169776.0
2012-11-16	ARGT	ETF	15.2	15.2	15.2	15.2	3500.0
2012-11-16	ASEA	ETF	16.28	16.36	16.21	16.36	3000.0
2012-11-16	AWAY	ETF	21.12	21.55	20.75	21.37	808070.0
2012-11-16	BAB	ETF	30.49	30.59	30.42	30.59	153626.0
2012-11-16	BAL	ETF	46.9301	47.35	46.9	47.21	7600.0
2012-11-16	BALT	ETF	2.97	2.97	2.86	2.89	137545.0
2012-11-16	BBH	ETF	50.98	52.3	50.98	52.11	21100.0
2012-11-16	BCM	ETF	43.5967	43.84	43.5967	43.84	1487.0
2012-11-16	BIB	ETF	12.6875	13.4225	12.4975	13.315	58020.0
2012-11-16	BICK	ETF	22.93	22.9699	22.78	22.9399	2160.0
2012-11-16	BIL	ETF	91.62	91.64	91.62	91.64	148600.0
2012-11-16	BIS	ETF	3034.0	3034.8	2903.6	2905.6	185.0
2012-11-16	BIV	ETF	90.49	90.55	90.4	90.51	234500.0
2012-11-16	BJK	ETF	34.01	34.01	33.48	33.7	6000.0
2012-11-16	BKF	ETF	37.08	37.09	36.67	37.03	77419.0
2012-11-16	BKLN	ETF	24.48	24.56	24.45	24.53	672800.0
2012-11-16	BLV	ETF	97.6	98.0	97.54	97.65	56100.0
2012-11-16	BMVP	ETF	15.2	15.32	15.13	15.32	10639.0
2012-11-16	BND	ETF	84.98	85.05	84.92	84.95	1151500.0
2012-11-16	BNO	ETF	39.835	39.97	39.52	39.97	151000.0
2012-11-16	BOIL	ETF	1065400.0	1100600.0	1059600.0	1094800.0	6.8
2012-11-16	BOND	ETF	109.98	110.099	109.96	110.04	318420.0

> showing 50 of 951 rows — these rows as CSV

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