PREVIEW / etf_daily / 2013-01-31

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-31.parquet
  size:    40 KB
  rows:    969

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
2013-01-31	SPY	ETF	149.89	150.38	149.6	149.7	108975800.0
2013-01-31	QQQ	ETF	66.99	67.35	66.81	66.87	34870426.0
2013-01-31	IWM	ETF	88.87	89.68	88.76	89.58	36924200.0
2013-01-31	DIA	ETF	138.76	140.22	138.32	138.41	3935300.0
2013-01-31	GLD	ETF	161.62	161.81	160.47	161.2	9334000.0
2013-01-31	TLT	ETF	117.03	117.34	116.55	117.32	6789200.0
2013-01-31	AADR	ETF	32.98	32.98	32.98	32.98	300.0
2013-01-31	AAXJ	ETF	60.53	60.6	60.4	60.47	2069600.0
2013-01-31	ACTV	ETF	5.48	5.6	5.43	5.53	439926.0
2013-01-31	ACWI	ETF	50.11	50.12	49.89	49.89	858000.0
2013-01-31	ACWV	ETF	58.1	58.11	57.82	58.01	30800.0
2013-01-31	ACWX	ETF	43.27	43.299	43.06	43.06	1032733.0
2013-01-31	ADRE	ETF	40.69	40.9199	40.666	40.8	22815.0
2013-01-31	AFK	ETF	30.85	31.2	30.811	30.811	34271.0
2013-01-31	AGEM	ETF	23.9299	23.9299	23.8799	23.9	1515.0
2013-01-31	AGG	ETF	110.3	110.39	110.26	110.39	1970000.0
2013-01-31	AGQ	ETF	191.84	192.68	183.56	187.84	328300.0
2013-01-31	AGZ	ETF	113.06	113.1	112.85	112.97	34479.0
2013-01-31	AIA	ETF	47.41	47.57	47.4	47.44	32333.0
2013-01-31	AIQ	ETF	6.52	6.59	6.35	6.5	7402.0
2013-01-31	AIVI	ETF	43.24	43.43	43.18	43.21	33400.0
2013-01-31	ALTL	ETF	27.7999	27.7999	27.7999	27.7999	300.0
2013-01-31	AMJ	ETF	42.88	43.269	42.88	43.26	2125358.0
2013-01-31	AMLP	ETF	85.8	86.45	85.7	86.45	649640.0
2013-01-31	ANGL	ETF	27.16	27.16	26.95	26.95	2400.0
2013-01-31	AOA	ETF	38.66	38.77	38.66	38.73	11700.0
2013-01-31	AOK	ETF	30.86	30.9099	30.854	30.87	9795.0
2013-01-31	AOM	ETF	32.29	32.31	32.25	32.28	22474.0
2013-01-31	AOR	ETF	34.9	34.95	34.8401	34.91	22033.0
2013-01-31	ARB	ETF	46.95	47.0	46.9	46.9	201209.0
2013-01-31	ARGT	ETF	18.32	18.74	18.32	18.74	9050.0
2013-01-31	ASEA	ETF	16.93	16.99	16.87	16.92	14000.0
2013-01-31	AWAY	ETF	23.55	24.0	23.51	23.97	457972.0
2013-01-31	BAB	ETF	30.04	30.08	29.9525	30.041	262535.0
2013-01-31	BAL	ETF	54.08	54.51	53.8674	54.35	41180.0
2013-01-31	BALT	ETF	3.3	3.4	3.2	3.23	53354.0
2013-01-31	BBH	ETF	57.41	57.92	57.37	57.68	29800.0
2013-01-31	BIB	ETF	16.045	16.4395	16.045	16.3	32372.0
2013-01-31	BICK	ETF	25.69	25.8	25.69	25.76	5120.0
2013-01-31	BIL	ETF	91.62	91.62	91.6	91.62	168450.0
2013-01-31	BIS	ETF	2343.96	2349.2	2336.0	2336.0	37.5
2013-01-31	BIV	ETF	87.33	87.4	87.21	87.26	304200.0
2013-01-31	BJK	ETF	38.72	38.99	38.72	38.92	15200.0
2013-01-31	BKF	ETF	41.87	42.074	41.8201	41.94	136647.0
2013-01-31	BKLN	ETF	25.17	25.17	25.14	25.14	2120400.0
2013-01-31	BLV	ETF	91.39	91.39	91.03	91.14	59200.0
2013-01-31	BMVP	ETF	17.4	17.52	17.397	17.503	7167.0
2013-01-31	BND	ETF	83.43	83.45	83.33	83.45	1630700.0
2013-01-31	BNO	ETF	42.66	43.085	42.65	43.075	53200.0
2013-01-31	BOIL	ETF	748200.0	785000.0	716600.0	758200.0	25.6

> showing 50 of 969 rows — these rows as CSV

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