PREVIEW / etf_daily / 2009-11-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-09.parquet
  size:    30 KB
  rows:    683

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-11-09	SPY	ETF	107.95	109.63	107.87	109.57	159495700.0
2009-11-09	QQQ	ETF	42.92	43.52	42.88	43.51	101620781.0
2009-11-09	IWM	ETF	58.59	59.27	58.55	59.22	49200200.0
2009-11-09	DIA	ETF	101.07	102.44	100.91	102.42	10959900.0
2009-11-09	GLD	ETF	108.69	108.75	107.91	108.19	18444800.0
2009-11-09	TLT	ETF	93.28	93.7	93.13	93.44	1697800.0
2009-11-09	AAXJ	ETF	54.24	55.0	54.04	55.0	174200.0
2009-11-09	ACWI	ETF	42.0	42.4	41.86	42.4	87000.0
2009-11-09	ACWX	ETF	41.05	41.42	40.9	41.4	186813.0
2009-11-09	ADRE	ETF	43.42	44.426	43.42	44.41	194734.0
2009-11-09	AFK	ETF	29.0	29.12	28.77	29.09	18746.0
2009-11-09	AGG	ETF	104.45	104.57	104.35	104.51	509400.0
2009-11-09	AGQ	ETF	127.12	127.2	123.48	125.1	227700.0
2009-11-09	AGZ	ETF	108.36	108.45	108.198	108.44	18177.0
2009-11-09	AIA	ETF	39.04	39.4964	39.04	39.47	34435.0
2009-11-09	AIQ	ETF	27.0	27.35	26.45	27.0	58608.0
2009-11-09	AIS	ETF	1.17	1.18	1.11	1.11	516045.0
2009-11-09	AIVI	ETF	43.59	44.01	43.59	43.96	21000.0
2009-11-09	AMJ	ETF	26.54	26.6	26.0	26.58	149752.0
2009-11-09	AOA	ETF	29.39	29.54	29.39	29.53	7900.0
2009-11-09	AOK	ETF	27.5	27.5	27.26	27.31	9575.0
2009-11-09	AOM	ETF	27.78	28.17	27.78	28.17	26256.0
2009-11-09	AOR	ETF	28.83	28.87	28.5701	28.87	23482.0
2009-11-09	ARB	ETF	22.54	22.981	22.44	22.94	209674.0
2009-11-09	BAL	ETF	35.13	35.24	35.08	35.15	16886.0
2009-11-09	BBH	ETF	31.9567	32.0867	31.8067	32.0867	135600.0
2009-11-09	BIL	ETF	91.74	91.76	91.74	91.76	161150.0
2009-11-09	BITS	ETF	27.88	27.88	27.0268	27.76	1585.0
2009-11-09	BIV	ETF	80.07	80.3	80.01	80.25	132100.0
2009-11-09	BJK	ETF	24.9	25.65	24.9	25.33	8100.0
2009-11-09	BKF	ETF	46.1	46.6532	45.88	46.63	283007.0
2009-11-09	BLV	ETF	77.52	77.52	76.95	77.18	49600.0
2009-11-09	BMVP	ETF	12.11	12.3	12.11	12.3	18997.0
2009-11-09	BND	ETF	79.19	79.25	79.13	79.24	335200.0
2009-11-09	BNE	ETF	7.08	7.14	6.73	6.82	177073.0
2009-11-09	BOSS	ETF	18.8	19.0	18.8	19.0	200.0
2009-11-09	BRF	ETF	45.96	46.96	45.96	46.76	542786.0
2009-11-09	BSV	ETF	80.0	80.0	79.9	79.99	290200.0
2009-11-09	BTF	ETF	62.449999999999996	63.3	62.449999999999996	62.85	8808.800000000001
2009-11-09	BWX	ETF	29.56	29.685	29.54	29.665	550538.0
2009-11-09	BWZ	ETF	37.565	37.81	37.56	37.68	49845.0
2009-11-09	BZQ	ETF	3960.0	3968.0	3766.4	3835.2	739.5
2009-11-09	CEF	ETF	14.38	14.38	14.11	14.15	1670200.0
2009-11-09	CEW	ETF	22.18	22.26	22.156	22.24	107487.0
2009-11-09	CGO	ETF	13.58	13.73	13.45	13.67	99018.0
2009-11-09	CGW	ETF	17.81	18.1599	17.81	18.11	94731.0
2009-11-09	CHB	ETF	0.22	0.23	0.1939	0.2	2798183.0
2009-11-09	CHI	ETF	12.1	12.166	12.0	12.05	155106.0
2009-11-09	CHW	ETF	7.56	7.66	7.56	7.62	232017.0
2009-11-09	CHY	ETF	11.62	11.69	11.53	11.53	187285.0

> showing 50 of 683 rows — these rows as CSV

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