PREVIEW / etf_daily / 2012-02-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-21.parquet
  size:    38 KB
  rows:    918

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-02-21	SPY	ETF	136.73	137.05	136.05	136.47	134042300.0
2012-02-21	QQQ	ETF	63.51	63.89	63.21	63.61	38141236.0
2012-02-21	IWM	ETF	82.92	83.04	81.83	82.23	39889400.0
2012-02-21	DIA	ETF	129.62	129.75	128.96	129.35	6589200.0
2012-02-21	GLD	ETF	169.65	171.07	169.59	171.02	13611200.0
2012-02-21	TLT	ETF	115.77	115.92	114.95	115.29	8338300.0
2012-02-21	AAXJ	ETF	57.79	57.98	57.49	57.67	200000.0
2012-02-21	ACTV	ETF	16.15	16.15	15.88	15.97	289251.0
2012-02-21	ACWI	ETF	46.56	46.63	46.25	46.39	708000.0
2012-02-21	ACWX	ETF	40.95	41.06	40.7278	40.83	126887.0
2012-02-21	ADRE	ETF	43.91	43.91	43.38	43.44	64902.0
2012-02-21	AFK	ETF	29.41	29.62	29.41	29.4545	14482.0
2012-02-21	AGEM	ETF	23.9427	24.06	23.9427	24.06	1315.0
2012-02-21	AGG	ETF	110.27	110.32	110.16	110.17	1043800.0
2012-02-21	AGQ	ETF	244.44	252.8	243.4	251.24	653300.0
2012-02-21	AGZ	ETF	112.67	112.846	112.62	112.62	19370.0
2012-02-21	AIA	ETF	45.23	45.239	44.78	44.91	13421.0
2012-02-21	AIQ	ETF	7.1	7.15	6.8	7.0	14951.0
2012-02-21	AIS	ETF	2.54	2.67	2.54	2.63	1073313.0
2012-02-21	AIVI	ETF	42.12	42.29	41.96	42.07	110300.0
2012-02-21	AMJ	ETF	41.5	41.6	41.22	41.42	2229573.0
2012-02-21	AMLP	ETF	85.55	85.75	85.3	85.55	563960.0
2012-02-21	AOA	ETF	35.98	36.03	35.81	35.85	16700.0
2012-02-21	AOK	ETF	30.05	30.1099	30.01	30.02	35560.0
2012-02-21	AOM	ETF	31.09	31.109	30.9804	31.0	8725.0
2012-02-21	AOR	ETF	33.03	33.04	32.904	32.94	25822.0
2012-02-21	ARB	ETF	35.59	35.67	34.28	34.45	242452.0
2012-02-21	ARGT	ETF	23.74	23.74	23.66	23.66	350.0
2012-02-21	ASEA	ETF	16.19	16.19	16.02	16.05	11600.0
2012-02-21	AWAY	ETF	26.0	26.51	24.86	25.51	406100.0
2012-02-21	BAB	ETF	29.11	29.15	29.0	29.1	152467.0
2012-02-21	BAL	ETF	56.82	57.0692	56.55	56.65	7109.0
2012-02-21	BALT	ETF	4.51	4.51	4.36	4.4	133602.0
2012-02-21	BBH	ETF	42.42	42.59	41.69	41.75	240800.0
2012-02-21	BIB	ETF	11.2387	11.2387	10.6925	10.7538	270288.0
2012-02-21	BICK	ETF	28.26	28.3	28.0	28.06	16489.0
2012-02-21	BIL	ETF	91.64	91.66	91.64	91.64	154750.0
2012-02-21	BIS	ETF	4000.0	4148.8	4000.0	4129.6	34.6
2012-02-21	BITS	ETF	22.0	22.0	21.24	21.88	998.0
2012-02-21	BIV	ETF	87.5	87.5	87.25	87.38	265900.0
2012-02-21	BJK	ETF	34.55	34.59	34.21	34.28	2900.0
2012-02-21	BKF	ETF	43.52	43.53	43.2	43.29	213252.0
2012-02-21	BKLN	ETF	24.5	24.5	24.39	24.45	130800.0
2012-02-21	BLNG	ETF	53.7645	53.7645	53.7645	53.7645	175.0
2012-02-21	BLV	ETF	90.54	90.62	90.09	90.26	82000.0
2012-02-21	BMVP	ETF	15.317	15.374	15.277	15.277	2736.0
2012-02-21	BND	ETF	83.53	83.54	83.44	83.46	900400.0
2012-02-21	BNO	ETF	42.025	42.53	41.9	42.285	318600.0
2012-02-21	BOIL	ETF	1394000.0	1416000.0	1341000.0	1416000.0	5.0
2012-02-21	BRF	ETF	46.32	46.652	46.2301	46.38	277252.0

> showing 50 of 918 rows — these rows as CSV

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