PREVIEW / etf_daily / 2012-06-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-06.parquet
  size:    38 KB
  rows:    937

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
2012-06-06	SPY	ETF	129.97	132.03	129.93	131.97	184202800.0
2012-06-06	QQQ	ETF	61.6	62.57	61.52	62.52	58781187.0
2012-06-06	IWM	ETF	75.19	76.51	75.03	76.44	48638400.0
2012-06-06	DIA	ETF	121.99	123.99	121.95	123.93	6138400.0
2012-06-06	GLD	ETF	158.9	159.2	156.59	157.21	15771600.0
2012-06-06	TLT	ETF	127.56	127.6	125.05	125.05	20806700.0
2012-06-06	AAXJ	ETF	50.26	51.16	50.26	51.13	270100.0
2012-06-06	ACTV	ETF	14.3	14.77	14.3	14.7	435373.0
2012-06-06	ACWI	ETF	42.19	42.8	42.05	42.79	1238400.0
2012-06-06	ACWV	ETF	52.67	52.98	52.57	52.98	2400.0
2012-06-06	ACWX	ETF	35.58	36.28	35.54	36.27	538007.0
2012-06-06	ADRE	ETF	36.2875	36.76	36.2078	36.75	13528.0
2012-06-06	AFK	ETF	27.11	27.69	27.11	27.53	48775.0
2012-06-06	AGEM	ETF	20.13	20.4	20.13	20.34	3689.0
2012-06-06	AGG	ETF	111.23	111.23	110.78	110.78	1864400.0
2012-06-06	AGQ	ETF	179.36	182.16	174.4	176.04	639600.0
2012-06-06	AGZ	ETF	113.29	113.565	113.29	113.4396	2503.0
2012-06-06	AIA	ETF	39.95	40.53	39.95	40.51	17738.0
2012-06-06	AIQ	ETF	5.05	5.25	5.05	5.1	10883.0
2012-06-06	AIS	ETF	2.98	3.17	2.96	3.15	1787727.0
2012-06-06	AIVI	ETF	36.45	37.14	36.45	37.13	47200.0
2012-06-06	AMJ	ETF	35.84	36.48	35.81	36.37	1734552.0
2012-06-06	AMLP	ETF	77.8	78.55	77.8	78.3	405800.0
2012-06-06	ANGL	ETF	24.72	24.8	24.72	24.79	3000.0
2012-06-06	AOA	ETF	33.77	34.11	33.77	34.07	8800.0
2012-06-06	AOK	ETF	29.52	29.59	29.52	29.56	20412.0
2012-06-06	AOM	ETF	30.19	30.3699	30.19	30.33	21094.0
2012-06-06	AOR	ETF	31.83	31.96	31.79	31.95	11985.0
2012-06-06	ARB	ETF	34.26	34.74	34.17	34.58	122880.0
2012-06-06	ARGT	ETF	15.46	15.98	15.46	15.94	1600.0
2012-06-06	ASEA	ETF	14.78	15.09	14.78	15.09	6600.0
2012-06-06	AWAY	ETF	21.28	22.68	20.77	22.07	484276.0
2012-06-06	BAB	ETF	30.03	30.05	29.7339	29.74	180675.0
2012-06-06	BAL	ETF	42.24	43.58	42.24	43.38	29869.0
2012-06-06	BALT	ETF	3.49	3.52	3.38	3.46	59836.0
2012-06-06	BBH	ETF	44.88	45.37	44.88	45.29	18800.0
2012-06-06	BCM	ETF	41.06	41.06	40.68	40.7476	79522.0
2012-06-06	BIB	ETF	11.8	11.8971	11.8	11.8492	15200.0
2012-06-06	BICK	ETF	21.88	22.11	21.761	22.1	7322.0
2012-06-06	BIL	ETF	91.66	91.66	91.62	91.64	753350.0
2012-06-06	BIS	ETF	3744.0	3744.0	3545.6	3545.6	16.05
2012-06-06	BIV	ETF	88.64	88.64	88.13	88.15	549200.0
2012-06-06	BJK	ETF	31.22	31.83	31.22	31.65	19000.0
2012-06-06	BKF	ETF	34.69	35.37	34.69	35.36	81032.0
2012-06-06	BKLN	ETF	23.83	23.98	23.83	23.96	108200.0
2012-06-06	BLNG	ETF	48.27	48.27	48.27	48.27	300.0
2012-06-06	BLV	ETF	95.19	95.19	94.05	94.12	91300.0
2012-06-06	BMVP	ETF	14.3433	14.3433	14.3433	14.3433	125.0
2012-06-06	BND	ETF	84.32	84.32	84.03	84.08	3526600.0
2012-06-06	BNO	ETF	35.35	35.735	35.33	35.585	69600.0

> showing 50 of 937 rows — these rows as CSV

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