PREVIEW / etf_daily / 2010-11-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-01.parquet
  size:    34 KB
  rows:    800

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-11-01	SPY	ETF	119.07	119.75	117.85	118.53	174074800.0
2010-11-01	QQQ	ETF	52.38	52.75	51.98	52.22	60555560.0
2010-11-01	IWM	ETF	70.66	71.17	69.31	69.82	47357500.0
2010-11-01	DIA	ETF	111.68	112.51	110.67	111.32	9428500.0
2010-11-01	GLD	ETF	132.85	133.07	131.76	131.92	12403600.0
2010-11-01	TLT	ETF	100.8	100.81	99.49	99.67	5921000.0
2010-11-01	AADR	ETF	28.92	28.92	28.92	28.92	500.0
2010-11-01	AAXJ	ETF	62.92	63.37	62.81	62.93	577000.0
2010-11-01	ACWI	ETF	45.08	45.23	44.64	44.89	176600.0
2010-11-01	ACWX	ETF	43.0	43.045	42.5	42.71	47608.0
2010-11-01	ADRE	ETF	46.21	46.76	46.21	46.52	70044.0
2010-11-01	AFK	ETF	33.43	33.43	33.0	33.11	28413.0
2010-11-01	AGG	ETF	108.38	108.49	108.12	108.23	737100.0
2010-11-01	AGQ	ETF	214.24	215.3	207.58	209.48	406950.0
2010-11-01	AGZ	ETF	111.65	111.65	111.38	111.42	13744.0
2010-11-01	AIA	ETF	44.49	44.72	44.26	44.45	31865.0
2010-11-01	AIQ	ETF	19.85	21.41	19.5	21.2	162828.0
2010-11-01	AIS	ETF	1.46	1.48	1.4	1.4	457128.0
2010-11-01	AIVI	ETF	45.43	45.55	44.8	45.17	24900.0
2010-11-01	AMJ	ETF	35.5	35.72	35.42	35.56	938161.0
2010-11-01	AMLP	ETF	79.95	79.95	79.55	79.8	94700.0
2010-11-01	AOA	ETF	32.8	32.91	32.43	32.63	9700.0
2010-11-01	AOK	ETF	28.87	28.87	28.69	28.69	23312.0
2010-11-01	AOM	ETF	29.66	29.699	29.5528	29.61	6860.0
2010-11-01	AOR	ETF	30.82	30.8397	30.72	30.72	12338.0
2010-11-01	ARB	ETF	25.48	26.34	25.48	26.0	415990.0
2010-11-01	BAB	ETF	26.2	26.22	26.03	26.09	103470.0
2010-11-01	BAL	ETF	62.83	63.74	62.79	63.48	47622.0
2010-11-01	BALT	ETF	11.38	11.541	11.28	11.47	111190.0
2010-11-01	BBH	ETF	33.9467	34.3367	33.9467	34.07	24000.0
2010-11-01	BIB	ETF	6.7438	6.7438	6.7412	6.7412	16000.0
2010-11-01	BICK	ETF	33.12	33.14	32.88	32.9	83808.0
2010-11-01	BIL	ETF	91.72	91.72	91.7	91.72	242100.0
2010-11-01	BIS	ETF	9060.0	9110.4	9060.0	9110.4	1.875
2010-11-01	BITS	ETF	27.76	28.0	27.76	28.0	1650.0
2010-11-01	BIV	ETF	86.96	86.96	86.46	86.5	109700.0
2010-11-01	BJK	ETF	31.47	31.68	31.21	31.39	27200.0
2010-11-01	BKF	ETF	49.49	50.07	49.49	49.74	89842.0
2010-11-01	BLV	ETF	84.04	84.04	83.02	83.17	239400.0
2010-11-01	BMVP	ETF	13.83	13.87	13.65	13.73	15589.0
2010-11-01	BND	ETF	82.64	82.68	82.39	82.47	648700.0
2010-11-01	BNE	ETF	11.36	11.36	11.32	11.35	200998.0
2010-11-01	BNO	ETF	28.465	28.465	28.465	28.465	400.0
2010-11-01	BRF	ETF	60.5	60.6799	60.07	60.59	449012.0
2010-11-01	BSCE	ETF	21.09	21.09	21.06	21.06	6293.0
2010-11-01	BSV	ETF	81.83	82.0	81.82	81.82	447500.0
2010-11-01	BTF	ETF	78.64999999999999	78.64999999999999	77.07	77.14999999999999	4948.0
2010-11-01	BWX	ETF	30.735	30.735	30.53	30.57	613242.0
2010-11-01	BWZ	ETF	38.01	38.01	37.65	37.78	30130.0
2010-11-01	BZQ	ETF	2643.2	2644.8	2569.6	2616.0	774.5

> showing 50 of 800 rows — these rows as CSV

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