PREVIEW / etf_daily / 2009-11-30

all etf daily files

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

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-30	SPY	ETF	109.48	110.2	108.12	109.94	160874800.0
2009-11-30	QQQ	ETF	43.41	43.62	43.11	43.56	84819373.0
2009-11-30	IWM	ETF	57.65	58.25	56.86	58.09	77936900.0
2009-11-30	DIA	ETF	103.11	103.74	102.71	103.58	11959000.0
2009-11-30	GLD	ETF	114.48	115.89	114.27	115.64	16421000.0
2009-11-30	TLT	ETF	96.2	96.73	96.0	96.63	3115800.0
2009-11-30	AAXJ	ETF	54.42	54.63	54.0	54.55	417600.0
2009-11-30	ACWI	ETF	41.85	42.03	41.51	41.79	442400.0
2009-11-30	ACWX	ETF	40.6	40.81	40.28	40.59	72837.0
2009-11-30	ADRE	ETF	44.01	44.19	43.62	43.99	167949.0
2009-11-30	AFK	ETF	28.38	28.56	27.7	28.1	16274.0
2009-11-30	AGG	ETF	105.63	105.83	105.34	105.83	632700.0
2009-11-30	AGQ	ETF	132.28	137.34	131.56	136.74	351600.0
2009-11-30	AGZ	ETF	109.36	109.43	109.05	109.43	6857.0
2009-11-30	AIA	ETF	38.57	38.66	38.31	38.6	46054.0
2009-11-30	AIQ	ETF	28.6	29.6	28.6	29.6	24172.0
2009-11-30	AIS	ETF	1.12	1.12	1.1	1.12	91899.0
2009-11-30	AIVI	ETF	43.56	43.85	43.02	43.58	23700.0
2009-11-30	AMJ	ETF	26.88	26.9	26.7	26.77	201828.0
2009-11-30	AOA	ETF	29.28	29.34	29.11	29.34	8400.0
2009-11-30	AOK	ETF	27.4023	27.49	27.4	27.49	12352.0
2009-11-30	AOM	ETF	28.17	28.25	28.0775	28.25	13427.0
2009-11-30	AOR	ETF	28.73	28.8	28.57	28.8	10452.0
2009-11-30	ARB	ETF	22.01	22.17	21.15	21.53	213691.0
2009-11-30	BAB	ETF	25.0	25.15	24.95	25.13	30604.0
2009-11-30	BAL	ETF	36.56	36.59	36.27	36.54	5634.0
2009-11-30	BBH	ETF	32.5067	32.6067	32.3333	32.43	56700.0
2009-11-30	BIL	ETF	91.7	91.76	91.7	91.72	271800.0
2009-11-30	BITS	ETF	27.96	28.0	27.4	27.4	750.0
2009-11-30	BIV	ETF	81.52	81.71	81.25	81.71	90600.0
2009-11-30	BJK	ETF	24.46	24.58	24.16	24.38	5300.0
2009-11-30	BKF	ETF	45.35	45.78	45.16	45.62	438647.0
2009-11-30	BLV	ETF	78.78	79.25	78.78	79.25	51800.0
2009-11-30	BMVP	ETF	12.12	12.18	12.06	12.18	11789.0
2009-11-30	BND	ETF	80.33	80.33	80.22	80.25	373600.0
2009-11-30	BNE	ETF	5.98	6.06	5.64	6.06	212941.0
2009-11-30	BOSS	ETF	19.0	19.0	19.0	19.0	100.0
2009-11-30	BRF	ETF	46.97	47.69	46.8	47.49	485854.0
2009-11-30	BSV	ETF	80.6	80.68	80.56	80.56	533800.0
2009-11-30	BTF	ETF	63.49999999999999	63.89999999999999	62.705999999999996	63.449999999999996	1494.4
2009-11-30	BWX	ETF	30.065	30.2	30.025	30.135	420126.0
2009-11-30	BWZ	ETF	38.08	38.19	38.0	38.18	39309.0
2009-11-30	BZQ	ETF	3860.8	3913.6	3811.2	3817.6	666.0
2009-11-30	CEF	ETF	14.5	14.82	14.47	14.81	1623000.0
2009-11-30	CEW	ETF	22.16	22.23	22.09	22.15	46447.0
2009-11-30	CGO	ETF	13.69	13.74	13.68	13.74	14038.0
2009-11-30	CGW	ETF	18.07	18.17	17.916	18.17	76820.0
2009-11-30	CHI	ETF	11.88	12.0	11.78	11.97	293692.0
2009-11-30	CHW	ETF	7.66	7.72	7.63	7.7	185253.0
2009-11-30	CHY	ETF	11.15	11.25	11.04	11.23	287854.0

> showing 50 of 690 rows — these rows as CSV

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