PREVIEW / etf_daily / 2013-03-27

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-27.parquet
  size:    40 KB
  rows:    980

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-27	SPY	ETF	155.26	156.24	155.0	156.19	99950600.0
2013-03-27	QQQ	ETF	68.25	68.85	68.14	68.801	22539423.0
2013-03-27	IWM	ETF	93.65	94.38	93.24	94.31	28461800.0
2013-03-27	DIA	ETF	144.35	145.09	144.06	144.96	4128900.0
2013-03-27	GLD	ETF	154.67	155.62	154.51	155.36	6717000.0
2013-03-27	TLT	ETF	118.3	118.77	118.18	118.36	7742900.0
2013-03-27	AADR	ETF	32.65	32.68	32.59	32.59	1400.0
2013-03-27	AAXJ	ETF	58.85	59.1	58.64	59.08	569600.0
2013-03-27	ACTV	ETF	4.0	4.13	3.98	4.08	639003.0
2013-03-27	ACWI	ETF	50.31	50.62	50.19	50.58	905100.0
2013-03-27	ACWV	ETF	61.46	61.65	61.32	61.63	363800.0
2013-03-27	ACWX	ETF	42.37	42.69	42.31	42.66	122171.0
2013-03-27	ADRE	ETF	38.14	38.58	38.048	38.55	27776.0
2013-03-27	AFK	ETF	29.99	30.25	29.99	30.2341	16669.0
2013-03-27	AGEM	ETF	22.48	22.5	22.48	22.5	854.0
2013-03-27	AGG	ETF	110.62	110.75	110.57	110.73	1028800.0
2013-03-27	AGQ	ETF	150.72	155.36	148.4	154.4	378750.0
2013-03-27	AGZ	ETF	113.38	113.38	113.3	113.34	10715.0
2013-03-27	AIA	ETF	46.23	46.47	46.151	46.47	9332.0
2013-03-27	AIQ	ETF	7.18	7.29	7.093	7.29	5802.0
2013-03-27	AIVI	ETF	41.84	42.01	41.78	41.93	144900.0
2013-03-27	ALTL	ETF	28.974	28.974	28.974	28.974	406.0
2013-03-27	AMJ	ETF	45.0	45.28	44.84	45.04	1400488.0
2013-03-27	AMLP	ETF	87.65	88.3	87.65	88.1	605360.0
2013-03-27	ANGL	ETF	26.84	27.44	26.84	27.3	2300.0
2013-03-27	AOA	ETF	39.46	39.65	39.41	39.65	47800.0
2013-03-27	AOK	ETF	31.13	31.1799	31.0725	31.1435	15396.0
2013-03-27	AOM	ETF	32.68	32.79	32.6634	32.73	11662.0
2013-03-27	AOR	ETF	35.49	35.61	35.4376	35.61	8682.0
2013-03-27	ARB	ETF	46.84	46.95	46.84	46.87	224987.0
2013-03-27	ARGT	ETF	17.58	17.6	17.54	17.6	3750.0
2013-03-27	ASEA	ETF	17.47	17.65	17.47	17.65	18500.0
2013-03-27	ATMP	ETF	25.82	25.93	25.81	25.92	12600.0
2013-03-27	AVIV	ETF	23.04	23.85	23.02	23.81	530176.0
2013-03-27	AWAY	ETF	33.14	33.29	32.66	33.13	602506.0
2013-03-27	BAB	ETF	30.28	30.36	30.2689	30.32	681181.0
2013-03-27	BAL	ETF	56.51	57.26	56.42	57.16	10641.0
2013-03-27	BALT	ETF	4.01	4.01	3.94	4.0	138076.0
2013-03-27	BBH	ETF	62.75	63.84	62.25	63.84	42100.0
2013-03-27	BCM	ETF	43.44	43.44	43.3335	43.34	2790.0
2013-03-27	BIB	ETF	18.4325	18.975	18.2252	18.975	66000.0
2013-03-27	BICK	ETF	23.99	24.1443	23.94	24.11	4461.0
2013-03-27	BIL	ETF	91.6	91.62	91.6	91.6	262850.0
2013-03-27	BIS	ETF	2036.4	2036.4	2036.4	2036.4	2.5
2013-03-27	BIV	ETF	87.86	88.12	87.86	87.96	187800.0
2013-03-27	BIZD	ETF	20.68	20.68	20.38	20.49	6100.0
2013-03-27	BJK	ETF	39.86	40.03	39.81	40.03	15900.0
2013-03-27	BKF	ETF	38.49	38.84	38.391	38.84	207495.0
2013-03-27	BKLN	ETF	25.1	25.11	25.06	25.07	1852400.0
2013-03-27	BLV	ETF	91.71	92.0	91.7	91.77	46800.0

> showing 50 of 980 rows — these rows as CSV

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