PREVIEW / etf_daily / 2010-05-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-21.parquet
  size:    33 KB
  rows:    756

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
2010-05-21	SPY	ETF	105.91	109.38	105.36	109.11	500909400.0
2010-05-21	QQQ	ETF	43.64	45.64	43.49	44.84	190631100.0
2010-05-21	IWM	ETF	63.07	65.64	62.76	65.07	139644500.0
2010-05-21	DIA	ETF	99.3	101.97	99.02	101.84	30840500.0
2010-05-21	GLD	ETF	115.05	116.24	114.51	115.22	20098300.0
2010-05-21	TLT	ETF	99.61	99.75	97.86	98.43	18670600.0
2010-05-21	AAXJ	ETF	48.76	51.46	48.76	51.46	302800.0
2010-05-21	ACWI	ETF	39.14	39.29	37.92	39.28	401800.0
2010-05-21	ACWX	ETF	35.04	36.45	35.04	36.4	512438.0
2010-05-21	ADRE	ETF	37.15	38.83	36.98	38.83	315013.0
2010-05-21	AFK	ETF	27.93	28.55	27.51	28.198	10868.0
2010-05-21	AGG	ETF	105.76	105.97	105.56	105.9	1048200.0
2010-05-21	AGQ	ETF	113.2	117.58	111.68	114.68	292000.0
2010-05-21	AGZ	ETF	109.63	109.65	109.28	109.3686	13127.0
2010-05-21	AIA	ETF	35.18	36.7199	35.17	36.7199	80755.0
2010-05-21	AIQ	ETF	25.6	26.25	25.0	26.2	34189.0
2010-05-21	AIS	ETF	1.44	1.54	1.44	1.52	549231.0
2010-05-21	AIVI	ETF	36.36	37.56	36.24	37.44	86400.0
2010-05-21	AMJ	ETF	27.59	28.58	27.11	28.49	1414861.0
2010-05-21	AOA	ETF	28.26	29.24	28.25	29.11	28000.0
2010-05-21	AOK	ETF	27.18	27.49	27.18	27.4001	10067.0
2010-05-21	AOM	ETF	27.72	27.895	27.6701	27.79	8663.0
2010-05-21	AOR	ETF	27.87	28.48	27.8	28.42	82913.0
2010-05-21	ARB	ETF	29.04	30.62	29.04	30.05	298105.0
2010-05-21	BAB	ETF	26.25	26.5	26.06	26.24	493613.0
2010-05-21	BAL	ETF	37.97	39.36	37.26	39.13	3613.0
2010-05-21	BALT	ETF	11.39	11.77	11.39	11.73	337689.0
2010-05-21	BBH	ETF	29.3867	29.7467	29.2867	29.5167	354600.0
2010-05-21	BIB	ETF	5.52	5.7819	5.5187	5.6813	44592.0
2010-05-21	BICK	ETF	25.49	26.23	25.15	25.9476	10107.0
2010-05-21	BIL	ETF	91.72	91.72	91.7	91.72	463150.0
2010-05-21	BIS	ETF	12451.2	12481.6	11968.0	12150.4	24.35
2010-05-21	BITS	ETF	29.0	29.2	28.6	29.16	2076.0
2010-05-21	BIV	ETF	82.85	82.92	82.22	82.45	387100.0
2010-05-21	BJK	ETF	22.57	23.5	22.49	23.49	11700.0
2010-05-21	BKF	ETF	38.3499	40.05	38.09	39.99	283804.0
2010-05-21	BLV	ETF	81.26	81.48	80.51	81.15	91100.0
2010-05-21	BMVP	ETF	12.06	12.4155	11.95	12.3422	19033.0
2010-05-21	BND	ETF	80.91	80.98	80.6	80.7	997400.0
2010-05-21	BNE	ETF	10.96	11.07	10.94	11.07	775222.0
2010-05-21	BRF	ETF	37.49	40.08	37.48	39.93	393445.0
2010-05-21	BSV	ETF	80.71	80.71	80.48	80.59	654900.0
2010-05-21	BTF	ETF	62.85	65.7	62.05	64.89999999999999	10578.2
2010-05-21	BWX	ETF	26.885	26.885	26.3459	26.71	508672.0
2010-05-21	BWZ	ETF	33.62	33.95	33.62	33.95	11348.0
2010-05-21	BZQ	ETF	5411.2	5420.8	4788.8	4803.2	3739.5
2010-05-21	CEF	ETF	14.27	14.65	14.1	14.57	2578700.0
2010-05-21	CEW	ETF	21.02	21.27	21.0	21.18	139047.0
2010-05-21	CGO	ETF	12.46	12.89	12.41	12.87	94791.0
2010-05-21	CGW	ETF	16.13	16.65	16.08	16.65	103362.0

> showing 50 of 756 rows — these rows as CSV

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