PREVIEW / etf_daily / 2010-06-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-09.parquet
  size:    32 KB
  rows:    757

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-06-09	SPY	ETF	107.24	108.28	105.6	106.05	268023300.0
2010-06-09	QQQ	ETF	44.48	44.91	43.69	43.82	102077323.0
2010-06-09	IWM	ETF	62.37	63.42	61.59	61.93	108638000.0
2010-06-09	DIA	ETF	99.98	100.78	98.8	99.15	16076800.0
2010-06-09	GLD	ETF	120.48	120.99	119.51	120.56	12884600.0
2010-06-09	TLT	ETF	97.6	98.12	97.21	97.94	5598000.0
2010-06-09	AAXJ	ETF	52.88	52.88	51.06	51.34	226300.0
2010-06-09	ACWI	ETF	38.9	39.08	38.13	38.35	351900.0
2010-06-09	ACWX	ETF	36.0	36.21	35.31	35.34	55438.0
2010-06-09	ADRE	ETF	39.59	40.24	39.25	39.41	78758.0
2010-06-09	AFK	ETF	28.25	28.712	27.67	27.74	5107.0
2010-06-09	AGG	ETF	105.8	105.96	105.67	105.92	539000.0
2010-06-09	AGQ	ETF	122.22	123.18	119.6	119.84	127300.0
2010-06-09	AGZ	ETF	109.38	109.56	109.38	109.56	5785.0
2010-06-09	AIA	ETF	36.67	36.94	36.1901	36.3199	24482.0
2010-06-09	AIQ	ETF	24.4	24.6	24.0	24.1	22515.0
2010-06-09	AIS	ETF	1.75	1.83	1.73	1.79	1385408.0
2010-06-09	AIVI	ETF	36.71	37.22	36.4	36.5	9200.0
2010-06-09	AMJ	ETF	29.75	29.75	29.1	29.245	354810.0
2010-06-09	AOA	ETF	28.56	28.85	28.36	28.36	9300.0
2010-06-09	AOK	ETF	27.3854	27.41	27.2999	27.2999	8328.0
2010-06-09	AOM	ETF	27.65	27.8084	27.619	27.619	17340.0
2010-06-09	AOR	ETF	28.13	28.27	27.944	27.944	4150.0
2010-06-09	ARB	ETF	27.69	29.62	27.69	28.14	290847.0
2010-06-09	BAB	ETF	26.0	26.12	25.958	26.11	189093.0
2010-06-09	BAL	ETF	37.66	38.285	37.66	38.285	15670.0
2010-06-09	BALT	ETF	12.0	12.47	11.845	11.95	722227.0
2010-06-09	BBH	ETF	29.0033	29.13	28.69	28.7433	208500.0
2010-06-09	BIB	ETF	5.3725	5.4517	5.2675	5.2675	27200.0
2010-06-09	BICK	ETF	26.61	26.97	26.415	26.415	14020.0
2010-06-09	BIL	ETF	91.74	91.74	91.72	91.74	163950.0
2010-06-09	BIS	ETF	12491.2	12824.0	12387.2	12824.0	21.0
2010-06-09	BITS	ETF	27.44	27.68	27.2	27.4	1075.0
2010-06-09	BIV	ETF	82.1	82.35	81.96	82.32	165500.0
2010-06-09	BJK	ETF	23.48	23.8	23.23	23.23	13500.0
2010-06-09	BKF	ETF	40.83	41.57	40.48	40.76	144861.0
2010-06-09	BLV	ETF	80.25	80.31	79.73	80.22	42800.0
2010-06-09	BMVP	ETF	11.9833	12.1681	11.9033	11.94	46807.0
2010-06-09	BND	ETF	80.46	80.59	80.36	80.56	446300.0
2010-06-09	BNE	ETF	11.05	11.1	11.02	11.1	793165.0
2010-06-09	BNO	ETF	25.38	25.515	25.29	25.33	17400.0
2010-06-09	BRF	ETF	42.71	42.91	41.78	41.91	238088.0
2010-06-09	BSCE	ETF	20.17	20.18	20.17	20.18	1900.0
2010-06-09	BSV	ETF	80.42	80.49	80.4	80.49	722500.0
2010-06-09	BTF	ETF	64.25	64.85	63.647499999999994	63.699999999999996	3428.8
2010-06-09	BWX	ETF	26.315	26.435	26.315	26.325	83358.0
2010-06-09	BWZ	ETF	32.57	33.1899	32.57	33.105	10636.0
2010-06-09	BZQ	ETF	4336.0	4510.4	4249.6	4484.8	1499.5
2010-06-09	CEF	ETF	14.95	15.03	14.74	14.83	1387200.0
2010-06-09	CEW	ETF	21.05	21.12	20.981	21.02	282829.0

> showing 50 of 757 rows — these rows as CSV

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