PREVIEW / etf_daily / 2009-12-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-15.parquet
  size:    30 KB
  rows:    698

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-15	SPY	ETF	111.46	111.92	111.0	111.35	120408800.0
2009-12-15	QQQ	ETF	44.41	44.67	44.17	44.3	61171042.0
2009-12-15	IWM	ETF	60.96	61.52	60.78	60.91	55378800.0
2009-12-15	DIA	ETF	104.91	105.15	104.47	104.74	7191500.0
2009-12-15	GLD	ETF	109.94	110.57	109.39	110.21	20059500.0
2009-12-15	TLT	ETF	91.57	92.0	91.49	91.79	2993900.0
2009-12-15	AAXJ	ETF	55.46	55.61	55.1	55.1	435300.0
2009-12-15	ACWI	ETF	42.17	42.42	42.1	42.16	229900.0
2009-12-15	ACWX	ETF	40.77	41.01	40.66	40.77	105678.0
2009-12-15	ADRE	ETF	44.33	44.62	44.17	44.262	75433.0
2009-12-15	AFK	ETF	28.44	28.5	27.93	28.07	13311.0
2009-12-15	AGG	ETF	104.45	104.56	104.36	104.39	475200.0
2009-12-15	AGQ	ETF	119.14	121.6	118.44	120.56	193200.0
2009-12-15	AGZ	ETF	108.31	108.35	108.13	108.31	6866.0
2009-12-15	AIA	ETF	39.65	39.67	39.36	39.47	46714.0
2009-12-15	AIQ	ETF	31.25	31.3	30.55	30.65	38655.0
2009-12-15	AIS	ETF	1.05	1.09	1.05	1.08	398502.0
2009-12-15	AIVI	ETF	43.62	43.95	43.55	43.7	26900.0
2009-12-15	AMJ	ETF	27.74	27.92	27.74	27.85	239598.0
2009-12-15	AOA	ETF	29.94	29.94	29.8	29.8	3100.0
2009-12-15	AOK	ETF	27.38	27.78	27.05	27.38	34486.0
2009-12-15	AOM	ETF	28.35	28.366	28.285	28.29	19615.0
2009-12-15	AOR	ETF	29.01	29.05	28.925	28.99	33769.0
2009-12-15	ARB	ETF	22.04	22.57	21.9	22.43	228520.0
2009-12-15	BAB	ETF	24.45	24.5199	24.41	24.46	109411.0
2009-12-15	BAL	ETF	37.26	37.31	36.71	36.76	5521.0
2009-12-15	BBH	ETF	32.7367	32.7367	32.24	32.3433	174300.0
2009-12-15	BIL	ETF	91.7	91.7	91.68	91.68	145100.0
2009-12-15	BITS	ETF	27.6	27.92	27.12	27.92	2032.0
2009-12-15	BIV	ETF	80.2	80.25	80.0	80.24	136300.0
2009-12-15	BJK	ETF	25.03	25.03	24.23	24.32	170300.0
2009-12-15	BKF	ETF	46.02	46.27	45.76	45.92	167066.0
2009-12-15	BLV	ETF	76.8	77.24	76.65	76.79	48000.0
2009-12-15	BMVP	ETF	12.5533	12.6519	12.54	12.58	17963.0
2009-12-15	BND	ETF	79.15	79.36	79.15	79.29	517200.0
2009-12-15	BNE	ETF	6.48	6.83	6.33	6.68	209979.0
2009-12-15	BRF	ETF	48.47	48.5994	47.89	48.14	386610.0
2009-12-15	BSV	ETF	80.12	80.15	80.03	80.14	300000.0
2009-12-15	BTF	ETF	63.3	63.65	63.15	63.2005	5932.0
2009-12-15	BWX	ETF	29.26	29.26	29.08	29.205	580014.0
2009-12-15	BWZ	ETF	37.14	37.16	37.0	37.07	32095.0
2009-12-15	BZQ	ETF	3702.4	3723.2	3638.4	3723.2	72.0
2009-12-15	CEF	ETF	13.7	13.95	13.7	13.76	1197100.0
2009-12-15	CEW	ETF	22.07	22.18	22.07	22.14	94115.0
2009-12-15	CGO	ETF	14.45	14.45	14.17	14.17	21400.0
2009-12-15	CGW	ETF	18.6	18.69	18.52	18.65	164447.0
2009-12-15	CHI	ETF	12.32	12.42	12.3	12.38	121079.0
2009-12-15	CHII	ETF	15.9	15.91	15.79	15.81	23502.0
2009-12-15	CHIQ	ETF	16.61	16.61	16.5	16.57	34305.0
2009-12-15	CHIX	ETF	14.8	14.83	14.68	14.79	341304.0

> showing 50 of 698 rows — these rows as CSV

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