PREVIEW / etf_daily / 2009-12-29

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-29.parquet
  size:    31 KB
  rows:    706

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-12-29	SPY	ETF	113.01	113.03	112.55	112.56	80572500.0
2009-12-29	QQQ	ETF	46.22	46.25	45.99	46.03	32410154.0
2009-12-29	IWM	ETF	63.42	63.53	63.18	63.23	24085300.0
2009-12-29	DIA	ETF	105.49	105.64	105.25	105.29	3356400.0
2009-12-29	GLD	ETF	108.5	108.5	107.45	107.47	11043700.0
2009-12-29	TLT	ETF	89.26	89.89	89.2	89.73	2617000.0
2009-12-29	AAXJ	ETF	55.88	55.88	55.31	55.53	213000.0
2009-12-29	ACWI	ETF	42.89	42.89	42.46	42.61	1461600.0
2009-12-29	ACWX	ETF	41.48	41.48	41.105	41.22	204442.0
2009-12-29	ADRE	ETF	44.19	44.19	43.841	43.85	188232.0
2009-12-29	AFK	ETF	28.12	28.5	28.12	28.29	14152.0
2009-12-29	AGG	ETF	103.11	103.2	103.0	103.06	833800.0
2009-12-29	AGQ	ETF	120.18	120.3	115.3	115.9	127900.0
2009-12-29	AGZ	ETF	107.63	107.74	107.43	107.74	12826.0
2009-12-29	AIA	ETF	39.5	39.65	39.3482	39.55	30008.0
2009-12-29	AIQ	ETF	29.1	29.15	28.35	28.4	33275.0
2009-12-29	AIS	ETF	1.1	1.1	1.07	1.0799	149290.0
2009-12-29	AIVI	ETF	44.18	44.47	43.88	43.97	41500.0
2009-12-29	AMJ	ETF	28.76	28.8	28.4	28.58	217966.0
2009-12-29	AOA	ETF	30.32	30.34	30.24	30.24	9500.0
2009-12-29	AOK	ETF	27.19	27.47	27.19	27.4	15673.0
2009-12-29	AOM	ETF	28.41	28.41	28.29	28.34	5208.0
2009-12-29	AOR	ETF	29.28	29.76	29.098	29.098	3460.0
2009-12-29	ARB	ETF	24.49	24.66	24.41	24.56	104354.0
2009-12-29	BAB	ETF	24.22	24.25	24.15	24.245	145534.0
2009-12-29	BAL	ETF	37.0054	37.06	36.8154	36.87	3539.0
2009-12-29	BBH	ETF	32.7633	32.8733	32.6667	32.8033	44100.0
2009-12-29	BIL	ETF	91.7	91.74	91.7	91.7	65050.0
2009-12-29	BITS	ETF	30.08	30.24	29.88	30.24	3652.0
2009-12-29	BIV	ETF	79.06	79.26	78.9	79.24	120600.0
2009-12-29	BJK	ETF	24.31	24.31	23.59	23.73	10700.0
2009-12-29	BKF	ETF	46.09	46.09	45.52	45.65	115719.0
2009-12-29	BLV	ETF	75.59	75.85	75.36	75.78	27000.0
2009-12-29	BMVP	ETF	12.85	12.857	12.813	12.82	18104.0
2009-12-29	BND	ETF	78.38	78.54	78.35	78.54	741700.0
2009-12-29	BNE	ETF	6.97	7.05	6.84	6.93	74718.0
2009-12-29	BOSS	ETF	19.86	20.17	19.86	20.17	300.0
2009-12-29	BRF	ETF	48.89	48.99	48.5	48.57	257353.0
2009-12-29	BSV	ETF	79.61	79.68	79.51	79.67	667500.0
2009-12-29	BTF	ETF	63.449999999999996	64.19999999999999	63.449999999999996	63.955	3925.6000000000004
2009-12-29	BWX	ETF	28.805	28.805	28.405	28.41	323286.0
2009-12-29	BWZ	ETF	36.88	36.88	36.29	36.34	43264.0
2009-12-29	BZQ	ETF	3700.8	3764.8	3700.8	3756.8	259.5
2009-12-29	CEF	ETF	13.95	14.0	13.72	13.77	636200.0
2009-12-29	CEW	ETF	21.95	22.02	21.866	21.9172	125986.0
2009-12-29	CGO	ETF	14.48	14.71	14.35	14.436	23610.0
2009-12-29	CGW	ETF	18.5	18.6	18.4	18.5	61943.0
2009-12-29	CHI	ETF	12.53	12.57	12.45	12.48	107613.0
2009-12-29	CHIE	ETF	15.49	15.49	14.9	14.97	18713.0
2009-12-29	CHII	ETF	16.35	16.35	15.37	15.4199	15708.0

> showing 50 of 706 rows — these rows as CSV

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