PREVIEW / etf_daily / 2009-01-29

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-29.parquet
  size:    28 KB
  rows:    632

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
2009-01-29	SPY	ETF	86.11	87.49	84.47	84.55	294392500.0
2009-01-29	QQQ	ETF	29.97	30.4008	29.48	29.58	130772841.0
2009-01-29	IWM	ETF	46.59	47.23	45.25	45.4	66434400.0
2009-01-29	DIA	ETF	82.58	82.94	81.35	81.53	20825600.0
2009-01-29	GLD	ETF	86.68	89.55	86.28	89.5	21175600.0
2009-01-29	TLT	ETF	105.56	106.31	103.66	104.08	3724400.0
2009-01-29	AAXJ	ETF	32.44	32.44	30.58	31.25	27000.0
2009-01-29	ACWI	ETF	29.78	29.96	29.18	29.26	1256300.0
2009-01-29	ACWX	ETF	27.57	27.6	26.96	26.96	141914.0
2009-01-29	ADRE	ETF	27.36	27.36	25.956	26.0	252496.0
2009-01-29	AFK	ETF	18.0	18.03	17.81	17.88	24225.0
2009-01-29	AGG	ETF	102.27	102.54	101.4	101.49	869600.0
2009-01-29	AGQ	ETF	68.04	74.0	67.26	74.0	76900.0
2009-01-29	AGZ	ETF	108.43	108.43	106.786	107.46	60613.0
2009-01-29	AIA	ETF	23.55	23.62	23.36	23.36	25700.0
2009-01-29	AIQ	ETF	44.35	46.1	44.15	44.8	42478.0
2009-01-29	AIS	ETF	0.4504	0.48	0.4504	0.48	63200.0
2009-01-29	AIVI	ETF	29.46	30.0	28.77	28.78	9300.0
2009-01-29	AOA	ETF	22.73	22.77	22.68	22.77	2000.0
2009-01-29	AOK	ETF	25.23	25.24	25.23	25.23	1550.0
2009-01-29	AOM	ETF	24.7	24.73	24.51	24.51	4126.0
2009-01-29	AOR	ETF	23.81	23.82	23.6	23.62	1753.0
2009-01-29	ARB	ETF	15.44	15.58	15.09	15.2	483546.0
2009-01-29	BAL	ETF	29.38	29.7	29.34	29.51	8084.0
2009-01-29	BBH	ETF	56.96	57.6467	56.96	57.3733	115200.0
2009-01-29	BIL	ETF	91.7	91.74	91.64	91.68	226450.0
2009-01-29	BITS	ETF	20.0	20.0	18.04	19.92	1376.0
2009-01-29	BIV	ETF	77.95	77.95	77.14	77.2	79100.0
2009-01-29	BKF	ETF	22.62	23.218	22.62	23.12	31176.0
2009-01-29	BLV	ETF	75.94	76.06	74.74	74.99	50200.0
2009-01-29	BMVP	ETF	10.56	10.56	10.32	10.33	34841.0
2009-01-29	BND	ETF	77.55	77.69	77.01	77.29	403700.0
2009-01-29	BNE	ETF	3.62	3.62	2.84	2.86	382169.0
2009-01-29	BSV	ETF	79.9	79.91	79.52	79.68	107800.0
2009-01-29	BTF	ETF	47.0	47.5	46.8	47.35	6823.200000000001
2009-01-29	BWX	ETF	25.775	25.8	25.575	25.695	190404.0
2009-01-29	BWZ	ETF	33.03	33.03	32.9	32.9	15200.0
2009-01-29	CBON	ETF	2.99	2.99	2.84	2.84	5300.0
2009-01-29	CDL	ETF	0.21	0.21	0.18	0.18	564155.0
2009-01-29	CEF	ETF	10.48	10.85	10.4	10.84	1089100.0
2009-01-29	CGO	ETF	10.22	10.22	9.86	9.97	12918.0
2009-01-29	CGW	ETF	13.4	13.4	12.96	13.07	86176.0
2009-01-29	CHB	ETF	0.48	0.49	0.46	0.48	277037.0
2009-01-29	CHI	ETF	9.02	9.24	9.01	9.15	176402.0
2009-01-29	CHIC	ETF	5.13	5.13	4.76	4.87	228092.0
2009-01-29	CHW	ETF	6.27	6.27	6.05	6.15	206618.0
2009-01-29	CHY	ETF	9.13	9.16	9.01	9.1	205159.0
2009-01-29	CMF	ETF	51.28	51.28	50.34	50.64	16160.0
2009-01-29	CNXT	ETF	0.72	0.72	0.68	0.71	210439.0
2009-01-29	COW	ETF	30.93	31.2699	30.93	31.13	6508.0

> showing 50 of 632 rows — these rows as CSV

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