PREVIEW / etf_daily / 2010-02-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-16.parquet
  size:    31 KB
  rows:    724

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-02-16	SPY	ETF	108.86	109.85	107.82	109.74	159317500.0
2010-02-16	QQQ	ETF	44.08	44.35	43.85	44.32	83861368.0
2010-02-16	IWM	ETF	61.66	62.11	61.08	62.05	50057600.0
2010-02-16	DIA	ETF	102.01	102.97	101.59	102.81	8958800.0
2010-02-16	GLD	ETF	109.45	109.87	109.1	109.62	20895700.0
2010-02-16	TLT	ETF	89.73	90.44	89.73	90.36	2440900.0
2010-02-16	AAXJ	ETF	52.78	53.32	52.51	53.26	98200.0
2010-02-16	ACWI	ETF	40.29	41.02	40.29	41.02	87300.0
2010-02-16	ACWX	ETF	38.74	39.25	38.48	39.2	66072.0
2010-02-16	ADRE	ETF	40.95	41.35	40.8081	41.34	119980.0
2010-02-16	AFK	ETF	29.17	29.38	28.99	29.3	27559.0
2010-02-16	AGG	ETF	104.03	104.33	103.97	104.28	592800.0
2010-02-16	AGQ	ETF	96.78	101.38	96.14	100.24	396800.0
2010-02-16	AGZ	ETF	108.34	108.56	108.25	108.56	14468.0
2010-02-16	AIA	ETF	38.22	38.5	38.01	38.37	61308.0
2010-02-16	AIQ	ETF	25.1	25.1	24.5	24.7	12166.0
2010-02-16	AIS	ETF	1.18	1.2	1.14	1.2	227744.0
2010-02-16	AIVI	ETF	39.87	40.81	39.85	40.77	17000.0
2010-02-16	AMJ	ETF	29.09	30.0	29.0	29.66	425417.0
2010-02-16	AOA	ETF	29.25	29.56	29.16	29.48	17800.0
2010-02-16	AOK	ETF	27.33	27.33	27.152	27.2701	8818.0
2010-02-16	AOM	ETF	27.75	27.95	27.72	27.95	14298.0
2010-02-16	AOR	ETF	28.43	28.5693	28.3019	28.5525	4336.0
2010-02-16	ARB	ETF	24.55	24.96	23.97	24.9	144002.0
2010-02-16	BAB	ETF	24.59	24.71	24.56	24.6916	128134.0
2010-02-16	BAL	ETF	36.3599	36.825	36.0	36.4	5498.0
2010-02-16	BBH	ETF	33.85	34.0333	33.51	33.77	78600.0
2010-02-16	BIL	ETF	91.74	91.74	91.72	91.74	155950.0
2010-02-16	BITS	ETF	32.12	32.2	32.0	32.2	556.0
2010-02-16	BIV	ETF	79.96	80.24	79.93	80.15	167000.0
2010-02-16	BJK	ETF	23.81	23.94	23.61	23.89	5300.0
2010-02-16	BKF	ETF	42.63	42.96	42.2	42.96	265106.0
2010-02-16	BLV	ETF	75.95	76.45	75.85	76.28	20000.0
2010-02-16	BMVP	ETF	12.38	12.5	12.34	12.5	30259.0
2010-02-16	BND	ETF	79.2	79.38	79.16	79.33	1246100.0
2010-02-16	BNE	ETF	6.33	6.81	6.33	6.81	228210.0
2010-02-16	BRF	ETF	45.09	46.11	44.8195	45.55	406232.0
2010-02-16	BSV	ETF	80.2	80.26	80.15	80.25	430700.0
2010-02-16	BTF	ETF	66.1	66.8465	66.054	66.8	5846.0
2010-02-16	BWX	ETF	27.855	28.03	27.7987	28.02	371264.0
2010-02-16	BWZ	ETF	35.52	35.82	35.52	35.8	25351.0
2010-02-16	BZQ	ETF	4294.4	4348.8	4168.0	4227.2	917.5
2010-02-16	CEF	ETF	13.62	13.77	13.5	13.71	1086500.0
2010-02-16	CEW	ETF	21.75	21.83	21.735	21.83	109163.0
2010-02-16	CGO	ETF	13.85	13.9568	13.59	13.85	27325.0
2010-02-16	CGW	ETF	17.31	17.588	17.31	17.55	52886.0
2010-02-16	CHI	ETF	12.15	12.17	12.09	12.12	171004.0
2010-02-16	CHIE	ETF	14.0	14.15	14.0	14.15	1400.0
2010-02-16	CHII	ETF	14.46	14.62	14.4425	14.62	2949.0
2010-02-16	CHIM	ETF	25.2	25.56	25.05	25.5	676.0

> showing 50 of 724 rows — these rows as CSV

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