PREVIEW / etf_daily / 2010-05-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-19.parquet
  size:    33 KB
  rows:    757

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-19	SPY	ETF	111.77	112.77	110.36	111.76	394742700.0
2010-05-19	QQQ	ETF	46.26	46.63	45.55	46.06	159000255.0
2010-05-19	IWM	ETF	68.04	68.8	66.58	67.54	107292800.0
2010-05-19	DIA	ETF	104.96	105.58	103.59	104.77	24115100.0
2010-05-19	GLD	ETF	118.19	118.43	116.08	116.63	34412400.0
2010-05-19	TLT	ETF	95.94	96.95	95.93	96.3	14121200.0
2010-05-19	AAXJ	ETF	52.41	52.76	51.78	52.65	1002300.0
2010-05-19	ACWI	ETF	39.99	40.39	39.58	40.13	242800.0
2010-05-19	ACWX	ETF	36.92	37.2	36.42	36.98	110863.0
2010-05-19	ADRE	ETF	39.46	39.67	38.7	39.32	329892.0
2010-05-19	AFK	ETF	29.17	29.1935	28.67	28.92	54794.0
2010-05-19	AGG	ETF	105.52	105.63	105.34	105.54	577300.0
2010-05-19	AGQ	ETF	127.7	128.36	118.42	122.4	461850.0
2010-05-19	AGZ	ETF	109.16	109.41	108.951	109.1799	10645.0
2010-05-19	AIA	ETF	37.52	37.78	37.16	37.63	18219.0
2010-05-19	AIQ	ETF	28.65	28.85	28.2	28.35	16940.0
2010-05-19	AIS	ETF	1.62	1.6499	1.58	1.62	378625.0
2010-05-19	AIVI	ETF	37.65	37.99	37.36	37.8	14300.0
2010-05-19	AMJ	ETF	29.52	29.56	28.36	28.965	785009.0
2010-05-19	AOA	ETF	29.75	29.82	29.38	29.82	14400.0
2010-05-19	AOK	ETF	27.57	27.65	27.53	27.6266	10442.0
2010-05-19	AOM	ETF	28.06	28.2	27.94	28.15	19709.0
2010-05-19	AOR	ETF	28.92	28.98	28.58	28.79	13962.0
2010-05-19	ARB	ETF	32.86	33.0	32.07	32.11	586114.0
2010-05-19	BAB	ETF	26.0	26.18	25.94	26.04	401118.0
2010-05-19	BAL	ETF	39.33	39.62	39.071	39.4785	4072.0
2010-05-19	BALT	ETF	12.82	12.89	12.26	12.55	157652.0
2010-05-19	BBH	ETF	30.7067	31.35	30.7067	31.06	165600.0
2010-05-19	BIB	ETF	6.1491	6.1491	6.1491	6.1491	800.0
2010-05-19	BICK	ETF	26.63	26.9599	26.34	26.7	6768.0
2010-05-19	BIL	ETF	91.7	91.72	91.7	91.72	354800.0
2010-05-19	BIS	ETF	11025.6	11348.8	11025.6	11176.0	18.75
2010-05-19	BITS	ETF	30.2	30.304	28.8	30.0	2120.0
2010-05-19	BIV	ETF	81.98	82.14	81.83	81.96	118500.0
2010-05-19	BJK	ETF	24.27	24.34	23.73	24.14	20300.0
2010-05-19	BKF	ETF	40.57	40.85	39.8	40.495	332992.0
2010-05-19	BLV	ETF	79.94	80.52	79.75	80.07	111900.0
2010-05-19	BMVP	ETF	12.76	12.84	12.57	12.73	16493.0
2010-05-19	BND	ETF	80.34	80.54	80.32	80.45	459400.0
2010-05-19	BNE	ETF	11.05	11.09	10.99	11.07	557781.0
2010-05-19	BRF	ETF	40.0	40.12	38.68	39.65	683725.0
2010-05-19	BSV	ETF	80.46	80.6	80.46	80.57	431000.0
2010-05-19	BTF	ETF	67.05	67.35	66.55	67.3	7645.400000000001
2010-05-19	BWX	ETF	25.69	26.655	25.505	26.485	446476.0
2010-05-19	BWZ	ETF	33.72	33.7599	33.46	33.7599	45550.0
2010-05-19	BZQ	ETF	4793.6	4990.4	4651.2	4774.4	2762.5
2010-05-19	CEF	ETF	14.91	15.01	14.46	14.61	3611800.0
2010-05-19	CEW	ETF	21.36	21.3899	21.15	21.28	122032.0
2010-05-19	CGO	ETF	13.56	13.56	13.0701	13.15	25461.0
2010-05-19	CGW	ETF	17.04	17.1399	16.72	16.96	63891.0

> showing 50 of 757 rows — these rows as CSV

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