PREVIEW / etf_daily / 2009-10-05

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-05.parquet
  size:    30 KB
  rows:    674

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-05	SPY	ETF	102.9	104.32	102.6	104.02	149875000.0
2009-10-05	QQQ	ETF	41.09	41.4	40.83	41.21	97054125.0
2009-10-05	IWM	ETF	58.31	59.29	58.08	59.04	48919600.0
2009-10-05	DIA	ETF	95.07	96.28	94.8	95.97	8742700.0
2009-10-05	GLD	ETF	98.48	99.84	98.36	99.82	11709400.0
2009-10-05	TLT	ETF	99.47	99.66	98.77	99.02	2910100.0
2009-10-05	AAXJ	ETF	51.74	52.25	51.43	52.06	327000.0
2009-10-05	ACWI	ETF	39.64	40.06	39.52	40.0	55100.0
2009-10-05	ACWX	ETF	38.4	39.03	38.4	38.98	23526.0
2009-10-05	ADRE	ETF	40.58	41.22	40.36	41.08	107219.0
2009-10-05	AFK	ETF	28.5	29.05	28.5	29.05	10432.0
2009-10-05	AGG	ETF	104.82	104.95	104.65	104.69	666900.0
2009-10-05	AGQ	ETF	108.46	114.4	107.68	114.14	188550.0
2009-10-05	AGZ	ETF	108.5001	108.89	108.5	108.8	9099.0
2009-10-05	AIA	ETF	37.37	37.87	37.3414	37.7	28613.0
2009-10-05	AIQ	ETF	28.55	29.75	27.9	29.6	97599.0
2009-10-05	AIS	ETF	1.1	1.14	1.08	1.12	344865.0
2009-10-05	AIVI	ETF	40.86	41.46	40.22	41.33	21000.0
2009-10-05	AMJ	ETF	24.64	24.98	24.62	24.96	213401.0
2009-10-05	AOA	ETF	28.38	28.54	28.34	28.51	5900.0
2009-10-05	AOK	ETF	26.97	27.0	26.8601	27.0	8119.0
2009-10-05	AOM	ETF	27.42	27.56	27.42	27.56	5821.0
2009-10-05	AOR	ETF	27.93	28.01	27.8655	27.98	7431.0
2009-10-05	ARB	ETF	21.1	21.68	20.93	21.25	227041.0
2009-10-05	BAL	ETF	31.71	32.02	31.69	31.832	933.0
2009-10-05	BBH	ETF	32.9067	33.1333	32.6933	32.9533	121200.0
2009-10-05	BIL	ETF	91.72	91.74	91.7	91.74	133750.0
2009-10-05	BITS	ETF	21.4	21.52	21.04	21.48	3237.0
2009-10-05	BIV	ETF	80.75	80.75	80.42	80.7	135100.0
2009-10-05	BJK	ETF	24.77	25.89	24.77	25.89	23800.0
2009-10-05	BKF	ETF	41.2	42.1	41.17	42.09	150510.0
2009-10-05	BLV	ETF	80.13	80.2	79.76	80.0	62100.0
2009-10-05	BMVP	ETF	11.65	11.84	11.65	11.8	18796.0
2009-10-05	BND	ETF	79.61	79.61	79.42	79.49	465500.0
2009-10-05	BNE	ETF	7.28	7.7901	7.19	7.5	302096.0
2009-10-05	BOSS	ETF	20.58	20.58	20.5	20.5	100.0
2009-10-05	BRF	ETF	40.06	41.11	39.842	41.02	890740.0
2009-10-05	BSV	ETF	80.19	80.32	80.02	80.18	418600.0
2009-10-05	BTF	ETF	58.099999999999994	59.196999999999996	58.099999999999994	58.849999999999994	4381.400000000001
2009-10-05	BWX	ETF	29.26	29.335	29.185	29.235	309398.0
2009-10-05	BWZ	ETF	37.17	37.27	37.134	37.25	13089.0
2009-10-05	BZQ	ETF	5312.0	5318.4	5052.8	5059.2	71.0
2009-10-05	CEF	ETF	12.75	13.09	12.67	12.98	939100.0
2009-10-05	CEW	ETF	21.69	21.9	21.677	21.78	75148.0
2009-10-05	CGO	ETF	13.73	14.0372	13.71	13.95	32758.0
2009-10-05	CGW	ETF	17.1	17.3	17.0253	17.27	69117.0
2009-10-05	CHB	ETF	0.433	0.45	0.41	0.415	1672463.0
2009-10-05	CHI	ETF	11.51	11.92	11.51	11.9	216283.0
2009-10-05	CHIC	ETF	17.5	17.51	17.49	17.51	190645.0
2009-10-05	CHW	ETF	7.52	7.67	7.49	7.65	184359.0

> showing 50 of 674 rows — these rows as CSV

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