PREVIEW / etf_daily / 2009-01-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-16.parquet
  size:    28 KB
  rows:    627

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-16	SPY	ETF	85.86	85.99	83.05	85.06	399237200.0
2009-01-16	QQQ	ETF	29.53	29.6	28.7	29.42	175490357.0
2009-01-16	IWM	ETF	46.98	47.03	44.97	46.48	80512600.0
2009-01-16	DIA	ETF	83.22	83.4	81.03	82.69	37613200.0
2009-01-16	GLD	ETF	82.2	83.0	81.74	82.71	16470300.0
2009-01-16	TLT	ETF	113.42	116.09	113.36	114.3	2994800.0
2009-01-16	AAXJ	ETF	31.5	31.74	31.06	31.31	10400.0
2009-01-16	ACWI	ETF	30.43	30.46	29.38	29.98	203800.0
2009-01-16	ACWX	ETF	28.29	28.37	27.23	27.81	166865.0
2009-01-16	ADRE	ETF	26.49	26.5596	25.406	26.22	237679.0
2009-01-16	AFK	ETF	20.31	20.31	19.316	19.6268	1345.0
2009-01-16	AGG	ETF	102.97	103.86	102.81	103.6	608700.0
2009-01-16	AGQ	ETF	59.34	61.76	58.28	61.34	34750.0
2009-01-16	AGZ	ETF	107.6	108.18	107.6	107.96	1976.0
2009-01-16	AIA	ETF	24.5	24.91	23.32	24.11	109942.0
2009-01-16	AIQ	ETF	42.3	44.0	41.8	43.95	55261.0
2009-01-16	AIS	ETF	0.45	0.48	0.45	0.48	8600.0
2009-01-16	AIVI	ETF	31.32	31.32	29.93	30.73	15500.0
2009-01-16	AOA	ETF	22.86	22.86	22.35	22.85	2700.0
2009-01-16	AOK	ETF	26.1	26.1	25.26	25.4299	3910.0
2009-01-16	AOM	ETF	24.66	24.754	24.66	24.754	1728.0
2009-01-16	AOR	ETF	24.06	24.16	22.22	23.71	4918.0
2009-01-16	ARB	ETF	15.06	15.11	14.41	14.87	409686.0
2009-01-16	BAL	ETF	29.08	29.12	28.13	28.13	3900.0
2009-01-16	BBH	ETF	57.72	57.9867	56.98	57.9867	421800.0
2009-01-16	BIL	ETF	91.72	91.82	91.72	91.78	116500.0
2009-01-16	BITS	ETF	19.822	19.822	18.8	18.8	225.0
2009-01-16	BIV	ETF	79.0	79.15	78.0	78.9	93700.0
2009-01-16	BJK	ETF	16.57	16.74	15.8	16.09	2300.0
2009-01-16	BKF	ETF	22.92	23.18	22.438	22.8	62425.0
2009-01-16	BLV	ETF	78.7	79.17	78.13	79.11	10300.0
2009-01-16	BMVP	ETF	10.343	10.453	10.164	10.403	34500.0
2009-01-16	BND	ETF	78.09	78.46	77.75	78.42	256200.0
2009-01-16	BNE	ETF	3.32	3.3279	2.99	3.17	214116.0
2009-01-16	BSV	ETF	80.43	80.49	80.02	80.34	125800.0
2009-01-16	BTF	ETF	47.55	47.99999999999999	46.51349999999999	47.64999999999999	8998.4
2009-01-16	BWX	ETF	26.215	26.215	26.0	26.175	165954.0
2009-01-16	CBON	ETF	2.16	2.33	2.15	2.32	90428.0
2009-01-16	CDL	ETF	0.2279	0.2279	0.2	0.21	358682.0
2009-01-16	CEF	ETF	10.39	10.45	10.27	10.29	769300.0
2009-01-16	CGO	ETF	9.47	10.25	9.47	9.75	27102.0
2009-01-16	CGW	ETF	13.34	13.5499	13.1	13.47	40654.0
2009-01-16	CHB	ETF	0.58	0.65	0.56	0.65	678405.0
2009-01-16	CHI	ETF	8.3	8.77	8.3	8.67	248045.0
2009-01-16	CHIC	ETF	4.78	4.78	4.37	4.58	150579.0
2009-01-16	CHW	ETF	6.11	6.125	5.86	6.11	236192.0
2009-01-16	CHY	ETF	8.48	8.846	8.44	8.84	284979.0
2009-01-16	CMF	ETF	52.145	52.235	51.57	52.179	13636.0
2009-01-16	CNXT	ETF	0.73	0.82	0.73	0.75	403029.0
2009-01-16	COW	ETF	33.0192	33.07	32.788	32.81	9447.0

> showing 50 of 627 rows — these rows as CSV

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