PREVIEW / etf_daily / 2010-09-09

all etf daily files

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

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-09	SPY	ETF	111.65	111.68	110.62	110.92	147017900.0
2010-09-09	QQQ	ETF	46.67	46.7	46.32	46.43	61476378.0
2010-09-09	IWM	ETF	64.45	64.48	63.04	63.52	52494300.0
2010-09-09	DIA	ETF	104.98	105.0	103.97	104.25	4396500.0
2010-09-09	GLD	ETF	122.44	122.88	121.38	121.56	13745000.0
2010-09-09	TLT	ETF	103.7	103.84	102.64	102.79	8588900.0
2010-09-09	AADR	ETF	26.52	26.52	26.52	26.52	800.0
2010-09-09	AAXJ	ETF	56.94	56.99	56.66	56.83	144800.0
2010-09-09	ACWI	ETF	41.74	41.74	41.31	41.46	116300.0
2010-09-09	ACWX	ETF	39.8	39.8	39.35	39.53	1593440.0
2010-09-09	ADRE	ETF	42.62	42.7	42.228	42.45	152795.0
2010-09-09	AFK	ETF	30.13	30.47	30.08	30.17	8497.0
2010-09-09	AGG	ETF	108.0	108.08	107.7	107.73	769800.0
2010-09-09	AGQ	ETF	140.42	142.0	137.46	137.58	153200.0
2010-09-09	AGZ	ETF	110.8	110.87	110.661	110.675	13352.0
2010-09-09	AIA	ETF	40.06	40.16	39.95	40.09	14248.0
2010-09-09	AIQ	ETF	21.9	22.4	21.9	22.2	17817.0
2010-09-09	AIS	ETF	1.54	1.54	1.48	1.5	174650.0
2010-09-09	AIVI	ETF	41.58	41.58	41.08	41.14	16100.0
2010-09-09	AMJ	ETF	32.83	32.88	32.73	32.84	378192.0
2010-09-09	AMLP	ETF	76.2	76.2	75.8	75.85	165900.0
2010-09-09	AOA	ETF	30.48	30.5	30.23	30.23	8300.0
2010-09-09	AOK	ETF	28.0375	28.0375	27.962	27.962	1742.0
2010-09-09	AOM	ETF	28.67	28.67	28.5799	28.629	9985.0
2010-09-09	AOR	ETF	29.35	29.352	29.202	29.23	3252.0
2010-09-09	ARB	ETF	26.87	26.97	25.67	26.08	134896.0
2010-09-09	BAB	ETF	26.54	26.55	26.4	26.41	178906.0
2010-09-09	BAL	ETF	44.022	44.51	43.991	44.51	5013.0
2010-09-09	BALT	ETF	11.3	11.39	10.98	11.05	191257.0
2010-09-09	BBH	ETF	31.2167	31.4367	31.2167	31.4167	24000.0
2010-09-09	BIB	ETF	5.9887	6.0388	5.9737	5.9737	18400.0
2010-09-09	BICK	ETF	29.72	29.75	29.5	29.74	12384.0
2010-09-09	BIL	ETF	91.7	91.72	91.7	91.7	100300.0
2010-09-09	BIS	ETF	10561.6	10561.6	10360.0	10454.4	11.9
2010-09-09	BITS	ETF	25.16	25.2	23.0	24.8	93770.0
2010-09-09	BIV	ETF	85.37	85.41	85.04	85.14	245800.0
2010-09-09	BJK	ETF	27.08	27.11	26.79	26.8	5600.0
2010-09-09	BKF	ETF	45.54	45.6299	44.93	45.04	108399.0
2010-09-09	BLV	ETF	84.83	84.83	84.04	84.14	33000.0
2010-09-09	BMVP	ETF	12.67	12.6744	12.5333	12.5633	5381.0
2010-09-09	BND	ETF	82.08	82.12	81.87	81.9	586000.0
2010-09-09	BNE	ETF	11.01	11.06	10.97	11.02	318170.0
2010-09-09	BNO	ETF	26.145	26.145	26.08	26.08	400.0
2010-09-09	BRF	ETF	53.91	54.1	53.57	54.09	360028.0
2010-09-09	BSCE	ETF	20.78	20.78	20.7454	20.7454	1749.0
2010-09-09	BSV	ETF	81.4	81.4	81.27	81.3	307700.0
2010-09-09	BTF	ETF	73.8	73.8	73.0	73.0	1920.0
2010-09-09	BWX	ETF	28.71	28.8	28.555	28.565	196304.0
2010-09-09	BWZ	ETF	35.27	35.41	35.27	35.353	32595.0
2010-09-09	BZQ	ETF	3220.8	3286.4	3208.0	3244.8	482.0

> showing 50 of 781 rows — these rows as CSV

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