PREVIEW / etf_daily / 2009-10-29

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-29.parquet
  size:    30 KB
  rows:    679

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-29	SPY	ETF	105.19	106.86	104.94	106.65	198110600.0
2009-10-29	QQQ	ETF	41.68	42.19	41.54	42.09	85207518.0
2009-10-29	IWM	ETF	57.33	58.24	57.12	57.91	73615700.0
2009-10-29	DIA	ETF	98.34	99.74	98.05	99.54	12927200.0
2009-10-29	GLD	ETF	101.72	102.76	101.5	102.69	15322600.0
2009-10-29	TLT	ETF	94.82	95.06	93.95	94.41	4645300.0
2009-10-29	AAXJ	ETF	51.82	53.01	51.82	52.94	327000.0
2009-10-29	ACWI	ETF	40.41	41.13	40.26	41.07	97500.0
2009-10-29	ACWX	ETF	39.55	40.21	39.5	40.13	63821.0
2009-10-29	ADRE	ETF	40.9	42.33	40.9	42.18	410903.0
2009-10-29	AFK	ETF	28.79	28.82	28.35	28.64	35655.0
2009-10-29	AGG	ETF	104.53	104.57	104.29	104.41	590400.0
2009-10-29	AGQ	ETF	110.58	113.66	110.26	113.36	321900.0
2009-10-29	AGZ	ETF	108.53	108.582	108.228	108.27	6873.0
2009-10-29	AIA	ETF	37.67	38.4247	37.67	38.33	17734.0
2009-10-29	AIQ	ETF	25.95	28.55	25.8	27.2	116559.0
2009-10-29	AIS	ETF	1.1	1.12	1.07	1.1	419555.0
2009-10-29	AIVI	ETF	42.0	42.82	42.0	42.68	23000.0
2009-10-29	AMJ	ETF	25.5	26.07	25.25	26.02	156424.0
2009-10-29	AOA	ETF	28.71	28.91	28.67	28.91	5800.0
2009-10-29	AOK	ETF	27.01	27.09	27.01	27.06	2372.0
2009-10-29	AOM	ETF	27.61	27.77	27.58	27.762	13462.0
2009-10-29	AOR	ETF	28.12	28.32	28.12	28.28	7394.0
2009-10-29	ARB	ETF	21.97	21.97	21.37	21.76	470770.0
2009-10-29	BAL	ETF	35.0	35.2	34.93	34.9301	5725.0
2009-10-29	BBH	ETF	30.5	30.71	29.63	30.5533	370200.0
2009-10-29	BIL	ETF	91.72	91.76	91.7	91.72	210250.0
2009-10-29	BITS	ETF	24.64	24.88	23.08	24.88	4793.0
2009-10-29	BIV	ETF	80.03	80.06	79.64	79.9	116900.0
2009-10-29	BJK	ETF	23.64	24.29	23.64	24.17	58300.0
2009-10-29	BKF	ETF	42.81	44.4085	42.73	44.04	370381.0
2009-10-29	BLV	ETF	78.24	78.31	77.38	78.01	52700.0
2009-10-29	BMVP	ETF	11.81	12.01	11.79	11.99	37697.0
2009-10-29	BND	ETF	79.07	79.22	78.96	79.14	357900.0
2009-10-29	BNE	ETF	6.76	6.9	6.64	6.78	183538.0
2009-10-29	BOSS	ETF	20.59	21.0	20.59	20.59	100.0
2009-10-29	BRF	ETF	41.42	43.228	41.14	43.1	869879.0
2009-10-29	BSV	ETF	79.94	80.05	79.85	79.93	545500.0
2009-10-29	BTF	ETF	59.55	61.1	59.55	60.55	18837.0
2009-10-29	BWX	ETF	29.09	29.24	29.075	29.22	532002.0
2009-10-29	BWZ	ETF	37.07	37.368	37.07	37.316	72672.0
2009-10-29	BZQ	ETF	4942.4	4942.4	4368.0	4443.2	394.5
2009-10-29	CEF	ETF	13.15	13.45	13.15	13.39	1330700.0
2009-10-29	CEW	ETF	21.65	21.9	21.65	21.88	65640.0
2009-10-29	CGO	ETF	13.33	13.8297	13.304	13.82	28805.0
2009-10-29	CGW	ETF	17.28	17.62	17.25	17.5	48928.0
2009-10-29	CHB	ETF	0.2244	0.25	0.19	0.25	4257787.0
2009-10-29	CHI	ETF	11.33	11.7827	11.25	11.73	236853.0
2009-10-29	CHW	ETF	7.63	7.86	7.6	7.69	171452.0
2009-10-29	CHY	ETF	11.2	11.42	10.95	11.42	243241.0

> showing 50 of 679 rows — these rows as CSV

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