PREVIEW / etf_daily / 2010-06-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-29.parquet
  size:    33 KB
  rows:    760

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-29	SPY	ETF	106.02	107.51	103.55	104.21	373649500.0
2010-06-29	QQQ	ETF	44.42	44.46	43.07	43.37	136384111.0
2010-06-29	IWM	ETF	63.22	63.22	61.38	61.83	110269700.0
2010-06-29	DIA	ETF	100.19	100.23	98.13	98.73	16662900.0
2010-06-29	GLD	ETF	121.05	121.82	120.02	121.27	17334700.0
2010-06-29	TLT	ETF	100.32	101.13	100.16	101.07	7334200.0
2010-06-29	AAXJ	ETF	52.81	52.95	52.04	52.2	835800.0
2010-06-29	ACWI	ETF	38.51	38.6	37.75	37.97	1763500.0
2010-06-29	ACWX	ETF	36.08	36.08	35.22	35.46	72263.0
2010-06-29	ADRE	ETF	40.0	40.19	39.17	39.33	149113.0
2010-06-29	AFK	ETF	28.5	28.5	27.75	27.96	13743.0
2010-06-29	AGG	ETF	107.17	107.26	106.98	107.24	469000.0
2010-06-29	AGQ	ETF	125.96	126.48	122.42	124.02	296100.0
2010-06-29	AGZ	ETF	110.24	110.31	110.105	110.27	12617.0
2010-06-29	AIA	ETF	37.15	37.58	36.77	36.8799	34755.0
2010-06-29	AIQ	ETF	21.35	21.35	20.35	20.45	38856.0
2010-06-29	AIS	ETF	1.85	1.86	1.73	1.74	1000657.0
2010-06-29	AIVI	ETF	36.55	36.56	35.95	36.02	72400.0
2010-06-29	AMJ	ETF	30.67	30.92	30.58	30.86	262707.0
2010-06-29	AOA	ETF	28.67	28.67	28.07	28.21	9600.0
2010-06-29	AOK	ETF	27.4401	27.48	27.38	27.39	7538.0
2010-06-29	AOM	ETF	27.74	27.74	27.53	27.55	5136.0
2010-06-29	AOR	ETF	28.0054	28.0054	27.75	27.84	5385.0
2010-06-29	ARB	ETF	27.13	27.14	25.58	25.75	208165.0
2010-06-29	BAB	ETF	26.11	26.18	26.02	26.18	208807.0
2010-06-29	BAL	ETF	38.0	38.0201	37.8001	37.97	1625.0
2010-06-29	BALT	ETF	11.52	11.6	11.17	11.33	181740.0
2010-06-29	BBH	ETF	30.0833	30.1667	29.5967	29.7433	141300.0
2010-06-29	BIB	ETF	5.5875	5.5875	5.3375	5.355	9200.0
2010-06-29	BICK	ETF	27.49	27.49	26.94	27.0	3413.0
2010-06-29	BIL	ETF	91.72	91.72	91.7	91.72	579550.0
2010-06-29	BIS	ETF	12188.784	12342.4	12188.784	12342.4	1.25
2010-06-29	BITS	ETF	27.2	27.24	26.72	26.72	2108.0
2010-06-29	BIV	ETF	83.46	83.63	83.4	83.6	237200.0
2010-06-29	BJK	ETF	23.92	23.92	23.06	23.1	14000.0
2010-06-29	BKF	ETF	41.66	42.18	40.92	41.03	540329.0
2010-06-29	BLV	ETF	82.09	82.24	81.73	82.24	32100.0
2010-06-29	BMVP	ETF	12.02	12.02	11.73	11.8	25289.0
2010-06-29	BND	ETF	81.19	81.37	81.19	81.36	1188300.0
2010-06-29	BNE	ETF	11.22	11.24	11.2	11.21	1067422.0
2010-06-29	BNO	ETF	25.615	25.615	25.425	25.425	12400.0
2010-06-29	BRF	ETF	44.64	44.65	43.79	44.11	345064.0
2010-06-29	BSCE	ETF	20.43	20.44	20.4199	20.44	11945.0
2010-06-29	BSV	ETF	80.93	81.02	80.9	80.96	620800.0
2010-06-29	BTF	ETF	68.25	68.25	66.85	67.45	7339.6
2010-06-29	BWX	ETF	26.75	26.945	26.745	26.745	172544.0
2010-06-29	BWZ	ETF	33.47	33.69	33.47	33.626	18190.0
2010-06-29	BZQ	ETF	4148.8	4379.2	4147.2	4315.2	2385.0
2010-06-29	CEF	ETF	15.02	15.12	14.9	14.97	1026700.0
2010-06-29	CEW	ETF	21.26	21.32	21.252	21.28	222451.0

> showing 50 of 760 rows — these rows as CSV

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