PREVIEW / etf_daily / 2010-09-02

all etf daily files

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

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-02	SPY	ETF	108.72	109.49	108.49	109.47	156112200.0
2010-09-02	QQQ	ETF	44.84	45.28	44.73	45.26	41816716.0
2010-09-02	IWM	ETF	62.49	63.38	62.27	63.2	45824200.0
2010-09-02	DIA	ETF	102.91	103.29	102.62	103.28	3782600.0
2010-09-02	GLD	ETF	122.38	122.48	121.89	122.29	7002100.0
2010-09-02	TLT	ETF	105.2	105.3	104.4	104.88	8167600.0
2010-09-02	AADR	ETF	26.03	26.03	26.03	26.03	100.0
2010-09-02	AAXJ	ETF	55.82	56.0	55.57	55.96	250000.0
2010-09-02	ACWI	ETF	40.66	41.03	40.54	41.03	681600.0
2010-09-02	ACWX	ETF	38.89	39.1	38.8	39.05	44510.0
2010-09-02	ADRE	ETF	42.2	42.3	42.0	42.27	167783.0
2010-09-02	AFK	ETF	30.44	30.4999	30.07	30.28	34941.0
2010-09-02	AGG	ETF	108.25	108.28	108.1	108.27	1217500.0
2010-09-02	AGQ	ETF	136.24	137.24	134.62	136.96	252500.0
2010-09-02	AGZ	ETF	110.99	111.165	110.926	110.995	21675.0
2010-09-02	AIA	ETF	39.19	39.41	39.1	39.4	11491.0
2010-09-02	AIQ	ETF	21.7	22.25	21.55	22.1	14375.0
2010-09-02	AIS	ETF	1.54	1.54	1.5	1.52	242654.0
2010-09-02	AIVI	ETF	40.74	40.93	40.61	40.93	21400.0
2010-09-02	AMJ	ETF	32.43	32.61	32.22	32.58	665885.0
2010-09-02	AMLP	ETF	75.5	75.8	75.3	75.8	179260.0
2010-09-02	AOA	ETF	29.81	29.97	29.74	29.97	21800.0
2010-09-02	AOK	ETF	27.93	27.96	27.8865	27.9544	7693.0
2010-09-02	AOM	ETF	28.44	28.5	28.44	28.5	4729.0
2010-09-02	AOR	ETF	28.8801	29.08	28.8801	29.059	13193.0
2010-09-02	ARB	ETF	26.38	26.93	26.36	26.87	79475.0
2010-09-02	BAB	ETF	26.73	26.74	26.59	26.67	171766.0
2010-09-02	BAL	ETF	43.43	43.89	43.43	43.69	10963.0
2010-09-02	BALT	ETF	11.44	11.44	11.09	11.15	94248.0
2010-09-02	BBH	ETF	30.5533	30.7367	30.4833	30.6733	70200.0
2010-09-02	BICK	ETF	29.2	29.2	28.97	29.16	19735.0
2010-09-02	BIL	ETF	91.7	91.72	91.7	91.72	132450.0
2010-09-02	BITS	ETF	24.8	24.8	23.04	24.8	2657.0
2010-09-02	BIV	ETF	85.65	85.74	85.57	85.66	224000.0
2010-09-02	BJK	ETF	26.18	26.31	26.0	26.31	7800.0
2010-09-02	BKF	ETF	44.6	44.76	44.4	44.72	92535.0
2010-09-02	BLV	ETF	85.26	85.34	84.78	85.11	69300.0
2010-09-02	BMVP	ETF	12.317	12.44	12.299	12.44	10595.0
2010-09-02	BND	ETF	82.31	82.35	82.19	82.24	636800.0
2010-09-02	BNE	ETF	10.95	11.0	10.8	10.86	1285607.0
2010-09-02	BNO	ETF	25.435	25.67	25.435	25.67	45600.0
2010-09-02	BRF	ETF	52.74	53.4	52.59	53.37	461196.0
2010-09-02	BSCE	ETF	20.79	20.8	20.79	20.8	5131.0
2010-09-02	BSV	ETF	81.4	81.46	81.36	81.45	398000.0
2010-09-02	BTF	ETF	70.6	71.0945	70.6	70.99999999999999	2665.0
2010-09-02	BWX	ETF	28.86	28.995	28.79	28.965	666378.0
2010-09-02	BWZ	ETF	35.29	35.4004	35.29	35.3748	7341.0
2010-09-02	BZQ	ETF	3256.0	3288.0	3240.0	3240.0	310.0
2010-09-02	CEF	ETF	15.64	15.78	15.6	15.75	743500.0
2010-09-02	CEW	ETF	22.07	22.15	22.07	22.12	55827.0

> showing 50 of 764 rows — these rows as CSV

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