PREVIEW / etf_daily / 2009-11-27

all etf daily files

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

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-27	SPY	ETF	108.4	110.32	108.29	109.57	126001800.0
2009-11-27	QQQ	ETF	43.0	43.83	42.9	43.51	61229930.0
2009-11-27	IWM	ETF	57.15	58.67	57.04	57.58	51862100.0
2009-11-27	DIA	ETF	102.46	103.84	102.23	103.18	12916100.0
2009-11-27	GLD	ETF	113.08	115.81	113.02	115.06	21234400.0
2009-11-27	TLT	ETF	96.4	96.56	96.09	96.4	2249100.0
2009-11-27	AAXJ	ETF	54.0	54.45	53.2	53.98	145200.0
2009-11-27	ACWI	ETF	41.1	42.01	41.08	41.75	61000.0
2009-11-27	ACWX	ETF	40.02	40.73	39.67	40.4	36792.0
2009-11-27	ADRE	ETF	43.01	44.28	42.9001	43.87	170907.0
2009-11-27	AFK	ETF	28.07	28.81	28.0	28.788	5739.0
2009-11-27	AGG	ETF	105.31	105.65	105.3	105.65	182500.0
2009-11-27	AGQ	ETF	128.76	137.06	128.68	133.96	446900.0
2009-11-27	AGZ	ETF	109.16	109.28	109.16	109.28	3144.0
2009-11-27	AIA	ETF	38.14	39.01	37.84	38.46	71177.0
2009-11-27	AIQ	ETF	28.9	29.45	28.7	28.7	19325.0
2009-11-27	AIS	ETF	1.11	1.14	1.09	1.1	204070.0
2009-11-27	AIVI	ETF	43.02	43.96	42.97	43.6	20200.0
2009-11-27	AMJ	ETF	26.66	26.89	25.39	26.84	115343.0
2009-11-27	AOA	ETF	28.89	29.39	28.89	29.35	8300.0
2009-11-27	AOK	ETF	27.25	27.49	27.25	27.47	14400.0
2009-11-27	AOM	ETF	27.89	28.24	27.89	28.12	16876.0
2009-11-27	AOR	ETF	28.54	28.8	28.34	28.71	16047.0
2009-11-27	ARB	ETF	21.94	22.63	21.52	22.1	80169.0
2009-11-27	BAB	ETF	25.1	25.11	25.088	25.1	17262.0
2009-11-27	BAL	ETF	35.9701	36.32	35.9701	36.28	16265.0
2009-11-27	BBH	ETF	32.5467	32.8067	32.04	32.5567	64200.0
2009-11-27	BIL	ETF	91.72	91.72	91.7	91.72	14150.0
2009-11-27	BITS	ETF	27.6	28.0	27.38	27.6	725.0
2009-11-27	BIV	ETF	81.5	81.54	81.26	81.54	22000.0
2009-11-27	BJK	ETF	24.65	24.74	24.23	24.73	19900.0
2009-11-27	BKF	ETF	44.55	45.81	44.0	45.438	323926.0
2009-11-27	BLV	ETF	78.32	79.0	78.32	79.0	7200.0
2009-11-27	BMVP	ETF	11.8833	12.214	11.62	12.1433	22842.0
2009-11-27	BND	ETF	80.29	80.29	80.11	80.29	117700.0
2009-11-27	BNE	ETF	5.67	6.16	5.63	6.06	96337.0
2009-11-27	BOSS	ETF	18.56	19.02	18.56	18.98	400.0
2009-11-27	BRF	ETF	46.23	47.25	45.69	46.83	361811.0
2009-11-27	BSV	ETF	80.65	80.65	80.33	80.61	86300.0
2009-11-27	BTF	ETF	63.75	63.949999999999996	63.099999999999994	63.89999999999999	1660.0
2009-11-27	BWX	ETF	29.885	30.02	29.825	29.955	243030.0
2009-11-27	BWZ	ETF	37.81	38.09	37.75	38.0	13558.0
2009-11-27	BZQ	ETF	4059.2	4062.4	3822.4	3918.4	318.0
2009-11-27	CEF	ETF	14.4	14.77	14.0	14.63	1532300.0
2009-11-27	CEW	ETF	22.12	22.2	22.0	22.16	46712.0
2009-11-27	CGO	ETF	13.49	13.68	13.49	13.67	10035.0
2009-11-27	CGW	ETF	17.95	18.2	17.77	18.1	74145.0
2009-11-27	CHI	ETF	11.82	11.95	11.68	11.9	66374.0
2009-11-27	CHW	ETF	7.59	7.7	7.56	7.62	84486.0
2009-11-27	CHY	ETF	11.1	11.2	10.97	11.19	215643.0

> showing 50 of 683 rows — these rows as CSV

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