PREVIEW / etf_daily / 2011-08-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-16.parquet
  size:    36 KB
  rows:    867

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
2011-08-16	SPY	ETF	119.47	120.69	118.31	119.59	294095200.0
2011-08-16	QQQ	ETF	53.82	54.35	53.18	53.9	89219190.0
2011-08-16	IWM	ETF	70.59	71.41	69.66	70.44	79484300.0
2011-08-16	DIA	ETF	113.94	114.91	112.97	114.08	10846800.0
2011-08-16	GLD	ETF	172.6	174.07	172.5	173.92	19658000.0
2011-08-16	TLT	ETF	104.66	106.64	104.63	106.23	15993200.0
2011-08-16	AADR	ETF	28.86	28.86	28.86	28.86	500.0
2011-08-16	AAXJ	ETF	56.07	56.56	55.64	56.13	265600.0
2011-08-16	ACTV	ETF	16.0	16.55	15.55	16.25	203256.0
2011-08-16	ACWI	ETF	43.13	43.57	42.71	43.04	881900.0
2011-08-16	ACWX	ETF	39.58	40.1	39.37	39.638	97858.0
2011-08-16	ADRE	ETF	41.1	41.45	40.817	41.24	63107.0
2011-08-16	AFK	ETF	29.35	29.36	28.99	29.2	23507.0
2011-08-16	AGEM	ETF	23.15	23.17	22.76	22.79	14873.0
2011-08-16	AGG	ETF	109.29	109.76	109.29	109.64	900100.0
2011-08-16	AGQ	ETF	414.58	427.0	413.44	424.5	507600.0
2011-08-16	AGZ	ETF	112.06	112.57	112.06	112.4282	18280.0
2011-08-16	AIA	ETF	41.35	41.54	40.953	41.25	106858.0
2011-08-16	AIQ	ETF	8.1	8.55	5.9	7.75	92032.0
2011-08-16	AIS	ETF	2.16	2.22	2.13	2.17	711413.0
2011-08-16	AIVI	ETF	41.64	42.25	41.34	41.75	67300.0
2011-08-16	AMJ	ETF	36.32	36.44	35.69	35.99	758208.0
2011-08-16	AMLP	ETF	78.25	78.25	77.4	77.9	89160.0
2011-08-16	AOA	ETF	32.43	32.7	32.21	32.53	9100.0
2011-08-16	AOK	ETF	29.05	29.06	29.018	29.0469	24611.0
2011-08-16	AOM	ETF	29.76	29.8404	29.72	29.79	25946.0
2011-08-16	AOR	ETF	30.7199	30.8636	29.85	30.74	93258.0
2011-08-16	ARB	ETF	34.93	34.97	34.2	34.48	103165.0
2011-08-16	ASEA	ETF	16.28	16.28	16.14	16.22	6000.0
2011-08-16	AWAY	ETF	36.68	37.15	35.5	36.49	49742.0
2011-08-16	BAB	ETF	26.96	27.44	26.96	27.39	475443.0
2011-08-16	BAL	ETF	64.04	64.63	63.72	64.61	43673.0
2011-08-16	BALT	ETF	4.47	4.55	4.42	4.45	98264.0
2011-08-16	BBH	ETF	31.2967	31.74	31.2133	31.6733	33600.0
2011-08-16	BCM	ETF	46.96	46.96	46.96	46.96	721.0
2011-08-16	BIB	ETF	7.0263	7.18	6.9764	7.1338	141096.0
2011-08-16	BICK	ETF	27.24	27.45	27.1604	27.3599	6515.0
2011-08-16	BIL	ETF	91.72	91.72	91.7	91.72	368100.0
2011-08-16	BIS	ETF	7403.2	7403.2	7238.4	7266.56	112.5
2011-08-16	BITS	ETF	20.36	22.48	20.32	21.28	15207.0
2011-08-16	BIV	ETF	87.51	87.89	87.36	87.82	191400.0
2011-08-16	BJK	ETF	33.54	33.59	32.97	33.38	13100.0
2011-08-16	BKF	ETF	41.43	41.7	40.95	41.42	199371.0
2011-08-16	BKLN	ETF	23.21	23.44	23.21	23.32	167500.0
2011-08-16	BLNG	ETF	56.03	56.03	56.03	56.03	200.0
2011-08-16	BLV	ETF	85.71	86.75	85.5	86.53	74600.0
2011-08-16	BMVP	ETF	13.43	13.61	13.36	13.45	11221.0
2011-08-16	BND	ETF	83.3	83.64	83.25	83.58	1283500.0
2011-08-16	BNO	ETF	36.455	36.755	36.3	36.59	251000.0
2011-08-16	BRF	ETF	48.35	48.6	47.77	48.21	128586.0

> showing 50 of 867 rows — these rows as CSV

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