PREVIEW / etf_daily / 2009-01-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-23.parquet
  size:    28 KB
  rows:    627

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-23	SPY	ETF	80.9	83.99	80.57	83.11	386800600.0
2009-01-23	QQQ	ETF	28.31	29.35	28.14	28.9	170164091.0
2009-01-23	IWM	ETF	43.04	45.01	42.86	44.39	76444000.0
2009-01-23	DIA	ETF	79.5	81.53	79.05	80.52	44701000.0
2009-01-23	GLD	ETF	86.57	88.94	86.07	88.53	34010700.0
2009-01-23	TLT	ETF	107.92	108.32	106.69	107.69	2676200.0
2009-01-23	AAXJ	ETF	29.73	30.19	29.0	30.16	53800.0
2009-01-23	ACWI	ETF	28.04	28.84	27.7	28.66	351200.0
2009-01-23	ACWX	ETF	25.5	26.42	25.44	26.21	147840.0
2009-01-23	ADRE	ETF	24.23	25.5	24.14	25.23	423403.0
2009-01-23	AFK	ETF	17.75	17.75	17.4	17.47	19300.0
2009-01-23	AGG	ETF	102.02	102.39	101.64	101.92	578000.0
2009-01-23	AGQ	ETF	64.8	70.4	61.4	68.98	46850.0
2009-01-23	AGZ	ETF	107.99	107.99	107.0101	107.9	5952.0
2009-01-23	AIA	ETF	22.53	23.0	22.53	22.7	6092.0
2009-01-23	AIQ	ETF	42.15	43.091	41.5	42.15	27440.0
2009-01-23	AIS	ETF	0.46	0.48	0.44	0.48	26900.0
2009-01-23	AIVI	ETF	26.99	28.07	26.83	27.93	20000.0
2009-01-23	AOA	ETF	22.38	22.38	21.44	21.87	7800.0
2009-01-23	AOK	ETF	24.9	25.7	24.84	25.03	3400.0
2009-01-23	AOM	ETF	23.942	25.05	23.942	25.05	5489.0
2009-01-23	AOR	ETF	23.44	26.2	23.0	23.36	13040.0
2009-01-23	ARB	ETF	14.02	14.7	13.72	14.2	248254.0
2009-01-23	BAL	ETF	29.4	30.0	29.07	29.31	6115.0
2009-01-23	BBH	ETF	55.6267	56.4467	55.4567	56.36	117000.0
2009-01-23	BIL	ETF	91.7	91.8	91.66	91.78	94600.0
2009-01-23	BITS	ETF	18.68	19.08	18.2	19.0	3450.0
2009-01-23	BIV	ETF	77.56	77.7	77.02	77.65	83200.0
2009-01-23	BJK	ETF	15.5	15.73	15.5	15.68	900.0
2009-01-23	BKF	ETF	21.12	22.25	21.1	21.93	46347.0
2009-01-23	BLV	ETF	76.12	76.27	75.18	75.92	24500.0
2009-01-23	BMVP	ETF	9.94	10.28	9.89	10.22	48595.0
2009-01-23	BND	ETF	77.62	77.62	77.24	77.56	260100.0
2009-01-23	BNE	ETF	2.9	3.16	2.57	2.59	521411.0
2009-01-23	BSV	ETF	79.7	79.7	79.03	79.2	165700.0
2009-01-23	BTF	ETF	45.75	46.3495	45.05	45.8	8490.0
2009-01-23	BWX	ETF	25.16	25.575	25.12	25.575	237494.0
2009-01-23	CBON	ETF	2.25	2.44	2.142	2.44	12164.0
2009-01-23	CDL	ETF	0.2	0.21	0.18	0.19	696012.0
2009-01-23	CEF	ETF	10.93	11.2	10.82	11.08	1409600.0
2009-01-23	CGO	ETF	9.52	9.56	9.25	9.45	21394.0
2009-01-23	CGW	ETF	12.27	12.91	12.27	12.65	32297.0
2009-01-23	CHB	ETF	0.49	0.56	0.49	0.54	393890.0
2009-01-23	CHI	ETF	8.7	8.92	8.57	8.9	161539.0
2009-01-23	CHIC	ETF	4.49	4.67	4.44	4.51	148903.0
2009-01-23	CHW	ETF	5.7	5.8497	5.61	5.78	156358.0
2009-01-23	CHY	ETF	8.47	8.88	8.46	8.85	242653.0
2009-01-23	CMF	ETF	51.655	51.78	50.775	50.835	10210.0
2009-01-23	CNXT	ETF	0.66	0.6989	0.65	0.69	185630.0
2009-01-23	COW	ETF	31.95	32.62	31.72	32.62	104112.0

> showing 50 of 627 rows — these rows as CSV

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