PREVIEW / etf_daily / 2010-11-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-23.parquet
  size:    34 KB
  rows:    807

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-11-23	SPY	ETF	118.77	119.02	117.99	118.45	222309000.0
2010-11-23	QQQ	ETF	52.39	52.45	51.77	52.07	76900950.0
2010-11-23	IWM	ETF	71.92	72.24	71.5	72.11	52202300.0
2010-11-23	DIA	ETF	110.78	110.81	109.9	110.39	6615500.0
2010-11-23	GLD	ETF	133.6	135.07	133.46	134.41	18215200.0
2010-11-23	TLT	ETF	97.67	97.95	97.24	97.48	9566900.0
2010-11-23	AADR	ETF	28.28	28.28	28.28	28.28	1000.0
2010-11-23	AAXJ	ETF	61.05	61.23	60.75	61.07	1204300.0
2010-11-23	ACWI	ETF	44.58	44.61	44.08	44.26	342200.0
2010-11-23	ACWX	ETF	42.27	42.28	41.84	41.95	92707.0
2010-11-23	ADRE	ETF	45.24	45.34	44.82	44.94	67854.0
2010-11-23	AFK	ETF	33.47	33.49	32.8	32.87	31699.0
2010-11-23	AGG	ETF	107.84	107.89	107.67	107.67	412300.0
2010-11-23	AGQ	ETF	258.64	261.5	251.06	256.12	721200.0
2010-11-23	AGZ	ETF	111.07	111.11	110.8	111.05	18870.0
2010-11-23	AIA	ETF	43.64	43.84	43.3701	43.53	72452.0
2010-11-23	AIQ	ETF	19.85	20.05	19.4	19.7	12882.0
2010-11-23	AIS	ETF	1.41	1.42	1.39	1.39	218049.0
2010-11-23	AIVI	ETF	43.4	43.52	42.91	43.05	25300.0
2010-11-23	AMJ	ETF	36.15	36.39	35.98	36.36	2389651.0
2010-11-23	AMLP	ETF	79.55	79.55	79.0	79.5	124200.0
2010-11-23	AOA	ETF	32.64	32.64	32.49	32.53	7100.0
2010-11-23	AOK	ETF	28.5936	28.5936	28.53	28.5599	7047.0
2010-11-23	AOM	ETF	29.42	29.46	29.3601	29.42	23588.0
2010-11-23	AOR	ETF	30.6	30.64	30.5	30.51	11376.0
2010-11-23	ARB	ETF	27.97	28.67	27.95	28.32	427753.0
2010-11-23	BAB	ETF	25.59	25.602	25.48	25.56	208869.0
2010-11-23	BAL	ETF	56.93	57.37	55.26	56.25	151427.0
2010-11-23	BALT	ETF	12.07	12.42	11.92	12.35	171134.0
2010-11-23	BBH	ETF	32.8867	32.9	32.55	32.59	63600.0
2010-11-23	BICK	ETF	31.83	31.83	31.46	31.58	60439.0
2010-11-23	BIL	ETF	91.72	91.72	91.7	91.7	68000.0
2010-11-23	BITS	ETF	28.0	28.32	27.84	28.28	3418.0
2010-11-23	BIV	ETF	86.06	86.14	85.75	85.88	362700.0
2010-11-23	BJK	ETF	31.02	31.02	30.58	30.58	7300.0
2010-11-23	BKF	ETF	47.83	47.83	47.2	47.27	186723.0
2010-11-23	BLV	ETF	81.94	82.06	81.62	81.77	20700.0
2010-11-23	BMVP	ETF	14.077	14.09	14.02	14.077	13371.0
2010-11-23	BND	ETF	82.09	82.21	82.02	82.02	728000.0
2010-11-23	BNE	ETF	11.49	11.5	11.49	11.49	691063.0
2010-11-23	BNO	ETF	27.88	27.88	27.88	27.88	2000.0
2010-11-23	BRF	ETF	58.52	58.64	57.2	57.49	959762.0
2010-11-23	BSCE	ETF	20.94	20.94	20.94	20.94	10734.0
2010-11-23	BSV	ETF	81.59	81.64	81.52	81.53	625000.0
2010-11-23	BTF	ETF	77.6	77.94999999999999	76.85	77.6	2849.0
2010-11-23	BWX	ETF	29.505	29.53	29.3	29.31	635266.0
2010-11-23	BWZ	ETF	36.74	36.97	36.668	36.77	36584.0
2010-11-23	BZQ	ETF	2827.2	2886.4	2796.8	2862.4	938.0
2010-11-23	CEF	ETF	18.92	19.07	18.85	18.97	1600100.0
2010-11-23	CEW	ETF	22.85	22.85	22.71	22.76	464430.0

> showing 50 of 807 rows — these rows as CSV

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