PREVIEW / etf_daily / 2010-08-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-24.parquet
  size:    33 KB
  rows:    775

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-08-24	SPY	ETF	105.95	106.39	104.97	105.53	280677800.0
2010-08-24	QQQ	ETF	44.01	44.12	43.465	43.65	79095766.0
2010-08-24	IWM	ETF	59.36	60.32	58.8	59.63	78875300.0
2010-08-24	DIA	ETF	100.73	101.15	99.91	100.4	9543400.0
2010-08-24	GLD	ETF	118.77	120.8	118.71	120.36	14811400.0
2010-08-24	TLT	ETF	107.04	108.13	106.67	107.76	9812100.0
2010-08-24	AADR	ETF	24.9	24.96	24.9	24.96	3800.0
2010-08-24	AAXJ	ETF	54.56	54.86	54.23	54.54	684700.0
2010-08-24	ACWI	ETF	39.32	39.57	39.06	39.25	229700.0
2010-08-24	ACWX	ETF	37.42	37.52	37.18	37.33	114803.0
2010-08-24	ADRE	ETF	40.84	41.15	40.62	40.92	285757.0
2010-08-24	AFK	ETF	29.78	30.061	29.7524	30.0099	16225.0
2010-08-24	AGG	ETF	108.57	108.86	108.38	108.84	834000.0
2010-08-24	AGQ	ETF	113.58	121.2	113.42	119.88	342600.0
2010-08-24	AGZ	ETF	111.2756	111.34	111.144	111.2235	10397.0
2010-08-24	AIA	ETF	38.88	38.88	38.44	38.7401	13771.0
2010-08-24	AIQ	ETF	22.6	22.714	22.1	22.1	56084.0
2010-08-24	AIS	ETF	1.5	1.52	1.48	1.49	484501.0
2010-08-24	AIVI	ETF	38.7	38.94	38.58	38.66	27100.0
2010-08-24	AMJ	ETF	32.45	32.541	32.25	32.54	973988.0
2010-08-24	AOA	ETF	28.83	28.96	28.69	28.82	7500.0
2010-08-24	AOK	ETF	27.62	27.7	27.62	27.648	4220.0
2010-08-24	AOM	ETF	28.04	28.0899	27.97	28.04	9265.0
2010-08-24	AOR	ETF	28.37	28.4	28.317	28.35	7168.0
2010-08-24	ARB	ETF	24.25	24.75	23.71	24.24	128762.0
2010-08-24	BAB	ETF	26.86	26.969	26.78	26.95	289466.0
2010-08-24	BAL	ETF	40.46	41.69	40.39	41.59	12810.0
2010-08-24	BALT	ETF	11.02	11.14	10.88	10.88	124966.0
2010-08-24	BBH	ETF	29.9667	29.9667	29.6433	29.75	60000.0
2010-08-24	BIB	ETF	5.3238	5.35	5.2938	5.3412	12000.0
2010-08-24	BICK	ETF	28.01	28.32	27.87	28.1201	10283.0
2010-08-24	BIL	ETF	91.7	91.72	91.7	91.7	392500.0
2010-08-24	BIS	ETF	11928.0	12014.384	11913.6	11913.6	8.9
2010-08-24	BITS	ETF	24.64	24.64	24.04	24.6	375.0
2010-08-24	BIV	ETF	86.44	86.64	86.25	86.55	160500.0
2010-08-24	BJK	ETF	25.31	25.31	24.98	24.98	23200.0
2010-08-24	BKF	ETF	43.26	43.37	42.83	43.1	128753.0
2010-08-24	BLV	ETF	86.96	87.52	86.71	87.43	27900.0
2010-08-24	BMVP	ETF	11.97	12.01	11.92	11.97	17965.0
2010-08-24	BND	ETF	82.7	82.83	82.64	82.8	543000.0
2010-08-24	BNE	ETF	11.11	11.15	11.1	11.14	291695.0
2010-08-24	BNO	ETF	24.465	24.465	24.34	24.34	22800.0
2010-08-24	BRF	ETF	50.31	50.81	50.0	50.4	372313.0
2010-08-24	BSCE	ETF	20.87	20.87	20.87	20.87	500.0
2010-08-24	BSV	ETF	81.73	81.74	81.61	81.69	414400.0
2010-08-24	BTF	ETF	68.55	69.25	68.1	68.64999999999999	4596.0
2010-08-24	BWX	ETF	28.54	28.87	28.54	28.595	175096.0
2010-08-24	BWZ	ETF	35.0305	35.13	34.941	35.12	12383.0
2010-08-24	BZQ	ETF	3636.8	3678.4	3574.4	3628.8	2334.0
2010-08-24	CEF	ETF	14.81	15.08	14.74	15.03	789100.0

> showing 50 of 775 rows — these rows as CSV

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