PREVIEW / etf_daily / 2010-06-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-16.parquet
  size:    33 KB
  rows:    755

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-06-16	SPY	ETF	111.42	112.42	111.2	111.96	216374000.0
2010-06-16	QQQ	ETF	46.58	47.14	46.5	46.9	78399646.0
2010-06-16	IWM	ETF	66.4	67.38	66.25	66.68	62369400.0
2010-06-16	DIA	ETF	103.69	104.48	103.52	104.29	9602400.0
2010-06-16	GLD	ETF	120.68	120.89	120.04	120.33	10500500.0
2010-06-16	TLT	ETF	97.19	97.22	96.39	97.06	4011100.0
2010-06-16	AAXJ	ETF	54.21	54.68	53.9	54.53	374700.0
2010-06-16	ACWI	ETF	40.47	41.06	40.35	40.79	883900.0
2010-06-16	ACWX	ETF	37.82	38.16	37.65	37.96	95503.0
2010-06-16	ADRE	ETF	41.68	42.24	41.52	42.0	178407.0
2010-06-16	AFK	ETF	29.215	29.314	28.6	29.18	2612.0
2010-06-16	AGG	ETF	105.72	105.99	105.72	105.97	654100.0
2010-06-16	AGQ	ETF	125.26	125.54	123.28	124.1	74950.0
2010-06-16	AGZ	ETF	109.46	109.521	109.3655	109.444	15358.0
2010-06-16	AIA	ETF	38.382	38.73	38.38	38.56	12962.0
2010-06-16	AIQ	ETF	25.45	25.95	25.15	25.3	7914.0
2010-06-16	AIS	ETF	1.88	1.9	1.82	1.84	571904.0
2010-06-16	AIVI	ETF	39.22	39.7	39.22	39.57	12300.0
2010-06-16	AMJ	ETF	30.44	30.61	30.252	30.61	325357.0
2010-06-16	AOA	ETF	30.02	30.2	29.96	30.09	3300.0
2010-06-16	AOK	ETF	27.73	27.79	27.693	27.74	24978.0
2010-06-16	AOM	ETF	28.2846	28.36	28.223	28.3068	37955.0
2010-06-16	AOR	ETF	28.9446	29.14	28.9446	29.022	26053.0
2010-06-16	ARB	ETF	27.87	28.59	27.87	28.47	341097.0
2010-06-16	BAB	ETF	25.82	25.88	25.72	25.8	201643.0
2010-06-16	BAL	ETF	39.04	39.1	38.87	38.87	3810.0
2010-06-16	BALT	ETF	12.61	12.64	12.12	12.52	219775.0
2010-06-16	BBH	ETF	30.14	30.5033	30.0	30.3633	76800.0
2010-06-16	BIB	ETF	6.0362	6.0362	5.9588	5.965	16704.0
2010-06-16	BICK	ETF	27.97	28.5899	27.97	28.22	13702.0
2010-06-16	BIL	ETF	91.72	91.74	91.7	91.7	863700.0
2010-06-16	BIS	ETF	11281.6	11281.6	11152.0	11238.4	2.125
2010-06-16	BITS	ETF	28.36	28.36	27.76	27.76	100.0
2010-06-16	BIV	ETF	82.03	82.04	81.71	82.0	142600.0
2010-06-16	BJK	ETF	24.8	25.15	24.74	24.9	15600.0
2010-06-16	BKF	ETF	43.01	43.46	42.75	43.38	91631.0
2010-06-16	BLV	ETF	79.55	79.69	79.27	79.52	53600.0
2010-06-16	BMVP	ETF	12.6667	12.7492	12.6308	12.6933	15364.0
2010-06-16	BND	ETF	80.36	80.44	80.29	80.43	662000.0
2010-06-16	BNE	ETF	11.16	11.18	11.16	11.18	261018.0
2010-06-16	BNO	ETF	26.275	26.685	26.275	26.64	5400.0
2010-06-16	BRF	ETF	44.76	45.41	44.65	45.05	276779.0
2010-06-16	BSCE	ETF	20.18	20.18	20.16	20.16	5755.0
2010-06-16	BSV	ETF	80.46	80.46	80.37	80.46	377900.0
2010-06-16	BTF	ETF	66.55	67.19999999999999	66.5	66.85	6010.0
2010-06-16	BWX	ETF	26.555	26.705	26.555	26.58	257966.0
2010-06-16	BWZ	ETF	33.621	33.695	33.57	33.61	16212.0
2010-06-16	BZQ	ETF	3971.2	3974.4	3792.0	3851.2	607.5
2010-06-16	CEF	ETF	15.21	15.25	15.09	15.13	809800.0
2010-06-16	CEW	ETF	21.51	21.57	21.43	21.55	75807.0

> showing 50 of 755 rows — these rows as CSV

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