PREVIEW / etf_daily / 2009-12-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-17.parquet
  size:    31 KB
  rows:    702

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-17	SPY	ETF	110.72	110.93	110.08	110.18	183390100.0
2009-12-17	QQQ	ETF	44.17	44.21	43.76	43.82	90440881.0
2009-12-17	IWM	ETF	60.93	61.17	60.18	60.62	60917400.0
2009-12-17	DIA	ETF	104.04	104.15	103.29	103.38	8223700.0
2009-12-17	GLD	ETF	109.47	109.98	107.28	107.34	35016800.0
2009-12-17	TLT	ETF	92.5	93.23	92.19	93.19	4428900.0
2009-12-17	AAXJ	ETF	54.59	54.87	54.25	54.46	1393300.0
2009-12-17	ACWI	ETF	41.81	42.0	41.66	41.75	86900.0
2009-12-17	ACWX	ETF	40.45	40.48	40.08	40.24	132159.0
2009-12-17	ADRE	ETF	43.73	43.73	42.98	43.03	146129.0
2009-12-17	AFK	ETF	28.4	28.4	27.78	28.1	3872.0
2009-12-17	AGG	ETF	104.8	104.85	104.62	104.75	481700.0
2009-12-17	AGQ	ETF	120.86	121.86	115.76	115.94	227150.0
2009-12-17	AGZ	ETF	108.43	108.84	108.43	108.71	34577.0
2009-12-17	AIA	ETF	38.78	38.95	38.56	38.69	16188.0
2009-12-17	AIQ	ETF	30.15	30.4	30.0	30.3	15412.0
2009-12-17	AIS	ETF	1.06	1.095	1.06	1.07	79549.0
2009-12-17	AIVI	ETF	43.5	43.5	42.87	43.07	39400.0
2009-12-17	AMJ	ETF	28.05	28.15	27.87	28.035	239123.0
2009-12-17	AOA	ETF	29.66	29.81	29.6	29.66	13500.0
2009-12-17	AOK	ETF	27.4593	27.48	27.4304	27.44	1601.0
2009-12-17	AOM	ETF	28.27	28.27	28.1905	28.246	31863.0
2009-12-17	AOR	ETF	28.97	28.97	28.79	28.84	9546.0
2009-12-17	ARB	ETF	22.81	23.14	22.68	22.96	286063.0
2009-12-17	BAB	ETF	24.64	24.7	24.51	24.68	73650.0
2009-12-17	BAL	ETF	37.14	37.14	36.894	37.055	7110.0
2009-12-17	BBH	ETF	31.7267	31.7267	31.3	31.51	789000.0
2009-12-17	BIL	ETF	91.72	91.74	91.7	91.7	197700.0
2009-12-17	BITS	ETF	28.0	29.96	27.55	29.87	11745.0
2009-12-17	BIV	ETF	80.48	80.67	80.4	80.67	63300.0
2009-12-17	BJK	ETF	23.9	24.08	23.71	23.77	64300.0
2009-12-17	BKF	ETF	44.78	45.28	44.28	44.57	283226.0
2009-12-17	BLV	ETF	77.36	77.7	77.19	77.7	49400.0
2009-12-17	BMVP	ETF	12.5783	12.5982	12.51	12.57	60867.0
2009-12-17	BND	ETF	79.47	79.59	79.44	79.55	514100.0
2009-12-17	BNE	ETF	6.79	6.96	6.66	6.81	165805.0
2009-12-17	BRF	ETF	47.47	47.51	46.05	46.19	528931.0
2009-12-17	BSV	ETF	80.25	80.4	80.21	80.39	623500.0
2009-12-17	BTF	ETF	63.449999999999996	63.699999999999996	63.4	63.449999999999996	2205.0
2009-12-17	BWX	ETF	28.985	28.99	28.705	28.845	717464.0
2009-12-17	BWZ	ETF	36.78	37.0	36.43	36.51	104432.0
2009-12-17	BZQ	ETF	3904.0	4086.4	3876.8	4080.0	494.5
2009-12-17	CEF	ETF	13.93	14.02	13.55	13.63	1621300.0
2009-12-17	CEW	ETF	22.01	22.01	21.84	21.98	402776.0
2009-12-17	CGO	ETF	14.31	14.48	14.3009	14.3591	18747.0
2009-12-17	CGW	ETF	18.55	18.55	18.31	18.39	101503.0
2009-12-17	CHI	ETF	12.34	12.45	12.32	12.36	147085.0
2009-12-17	CHIE	ETF	14.83	14.83	14.58	14.64	12350.0
2009-12-17	CHII	ETF	15.31	15.31	15.11	15.11	51658.0
2009-12-17	CHIQ	ETF	16.23	16.23	15.9301	15.9799	32197.0

> showing 50 of 702 rows — these rows as CSV

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