PREVIEW / etf_daily / 2010-07-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-16.parquet
  size:    33 KB
  rows:    765

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-07-16	SPY	ETF	109.09	109.21	106.45	106.66	282693400.0
2010-07-16	QQQ	ETF	45.44	45.6281	44.3	44.34	98831860.0
2010-07-16	IWM	ETF	62.91	63.04	60.89	61.07	98127500.0
2010-07-16	DIA	ETF	103.01	103.11	100.83	101.01	12219700.0
2010-07-16	GLD	ETF	116.69	116.79	115.95	116.67	17494400.0
2010-07-16	TLT	ETF	100.31	101.13	100.27	100.8	7512400.0
2010-07-16	AAXJ	ETF	54.08	54.12	53.2	53.28	129600.0
2010-07-16	ACWI	ETF	40.23	40.23	39.28	39.38	117900.0
2010-07-16	ACWX	ETF	37.83	37.83	36.98	37.04	41014.0
2010-07-16	ADRE	ETF	40.37	40.49	39.72	39.72	251199.0
2010-07-16	AFK	ETF	29.0	29.0	28.6	28.77	17713.0
2010-07-16	AGG	ETF	107.29	107.49	107.2	107.43	386100.0
2010-07-16	AGQ	ETF	115.64	115.64	113.0	114.7	232850.0
2010-07-16	AGZ	ETF	110.38	110.51	110.37	110.45	12838.0
2010-07-16	AIA	ETF	38.08	38.21	37.6	37.62	26626.0
2010-07-16	AIQ	ETF	20.95	21.0	19.9	20.2	35115.0
2010-07-16	AIS	ETF	1.6	1.65	1.57	1.58	461630.0
2010-07-16	AIVI	ETF	39.59	39.59	38.65	38.83	41300.0
2010-07-16	AMJ	ETF	32.45	32.5395	32.171	32.48	474427.0
2010-07-16	AOA	ETF	29.25	29.25	28.94	28.95	12500.0
2010-07-16	AOK	ETF	27.68	27.68	27.5092	27.5092	86714.0
2010-07-16	AOM	ETF	28.0	28.0	27.8777	27.8777	8378.0
2010-07-16	AOR	ETF	28.49	28.55	28.3	28.32	10687.0
2010-07-16	ARB	ETF	26.9	26.9	26.04	26.25	354868.0
2010-07-16	BAB	ETF	25.98	26.04	25.85	26.0	184219.0
2010-07-16	BAL	ETF	36.24	36.24	35.8	35.8	4180.0
2010-07-16	BALT	ETF	10.83	11.2	10.64	10.7	175863.0
2010-07-16	BBH	ETF	29.9933	30.1633	29.0367	29.06	107400.0
2010-07-16	BIB	ETF	5.31	5.31	5.31	5.31	800.0
2010-07-16	BICK	ETF	27.31	27.74	26.98	27.04	10395.0
2010-07-16	BIL	ETF	91.7	91.72	91.7	91.72	87750.0
2010-07-16	BIS	ETF	12590.4	12590.4	12590.4	12590.4	0.625
2010-07-16	BITS	ETF	27.9996	28.4	27.96	28.0	1075.0
2010-07-16	BIV	ETF	83.84	84.17	83.76	84.07	155000.0
2010-07-16	BJK	ETF	24.17	24.17	23.52	23.52	12300.0
2010-07-16	BKF	ETF	42.36	42.48	41.73	41.94	70708.0
2010-07-16	BLV	ETF	82.04	82.48	81.8	82.23	60100.0
2010-07-16	BMVP	ETF	12.28	12.28	11.99	12.01	25787.0
2010-07-16	BND	ETF	81.38	81.58	81.29	81.54	350800.0
2010-07-16	BNE	ETF	11.3	11.3	11.26	11.26	661611.0
2010-07-16	BNO	ETF	25.445	25.54	25.31	25.31	40800.0
2010-07-16	BRF	ETF	46.28	46.36	45.44	45.52	345616.0
2010-07-16	BSCE	ETF	20.56	20.61	20.56	20.61	5651.0
2010-07-16	BSV	ETF	81.06	81.17	81.04	81.14	635300.0
2010-07-16	BTF	ETF	68.25	68.25999999999999	67.455	67.55	8701.4
2010-07-16	BWX	ETF	27.95	27.98	27.92	27.96	192446.0
2010-07-16	BWZ	ETF	34.84	34.98	34.815	34.98	8448.0
2010-07-16	BZQ	ETF	3913.6	4086.4	3904.0	4075.2	1295.0
2010-07-16	CEF	ETF	14.6	14.67	14.5	14.53	858300.0
2010-07-16	CEW	ETF	21.6	21.6594	21.55	21.59	83664.0

> showing 50 of 765 rows — these rows as CSV

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