PREVIEW / etf_daily / 2009-01-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-20.parquet
  size:    28 KB
  rows:    640

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-20	SPY	ETF	84.23	85.06	80.05	80.57	419855200.0
2009-01-20	QQQ	ETF	29.29	29.43	27.96	27.96	135250974.0
2009-01-20	IWM	ETF	45.88	46.25	43.31	43.33	85180200.0
2009-01-20	DIA	ETF	82.21	82.41	79.36	79.41	36892100.0
2009-01-20	GLD	ETF	84.17	85.29	83.57	84.52	16743000.0
2009-01-20	TLT	ETF	112.29	114.63	112.23	114.28	3268300.0
2009-01-20	AAXJ	ETF	30.84	30.84	29.29	29.51	38600.0
2009-01-20	ACWI	ETF	29.51	29.51	27.87	27.97	557300.0
2009-01-20	ACWX	ETF	27.25	27.25	25.72	25.76	327450.0
2009-01-20	ADRE	ETF	25.79	25.79	24.3	24.3	289384.0
2009-01-20	AGG	ETF	102.71	103.19	102.64	103.06	663100.0
2009-01-20	AGQ	ETF	61.78	62.86	59.76	60.06	15350.0
2009-01-20	AGZ	ETF	107.18	108.02	107.16	108.02	4282.0
2009-01-20	AIA	ETF	23.08	23.08	22.14	22.32	8357.0
2009-01-20	AIQ	ETF	43.2	43.55	41.05	41.3	43521.0
2009-01-20	AIS	ETF	0.46	0.48	0.45	0.46	21776.0
2009-01-20	AIVI	ETF	29.25	29.25	27.94	27.94	25900.0
2009-01-20	AOA	ETF	23.18	23.18	22.07	22.07	5000.0
2009-01-20	AOK	ETF	25.17	25.9	25.0	25.1	7655.0
2009-01-20	AOM	ETF	24.49	25.15	24.26	24.26	5702.0
2009-01-20	AOR	ETF	25.32	25.32	23.0784	23.0784	42193.0
2009-01-20	ARB	ETF	14.67	15.18	13.5	13.74	394745.0
2009-01-20	BAL	ETF	27.73	28.01	27.73	27.81	2400.0
2009-01-20	BBH	ETF	57.0933	57.9467	55.92	55.9667	338400.0
2009-01-20	BIL	ETF	91.82	91.88	91.62	91.62	1157900.0
2009-01-20	BITS	ETF	18.0	18.56	15.04	18.08	9668.0
2009-01-20	BIV	ETF	77.94	78.72	77.55	78.4	93100.0
2009-01-20	BJK	ETF	15.76	15.78	15.76	15.78	300.0
2009-01-20	BKF	ETF	21.91	21.99	21.02	21.02	20576.0
2009-01-20	BLV	ETF	77.27	78.86	76.97	78.39	13000.0
2009-01-20	BMVP	ETF	10.3333	10.3333	9.8967	9.9002	38432.0
2009-01-20	BND	ETF	78.0	78.11	77.23	78.08	374800.0
2009-01-20	BNE	ETF	3.1	4.3	3.1	3.58	714325.0
2009-01-20	BSV	ETF	80.27	80.33	79.6	79.61	151800.0
2009-01-20	BTF	ETF	46.8	47.199999999999996	46.15	46.4565	6013.8
2009-01-20	BWX	ETF	25.68	25.7134	25.29	25.675	223238.0
2009-01-20	CBON	ETF	2.51	2.51	2.26	2.355	5645.0
2009-01-20	CDL	ETF	0.2	0.21	0.18	0.18	922592.0
2009-01-20	CEF	ETF	10.38	10.54	10.27	10.47	1045200.0
2009-01-20	CGO	ETF	10.2	10.2	9.25	9.36	20628.0
2009-01-20	CGW	ETF	13.24	13.24	12.5001	12.61	85176.0
2009-01-20	CHB	ETF	0.63	0.63	0.5	0.5	591748.0
2009-01-20	CHI	ETF	8.65	8.855	8.35	8.66	233798.0
2009-01-20	CHIC	ETF	4.53	5.19	4.52	4.99	585937.0
2009-01-20	CHW	ETF	6.06	6.06	5.64	5.87	181244.0
2009-01-20	CHY	ETF	8.81	8.87	8.46	8.48	331882.0
2009-01-20	CMF	ETF	51.795	52.0	51.515	51.5975	11212.0
2009-01-20	CNXT	ETF	0.79	0.79	0.67	0.69	250389.0
2009-01-20	COW	ETF	32.64	32.7612	32.21	32.22	20719.0
2009-01-20	CPST	ETF	0.902	0.92	0.85	0.85	1123562.0

> showing 50 of 640 rows — these rows as CSV

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