PREVIEW / etf_daily / 2010-01-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-26.parquet
  size:    31 KB
  rows:    712

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-01-26	SPY	ETF	109.34	110.47	109.04	109.31	211168800.0
2010-01-26	QQQ	ETF	44.28	44.89	44.05	44.35	140816418.0
2010-01-26	IWM	ETF	61.57	62.03	61.14	61.19	58213200.0
2010-01-26	DIA	ETF	101.66	103.06	101.48	101.88	18352400.0
2010-01-26	GLD	ETF	106.87	107.99	106.75	107.56	12297100.0
2010-01-26	TLT	ETF	92.02	92.11	91.31	91.61	3138100.0
2010-01-26	AAXJ	ETF	53.28	53.38	52.7	52.7	673400.0
2010-01-26	ACWI	ETF	41.31	41.61	41.0	41.28	72600.0
2010-01-26	ACWX	ETF	39.78	40.1081	39.61	39.8	76705.0
2010-01-26	ADRE	ETF	40.64	41.062	40.27	40.41	469973.0
2010-01-26	AFK	ETF	28.63	28.825	28.41	28.825	3560.0
2010-01-26	AGG	ETF	104.65	104.71	104.47	104.58	1288200.0
2010-01-26	AGQ	ETF	106.0	111.96	105.8	109.58	366250.0
2010-01-26	AGZ	ETF	108.52	108.722	108.33	108.65	18545.0
2010-01-26	AIA	ETF	38.38	38.76	37.87	38.18	21923.0
2010-01-26	AIQ	ETF	25.45	25.9	24.55	24.6	60710.0
2010-01-26	AIS	ETF	1.13	1.18	1.13	1.18	73721.0
2010-01-26	AIVI	ETF	41.9	42.42	41.89	41.94	19500.0
2010-01-26	AMJ	ETF	29.72	29.98	29.46	29.98	304507.0
2010-01-26	AOA	ETF	29.57	29.77	29.49	29.54	7700.0
2010-01-26	AOK	ETF	27.3419	27.45	27.31	27.3519	4250.0
2010-01-26	AOM	ETF	28.05	28.16	27.97	28.0251	8120.0
2010-01-26	AOR	ETF	28.73	28.84	28.59	28.65	15456.0
2010-01-26	ARB	ETF	25.46	25.96	25.2913	25.81	147220.0
2010-01-26	BAB	ETF	24.9	25.0	24.876	24.9	102785.0
2010-01-26	BAL	ETF	33.8901	34.34	33.81	34.13	42671.0
2010-01-26	BBH	ETF	32.9233	33.0167	32.6	32.94	150300.0
2010-01-26	BIL	ETF	91.72	91.72	91.68	91.72	136000.0
2010-01-26	BITS	ETF	32.4	32.4	32.16	32.4	868.0
2010-01-26	BIV	ETF	80.79	80.79	80.51	80.52	189300.0
2010-01-26	BJK	ETF	24.57	24.57	24.21	24.4	8600.0
2010-01-26	BKF	ETF	42.8	42.99	42.21	42.43	661485.0
2010-01-26	BLV	ETF	77.79	77.79	77.3	77.51	26400.0
2010-01-26	BMVP	ETF	12.48	12.58	12.433	12.46	30691.0
2010-01-26	BND	ETF	79.59	79.63	79.46	79.58	494400.0
2010-01-26	BNE	ETF	6.53	6.54	6.4	6.47	91147.0
2010-01-26	BRF	ETF	44.75	44.75	43.36	43.55	999420.0
2010-01-26	BSV	ETF	80.29	80.31	80.17	80.26	465900.0
2010-01-26	BTF	ETF	64.6	65.0	64.55	64.69999999999999	2600.0
2010-01-26	BWX	ETF	28.5	28.691	28.175	28.46	402882.0
2010-01-26	BWZ	ETF	36.41	36.44	36.2	36.23	63637.0
2010-01-26	BZQ	ETF	4540.8	4619.2	4368.0	4540.8	3674.0
2010-01-26	CEF	ETF	13.35	13.61	13.25	13.48	877500.0
2010-01-26	CEW	ETF	21.8	21.93	21.75	21.9	128293.0
2010-01-26	CGO	ETF	14.37	14.55	14.28	14.28	19995.0
2010-01-26	CGW	ETF	18.01	18.22	18.0	18.01	210281.0
2010-01-26	CHI	ETF	12.36	12.46	12.23	12.44	145602.0
2010-01-26	CHIE	ETF	13.8	13.97	13.73	13.82	20755.0
2010-01-26	CHII	ETF	14.58	14.75	14.52	14.5401	31877.0
2010-01-26	CHIM	ETF	25.14	25.32	25.04	25.04	3675.0

> showing 50 of 712 rows — these rows as CSV

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