PREVIEW / etf_daily / 2009-10-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-09.parquet
  size:    29 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-09	SPY	ETF	106.64	107.26	106.36	107.26	135008300.0
2009-10-09	QQQ	ETF	42.15	42.55	42.06	42.48	62827992.0
2009-10-09	IWM	ETF	60.85	61.51	60.67	61.42	34597000.0
2009-10-09	DIA	ETF	97.87	98.72	97.69	98.69	6494100.0
2009-10-09	GLD	ETF	103.06	103.25	102.37	102.84	15177500.0
2009-10-09	TLT	ETF	97.62	97.71	95.5	95.9	8135900.0
2009-10-09	AAXJ	ETF	53.02	53.5	52.94	53.5	353400.0
2009-10-09	ACWI	ETF	41.27	41.39	41.16	41.39	48900.0
2009-10-09	ACWX	ETF	40.27	40.37	40.13	40.37	60277.0
2009-10-09	ADRE	ETF	42.46	42.5	42.22	42.45	168203.0
2009-10-09	AFK	ETF	29.69	29.9	29.44	29.9	10129.0
2009-10-09	AGG	ETF	104.68	104.71	104.15	104.16	567500.0
2009-10-09	AGQ	ETF	129.12	130.58	126.96	129.08	228500.0
2009-10-09	AGZ	ETF	108.45	108.905	108.28	108.28	24859.0
2009-10-09	AIA	ETF	38.59	38.74	38.53	38.61	18643.0
2009-10-09	AIQ	ETF	31.15	31.45	31.0	31.25	22181.0
2009-10-09	AIS	ETF	1.13	1.13	1.09	1.12	414428.0
2009-10-09	AIVI	ETF	42.75	42.8	42.44	42.68	16100.0
2009-10-09	AMJ	ETF	25.58	25.65	25.51	25.6	193497.0
2009-10-09	AOA	ETF	29.3	29.31	29.18	29.31	3400.0
2009-10-09	AOK	ETF	27.02	27.16	27.02	27.13	12625.0
2009-10-09	AOM	ETF	27.86	27.86	27.8	27.86	7073.0
2009-10-09	AOR	ETF	28.48	28.52	28.43	28.4704	6232.0
2009-10-09	ARB	ETF	21.77	22.0	21.6	21.68	164023.0
2009-10-09	BAL	ETF	33.0	33.0976	32.74	32.77	4614.0
2009-10-09	BBH	ETF	33.0067	33.4833	33.0067	33.2933	238200.0
2009-10-09	BIL	ETF	91.72	91.74	91.7	91.72	228900.0
2009-10-09	BITS	ETF	22.16	22.16	21.6	22.08	1056.0
2009-10-09	BIV	ETF	80.38	80.48	79.74	79.76	144000.0
2009-10-09	BJK	ETF	26.45	26.46	26.04	26.16	12500.0
2009-10-09	BKF	ETF	43.73	43.92	43.46	43.91	685963.0
2009-10-09	BLV	ETF	79.34	79.39	77.94	78.06	106500.0
2009-10-09	BMVP	ETF	12.0833	12.1704	12.08	12.1704	151252.0
2009-10-09	BND	ETF	79.43	79.43	79.0	79.01	1349300.0
2009-10-09	BNE	ETF	7.8	7.81	7.67	7.79	93072.0
2009-10-09	BOSS	ETF	21.2	21.6	21.2	21.6	100.0
2009-10-09	BRF	ETF	43.46	43.67	43.12	43.56	688869.0
2009-10-09	BSV	ETF	79.96	79.99	79.82	79.9	211200.0
2009-10-09	BTF	ETF	60.199999999999996	60.9	59.85	60.25	12986.6
2009-10-09	BWX	ETF	29.5	29.5	29.28	29.345	205396.0
2009-10-09	BWZ	ETF	37.5399	37.54	37.3458	37.35	11901.0
2009-10-09	BZQ	ETF	4704.0	4704.0	4638.4	4638.4	14.5
2009-10-09	CEF	ETF	13.71	13.71	13.37	13.65	916000.0
2009-10-09	CEW	ETF	21.93	22.03	21.8475	21.91	69249.0
2009-10-09	CGO	ETF	14.24	14.29	14.19	14.25	12400.0
2009-10-09	CGW	ETF	17.69	17.75	17.56	17.75	69421.0
2009-10-09	CHB	ETF	0.44	0.47	0.43	0.4398	2317915.0
2009-10-09	CHI	ETF	11.83	11.96	11.83	11.86	115749.0
2009-10-09	CHIC	ETF	17.48	17.5	17.47	17.49	215471.0
2009-10-09	CHW	ETF	7.89	7.9	7.75	7.84	152161.0

> showing 50 of 674 rows — these rows as CSV

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