PREVIEW / etf_daily / 2009-12-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-16.parquet
  size:    31 KB
  rows:    704

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-16	SPY	ETF	111.8	112.13	111.27	111.52	155358200.0
2009-12-16	QQQ	ETF	44.47	44.7	44.29	44.36	61629612.0
2009-12-16	IWM	ETF	61.3	61.62	60.9	61.3	56550000.0
2009-12-16	DIA	ETF	105.09	105.31	104.47	104.67	6283400.0
2009-12-16	GLD	ETF	110.83	111.91	110.63	111.59	22850300.0
2009-12-16	TLT	ETF	91.93	92.25	91.36	91.68	3301600.0
2009-12-16	AAXJ	ETF	55.6	55.71	55.35	55.53	193300.0
2009-12-16	ACWI	ETF	42.37	42.68	42.37	42.43	230800.0
2009-12-16	ACWX	ETF	41.18	41.35	41.04	41.19	66331.0
2009-12-16	ADRE	ETF	44.57	44.6478	44.23	44.3	75149.0
2009-12-16	AFK	ETF	28.53	28.69	28.46	28.59	14173.0
2009-12-16	AGG	ETF	104.51	104.72	104.5	104.58	519000.0
2009-12-16	AGQ	ETF	121.6	125.62	121.48	124.28	288050.0
2009-12-16	AGZ	ETF	108.43	108.62	108.2701	108.48	19318.0
2009-12-16	AIA	ETF	39.55	39.77	39.43	39.46	48098.0
2009-12-16	AIQ	ETF	30.9	30.9	29.95	30.25	32681.0
2009-12-16	AIS	ETF	1.07	1.09	1.06	1.09	156483.0
2009-12-16	AIVI	ETF	43.88	44.33	43.82	44.04	33200.0
2009-12-16	AMJ	ETF	27.79	28.15	27.79	28.14	338498.0
2009-12-16	AOA	ETF	30.1	30.11	29.97	29.97	7500.0
2009-12-16	AOK	ETF	27.51	27.5425	27.51	27.52	2942.0
2009-12-16	AOM	ETF	28.37	28.5	28.31	28.376	4506.0
2009-12-16	AOR	ETF	29.15	29.2094	29.06	29.11	6915.0
2009-12-16	ARB	ETF	22.49	23.1	22.43	22.98	198028.0
2009-12-16	BAB	ETF	24.51	24.56	24.48	24.5	58243.0
2009-12-16	BAL	ETF	37.28	37.49	37.19	37.363	5935.0
2009-12-16	BBH	ETF	32.29	32.33	31.7267	31.77	253200.0
2009-12-16	BIL	ETF	91.7	91.74	91.7	91.7	73000.0
2009-12-16	BITS	ETF	28.0	28.52	27.64	28.32	6251.0
2009-12-16	BIV	ETF	80.4	80.49	80.27	80.36	136000.0
2009-12-16	BJK	ETF	24.21	24.47	24.21	24.22	7500.0
2009-12-16	BKF	ETF	46.19	46.403	45.78	46.02	138654.0
2009-12-16	BLV	ETF	77.18	77.36	76.93	77.09	49700.0
2009-12-16	BMVP	ETF	12.6486	12.7097	12.6433	12.6633	12737.0
2009-12-16	BND	ETF	79.34	79.45	79.31	79.33	709400.0
2009-12-16	BNE	ETF	6.76	7.0	6.67	6.88	141838.0
2009-12-16	BOSS	ETF	19.04	19.62	19.04	19.62	100.0
2009-12-16	BRF	ETF	48.6	48.7672	48.05	48.18	243675.0
2009-12-16	BSV	ETF	80.21	80.24	80.08	80.17	711200.0
2009-12-16	BTF	ETF	63.2	64.0	62.15	63.49999999999999	2080.0
2009-12-16	BWX	ETF	29.275	29.39	28.91	29.115	4749426.0
2009-12-16	BWZ	ETF	37.17	38.5	37.0201	37.15	59412.0
2009-12-16	BZQ	ETF	3641.6	3776.0	3625.6	3736.0	251.0
2009-12-16	CEF	ETF	13.94	14.19	13.93	14.12	1067200.0
2009-12-16	CEW	ETF	22.09	22.22	22.09	22.18	5233215.0
2009-12-16	CGO	ETF	14.35	14.36	14.19	14.34	24522.0
2009-12-16	CGW	ETF	18.81	18.81	18.6	18.69	115866.0
2009-12-16	CHI	ETF	12.38	12.46	12.3401	12.39	135630.0
2009-12-16	CHIE	ETF	15.03	15.03	14.9	14.95	28345.0
2009-12-16	CHII	ETF	15.72	15.72	15.55	15.5899	266259.0

> showing 50 of 704 rows — these rows as CSV

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