PREVIEW / etf_daily / 2009-04-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-14.parquet
  size:    28 KB
  rows:    639

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-04-14	SPY	ETF	85.03	85.76	84.08	84.35	276598800.0
2009-04-14	QQQ	ETF	32.69	32.88	32.27	32.49	124068950.0
2009-04-14	IWM	ETF	45.96	46.53	45.23	45.31	56579200.0
2009-04-14	DIA	ETF	79.97	80.34	79.08	79.27	18590000.0
2009-04-14	GLD	ETF	87.78	87.81	87.04	87.37	7167400.0
2009-04-14	TLT	ETF	103.25	104.21	102.93	103.83	1336000.0
2009-04-14	AAXJ	ETF	37.16	37.44	36.91	37.08	29000.0
2009-04-14	ACWI	ETF	31.0	31.16	30.65	30.79	190300.0
2009-04-14	ACWX	ETF	29.13	29.37	28.98	28.99	136833.0
2009-04-14	ADRE	ETF	30.6	30.82	30.07	30.11	170114.0
2009-04-14	AFK	ETF	20.73	20.73	20.02	20.1	2599.0
2009-04-14	AGG	ETF	100.7	101.14	100.63	101.13	594200.0
2009-04-14	AGQ	ETF	74.84	75.64	72.86	74.86	64750.0
2009-04-14	AGZ	ETF	108.57	108.77	108.05	108.73	7483.0
2009-04-14	AIA	ETF	28.55	28.55	27.68	27.8799	30598.0
2009-04-14	AIQ	ETF	37.85	38.55	36.95	37.45	37931.0
2009-04-14	AIS	ETF	0.43	0.46	0.42	0.45	182425.0
2009-04-14	AIVI	ETF	30.83	31.19	30.77	31.01	14900.0
2009-04-14	AMJ	ETF	20.31	20.33	20.0	20.22	23200.0
2009-04-14	AOA	ETF	23.26	23.58	23.0	23.0	21600.0
2009-04-14	AOK	ETF	25.21	25.2294	24.6299	25.15	2250.0
2009-04-14	AOM	ETF	24.65	25.23	24.4724	25.23	14130.0
2009-04-14	AOR	ETF	24.14	24.81	23.88	23.88	16074.0
2009-04-14	ARB	ETF	16.82	18.17	16.81	17.95	732978.0
2009-04-14	BAL	ETF	27.51	27.51	27.23	27.23	2705.0
2009-04-14	BBH	ETF	29.9067	30.0633	29.5967	29.8767	579300.0
2009-04-14	BIL	ETF	91.7	91.72	91.68	91.7	125600.0
2009-04-14	BITS	ETF	17.64	18.64	17.4	17.88	2621.0
2009-04-14	BIV	ETF	76.5	76.67	76.35	76.61	56000.0
2009-04-14	BJK	ETF	18.15	18.56	17.67	18.02	6800.0
2009-04-14	BKF	ETF	29.18	29.73	28.5306	28.62	104468.0
2009-04-14	BLV	ETF	73.07	73.7	73.07	73.57	7100.0
2009-04-14	BMVP	ETF	10.35	10.44	10.29	10.32	19393.0
2009-04-14	BND	ETF	77.22	77.34	77.06	77.29	316000.0
2009-04-14	BNE	ETF	3.98	4.26	3.778	4.0	311934.0
2009-04-14	BOSS	ETF	12.11	12.22	12.11	12.22	100.0
2009-04-14	BSV	ETF	78.73	78.82	78.48	78.8	166100.0
2009-04-14	BTF	ETF	45.49999999999999	46.15	44.29	45.49999999999999	10535.2
2009-04-14	BWX	ETF	25.63	25.8	25.617	25.775	161858.0
2009-04-14	CBON	ETF	2.5	2.5	2.35	2.4	7015.0
2009-04-14	CEF	ETF	11.0	11.06	10.91	10.97	881900.0
2009-04-14	CGO	ETF	9.36	9.68	9.35	9.36	24569.0
2009-04-14	CGW	ETF	13.0	13.0	12.58	12.81	16855.0
2009-04-14	CHB	ETF	0.56	0.72	0.55	0.59	1337762.0
2009-04-14	CHI	ETF	8.87	9.06	8.87	8.93	152500.0
2009-04-14	CHIC	ETF	11.01	11.72	10.71	11.51	608989.0
2009-04-14	CHW	ETF	6.0	6.0	5.8	5.88	141288.0
2009-04-14	CHY	ETF	9.0	9.0	8.53	8.55	175718.0
2009-04-14	CMF	ETF	51.91	51.91	51.7644	51.905	11296.0
2009-04-14	CNXT	ETF	0.72	0.73	0.7	0.7038	201010.0

> showing 50 of 639 rows — these rows as CSV

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