PREVIEW / etf_daily / 2012-12-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-28.parquet
  size:    40 KB
  rows:    976

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-28	SPY	ETF	140.64	141.42	139.87	140.03	148806700.0
2012-12-28	QQQ	ETF	63.93	64.43	63.75	63.78	33082054.0
2012-12-28	IWM	ETF	82.69	83.37	82.52	82.53	34262200.0
2012-12-28	DIA	ETF	129.82	130.45	128.97	129.07	8570000.0
2012-12-28	GLD	ETF	160.94	160.97	160.15	160.54	6852900.0
2012-12-28	TLT	ETF	123.14	123.34	122.78	123.31	3928200.0
2012-12-28	AADR	ETF	30.89	30.96	30.89	30.96	300.0
2012-12-28	AAXJ	ETF	59.24	59.78	59.24	59.61	2651600.0
2012-12-28	ACTV	ETF	4.7	4.9	4.65	4.8	1485133.0
2012-12-28	ACWI	ETF	47.55	47.67	47.33	47.36	1011100.0
2012-12-28	ACWV	ETF	55.3	55.44	54.63	55.23	35800.0
2012-12-28	ACWX	ETF	41.53	41.61	41.31	41.38	316055.0
2012-12-28	ADRE	ETF	39.29	39.8	39.29	39.72	74417.0
2012-12-28	AFK	ETF	30.66	31.0	30.65	30.79	21208.0
2012-12-28	AGEM	ETF	23.08	23.1765	23.06	23.16	1868.0
2012-12-28	AGG	ETF	111.29	111.3	111.15	111.28	1295800.0
2012-12-28	AGQ	ETF	173.24	173.8	171.2	173.28	196375.0
2012-12-28	AGZ	ETF	113.37	113.54	113.37	113.53	7878.0
2012-12-28	AIA	ETF	47.3	47.61	47.3	47.47	19499.0
2012-12-28	AIQ	ETF	6.52	6.52	6.22	6.35	23355.0
2012-12-28	AIVI	ETF	41.24	41.38	41.1	41.18	29000.0
2012-12-28	AMJ	ETF	37.61	38.1	37.6	37.92	849563.0
2012-12-28	AMLP	ETF	78.8	79.35	78.7	79.05	505000.0
2012-12-28	ANGL	ETF	26.83	26.83	26.81	26.81	1100.0
2012-12-28	AOA	ETF	36.85	36.89	36.68	36.74	40500.0
2012-12-28	AOK	ETF	30.54	30.54	30.4701	30.485	21818.0
2012-12-28	AOM	ETF	31.63	31.6499	31.52	31.52	16361.0
2012-12-28	AOR	ETF	33.78	33.79	33.6	33.65	29068.0
2012-12-28	ARB	ETF	46.45	46.7	46.45	46.65	682104.0
2012-12-28	ARGT	ETF	17.14	17.18	16.92	16.92	3700.0
2012-12-28	ASEA	ETF	16.69	16.83	16.69	16.76	37100.0
2012-12-28	AWAY	ETF	21.2	21.7136	21.03	21.31	229156.0
2012-12-28	BAB	ETF	30.57	30.6	30.46	30.5353	200112.0
2012-12-28	BAL	ETF	49.36	49.36	48.7	48.83	9968.0
2012-12-28	BALT	ETF	2.95	2.96	2.85	2.93	167679.0
2012-12-28	BBH	ETF	53.01	53.35	52.8	52.8	175100.0
2012-12-28	BCM	ETF	43.75	43.78	43.691	43.698	10631.0
2012-12-28	BIB	ETF	13.9525	14.2925	13.9325	14.05	54424.0
2012-12-28	BICK	ETF	25.01	25.074	24.99	24.99	15105.0
2012-12-28	BIL	ETF	91.62	91.64	91.62	91.64	213250.0
2012-12-28	BIS	ETF	2718.4	2752.4	2699.996	2752.4	282.0
2012-12-28	BIV	ETF	88.56	88.59	88.45	88.59	264400.0
2012-12-28	BJK	ETF	35.16	35.35	35.11	35.11	4200.0
2012-12-28	BKF	ETF	40.04	40.41	40.04	40.28	63045.0
2012-12-28	BKLN	ETF	24.92	24.93	24.92	24.93	759400.0
2012-12-28	BLV	ETF	94.45	94.75	94.3	94.72	46400.0
2012-12-28	BMVP	ETF	16.013	16.09	15.971	15.98	8881.0
2012-12-28	BND	ETF	84.15	84.16	84.04	84.11	1627500.0
2012-12-28	BNO	ETF	40.845	40.845	40.56	40.83	42400.0
2012-12-28	BOIL	ETF	844400.0	845600.0	812000.0	832600.0	7.2

> showing 50 of 976 rows — these rows as CSV

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