PREVIEW / etf_daily / 2013-03-06

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-06.parquet
  size:    40 KB
  rows:    978

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-03-06	SPY	ETF	154.84	154.92	154.16	154.5	94469900.0
2013-03-06	QQQ	ETF	68.8899	68.908	68.42	68.51	29070971.0
2013-03-06	IWM	ETF	92.47	92.6	92.12	92.43	28483000.0
2013-03-06	DIA	ETF	142.91	143.07	142.49	142.84	4481000.0
2013-03-06	GLD	ETF	152.17	153.38	151.65	153.23	10856000.0
2013-03-06	TLT	ETF	117.11	117.5	116.85	116.86	6514900.0
2013-03-06	AADR	ETF	33.29	33.29	33.22	33.22	300.0
2013-03-06	AAXJ	ETF	60.44	60.44	60.14	60.32	545900.0
2013-03-06	ACTV	ETF	4.55	4.69	4.53	4.61	1040075.0
2013-03-06	ACWI	ETF	50.71	50.71	50.45	50.59	1044000.0
2013-03-06	ACWV	ETF	60.3	60.3	60.02	60.16	17200.0
2013-03-06	ACWX	ETF	43.2	43.2099	42.9001	43.08	291110.0
2013-03-06	ADRE	ETF	39.46	39.74	39.32	39.66	22938.0
2013-03-06	AFK	ETF	30.44	30.44	30.232	30.38	28538.0
2013-03-06	AGEM	ETF	22.96	22.9758	22.894	22.894	600.0
2013-03-06	AGG	ETF	110.4	110.45	110.33	110.37	974300.0
2013-03-06	AGQ	ETF	154.68	159.6	153.36	158.84	328000.0
2013-03-06	AGZ	ETF	113.14	113.26	113.14	113.26	14556.0
2013-03-06	AIA	ETF	47.38	47.44	47.2605	47.36	35528.0
2013-03-06	AIQ	ETF	6.96	7.04	6.88	7.0	6686.0
2013-03-06	AIVI	ETF	42.46	42.47	42.19	42.32	28400.0
2013-03-06	AMJ	ETF	43.32	43.4295	42.45	43.04	3501041.0
2013-03-06	AMLP	ETF	86.1	87.35	84.45	85.2	961620.0
2013-03-06	AOA	ETF	39.41	39.45	39.23	39.33	30300.0
2013-03-06	AOK	ETF	31.1	31.1	31.031	31.058	33510.0
2013-03-06	AOM	ETF	32.64	32.64	32.55	32.59	25346.0
2013-03-06	AOR	ETF	35.41	35.66	35.32	35.66	90234.0
2013-03-06	ARB	ETF	46.85	46.95	46.85	46.92	532941.0
2013-03-06	ARGT	ETF	17.0	17.38	17.0	17.32	1350.0
2013-03-06	ASEA	ETF	17.51	17.51	17.39	17.4	12700.0
2013-03-06	AWAY	ETF	29.89	30.79	29.89	30.59	888118.0
2013-03-06	BAB	ETF	30.48	30.49	30.31	30.35	562880.0
2013-03-06	BAL	ETF	56.16	56.63	56.14	56.4	27031.0
2013-03-06	BALT	ETF	3.97	4.0	3.75	3.87	37743.0
2013-03-06	BBH	ETF	61.59	62.03	61.59	61.86	55700.0
2013-03-06	BIB	ETF	18.265	18.3125	18.0545	18.2225	117788.0
2013-03-06	BICK	ETF	25.19	25.22	25.14	25.21	3523.0
2013-03-06	BIL	ETF	91.6	91.62	91.6	91.6	186800.0
2013-03-06	BIS	ETF	2070.0	2071.6	2060.0	2060.0	55.0
2013-03-06	BIV	ETF	87.67	87.73	87.6	87.6	210700.0
2013-03-06	BIZD	ETF	20.56	20.6	20.55	20.58	16100.0
2013-03-06	BJK	ETF	38.71	38.75	38.58	38.68	4500.0
2013-03-06	BKF	ETF	40.08	40.25	39.95	40.191	197764.0
2013-03-06	BKLN	ETF	25.03	25.03	25.02	25.03	1739000.0
2013-03-06	BLV	ETF	91.75	91.85	91.5	91.61	39400.0
2013-03-06	BMVP	ETF	18.1233	18.1234	18.0533	18.0733	4294.0
2013-03-06	BND	ETF	83.49	83.52	83.41	83.41	919600.0
2013-03-06	BNO	ETF	41.75	41.75	41.52	41.67	50600.0
2013-03-06	BOIL	ETF	792000.0	802000.0	770000.0	777800.0	7.4
2013-03-06	BOND	ETF	109.58	109.58	109.45	109.53	412242.0

> showing 50 of 978 rows — these rows as CSV

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