PREVIEW / etf_daily / 2009-10-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-07.parquet
  size:    29 KB
  rows:    671

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-10-07	SPY	ETF	105.27	105.91	105.07	105.8	159200300.0
2009-10-07	QQQ	ETF	41.88	42.08	41.77	42.06	93787522.0
2009-10-07	IWM	ETF	59.98	60.41	59.85	60.16	35534000.0
2009-10-07	DIA	ETF	97.13	97.48	96.83	97.28	10039900.0
2009-10-07	GLD	ETF	102.29	102.52	101.83	102.36	16194200.0
2009-10-07	TLT	ETF	98.67	99.33	98.6	99.19	3591000.0
2009-10-07	AAXJ	ETF	52.95	53.03	52.65	52.88	93700.0
2009-10-07	ACWI	ETF	40.79	40.83	40.51	40.81	291800.0
2009-10-07	ACWX	ETF	39.52	39.76	39.44	39.74	25547.0
2009-10-07	ADRE	ETF	41.71	41.76	41.28	41.76	115836.0
2009-10-07	AFK	ETF	29.01	29.16	28.83	29.1363	5766.0
2009-10-07	AGG	ETF	104.86	105.06	104.78	104.96	531500.0
2009-10-07	AGQ	ETF	124.36	127.3	123.24	126.74	298250.0
2009-10-07	AGZ	ETF	108.8	108.92	108.629	108.87	19151.0
2009-10-07	AIA	ETF	38.01	38.038	37.82	38.03	15269.0
2009-10-07	AIQ	ETF	30.35	31.15	29.5	30.9	106760.0
2009-10-07	AIS	ETF	1.11	1.13	1.08	1.1	314274.0
2009-10-07	AIVI	ETF	41.98	42.3	41.96	42.3	13600.0
2009-10-07	AMJ	ETF	25.3	25.3	25.147	25.22	146466.0
2009-10-07	AOA	ETF	28.95	28.95	28.75	28.87	5000.0
2009-10-07	AOK	ETF	27.13	27.14	27.0401	27.14	24670.0
2009-10-07	AOM	ETF	27.76	27.8	27.67	27.8	3550.0
2009-10-07	AOR	ETF	28.28	28.31	28.2728	28.31	3642.0
2009-10-07	ARB	ETF	21.63	21.83	21.37	21.74	118856.0
2009-10-07	BAL	ETF	32.75	32.75	32.43	32.68	6489.0
2009-10-07	BBH	ETF	33.0967	33.3367	33.0267	33.1133	143700.0
2009-10-07	BIL	ETF	91.7	91.74	91.7	91.74	106550.0
2009-10-07	BITS	ETF	21.4	22.16	20.0804	21.744	4489.0
2009-10-07	BIV	ETF	80.64	80.96	80.61	80.87	114100.0
2009-10-07	BJK	ETF	26.13	26.13	25.66	25.8	13400.0
2009-10-07	BKF	ETF	42.66	42.94	42.49	42.64	186761.0
2009-10-07	BLV	ETF	79.88	80.12	79.56	80.12	80200.0
2009-10-07	BMVP	ETF	11.9367	12.0004	11.9367	11.9967	21180.0
2009-10-07	BND	ETF	79.64	79.66	79.53	79.62	802700.0
2009-10-07	BNE	ETF	7.87	7.94	7.7	7.76	73064.0
2009-10-07	BRF	ETF	42.15	42.59	42.0	42.45	1181065.0
2009-10-07	BSV	ETF	80.07	80.13	79.93	80.08	245800.0
2009-10-07	BTF	ETF	59.4	59.599999999999994	59.165	59.4	2240.0
2009-10-07	BWX	ETF	29.4	29.435	29.29	29.385	671918.0
2009-10-07	BWZ	ETF	37.44	37.44	37.11	37.37	19506.0
2009-10-07	BZQ	ETF	5040.0	5070.4	4963.2	4963.2	20.0
2009-10-07	CEF	ETF	13.6	13.7	13.5	13.57	984500.0
2009-10-07	CEW	ETF	21.83	21.92	21.8	21.86	124941.0
2009-10-07	CGO	ETF	14.02	14.2999	14.014	14.23	20561.0
2009-10-07	CGW	ETF	17.4	17.51	17.38	17.42	50564.0
2009-10-07	CHB	ETF	0.42	0.439	0.41	0.42	1378053.0
2009-10-07	CHI	ETF	11.77	11.9	11.77	11.85	158476.0
2009-10-07	CHIC	ETF	17.5	17.5	17.48	17.5	229509.0
2009-10-07	CHW	ETF	7.7	7.79	7.63	7.79	136278.0
2009-10-07	CHY	ETF	11.48	11.51	11.42	11.45	127512.0

> showing 50 of 671 rows — these rows as CSV

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