PREVIEW / etf_daily / 2010-09-03

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-03.parquet
  size:    33 KB
  rows:    773

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-09-03	SPY	ETF	110.54	110.99	109.95	110.89	212197300.0
2010-09-03	QQQ	ETF	45.73	46.02	45.55	46.01	64041080.0
2010-09-03	IWM	ETF	64.16	64.53	63.61	64.33	51986300.0
2010-09-03	DIA	ETF	104.22	104.63	103.29	104.58	6280300.0
2010-09-03	GLD	ETF	121.39	122.39	121.15	121.86	9074500.0
2010-09-03	TLT	ETF	102.72	103.94	102.7	103.58	9210700.0
2010-09-03	AADR	ETF	26.31	26.31	26.23	26.23	4300.0
2010-09-03	AAXJ	ETF	56.66	56.66	56.17	56.46	320900.0
2010-09-03	ACWI	ETF	41.4	41.51	41.16	41.39	66500.0
2010-09-03	ACWX	ETF	39.44	39.55	39.279	39.47	28509.0
2010-09-03	ADRE	ETF	42.63	42.87	42.51	42.66	87116.0
2010-09-03	AFK	ETF	30.59	30.99	30.37	30.58	41612.0
2010-09-03	AGG	ETF	107.9	108.08	107.78	108.02	856000.0
2010-09-03	AGQ	ETF	135.66	140.6	134.68	139.16	226750.0
2010-09-03	AGZ	ETF	110.81	111.1299	110.733	110.889	16088.0
2010-09-03	AIA	ETF	39.86	39.86	39.64	39.82	65161.0
2010-09-03	AIQ	ETF	22.3	22.4	21.8	22.4	14513.0
2010-09-03	AIS	ETF	1.52	1.53	1.52	1.53	153421.0
2010-09-03	AIVI	ETF	41.2	41.37	41.04	41.22	8100.0
2010-09-03	AMJ	ETF	32.99	33.14	32.6	32.75	1358937.0
2010-09-03	AMLP	ETF	76.1	76.1	75.8	75.95	83320.0
2010-09-03	AOA	ETF	30.25	30.37	30.2	30.3	13700.0
2010-09-03	AOK	ETF	28.04	28.05	27.98	28.05	6356.0
2010-09-03	AOM	ETF	28.61	28.61	28.545	28.602	5261.0
2010-09-03	AOR	ETF	29.2	29.2292	29.2	29.2292	1900.0
2010-09-03	ARB	ETF	27.27	27.56	26.98	27.45	89601.0
2010-09-03	BAB	ETF	26.32	26.52	26.26	26.47	254175.0
2010-09-03	BAL	ETF	43.73	43.89	43.2501	43.77	10822.0
2010-09-03	BALT	ETF	11.24	11.46	11.24	11.44	89419.0
2010-09-03	BBH	ETF	30.88	31.08	30.7933	31.08	104700.0
2010-09-03	BIB	ETF	5.7725	5.795	5.755	5.795	21600.0
2010-09-03	BICK	ETF	29.61	29.61	29.26	29.36	26421.0
2010-09-03	BIL	ETF	91.7	91.72	91.7	91.72	652850.0
2010-09-03	BIS	ETF	10892.8	10892.8	10892.8	10892.8	6.25
2010-09-03	BITS	ETF	24.96	25.16	24.4	24.4	3584.0
2010-09-03	BIV	ETF	85.24	85.37	85.03	85.11	206300.0
2010-09-03	BJK	ETF	26.28	26.55	26.28	26.55	7900.0
2010-09-03	BKF	ETF	45.15	45.56	44.89	44.95	91800.0
2010-09-03	BLV	ETF	83.84	84.55	83.84	84.4	79100.0
2010-09-03	BMVP	ETF	12.63	12.63	12.55	12.6	7134.0
2010-09-03	BND	ETF	82.03	82.13	81.88	82.09	814100.0
2010-09-03	BNE	ETF	10.91	10.93	10.67	10.86	714924.0
2010-09-03	BNO	ETF	26.025	26.03	25.49	25.595	31000.0
2010-09-03	BRF	ETF	53.7	53.9	52.834	52.89	403828.0
2010-09-03	BSCE	ETF	20.7552	20.81	20.7552	20.8099	3015.0
2010-09-03	BSV	ETF	81.35	81.41	81.29	81.41	421600.0
2010-09-03	BTF	ETF	71.5	72.75	71.5	72.0	4795.400000000001
2010-09-03	BWX	ETF	28.885	28.96	28.725	28.95	491508.0
2010-09-03	BWZ	ETF	35.52	35.53	35.4299	35.53	2409.0
2010-09-03	BZQ	ETF	3153.6	3259.2	3140.8	3254.4	752.0

> showing 50 of 773 rows — these rows as CSV

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