PREVIEW / etf_daily / 2010-10-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-13.parquet
  size:    34 KB
  rows:    798

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-10-13	SPY	ETF	117.66	118.55	117.38	117.92	194347200.0
2010-10-13	QQQ	ETF	50.4	50.75	50.28	50.52	71122723.0
2010-10-13	IWM	ETF	69.99	71.14	69.77	70.58	58582200.0
2010-10-13	DIA	ETF	110.82	111.64	110.66	111.06	6921600.0
2010-10-13	GLD	ETF	132.73	134.31	132.63	134.07	18398500.0
2010-10-13	TLT	ETF	102.35	103.12	102.04	103.05	8168400.0
2010-10-13	AADR	ETF	29.17	29.17	29.16	29.16	1200.0
2010-10-13	AAXJ	ETF	63.07	63.51	62.99	63.18	894900.0
2010-10-13	ACWI	ETF	44.99	45.23	44.78	45.06	309700.0
2010-10-13	ACWX	ETF	43.04	43.41	43.02	43.22	25770.0
2010-10-13	ADRE	ETF	46.69	47.1683	46.65	47.03	56322.0
2010-10-13	AFK	ETF	33.93	34.2	33.81	34.0276	24072.0
2010-10-13	AGG	ETF	108.7	108.72	108.45	108.64	984200.0
2010-10-13	AGQ	ETF	193.26	200.94	192.46	200.6	304200.0
2010-10-13	AGZ	ETF	111.66	111.73	111.56	111.7	23953.0
2010-10-13	AIA	ETF	43.68	44.0	43.6	43.8066	23186.0
2010-10-13	AIQ	ETF	23.0	23.35	22.55	22.95	20636.0
2010-10-13	AIS	ETF	1.56	1.59	1.54	1.58	237879.0
2010-10-13	AIVI	ETF	44.96	45.35	44.94	45.18	67400.0
2010-10-13	AMJ	ETF	35.02	35.18	34.967	35.14	356735.0
2010-10-13	AMLP	ETF	79.55	79.55	79.1	79.25	161200.0
2010-10-13	AOA	ETF	32.53	32.73	32.48	32.65	6000.0
2010-10-13	AOK	ETF	28.74	28.8	28.72	28.7999	9261.0
2010-10-13	AOM	ETF	29.6	29.69	29.6	29.6596	8199.0
2010-10-13	AOR	ETF	30.64	30.8	30.61	30.74	12997.0
2010-10-13	ARB	ETF	29.7	31.1	29.46	30.81	158999.0
2010-10-13	BAB	ETF	26.53	26.6	26.47	26.59	223518.0
2010-10-13	BAL	ETF	53.73	55.0	53.65	54.8	26202.0
2010-10-13	BALT	ETF	11.1	11.38	11.01	11.33	191900.0
2010-10-13	BBH	ETF	32.5267	32.55	32.3933	32.46	18600.0
2010-10-13	BICK	ETF	32.96	33.49	32.96	33.35	67284.0
2010-10-13	BIL	ETF	91.7	91.72	91.7	91.7	397050.0
2010-10-13	BIS	ETF	9249.6	9257.6	9169.6	9257.6	4.375
2010-10-13	BITS	ETF	27.24	27.4	26.96	27.2	4286.0
2010-10-13	BIV	ETF	87.13	87.43	87.07	87.4	173500.0
2010-10-13	BJK	ETF	30.1	30.26	29.95	30.05	15900.0
2010-10-13	BKF	ETF	50.01	50.6905	50.01	50.54	206927.0
2010-10-13	BLV	ETF	84.7	85.12	84.45	84.97	59600.0
2010-10-13	BMVP	ETF	13.45	13.56	13.42	13.49	10770.0
2010-10-13	BND	ETF	82.75	82.86	82.66	82.85	612500.0
2010-10-13	BNE	ETF	11.37	11.39	11.35	11.39	325674.0
2010-10-13	BOSS	ETF	38.155	38.155	38.155	38.155	300.0
2010-10-13	BRF	ETF	60.88	62.15	60.5005	61.95	599963.0
2010-10-13	BSCE	ETF	21.19	21.19	21.125	21.15	9355.0
2010-10-13	BSV	ETF	81.89	81.93	81.83	81.91	503500.0
2010-10-13	BTF	ETF	76.9	77.94999999999999	76.9	77.8	2840.4
2010-10-13	BWX	ETF	30.685	30.865	30.685	30.745	101848.0
2010-10-13	BWZ	ETF	37.77	37.77	37.5	37.54	32881.0
2010-10-13	BZQ	ETF	2508.8	2508.8	2428.8	2441.6	1768.0
2010-10-13	CEF	ETF	17.4	17.67	17.36	17.67	1044200.0

> showing 50 of 798 rows — these rows as CSV

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