PREVIEW / etf_daily / 2012-12-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-11.parquet
  size:    40 KB
  rows:    963

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-11	SPY	ETF	143.06	144.11	142.99	143.44	152570400.0
2012-12-11	QQQ	ETF	65.58	66.34	65.515	65.97	40750801.0
2012-12-11	IWM	ETF	83.11	83.56	82.92	83.41	40262100.0
2012-12-11	DIA	ETF	132.21	133.12	132.18	132.5	4012700.0
2012-12-11	GLD	ETF	165.45	165.66	165.12	165.65	4724000.0
2012-12-11	TLT	ETF	124.26	124.31	123.83	124.03	3777900.0
2012-12-11	AADR	ETF	31.01	31.01	30.92	30.92	200.0
2012-12-11	AAXJ	ETF	59.55	59.79	59.4	59.66	370900.0
2012-12-11	ACTV	ETF	4.82	4.98	4.74	4.95	626785.0
2012-12-11	ACWI	ETF	47.7	48.05	47.7	47.92	481800.0
2012-12-11	ACWV	ETF	57.25	57.3	56.98	57.11	79700.0
2012-12-11	ACWX	ETF	41.1	41.38	41.1	41.27	326660.0
2012-12-11	ADRE	ETF	39.28	39.49	39.17	39.47	63267.0
2012-12-11	AFK	ETF	30.8	30.95	30.71	30.74	20744.0
2012-12-11	AGEM	ETF	23.04	23.0763	23.04	23.0763	775.0
2012-12-11	AGG	ETF	111.6	111.65	111.55	111.64	814100.0
2012-12-11	AGQ	ETF	208.8	209.56	206.92	209.2	205725.0
2012-12-11	AGZ	ETF	113.78	113.83	113.6	113.6	19452.0
2012-12-11	AIA	ETF	47.38	47.76	47.38	47.67	56969.0
2012-12-11	AIQ	ETF	6.4	6.5	6.3	6.5	7547.0
2012-12-11	AIVI	ETF	41.04	41.28	41.01	41.24	68900.0
2012-12-11	AMJ	ETF	38.77	38.77	38.43	38.66	697342.0
2012-12-11	AMLP	ETF	80.2	80.5	79.6	79.95	507920.0
2012-12-11	ANGL	ETF	27.25	27.25	27.15	27.23	4600.0
2012-12-11	AOA	ETF	37.08	37.25	37.08	37.14	9500.0
2012-12-11	AOK	ETF	30.6	30.6799	30.6	30.66	25035.0
2012-12-11	AOM	ETF	31.87	31.909	31.85	31.85	15196.0
2012-12-11	AOR	ETF	34.02	34.0799	33.9701	33.9701	3403.0
2012-12-11	ARB	ETF	38.07	38.45	37.71	38.24	210211.0
2012-12-11	ARGT	ETF	16.9	17.06	16.9	17.06	1750.0
2012-12-11	ASEA	ETF	16.94	17.1	16.94	17.06	21500.0
2012-12-11	AWAY	ETF	20.02	20.47	19.88	20.44	585560.0
2012-12-11	BAB	ETF	30.57	30.59	30.5	30.56	182228.0
2012-12-11	BAL	ETF	48.22	48.91	48.22	48.78	14445.0
2012-12-11	BALT	ETF	2.74	2.81	2.7	2.77	68610.0
2012-12-11	BBH	ETF	55.07	55.9	55.07	55.81	48400.0
2012-12-11	BCM	ETF	44.4	44.4	44.3999	44.3999	414.0
2012-12-11	BIB	ETF	15.0725	15.3963	15.0705	15.3475	234120.0
2012-12-11	BICK	ETF	24.65	24.7148	24.55	24.67	4336.0
2012-12-11	BIL	ETF	91.62	91.64	91.62	91.62	308800.0
2012-12-11	BIS	ETF	2564.796	2564.8	2512.0	2526.4	777.5
2012-12-11	BIV	ETF	90.39	90.4	90.3	90.36	567400.0
2012-12-11	BJK	ETF	35.85	35.9	35.73	35.73	2600.0
2012-12-11	BKF	ETF	39.61	39.81	39.39	39.68	235467.0
2012-12-11	BKLN	ETF	24.93	24.96	24.89	24.96	457500.0
2012-12-11	BLV	ETF	96.65	96.73	96.39	96.51	178500.0
2012-12-11	BMVP	ETF	16.3034	16.3867	16.3034	16.36	15399.0
2012-12-11	BND	ETF	84.73	84.83	84.73	84.79	2083600.0
2012-12-11	BNO	ETF	39.295	39.445	39.205	39.43	9800.0
2012-12-11	BOIL	ETF	848400.0	855200.0	818400.0	828600.0	12.4

> showing 50 of 963 rows — these rows as CSV

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