PREVIEW / etf_daily / 2010-06-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-18.parquet
  size:    32 KB
  rows:    754

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-18	SPY	ETF	111.83	112.13	111.37	111.73	174006600.0
2010-06-18	QQQ	ETF	47.06	47.34	46.86	47.0	75921357.0
2010-06-18	IWM	ETF	66.97	67.53	66.45	66.8	52760900.0
2010-06-18	DIA	ETF	104.51	104.84	104.23	104.49	6890700.0
2010-06-18	GLD	ETF	123.04	123.5	122.81	122.83	19429900.0
2010-06-18	TLT	ETF	97.89	98.11	97.57	97.69	4171700.0
2010-06-18	AAXJ	ETF	54.35	54.72	54.32	54.58	55700.0
2010-06-18	ACWI	ETF	40.95	40.95	40.72	40.78	60700.0
2010-06-18	ACWX	ETF	38.078	38.29	38.01	38.18	60066.0
2010-06-18	ADRE	ETF	41.41	41.74	41.39	41.56	63888.0
2010-06-18	AFK	ETF	29.26	29.39	29.23	29.39	3040.0
2010-06-18	AGG	ETF	106.34	106.34	106.03	106.05	634000.0
2010-06-18	AGQ	ETF	132.7	135.1	132.06	133.58	203300.0
2010-06-18	AGZ	ETF	109.4	109.7	109.4	109.54	35374.0
2010-06-18	AIA	ETF	38.39	38.875	38.39	38.58	30449.0
2010-06-18	AIQ	ETF	25.4	25.7	24.9	25.2	24993.0
2010-06-18	AIS	ETF	1.92	1.95	1.87	1.95	972643.0
2010-06-18	AIVI	ETF	39.53	39.79	39.53	39.64	12700.0
2010-06-18	AMJ	ETF	30.4	30.81	30.31	30.54	249777.0
2010-06-18	AOA	ETF	30.17	30.2	30.13	30.2	1500.0
2010-06-18	AOK	ETF	27.77	27.81	27.73	27.8	8373.0
2010-06-18	AOM	ETF	28.36	28.409	28.35	28.38	6380.0
2010-06-18	AOR	ETF	29.05	29.16	29.05	29.1	3145.0
2010-06-18	ARB	ETF	28.7	28.93	27.92	28.1	179572.0
2010-06-18	BAB	ETF	25.97	25.97	25.8	25.87	186432.0
2010-06-18	BAL	ETF	38.3616	38.84	38.1794	38.455	1903.0
2010-06-18	BALT	ETF	12.4	12.5	12.24	12.48	211276.0
2010-06-18	BBH	ETF	30.5367	30.85	30.4733	30.62	135300.0
2010-06-18	BICK	ETF	28.53	28.53	28.3516	28.42	2779.0
2010-06-18	BIL	ETF	91.7	91.72	91.7	91.72	227550.0
2010-06-18	BIS	ETF	11120.0	11219.2	11025.6	11219.2	8.1
2010-06-18	BITS	ETF	27.6	28.28	25.68	27.92	2379.0
2010-06-18	BIV	ETF	82.35	82.36	82.14	82.14	251000.0
2010-06-18	BJK	ETF	25.0	25.26	24.88	25.02	35600.0
2010-06-18	BKF	ETF	43.28	43.41	42.9601	43.24	62413.0
2010-06-18	BLV	ETF	80.36	80.41	80.03	80.21	28500.0
2010-06-18	BMVP	ETF	12.71	12.74	12.66	12.7	14432.0
2010-06-18	BND	ETF	80.67	80.7	80.58	80.62	902100.0
2010-06-18	BNE	ETF	11.2	11.21	11.19	11.2	787172.0
2010-06-18	BNO	ETF	26.65	26.65	26.65	26.65	4000.0
2010-06-18	BRF	ETF	45.52	45.85	45.39	45.66	228726.0
2010-06-18	BSCE	ETF	20.22	20.22	20.22	20.22	1300.0
2010-06-18	BSV	ETF	80.53	80.58	80.48	80.54	372900.0
2010-06-18	BTF	ETF	66.9	69.05	66.9	67.45	3936.2000000000003
2010-06-18	BWX	ETF	26.835	26.835	26.7075	26.79	162868.0
2010-06-18	BWZ	ETF	33.87	33.87	33.72	33.72	11613.0
2010-06-18	BZQ	ETF	3870.4	3886.4	3782.4	3843.2	923.0
2010-06-18	CEF	ETF	15.4	15.48	15.3	15.3	1439400.0
2010-06-18	CEW	ETF	21.6	21.65	21.536	21.58	22013.0
2010-06-18	CGO	ETF	13.52	13.52	13.21	13.21	28249.0

> showing 50 of 754 rows — these rows as CSV

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