PREVIEW / etf_daily / 2009-09-11

all etf daily files

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

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-09-11	SPY	ETF	104.99	105.3	104.28	104.77	152360100.0
2009-09-11	QQQ	ETF	41.5	41.62	41.22	41.52	93869374.0
2009-09-11	IWM	ETF	59.59	59.99	59.1	59.42	31718400.0
2009-09-11	DIA	ETF	96.37	96.63	95.86	96.22	8116500.0
2009-09-11	GLD	ETF	98.96	99.33	98.27	98.78	19499400.0
2009-09-11	TLT	ETF	96.82	97.68	96.6	96.7	4826200.0
2009-09-11	AAXJ	ETF	52.19	52.19	51.58	51.75	1141600.0
2009-09-11	ACWI	ETF	40.52	40.57	40.22	40.33	52000.0
2009-09-11	ACWX	ETF	39.69	39.72	39.39	39.528	37763.0
2009-09-11	ADRE	ETF	40.45	40.56	40.03	40.17	81258.0
2009-09-11	AFK	ETF	28.52	28.52	28.2449	28.3691	5910.0
2009-09-11	AGG	ETF	104.31	104.47	104.14	104.24	447500.0
2009-09-11	AGQ	ETF	119.72	120.48	115.66	117.68	277300.0
2009-09-11	AGZ	ETF	108.18	108.88	108.18	108.6	16519.0
2009-09-11	AIA	ETF	38.04	38.04	37.76	37.846	29089.0
2009-09-11	AIQ	ETF	28.05	28.45	27.6	27.85	32233.0
2009-09-11	AIS	ETF	1.19	1.19	1.08	1.13	1248100.0
2009-09-11	AIVI	ETF	42.73	42.79	42.32	42.53	28800.0
2009-09-11	AMJ	ETF	24.4	24.59	24.33	24.59	208959.0
2009-09-11	AOA	ETF	28.54	28.85	28.54	28.67	2300.0
2009-09-11	AOK	ETF	27.29	27.29	26.59	26.9697	24529.0
2009-09-11	AOM	ETF	28.15	28.15	27.6394	27.65	6559.0
2009-09-11	AOR	ETF	28.41	30.16	28.16	28.22	19394.0
2009-09-11	ARB	ETF	18.13	18.46	17.94	18.41	159541.0
2009-09-11	BAL	ETF	31.86	32.2	31.85	31.85	3200.0
2009-09-11	BBH	ETF	33.59	33.5933	33.3	33.4767	81300.0
2009-09-11	BIL	ETF	91.7	91.72	91.7	91.7	211600.0
2009-09-11	BITS	ETF	21.16	21.28	20.88	21.0	2080.0
2009-09-11	BIV	ETF	80.05	80.2	79.8	80.1	228700.0
2009-09-11	BJK	ETF	25.93	25.93	25.4	25.58	15100.0
2009-09-11	BKF	ETF	40.69	40.719	40.2394	40.36	325710.0
2009-09-11	BLV	ETF	78.99	79.44	78.71	79.02	69400.0
2009-09-11	BMVP	ETF	11.96	11.97	11.89	11.91	13219.0
2009-09-11	BND	ETF	79.21	79.33	79.03	79.18	370000.0
2009-09-11	BNE	ETF	7.3	7.44	6.93	7.04	157428.0
2009-09-11	BRF	ETF	38.73	38.73	38.17	38.33	498487.0
2009-09-11	BSV	ETF	80.06	80.07	79.81	79.85	419400.0
2009-09-11	BTF	ETF	57.99999999999999	58.2	57.75	58.15	4230.8
2009-09-11	BWX	ETF	28.945	29.15	28.825	28.895	291062.0
2009-09-11	BWZ	ETF	37.06	37.16	37.0	37.08	18662.0
2009-09-11	BZQ	ETF	6176.0	6307.2	6176.0	6300.8	47.0
2009-09-11	CEF	ETF	13.23	13.41	13.05	13.2	1782400.0
2009-09-11	CEW	ETF	21.48	21.56	21.48	21.51	22490.0
2009-09-11	CGO	ETF	13.79	13.8	13.59	13.679	17561.0
2009-09-11	CGW	ETF	17.78	17.89	17.6	17.6788	67575.0
2009-09-11	CHB	ETF	0.49	0.49	0.46	0.47	1353453.0
2009-09-11	CHI	ETF	11.43	11.44	11.3	11.35	114731.0
2009-09-11	CHIC	ETF	17.45	17.46	17.43	17.43	598037.0
2009-09-11	CHW	ETF	7.5	7.5376	7.41	7.49	142228.0
2009-09-11	CHY	ETF	11.19	11.2	11.1	11.1	104530.0

> showing 50 of 675 rows — these rows as CSV

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