PREVIEW / etf_daily / 2010-08-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-30.parquet
  size:    33 KB
  rows:    766

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-30	SPY	ETF	106.58	106.91	105.3	105.31	167238600.0
2010-08-30	QQQ	ETF	43.87	44.25	43.6	43.61	49373115.0
2010-08-30	IWM	ETF	61.35	61.66	60.27	60.3	42401800.0
2010-08-30	DIA	ETF	101.23	101.54	100.16	100.17	4731200.0
2010-08-30	GLD	ETF	120.85	121.06	120.58	120.91	4390900.0
2010-08-30	TLT	ETF	106.21	107.4	105.82	107.37	5535300.0
2010-08-30	AADR	ETF	25.29	25.29	25.29	25.29	300.0
2010-08-30	AAXJ	ETF	54.97	55.01	54.5	54.55	299200.0
2010-08-30	ACWI	ETF	39.75	39.78	39.25	39.27	455600.0
2010-08-30	ACWX	ETF	37.86	37.92	37.54	37.6167	34942.0
2010-08-30	ADRE	ETF	41.03	41.13	40.5	40.53	372146.0
2010-08-30	AFK	ETF	29.72	30.069	29.5	29.51	6666.0
2010-08-30	AGG	ETF	108.48	108.86	108.33	108.86	429900.0
2010-08-30	AGQ	ETF	129.2	130.0	128.02	128.16	118800.0
2010-08-30	AGZ	ETF	111.2	111.43	111.114	111.43	14311.0
2010-08-30	AIA	ETF	38.92	39.01	38.701	38.73	14767.0
2010-08-30	AIQ	ETF	22.45	22.55	21.4	21.65	26768.0
2010-08-30	AIS	ETF	1.47	1.5	1.47	1.49	302107.0
2010-08-30	AIVI	ETF	39.39	39.45	39.08	39.08	18800.0
2010-08-30	AMJ	ETF	32.3	32.3	31.84	31.9	1441220.0
2010-08-30	AMLP	ETF	75.5	75.5	74.8	74.8	204480.0
2010-08-30	AOA	ETF	29.18	29.21	28.86	28.86	4900.0
2010-08-30	AOK	ETF	27.78	27.78	27.73	27.74	6446.0
2010-08-30	AOM	ETF	28.1604	28.19	28.05	28.07	5779.0
2010-08-30	AOR	ETF	28.57	28.6	28.4	28.4	26129.0
2010-08-30	ARB	ETF	25.54	25.56	25.14	25.19	176749.0
2010-08-30	BAB	ETF	26.77	26.95	26.67	26.95	305865.0
2010-08-30	BAL	ETF	41.95	42.32	41.95	42.32	4687.0
2010-08-30	BALT	ETF	11.44	11.52	11.09	11.09	136274.0
2010-08-30	BBH	ETF	30.14	30.3733	30.07	30.07	28800.0
2010-08-30	BIB	ETF	5.375	5.375	5.3338	5.3362	10400.0
2010-08-30	BICK	ETF	28.31	28.41	28.06	28.067	2601.0
2010-08-30	BIL	ETF	91.7	91.72	91.7	91.72	119250.0
2010-08-30	BITS	ETF	23.64	25.4	23.4	23.8	7082.0
2010-08-30	BIV	ETF	85.98	86.27	85.88	86.24	172200.0
2010-08-30	BJK	ETF	25.77	25.77	25.39	25.39	12000.0
2010-08-30	BKF	ETF	43.32	43.4	42.72	42.74	117606.0
2010-08-30	BLV	ETF	86.24	86.83	85.92	86.77	30600.0
2010-08-30	BMVP	ETF	12.1233	12.152	11.9922	11.9922	4881.0
2010-08-30	BND	ETF	82.57	82.75	82.5	82.75	499700.0
2010-08-30	BNE	ETF	11.15	11.18	11.1	11.11	258520.0
2010-08-30	BNO	ETF	25.73	25.87	25.67	25.87	56000.0
2010-08-30	BRF	ETF	51.6	51.6	50.83	50.85	157776.0
2010-08-30	BSCE	ETF	20.83	20.83	20.8056	20.8083	1819.0
2010-08-30	BSV	ETF	81.52	81.66	81.48	81.63	459600.0
2010-08-30	BTF	ETF	69.35	69.35	68.8	68.85	1900.0
2010-08-30	BWX	ETF	28.9	28.995	28.7	28.94	767494.0
2010-08-30	BWZ	ETF	35.05	35.15	34.86	35.045	16575.0
2010-08-30	BZQ	ETF	3534.4	3662.4	3507.2	3662.4	752.0
2010-08-30	CEF	ETF	15.36	15.43	15.34	15.37	399900.0

> showing 50 of 766 rows — these rows as CSV

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