PREVIEW / etf_daily / 2011-09-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-01.parquet
  size:    36 KB
  rows:    857

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-09-01	SPY	ETF	122.29	123.4	120.78	120.94	254585900.0
2011-09-01	QQQ	ETF	55.21	55.64	54.46	54.56	57158373.0
2011-09-01	IWM	ETF	72.7	73.63	70.69	71.09	86788800.0
2011-09-01	DIA	ETF	116.09	117.03	114.72	114.87	7690900.0
2011-09-01	GLD	ETF	177.44	178.26	176.55	177.87	13895500.0
2011-09-01	TLT	ETF	107.47	108.98	106.08	108.97	10686600.0
2011-09-01	AADR	ETF	29.65	29.7	29.65	29.7	200.0
2011-09-01	AAXJ	ETF	56.36	56.73	55.75	55.75	154000.0
2011-09-01	ACTV	ETF	16.2	16.43	15.36	15.45	40709.0
2011-09-01	ACWI	ETF	43.78	44.02	43.31	43.38	582600.0
2011-09-01	ACWX	ETF	39.94	40.34	39.71	39.75	241361.0
2011-09-01	ADRE	ETF	42.45	42.73	42.36	42.39	84101.0
2011-09-01	AFK	ETF	29.7	29.92	29.36	29.5	11439.0
2011-09-01	AGEM	ETF	23.79	24.48	23.78	23.85	620.0
2011-09-01	AGG	ETF	109.47	109.69	109.16	109.62	1541600.0
2011-09-01	AGQ	ETF	448.02	456.2	442.22	450.76	371050.0
2011-09-01	AGZ	ETF	112.27	112.39	112.1	112.341	5885.0
2011-09-01	AIA	ETF	42.29	42.61	42.07	42.07	170481.0
2011-09-01	AIQ	ETF	8.0	8.05	7.35	7.35	19867.0
2011-09-01	AIS	ETF	2.47	2.4992	2.35	2.35	551664.0
2011-09-01	AIVI	ETF	42.51	42.8	42.01	42.01	42200.0
2011-09-01	AMJ	ETF	35.63	35.816	35.3	35.35	805885.0
2011-09-01	AMLP	ETF	78.15	78.15	77.35	77.75	84880.0
2011-09-01	AOA	ETF	33.01	33.01	32.65	32.67	4100.0
2011-09-01	AOK	ETF	29.2	29.203	29.1399	29.14	121778.0
2011-09-01	AOM	ETF	29.96	30.66	29.86	29.86	67677.0
2011-09-01	AOR	ETF	31.0983	31.145	30.9	30.94	5301.0
2011-09-01	ARB	ETF	37.42	38.02	35.56	36.13	294532.0
2011-09-01	ARGT	ETF	25.34	25.34	25.08	25.08	300.0
2011-09-01	ASEA	ETF	16.12	16.29	16.04	16.04	3400.0
2011-09-01	AWAY	ETF	42.18	42.27	39.0	41.23	124742.0
2011-09-01	BAB	ETF	27.45	27.69	27.3	27.68	127120.0
2011-09-01	BAL	ETF	66.52	66.52	65.4	65.45	48442.0
2011-09-01	BALT	ETF	5.12	5.33	4.94	5.01	179241.0
2011-09-01	BBH	ETF	33.1133	33.3333	32.7267	32.81	42000.0
2011-09-01	BCM	ETF	48.545	48.6335	48.35	48.35	465.0
2011-09-01	BIB	ETF	7.5362	7.7825	7.285	7.3091	68840.0
2011-09-01	BICK	ETF	27.58	27.9452	27.54	27.59	14177.0
2011-09-01	BIL	ETF	91.7	91.72	91.68	91.72	1048100.0
2011-09-01	BIS	ETF	6910.4	6910.4	6910.4	6910.4	5.0
2011-09-01	BITS	ETF	22.16	22.32	21.36	21.744	16750.0
2011-09-01	BIV	ETF	87.86	88.1	87.15	87.89	224100.0
2011-09-01	BJK	ETF	33.51	33.77	33.09	33.09	17200.0
2011-09-01	BKF	ETF	42.25	42.6	42.04	42.12	120394.0
2011-09-01	BKLN	ETF	23.16	23.35	23.16	23.33	72500.0
2011-09-01	BLV	ETF	86.7	87.78	86.0	87.78	62200.0
2011-09-01	BMVP	ETF	13.7533	13.8367	13.5467	13.5501	3055.0
2011-09-01	BND	ETF	83.32	83.54	83.05	83.54	1902400.0
2011-09-01	BNO	ETF	38.335	38.54	38.15	38.155	166600.0
2011-09-01	BRF	ETF	52.3	53.51	51.81	52.26	482418.0

> showing 50 of 857 rows — these rows as CSV

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