PREVIEW / etf_daily / 2010-07-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-13.parquet
  size:    33 KB
  rows:    761

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-07-13	SPY	ETF	109.15	110.09	108.93	109.66	213025900.0
2010-07-13	QQQ	ETF	45.13	45.5	44.8	45.33	93310499.0
2010-07-13	IWM	ETF	63.08	64.44	62.84	64.2	83581200.0
2010-07-13	DIA	ETF	103.22	104.18	103.17	103.73	9339100.0
2010-07-13	GLD	ETF	118.98	119.1	118.36	118.36	8423700.0
2010-07-13	TLT	ETF	98.85	98.89	98.18	98.33	5842500.0
2010-07-13	AAXJ	ETF	55.07	55.33	54.91	55.25	114900.0
2010-07-13	ACWI	ETF	40.16	40.47	40.1	40.31	273100.0
2010-07-13	ACWX	ETF	37.87	38.05	37.78	37.98	19973.0
2010-07-13	ADRE	ETF	41.19	41.472	41.19	41.3	58365.0
2010-07-13	AFK	ETF	28.7	29.27	28.7	29.1288	5650.0
2010-07-13	AGG	ETF	106.86	106.87	106.58	106.59	402300.0
2010-07-13	AGQ	ETF	120.0	120.94	119.24	119.4	143450.0
2010-07-13	AGZ	ETF	109.94	109.98	109.6613	109.89	9192.0
2010-07-13	AIA	ETF	38.61	38.95	38.61	38.9465	13845.0
2010-07-13	AIQ	ETF	18.75	20.05	18.4	19.95	50433.0
2010-07-13	AIS	ETF	1.66	1.72	1.65	1.68	407257.0
2010-07-13	AIVI	ETF	38.94	39.4	38.94	39.26	6000.0
2010-07-13	AMJ	ETF	32.61	32.61	32.02	32.34	1166931.0
2010-07-13	AOA	ETF	29.49	29.82	29.49	29.74	5600.0
2010-07-13	AOK	ETF	27.64	27.68	27.6284	27.68	3359.0
2010-07-13	AOM	ETF	28.13	28.19	28.0401	28.19	4901.0
2010-07-13	AOR	ETF	28.71	28.81	28.6899	28.81	4445.0
2010-07-13	ARB	ETF	26.76	27.64	26.38	27.45	141866.0
2010-07-13	BAB	ETF	25.76	25.76	25.65	25.689	278284.0
2010-07-13	BAL	ETF	36.48	36.48	36.25	36.25	4397.0
2010-07-13	BALT	ETF	10.4	10.82	10.31	10.74	224407.0
2010-07-13	BBH	ETF	29.8167	30.23	29.8167	30.0667	123600.0
2010-07-13	BICK	ETF	28.32	28.32	28.04	28.2	4606.0
2010-07-13	BIL	ETF	91.72	91.72	91.7	91.72	164050.0
2010-07-13	BIS	ETF	11894.4	11894.4	11865.6	11865.6	1.25
2010-07-13	BITS	ETF	27.64	28.32	27.0	27.92	250.0
2010-07-13	BIV	ETF	83.13	83.23	83.0	83.04	288500.0
2010-07-13	BJK	ETF	23.87	24.28	23.87	24.21	11500.0
2010-07-13	BKF	ETF	43.67	43.83	43.27	43.49	226394.0
2010-07-13	BLV	ETF	80.97	80.97	80.44	80.5	74100.0
2010-07-13	BMVP	ETF	12.21	12.39	12.21	12.39	16032.0
2010-07-13	BND	ETF	81.07	81.07	80.92	80.98	514100.0
2010-07-13	BNE	ETF	11.32	11.32	11.27	11.29	351805.0
2010-07-13	BNO	ETF	25.825	25.975	25.825	25.945	6800.0
2010-07-13	BOSS	ETF	28.02	28.16	28.02	28.16	100.0
2010-07-13	BRF	ETF	46.28	46.6	46.24	46.24	243598.0
2010-07-13	BSCE	ETF	20.47	20.47	20.427	20.43	12325.0
2010-07-13	BSV	ETF	80.89	80.89	80.82	80.86	349700.0
2010-07-13	BTF	ETF	68.89999999999999	69.14999999999999	68.75	69.14999999999999	6326.8
2010-07-13	BWX	ETF	27.475	27.6	27.4	27.575	225514.0
2010-07-13	BWZ	ETF	34.405	34.562	34.38	34.562	7612.0
2010-07-13	BZQ	ETF	3798.4	3817.6	3726.4	3756.8	561.0
2010-07-13	CEF	ETF	14.91	14.95	14.83	14.84	426800.0
2010-07-13	CEW	ETF	21.55	21.66	21.55	21.66	51771.0

> showing 50 of 761 rows — these rows as CSV

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