PREVIEW / etf_daily / 2009-01-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-21.parquet
  size:    28 KB
  rows:    642

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-21	SPY	ETF	81.94	84.24	80.47	84.05	364360700.0
2009-01-21	QQQ	ETF	28.43	29.19	28.1	29.15	149242661.0
2009-01-21	IWM	ETF	44.0	45.69	43.04	45.49	66088100.0
2009-01-21	DIA	ETF	80.65	82.41	79.35	82.24	34826600.0
2009-01-21	GLD	ETF	84.05	84.39	82.98	84.15	12272100.0
2009-01-21	TLT	ETF	111.93	113.04	110.4	110.67	2838100.0
2009-01-21	AAXJ	ETF	30.59	30.59	29.33	30.25	51800.0
2009-01-21	ACWI	ETF	28.28	29.24	28.08	29.21	396100.0
2009-01-21	ACWX	ETF	26.33	27.14	26.11	27.13	255123.0
2009-01-21	ADRE	ETF	25.0	25.68	24.4	25.68	201304.0
2009-01-21	AFK	ETF	17.31	18.534	17.31	18.534	200.0
2009-01-21	AGG	ETF	103.23	103.23	102.51	102.52	621200.0
2009-01-21	AGQ	ETF	63.0	63.0	59.0	61.92	27900.0
2009-01-21	AGZ	ETF	108.37	108.4	107.35	107.35	9508.0
2009-01-21	AIA	ETF	22.8	23.52	22.5	23.02	10765.0
2009-01-21	AIQ	ETF	41.25	44.05	41.0	43.8	45948.0
2009-01-21	AIS	ETF	0.45	0.47	0.44	0.4601	16540.0
2009-01-21	AIVI	ETF	28.43	29.41	28.1	29.41	14400.0
2009-01-21	AOA	ETF	22.0	22.0	21.66	21.86	16100.0
2009-01-21	AOK	ETF	24.75	25.5	24.715	24.952	4926.0
2009-01-21	AOM	ETF	24.19	25.15	23.995	24.42	6762.0
2009-01-21	AOR	ETF	22.9401	23.16	22.9401	23.16	1620.0
2009-01-21	ARB	ETF	13.95	15.1	13.87	15.04	390978.0
2009-01-21	BAL	ETF	27.48	27.54	27.42	27.54	5300.0
2009-01-21	BBH	ETF	56.1833	57.2067	55.8167	57.2067	164400.0
2009-01-21	BIL	ETF	91.68	91.78	91.64	91.78	133400.0
2009-01-21	BITS	ETF	18.64	19.44	18.4	19.4	2888.0
2009-01-21	BIV	ETF	78.38	78.38	77.6	77.69	61900.0
2009-01-21	BJK	ETF	16.01	16.01	15.5	16.0	1600.0
2009-01-21	BKF	ETF	22.2	22.5599	21.33	21.962	8105.0
2009-01-21	BLV	ETF	77.33	78.25	76.81	76.88	19100.0
2009-01-21	BMVP	ETF	10.02	10.33	9.88	10.31	17873.0
2009-01-21	BND	ETF	78.0	78.13	77.41	77.54	350500.0
2009-01-21	BNE	ETF	3.51	3.68	3.24	3.56	228328.0
2009-01-21	BOSS	ETF	14.03	14.03	13.88	13.88	300.0
2009-01-21	BSV	ETF	80.27	80.27	78.81	79.03	227000.0
2009-01-21	BTF	ETF	46.5	47.0	46.3	47.0	8572.6
2009-01-21	BWX	ETF	25.66	25.7	25.275	25.695	336664.0
2009-01-21	CBON	ETF	2.32	2.45	2.268	2.4	4908.0
2009-01-21	CDL	ETF	0.19	0.21	0.19	0.21	386765.0
2009-01-21	CEF	ETF	10.5	10.59	10.32	10.49	678100.0
2009-01-21	CGO	ETF	9.7	9.7	9.29	9.46	25213.0
2009-01-21	CGW	ETF	12.62	13.05	12.5	13.05	32830.0
2009-01-21	CHB	ETF	0.56	0.6	0.5	0.54	443476.0
2009-01-21	CHI	ETF	8.79	8.95	8.6	8.91	324403.0
2009-01-21	CHIC	ETF	4.99	5.05	4.78	4.93	399024.0
2009-01-21	CHW	ETF	5.92	5.92	5.65	5.88	144826.0
2009-01-21	CHY	ETF	8.55	9.29	8.55	8.94	792694.0
2009-01-21	CMF	ETF	51.48	51.6799	51.09	51.35	15332.0
2009-01-21	CNXT	ETF	0.69	0.7	0.6513	0.675	167511.0

> showing 50 of 642 rows — these rows as CSV

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