PREVIEW / etf_daily / 2010-05-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-28.parquet
  size:    32 KB
  rows:    745

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-28	SPY	ETF	110.64	110.72	108.85	109.37	297933500.0
2010-05-28	QQQ	ETF	45.94	45.99	45.2	45.6	128535258.0
2010-05-28	IWM	ETF	66.91	67.17	65.73	66.25	92369800.0
2010-05-28	DIA	ETF	102.59	102.63	101.04	101.47	19442500.0
2010-05-28	GLD	ETF	118.48	118.9	117.63	118.88	11579400.0
2010-05-28	TLT	ETF	96.49	96.78	96.02	96.5	5805500.0
2010-05-28	AAXJ	ETF	53.92	53.92	51.96	52.27	316800.0
2010-05-28	ACWI	ETF	39.7	39.84	39.21	39.34	259300.0
2010-05-28	ACWX	ETF	36.9	37.028	36.33	36.54	229151.0
2010-05-28	ADRE	ETF	40.0	40.1	39.42	39.74	108425.0
2010-05-28	AFK	ETF	29.03	29.04	28.34	28.8985	7446.0
2010-05-28	AGG	ETF	105.58	105.81	105.57	105.71	658900.0
2010-05-28	AGQ	ETF	124.64	124.94	122.3	124.18	128200.0
2010-05-28	AGZ	ETF	109.21	109.45	109.025	109.45	25040.0
2010-05-28	AIA	ETF	37.16	37.23	36.79	36.82	48987.0
2010-05-28	AIQ	ETF	27.65	28.05	26.95	27.8	18557.0
2010-05-28	AIS	ETF	1.62	1.67	1.59	1.66	436727.0
2010-05-28	AIVI	ETF	37.93	37.97	37.36	37.6	13400.0
2010-05-28	AMJ	ETF	29.44	29.55	29.05	29.25	398415.0
2010-05-28	AOA	ETF	29.62	29.67	29.39	29.39	6200.0
2010-05-28	AOK	ETF	27.5401	27.6	27.5025	27.59	8301.0
2010-05-28	AOM	ETF	28.08	28.08	27.92	27.96	9524.0
2010-05-28	AOR	ETF	29.5	30.2	28.493	28.51	9710.0
2010-05-28	ARB	ETF	30.72	30.93	30.41	30.46	176783.0
2010-05-28	BAB	ETF	25.79	25.9	25.79	25.83	142068.0
2010-05-28	BAL	ETF	38.0	38.0	37.795	37.795	417.0
2010-05-28	BALT	ETF	12.6	12.67	12.2	12.49	77120.0
2010-05-28	BBH	ETF	29.4167	29.5067	29.2467	29.2733	190500.0
2010-05-28	BICK	ETF	27.2	27.32	26.95	27.295	5355.0
2010-05-28	BIL	ETF	91.72	91.72	91.7	91.72	280750.0
2010-05-28	BITS	ETF	29.08	29.32	28.0	28.44	600.0
2010-05-28	BIV	ETF	82.0	82.16	81.85	82.06	134100.0
2010-05-28	BJK	ETF	24.21	24.21	23.79	24.02	1900.0
2010-05-28	BKF	ETF	41.32	41.74	41.0	41.34	142088.0
2010-05-28	BLV	ETF	79.76	79.79	79.4	79.67	24500.0
2010-05-28	BMVP	ETF	12.64	12.64	12.44	12.49	14503.0
2010-05-28	BND	ETF	80.35	80.5	80.3	80.46	511900.0
2010-05-28	BNE	ETF	11.04	11.09	11.01	11.07	401962.0
2010-05-28	BRF	ETF	42.42	42.8225	41.88	42.64	277155.0
2010-05-28	BSV	ETF	80.32	80.56	80.32	80.37	381600.0
2010-05-28	BTF	ETF	66.35	66.35	65.25	65.25	3986.4
2010-05-28	BWX	ETF	26.35	26.73	26.35	26.57	191480.0
2010-05-28	BWZ	ETF	32.29	33.62	32.29	33.56	33630.0
2010-05-28	BZQ	ETF	4417.6	4510.4	4318.4	4403.2	1727.0
2010-05-28	CEF	ETF	14.91	15.04	14.8	15.04	980200.0
2010-05-28	CEW	ETF	21.5	21.5	21.37	21.45	135089.0
2010-05-28	CGO	ETF	13.29	13.29	13.06	13.25	15498.0
2010-05-28	CGW	ETF	16.95	16.95	16.58	16.6612	29206.0
2010-05-28	CHI	ETF	11.81	11.9	11.67	11.81	260987.0
2010-05-28	CHIE	ETF	13.17	13.26	13.17	13.26	200.0

> showing 50 of 745 rows — these rows as CSV

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