PREVIEW / etf_daily / 2010-09-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-23.parquet
  size:    34 KB
  rows:    794

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-23	SPY	ETF	112.49	113.67	112.18	112.5	202354300.0
2010-09-23	QQQ	ETF	48.39	49.16	48.32	48.67	85039930.0
2010-09-23	IWM	ETF	65.15	66.16	64.66	64.88	62724700.0
2010-09-23	DIA	ETF	106.64	107.62	106.41	106.67	7547400.0
2010-09-23	GLD	ETF	126.2	126.66	125.81	126.3	9325200.0
2010-09-23	TLT	ETF	105.41	105.46	104.24	104.91	7412200.0
2010-09-23	AADR	ETF	27.85	27.85	27.59	27.7	4800.0
2010-09-23	AAXJ	ETF	58.81	59.12	58.56	58.66	184100.0
2010-09-23	ACWI	ETF	42.53	42.73	42.25	42.33	83000.0
2010-09-23	ACWX	ETF	40.53	40.75	40.34	40.45	86861.0
2010-09-23	ADRE	ETF	43.23	43.88	43.19	43.46	454677.0
2010-09-23	AFK	ETF	31.66	31.872	31.59	31.6	7312.0
2010-09-23	AGG	ETF	108.66	108.66	108.4	108.54	837200.0
2010-09-23	AGQ	ETF	155.68	159.04	153.92	157.22	155550.0
2010-09-23	AGZ	ETF	111.43	111.462	111.26	111.26	12864.0
2010-09-23	AIA	ETF	41.39	41.63	41.304	41.369	12956.0
2010-09-23	AIQ	ETF	22.4	22.4	21.55	21.55	8743.0
2010-09-23	AIS	ETF	1.36	1.41	1.33	1.41	345815.0
2010-09-23	AIVI	ETF	42.07	42.46	41.95	42.03	5600.0
2010-09-23	AMJ	ETF	33.18	33.2	33.01	33.1	711630.0
2010-09-23	AMLP	ETF	76.25	76.6	76.15	76.3	110000.0
2010-09-23	AOA	ETF	30.97	31.19	30.9	30.94	7500.0
2010-09-23	AOK	ETF	28.33	28.33	28.25	28.25	7461.0
2010-09-23	AOM	ETF	28.9705	29.06	28.9036	28.9399	20884.0
2010-09-23	AOR	ETF	29.73	29.86	29.68	29.69	24009.0
2010-09-23	ARB	ETF	26.54	27.13	26.4	26.56	245813.0
2010-09-23	BAB	ETF	26.75	26.84	26.64	26.75	199029.0
2010-09-23	BAL	ETF	48.18	48.33	47.3601	47.7	104834.0
2010-09-23	BALT	ETF	11.05	11.24	11.0384	11.2	195892.0
2010-09-23	BBH	ETF	32.0167	32.3167	32.0167	32.06	54600.0
2010-09-23	BIB	ETF	6.4212	6.4212	6.32	6.32	4376.0
2010-09-23	BICK	ETF	31.1	31.19	30.85	30.95	16984.0
2010-09-23	BIL	ETF	91.7	91.72	91.7	91.7	209900.0
2010-09-23	BITS	ETF	26.4	27.0	26.24	26.6	16250.0
2010-09-23	BIV	ETF	86.61	86.62	86.28	86.35	105400.0
2010-09-23	BJK	ETF	27.4	27.69	26.99	27.05	13600.0
2010-09-23	BKF	ETF	46.31	46.949	46.0	46.45	99360.0
2010-09-23	BLV	ETF	85.8	85.82	85.08	85.42	18200.0
2010-09-23	BMVP	ETF	12.73	12.86	12.7	12.71	6976.0
2010-09-23	BND	ETF	82.58	82.59	82.4	82.45	684300.0
2010-09-23	BNE	ETF	10.97	10.98	10.84	10.98	850444.0
2010-09-23	BOSS	ETF	32.76	32.76	32.75	32.75	100.0
2010-09-23	BRF	ETF	55.14	55.67	54.8	55.21	456219.0
2010-09-23	BSCE	ETF	20.95	20.95	20.935	20.94	3039.0
2010-09-23	BSV	ETF	81.71	81.71	81.62	81.67	354100.0
2010-09-23	BTF	ETF	74.8	75.25	74.482	74.482	1969.8000000000002
2010-09-23	BWX	ETF	29.31	29.625	29.31	29.625	154158.0
2010-09-23	BWZ	ETF	36.37	36.519	36.34	36.519	9120.0
2010-09-23	BZQ	ETF	3024.0	3040.0	2872.0	2945.6	1066.0
2010-09-23	CEF	ETF	16.36	16.5	16.28	16.48	778200.0

> showing 50 of 794 rows — these rows as CSV

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