PREVIEW / etf_daily / 2009-12-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-07.parquet
  size:    30 KB
  rows:    695

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-12-07	SPY	ETF	110.91	111.53	110.49	110.84	127973800.0
2009-12-07	QQQ	ETF	44.08	44.29	43.82	43.91	67471808.0
2009-12-07	IWM	ETF	60.41	60.84	60.11	60.51	55543100.0
2009-12-07	DIA	ETF	103.83	104.53	103.69	104.05	8189500.0
2009-12-07	GLD	ETF	111.51	114.22	111.44	113.11	42538700.0
2009-12-07	TLT	ETF	93.27	93.74	93.09	93.46	2774200.0
2009-12-07	AAXJ	ETF	56.38	56.39	55.93	56.19	75000.0
2009-12-07	ACWI	ETF	42.49	42.81	42.42	42.54	70100.0
2009-12-07	ACWX	ETF	41.39	41.7	41.3699	41.4	77446.0
2009-12-07	ADRE	ETF	44.85	45.07	44.59	44.66	102777.0
2009-12-07	AFK	ETF	28.12	29.02	28.12	28.8299	9592.0
2009-12-07	AGG	ETF	104.86	105.0	104.75	104.92	558200.0
2009-12-07	AGQ	ETF	128.94	134.18	127.38	131.58	370350.0
2009-12-07	AGZ	ETF	108.47	108.72	108.4622	108.67	7121.0
2009-12-07	AIA	ETF	39.98	40.09	39.8699	39.9099	18669.0
2009-12-07	AIQ	ETF	29.5	29.5	29.25	29.45	16819.0
2009-12-07	AIS	ETF	1.15	1.15	1.1	1.12	371510.0
2009-12-07	AIVI	ETF	44.36	44.78	44.03	44.41	43500.0
2009-12-07	AMJ	ETF	27.0	27.49	26.7906	26.93	270043.0
2009-12-07	AOA	ETF	30.08	30.08	29.69	29.76	1700.0
2009-12-07	AOK	ETF	27.51	27.55	27.47	27.51	11416.0
2009-12-07	AOM	ETF	28.52	28.52	28.3276	28.37	6364.0
2009-12-07	AOR	ETF	29.1	29.1	29.027	29.05	8703.0
2009-12-07	ARB	ETF	21.96	22.38	21.96	22.19	245338.0
2009-12-07	BAB	ETF	24.7	24.74	24.63	24.7	79838.0
2009-12-07	BAL	ETF	36.281	36.685	36.17	36.685	6221.0
2009-12-07	BBH	ETF	32.6967	32.9533	32.5633	32.6233	71400.0
2009-12-07	BIL	ETF	91.7	91.74	91.7	91.7	98500.0
2009-12-07	BITS	ETF	26.64	27.48	26.64	26.76	1160.0
2009-12-07	BIV	ETF	80.51	80.68	80.25	80.63	156200.0
2009-12-07	BJK	ETF	24.91	24.92	24.43	24.46	20900.0
2009-12-07	BKF	ETF	46.61	46.9	46.36	46.43	227106.0
2009-12-07	BLV	ETF	77.91	77.91	77.39	77.74	35900.0
2009-12-07	BMVP	ETF	12.3367	12.4431	12.3367	12.3733	12297.0
2009-12-07	BND	ETF	79.46	79.62	79.39	79.58	482200.0
2009-12-07	BNE	ETF	6.4	6.45	6.3	6.36	145103.0
2009-12-07	BRF	ETF	48.8	49.579	48.66	49.02	336713.0
2009-12-07	BSV	ETF	80.18	80.29	80.05	80.29	451000.0
2009-12-07	BTF	ETF	62.8	63.25	62.8	63.2	3751.4
2009-12-07	BWX	ETF	29.61	29.815	29.535	29.675	348992.0
2009-12-07	BWZ	ETF	37.51	37.67	37.44	37.58	38322.0
2009-12-07	BZQ	ETF	3688.0	3732.8	3560.0	3694.4	269.5
2009-12-07	CEF	ETF	14.35	14.53	13.93	14.4	3637000.0
2009-12-07	CEW	ETF	22.3	22.35	22.22	22.3028	63707.0
2009-12-07	CGO	ETF	14.2	14.31	14.01	14.01	17587.0
2009-12-07	CGW	ETF	18.62	18.79	18.5	18.61	160398.0
2009-12-07	CHI	ETF	12.14	12.2	12.05	12.1	122280.0
2009-12-07	CHII	ETF	19.55	19.55	16.31	16.35	332085.0
2009-12-07	CHIQ	ETF	16.63	18.48	16.56	16.58	162666.0
2009-12-07	CHW	ETF	7.73	7.75	7.64	7.68	217739.0

> showing 50 of 695 rows — these rows as CSV

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