PREVIEW / etf_daily / 2010-08-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-10.parquet
  size:    33 KB
  rows:    771

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-10	SPY	ETF	112.03	112.98	111.37	112.38	242916300.0
2010-08-10	QQQ	ETF	46.72	46.95	46.28	46.6725	86694468.0
2010-08-10	IWM	ETF	65.21	65.41	64.13	64.62	59841700.0
2010-08-10	DIA	ETF	106.36	107.18	105.67	106.66	8434400.0
2010-08-10	GLD	ETF	116.59	118.09	116.4	117.73	10444900.0
2010-08-10	TLT	ETF	100.06	101.01	99.47	99.94	11251000.0
2010-08-10	AADR	ETF	26.08	26.08	26.08	26.08	500.0
2010-08-10	AAXJ	ETF	56.64	56.78	56.2	56.55	196200.0
2010-08-10	ACWI	ETF	41.87	42.08	41.49	42.08	184500.0
2010-08-10	ACWX	ETF	39.5	39.92	39.25	39.83	43668.0
2010-08-10	ADRE	ETF	42.9	43.23	42.72	43.06	121473.0
2010-08-10	AFK	ETF	31.18	31.286	30.8	31.286	6835.0
2010-08-10	AGG	ETF	107.63	107.92	107.56	107.81	571900.0
2010-08-10	AGQ	ETF	116.26	121.6	115.6	120.14	151350.0
2010-08-10	AGZ	ETF	110.77	110.916	110.6701	110.89	11804.0
2010-08-10	AIA	ETF	40.31	40.4699	40.09	40.35	16640.0
2010-08-10	AIQ	ETF	24.15	24.3	23.55	23.85	28770.0
2010-08-10	AIS	ETF	1.7	1.72	1.62	1.68	780886.0
2010-08-10	AIVI	ETF	41.29	41.84	41.05	41.69	13500.0
2010-08-10	AMJ	ETF	33.3	33.3	32.75	33.0	1296765.0
2010-08-10	AOA	ETF	30.53	30.61	30.39	30.61	6100.0
2010-08-10	AOK	ETF	27.99	28.11	27.961	28.09	6812.0
2010-08-10	AOM	ETF	28.61	28.75	28.58	28.75	11866.0
2010-08-10	AOR	ETF	29.2799	29.46	29.2799	29.4515	8839.0
2010-08-10	ARB	ETF	27.04	27.59	26.85	27.24	157555.0
2010-08-10	BAB	ETF	26.13	26.37	26.13	26.2	296185.0
2010-08-10	BAL	ETF	38.83	39.74	38.74	39.58	5870.0
2010-08-10	BALT	ETF	11.45	11.45	11.01	11.2	597011.0
2010-08-10	BBH	ETF	31.7933	32.25	31.6567	32.06	59700.0
2010-08-10	BIB	ETF	6.1437	6.1437	5.995	6.0137	3200.0
2010-08-10	BICK	ETF	29.3	29.45	28.94	29.31	19866.0
2010-08-10	BIL	ETF	91.7	91.7	91.68	91.7	125500.0
2010-08-10	BIS	ETF	10736.0	10736.0	10619.2	10619.2	4.375
2010-08-10	BITS	ETF	27.6	28.04	27.6	27.6004	400.0
2010-08-10	BIV	ETF	84.99	85.46	84.91	85.34	210500.0
2010-08-10	BJK	ETF	25.67	25.9	25.6	25.81	7700.0
2010-08-10	BKF	ETF	44.78	45.345	44.73	45.21	82712.0
2010-08-10	BLV	ETF	82.98	83.72	82.66	83.13	57300.0
2010-08-10	BMVP	ETF	12.683	12.748	12.607	12.693	9093.0
2010-08-10	BND	ETF	81.92	82.11	81.85	82.1	1123200.0
2010-08-10	BNE	ETF	11.2	11.25	11.2	11.25	413851.0
2010-08-10	BNO	ETF	26.79	26.975	26.745	26.975	42200.0
2010-08-10	BRF	ETF	50.06	50.06	49.57	49.7	368014.0
2010-08-10	BSCE	ETF	20.8	20.84	20.7975	20.805	6721.0
2010-08-10	BSV	ETF	81.37	81.48	81.25	81.41	563100.0
2010-08-10	BTF	ETF	71.14999999999999	71.5	70.7	71.25	3200.0
2010-08-10	BWX	ETF	28.985	29.125	28.785	28.885	180690.0
2010-08-10	BWZ	ETF	35.74	35.87	35.488	35.87	27799.0
2010-08-10	BZQ	ETF	3364.8	3393.6	3312.0	3340.8	2068.0
2010-08-10	CEF	ETF	14.67	14.87	14.56	14.87	487500.0

> showing 50 of 771 rows — these rows as CSV

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