PREVIEW / etf_daily / 2009-12-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-14.parquet
  size:    31 KB
  rows:    705

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-14	SPY	ETF	111.87	112.0	111.13	111.87	107141500.0
2009-12-14	QQQ	ETF	44.43	44.6	44.19	44.55	47965477.0
2009-12-14	IWM	ETF	60.65	61.38	59.97	61.08	48248700.0
2009-12-14	DIA	ETF	105.32	105.38	104.92	105.2	9752400.0
2009-12-14	GLD	ETF	110.01	110.7	109.5	110.24	16339100.0
2009-12-14	TLT	ETF	92.35	92.5	92.05	92.2	2380400.0
2009-12-14	AAXJ	ETF	55.83	55.9	55.55	55.89	59100.0
2009-12-14	ACWI	ETF	42.64	42.64	42.29	42.5	72900.0
2009-12-14	ACWX	ETF	40.98	41.23	40.9699	41.15	53451.0
2009-12-14	ADRE	ETF	44.51	44.66	44.3548	44.58	190663.0
2009-12-14	AFK	ETF	28.47	28.66	28.47	28.52	2326.0
2009-12-14	AGG	ETF	104.82	104.83	104.64	104.68	423300.0
2009-12-14	AGQ	ETF	118.4	120.34	117.36	119.96	262050.0
2009-12-14	AGZ	ETF	108.66	108.68	108.33	108.33	10368.0
2009-12-14	AIA	ETF	39.87	39.92	39.7	39.88	16843.0
2009-12-14	AIQ	ETF	31.45	31.5	30.3	31.25	40975.0
2009-12-14	AIS	ETF	1.05	1.09	1.03	1.07	319772.0
2009-12-14	AIVI	ETF	43.96	44.22	43.89	44.14	45500.0
2009-12-14	AMJ	ETF	27.55	27.88	27.55	27.73	491107.0
2009-12-14	AOA	ETF	29.84	29.99	29.84	29.97	2100.0
2009-12-14	AOK	ETF	27.42	27.52	27.42	27.52	6878.0
2009-12-14	AOM	ETF	28.28	28.41	28.28	28.41	8827.0
2009-12-14	AOR	ETF	29.11	29.12	29.0007	29.104	23770.0
2009-12-14	ARB	ETF	21.85	22.28	21.753	22.15	167784.0
2009-12-14	BAB	ETF	24.6	24.6	24.5	24.58	161762.0
2009-12-14	BAL	ETF	36.76	37.25	36.75	37.25	11949.0
2009-12-14	BBH	ETF	32.5767	32.9633	32.5367	32.8967	254400.0
2009-12-14	BIL	ETF	91.7	91.72	91.68	91.68	263450.0
2009-12-14	BITS	ETF	27.8	28.16	27.2	28.0	4962.0
2009-12-14	BIV	ETF	80.5	80.53	80.3	80.37	95200.0
2009-12-14	BJK	ETF	24.61	24.64	24.27	24.64	9400.0
2009-12-14	BKF	ETF	46.12	46.53	46.07	46.35	253545.0
2009-12-14	BLV	ETF	77.33	77.57	77.28	77.4	28100.0
2009-12-14	BMVP	ETF	12.48	12.6	12.48	12.59	21976.0
2009-12-14	BND	ETF	79.45	79.48	79.27	79.36	393800.0
2009-12-14	BNE	ETF	6.44	6.51	6.33	6.51	283692.0
2009-12-14	BRF	ETF	49.38	49.54	48.81	49.08	375869.0
2009-12-14	BSV	ETF	80.27	80.28	80.14	80.19	315800.0
2009-12-14	BTF	ETF	63.49999999999999	63.65	63.05	63.449999999999996	6380.0
2009-12-14	BWX	ETF	29.39	29.475	29.33	29.455	319922.0
2009-12-14	BWZ	ETF	37.14	37.38	37.1301	37.37	24530.0
2009-12-14	BZQ	ETF	3635.2	3684.8	3627.2	3656.0	52.5
2009-12-14	CEF	ETF	13.77	13.87	13.72	13.73	1899000.0
2009-12-14	CEW	ETF	22.07	22.39	22.07	22.22	37941.0
2009-12-14	CGO	ETF	14.3	14.48	14.3	14.4	12505.0
2009-12-14	CGW	ETF	18.6	18.67	18.46	18.67	246862.0
2009-12-14	CHI	ETF	12.38	12.46	12.3	12.37	256907.0
2009-12-14	CHII	ETF	16.09	16.1	15.935	15.99	26537.0
2009-12-14	CHIQ	ETF	16.5	16.52	16.343	16.49	55245.0
2009-12-14	CHIX	ETF	15.23	15.25	15.07	15.17	93805.0

> showing 50 of 705 rows — these rows as CSV

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