PREVIEW / etf_daily / 2010-05-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-07.parquet
  size:    33 KB
  rows:    758

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-05-07	SPY	ETF	112.64	113.77	109.41	111.26	637558800.0
2010-05-07	QQQ	ETF	46.22	46.8	44.2833	45.41	288200345.0
2010-05-07	IWM	ETF	66.71	67.62	64.64	65.36	189573100.0
2010-05-07	DIA	ETF	105.02	105.94	102.54	103.78	33885700.0
2010-05-07	GLD	ETF	117.64	118.88	116.74	118.27	34272700.0
2010-05-07	TLT	ETF	95.88	98.09	95.27	95.58	18740600.0
2010-05-07	AAXJ	ETF	52.46	53.66	51.9	52.9	1445000.0
2010-05-07	ACWI	ETF	40.72	40.82	39.16	39.75	625800.0
2010-05-07	ACWX	ETF	37.2	38.08	36.37	37.16	750369.0
2010-05-07	ADRE	ETF	40.43	40.7	38.91	40.13	298027.0
2010-05-07	AFK	ETF	29.59	30.11	28.42	30.11	62554.0
2010-05-07	AGG	ETF	105.1	105.5	104.4	104.41	1415400.0
2010-05-07	AGQ	ETF	116.92	129.32	113.64	125.66	513300.0
2010-05-07	AGZ	ETF	108.84	109.015	108.49	108.49	79324.0
2010-05-07	AIA	ETF	38.13	38.42	37.34	37.73	52641.0
2010-05-07	AIQ	ETF	25.65	25.65	24.0	24.45	93263.0
2010-05-07	AIS	ETF	1.55	1.6	1.53	1.53	552533.0
2010-05-07	AIVI	ETF	37.6	38.2	36.48	37.32	74300.0
2010-05-07	AMJ	ETF	28.75	29.2	28.17	29.16	1414555.0
2010-05-07	AOA	ETF	29.97	30.15	29.24	29.5	45500.0
2010-05-07	AOK	ETF	27.7	27.7	27.5	27.57	6081.0
2010-05-07	AOM	ETF	28.22	28.22	27.93	27.9528	68697.0
2010-05-07	AOR	ETF	29.01	29.04	28.4401	28.5716	26374.0
2010-05-07	ARB	ETF	30.61	30.61	28.71	28.99	311981.0
2010-05-07	BAB	ETF	26.25	26.43	25.9	25.988	281806.0
2010-05-07	BAL	ETF	38.1685	38.62	38.05	38.38	4990.0
2010-05-07	BALT	ETF	12.32	12.69	11.178	11.93	717584.0
2010-05-07	BBH	ETF	31.06	31.24	30.2733	30.82	134700.0
2010-05-07	BIB	ETF	6.6825	6.6825	5.94	6.0225	35584.0
2010-05-07	BICK	ETF	26.55	27.51	26.55	26.87	11173.0
2010-05-07	BIL	ETF	91.7	91.72	91.68	91.72	353300.0
2010-05-07	BIS	ETF	12400.0	12400.0	11145.6	11680.0	15.0
2010-05-07	BITS	ETF	30.8004	30.96	30.0	30.88	2810.0
2010-05-07	BIV	ETF	81.61	81.61	81.05	81.32	290200.0
2010-05-07	BJK	ETF	24.15	24.59	23.12	23.87	17000.0
2010-05-07	BKF	ETF	41.0	41.664	39.5	40.85	498049.0
2010-05-07	BLV	ETF	78.88	80.56	78.61	79.09	69100.0
2010-05-07	BMVP	ETF	12.703	12.763	12.463	12.513	42582.0
2010-05-07	BND	ETF	80.14	80.51	79.9	79.9	767500.0
2010-05-07	BNE	ETF	11.12	11.25	11.0	11.01	1521234.0
2010-05-07	BRF	ETF	41.78	42.34	40.038	41.1	643290.0
2010-05-07	BSV	ETF	80.21	80.45	80.17	80.34	643200.0
2010-05-07	BTF	ETF	67.39999999999999	68.0	66.14999999999999	67.258	8138.200000000001
2010-05-07	BWX	ETF	26.575	26.625	26.418	26.555	261358.0
2010-05-07	BWZ	ETF	33.56	33.9	32.8	33.64	91624.0
2010-05-07	BZQ	ETF	4587.2	4931.2	4396.8	4609.6	1159.5
2010-05-07	CEF	ETF	15.05	15.39	14.83	15.3	2191800.0
2010-05-07	CEW	ETF	21.51	21.584	21.32	21.47	299741.0
2010-05-07	CGO	ETF	13.06	13.49	13.02	13.26	45752.0
2010-05-07	CGW	ETF	16.93	17.09	16.4	16.68	489242.0

> showing 50 of 758 rows — these rows as CSV

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