PREVIEW / etf_daily / 2009-11-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-18.parquet
  size:    30 KB
  rows:    688

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-11-18	SPY	ETF	111.26	111.43	110.57	111.27	156486800.0
2009-11-18	QQQ	ETF	44.47	44.49	44.05	44.353	100240791.0
2009-11-18	IWM	ETF	60.35	60.38	59.6	60.16	54309000.0
2009-11-18	DIA	ETF	104.5	104.62	103.91	104.55	7773400.0
2009-11-18	GLD	ETF	112.69	113.09	111.8	112.25	22336900.0
2009-11-18	TLT	ETF	95.44	95.53	94.74	94.97	2413600.0
2009-11-18	AAXJ	ETF	56.38	56.39	55.67	55.89	142100.0
2009-11-18	ACWI	ETF	42.89	42.91	42.55	42.91	117700.0
2009-11-18	ACWX	ETF	41.81	41.86	41.44	41.75	184392.0
2009-11-18	ADRE	ETF	45.11	45.2497	44.61	44.84	136275.0
2009-11-18	AFK	ETF	28.77	29.0	28.48	28.48	10109.0
2009-11-18	AGG	ETF	105.19	105.36	104.9	105.02	528100.0
2009-11-18	AGQ	ETF	142.06	142.96	136.3	138.66	358450.0
2009-11-18	AGZ	ETF	108.76	108.906	108.6201	108.78	17534.0
2009-11-18	AIA	ETF	40.04	40.24	39.91	40.12	37614.0
2009-11-18	AIQ	ETF	28.15	29.25	28.05	28.7	58039.0
2009-11-18	AIS	ETF	1.14	1.14	1.11	1.13	109374.0
2009-11-18	AIVI	ETF	45.01	45.11	44.59	44.82	53200.0
2009-11-18	AMJ	ETF	27.0	27.0	26.81	26.88	169065.0
2009-11-18	AOA	ETF	29.82	29.86	29.78	29.86	13400.0
2009-11-18	AOK	ETF	27.5101	27.61	27.5101	27.55	19112.0
2009-11-18	AOM	ETF	28.36	28.42	28.3475	28.42	12900.0
2009-11-18	AOR	ETF	29.2	29.2	29.03	29.12	13280.0
2009-11-18	ARB	ETF	22.27	22.62	22.2	22.55	382001.0
2009-11-18	BAB	ETF	24.93	24.93	24.82	24.85	77481.0
2009-11-18	BAL	ETF	35.7001	35.8699	35.555	35.7499	5387.0
2009-11-18	BBH	ETF	32.46	32.5333	32.1833	32.39	110700.0
2009-11-18	BIL	ETF	91.72	91.74	91.7	91.7	110500.0
2009-11-18	BITS	ETF	27.4	27.4	26.8004	27.2	2294.0
2009-11-18	BIV	ETF	80.96	80.96	80.62	80.75	151800.0
2009-11-18	BJK	ETF	25.85	26.0	25.45	25.62	14800.0
2009-11-18	BKF	ETF	47.7	47.7	46.89	46.9	262082.0
2009-11-18	BLV	ETF	78.41	78.41	77.75	77.97	64400.0
2009-11-18	BMVP	ETF	12.5	12.5	12.37	12.42	16758.0
2009-11-18	BND	ETF	79.78	79.78	79.62	79.71	660800.0
2009-11-18	BNE	ETF	6.69	6.7	5.79	6.09	452247.0
2009-11-18	BOSS	ETF	19.82	19.82	19.38	19.38	1000.0
2009-11-18	BRF	ETF	47.92	48.09	46.65	47.17	368431.0
2009-11-18	BSV	ETF	80.32	80.32	80.21	80.3	343200.0
2009-11-18	BTF	ETF	63.849999999999994	64.35	63.550000000000004	64.05	3435.6000000000004
2009-11-18	BWX	ETF	29.875	29.875	29.732	29.8	378278.0
2009-11-18	BWZ	ETF	37.87	37.98	37.807	37.88	22549.0
2009-11-18	BZQ	ETF	3683.2	3932.8	3683.2	3849.6	286.0
2009-11-18	CEF	ETF	14.29	14.3	14.11	14.2	1420600.0
2009-11-18	CEW	ETF	22.38	22.39	22.282	22.32	51042.0
2009-11-18	CGO	ETF	14.14	14.14	14.02	14.102	16834.0
2009-11-18	CGW	ETF	18.46	18.46	18.199	18.37	54031.0
2009-11-18	CHI	ETF	12.08	12.13	11.93	12.1199	181163.0
2009-11-18	CHW	ETF	7.54	7.65	7.51	7.6	261847.0
2009-11-18	CHY	ETF	11.58	11.75	11.52	11.73	174098.0

> showing 50 of 688 rows — these rows as CSV

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