PREVIEW / etf_daily / 2011-12-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-14.parquet
  size:    37 KB
  rows:    897

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-12-14	SPY	ETF	122.56	123.03	121.47	121.74	238618800.0
2011-12-14	QQQ	ETF	55.52	55.59	54.58	54.89	63682706.0
2011-12-14	IWM	ETF	71.25	71.89	70.58	71.04	77704900.0
2011-12-14	DIA	ETF	119.08	119.49	117.91	118.32	10062700.0
2011-12-14	GLD	ETF	156.79	157.34	152.05	152.89	42334400.0
2011-12-14	TLT	ETF	119.79	121.39	119.49	121.36	11247700.0
2011-12-14	AAXJ	ETF	49.39	49.71	49.01	49.16	559000.0
2011-12-14	ACTV	ETF	12.92	13.03	12.67	12.86	364231.0
2011-12-14	ACWI	ETF	41.37	41.56	40.98	41.14	518900.0
2011-12-14	ACWV	ETF	49.89	49.96	49.53	49.63	19800.0
2011-12-14	ACWX	ETF	36.33	36.4	35.97	36.11	301171.0
2011-12-14	ADRE	ETF	38.01	38.06	37.596	37.65	24190.0
2011-12-14	AFK	ETF	25.85	26.11	25.8	25.94	67377.0
2011-12-14	AGEM	ETF	20.58	20.61	20.49	20.58	1816.0
2011-12-14	AGG	ETF	109.79	110.04	109.73	109.91	928500.0
2011-12-14	AGQ	ETF	188.8	193.56	180.8	185.08	1391725.0
2011-12-14	AGZ	ETF	112.36	112.899	112.36	112.69	18653.0
2011-12-14	AIA	ETF	39.23	39.32	38.73	38.91	90838.0
2011-12-14	AIQ	ETF	5.5	5.65	5.4	5.45	8460.0
2011-12-14	AIS	ETF	2.57	2.59	2.35	2.41	4040372.0
2011-12-14	AIVI	ETF	38.68	38.75	38.3	38.47	66700.0
2011-12-14	AMJ	ETF	37.25	37.48	36.841	37.03	1363146.0
2011-12-14	AMLP	ETF	80.85	80.85	80.1	80.3	201960.0
2011-12-14	AOA	ETF	32.21	32.26	32.05	32.1	13000.0
2011-12-14	AOK	ETF	29.13	29.1616	29.102	29.16	25841.0
2011-12-14	AOM	ETF	29.73	29.91	29.6096	29.66	21691.0
2011-12-14	AOR	ETF	30.78	30.78	30.56	30.63	13767.0
2011-12-14	ARB	ETF	36.13	36.13	34.74	34.81	164554.0
2011-12-14	ARGT	ETF	22.24	22.24	22.24	22.24	50.0
2011-12-14	ASEA	ETF	14.31	14.46	14.25	14.28	5600.0
2011-12-14	AWAY	ETF	23.64	24.09	22.59	23.01	436925.0
2011-12-14	BAB	ETF	28.6	28.889	28.5155	28.79	227890.0
2011-12-14	BAL	ETF	53.28	53.53	52.13	52.8	39878.0
2011-12-14	BALT	ETF	4.91	5.08	4.858	5.07	71215.0
2011-12-14	BBH	ETF	34.08	34.4967	33.4767	34.4	164700.0
2011-12-14	BCM	ETF	42.38	42.38	41.65	41.73	5393.0
2011-12-14	BIB	ETF	7.835	7.8525	7.7351	7.805	34800.0
2011-12-14	BICK	ETF	23.21	23.21	22.78	22.8128	14292.0
2011-12-14	BIL	ETF	91.66	91.68	91.66	91.68	1237650.0
2011-12-14	BIS	ETF	5844.8	5862.4	5832.0	5840.064	12.35
2011-12-14	BITS	ETF	21.28	21.6	21.2	21.52	3453.0
2011-12-14	BIV	ETF	87.51	87.76	87.43	87.74	253600.0
2011-12-14	BJK	ETF	29.22	29.41	29.04	29.16	8500.0
2011-12-14	BKF	ETF	36.02	36.13	35.5629	35.58	129223.0
2011-12-14	BKLN	ETF	23.78	23.83	23.72	23.8	81800.0
2011-12-14	BLNG	ETF	48.5	48.5	47.68	47.68	2400.0
2011-12-14	BLV	ETF	91.56	92.25	91.34	92.13	51100.0
2011-12-14	BMVP	ETF	13.24	13.24	13.097	13.137	10363.0
2011-12-14	BND	ETF	83.74	83.9	83.67	83.86	1996800.0
2011-12-14	BNO	ETF	37.06	37.065	35.975	36.12	197600.0

> showing 50 of 897 rows — these rows as CSV

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