PREVIEW / etf_daily / 2010-04-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-27.parquet
  size:    33 KB
  rows:    755

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
2010-04-27	SPY	ETF	120.65	121.34	118.25	118.48	355853300.0
2010-04-27	QQQ	ETF	50.22	50.43	49.21	49.34	112607970.0
2010-04-27	IWM	ETF	73.55	74.24	72.02	72.16	101050200.0
2010-04-27	DIA	ETF	111.76	112.18	109.73	109.87	19874600.0
2010-04-27	GLD	ETF	112.43	114.82	112.34	114.63	25057100.0
2010-04-27	TLT	ETF	90.85	91.92	90.7	91.48	13199200.0
2010-04-27	AAXJ	ETF	57.91	57.91	56.54	56.7	330700.0
2010-04-27	ACWI	ETF	44.4	44.5	43.22	43.42	273800.0
2010-04-27	ACWX	ETF	41.82	41.99	40.56	40.69	105036.0
2010-04-27	ADRE	ETF	44.51	44.51	43.24	43.3	243150.0
2010-04-27	AFK	ETF	32.1	32.11	31.2	31.58	23848.0
2010-04-27	AGG	ETF	104.37	104.72	104.35	104.56	950900.0
2010-04-27	AGQ	ETF	123.8	127.18	122.56	124.46	192400.0
2010-04-27	AGZ	ETF	108.25	108.42	108.0501	108.26	24584.0
2010-04-27	AIA	ETF	41.22	41.51	40.4036	40.62	28359.0
2010-04-27	AIQ	ETF	27.9	28.1	26.95	27.1	25226.0
2010-04-27	AIS	ETF	1.6	1.62	1.56	1.59	519470.0
2010-04-27	AIVI	ETF	42.94	43.05	41.53	41.57	36000.0
2010-04-27	AMJ	ETF	31.75	31.98	31.19	31.38	1043649.0
2010-04-27	AOA	ETF	32.45	32.61	31.81	31.81	51900.0
2010-04-27	AOK	ETF	28.09	28.13	28.0401	28.074	5765.0
2010-04-27	AOM	ETF	29.12	29.15	28.94	28.94	6667.0
2010-04-27	AOR	ETF	30.25	30.47	29.96	29.96	74307.0
2010-04-27	ARB	ETF	31.74	32.19	31.49	31.89	256835.0
2010-04-27	BAB	ETF	25.35	25.61	25.35	25.54	151947.0
2010-04-27	BAL	ETF	40.5	40.5	40.09	40.35	6816.0
2010-04-27	BALT	ETF	14.13	14.5	13.87	14.12	662703.0
2010-04-27	BBH	ETF	32.4767	32.9367	32.38	32.3867	219900.0
2010-04-27	BIB	ETF	7.27	7.3587	7.0012	7.0012	13728.0
2010-04-27	BICK	ETF	29.91	30.04	29.462	29.462	24922.0
2010-04-27	BIL	ETF	91.68	91.7	91.68	91.68	579550.0
2010-04-27	BIS	ETF	9921.6	10175.76	9803.2	10175.76	11.9
2010-04-27	BITS	ETF	31.9996	31.9996	31.4	31.52	461.0
2010-04-27	BIV	ETF	80.68	81.0	80.55	80.99	438700.0
2010-04-27	BJK	ETF	27.28	27.46	26.52	26.52	9900.0
2010-04-27	BKF	ETF	46.4	46.48	44.95	44.98	286813.0
2010-04-27	BLV	ETF	77.98	78.54	77.79	78.23	38600.0
2010-04-27	BMVP	ETF	13.83	13.85	13.54	13.54	24502.0
2010-04-27	BND	ETF	79.45	79.65	79.4	79.59	598500.0
2010-04-27	BNE	ETF	11.23	11.26	11.16	11.17	822318.0
2010-04-27	BRF	ETF	46.01	46.2	44.77	45.08	444170.0
2010-04-27	BSV	ETF	80.03	80.17	79.95	80.15	475700.0
2010-04-27	BTF	ETF	74.4	74.74999999999999	73.1	73.15	8805.2
2010-04-27	BWX	ETF	27.585	27.5955	27.415	27.425	288710.0
2010-04-27	BWZ	ETF	35.2	35.26	35.01	35.01	26548.0
2010-04-27	BZQ	ETF	3664.0	3912.0	3654.4	3912.0	941.0
2010-04-27	CEF	ETF	14.48	14.66	14.37	14.56	1264700.0
2010-04-27	CEW	ETF	22.2	22.38	22.16	22.16	383309.0
2010-04-27	CGO	ETF	14.93	15.01	14.8	14.8	28343.0
2010-04-27	CGW	ETF	18.79	18.79	18.24	18.27	73232.0

> showing 50 of 755 rows — these rows as CSV

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