PREVIEW / etf_daily / 2012-04-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-17.parquet
  size:    38 KB
  rows:    921

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-04-17	SPY	ETF	137.84	139.36	137.7	139.08	147877600.0
2012-04-17	QQQ	ETF	65.75	66.99	65.63	66.78	47362395.0
2012-04-17	IWM	ETF	80.33	81.55	80.27	80.82	46737700.0
2012-04-17	DIA	ETF	129.83	131.13	129.81	130.94	6290900.0
2012-04-17	GLD	ETF	160.54	160.96	158.75	160.25	7587100.0
2012-04-17	TLT	ETF	116.53	116.83	116.25	116.6	5398600.0
2012-04-17	AADR	ETF	30.63	30.67	30.63	30.67	400.0
2012-04-17	AAXJ	ETF	56.08	56.46	55.76	56.3	357700.0
2012-04-17	ACTV	ETF	16.76	17.02	16.76	16.9	321606.0
2012-04-17	ACWI	ETF	46.14	46.56	45.96	46.44	708100.0
2012-04-17	ACWV	ETF	53.75	53.75	53.75	53.75	800.0
2012-04-17	ACWX	ETF	39.86	40.11	39.68	40.03	300375.0
2012-04-17	ADRE	ETF	41.22	41.4799	41.1501	41.34	16253.0
2012-04-17	AFK	ETF	28.53	28.82	28.53	28.75	24177.0
2012-04-17	AGEM	ETF	22.71	22.8725	22.71	22.8725	1874.0
2012-04-17	AGG	ETF	110.3	110.4	110.25	110.4	737600.0
2012-04-17	AGQ	ETF	209.84	211.28	204.24	208.68	309750.0
2012-04-17	AGZ	ETF	112.89	112.89	112.6	112.61	13827.0
2012-04-17	AIA	ETF	44.3	44.61	44.12	44.53	13491.0
2012-04-17	AIQ	ETF	7.45	7.55	7.15	7.25	15578.0
2012-04-17	AIS	ETF	3.03	3.05	2.98	2.99	672207.0
2012-04-17	AIVI	ETF	40.13	40.45	40.01	40.39	53100.0
2012-04-17	AMJ	ETF	38.7	38.98	38.7	38.89	1385880.0
2012-04-17	AMLP	ETF	82.3	82.75	82.2	82.55	392980.0
2012-04-17	ANGL	ETF	25.5	25.55	25.5	25.55	1600.0
2012-04-17	AOA	ETF	35.81	36.07	35.79	36.06	20300.0
2012-04-17	AOK	ETF	29.98	30.12	29.98	30.11	17209.0
2012-04-17	AOM	ETF	31.02	31.1597	31.009	31.11	77834.0
2012-04-17	AOR	ETF	32.94	33.17	32.9305	33.07	10367.0
2012-04-17	ARB	ETF	38.32	38.82	38.048	38.65	184314.0
2012-04-17	ARGT	ETF	19.42	19.42	19.3	19.3	1150.0
2012-04-17	ASEA	ETF	16.07	16.23	16.01	16.16	1900.0
2012-04-17	AWAY	ETF	24.1	24.74	23.99	24.47	192392.0
2012-04-17	BAB	ETF	29.38	29.55	29.2683	29.54	385325.0
2012-04-17	BAL	ETF	55.5	55.5	54.72	55.0	23932.0
2012-04-17	BALT	ETF	4.16	4.36	4.16	4.33	120613.0
2012-04-17	BBH	ETF	42.51	43.2	42.51	43.04	229100.0
2012-04-17	BCM	ETF	44.483	44.58	44.48	44.48	331.0
2012-04-17	BIB	ETF	11.0075	11.353	11.0075	11.2562	21376.0
2012-04-17	BICK	ETF	25.76	26.03	25.71	25.936	5123.0
2012-04-17	BIL	ETF	91.64	91.66	91.64	91.64	174500.0
2012-04-17	BIS	ETF	3980.8	3980.8	3824.0	3824.0	22.2
2012-04-17	BIV	ETF	87.48	87.56	87.37	87.55	373200.0
2012-04-17	BJK	ETF	36.0	36.35	36.0	36.22	6300.0
2012-04-17	BKF	ETF	40.32	40.69	40.22	40.57	100210.0
2012-04-17	BKLN	ETF	24.4	24.46	24.4	24.4	131300.0
2012-04-17	BLV	ETF	90.78	90.95	90.63	90.89	25300.0
2012-04-17	BMVP	ETF	15.22	15.42	15.22	15.41	3404.0
2012-04-17	BND	ETF	83.72	83.72	83.61	83.7	838200.0
2012-04-17	BNO	ETF	41.86	42.015	41.715	41.85	38800.0

> showing 50 of 921 rows — these rows as CSV

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